PREVIEW / etf_1hour / 2003-08-18

all etf 1-hour files

  file:    by_date/etf_1hour/2003/2003-08-18.parquet
  size:    17 KB
  rows:    422

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-08-18 08:00:00	SPY	ETF	99.79	100.04	99.79	99.98	37700.0
2003-08-18 09:00:00	SPY	ETF	99.97	100.11	99.79	99.94	3517200.0
2003-08-18 10:00:00	SPY	ETF	99.93	100.38	99.74	100.35	4912600.0
2003-08-18 11:00:00	SPY	ETF	100.34	100.43	100.09	100.36	2229200.0
2003-08-18 12:00:00	SPY	ETF	100.36	100.5	100.3	100.34	2056900.0
2003-08-18 13:00:00	SPY	ETF	100.35	100.45	100.28	100.36	895700.0
2003-08-18 14:00:00	SPY	ETF	100.36	100.56	100.34	100.45	2589200.0
2003-08-18 15:00:00	SPY	ETF	100.49	100.6	100.35	100.5	3554200.0
2003-08-18 16:00:00	SPY	ETF	100.52	100.55	100.41	100.44	1374000.0
2003-08-18 17:00:00	SPY	ETF	100.5	100.58	100.5	100.58	5000.0
2003-08-18 18:00:00	SPY	ETF	100.54	100.61	100.52	100.52	16100.0
2003-08-18 19:00:00	SPY	ETF	100.56	100.58	100.49	100.58	54600.0
2003-08-18 08:00:00	QQQ	ETF	31.25	31.35	31.22	31.31	157800.0
2003-08-18 09:00:00	QQQ	ETF	31.31	31.45	31.23	31.37	8749300.0
2003-08-18 10:00:00	QQQ	ETF	31.366	31.564	31.3	31.553	10795300.0
2003-08-18 11:00:00	QQQ	ETF	31.56	31.75	31.52	31.73	10360100.0
2003-08-18 12:00:00	QQQ	ETF	31.73	31.8	31.68	31.71	6372200.0
2003-08-18 13:00:00	QQQ	ETF	31.715	31.77	31.65	31.71	3320800.0
2003-08-18 14:00:00	QQQ	ETF	31.7	31.909	31.68	31.86	8358000.0
2003-08-18 15:00:00	QQQ	ETF	31.86	31.96	31.79	31.94	10151500.0
2003-08-18 16:00:00	QQQ	ETF	31.94	32.04	31.92	32.03	2650200.0
2003-08-18 17:00:00	QQQ	ETF	32.026	32.11	32.026	32.1	446900.0
2003-08-18 18:00:00	QQQ	ETF	32.091	32.099	32.05	32.07	95400.0
2003-08-18 19:00:00	QQQ	ETF	32.04	32.05	32.0	32.05	153800.0
2003-08-18 09:00:00	IWM	ETF	47.33	47.44	47.16	47.415	289200.0
2003-08-18 10:00:00	IWM	ETF	47.43	47.75	47.43	47.735	501200.0
2003-08-18 11:00:00	IWM	ETF	47.745	47.745	47.605	47.73	181600.0
2003-08-18 12:00:00	IWM	ETF	47.71	47.79	47.705	47.745	397400.0
2003-08-18 13:00:00	IWM	ETF	47.75	47.83	47.725	47.8	341600.0
2003-08-18 14:00:00	IWM	ETF	47.8	47.85	47.755	47.815	273400.0
2003-08-18 15:00:00	IWM	ETF	47.815	47.97	47.755	47.955	1084000.0
2003-08-18 16:00:00	IWM	ETF	47.955	48.155	47.955	48.005	123000.0
2003-08-18 08:00:00	DIA	ETF	93.45	93.7	93.45	93.68	8900.0
2003-08-18 09:00:00	DIA	ETF	93.7	93.9	93.57	93.7	938600.0
2003-08-18 10:00:00	DIA	ETF	93.73	94.24	93.54	94.21	1221200.0
2003-08-18 11:00:00	DIA	ETF	94.21	94.24	93.95	94.22	868400.0
2003-08-18 12:00:00	DIA	ETF	94.23	94.39	94.12	94.19	623200.0
2003-08-18 13:00:00	DIA	ETF	94.169	94.27	94.11	94.17	260800.0
2003-08-18 14:00:00	DIA	ETF	94.16	94.347	94.11	94.26	549500.0
2003-08-18 15:00:00	DIA	ETF	94.26	94.35	94.14	94.286	566300.0
2003-08-18 16:00:00	DIA	ETF	94.25	94.33	94.24	94.28	168800.0
2003-08-18 17:00:00	DIA	ETF	94.28	94.33	94.28	94.33	2000.0
2003-08-18 18:00:00	DIA	ETF	94.33	94.33	94.32	94.32	1500.0
2003-08-18 19:00:00	DIA	ETF	94.3	94.5	94.3	94.4	7000.0
2003-08-18 09:00:00	TLT	ETF	82.3	82.49	82.3	82.36	159100.0
2003-08-18 10:00:00	TLT	ETF	82.37	82.6	82.35	82.37	272100.0
2003-08-18 11:00:00	TLT	ETF	82.32	82.56	82.3	82.36	67000.0
2003-08-18 12:00:00	TLT	ETF	82.35	82.38	82.06	82.36	35500.0
2003-08-18 13:00:00	TLT	ETF	82.27	82.36	82.01	82.32	21100.0
2003-08-18 14:00:00	TLT	ETF	82.34	82.45	82.15	82.4	22400.0

> showing 50 of 422 rows — these rows as CSV

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