PREVIEW / etf_30min / 2002-01-04

all etf 30-min files

  file:    by_date/etf_30min/2002/2002-01-04.parquet
  size:    18 KB
  rows:    473

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
2002-01-04 09:30:00	SPY	ETF	117.17	117.7	117.14	117.62	1700100.0
2002-01-04 10:00:00	SPY	ETF	117.65	117.98	117.37	117.44	3369800.0
2002-01-04 10:30:00	SPY	ETF	117.45	117.47	116.7	117.03	3127200.0
2002-01-04 11:00:00	SPY	ETF	117.01	117.28	117.0	117.12	1282300.0
2002-01-04 11:30:00	SPY	ETF	117.02	117.23	116.86	116.94	1012100.0
2002-01-04 12:00:00	SPY	ETF	116.92	116.92	116.55	116.8	898400.0
2002-01-04 12:30:00	SPY	ETF	116.82	117.11	116.77	117.04	587000.0
2002-01-04 13:00:00	SPY	ETF	117.04	117.15	116.93	117.12	2775300.0
2002-01-04 13:30:00	SPY	ETF	117.1	117.35	116.93	117.35	617000.0
2002-01-04 14:00:00	SPY	ETF	117.35	117.45	117.17	117.33	1034500.0
2002-01-04 14:30:00	SPY	ETF	117.35	117.37	117.0	117.34	708100.0
2002-01-04 15:00:00	SPY	ETF	117.37	117.64	117.26	117.57	1080900.0
2002-01-04 15:30:00	SPY	ETF	117.56	117.7	117.3	117.41	982400.0
2002-01-04 16:00:00	SPY	ETF	117.44	117.72	117.42	117.72	951800.0
2002-01-04 16:30:00	SPY	ETF	117.0	117.0	117.0	117.0	100.0
2002-01-04 17:00:00	SPY	ETF	117.51	117.61	117.43	117.51	600.0
2002-01-04 18:00:00	SPY	ETF	117.51	117.51	117.51	117.51	100.0
2002-01-04 09:30:00	QQQ	ETF	41.95	42.29	41.86	41.95	13898600.0
2002-01-04 10:00:00	QQQ	ETF	41.95	42.15	41.51	41.65	12953100.0
2002-01-04 10:30:00	QQQ	ETF	41.65	41.7	41.2	41.41	11525000.0
2002-01-04 11:00:00	QQQ	ETF	41.42	41.62	41.4	41.45	6317000.0
2002-01-04 11:30:00	QQQ	ETF	41.46	41.55	41.19	41.24	5125100.0
2002-01-04 12:00:00	QQQ	ETF	41.25	41.26	40.93	41.15	3992800.0
2002-01-04 12:30:00	QQQ	ETF	41.14	41.39	41.13	41.34	2826600.0
2002-01-04 13:00:00	QQQ	ETF	41.33	41.47	41.26	41.44	3012700.0
2002-01-04 13:30:00	QQQ	ETF	41.42	41.72	41.31	41.69	4310000.0
2002-01-04 14:00:00	QQQ	ETF	41.72	41.89	41.67	41.8	4644600.0
2002-01-04 14:30:00	QQQ	ETF	41.82	41.84	41.5	41.75	5063100.0
2002-01-04 15:00:00	QQQ	ETF	41.76	41.95	41.7	41.84	4917800.0
2002-01-04 15:30:00	QQQ	ETF	41.83	41.94	41.59	41.65	5916000.0
2002-01-04 16:00:00	QQQ	ETF	41.65	41.74	41.39	41.65	1121600.0
2002-01-04 16:30:00	QQQ	ETF	41.64	41.67	41.6	41.6	35900.0
2002-01-04 17:00:00	QQQ	ETF	41.64	41.71	41.61	41.61	104500.0
2002-01-04 17:30:00	QQQ	ETF	41.61	41.63	41.57	41.6	6400.0
2002-01-04 18:00:00	QQQ	ETF	41.57	41.6	41.55	41.55	8500.0
2002-01-04 09:30:00	IWM	ETF	49.375	49.835	49.375	49.625	108000.0
2002-01-04 10:00:00	IWM	ETF	49.575	49.79	49.45	49.515	36400.0
2002-01-04 10:30:00	IWM	ETF	49.5	49.5	49.165	49.275	14800.0
2002-01-04 11:00:00	IWM	ETF	49.225	49.435	49.225	49.405	242400.0
2002-01-04 11:30:00	IWM	ETF	49.405	49.405	49.25	49.325	66800.0
2002-01-04 12:00:00	IWM	ETF	49.25	49.25	49.15	49.24	86600.0
2002-01-04 12:30:00	IWM	ETF	49.31	49.485	49.3	49.455	77400.0
2002-01-04 13:00:00	IWM	ETF	49.46	49.575	49.45	49.53	86800.0
2002-01-04 13:30:00	IWM	ETF	49.53	49.775	49.5	49.775	88600.0
2002-01-04 14:00:00	IWM	ETF	49.775	49.845	49.7	49.8	89600.0
2002-01-04 14:30:00	IWM	ETF	49.8	49.815	49.67	49.765	304400.0
2002-01-04 15:00:00	IWM	ETF	49.75	49.875	49.735	49.875	16800.0
2002-01-04 15:30:00	IWM	ETF	49.875	49.92	49.6	49.67	80800.0
2002-01-04 16:00:00	IWM	ETF	49.6	49.725	49.6	49.725	5000.0
2002-01-04 09:30:00	DIA	ETF	102.36	102.67	102.02	102.65	445700.0

> showing 50 of 473 rows — these rows as CSV

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