PREVIEW / etf_1hour / 2004-03-05

all etf 1-hour files

  file:    by_date/etf_1hour/2004/2004-03-05.parquet
  size:    25 KB
  rows:    692

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-03-05 08:00:00	SPY	ETF	116.01	116.03	115.43	115.52	350000.0
2004-03-05 09:00:00	SPY	ETF	115.55	115.88	115.26	115.81	5977600.0
2004-03-05 10:00:00	SPY	ETF	115.81	116.95	115.76	116.57	11468000.0
2004-03-05 11:00:00	SPY	ETF	116.54	116.68	115.74	116.22	7132000.0
2004-03-05 12:00:00	SPY	ETF	116.18	116.53	116.07	116.27	2643300.0
2004-03-05 13:00:00	SPY	ETF	116.28	116.48	116.15	116.25	2279100.0
2004-03-05 14:00:00	SPY	ETF	116.2	116.58	116.15	116.33	3359000.0
2004-03-05 15:00:00	SPY	ETF	116.33	116.6	116.13	116.29	4369000.0
2004-03-05 16:00:00	SPY	ETF	116.3	116.43	116.26	116.42	1427400.0
2004-03-05 17:00:00	SPY	ETF	116.42	116.5	116.38	116.48	17100.0
2004-03-05 18:00:00	SPY	ETF	116.39	116.39	116.37	116.37	11100.0
2004-03-05 19:00:00	SPY	ETF	116.38	116.38	116.38	116.38	200.0
2004-03-05 08:00:00	QQQ	ETF	36.68	36.72	36.37	36.43	1476100.0
2004-03-05 09:00:00	QQQ	ETF	36.44	36.57	36.3	36.5	12131200.0
2004-03-05 10:00:00	QQQ	ETF	36.5	37.15	36.48	36.96	24241500.0
2004-03-05 11:00:00	QQQ	ETF	36.97	37.02	36.49	36.669	17092200.0
2004-03-05 12:00:00	QQQ	ETF	36.67	36.83	36.62	36.73	6435300.0
2004-03-05 13:00:00	QQQ	ETF	36.73	36.8	36.62	36.64	5622900.0
2004-03-05 14:00:00	QQQ	ETF	36.67	36.889	36.65	36.78	6941000.0
2004-03-05 15:00:00	QQQ	ETF	36.77	36.88	36.66	36.69	10792700.0
2004-03-05 16:00:00	QQQ	ETF	36.676	36.7	36.6	36.63	2255300.0
2004-03-05 17:00:00	QQQ	ETF	36.63	36.66	36.62	36.632	47300.0
2004-03-05 18:00:00	QQQ	ETF	36.669	36.67	36.63	36.65	10800.0
2004-03-05 19:00:00	QQQ	ETF	36.65	36.67	36.65	36.67	5200.0
2004-03-05 08:00:00	IWM	ETF	59.31	59.4	59.155	59.275	14000.0
2004-03-05 09:00:00	IWM	ETF	59.215	59.475	59.125	59.435	962600.0
2004-03-05 10:00:00	IWM	ETF	59.45	60.215	59.45	59.94	1623400.0
2004-03-05 11:00:00	IWM	ETF	59.945	60.025	59.5	59.715	1801200.0
2004-03-05 12:00:00	IWM	ETF	59.73	59.92	59.655	59.805	662200.0
2004-03-05 13:00:00	IWM	ETF	59.805	59.85	59.72	59.745	139800.0
2004-03-05 14:00:00	IWM	ETF	59.8	59.9	59.745	59.82	375800.0
2004-03-05 15:00:00	IWM	ETF	59.815	59.975	59.645	59.703	651000.0
2004-03-05 16:00:00	IWM	ETF	59.685	59.76	59.67	59.725	59000.0
2004-03-05 08:00:00	DIA	ETF	105.97	106.04	105.42	105.5	41800.0
2004-03-05 09:00:00	DIA	ETF	105.54	105.72	105.27	105.67	691400.0
2004-03-05 10:00:00	DIA	ETF	105.62	106.681	105.62	106.4	1216500.0
2004-03-05 11:00:00	DIA	ETF	106.4	106.49	105.7	106.03	780400.0
2004-03-05 12:00:00	DIA	ETF	106.03	106.28	105.93	106.11	654900.0
2004-03-05 13:00:00	DIA	ETF	106.11	106.23	106.027	106.14	165500.0
2004-03-05 14:00:00	DIA	ETF	106.14	106.363	106.07	106.21	351000.0
2004-03-05 15:00:00	DIA	ETF	106.21	106.38	106.007	106.17	500500.0
2004-03-05 16:00:00	DIA	ETF	106.19	106.28	106.142	106.28	90700.0
2004-03-05 18:00:00	DIA	ETF	106.23	106.23	106.22	106.22	600.0
2004-03-05 08:00:00	TLT	ETF	89.19	89.55	89.17	89.55	13600.0
2004-03-05 09:00:00	TLT	ETF	89.55	90.0	89.55	89.83	491600.0
2004-03-05 10:00:00	TLT	ETF	89.77	89.89	89.68	89.751	390000.0
2004-03-05 11:00:00	TLT	ETF	89.75	89.894	89.67	89.85	140200.0
2004-03-05 12:00:00	TLT	ETF	89.85	89.88	89.773	89.8	40800.0
2004-03-05 13:00:00	TLT	ETF	89.83	90.0	89.77	89.93	87300.0
2004-03-05 14:00:00	TLT	ETF	89.85	89.93	89.73	89.73	283700.0

> showing 50 of 692 rows — these rows as CSV

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