PREVIEW / etf_30min / 2001-06-01

all etf 30-min files

  file:    by_date/etf_30min/2001/2001-06-01.parquet
  size:    14 KB
  rows:    354

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-06-01 09:30:00	SPY	ETF	126.2	126.39	125.71	126.04	1160300.0
2001-06-01 10:00:00	SPY	ETF	126.14	126.25	125.12	125.26	2250700.0
2001-06-01 10:30:00	SPY	ETF	125.34	125.78	125.22	125.7	290500.0
2001-06-01 11:00:00	SPY	ETF	125.71	125.9	125.52	125.85	297400.0
2001-06-01 11:30:00	SPY	ETF	125.8	125.85	125.53	125.7	204700.0
2001-06-01 12:00:00	SPY	ETF	125.75	126.33	125.61	126.19	395300.0
2001-06-01 12:30:00	SPY	ETF	126.27	126.43	126.05	126.14	347500.0
2001-06-01 13:00:00	SPY	ETF	126.14	126.26	125.86	126.08	384700.0
2001-06-01 13:30:00	SPY	ETF	126.05	126.48	126.01	126.22	435600.0
2001-06-01 14:00:00	SPY	ETF	126.24	126.7	126.19	126.67	367000.0
2001-06-01 14:30:00	SPY	ETF	126.7	126.96	126.58	126.95	342200.0
2001-06-01 15:00:00	SPY	ETF	126.99	127.09	126.61	126.65	571100.0
2001-06-01 15:30:00	SPY	ETF	126.73	126.8	126.3	126.64	778000.0
2001-06-01 16:00:00	SPY	ETF	126.64	126.89	126.08	126.87	443300.0
2001-06-01 16:30:00	SPY	ETF	125.91	125.91	125.91	125.91	100.0
2001-06-01 17:00:00	SPY	ETF	126.93	126.93	126.9	126.9	4000.0
2001-06-01 09:30:00	QQQ	ETF	45.54	45.75	45.24	45.46	8213300.0
2001-06-01 10:00:00	QQQ	ETF	45.46	45.8	44.44	44.59	11515300.0
2001-06-01 10:30:00	QQQ	ETF	44.54	45.12	44.44	45.1	4980100.0
2001-06-01 11:00:00	QQQ	ETF	45.1	45.39	44.95	45.23	4040600.0
2001-06-01 11:30:00	QQQ	ETF	45.23	45.24	44.96	45.17	2011300.0
2001-06-01 12:00:00	QQQ	ETF	45.19	45.63	45.06	45.53	2449800.0
2001-06-01 12:30:00	QQQ	ETF	45.52	45.7	45.4	45.49	2724900.0
2001-06-01 13:00:00	QQQ	ETF	45.5	45.6	45.24	45.43	1081400.0
2001-06-01 13:30:00	QQQ	ETF	45.44	45.7	45.36	45.45	2127000.0
2001-06-01 14:00:00	QQQ	ETF	45.45	45.87	45.4	45.85	3134500.0
2001-06-01 14:30:00	QQQ	ETF	45.85	46.1	45.8	46.0	2912200.0
2001-06-01 15:00:00	QQQ	ETF	46.06	46.15	45.58	45.73	5289700.0
2001-06-01 15:30:00	QQQ	ETF	45.7	45.93	45.46	45.92	4034000.0
2001-06-01 16:00:00	QQQ	ETF	45.9	46.3	45.85	46.1	1708500.0
2001-06-01 16:30:00	QQQ	ETF	46.2	46.2	46.09	46.15	20000.0
2001-06-01 17:00:00	QQQ	ETF	46.12	46.13	46.05	46.1	14900.0
2001-06-01 17:30:00	QQQ	ETF	46.1	46.11	46.05	46.11	9600.0
2001-06-01 18:00:00	QQQ	ETF	46.1	46.16	46.05	46.05	5200.0
2001-06-01 09:30:00	IWM	ETF	49.875	49.9	49.55	49.575	66400.0
2001-06-01 10:00:00	IWM	ETF	49.5	49.65	49.325	49.34	50800.0
2001-06-01 10:30:00	IWM	ETF	49.25	49.445	49.25	49.445	17800.0
2001-06-01 11:00:00	IWM	ETF	49.45	49.55	49.375	49.5	52400.0
2001-06-01 11:30:00	IWM	ETF	49.43	49.45	49.43	49.45	3000.0
2001-06-01 12:00:00	IWM	ETF	49.45	49.75	49.45	49.75	20400.0
2001-06-01 12:30:00	IWM	ETF	49.75	49.795	49.73	49.75	19200.0
2001-06-01 13:00:00	IWM	ETF	49.795	49.795	49.71	49.775	37000.0
2001-06-01 13:30:00	IWM	ETF	49.78	49.88	49.72	49.875	46000.0
2001-06-01 14:00:00	IWM	ETF	49.87	49.945	49.85	49.87	16200.0
2001-06-01 14:30:00	IWM	ETF	49.95	50.025	49.935	50.025	23600.0
2001-06-01 15:00:00	IWM	ETF	50.22	50.22	50.075	50.15	27400.0
2001-06-01 15:30:00	IWM	ETF	50.06	50.175	49.85	49.995	24000.0
2001-06-01 16:00:00	IWM	ETF	50.03	50.145	50.03	50.135	6800.0
2001-06-01 09:30:00	DIA	ETF	109.5	109.6	108.8	109.14	327100.0
2001-06-01 10:00:00	DIA	ETF	109.24	109.24	108.4	108.75	278100.0

> showing 50 of 354 rows — these rows as CSV

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