Oracle 18c

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

VALUE
1617210000000
0.00325500
0.00326600
0.00325400
0.00326600
780.81000000
1617210299999
2.54374363
210
569.58000000
1.85545803
0

SELECT *
FROM json_table(
--  '[[1617210000000,"0.00325500","0.00326600","0.00325400","0.00326600","780.81000000",1617210299999,"2.54374363",210,"569.58000000","1.85545803","0"]]' ,
  '[[1617423900000,"0.00356800","0.00357100","0.00356400","0.00356800","358.71000000",1617424199999,"1.27964866",90,"313.96000000","1.12008826","0"],[1617424200000,"0.00356800","0.00357000","0.00356600","0.00356800","349.47000000",1617424499999,"1.24704741",105,"283.05000000","1.01005077","0"],[1617424500000,"0.00357000","0.00357900","0.00357000","0.00357400","412.32000000",1617424799999,"1.47359944",127,"53.73000000","0.19203676","0"],[1617424800000,"0.00357500","0.00357500","0.00356500","0.00356600","910.58000000",1617425099999,"3.25045272",198,"463.30000000","1.65400945","0"]]',
  '$[*]'
  COLUMNS (
    idx for ordinality,
    open_time PATH '$[0]',
    open PATH '$[1]',
    high PATH '$[2]',
    low PATH '$[3]',
    close PATH '$[4]',
    volume PATH '$[5]',
    close_time PATH '$[6]',
    quote_av PATH '$[7]',
    number_of_trades PATH '$[8]',
    taker_buy_base_av PATH '$[9]',
    taker_buy_quote_av PATH '$[10]',
    ignore PATH '$[11]'
  )
)

IDX	OPEN_TIME	OPEN	HIGH	LOW	CLOSE	VOLUME	CLOSE_TIME	QUOTE_AV	NUMBER_OF_TRADES	TAKER_BUY_BASE_AV	TAKER_BUY_QUOTE_AV
1	1617423900000	0.00356800	0.00357100	0.00356400	0.00356800	358.71000000	1617424199999	1.27964866	90	313.96000000	1.12008826
2	1617424200000	0.00356800	0.00357000	0.00356600	0.00356800	349.47000000	1617424499999	1.24704741	105	283.05000000	1.01005077
3	1617424500000	0.00357000	0.00357900	0.00357000	0.00357400	412.32000000	1617424799999	1.47359944	127	53.73000000	0.19203676
4	1617424800000	0.00357500	0.00357500	0.00356500	0.00356600	910.58000000	1617425099999	3.25045272	198	463.30000000	1.65400945