PREVIEW / etf_1hour / 2003-08-26

all etf 1-hour files

  file:    by_date/etf_1hour/2003/2003-08-26.parquet
  size:    17 KB
  rows:    428

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-26 08:00:00	SPY	ETF	99.62	99.8	99.55	99.6	41300.0
2003-08-26 09:00:00	SPY	ETF	99.59	99.774	99.46	99.721	3214700.0
2003-08-26 10:00:00	SPY	ETF	99.7	99.91	98.83	99.12	10805100.0
2003-08-26 11:00:00	SPY	ETF	99.09	99.18	98.97	99.12	2410900.0
2003-08-26 12:00:00	SPY	ETF	99.12	99.2	99.02	99.05	2005800.0
2003-08-26 13:00:00	SPY	ETF	99.03	99.33	98.97	99.25	2543600.0
2003-08-26 14:00:00	SPY	ETF	99.23	99.88	99.21	99.85	6940500.0
2003-08-26 15:00:00	SPY	ETF	99.86	100.39	99.83	100.18	8998700.0
2003-08-26 16:00:00	SPY	ETF	100.19	100.23	99.97	100.13	1511000.0
2003-08-26 17:00:00	SPY	ETF	100.13	100.19	100.13	100.19	50700.0
2003-08-26 18:00:00	SPY	ETF	100.19	100.21	100.19	100.21	5200.0
2003-08-26 19:00:00	SPY	ETF	100.18	100.19	100.11	100.19	7500.0
2003-08-26 08:00:00	QQQ	ETF	32.35	32.5	32.29	32.31	116200.0
2003-08-26 09:00:00	QQQ	ETF	32.31	32.4	32.16	32.22	6815200.0
2003-08-26 10:00:00	QQQ	ETF	32.227	32.311	31.81	31.97	20706100.0
2003-08-26 11:00:00	QQQ	ETF	31.97	32.04	31.9	31.99	6299200.0
2003-08-26 12:00:00	QQQ	ETF	31.98	32.01	31.92	31.94	3504300.0
2003-08-26 13:00:00	QQQ	ETF	31.93	32.04	31.89	31.99	3851300.0
2003-08-26 14:00:00	QQQ	ETF	32.0	32.3	31.977	32.29	10939100.0
2003-08-26 15:00:00	QQQ	ETF	32.29	32.59	32.27	32.51	18056100.0
2003-08-26 16:00:00	QQQ	ETF	32.51	32.56	32.4	32.54	1237200.0
2003-08-26 17:00:00	QQQ	ETF	32.53	32.564	32.52	32.54	111500.0
2003-08-26 18:00:00	QQQ	ETF	32.53	32.57	32.53	32.53	14300.0
2003-08-26 19:00:00	QQQ	ETF	32.54	32.57	32.53	32.57	11200.0
2003-08-26 09:00:00	IWM	ETF	48.16	48.23	48.075	48.1	422000.0
2003-08-26 10:00:00	IWM	ETF	48.105	48.15	47.555	47.71	1510600.0
2003-08-26 11:00:00	IWM	ETF	47.7	47.83	47.65	47.83	520800.0
2003-08-26 12:00:00	IWM	ETF	47.825	47.87	47.795	47.865	233400.0
2003-08-26 13:00:00	IWM	ETF	47.87	47.975	47.825	47.95	328400.0
2003-08-26 14:00:00	IWM	ETF	47.95	48.35	47.945	48.34	532400.0
2003-08-26 15:00:00	IWM	ETF	48.35	48.625	48.35	48.57	1169800.0
2003-08-26 16:00:00	IWM	ETF	48.57	48.62	48.515	48.6	107400.0
2003-08-26 08:00:00	DIA	ETF	93.19	93.45	93.18	93.18	7000.0
2003-08-26 09:00:00	DIA	ETF	93.17	93.33	93.05	93.31	367100.0
2003-08-26 10:00:00	DIA	ETF	93.31	93.46	92.55	92.78	1327200.0
2003-08-26 11:00:00	DIA	ETF	92.77	92.83	92.61	92.74	388700.0
2003-08-26 12:00:00	DIA	ETF	92.74	92.77	92.63	92.7	302100.0
2003-08-26 13:00:00	DIA	ETF	92.68	92.87	92.57	92.77	449400.0
2003-08-26 14:00:00	DIA	ETF	92.74	93.35	92.73	93.35	1277200.0
2003-08-26 15:00:00	DIA	ETF	93.35	93.84	93.35	93.64	893500.0
2003-08-26 16:00:00	DIA	ETF	93.63	93.67	93.5	93.64	70000.0
2003-08-26 17:00:00	DIA	ETF	93.6	93.63	93.55	93.55	1300.0
2003-08-26 18:00:00	DIA	ETF	93.6	93.65	93.6	93.65	200.0
2003-08-26 09:00:00	TLT	ETF	82.45	82.58	82.36	82.45	26300.0
2003-08-26 10:00:00	TLT	ETF	82.36	82.85	82.34	82.85	224500.0
2003-08-26 11:00:00	TLT	ETF	82.91	82.99	82.67	82.91	181600.0
2003-08-26 12:00:00	TLT	ETF	82.96	83.17	82.85	83.17	40700.0
2003-08-26 13:00:00	TLT	ETF	83.15	83.2	83.0	83.1	27700.0
2003-08-26 14:00:00	TLT	ETF	83.11	83.37	83.08	83.29	68600.0
2003-08-26 15:00:00	TLT	ETF	83.2	83.3	83.1	83.27	236600.0

> showing 50 of 428 rows — these rows as CSV

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