PREVIEW / etf_1hour / 2005-12-19

all etf 1-hour files

  file:    by_date/etf_1hour/2005/2005-12-19.parquet
  size:    38 KB
  rows:    1,176

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-19 07:00:00	SPY	ETF	126.8	126.86	126.75	126.78	50900.0
2005-12-19 08:00:00	SPY	ETF	126.75	126.82	126.69	126.75	549600.0
2005-12-19 09:00:00	SPY	ETF	126.74	126.78	126.52	126.56	4550300.0
2005-12-19 10:00:00	SPY	ETF	126.56	126.87	126.49	126.59	6420200.0
2005-12-19 11:00:00	SPY	ETF	126.59	126.75	126.54	126.65	3400600.0
2005-12-19 12:00:00	SPY	ETF	126.66	126.83	126.64	126.67	3353000.0
2005-12-19 13:00:00	SPY	ETF	126.67	126.69	126.16	126.28	9881700.0
2005-12-19 14:00:00	SPY	ETF	126.28	126.29	125.82	125.96	9555200.0
2005-12-19 15:00:00	SPY	ETF	125.95	126.03	125.69	125.78	8159200.0
2005-12-19 16:00:00	SPY	ETF	125.79	125.86	125.7	125.84	785700.0
2005-12-19 17:00:00	SPY	ETF	125.8	125.81	125.73	125.73	126200.0
2005-12-19 18:00:00	SPY	ETF	125.74	125.83	125.74	125.75	61300.0
2005-12-19 19:00:00	SPY	ETF	125.76	125.8	125.76	125.8	1400.0
2005-12-19 09:00:00	QQQ	ETF	41.68	41.71	41.44	41.5	11640200.0
2005-12-19 10:00:00	QQQ	ETF	41.51	41.66	41.47	41.55	8971300.0
2005-12-19 11:00:00	QQQ	ETF	41.55	41.62	41.54	41.56	5764300.0
2005-12-19 12:00:00	QQQ	ETF	41.56	41.59	41.53	41.54	3165400.0
2005-12-19 13:00:00	QQQ	ETF	41.53	41.53	41.22	41.29	12415900.0
2005-12-19 14:00:00	QQQ	ETF	41.29	41.32	41.17	41.23	8673100.0
2005-12-19 15:00:00	QQQ	ETF	41.23	41.24	40.0	40.92	20427100.0
2005-12-19 07:00:00	IWM	ETF	68.01	68.02	67.93	67.93	2300.0
2005-12-19 08:00:00	IWM	ETF	67.94	67.97	67.94	67.97	20100.0
2005-12-19 09:00:00	IWM	ETF	67.95	67.97	67.47	67.52	2139200.0
2005-12-19 10:00:00	IWM	ETF	67.52	67.72	67.42	67.49	2417400.0
2005-12-19 11:00:00	IWM	ETF	67.49	67.64	67.48	67.53	1238100.0
2005-12-19 12:00:00	IWM	ETF	67.53	67.58	67.48	67.55	1196000.0
2005-12-19 13:00:00	IWM	ETF	67.55	67.56	67.12	67.16	4083000.0
2005-12-19 14:00:00	IWM	ETF	67.16	67.16	66.97	67.08	4964600.0
2005-12-19 15:00:00	IWM	ETF	67.08	67.11	66.81	66.83	5480000.0
2005-12-19 16:00:00	IWM	ETF	66.98	67.05	66.96	67.02	95800.0
2005-12-19 17:00:00	IWM	ETF	66.99	66.99	66.99	66.99	300.0
2005-12-19 18:00:00	IWM	ETF	66.98	66.98	66.96	66.96	7300.0
2005-12-19 07:00:00	DIA	ETF	108.91	108.91	108.86	108.86	2300.0
2005-12-19 08:00:00	DIA	ETF	108.91	108.91	108.8	108.8	14000.0
2005-12-19 09:00:00	DIA	ETF	108.8	108.84	108.59	108.67	910200.0
2005-12-19 10:00:00	DIA	ETF	108.68	108.97	108.68	108.82	706600.0
2005-12-19 11:00:00	DIA	ETF	108.8199	108.98	108.76	108.83	433300.0
2005-12-19 12:00:00	DIA	ETF	108.84	109.05	108.84	108.91	391600.0
2005-12-19 13:00:00	DIA	ETF	108.91	108.91	108.49	108.56	1313000.0
2005-12-19 14:00:00	DIA	ETF	108.55	108.57	108.11	108.22	1825600.0
2005-12-19 15:00:00	DIA	ETF	108.23	108.32	108.05	108.2	1944100.0
2005-12-19 16:00:00	DIA	ETF	108.22	108.25	108.17	108.23	21000.0
2005-12-19 17:00:00	DIA	ETF	108.22	108.22	108.22	108.22	2500.0
2005-12-19 18:00:00	DIA	ETF	108.22	108.22	108.22	108.22	200.0
2005-12-19 19:00:00	DIA	ETF	108.27	108.27	108.27	108.27	200.0
2005-12-19 07:00:00	GLD	ETF	50.64	50.64	50.5	50.6	11200.0
2005-12-19 08:00:00	GLD	ETF	50.58	50.69	50.52	50.59	27900.0
2005-12-19 09:00:00	GLD	ETF	50.57	50.74	50.52	50.73	414500.0
2005-12-19 10:00:00	GLD	ETF	50.74	50.75	50.42	50.549	377300.0
2005-12-19 11:00:00	GLD	ETF	50.52	50.72	50.47	50.66	211400.0

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

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