PREVIEW / etf_1hour / 2005-12-23

all etf 1-hour files

  file:    by_date/etf_1hour/2005/2005-12-23.parquet
  size:    35 KB
  rows:    1,137

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
2005-12-23 06:00:00	SPY	ETF	126.63	126.63	126.63	126.63	400.0
2005-12-23 07:00:00	SPY	ETF	126.65	126.68	126.65	126.68	21500.0
2005-12-23 08:00:00	SPY	ETF	126.7	126.72	126.62	126.71	648900.0
2005-12-23 09:00:00	SPY	ETF	126.7	126.86	126.6	126.74	4099800.0
2005-12-23 10:00:00	SPY	ETF	126.75	126.79	126.42	126.47	5204000.0
2005-12-23 11:00:00	SPY	ETF	126.46	126.72	126.45	126.68	8161200.0
2005-12-23 12:00:00	SPY	ETF	126.7	126.75	126.58	126.74	2326500.0
2005-12-23 13:00:00	SPY	ETF	126.75	126.77	126.67	126.71	2016500.0
2005-12-23 14:00:00	SPY	ETF	126.74	126.75	126.57	126.74	1722400.0
2005-12-23 15:00:00	SPY	ETF	126.73	126.82	126.64	126.75	2759400.0
2005-12-23 16:00:00	SPY	ETF	126.77	126.8	126.66	126.66	186400.0
2005-12-23 17:00:00	SPY	ETF	126.71	126.75	126.67	126.67	1800.0
2005-12-23 09:00:00	QQQ	ETF	41.51	41.59	41.46	41.55	8199800.0
2005-12-23 10:00:00	QQQ	ETF	41.55	41.56	41.32	41.34	8704300.0
2005-12-23 11:00:00	QQQ	ETF	41.33	41.44	41.33	41.43	3441700.0
2005-12-23 12:00:00	QQQ	ETF	41.43	41.43	41.33	41.39	3703500.0
2005-12-23 13:00:00	QQQ	ETF	41.39	41.41	41.36	41.38	2552400.0
2005-12-23 14:00:00	QQQ	ETF	41.38	41.38	41.3	41.37	2463900.0
2005-12-23 15:00:00	QQQ	ETF	41.37	41.41	41.34	41.41	4310400.0
2005-12-23 08:00:00	IWM	ETF	67.98	68.07	67.98	68.01	7500.0
2005-12-23 09:00:00	IWM	ETF	68.06	68.27	68.03	68.2	3677800.0
2005-12-23 10:00:00	IWM	ETF	68.19	68.2	67.96	68.0	2930000.0
2005-12-23 11:00:00	IWM	ETF	68.01	68.15	68.01	68.14	1640200.0
2005-12-23 12:00:00	IWM	ETF	68.13	68.17	68.03	68.16	1916000.0
2005-12-23 13:00:00	IWM	ETF	68.17	68.2	68.09	68.14	1176900.0
2005-12-23 14:00:00	IWM	ETF	68.14	68.16	68.03	68.08	1186400.0
2005-12-23 15:00:00	IWM	ETF	68.09	68.8	68.0	68.21	1904800.0
2005-12-23 16:00:00	IWM	ETF	68.21	68.21	68.11	68.13	122500.0
2005-12-23 18:00:00	IWM	ETF	68.09	68.09	68.09	68.09	300.0
2005-12-23 08:00:00	DIA	ETF	108.71	108.78	108.7	108.75	19600.0
2005-12-23 09:00:00	DIA	ETF	108.8	108.95	108.72	108.89	396500.0
2005-12-23 10:00:00	DIA	ETF	108.88	108.89	108.6	108.6	395500.0
2005-12-23 11:00:00	DIA	ETF	108.6	108.82	108.6	108.8	113100.0
2005-12-23 12:00:00	DIA	ETF	108.81	108.85	108.71	108.84	124300.0
2005-12-23 13:00:00	DIA	ETF	108.85	108.89	108.78	108.83	275900.0
2005-12-23 14:00:00	DIA	ETF	108.83	108.89	108.72	108.79	164300.0
2005-12-23 15:00:00	DIA	ETF	108.79	108.89	108.7	108.77	287300.0
2005-12-23 16:00:00	DIA	ETF	108.78	108.78	108.7	108.71	111900.0
2005-12-23 08:00:00	GLD	ETF	50.18	50.18	49.82	49.92	27100.0
2005-12-23 09:00:00	GLD	ETF	49.91	50.46	49.9	50.34	957600.0
2005-12-23 10:00:00	GLD	ETF	50.34	50.45	50.12	50.24	545800.0
2005-12-23 11:00:00	GLD	ETF	50.24	50.3	50.17	50.19	932500.0
2005-12-23 12:00:00	GLD	ETF	50.2	50.2	50.1	50.18	155900.0
2005-12-23 13:00:00	GLD	ETF	50.18	50.19	50.13	50.15	65600.0
2005-12-23 14:00:00	GLD	ETF	50.14	50.2	50.12	50.19	73200.0
2005-12-23 15:00:00	GLD	ETF	50.17	50.21	50.11	50.2	73500.0
2005-12-23 16:00:00	GLD	ETF	50.15	50.15	50.12	50.12	2500.0
2005-12-23 08:00:00	TLT	ETF	91.22	91.22	91.22	91.22	200.0
2005-12-23 09:00:00	TLT	ETF	91.28	91.28	91.1	91.17	18800.0
2005-12-23 10:00:00	TLT	ETF	91.25	91.73	91.25	91.71	120000.0

> showing 50 of 1,137 rows — these rows as CSV

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