PREVIEW / etf_30min / 2024-01-16

all etf 30-min files

  file:    by_date/etf_30min/2024/2024-01-16.parquet
  size:    813 KB
  rows:    32,567

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-01-16 04:00:00	SPY	ETF	474.25	474.88	474.0	474.01	14235.0
2024-01-16 04:30:00	SPY	ETF	474.03	474.42	474.0	474.4	4107.0
2024-01-16 05:00:00	SPY	ETF	474.11	474.11	473.84	473.85	4770.0
2024-01-16 05:30:00	SPY	ETF	473.75	474.15	473.69	473.91	3581.0
2024-01-16 06:00:00	SPY	ETF	474.01	474.29	473.93	474.29	3956.0
2024-01-16 06:30:00	SPY	ETF	474.3	474.92	474.19	474.81	17418.0
2024-01-16 07:00:00	SPY	ETF	474.84	474.93	474.46	474.93	146700.0
2024-01-16 07:30:00	SPY	ETF	474.94	475.48	474.751	475.38	71487.0
2024-01-16 08:00:00	SPY	ETF	474.8304	475.45	473.85	474.8	210562.0
2024-01-16 08:30:00	SPY	ETF	474.8	475.55	474.53	474.61	173105.0
2024-01-16 09:00:00	SPY	ETF	474.71	475.31	474.41	475.25	187334.0
2024-01-16 09:30:00	SPY	ETF	475.25	475.61	473.47	474.5	6838108.0
2024-01-16 10:00:00	SPY	ETF	474.49	476.26	474.145	475.92	5913800.0
2024-01-16 10:30:00	SPY	ETF	475.92	476.59	475.59	476.19	4272246.0
2024-01-16 11:00:00	SPY	ETF	476.21	476.6098	474.61	475.8803	6668378.0
2024-01-16 11:30:00	SPY	ETF	475.9	476.44	475.02	475.23	2487291.0
2024-01-16 12:00:00	SPY	ETF	475.23	475.39	474.34	474.41	2759750.0
2024-01-16 12:30:00	SPY	ETF	474.42	474.69	473.92	473.94	2838756.0
2024-01-16 13:00:00	SPY	ETF	473.96	475.21	473.83	475.005	3009035.0
2024-01-16 13:30:00	SPY	ETF	475.01	475.2	473.78	474.0606	2814161.0
2024-01-16 14:00:00	SPY	ETF	474.07	474.21	473.06	473.5901	3315011.0
2024-01-16 14:30:00	SPY	ETF	473.595	474.37	473.36	474.29	3413973.0
2024-01-16 15:00:00	SPY	ETF	474.28	474.52	473.95	474.0399	3898083.0
2024-01-16 15:30:00	SPY	ETF	474.05	475.06	473.775	474.95	10312043.0
2024-01-16 16:00:00	SPY	ETF	474.95	475.13	473.9066	475.0609	2694948.0
2024-01-16 16:30:00	SPY	ETF	475.0701	475.15	474.95	475.03	220201.0
2024-01-16 17:00:00	SPY	ETF	475.03	475.07	474.93	474.99	28962.0
2024-01-16 17:30:00	SPY	ETF	475.05	475.05	474.96	474.99	10684.0
2024-01-16 18:00:00	SPY	ETF	475.03	475.1	474.93	475.05	29109.0
2024-01-16 18:30:00	SPY	ETF	474.93	475.1	474.9	475.1	13072.0
2024-01-16 19:00:00	SPY	ETF	475.08	475.09	474.75	474.85	34525.0
2024-01-16 19:30:00	SPY	ETF	474.8	474.86	474.61	474.75	18967.0
2024-01-16 04:00:00	QQQ	ETF	406.42	407.38	406.42	406.49	53279.0
2024-01-16 04:30:00	QQQ	ETF	406.56	406.99	406.56	406.8	12350.0
2024-01-16 05:00:00	QQQ	ETF	406.6	406.7	406.28	406.35	7896.0
2024-01-16 05:30:00	QQQ	ETF	406.21	406.75	406.15	406.55	19367.0
2024-01-16 06:00:00	QQQ	ETF	406.74	406.93	406.61	406.93	9159.0
2024-01-16 06:30:00	QQQ	ETF	406.92	407.58	406.82	407.39	30600.0
2024-01-16 07:00:00	QQQ	ETF	407.45	407.84	407.26	407.78	73894.0
2024-01-16 07:30:00	QQQ	ETF	407.78	408.3	407.62	408.18	36899.0
2024-01-16 08:00:00	QQQ	ETF	407.36	408.27	406.0	407.59	167760.0
2024-01-16 08:30:00	QQQ	ETF	407.54	408.6	407.46	407.76	224737.0
2024-01-16 09:00:00	QQQ	ETF	407.8	408.31	407.48	408.3	146999.0
2024-01-16 09:30:00	QQQ	ETF	408.31	409.02	406.83	408.25	5817567.0
2024-01-16 10:00:00	QQQ	ETF	408.245	410.38	407.7248	410.11	4052606.0
2024-01-16 10:30:00	QQQ	ETF	410.12	411.12	409.65	410.615	2399627.0
2024-01-16 11:00:00	QQQ	ETF	410.63	410.86	408.77	410.18	4634384.0
2024-01-16 11:30:00	QQQ	ETF	410.21	410.74	408.9	409.11	1970402.0
2024-01-16 12:00:00	QQQ	ETF	409.105	409.37	408.22	408.36	1751640.0
2024-01-16 12:30:00	QQQ	ETF	408.36	408.71	407.77	407.86	1665879.0

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

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