PREVIEW / etf_1hour / 2004-07-29

all etf 1-hour files

  file:    by_date/etf_1hour/2004/2004-07-29.parquet
  size:    25 KB
  rows:    685

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-07-29 08:00:00	SPY	ETF	110.35	110.58	110.35	110.42	151900.0
2004-07-29 09:00:00	SPY	ETF	110.43	110.66	110.21	110.54	4806900.0
2004-07-29 10:00:00	SPY	ETF	110.55	110.58	110.15	110.44	7122100.0
2004-07-29 11:00:00	SPY	ETF	110.44	110.49	110.24	110.44	3394500.0
2004-07-29 12:00:00	SPY	ETF	110.44	110.85	110.36	110.68	5956800.0
2004-07-29 13:00:00	SPY	ETF	110.68	110.8	110.41	110.45	4112500.0
2004-07-29 14:00:00	SPY	ETF	110.45	110.49	110.0	110.49	8044500.0
2004-07-29 15:00:00	SPY	ETF	110.48	110.86	110.33	110.55	11835300.0
2004-07-29 16:00:00	SPY	ETF	110.58	110.67	110.45	110.67	2096400.0
2004-07-29 17:00:00	SPY	ETF	110.65	110.65	110.56	110.6	147900.0
2004-07-29 18:00:00	SPY	ETF	110.58	110.6	110.58	110.59	3600.0
2004-07-29 19:00:00	SPY	ETF	110.57	110.57	110.55	110.55	1000.0
2004-07-29 08:00:00	QQQ	ETF	34.54	34.72	34.54	34.62	397700.0
2004-07-29 09:00:00	QQQ	ETF	34.61	34.78	34.6	34.734	11248200.0
2004-07-29 10:00:00	QQQ	ETF	34.73	34.77	34.535	34.68	13807400.0
2004-07-29 11:00:00	QQQ	ETF	34.68	34.74	34.61	34.65	6726700.0
2004-07-29 12:00:00	QQQ	ETF	34.66	34.92	34.63	34.79	14963000.0
2004-07-29 13:00:00	QQQ	ETF	34.78	34.9	34.67	34.68	8422300.0
2004-07-29 14:00:00	QQQ	ETF	34.68	34.73	34.5	34.73	15897700.0
2004-07-29 15:00:00	QQQ	ETF	34.73	34.89	34.65	34.77	19844700.0
2004-07-29 16:00:00	QQQ	ETF	34.78	34.87	34.733	34.84	2712500.0
2004-07-29 17:00:00	QQQ	ETF	34.85	34.87	34.78	34.83	157800.0
2004-07-29 18:00:00	QQQ	ETF	34.82	34.85	34.8	34.83	77500.0
2004-07-29 19:00:00	QQQ	ETF	34.82	34.84	34.82	34.84	1700.0
2004-07-29 08:00:00	IWM	ETF	54.215	54.3	54.215	54.27	52400.0
2004-07-29 09:00:00	IWM	ETF	54.27	54.53	54.225	54.5	1637200.0
2004-07-29 10:00:00	IWM	ETF	54.5	54.535	54.145	54.45	1636800.0
2004-07-29 11:00:00	IWM	ETF	54.455	54.51	54.255	54.335	636600.0
2004-07-29 12:00:00	IWM	ETF	54.33	54.66	54.27	54.57	590600.0
2004-07-29 13:00:00	IWM	ETF	54.565	54.675	54.46	54.46	1098200.0
2004-07-29 14:00:00	IWM	ETF	54.46	54.565	54.14	54.545	1015600.0
2004-07-29 15:00:00	IWM	ETF	54.54	54.84	54.465	54.815	2890000.0
2004-07-29 16:00:00	IWM	ETF	54.805	54.87	54.7	54.815	764800.0
2004-07-29 17:00:00	IWM	ETF	54.77	54.77	54.765	54.765	10000.0
2004-07-29 08:00:00	DIA	ETF	101.6	101.71	101.53	101.58	11400.0
2004-07-29 09:00:00	DIA	ETF	101.8	101.81	101.46	101.66	1176200.0
2004-07-29 10:00:00	DIA	ETF	101.67	101.72	101.3	101.53	915600.0
2004-07-29 11:00:00	DIA	ETF	101.54	101.61	101.38	101.52	416100.0
2004-07-29 12:00:00	DIA	ETF	101.5	101.89	101.49	101.7	925000.0
2004-07-29 13:00:00	DIA	ETF	101.69	101.81	101.43	101.44	633800.0
2004-07-29 14:00:00	DIA	ETF	101.45	101.54	101.05	101.54	1261900.0
2004-07-29 15:00:00	DIA	ETF	101.5	101.85	101.36	101.56	1315300.0
2004-07-29 16:00:00	DIA	ETF	101.58	101.65	101.52	101.65	289300.0
2004-07-29 18:00:00	DIA	ETF	101.65	101.69	101.65	101.69	400.0
2004-07-29 09:00:00	TLT	ETF	83.27	83.4	83.27	83.35	210900.0
2004-07-29 10:00:00	TLT	ETF	83.34	83.49	83.34	83.43	27200.0
2004-07-29 11:00:00	TLT	ETF	83.44	83.53	83.43	83.5	20300.0
2004-07-29 12:00:00	TLT	ETF	83.4	83.45	83.36	83.42	80800.0
2004-07-29 13:00:00	TLT	ETF	83.48	83.64	83.48	83.64	82800.0
2004-07-29 14:00:00	TLT	ETF	83.55	83.65	83.52	83.59	57800.0

> showing 50 of 685 rows — these rows as CSV

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