PREVIEW / etf_1hour / 2003-08-15

all etf 1-hour files

  file:    by_date/etf_1hour/2003/2003-08-15.parquet
  size:    13 KB
  rows:    298

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-15 08:00:00	SPY	ETF	99.48	99.53	99.29	99.37	131300.0
2003-08-15 09:00:00	SPY	ETF	99.36	99.47	99.19	99.31	1624800.0
2003-08-15 10:00:00	SPY	ETF	99.31	99.79	99.122	99.66	2245600.0
2003-08-15 11:00:00	SPY	ETF	99.67	99.705	99.48	99.5	1177800.0
2003-08-15 12:00:00	SPY	ETF	99.48	99.5	99.19	99.26	1162600.0
2003-08-15 13:00:00	SPY	ETF	99.26	99.37	99.184	99.35	894200.0
2003-08-15 14:00:00	SPY	ETF	99.36	99.53	99.3	99.5	1018600.0
2003-08-15 15:00:00	SPY	ETF	99.52	99.58	99.38	99.52	1116500.0
2003-08-15 16:00:00	SPY	ETF	99.52	99.69	99.51	99.6	649800.0
2003-08-15 17:00:00	SPY	ETF	99.6	99.6	99.55	99.6	2600.0
2003-08-15 18:00:00	SPY	ETF	99.55	99.55	99.55	99.55	100.0
2003-08-15 19:00:00	SPY	ETF	99.6	99.6	99.6	99.6	400.0
2003-08-15 08:00:00	QQQ	ETF	31.02	31.06	30.97	30.98	91900.0
2003-08-15 09:00:00	QQQ	ETF	30.99	31.091	30.93	31.08	3504300.0
2003-08-15 10:00:00	QQQ	ETF	31.063	31.29	30.98	31.198	6412200.0
2003-08-15 11:00:00	QQQ	ETF	31.2	31.24	31.11	31.14	3087500.0
2003-08-15 12:00:00	QQQ	ETF	31.14	31.16	30.97	31.03	3096500.0
2003-08-15 13:00:00	QQQ	ETF	31.022	31.109	31.0	31.1	1886900.0
2003-08-15 14:00:00	QQQ	ETF	31.1	31.15	31.05	31.15	1743200.0
2003-08-15 15:00:00	QQQ	ETF	31.14	31.17	31.07	31.146	2517400.0
2003-08-15 16:00:00	QQQ	ETF	31.13	31.2	31.123	31.17	875200.0
2003-08-15 17:00:00	QQQ	ETF	31.17	31.18	31.15	31.16	18900.0
2003-08-15 18:00:00	QQQ	ETF	31.17	31.19	31.16	31.18	13600.0
2003-08-15 19:00:00	QQQ	ETF	31.19	31.2	31.19	31.2	3400.0
2003-08-15 09:00:00	IWM	ETF	47.025	47.19	47.02	47.17	267600.0
2003-08-15 10:00:00	IWM	ETF	47.1	47.335	47.055	47.285	384000.0
2003-08-15 11:00:00	IWM	ETF	47.3	47.3	47.255	47.28	117400.0
2003-08-15 12:00:00	IWM	ETF	47.3	47.3	47.2	47.215	300800.0
2003-08-15 13:00:00	IWM	ETF	47.215	47.215	47.155	47.175	47800.0
2003-08-15 14:00:00	IWM	ETF	47.16	47.23	47.16	47.225	71400.0
2003-08-15 15:00:00	IWM	ETF	47.245	47.265	47.14	47.14	107600.0
2003-08-15 16:00:00	IWM	ETF	47.095	47.17	47.095	47.17	74800.0
2003-08-15 08:00:00	DIA	ETF	93.14	93.14	92.94	93.01	35300.0
2003-08-15 09:00:00	DIA	ETF	93.01	93.3	92.92	93.23	278500.0
2003-08-15 10:00:00	DIA	ETF	93.2	93.52	93.0	93.37	585800.0
2003-08-15 11:00:00	DIA	ETF	93.4	93.4	93.21	93.21	436400.0
2003-08-15 12:00:00	DIA	ETF	93.2	93.23	92.9	92.98	774400.0
2003-08-15 13:00:00	DIA	ETF	92.98	93.09	92.95	93.07	478800.0
2003-08-15 14:00:00	DIA	ETF	93.069	93.25	93.01	93.22	207400.0
2003-08-15 15:00:00	DIA	ETF	93.25	93.31	93.123	93.29	334300.0
2003-08-15 16:00:00	DIA	ETF	93.29	93.4	93.2	93.34	147400.0
2003-08-15 17:00:00	DIA	ETF	93.34	93.35	93.34	93.35	600.0
2003-08-15 18:00:00	DIA	ETF	93.35	93.35	93.35	93.35	900.0
2003-08-15 19:00:00	DIA	ETF	93.3	93.3	93.3	93.3	800.0
2003-08-15 09:00:00	TLT	ETF	82.2	82.2	82.1	82.1	2500.0
2003-08-15 10:00:00	TLT	ETF	82.15	82.5	82.15	82.45	179400.0
2003-08-15 11:00:00	TLT	ETF	82.48	82.5	82.3	82.45	148600.0
2003-08-15 12:00:00	TLT	ETF	82.36	82.5	82.15	82.15	130000.0
2003-08-15 13:00:00	TLT	ETF	82.1	82.1	81.95	82.1	7600.0
2003-08-15 14:00:00	TLT	ETF	82.05	82.05	81.9	81.9	3500.0

> showing 50 of 298 rows — these rows as CSV

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