PREVIEW / etf_30min / 2022-12-19

all etf 30-min files

  file:    by_date/etf_30min/2022/2022-12-19.parquet
  size:    712 KB
  rows:    27,929

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
2022-12-19 04:00:00	SPY	ETF	383.27	385.25	383.27	384.95	77338.0
2022-12-19 04:30:00	SPY	ETF	385.0	385.02	384.43	384.49	16250.0
2022-12-19 05:00:00	SPY	ETF	384.49	385.39	384.43	385.12	34731.0
2022-12-19 05:30:00	SPY	ETF	385.21	385.39	384.91	384.91	16677.0
2022-12-19 06:00:00	SPY	ETF	384.88	384.94	384.71	384.94	6028.0
2022-12-19 06:30:00	SPY	ETF	384.83	384.86	384.19	384.5	88351.0
2022-12-19 07:00:00	SPY	ETF	384.48	384.7	383.6	384.46	149059.0
2022-12-19 07:30:00	SPY	ETF	384.45	384.8	384.3	384.55	128368.0
2022-12-19 08:00:00	SPY	ETF	384.5	384.92	383.27	383.87	209834.0
2022-12-19 08:30:00	SPY	ETF	383.83	383.87	383.37	383.43	211591.0
2022-12-19 09:00:00	SPY	ETF	383.46	383.87	383.22	383.47	232268.0
2022-12-19 09:30:00	SPY	ETF	383.47	383.82	381.89	382.42	4745147.0
2022-12-19 10:00:00	SPY	ETF	382.43	383.67	381.74	383.5201	3866878.0
2022-12-19 10:30:00	SPY	ETF	383.53	383.53	381.66	381.73	2823220.0
2022-12-19 11:00:00	SPY	ETF	381.74	381.9499	381.175	381.61	2992931.0
2022-12-19 11:30:00	SPY	ETF	381.63	381.64	380.41	380.9799	2957171.0
2022-12-19 12:00:00	SPY	ETF	380.97	381.78	380.95	381.005	1935695.0
2022-12-19 12:30:00	SPY	ETF	381.01	381.7	380.76	381.41	2106674.0
2022-12-19 13:00:00	SPY	ETF	381.41	381.73	380.94	381.0765	1918669.0
2022-12-19 13:30:00	SPY	ETF	381.05	381.19	379.8001	379.9	2942300.0
2022-12-19 14:00:00	SPY	ETF	379.9	379.97	378.655	378.655	5336865.0
2022-12-19 14:30:00	SPY	ETF	378.655	379.55	378.31	378.745	4731676.0
2022-12-19 15:00:00	SPY	ETF	378.73	379.11	378.28	378.805	5099069.0
2022-12-19 15:30:00	SPY	ETF	378.815	380.41	378.553	379.98	9929463.0
2022-12-19 16:00:00	SPY	ETF	379.98	380.12	379.54	379.59	4515847.0
2022-12-19 16:30:00	SPY	ETF	379.59	380.02	379.52	379.75	257060.0
2022-12-19 17:00:00	SPY	ETF	379.76	380.02	379.7	379.75	167543.0
2022-12-19 17:30:00	SPY	ETF	379.7001	379.8	379.7	379.75	39275.0
2022-12-19 18:00:00	SPY	ETF	379.75	380.34	379.75	380.34	128992.0
2022-12-19 18:30:00	SPY	ETF	380.35	380.78	380.32	380.6	30638.0
2022-12-19 19:00:00	SPY	ETF	380.52	380.65	380.42	380.42	16698.0
2022-12-19 19:30:00	SPY	ETF	380.48	381.2	380.36	380.7	48291.0
2022-12-19 04:00:00	QQQ	ETF	274.57	275.5	274.26	274.88	54710.0
2022-12-19 04:30:00	QQQ	ETF	274.83	274.87	274.4	274.4	14839.0
2022-12-19 05:00:00	QQQ	ETF	274.56	275.16	274.43	274.92	22043.0
2022-12-19 05:30:00	QQQ	ETF	274.93	275.2	274.93	275.0	16787.0
2022-12-19 06:00:00	QQQ	ETF	274.95	275.04	274.77	275.0	18303.0
2022-12-19 06:30:00	QQQ	ETF	275.01	275.04	274.4	274.66	40880.0
2022-12-19 07:00:00	QQQ	ETF	274.72	274.86	274.42	274.7	93194.0
2022-12-19 07:30:00	QQQ	ETF	274.63	274.91	274.57	274.69	64479.0
2022-12-19 08:00:00	QQQ	ETF	274.55	274.92	273.76	274.19	158962.0
2022-12-19 08:30:00	QQQ	ETF	274.14	274.22	273.75	273.92	122057.0
2022-12-19 09:00:00	QQQ	ETF	273.93	274.3	273.71	273.82	226614.0
2022-12-19 09:30:00	QQQ	ETF	273.87	273.96	271.42	271.7929	3679458.0
2022-12-19 10:00:00	QQQ	ETF	271.79	272.77	270.86	272.5784	2979559.0
2022-12-19 10:30:00	QQQ	ETF	272.58	272.5999	270.93	270.99	1837135.0
2022-12-19 11:00:00	QQQ	ETF	270.985	271.07	270.43	270.82	1898081.0
2022-12-19 11:30:00	QQQ	ETF	270.81	270.84	269.66	270.3	1830532.0
2022-12-19 12:00:00	QQQ	ETF	270.31	270.94	270.28	270.4	1184903.0
2022-12-19 12:30:00	QQQ	ETF	270.4	271.28	270.28	270.88	1212037.0

> showing 50 of 27,929 rows — these rows as CSV

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