PREVIEW / etf_30min / 2024-01-22

all etf 30-min files

  file:    by_date/etf_30min/2024/2024-01-22.parquet
  size:    810 KB
  rows:    32,227

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-22 04:00:00	SPY	ETF	483.67	483.76	483.0	483.6	24347.0
2024-01-22 04:30:00	SPY	ETF	483.62	483.88	483.59	483.88	9900.0
2024-01-22 05:00:00	SPY	ETF	483.77	483.99	483.66	483.75	16380.0
2024-01-22 05:30:00	SPY	ETF	483.77	483.88	483.67	483.77	5869.0
2024-01-22 06:00:00	SPY	ETF	483.73	483.98	483.73	483.94	4874.0
2024-01-22 06:30:00	SPY	ETF	483.95	484.13	483.81	483.81	23575.0
2024-01-22 07:00:00	SPY	ETF	483.81	484.35	483.62	484.27	240361.0
2024-01-22 07:30:00	SPY	ETF	484.3	484.44	484.15	484.4	102799.0
2024-01-22 08:00:00	SPY	ETF	483.87	484.41	483.37	484.35	164771.0
2024-01-22 08:30:00	SPY	ETF	484.36	484.39	483.79	484.03	332254.0
2024-01-22 09:00:00	SPY	ETF	484.03	484.18	483.74	484.01	355144.0
2024-01-22 09:30:00	SPY	ETF	484.01	485.2	483.9	485.02	7472619.0
2024-01-22 10:00:00	SPY	ETF	485.0199	485.22	484.25	484.37	5232910.0
2024-01-22 10:30:00	SPY	ETF	484.38	484.4	483.21	483.55	5250130.0
2024-01-22 11:00:00	SPY	ETF	483.56	484.13	482.96	484.07	3224764.0
2024-01-22 11:30:00	SPY	ETF	484.06	484.21	483.5	484.07	2426198.0
2024-01-22 12:00:00	SPY	ETF	484.07	484.16	483.19	483.92	2360792.0
2024-01-22 12:30:00	SPY	ETF	483.9212	484.04	483.495	483.75	2006027.0
2024-01-22 13:00:00	SPY	ETF	483.77	483.79	482.78	482.89	2658456.0
2024-01-22 13:30:00	SPY	ETF	482.9	483.98	482.86	483.84	2904897.0
2024-01-22 14:00:00	SPY	ETF	483.845	484.01	483.02	483.61	3092561.0
2024-01-22 14:30:00	SPY	ETF	483.62	483.77	483.27	483.635	2883888.0
2024-01-22 15:00:00	SPY	ETF	483.65	484.2	483.32	484.1001	2946701.0
2024-01-22 15:30:00	SPY	ETF	484.105	484.19	483.37	483.52	8737813.0
2024-01-22 16:00:00	SPY	ETF	483.52	483.6	483.33	483.45	1975276.0
2024-01-22 16:30:00	SPY	ETF	483.45	483.5	483.4	483.45	312842.0
2024-01-22 17:00:00	SPY	ETF	483.41	483.49	483.36	483.3999	10971.0
2024-01-22 17:30:00	SPY	ETF	483.34	483.4	483.34	483.35	9477.0
2024-01-22 18:00:00	SPY	ETF	483.4	483.49	483.261	483.4	17420.0
2024-01-22 18:30:00	SPY	ETF	483.48	483.66	483.48	483.51	4679.0
2024-01-22 19:00:00	SPY	ETF	483.51	483.67	483.45	483.46	6797.0
2024-01-22 19:30:00	SPY	ETF	483.52	483.6	483.46	483.54	6667.0
2024-01-22 04:00:00	QQQ	ETF	423.5	423.76	423.36	423.38	43952.0
2024-01-22 04:30:00	QQQ	ETF	423.42	423.7	423.28	423.63	16830.0
2024-01-22 05:00:00	QQQ	ETF	423.63	423.83	423.41	423.5	20877.0
2024-01-22 05:30:00	QQQ	ETF	423.52	423.66	423.39	423.56	25163.0
2024-01-22 06:00:00	QQQ	ETF	423.57	423.82	423.53	423.73	13370.0
2024-01-22 06:30:00	QQQ	ETF	423.83	424.0	423.54	423.54	43242.0
2024-01-22 07:00:00	QQQ	ETF	423.56	424.49	423.52	424.41	99675.0
2024-01-22 07:30:00	QQQ	ETF	424.47	424.685	424.32	424.45	262162.0
2024-01-22 08:00:00	QQQ	ETF	423.53	424.67	420.865	424.16	241937.0
2024-01-22 08:30:00	QQQ	ETF	424.15	424.15	423.16	423.36	177082.0
2024-01-22 09:00:00	QQQ	ETF	423.39	423.55	423.08	423.43	251812.0
2024-01-22 09:30:00	QQQ	ETF	423.41	424.7275	422.49	423.68	5915125.0
2024-01-22 10:00:00	QQQ	ETF	423.68	423.927	422.3	422.3899	3696388.0
2024-01-22 10:30:00	QQQ	ETF	422.39	422.44	421.19	421.47	3847848.0
2024-01-22 11:00:00	QQQ	ETF	421.49	422.71	421.23	422.54	2229297.0
2024-01-22 11:30:00	QQQ	ETF	422.54	423.01	422.2	422.958	1472565.0
2024-01-22 12:00:00	QQQ	ETF	422.96	423.0	421.75	422.48	1397219.0
2024-01-22 12:30:00	QQQ	ETF	422.48	422.66	421.96	422.28	1002150.0

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

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