PREVIEW / etf_30min / 2024-05-20

all etf 30-min files

  file:    by_date/etf_30min/2024/2024-05-20.parquet
  size:    803 KB
  rows:    32,036

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-05-20 04:00:00	SPY	ETF	529.82	530.16	529.82	530.11	11694.0
2024-05-20 04:30:00	SPY	ETF	530.06	530.1	529.87	530.04	2640.0
2024-05-20 05:00:00	SPY	ETF	529.93	530.05	529.93	529.94	522.0
2024-05-20 05:30:00	SPY	ETF	530.0	530.16	530.0	530.13	1437.0
2024-05-20 06:00:00	SPY	ETF	530.12	530.12	530.07	530.12	972.0
2024-05-20 06:30:00	SPY	ETF	530.08	530.23	530.08	530.23	27098.0
2024-05-20 07:00:00	SPY	ETF	530.23	530.39	529.98	530.341	93390.0
2024-05-20 07:30:00	SPY	ETF	530.38	530.43	530.28	530.31	8457.0
2024-05-20 08:00:00	SPY	ETF	530.2108	530.44	530.08	530.24	60240.0
2024-05-20 08:30:00	SPY	ETF	530.2	530.2	529.64	529.7	122158.0
2024-05-20 09:00:00	SPY	ETF	529.72	529.82	529.59	529.59	88055.0
2024-05-20 09:30:00	SPY	ETF	529.57	531.23	529.47	531.1679	3013086.0
2024-05-20 10:00:00	SPY	ETF	531.19	531.3494	530.7	531.28	1963758.0
2024-05-20 10:30:00	SPY	ETF	531.29	531.48	531.04	531.24	1070476.0
2024-05-20 11:00:00	SPY	ETF	531.23	531.46	530.95	531.39	1048479.0
2024-05-20 11:30:00	SPY	ETF	531.4	531.5601	530.815	531.0013	1295639.0
2024-05-20 12:00:00	SPY	ETF	531.0	531.22	530.635	530.79	1101332.0
2024-05-20 12:30:00	SPY	ETF	530.79	531.23	530.71	531.22	948682.0
2024-05-20 13:00:00	SPY	ETF	531.21	531.28	530.18	530.35	1127594.0
2024-05-20 13:30:00	SPY	ETF	530.35	530.52	530.06	530.2465	1110500.0
2024-05-20 14:00:00	SPY	ETF	530.25	530.3299	529.17	530.185	2114195.0
2024-05-20 14:30:00	SPY	ETF	530.18	530.44	529.89	529.895	1319700.0
2024-05-20 15:00:00	SPY	ETF	529.895	530.405	529.765	530.2614	1693111.0
2024-05-20 15:30:00	SPY	ETF	530.27	530.33	529.5	530.02	5361152.0
2024-05-20 16:00:00	SPY	ETF	530.02	530.29	529.7	529.82	3627097.0
2024-05-20 16:30:00	SPY	ETF	529.83	529.99	529.83	529.96	70463.0
2024-05-20 17:00:00	SPY	ETF	529.93	530.1	529.88	529.96	14845.0
2024-05-20 17:30:00	SPY	ETF	530.0	530.06	529.98	530.02	11806.0
2024-05-20 18:00:00	SPY	ETF	530.0	530.09	529.91	529.91	14474.0
2024-05-20 18:30:00	SPY	ETF	529.92	529.92	529.76	529.83	8703.0
2024-05-20 19:00:00	SPY	ETF	529.8	529.88	529.8	529.87	3971.0
2024-05-20 19:30:00	SPY	ETF	529.83	529.92	529.81	529.9	3287.0
2024-05-20 04:00:00	QQQ	ETF	452.4	452.63	452.4	452.58	22092.0
2024-05-20 04:30:00	QQQ	ETF	452.49	452.5	452.27	452.39	6474.0
2024-05-20 05:00:00	QQQ	ETF	452.39	452.41	452.24	452.4	5542.0
2024-05-20 05:30:00	QQQ	ETF	452.42	452.61	452.42	452.6	4522.0
2024-05-20 06:00:00	QQQ	ETF	452.69	452.69	452.53	452.56	13309.0
2024-05-20 06:30:00	QQQ	ETF	452.51	452.8	452.51	452.8	36340.0
2024-05-20 07:00:00	QQQ	ETF	452.78	452.92	452.61	452.909	21519.0
2024-05-20 07:30:00	QQQ	ETF	452.93	453.07	452.66	452.9	18800.0
2024-05-20 08:00:00	QQQ	ETF	452.8104	453.06	452.098	452.66	45713.0
2024-05-20 08:30:00	QQQ	ETF	452.67	452.67	451.99	452.06	117023.0
2024-05-20 09:00:00	QQQ	ETF	452.11	452.23	451.86	451.89	87827.0
2024-05-20 09:30:00	QQQ	ETF	451.98	454.64	451.785	454.51	3417205.0
2024-05-20 10:00:00	QQQ	ETF	454.52	454.71	454.1086	454.6	1705363.0
2024-05-20 10:30:00	QQQ	ETF	454.6	455.01	454.17	454.365	1101717.0
2024-05-20 11:00:00	QQQ	ETF	454.365	454.64	454.02	454.57	724400.0
2024-05-20 11:30:00	QQQ	ETF	454.6	454.8153	454.1	454.334	625244.0
2024-05-20 12:00:00	QQQ	ETF	454.33	454.7	454.31	454.44	528534.0
2024-05-20 12:30:00	QQQ	ETF	454.42	455.58	454.39	455.51	843644.0

> showing 50 of 32,036 rows — these rows as CSV

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