PREVIEW / etf_1hour / 2004-08-18

all etf 1-hour files

  file:    by_date/etf_1hour/2004/2004-08-18.parquet
  size:    25 KB
  rows:    682

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
2004-08-18 08:00:00	SPY	ETF	108.52	108.58	108.45	108.52	49600.0
2004-08-18 09:00:00	SPY	ETF	108.51	108.84	108.45	108.75	5707600.0
2004-08-18 10:00:00	SPY	ETF	108.75	109.52	108.74	109.34	8941600.0
2004-08-18 11:00:00	SPY	ETF	109.3316	109.4	109.1	109.32	4447500.0
2004-08-18 12:00:00	SPY	ETF	109.31	109.4	109.22	109.29	1560800.0
2004-08-18 13:00:00	SPY	ETF	109.28	109.47	109.15	109.38	2804100.0
2004-08-18 14:00:00	SPY	ETF	109.38	109.87	109.38	109.83	6006200.0
2004-08-18 15:00:00	SPY	ETF	109.83	110.13	109.7	110.09	6901900.0
2004-08-18 16:00:00	SPY	ETF	110.09	110.17	109.95	110.03	2496000.0
2004-08-18 17:00:00	SPY	ETF	110.02	110.02	109.95	109.99	30700.0
2004-08-18 18:00:00	SPY	ETF	109.98	110.02	109.98	110.02	41900.0
2004-08-18 19:00:00	SPY	ETF	110.01	110.01	110.01	110.01	500.0
2004-08-18 08:00:00	QQQ	ETF	33.12	33.15	33.1	33.11	129800.0
2004-08-18 09:00:00	QQQ	ETF	33.12	33.22	33.01	33.17	10471300.0
2004-08-18 10:00:00	QQQ	ETF	33.19	33.642	33.15	33.57	23342300.0
2004-08-18 11:00:00	QQQ	ETF	33.579	33.59	33.45	33.54	10461000.0
2004-08-18 12:00:00	QQQ	ETF	33.55	33.62	33.49	33.529	8477800.0
2004-08-18 13:00:00	QQQ	ETF	33.53	33.67	33.449	33.591	11371900.0
2004-08-18 14:00:00	QQQ	ETF	33.591	33.78	33.59	33.75	15916800.0
2004-08-18 15:00:00	QQQ	ETF	33.75	33.9	33.68	33.89	15247100.0
2004-08-18 16:00:00	QQQ	ETF	33.88	33.91	33.79	33.81	4024900.0
2004-08-18 17:00:00	QQQ	ETF	33.83	33.85	33.79	33.84	1559500.0
2004-08-18 18:00:00	QQQ	ETF	33.83	33.85	33.82	33.84	93500.0
2004-08-18 19:00:00	QQQ	ETF	33.84	33.85	33.81	33.81	11500.0
2004-08-18 08:00:00	IWM	ETF	52.595	52.64	52.595	52.64	1400.0
2004-08-18 09:00:00	IWM	ETF	52.595	52.835	52.5	52.835	1254200.0
2004-08-18 10:00:00	IWM	ETF	52.835	53.53	52.835	53.375	3432000.0
2004-08-18 11:00:00	IWM	ETF	53.36	53.48	53.265	53.45	1081400.0
2004-08-18 12:00:00	IWM	ETF	53.435	53.51	53.385	53.4	348400.0
2004-08-18 13:00:00	IWM	ETF	53.41	53.6	53.38	53.59	901800.0
2004-08-18 14:00:00	IWM	ETF	53.595	53.875	53.585	53.815	1894800.0
2004-08-18 15:00:00	IWM	ETF	53.8	54.06	53.775	54.045	2486200.0
2004-08-18 16:00:00	IWM	ETF	54.07	54.075	53.895	53.9	746400.0
2004-08-18 17:00:00	IWM	ETF	53.9	53.95	53.875	53.95	44400.0
2004-08-18 08:00:00	DIA	ETF	99.88	99.9	99.86	99.88	2100.0
2004-08-18 09:00:00	DIA	ETF	99.84	100.06	99.77	99.96	387600.0
2004-08-18 10:00:00	DIA	ETF	99.96	100.57	99.96	100.42	839400.0
2004-08-18 11:00:00	DIA	ETF	100.44	100.48	100.22	100.39	416500.0
2004-08-18 12:00:00	DIA	ETF	100.38	100.48	100.33	100.35	450900.0
2004-08-18 13:00:00	DIA	ETF	100.35	100.54	100.24	100.42	345900.0
2004-08-18 14:00:00	DIA	ETF	100.43	100.9	100.43	100.85	1341600.0
2004-08-18 15:00:00	DIA	ETF	100.84	101.24	100.74	101.23	1137400.0
2004-08-18 16:00:00	DIA	ETF	101.22	101.3	101.18	101.2	88700.0
2004-08-18 18:00:00	DIA	ETF	101.14	101.14	101.14	101.14	100.0
2004-08-18 08:00:00	TLT	ETF	86.96	87.0	86.96	87.0	2300.0
2004-08-18 09:00:00	TLT	ETF	87.05	87.06	86.92	86.92	27000.0
2004-08-18 10:00:00	TLT	ETF	86.9	86.91	86.41	86.5	85500.0
2004-08-18 11:00:00	TLT	ETF	86.54	86.61	86.45	86.58	78200.0
2004-08-18 12:00:00	TLT	ETF	86.55	86.69	86.5	86.66	4300.0
2004-08-18 13:00:00	TLT	ETF	86.68	86.73	86.59	86.64	22200.0

> showing 50 of 682 rows — these rows as CSV

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