PREVIEW / etf_1hour / 2005-09-28

all etf 1-hour files

  file:    by_date/etf_1hour/2005/2005-09-28.parquet
  size:    32 KB
  rows:    987

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-09-28 07:00:00	SPY	ETF	121.93	121.99	121.92	121.92	37100.0
2005-09-28 08:00:00	SPY	ETF	121.96	122.02	121.8	121.94	658000.0
2005-09-28 09:00:00	SPY	ETF	121.93	122.02	121.85	121.98	3922500.0
2005-09-28 10:00:00	SPY	ETF	121.97	122.12	121.83	122.0	7644000.0
2005-09-28 11:00:00	SPY	ETF	122.01	122.04	121.56	121.66	5742200.0
2005-09-28 12:00:00	SPY	ETF	121.66	121.7	121.31	121.5	5362500.0
2005-09-28 13:00:00	SPY	ETF	121.5	121.59	121.2	121.4	6677400.0
2005-09-28 14:00:00	SPY	ETF	121.38	122.01	121.38	121.84	13753900.0
2005-09-28 15:00:00	SPY	ETF	121.84	121.94	121.65	121.68	12570600.0
2005-09-28 16:00:00	SPY	ETF	121.7	121.75	121.64	121.72	812300.0
2005-09-28 17:00:00	SPY	ETF	121.73	121.7861	121.71	121.73	13400.0
2005-09-28 18:00:00	SPY	ETF	121.75	121.7861	121.69	121.69	12900.0
2005-09-28 19:00:00	SPY	ETF	121.72	121.72	121.72	121.72	100.0
2005-09-28 09:00:00	QQQ	ETF	38.77	38.85	38.76	38.85	8772200.0
2005-09-28 10:00:00	QQQ	ETF	38.85	38.95	38.81	38.86	15523300.0
2005-09-28 11:00:00	QQQ	ETF	38.86	38.9	38.7	38.73	7950600.0
2005-09-28 12:00:00	QQQ	ETF	38.74	38.75	38.57	38.65	11650900.0
2005-09-28 13:00:00	QQQ	ETF	38.65	38.68	38.56	38.65	6555900.0
2005-09-28 14:00:00	QQQ	ETF	38.65	38.85	38.65	38.78	9060200.0
2005-09-28 15:00:00	QQQ	ETF	38.78	38.81	38.67	38.67	8528000.0
2005-09-28 08:00:00	IWM	ETF	65.6	65.7	65.6	65.6	81100.0
2005-09-28 09:00:00	IWM	ETF	65.62	65.63	65.28	65.44	1716600.0
2005-09-28 10:00:00	IWM	ETF	65.44	65.64	65.3	65.56	2547300.0
2005-09-28 11:00:00	IWM	ETF	65.56	65.59	65.15	65.18	2421000.0
2005-09-28 12:00:00	IWM	ETF	65.18	65.21	64.92	65.03	3507100.0
2005-09-28 13:00:00	IWM	ETF	65.03	65.13	64.74	64.9	3527400.0
2005-09-28 14:00:00	IWM	ETF	64.91	65.43	64.87	65.27	3866000.0
2005-09-28 15:00:00	IWM	ETF	65.28	65.32	65.08	65.15	2542300.0
2005-09-28 16:00:00	IWM	ETF	65.16	65.3	65.14	65.27	109400.0
2005-09-28 17:00:00	IWM	ETF	65.29	65.3	65.29	65.3	5000.0
2005-09-28 07:00:00	DIA	ETF	104.85	104.85	104.85	104.85	1900.0
2005-09-28 08:00:00	DIA	ETF	104.82	104.85	104.7	104.78	19200.0
2005-09-28 09:00:00	DIA	ETF	104.81	104.88	104.74	104.87	561900.0
2005-09-28 10:00:00	DIA	ETF	104.89	105.04	104.75	104.97	979200.0
2005-09-28 11:00:00	DIA	ETF	104.99	105.03	104.54	104.58	674400.0
2005-09-28 12:00:00	DIA	ETF	104.6	104.62	104.31	104.46	1146000.0
2005-09-28 13:00:00	DIA	ETF	104.46	104.5	104.16	104.31	684800.0
2005-09-28 14:00:00	DIA	ETF	104.292	104.76	104.28	104.71	874300.0
2005-09-28 15:00:00	DIA	ETF	104.69	104.82	104.62	104.71	1157700.0
2005-09-28 16:00:00	DIA	ETF	104.69	104.75	104.67	104.74	107800.0
2005-09-28 08:00:00	GLD	ETF	46.28	46.38	46.27	46.38	11200.0
2005-09-28 09:00:00	GLD	ETF	46.25	46.37	46.24	46.32	256600.0
2005-09-28 10:00:00	GLD	ETF	46.33	46.35	46.16	46.17	2001500.0
2005-09-28 11:00:00	GLD	ETF	46.18	46.46	46.17	46.46	160700.0
2005-09-28 12:00:00	GLD	ETF	46.46	46.7	46.44	46.69	322700.0
2005-09-28 13:00:00	GLD	ETF	46.69	46.89	46.69	46.83	423100.0
2005-09-28 14:00:00	GLD	ETF	46.85	46.85	46.77	46.78	144500.0
2005-09-28 15:00:00	GLD	ETF	46.77	46.82	46.74	46.8	127600.0
2005-09-28 16:00:00	GLD	ETF	46.81	46.81	46.81	46.81	100.0
2005-09-28 18:00:00	GLD	ETF	46.83	46.83	46.83	46.83	100.0

> showing 50 of 987 rows — these rows as CSV

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