PREVIEW / etf_30min / 2024-04-19

all etf 30-min files

  file:    by_date/etf_30min/2024/2024-04-19.parquet
  size:    793 KB
  rows:    31,936

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
2024-04-19 04:00:00	SPY	ETF	497.0	497.88	494.97	497.62	53399.0
2024-04-19 04:30:00	SPY	ETF	497.65	497.65	496.77	497.19	17023.0
2024-04-19 05:00:00	SPY	ETF	497.11	497.77	497.1	497.71	58335.0
2024-04-19 05:30:00	SPY	ETF	497.86	498.17	497.63	497.63	73829.0
2024-04-19 06:00:00	SPY	ETF	497.63	498.36	497.25	497.5	143276.0
2024-04-19 06:30:00	SPY	ETF	497.56	497.91	497.0	497.77	128089.0
2024-04-19 07:00:00	SPY	ETF	497.78	498.66	497.38	498.49	251722.0
2024-04-19 07:30:00	SPY	ETF	498.55	499.5	498.45	499.15	500825.0
2024-04-19 08:00:00	SPY	ETF	497.73	499.9	495.0	499.8	408027.0
2024-04-19 08:30:00	SPY	ETF	499.81	500.35	499.22	499.45	371639.0
2024-04-19 09:00:00	SPY	ETF	499.34	499.59	498.6	499.43	702251.0
2024-04-19 09:30:00	SPY	ETF	499.44	500.455	498.6899	499.64	5759824.0
2024-04-19 10:00:00	SPY	ETF	499.62	500.14	497.6	498.46	5093400.0
2024-04-19 10:30:00	SPY	ETF	498.45	499.4	497.58	498.54	4582799.0
2024-04-19 11:00:00	SPY	ETF	498.53	498.9592	497.53	497.87	3561137.0
2024-04-19 11:30:00	SPY	ETF	497.86	498.33	496.98	497.11	3365272.0
2024-04-19 12:00:00	SPY	ETF	497.09	497.77	495.19	495.1999	4339888.0
2024-04-19 12:30:00	SPY	ETF	495.22	497.23	495.08	497.1	4307518.0
2024-04-19 13:00:00	SPY	ETF	497.09	497.74	496.45	496.5325	3163990.0
2024-04-19 13:30:00	SPY	ETF	496.55	498.46	496.51	497.3	3474637.0
2024-04-19 14:00:00	SPY	ETF	497.29	497.3399	495.46	495.47	4321385.0
2024-04-19 14:30:00	SPY	ETF	495.46	495.9725	494.02	494.9197	5759934.0
2024-04-19 15:00:00	SPY	ETF	494.91	495.72	494.0999	495.08	4526134.0
2024-04-19 15:30:00	SPY	ETF	495.08	495.52	493.86	495.1	11934833.0
2024-04-19 16:00:00	SPY	ETF	495.09	495.31	494.71	495.25	5009877.0
2024-04-19 16:30:00	SPY	ETF	495.27	495.35	494.93	495.07	390068.0
2024-04-19 17:00:00	SPY	ETF	495.16	495.16	494.81	495.0	64532.0
2024-04-19 17:30:00	SPY	ETF	494.99	495.0	494.75	494.8	41690.0
2024-04-19 18:00:00	SPY	ETF	494.9	494.92	494.8	494.83	41856.0
2024-04-19 18:30:00	SPY	ETF	494.83	494.83	494.6	494.6	27365.0
2024-04-19 19:00:00	SPY	ETF	494.64	494.7	494.6	494.65	7306.0
2024-04-19 19:30:00	SPY	ETF	494.71	494.71	494.51	494.71	23504.0
2024-04-19 04:00:00	QQQ	ETF	420.71	421.48	419.68	420.91	114984.0
2024-04-19 04:30:00	QQQ	ETF	421.01	421.01	419.85	420.19	29292.0
2024-04-19 05:00:00	QQQ	ETF	420.26	420.86	420.24	420.86	87509.0
2024-04-19 05:30:00	QQQ	ETF	420.95	421.47	420.77	420.77	54481.0
2024-04-19 06:00:00	QQQ	ETF	420.84	421.52	420.4	420.66	41367.0
2024-04-19 06:30:00	QQQ	ETF	420.65	421.02	420.27	420.96	51756.0
2024-04-19 07:00:00	QQQ	ETF	421.06	422.1	420.75	421.9	250422.0
2024-04-19 07:30:00	QQQ	ETF	421.91	422.549	421.75	422.461	222624.0
2024-04-19 08:00:00	QQQ	ETF	421.0	423.25	418.27	423.09	477710.0
2024-04-19 08:30:00	QQQ	ETF	423.11	423.727	422.64	422.8	235046.0
2024-04-19 09:00:00	QQQ	ETF	422.74	422.9	421.58	422.13	550923.0
2024-04-19 09:30:00	QQQ	ETF	422.22	422.75	420.65	421.28	5764043.0
2024-04-19 10:00:00	QQQ	ETF	421.27	421.7	418.52	419.3787	4498710.0
2024-04-19 10:30:00	QQQ	ETF	419.36	420.47	418.63	419.68	3850737.0
2024-04-19 11:00:00	QQQ	ETF	419.64	419.67	418.03	418.35	2310302.0
2024-04-19 11:30:00	QQQ	ETF	418.33	418.8	417.28	417.32	2322565.0
2024-04-19 12:00:00	QQQ	ETF	417.31	417.99	415.3	415.34	3393904.0
2024-04-19 12:30:00	QQQ	ETF	415.36	417.22	415.23	417.165	3201160.0

> showing 50 of 31,936 rows — these rows as CSV

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