PREVIEW / etf_30min / 2024-12-17

all etf 30-min files

  file:    by_date/etf_30min/2024/2024-12-17.parquet
  size:    929 KB
  rows:    37,342

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-12-17 04:00:00	SPY	ETF	605.35	605.35	604.8	604.87	29888.0
2024-12-17 04:30:00	SPY	ETF	605.1	605.36	605.01	605.33	7331.0
2024-12-17 05:00:00	SPY	ETF	605.37	605.39	605.0	605.06	2165.0
2024-12-17 05:30:00	SPY	ETF	605.36	605.42	605.24	605.39	1600.0
2024-12-17 06:00:00	SPY	ETF	605.14	605.62	605.14	605.53	4213.0
2024-12-17 06:30:00	SPY	ETF	605.2	605.2	604.85	605.02	26024.0
2024-12-17 07:00:00	SPY	ETF	605.09	605.25	604.8	604.91	65124.0
2024-12-17 07:30:00	SPY	ETF	604.86	605.02	604.66	604.68	72683.0
2024-12-17 08:00:00	SPY	ETF	604.86	606.46	604.02	604.35	174840.0
2024-12-17 08:30:00	SPY	ETF	604.27	604.65	604.06	604.6	106482.0
2024-12-17 09:00:00	SPY	ETF	604.6	604.9	604.17	604.19	179497.0
2024-12-17 09:30:00	SPY	ETF	604.19	604.86	603.6004	604.4	3107034.0
2024-12-17 10:00:00	SPY	ETF	604.38	604.41	603.16	603.22	2034300.0
2024-12-17 10:30:00	SPY	ETF	603.2	603.99	603.165	603.935	1641976.0
2024-12-17 11:00:00	SPY	ETF	603.935	605.11	603.85	604.39	1657800.0
2024-12-17 11:30:00	SPY	ETF	604.36	605.17	604.27	604.94	1088024.0
2024-12-17 12:00:00	SPY	ETF	604.94	604.965	604.26	604.54	954048.0
2024-12-17 12:30:00	SPY	ETF	604.55	604.97	604.33	604.82	972231.0
2024-12-17 13:00:00	SPY	ETF	604.79	604.79	604.02	604.215	769156.0
2024-12-17 13:30:00	SPY	ETF	604.22	604.44	604.065	604.25	883409.0
2024-12-17 14:00:00	SPY	ETF	604.24	604.3	603.61	603.675	1480387.0
2024-12-17 14:30:00	SPY	ETF	603.6798	603.73	603.25	603.41	2128201.0
2024-12-17 15:00:00	SPY	ETF	603.4	603.5	602.885	603.09	1887425.0
2024-12-17 15:30:00	SPY	ETF	603.09	604.74	602.96	604.24	6550458.0
2024-12-17 16:00:00	SPY	ETF	604.22	604.47	603.66	604.36	6864706.0
2024-12-17 16:30:00	SPY	ETF	604.33	604.41	603.9	604.03	272489.0
2024-12-17 17:00:00	SPY	ETF	604.0	604.12	604.0	604.12	4788.0
2024-12-17 17:30:00	SPY	ETF	604.05	604.15	603.92	604.15	13987.0
2024-12-17 18:00:00	SPY	ETF	604.14	604.15	602.87	603.42	32310.0
2024-12-17 18:30:00	SPY	ETF	603.48	603.91	603.48	603.9	6937.0
2024-12-17 19:00:00	SPY	ETF	603.82	604.17	603.82	604.17	11421.0
2024-12-17 19:30:00	SPY	ETF	604.09	604.14	604.01	604.09	10633.0
2024-12-17 04:00:00	QQQ	ETF	537.48	537.48	536.54	536.98	46156.0
2024-12-17 04:30:00	QQQ	ETF	537.01	537.8	537.01	537.68	21995.0
2024-12-17 05:00:00	QQQ	ETF	537.77	537.78	537.42	537.7	25429.0
2024-12-17 05:30:00	QQQ	ETF	537.8	538.2	537.77	538.18	12368.0
2024-12-17 06:00:00	QQQ	ETF	538.1	538.51	537.75	538.34	20123.0
2024-12-17 06:30:00	QQQ	ETF	538.36	538.36	537.37	537.7	34601.0
2024-12-17 07:00:00	QQQ	ETF	537.68	537.9	536.87	537.19	75646.0
2024-12-17 07:30:00	QQQ	ETF	537.18	537.18	536.8	536.8	45460.0
2024-12-17 08:00:00	QQQ	ETF	537.07	538.573	536.2	536.49	203902.0
2024-12-17 08:30:00	QQQ	ETF	536.54	537.04	536.22	536.74	100391.0
2024-12-17 09:00:00	QQQ	ETF	536.76	537.15	536.26	536.38	182170.0
2024-12-17 09:30:00	QQQ	ETF	536.36	537.09	535.04	535.6899	3024847.0
2024-12-17 10:00:00	QQQ	ETF	535.63	535.89	534.13	534.22	1995070.0
2024-12-17 10:30:00	QQQ	ETF	534.21	535.82	534.17	535.65	1174093.0
2024-12-17 11:00:00	QQQ	ETF	535.61	536.78	535.04	536.46	1356504.0
2024-12-17 11:30:00	QQQ	ETF	536.41	537.48	536.22	536.42	1286981.0
2024-12-17 12:00:00	QQQ	ETF	536.43	536.4599	535.38	536.39	1166038.0
2024-12-17 12:30:00	QQQ	ETF	536.4	536.8177	535.99	536.42	720116.0

> showing 50 of 37,342 rows — these rows as CSV

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