PREVIEW / etf_30min / 2023-01-03

all etf 30-min files

  file:    by_date/etf_30min/2023/2023-01-03.parquet
  size:    697 KB
  rows:    28,417

schema

  timestamp    TIMESTAMP
  symbol       VARCHAR
  asset_type   VARCHAR
  open         DOUBLE
  high         DOUBLE
  low          DOUBLE
  close        DOUBLE
  volume       DOUBLE

sample rows

timestamp	symbol	asset_type	open	high	low	close	volume
2023-01-03 04:00:00	SPY	ETF	384.0	386.83	384.0	386.5	97457.0
2023-01-03 04:30:00	SPY	ETF	386.68	386.83	386.41	386.83	38307.0
2023-01-03 05:00:00	SPY	ETF	386.63	386.64	385.73	385.82	49317.0
2023-01-03 05:30:00	SPY	ETF	385.77	386.21	385.62	386.06	61940.0
2023-01-03 06:00:00	SPY	ETF	385.9	386.0	385.38	385.53	17163.0
2023-01-03 06:30:00	SPY	ETF	385.57	385.67	383.52	383.96	96343.0
2023-01-03 07:00:00	SPY	ETF	383.95	384.16	383.34	383.82	170863.0
2023-01-03 07:30:00	SPY	ETF	383.82	384.44	383.82	384.31	197755.0
2023-01-03 08:00:00	SPY	ETF	383.53	386.7204	382.77	384.15	613608.0
2023-01-03 08:30:00	SPY	ETF	384.13	384.88	384.0	384.69	220314.0
2023-01-03 09:00:00	SPY	ETF	384.66	385.28	382.43	384.4	465664.0
2023-01-03 09:30:00	SPY	ETF	384.37	386.43	381.6601	381.71	7391068.0
2023-01-03 10:00:00	SPY	ETF	381.77	382.58	380.145	380.94	4314212.0
2023-01-03 10:30:00	SPY	ETF	380.89	382.095	380.07	382.04	3567632.0
2023-01-03 11:00:00	SPY	ETF	382.0499	382.33	379.48	380.0382	4035712.0
2023-01-03 11:30:00	SPY	ETF	380.04	380.05	378.65	379.07	3691236.0
2023-01-03 12:00:00	SPY	ETF	379.11	379.73	378.43	378.94	2437828.0
2023-01-03 12:30:00	SPY	ETF	378.965	380.02	377.831	378.61	2627038.0
2023-01-03 13:00:00	SPY	ETF	378.63	379.6857	378.34	379.52	1908249.0
2023-01-03 13:30:00	SPY	ETF	379.52	379.99	378.96	379.83	1952491.0
2023-01-03 14:00:00	SPY	ETF	379.84	380.23	378.79	378.99	2382294.0
2023-01-03 14:30:00	SPY	ETF	379.0	380.75	378.09	380.0399	3918352.0
2023-01-03 15:00:00	SPY	ETF	380.02	381.15	379.82	380.36	3521009.0
2023-01-03 15:30:00	SPY	ETF	380.37	381.3	380.29	380.84	7288884.0
2023-01-03 16:00:00	SPY	ETF	380.84	380.93	380.16	380.56	2547911.0
2023-01-03 16:30:00	SPY	ETF	380.61	380.81	380.49	380.69	157949.0
2023-01-03 17:00:00	SPY	ETF	380.61	380.7	380.48	380.56	12661.0
2023-01-03 17:30:00	SPY	ETF	380.56	380.65	380.56	380.61	22840.0
2023-01-03 18:00:00	SPY	ETF	380.58	380.64	380.31	380.6	72644.0
2023-01-03 18:30:00	SPY	ETF	380.52	380.79	380.4	380.79	25533.0
2023-01-03 19:00:00	SPY	ETF	380.79	381.11	380.67	381.1	49947.0
2023-01-03 19:30:00	SPY	ETF	381.09	381.1	380.63	380.77	60403.0
2023-01-03 04:00:00	QQQ	ETF	268.8	269.61	268.0	269.31	72561.0
2023-01-03 04:30:00	QQQ	ETF	269.37	269.79	269.35	269.79	28809.0
2023-01-03 05:00:00	QQQ	ETF	269.82	269.86	268.74	268.94	38064.0
2023-01-03 05:30:00	QQQ	ETF	268.93	269.46	268.83	269.26	27271.0
2023-01-03 06:00:00	QQQ	ETF	269.23	269.35	268.8	268.88	16742.0
2023-01-03 06:30:00	QQQ	ETF	268.91	268.97	267.12	267.66	157669.0
2023-01-03 07:00:00	QQQ	ETF	267.69	268.0	267.09	267.81	121819.0
2023-01-03 07:30:00	QQQ	ETF	267.82	268.36	267.73	268.1	75912.0
2023-01-03 08:00:00	QQQ	ETF	267.775	269.5504	266.65	268.09	435116.0
2023-01-03 08:30:00	QQQ	ETF	268.0	268.82	267.92	268.61	137424.0
2023-01-03 09:00:00	QQQ	ETF	268.58	269.15	268.35	268.67	221763.0
2023-01-03 09:30:00	QQQ	ETF	268.65	270.155	265.59	265.6579	5722608.0
2023-01-03 10:00:00	QQQ	ETF	265.66	266.2	264.02	264.58	2759801.0
2023-01-03 10:30:00	QQQ	ETF	264.56	265.3	263.73	265.21	2066736.0
2023-01-03 11:00:00	QQQ	ETF	265.23	265.498	263.21	263.785	2122322.0
2023-01-03 11:30:00	QQQ	ETF	263.79	263.8	262.44	262.81	1823039.0
2023-01-03 12:00:00	QQQ	ETF	262.8	263.36	262.31	262.8201	1476819.0
2023-01-03 12:30:00	QQQ	ETF	262.85	263.64	262.13	262.75	1403369.0

> showing 50 of 28,417 rows — these rows as CSV

> unlock the full archive -- $79 one-time