PREVIEW / etf_1hour / 2004-08-20

all etf 1-hour files

  file:    by_date/etf_1hour/2004/2004-08-20.parquet
  size:    24 KB
  rows:    665

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-20 08:00:00	SPY	ETF	109.53	109.53	109.33	109.44	52000.0
2004-08-20 09:00:00	SPY	ETF	109.43	109.99	109.41	109.87	5878000.0
2004-08-20 10:00:00	SPY	ETF	109.86	110.17	109.79	109.94	7003100.0
2004-08-20 11:00:00	SPY	ETF	109.94	110.0	109.81	109.93	3458300.0
2004-08-20 12:00:00	SPY	ETF	109.92	110.35	109.91	110.25	6842900.0
2004-08-20 13:00:00	SPY	ETF	110.25	110.48	110.21	110.35	3913400.0
2004-08-20 14:00:00	SPY	ETF	110.35	110.56	110.29	110.47	6958000.0
2004-08-20 15:00:00	SPY	ETF	110.45	110.63	110.34	110.44	7963900.0
2004-08-20 16:00:00	SPY	ETF	110.44	110.5	110.38	110.42	1170100.0
2004-08-20 17:00:00	SPY	ETF	110.42	110.44	110.39	110.39	17000.0
2004-08-20 18:00:00	SPY	ETF	110.41	110.48	110.41	110.46	7100.0
2004-08-20 19:00:00	SPY	ETF	110.44	110.5	110.44	110.5	5100.0
2004-08-20 08:00:00	QQQ	ETF	33.67	33.67	33.5	33.53	59500.0
2004-08-20 09:00:00	QQQ	ETF	33.52	33.75	33.51	33.691	10981300.0
2004-08-20 10:00:00	QQQ	ETF	33.694	33.863	33.64	33.772	15471100.0
2004-08-20 11:00:00	QQQ	ETF	33.77	33.8	33.71	33.785	7752600.0
2004-08-20 12:00:00	QQQ	ETF	33.785	33.99	33.75	33.95	12879700.0
2004-08-20 13:00:00	QQQ	ETF	33.944	34.01	33.889	33.98	10420700.0
2004-08-20 14:00:00	QQQ	ETF	33.98	34.08	33.96	34.05	11248000.0
2004-08-20 15:00:00	QQQ	ETF	34.05	34.14	33.98	34.01	16986200.0
2004-08-20 16:00:00	QQQ	ETF	34.0	34.03	33.97	34.0	3959400.0
2004-08-20 17:00:00	QQQ	ETF	34.0	34.02	33.96	33.99	92900.0
2004-08-20 18:00:00	QQQ	ETF	33.98	34.01	33.94	33.94	49200.0
2004-08-20 19:00:00	QQQ	ETF	34.0	34.0	33.96	34.0	3200.0
2004-08-20 08:00:00	IWM	ETF	53.52	53.52	53.405	53.405	1200.0
2004-08-20 09:00:00	IWM	ETF	53.415	54.065	53.36	53.945	1126200.0
2004-08-20 10:00:00	IWM	ETF	53.935	54.2	53.875	54.14	2403800.0
2004-08-20 11:00:00	IWM	ETF	54.125	54.145	54.0	54.07	847600.0
2004-08-20 12:00:00	IWM	ETF	54.065	54.275	54.065	54.235	1086800.0
2004-08-20 13:00:00	IWM	ETF	54.24	54.46	54.195	54.4	707800.0
2004-08-20 14:00:00	IWM	ETF	54.4	54.535	54.385	54.455	1720400.0
2004-08-20 15:00:00	IWM	ETF	54.475	54.7	54.405	54.545	2589400.0
2004-08-20 16:00:00	IWM	ETF	54.545	54.7	54.505	54.7	603400.0
2004-08-20 17:00:00	IWM	ETF	54.45	54.45	54.425	54.425	600.0
2004-08-20 08:00:00	DIA	ETF	100.28	100.38	100.28	100.3	26600.0
2004-08-20 09:00:00	DIA	ETF	100.28	100.66	100.28	100.59	898600.0
2004-08-20 10:00:00	DIA	ETF	100.59	100.82	100.52	100.66	969400.0
2004-08-20 11:00:00	DIA	ETF	100.66	100.75	100.55	100.64	270500.0
2004-08-20 12:00:00	DIA	ETF	100.64	101.02	100.61	100.94	290100.0
2004-08-20 13:00:00	DIA	ETF	100.94	101.21	100.9	101.07	520300.0
2004-08-20 14:00:00	DIA	ETF	101.07	101.28	101.06	101.22	356600.0
2004-08-20 15:00:00	DIA	ETF	101.21	101.44	101.15	101.2	1025100.0
2004-08-20 16:00:00	DIA	ETF	101.22	101.31	101.165	101.26	353600.0
2004-08-20 17:00:00	DIA	ETF	101.25	101.35	101.25	101.33	3800.0
2004-08-20 18:00:00	DIA	ETF	101.33	101.33	101.33	101.33	100.0
2004-08-20 09:00:00	TLT	ETF	86.58	86.63	86.4	86.4	25300.0
2004-08-20 10:00:00	TLT	ETF	86.44	86.5	86.42	86.48	101100.0
2004-08-20 11:00:00	TLT	ETF	86.49	86.56	86.49	86.53	140400.0
2004-08-20 12:00:00	TLT	ETF	86.54	86.6	86.49	86.6	52700.0
2004-08-20 13:00:00	TLT	ETF	86.58	86.75	86.56	86.75	359800.0

> showing 50 of 665 rows — these rows as CSV

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