PREVIEW / etf_30min / 2001-10-17

all etf 30-min files

  file:    by_date/etf_30min/2001/2001-10-17.parquet
  size:    17 KB
  rows:    436

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
2001-10-17 09:30:00	SPY	ETF	111.07	111.15	110.64	110.81	2558900.0
2001-10-17 10:00:00	SPY	ETF	110.74	110.84	109.3	109.84	4402400.0
2001-10-17 10:30:00	SPY	ETF	109.89	110.38	109.67	110.33	2089300.0
2001-10-17 11:00:00	SPY	ETF	110.37	110.54	110.04	110.16	632700.0
2001-10-17 11:30:00	SPY	ETF	110.16	110.3	109.37	109.51	2169900.0
2001-10-17 12:00:00	SPY	ETF	109.51	109.84	109.32	109.57	1946500.0
2001-10-17 12:30:00	SPY	ETF	109.6	109.6	108.76	109.08	1780600.0
2001-10-17 13:00:00	SPY	ETF	109.08	109.38	108.65	108.81	2442000.0
2001-10-17 13:30:00	SPY	ETF	108.77	109.06	108.49	109.0	1014600.0
2001-10-17 14:00:00	SPY	ETF	108.99	109.3	108.87	109.05	950200.0
2001-10-17 14:30:00	SPY	ETF	108.97	109.48	108.76	109.25	954900.0
2001-10-17 15:00:00	SPY	ETF	109.25	109.3	108.71	108.96	1351900.0
2001-10-17 15:30:00	SPY	ETF	108.95	109.24	107.9	107.9	3791700.0
2001-10-17 16:00:00	SPY	ETF	107.9	108.4	107.5	108.4	1429700.0
2001-10-17 16:30:00	SPY	ETF	107.7	107.8	107.5	107.8	17300.0
2001-10-17 17:00:00	SPY	ETF	107.71	107.71	107.35	107.39	39900.0
2001-10-17 17:30:00	SPY	ETF	107.45	107.65	107.4	107.65	2200.0
2001-10-17 09:30:00	QQQ	ETF	35.87	35.95	35.3	35.39	17536800.0
2001-10-17 10:00:00	QQQ	ETF	35.38	35.44	34.3	34.8	26933900.0
2001-10-17 10:30:00	QQQ	ETF	34.84	35.08	34.65	34.94	8837100.0
2001-10-17 11:00:00	QQQ	ETF	34.89	35.05	34.66	34.76	4541400.0
2001-10-17 11:30:00	QQQ	ETF	34.75	34.89	34.2	34.38	7080800.0
2001-10-17 12:00:00	QQQ	ETF	34.33	34.47	33.9	33.99	7483900.0
2001-10-17 12:30:00	QQQ	ETF	33.99	34.09	33.66	33.84	6422700.0
2001-10-17 13:00:00	QQQ	ETF	33.84	34.07	33.5	33.6	6102900.0
2001-10-17 13:30:00	QQQ	ETF	33.58	33.83	33.45	33.76	6306600.0
2001-10-17 14:00:00	QQQ	ETF	33.78	34.0	33.66	33.74	6791600.0
2001-10-17 14:30:00	QQQ	ETF	33.74	34.09	33.51	34.0	7071600.0
2001-10-17 15:00:00	QQQ	ETF	34.0	34.02	33.55	33.68	7036000.0
2001-10-17 15:30:00	QQQ	ETF	33.65	33.87	32.76	32.83	18039600.0
2001-10-17 16:00:00	QQQ	ETF	32.79	33.35	32.32	32.65	4191000.0
2001-10-17 16:30:00	QQQ	ETF	32.65	32.72	32.45	32.61	216600.0
2001-10-17 17:00:00	QQQ	ETF	32.6	32.6	32.4	32.45	81200.0
2001-10-17 17:30:00	QQQ	ETF	32.46	32.65	32.45	32.65	192300.0
2001-10-17 18:00:00	QQQ	ETF	32.63	32.68	32.6	32.66	42200.0
2001-10-17 09:30:00	IWM	ETF	43.65	43.725	43.405	43.525	57600.0
2001-10-17 10:00:00	IWM	ETF	43.45	43.45	42.755	42.955	93000.0
2001-10-17 10:30:00	IWM	ETF	42.975	43.065	42.95	43.06	10400.0
2001-10-17 11:00:00	IWM	ETF	43.09	43.135	43.015	43.015	15800.0
2001-10-17 11:30:00	IWM	ETF	43.065	43.095	42.89	42.89	14000.0
2001-10-17 12:00:00	IWM	ETF	42.875	42.88	42.81	42.88	223800.0
2001-10-17 12:30:00	IWM	ETF	42.775	42.775	42.62	42.62	2400.0
2001-10-17 13:00:00	IWM	ETF	42.7	42.74	42.56	42.74	44600.0
2001-10-17 13:30:00	IWM	ETF	42.4	42.615	42.4	42.485	211400.0
2001-10-17 14:00:00	IWM	ETF	42.615	42.69	42.615	42.675	15200.0
2001-10-17 14:30:00	IWM	ETF	42.675	42.75	42.595	42.66	27000.0
2001-10-17 15:00:00	IWM	ETF	42.66	42.67	42.65	42.67	10000.0
2001-10-17 15:30:00	IWM	ETF	42.695	42.8	42.16	42.16	47600.0
2001-10-17 16:00:00	IWM	ETF	42.075	42.075	42.075	42.075	4000.0
2001-10-17 16:30:00	IWM	ETF	42.0	42.0	42.0	42.0	400.0

> showing 50 of 436 rows — these rows as CSV

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