PREVIEW / etf_30min / 2023-12-22

all etf 30-min files

  file:    by_date/etf_30min/2023/2023-12-22.parquet
  size:    788 KB
  rows:    31,292

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-12-22 04:00:00	SPY	ETF	472.15	472.48	472.13	472.38	3378.0
2023-12-22 04:30:00	SPY	ETF	472.42	472.64	472.4	472.4	4611.0
2023-12-22 05:00:00	SPY	ETF	472.37	472.46	472.3	472.46	2027.0
2023-12-22 05:30:00	SPY	ETF	472.41	472.63	472.26	472.6	25464.0
2023-12-22 06:00:00	SPY	ETF	472.59	472.77	472.44	472.53	58215.0
2023-12-22 06:30:00	SPY	ETF	472.6	472.75	472.57	472.71	72509.0
2023-12-22 07:00:00	SPY	ETF	472.7	472.95	472.69	472.86	40473.0
2023-12-22 07:30:00	SPY	ETF	472.86	472.89	472.6	472.62	39527.0
2023-12-22 08:00:00	SPY	ETF	472.82	473.22	472.0	473.0	134603.0
2023-12-22 08:30:00	SPY	ETF	473.13	474.0	472.22	473.96	574575.0
2023-12-22 09:00:00	SPY	ETF	473.94	474.02	473.77	473.87	279936.0
2023-12-22 09:30:00	SPY	ETF	473.86	475.38	473.77	474.91	5894835.0
2023-12-22 10:00:00	SPY	ETF	474.92	475.27	474.6	475.15	3490631.0
2023-12-22 10:30:00	SPY	ETF	475.15	475.299	474.14	474.15	2901170.0
2023-12-22 11:00:00	SPY	ETF	474.155	474.655	473.58	474.39	3725366.0
2023-12-22 11:30:00	SPY	ETF	474.38	474.6999	473.92	474.065	1989797.0
2023-12-22 12:00:00	SPY	ETF	474.07	474.4495	473.661	474.1	1591047.0
2023-12-22 12:30:00	SPY	ETF	474.11	474.565	473.9	474.55	1611461.0
2023-12-22 13:00:00	SPY	ETF	474.54	474.75	474.39	474.6	1831359.0
2023-12-22 13:30:00	SPY	ETF	474.59	474.7	474.19	474.22	1543214.0
2023-12-22 14:00:00	SPY	ETF	474.22	474.27	471.97	472.08	4423316.0
2023-12-22 14:30:00	SPY	ETF	472.09	473.88	471.7	473.88	4975506.0
2023-12-22 15:00:00	SPY	ETF	473.88	474.03	473.44	473.945	2818942.0
2023-12-22 15:30:00	SPY	ETF	473.94	473.96	472.975	473.62	7547384.0
2023-12-22 16:00:00	SPY	ETF	473.62	473.91	473.01	473.14	3428220.0
2023-12-22 16:30:00	SPY	ETF	473.11	473.11	472.84	473.0	326845.0
2023-12-22 17:00:00	SPY	ETF	472.99	473.06	472.97	473.06	79845.0
2023-12-22 17:30:00	SPY	ETF	473.09	473.2	473.05	473.12	3407.0
2023-12-22 18:00:00	SPY	ETF	473.02	473.1	473.02	473.09	302.0
2023-12-22 18:30:00	SPY	ETF	473.1484	473.2	473.08	473.18	1297.0
2023-12-22 19:00:00	SPY	ETF	473.15	473.15	473.01	473.01	3692.0
2023-12-22 19:30:00	SPY	ETF	473.09	473.18	473.0	473.18	17795.0
2023-12-22 04:00:00	QQQ	ETF	406.66	407.05	406.65	406.92	15337.0
2023-12-22 04:30:00	QQQ	ETF	407.02	407.16	406.98	406.98	5477.0
2023-12-22 05:00:00	QQQ	ETF	406.94	407.13	406.89	407.09	5015.0
2023-12-22 05:30:00	QQQ	ETF	407.08	407.36	407.08	407.36	9502.0
2023-12-22 06:00:00	QQQ	ETF	407.37	407.5	407.33	407.37	13538.0
2023-12-22 06:30:00	QQQ	ETF	407.34	407.5	407.27	407.44	11042.0
2023-12-22 07:00:00	QQQ	ETF	407.47	407.85	407.47	407.8	57755.0
2023-12-22 07:30:00	QQQ	ETF	407.79	407.79	407.57	407.7	52332.0
2023-12-22 08:00:00	QQQ	ETF	407.66	408.21	406.5	408.19	145986.0
2023-12-22 08:30:00	QQQ	ETF	408.2	409.17	407.34	409.03	499232.0
2023-12-22 09:00:00	QQQ	ETF	409.05	409.34	408.9	409.01	178888.0
2023-12-22 09:30:00	QQQ	ETF	409.0	409.97	408.77	409.55	3802277.0
2023-12-22 10:00:00	QQQ	ETF	409.55	409.829	409.07	409.6	1618391.0
2023-12-22 10:30:00	QQQ	ETF	409.61	409.796	408.87	408.88	1426528.0
2023-12-22 11:00:00	QQQ	ETF	408.88	409.19	408.24	408.95	1799259.0
2023-12-22 11:30:00	QQQ	ETF	408.95	409.3	408.55	408.735	984368.0
2023-12-22 12:00:00	QQQ	ETF	408.75	409.14	408.22	408.71	869383.0
2023-12-22 12:30:00	QQQ	ETF	408.74	409.1999	408.525	409.15	721354.0

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

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