PREVIEW / etf_1hour / 2008-01-02

all etf 1-hour files

  file:    by_date/etf_1hour/2008/2008-01-02.parquet
  size:    97 KB
  rows:    3,224

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
2008-01-02 06:00:00	SPY	ETF	146.89	147.13	146.85	147.13	31000.0
2008-01-02 07:00:00	SPY	ETF	147.14	147.15	146.76	146.8	563700.0
2008-01-02 08:00:00	SPY	ETF	146.8	146.96	146.21	146.85	955800.0
2008-01-02 09:00:00	SPY	ETF	146.86	146.99	146.21	146.72	12498857.0
2008-01-02 10:00:00	SPY	ETF	146.72	146.72	145.44	145.49	33423183.0
2008-01-02 11:00:00	SPY	ETF	145.49	145.79	144.64	145.06	26260214.0
2008-01-02 12:00:00	SPY	ETF	145.06	145.06	144.33	144.6	17423214.0
2008-01-02 13:00:00	SPY	ETF	144.6	144.83	144.16	144.67	16622063.0
2008-01-02 14:00:00	SPY	ETF	144.67	145.75	144.42	144.45	37314224.0
2008-01-02 15:00:00	SPY	ETF	144.45	144.7	143.88	144.55	29640195.0
2008-01-02 16:00:00	SPY	ETF	144.57	146.6246	144.48	144.97	18993500.0
2008-01-02 17:00:00	SPY	ETF	144.97	145.1	144.97	145.1	224200.0
2008-01-02 18:00:00	SPY	ETF	145.05	145.19	145.01	145.07	33400.0
2008-01-02 19:00:00	SPY	ETF	145.06	145.2	145.01	145.18	11800.0
2008-01-02 06:00:00	QQQ	ETF	51.52	51.52	51.51	51.52	12500.0
2008-01-02 07:00:00	QQQ	ETF	51.53	51.53	51.39	51.4	141237.0
2008-01-02 08:00:00	QQQ	ETF	51.4	51.44	51.24	51.35	537790.0
2008-01-02 09:00:00	QQQ	ETF	51.34	51.47	51.22	51.38	8642690.0
2008-01-02 10:00:00	QQQ	ETF	51.39	51.39	50.92	50.93	27607004.0
2008-01-02 11:00:00	QQQ	ETF	50.93	51.04	50.27	50.4701	24123342.0
2008-01-02 12:00:00	QQQ	ETF	50.47	50.48	50.13	50.31	19105137.0
2008-01-02 13:00:00	QQQ	ETF	50.31	50.45	50.13	50.36	16494779.0
2008-01-02 14:00:00	QQQ	ETF	50.37	50.8	50.25	50.27	32059626.0
2008-01-02 15:00:00	QQQ	ETF	50.27	50.45	50.16	50.41	22316111.0
2008-01-02 16:00:00	QQQ	ETF	50.41	50.53	50.37	50.5	2729100.0
2008-01-02 17:00:00	QQQ	ETF	50.5	50.56	50.5	50.53	23047.0
2008-01-02 18:00:00	QQQ	ETF	50.53	50.59	50.53	50.55	35404.0
2008-01-02 19:00:00	QQQ	ETF	50.55	50.58	50.54	50.58	15900.0
2008-01-02 07:00:00	IWM	ETF	76.5	76.5	76.29	76.29	28900.0
2008-01-02 08:00:00	IWM	ETF	75.92	76.28	75.92	76.25	2557600.0
2008-01-02 09:00:00	IWM	ETF	76.3	76.5	75.92	76.39	5625563.0
2008-01-02 10:00:00	IWM	ETF	76.39	76.39	75.22	75.24	16553168.0
2008-01-02 11:00:00	IWM	ETF	75.23	75.39	74.67	75.01	13515663.0
2008-01-02 12:00:00	IWM	ETF	75.01	75.01	74.59	74.86	9324415.0
2008-01-02 13:00:00	IWM	ETF	74.87	75.24	74.64	75.19	8912440.0
2008-01-02 14:00:00	IWM	ETF	75.19	75.83	74.91	74.95	16218346.0
2008-01-02 15:00:00	IWM	ETF	74.94	75.21	74.59	75.08	19302861.0
2008-01-02 16:00:00	IWM	ETF	75.08	75.4	75.0	75.33	2219310.0
2008-01-02 17:00:00	IWM	ETF	75.31	75.39	75.31	75.39	1400.0
2008-01-02 18:00:00	IWM	ETF	75.3	75.33	75.3	75.33	6000.0
2008-01-02 07:00:00	DIA	ETF	131.93	132.6	131.93	132.6	200.0
2008-01-02 08:00:00	DIA	ETF	132.55	132.71	132.55	132.69	37100.0
2008-01-02 09:00:00	DIA	ETF	132.69	132.7	132.39	132.5	1142160.0
2008-01-02 10:00:00	DIA	ETF	132.5	132.5	131.26	131.35	2489480.0
2008-01-02 11:00:00	DIA	ETF	131.35	131.5	130.73	131.02	1935466.0
2008-01-02 12:00:00	DIA	ETF	131.01	131.01	130.35	130.51	1565380.0
2008-01-02 13:00:00	DIA	ETF	130.51	130.61	130.08	130.37	1377353.0
2008-01-02 14:00:00	DIA	ETF	130.39	131.07	130.22	130.26	3465305.0
2008-01-02 15:00:00	DIA	ETF	130.23	130.45	129.82	130.38	2673919.0
2008-01-02 16:00:00	DIA	ETF	130.42	130.76	130.41	130.74	120600.0

> showing 50 of 3,224 rows — these rows as CSV

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