PREVIEW / etf_30min / 2024-12-10

all etf 30-min files

  file:    by_date/etf_30min/2024/2024-12-10.parquet
  size:    928 KB
  rows:    36,042

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-10 04:00:00	SPY	ETF	604.5	604.5	604.09	604.18	2120.0
2024-12-10 04:30:00	SPY	ETF	604.18	604.21	604.0	604.14	12819.0
2024-12-10 05:00:00	SPY	ETF	604.4	604.7	604.4	604.7	2568.0
2024-12-10 05:30:00	SPY	ETF	604.76	604.84	604.57	604.82	2488.0
2024-12-10 06:00:00	SPY	ETF	604.8	605.1	604.8	605.09	7239.0
2024-12-10 06:30:00	SPY	ETF	605.2	605.33	605.13	605.13	49468.0
2024-12-10 07:00:00	SPY	ETF	605.18	605.29	605.1	605.25	23259.0
2024-12-10 07:30:00	SPY	ETF	605.25	605.31	605.11	605.25	92136.0
2024-12-10 08:00:00	SPY	ETF	605.13	605.32	604.17	604.87	76958.0
2024-12-10 08:30:00	SPY	ETF	604.89	604.93	604.73	604.79	77893.0
2024-12-10 09:00:00	SPY	ETF	604.87	605.41	604.76	605.38	60759.0
2024-12-10 09:30:00	SPY	ETF	605.37	605.4	604.2737	605.09	2152155.0
2024-12-10 10:00:00	SPY	ETF	605.075	605.51	604.88	605.1198	1311436.0
2024-12-10 10:30:00	SPY	ETF	605.1198	605.8	604.96	605.0083	1041294.0
2024-12-10 11:00:00	SPY	ETF	605.0	605.27	604.58	604.66	1116249.0
2024-12-10 11:30:00	SPY	ETF	604.65	604.71	604.31	604.57	860908.0
2024-12-10 12:00:00	SPY	ETF	604.56	604.78	604.18	604.52	809288.0
2024-12-10 12:30:00	SPY	ETF	604.5	605.02	604.26	604.3101	552590.0
2024-12-10 13:00:00	SPY	ETF	604.32	604.45	604.08	604.35	1038469.0
2024-12-10 13:30:00	SPY	ETF	604.37	604.62	604.04	604.05	588085.0
2024-12-10 14:00:00	SPY	ETF	604.04	604.11	603.58	604.02	1497286.0
2024-12-10 14:30:00	SPY	ETF	604.02	604.04	603.53	603.655	1474453.0
2024-12-10 15:00:00	SPY	ETF	603.65	603.66	602.66	602.7318	2121141.0
2024-12-10 15:30:00	SPY	ETF	602.74	602.92	602.13	602.87	4916691.0
2024-12-10 16:00:00	SPY	ETF	602.87	603.38	602.6371	603.33	2722497.0
2024-12-10 16:30:00	SPY	ETF	603.33	603.44	603.33	603.36	124373.0
2024-12-10 17:00:00	SPY	ETF	603.2975	603.35	603.26	603.33	18999.0
2024-12-10 17:30:00	SPY	ETF	603.33	603.48	603.33	603.35	12520.0
2024-12-10 18:00:00	SPY	ETF	603.4	603.59	603.06	603.14	41652.0
2024-12-10 18:30:00	SPY	ETF	603.2	603.31	603.2	603.26	2281.0
2024-12-10 19:00:00	SPY	ETF	603.26	603.26	603.09	603.11	6204.0
2024-12-10 19:30:00	SPY	ETF	603.1	603.3	603.02	603.16	22930.0
2024-12-10 04:00:00	QQQ	ETF	521.36	521.9	521.36	521.78	14508.0
2024-12-10 04:30:00	QQQ	ETF	521.82	521.96	521.65	521.73	4304.0
2024-12-10 05:00:00	QQQ	ETF	521.91	522.6	521.89	522.6	16195.0
2024-12-10 05:30:00	QQQ	ETF	522.7	522.7	522.47	522.6	9760.0
2024-12-10 06:00:00	QQQ	ETF	522.67	522.9	522.62	522.87	6653.0
2024-12-10 06:30:00	QQQ	ETF	522.94	523.23	522.94	523.04	35692.0
2024-12-10 07:00:00	QQQ	ETF	523.06	523.5	522.96	523.421	28047.0
2024-12-10 07:30:00	QQQ	ETF	523.43	523.67	523.37	523.5	33777.0
2024-12-10 08:00:00	QQQ	ETF	523.07	523.7	521.65	523.19	138705.0
2024-12-10 08:30:00	QQQ	ETF	523.22	523.28	522.74	522.8	51017.0
2024-12-10 09:00:00	QQQ	ETF	522.88	523.65	522.67	523.61	146981.0
2024-12-10 09:30:00	QQQ	ETF	523.62	524.95	522.8	523.97	2213690.0
2024-12-10 10:00:00	QQQ	ETF	523.96	525.38	523.8802	524.3	1068800.0
2024-12-10 10:30:00	QQQ	ETF	524.29	524.66	522.72	522.9349	1117016.0
2024-12-10 11:00:00	QQQ	ETF	522.94	523.1599	522.04	522.12	1089696.0
2024-12-10 11:30:00	QQQ	ETF	522.15	522.45	521.5301	522.36	1188912.0
2024-12-10 12:00:00	QQQ	ETF	522.37	522.58	521.41	522.29	777187.0
2024-12-10 12:30:00	QQQ	ETF	522.25	522.82	521.81	522.04	785673.0

> showing 50 of 36,042 rows — these rows as CSV

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