PREVIEW / etf_1hour / 2004-08-19

all etf 1-hour files

  file:    by_date/etf_1hour/2004/2004-08-19.parquet
  size:    24 KB
  rows:    672

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-19 08:00:00	SPY	ETF	109.7	109.85	109.65	109.84	476200.0
2004-08-19 09:00:00	SPY	ETF	109.8	110.02	109.64	110.0	3676100.0
2004-08-19 10:00:00	SPY	ETF	110.01	110.01	109.48	109.65	7786600.0
2004-08-19 11:00:00	SPY	ETF	109.64	109.92	109.61	109.84	3727400.0
2004-08-19 12:00:00	SPY	ETF	109.84	109.98	109.72	109.85	2013700.0
2004-08-19 13:00:00	SPY	ETF	109.84	109.91	109.61	109.65	2694500.0
2004-08-19 14:00:00	SPY	ETF	109.65	109.66	109.18	109.29	6261700.0
2004-08-19 15:00:00	SPY	ETF	109.29	109.82	109.19	109.61	8150400.0
2004-08-19 16:00:00	SPY	ETF	109.6	109.89	109.53	109.58	3939200.0
2004-08-19 17:00:00	SPY	ETF	109.62	109.68	109.6	109.61	86100.0
2004-08-19 18:00:00	SPY	ETF	109.61	109.61	109.55	109.55	36700.0
2004-08-19 19:00:00	SPY	ETF	109.54	109.55	109.54	109.55	1100.0
2004-08-19 08:00:00	QQQ	ETF	33.68	33.76	33.67	33.75	551100.0
2004-08-19 09:00:00	QQQ	ETF	33.74	33.85	33.6	33.809	13466600.0
2004-08-19 10:00:00	QQQ	ETF	33.809	33.81	33.55	33.67	18457100.0
2004-08-19 11:00:00	QQQ	ETF	33.67	33.826	33.639	33.72	12682700.0
2004-08-19 12:00:00	QQQ	ETF	33.71	33.8	33.672	33.73	11545200.0
2004-08-19 13:00:00	QQQ	ETF	33.74	33.76	33.63	33.63	7543900.0
2004-08-19 14:00:00	QQQ	ETF	33.64	33.65	33.42	33.51	16401500.0
2004-08-19 15:00:00	QQQ	ETF	33.51	33.75	33.44	33.63	17052700.0
2004-08-19 16:00:00	QQQ	ETF	33.63	33.703	33.62	33.65	2879400.0
2004-08-19 17:00:00	QQQ	ETF	33.651	33.67	33.6	33.62	2127300.0
2004-08-19 18:00:00	QQQ	ETF	33.62	33.62	33.6	33.6	31900.0
2004-08-19 19:00:00	QQQ	ETF	33.61	33.65	33.61	33.63	42900.0
2004-08-19 08:00:00	IWM	ETF	53.87	53.88	53.8	53.8	67000.0
2004-08-19 09:00:00	IWM	ETF	53.865	54.04	53.625	54.025	1611600.0
2004-08-19 10:00:00	IWM	ETF	54.015	54.015	53.645	53.77	1966200.0
2004-08-19 11:00:00	IWM	ETF	53.775	53.965	53.74	53.905	1075400.0
2004-08-19 12:00:00	IWM	ETF	53.92	54.03	53.85	53.94	345000.0
2004-08-19 13:00:00	IWM	ETF	53.925	53.945	53.74	53.765	617000.0
2004-08-19 14:00:00	IWM	ETF	53.745	53.745	53.365	53.495	1842000.0
2004-08-19 15:00:00	IWM	ETF	53.495	53.74	53.425	53.61	1579600.0
2004-08-19 16:00:00	IWM	ETF	53.64	53.93	53.56	53.605	272000.0
2004-08-19 17:00:00	IWM	ETF	53.545	53.545	53.5	53.5	88600.0
2004-08-19 08:00:00	DIA	ETF	100.91	101.03	100.91	101.01	9600.0
2004-08-19 09:00:00	DIA	ETF	101.05	101.18	100.85	101.15	404400.0
2004-08-19 10:00:00	DIA	ETF	101.13	101.14	100.68	100.85	1052800.0
2004-08-19 11:00:00	DIA	ETF	100.84	101.02	100.79	100.92	427300.0
2004-08-19 12:00:00	DIA	ETF	100.91	101.0	100.84	100.91	243900.0
2004-08-19 13:00:00	DIA	ETF	100.89	100.9476	100.71	100.73	235600.0
2004-08-19 14:00:00	DIA	ETF	100.74	100.74	100.32	100.45	902800.0
2004-08-19 15:00:00	DIA	ETF	100.46	100.93	100.35	100.78	1595400.0
2004-08-19 16:00:00	DIA	ETF	100.78	100.85	100.73	100.73	121000.0
2004-08-19 17:00:00	DIA	ETF	100.8	100.8	100.71	100.71	80100.0
2004-08-19 09:00:00	TLT	ETF	86.5	86.5	86.34	86.4	8500.0
2004-08-19 10:00:00	TLT	ETF	86.4	86.59	86.34	86.56	23600.0
2004-08-19 11:00:00	TLT	ETF	86.51	86.61	86.45	86.61	16500.0
2004-08-19 12:00:00	TLT	ETF	86.6	86.65	86.44	86.65	85500.0
2004-08-19 13:00:00	TLT	ETF	86.65	86.72	86.62	86.67	55200.0
2004-08-19 14:00:00	TLT	ETF	86.67	86.75	86.63	86.63	68600.0

> showing 50 of 672 rows — these rows as CSV

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