PREVIEW / etf_1hour / 2004-12-27

all etf 1-hour files

  file:    by_date/etf_1hour/2004/2004-12-27.parquet
  size:    27 KB
  rows:    773

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-12-27 08:00:00	SPY	ETF	121.18	121.25	121.18	121.22	17200.0
2004-12-27 09:00:00	SPY	ETF	121.21	121.36	121.15	121.23	3941000.0
2004-12-27 10:00:00	SPY	ETF	121.23	121.24	120.9	121.12	4958000.0
2004-12-27 11:00:00	SPY	ETF	121.11	121.18	120.47	120.66	5964000.0
2004-12-27 12:00:00	SPY	ETF	120.65	120.82	120.62	120.67	1952800.0
2004-12-27 13:00:00	SPY	ETF	120.67	120.79	120.55	120.76	1430200.0
2004-12-27 14:00:00	SPY	ETF	120.77	120.86	120.61	120.75	2354300.0
2004-12-27 15:00:00	SPY	ETF	120.76	120.81	120.41	120.42	4231400.0
2004-12-27 16:00:00	SPY	ETF	120.43	120.69	120.38	120.46	3186500.0
2004-12-27 17:00:00	SPY	ETF	120.46	120.48	120.45	120.45	32800.0
2004-12-27 18:00:00	SPY	ETF	120.47	120.52	120.47	120.51	3000.0
2004-12-27 19:00:00	SPY	ETF	120.54	120.54	120.54	120.54	300.0
2004-12-27 08:00:00	QQQ	ETF	39.86	39.92	39.845	39.92	200793.0
2004-12-27 09:00:00	QQQ	ETF	39.92	40.02	39.85	39.93	7888933.0
2004-12-27 10:00:00	QQQ	ETF	39.931	39.94	39.71	39.84	10874085.0
2004-12-27 11:00:00	QQQ	ETF	39.843	39.88	39.4	39.57	17393979.0
2004-12-27 12:00:00	QQQ	ETF	39.561	39.63	39.56	39.61	6179990.0
2004-12-27 13:00:00	QQQ	ETF	39.62	39.643	39.53	39.6301	4598566.0
2004-12-27 14:00:00	QQQ	ETF	39.64	39.74	39.61	39.702	7773679.0
2004-12-27 15:00:00	QQQ	ETF	39.703	39.711	39.58	39.59	8442276.0
2004-12-27 16:00:00	QQQ	ETF	39.59	39.66	39.57	39.6	1620954.0
2004-12-27 17:00:00	QQQ	ETF	39.6	39.63	39.589	39.6	97306.0
2004-12-27 18:00:00	QQQ	ETF	39.602	39.62	39.6	39.61	41706.0
2004-12-27 09:00:00	IWM	ETF	64.86	65.005	64.725	64.83	1863400.0
2004-12-27 10:00:00	IWM	ETF	64.83	64.83	64.445	64.565	1749800.0
2004-12-27 11:00:00	IWM	ETF	64.565	64.605	63.825	64.085	2380200.0
2004-12-27 12:00:00	IWM	ETF	64.085	64.2648	64.075	64.19	681800.0
2004-12-27 13:00:00	IWM	ETF	64.2	64.225	64.14	64.22	621200.0
2004-12-27 14:00:00	IWM	ETF	64.225	64.28	64.14	64.205	950200.0
2004-12-27 15:00:00	IWM	ETF	64.21	64.305	64.065	64.075	1241600.0
2004-12-27 16:00:00	IWM	ETF	64.055	64.255	64.05	64.19	294400.0
2004-12-27 17:00:00	IWM	ETF	64.17	64.18	64.17	64.18	6800.0
2004-12-27 08:00:00	DIA	ETF	108.42	108.49	108.42	108.46	3100.0
2004-12-27 09:00:00	DIA	ETF	108.43	108.56	108.38	108.48	617100.0
2004-12-27 10:00:00	DIA	ETF	108.48	108.49	108.21	108.39	835900.0
2004-12-27 11:00:00	DIA	ETF	108.39	108.44	107.9	108.07	1375900.0
2004-12-27 12:00:00	DIA	ETF	108.08	108.25	107.99	108.06	949300.0
2004-12-27 13:00:00	DIA	ETF	108.06	108.17	107.97	108.15	277000.0
2004-12-27 14:00:00	DIA	ETF	108.15	108.22	107.93	108.06	577100.0
2004-12-27 15:00:00	DIA	ETF	108.05	108.08	107.72	107.72	707000.0
2004-12-27 16:00:00	DIA	ETF	107.72	107.85	107.69	107.76	81900.0
2004-12-27 09:00:00	GLD	ETF	44.29	44.32	44.27	44.29	130200.0
2004-12-27 10:00:00	GLD	ETF	44.3	44.54	44.3	44.53	1829300.0
2004-12-27 11:00:00	GLD	ETF	44.53	44.56	44.49	44.51	224300.0
2004-12-27 12:00:00	GLD	ETF	44.5	44.56	44.5	44.53	67800.0
2004-12-27 13:00:00	GLD	ETF	44.52	44.52	44.48	44.5	139100.0
2004-12-27 14:00:00	GLD	ETF	44.48	44.51	44.43	44.45	161700.0
2004-12-27 15:00:00	GLD	ETF	44.46	44.49	44.41	44.48	85300.0
2004-12-27 16:00:00	GLD	ETF	44.48	44.52	44.48	44.49	5800.0
2004-12-27 08:00:00	TLT	ETF	88.53	88.53	88.4	88.4	10300.0

> showing 50 of 773 rows — these rows as CSV

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