PREVIEW / etf_1hour / 2003-06-23

all etf 1-hour files

  file:    by_date/etf_1hour/2003/2003-06-23.parquet
  size:    17 KB
  rows:    421

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
2003-06-23 08:00:00	SPY	ETF	99.45	99.49	99.4	99.43	12200.0
2003-06-23 09:00:00	SPY	ETF	99.41	99.64	99.03	99.21	4274200.0
2003-06-23 10:00:00	SPY	ETF	99.21	99.24	98.36	98.56	8303100.0
2003-06-23 11:00:00	SPY	ETF	98.54	98.6	98.19	98.25	3333600.0
2003-06-23 12:00:00	SPY	ETF	98.26	98.4	98.13	98.21	2611500.0
2003-06-23 13:00:00	SPY	ETF	98.2	98.4	98.12	98.33	1922200.0
2003-06-23 14:00:00	SPY	ETF	98.32	98.42	98.0	98.022	3210100.0
2003-06-23 15:00:00	SPY	ETF	98.03	98.46	97.92	98.36	5437600.0
2003-06-23 16:00:00	SPY	ETF	98.37	98.69	98.34	98.52	937100.0
2003-06-23 17:00:00	SPY	ETF	98.54	98.54	98.49	98.5	31200.0
2003-06-23 18:00:00	SPY	ETF	98.5	98.53	98.46	98.53	54200.0
2003-06-23 19:00:00	SPY	ETF	98.47	98.47	98.25	98.35	20200.0
2003-06-23 08:00:00	QQQ	ETF	30.31	30.36	30.28	30.31	45800.0
2003-06-23 09:00:00	QQQ	ETF	30.3	30.371	30.15	30.28	10432900.0
2003-06-23 10:00:00	QQQ	ETF	30.28	30.28	29.77	29.91	20933300.0
2003-06-23 11:00:00	QQQ	ETF	29.92	29.923	29.67	29.697	10143600.0
2003-06-23 12:00:00	QQQ	ETF	29.695	29.79	29.61	29.691	8195900.0
2003-06-23 13:00:00	QQQ	ETF	29.68	29.782	29.66	29.738	5544600.0
2003-06-23 14:00:00	QQQ	ETF	29.74	29.77	29.58	29.59	6783000.0
2003-06-23 15:00:00	QQQ	ETF	29.59	29.84	29.56	29.77	11461000.0
2003-06-23 16:00:00	QQQ	ETF	29.77	30.4119	29.75	29.9	4467300.0
2003-06-23 17:00:00	QQQ	ETF	29.89	29.92	29.88	29.92	38600.0
2003-06-23 18:00:00	QQQ	ETF	29.902	29.92	29.87	29.89	76500.0
2003-06-23 19:00:00	QQQ	ETF	29.88	29.88	29.78	29.81	51900.0
2003-06-23 09:00:00	IWM	ETF	44.675	44.85	44.45	44.49	432000.0
2003-06-23 10:00:00	IWM	ETF	44.49	44.49	43.875	43.98	1095600.0
2003-06-23 11:00:00	IWM	ETF	44.005	44.005	43.825	43.92	409600.0
2003-06-23 12:00:00	IWM	ETF	43.92	43.945	43.86	43.92	304800.0
2003-06-23 13:00:00	IWM	ETF	43.9	43.95	43.89	43.93	132600.0
2003-06-23 14:00:00	IWM	ETF	43.925	43.945	43.725	43.735	429000.0
2003-06-23 15:00:00	IWM	ETF	43.735	43.91	43.695	43.79	582000.0
2003-06-23 16:00:00	IWM	ETF	43.785	43.86	43.765	43.79	219400.0
2003-06-23 08:00:00	DIA	ETF	91.81	91.87	91.75	91.75	3500.0
2003-06-23 09:00:00	DIA	ETF	91.8	91.89	91.42	91.65	1000400.0
2003-06-23 10:00:00	DIA	ETF	91.593	91.65	90.77	90.94	2548500.0
2003-06-23 11:00:00	DIA	ETF	90.95	90.98	90.59	90.62	2526600.0
2003-06-23 12:00:00	DIA	ETF	90.6	90.84	90.51	90.76	885800.0
2003-06-23 13:00:00	DIA	ETF	90.75	90.9	90.65	90.82	556600.0
2003-06-23 14:00:00	DIA	ETF	90.81	90.89	90.51	90.52	781500.0
2003-06-23 15:00:00	DIA	ETF	90.51	90.94	90.49	90.83	880100.0
2003-06-23 16:00:00	DIA	ETF	90.86	90.94	90.82	90.91	443100.0
2003-06-23 17:00:00	DIA	ETF	90.86	90.87	90.85	90.87	1300.0
2003-06-23 18:00:00	DIA	ETF	90.91	90.91	90.91	90.91	300.0
2003-06-23 09:00:00	TLT	ETF	93.819	93.819	93.57	93.57	41600.0
2003-06-23 10:00:00	TLT	ETF	93.57	93.78	93.53	93.78	108000.0
2003-06-23 11:00:00	TLT	ETF	93.7	93.9	93.66	93.9	58200.0
2003-06-23 12:00:00	TLT	ETF	93.89	93.89	93.79	93.89	31000.0
2003-06-23 13:00:00	TLT	ETF	93.9	94.21	93.9	94.18	224400.0
2003-06-23 14:00:00	TLT	ETF	94.2	94.29	94.06	94.29	155400.0
2003-06-23 15:00:00	TLT	ETF	94.29	94.43	94.19	94.29	116400.0

> showing 50 of 421 rows — these rows as CSV

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