PREVIEW / etf_1hour / 2004-08-03

all etf 1-hour files

  file:    by_date/etf_1hour/2004/2004-08-03.parquet
  size:    25 KB
  rows:    677

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-03 08:00:00	SPY	ETF	110.92	111.03	110.91	110.92	51600.0
2004-08-03 09:00:00	SPY	ETF	110.94	111.04	110.86	110.9	4394900.0
2004-08-03 10:00:00	SPY	ETF	110.91	110.95	110.56	110.84	6129700.0
2004-08-03 11:00:00	SPY	ETF	110.84	111.06	110.73	110.9	3768900.0
2004-08-03 12:00:00	SPY	ETF	110.9	111.03	110.72	110.77	2660300.0
2004-08-03 13:00:00	SPY	ETF	110.76	110.9	110.62	110.84	3850400.0
2004-08-03 14:00:00	SPY	ETF	110.84	110.86	110.35	110.47	8875900.0
2004-08-03 15:00:00	SPY	ETF	110.46	110.63	110.32	110.35	6473400.0
2004-08-03 16:00:00	SPY	ETF	110.38	110.4	110.16	110.17	3619700.0
2004-08-03 17:00:00	SPY	ETF	110.17	110.5505	110.11	110.13	101700.0
2004-08-03 18:00:00	SPY	ETF	110.16	110.19	110.14	110.19	19700.0
2004-08-03 19:00:00	SPY	ETF	110.17	110.17	110.16	110.16	5800.0
2004-08-03 08:00:00	QQQ	ETF	34.88	34.91	34.85	34.85	131900.0
2004-08-03 09:00:00	QQQ	ETF	34.88	34.921	34.76	34.81	9219600.0
2004-08-03 10:00:00	QQQ	ETF	34.81	34.82	34.57	34.717	13785600.0
2004-08-03 11:00:00	QQQ	ETF	34.717	34.76	34.64	34.67	7705600.0
2004-08-03 12:00:00	QQQ	ETF	34.667	34.702	34.55	34.58	8516100.0
2004-08-03 13:00:00	QQQ	ETF	34.58	34.61	34.47	34.56	9219500.0
2004-08-03 14:00:00	QQQ	ETF	34.55	34.56	34.31	34.365	15565000.0
2004-08-03 15:00:00	QQQ	ETF	34.365	34.45	34.27	34.29	15983200.0
2004-08-03 16:00:00	QQQ	ETF	34.29	34.3	34.15	34.17	3890300.0
2004-08-03 17:00:00	QQQ	ETF	34.17	34.19	34.13	34.15	210700.0
2004-08-03 18:00:00	QQQ	ETF	34.14	34.18	34.14	34.16	39700.0
2004-08-03 19:00:00	QQQ	ETF	34.15	34.17	34.15	34.17	26400.0
2004-08-03 09:00:00	IWM	ETF	54.715	54.775	54.575	54.67	1019200.0
2004-08-03 10:00:00	IWM	ETF	54.725	54.77	54.285	54.485	2288200.0
2004-08-03 11:00:00	IWM	ETF	54.505	54.66	54.455	54.64	1286200.0
2004-08-03 12:00:00	IWM	ETF	54.62	54.65	54.48	54.545	1168800.0
2004-08-03 13:00:00	IWM	ETF	54.535	54.67	54.47	54.59	1523800.0
2004-08-03 14:00:00	IWM	ETF	54.58	54.585	54.215	54.295	2657600.0
2004-08-03 15:00:00	IWM	ETF	54.285	54.445	54.125	54.14	2709800.0
2004-08-03 16:00:00	IWM	ETF	54.125	54.225	53.985	54.015	877400.0
2004-08-03 17:00:00	IWM	ETF	54.0	54.2861	54.0	54.2861	26800.0
2004-08-03 18:00:00	IWM	ETF	53.975	53.975	53.975	53.975	200.0
2004-08-03 08:00:00	DIA	ETF	101.93	101.93	101.8	101.84	11000.0
2004-08-03 09:00:00	DIA	ETF	101.87	101.94	101.7	101.85	476400.0
2004-08-03 10:00:00	DIA	ETF	101.85	101.87	101.52	101.77	1122600.0
2004-08-03 11:00:00	DIA	ETF	101.77	101.9	101.66	101.77	290200.0
2004-08-03 12:00:00	DIA	ETF	101.77	101.87	101.62	101.66	214500.0
2004-08-03 13:00:00	DIA	ETF	101.66	101.74	101.55	101.68	336800.0
2004-08-03 14:00:00	DIA	ETF	101.67	101.67	101.21	101.31	924200.0
2004-08-03 15:00:00	DIA	ETF	101.31	101.53	101.16	101.37	1058100.0
2004-08-03 16:00:00	DIA	ETF	101.36	101.36	101.17	101.25	537400.0
2004-08-03 17:00:00	DIA	ETF	101.2	101.2	101.2	101.2	1400.0
2004-08-03 18:00:00	DIA	ETF	101.17	101.17	101.17	101.17	200.0
2004-08-03 19:00:00	DIA	ETF	101.26	101.26	101.2	101.2	800.0
2004-08-03 09:00:00	TLT	ETF	84.49	84.52	84.4	84.52	11100.0
2004-08-03 10:00:00	TLT	ETF	84.53	84.67	84.52	84.65	108500.0
2004-08-03 11:00:00	TLT	ETF	84.55	84.64	84.53	84.54	108600.0
2004-08-03 12:00:00	TLT	ETF	84.58	84.83	84.58	84.75	42300.0

> showing 50 of 677 rows — these rows as CSV

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