PREVIEW / etf_1hour / 2004-12-16

all etf 1-hour files

  file:    by_date/etf_1hour/2004/2004-12-16.parquet
  size:    28 KB
  rows:    794

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-16 08:00:00	SPY	ETF	120.85	120.87	120.78	120.79	80600.0
2004-12-16 09:00:00	SPY	ETF	120.8	120.87	120.51	120.79	6862500.0
2004-12-16 10:00:00	SPY	ETF	120.79	121.05	120.57	121.02	5928700.0
2004-12-16 11:00:00	SPY	ETF	121.02	121.14	120.82	121.05	5410500.0
2004-12-16 12:00:00	SPY	ETF	121.05	121.24	121.0	121.07	3607500.0
2004-12-16 13:00:00	SPY	ETF	121.08	121.09	120.73	120.75	5256800.0
2004-12-16 14:00:00	SPY	ETF	120.74	120.82	120.23	120.23	9807100.0
2004-12-16 15:00:00	SPY	ETF	120.31	120.87	120.22	120.7	9832400.0
2004-12-16 16:00:00	SPY	ETF	120.7	120.88	120.59	120.82	2777300.0
2004-12-16 17:00:00	SPY	ETF	120.83	120.85	120.78	120.79	184500.0
2004-12-16 18:00:00	SPY	ETF	120.81	120.81	120.79	120.79	4600.0
2004-12-16 19:00:00	SPY	ETF	120.74	120.74	120.73	120.74	1300.0
2004-12-16 08:00:00	QQQ	ETF	40.359	40.43	40.34	40.39	237308.0
2004-12-16 09:00:00	QQQ	ETF	40.4	40.425	40.273	40.337	8813800.0
2004-12-16 10:00:00	QQQ	ETF	40.34	40.38	40.22	40.377	9953008.0
2004-12-16 11:00:00	QQQ	ETF	40.371	40.44	40.33	40.38	6952898.0
2004-12-16 12:00:00	QQQ	ETF	40.382	40.43	40.34	40.37	4684702.0
2004-12-16 13:00:00	QQQ	ETF	40.36	40.38	40.16	40.17	8056659.0
2004-12-16 14:00:00	QQQ	ETF	40.172	40.22	39.84	39.846	23235731.0
2004-12-16 15:00:00	QQQ	ETF	39.846	40.041	39.82	40.0	18382298.0
2004-12-16 16:00:00	QQQ	ETF	40.0	40.131	39.925	40.055	3397843.0
2004-12-16 17:00:00	QQQ	ETF	40.07	40.07	39.95	40.01	87162.0
2004-12-16 18:00:00	QQQ	ETF	40.02	40.05	40.02	40.04	88755.0
2004-12-16 08:00:00	IWM	ETF	64.705	64.705	64.705	64.705	600.0
2004-12-16 09:00:00	IWM	ETF	64.615	64.715	64.585	64.66	1244200.0
2004-12-16 10:00:00	IWM	ETF	64.685	64.705	64.355	64.49	3006200.0
2004-12-16 11:00:00	IWM	ETF	64.5	64.525	64.37	64.395	938600.0
2004-12-16 12:00:00	IWM	ETF	64.395	64.495	64.28	64.355	758600.0
2004-12-16 13:00:00	IWM	ETF	64.352	64.38	64.16	64.23	1070800.0
2004-12-16 14:00:00	IWM	ETF	64.185	64.185	63.83	63.875	2300400.0
2004-12-16 15:00:00	IWM	ETF	63.875	64.29	63.855	64.125	3081200.0
2004-12-16 16:00:00	IWM	ETF	64.14	64.185	64.12	64.165	578000.0
2004-12-16 08:00:00	DIA	ETF	106.81	106.83	106.81	106.83	4300.0
2004-12-16 09:00:00	DIA	ETF	106.81	106.93	106.63	106.82	971000.0
2004-12-16 10:00:00	DIA	ETF	106.84	107.09	106.66	107.06	2188300.0
2004-12-16 11:00:00	DIA	ETF	107.06	107.16	106.96	107.14	927500.0
2004-12-16 12:00:00	DIA	ETF	107.14	107.29	107.14	107.21	453200.0
2004-12-16 13:00:00	DIA	ETF	107.21	107.21	106.97	107.01	780200.0
2004-12-16 14:00:00	DIA	ETF	107.02	107.09	106.62	106.62	1591400.0
2004-12-16 15:00:00	DIA	ETF	106.62	107.18	106.62	107.05	1342200.0
2004-12-16 16:00:00	DIA	ETF	107.05	107.16	107.0	107.08	242500.0
2004-12-16 17:00:00	DIA	ETF	107.11	107.11	107.11	107.11	300.0
2004-12-16 18:00:00	DIA	ETF	107.16	107.16	107.16	107.16	200.0
2004-12-16 09:00:00	GLD	ETF	43.99	44.05	43.95	44.0	840400.0
2004-12-16 10:00:00	GLD	ETF	43.98	44.05	43.8	43.89	610600.0
2004-12-16 11:00:00	GLD	ETF	43.89	43.91	43.83	43.88	134200.0
2004-12-16 12:00:00	GLD	ETF	43.89	43.91	43.69	43.75	413300.0
2004-12-16 13:00:00	GLD	ETF	43.8	43.8	43.58	43.62	214000.0
2004-12-16 14:00:00	GLD	ETF	43.64	43.72	43.58	43.69	394100.0
2004-12-16 15:00:00	GLD	ETF	43.7	43.72	43.67	43.68	111200.0

> showing 50 of 794 rows — these rows as CSV

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