PREVIEW / etf_1hour / 2006-05-02

all etf 1-hour files

  file:    by_date/etf_1hour/2006/2006-05-02.parquet
  size:    41 KB
  rows:    1,291

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
2006-05-02 04:00:00	SPY	ETF	130.84	130.84	130.84	130.84	300.0
2006-05-02 05:00:00	SPY	ETF	130.93	130.93	130.93	130.93	9100.0
2006-05-02 07:00:00	SPY	ETF	130.88	130.89	130.81	130.84	248500.0
2006-05-02 08:00:00	SPY	ETF	130.84	131.42	130.82	130.95	1952000.0
2006-05-02 09:00:00	SPY	ETF	130.95	131.1	130.07	130.93	7524800.0
2006-05-02 10:00:00	SPY	ETF	130.95	131.22	130.74	130.95	10139800.0
2006-05-02 11:00:00	SPY	ETF	130.95	131.15	130.8	131.05	4856300.0
2006-05-02 12:00:00	SPY	ETF	131.04	131.38	131.01	131.3	6521200.0
2006-05-02 13:00:00	SPY	ETF	131.28	131.46	131.21	131.28	4556100.0
2006-05-02 14:00:00	SPY	ETF	131.28	131.37	131.06	131.16	3890100.0
2006-05-02 15:00:00	SPY	ETF	131.17	131.42	131.13	131.38	5249800.0
2006-05-02 16:00:00	SPY	ETF	131.37	131.43	131.35	131.39	938100.0
2006-05-02 17:00:00	SPY	ETF	131.41	131.42	131.37	131.39	8100.0
2006-05-02 18:00:00	SPY	ETF	131.42	131.42	131.32	131.32	24200.0
2006-05-02 19:00:00	SPY	ETF	131.35	131.37	131.35	131.37	4000.0
2006-05-02 09:00:00	QQQ	ETF	41.61	41.67	41.4	41.55	12815000.0
2006-05-02 10:00:00	QQQ	ETF	41.55	41.73	41.46	41.56	21264100.0
2006-05-02 11:00:00	QQQ	ETF	41.56	41.58	41.48	41.53	7003100.0
2006-05-02 12:00:00	QQQ	ETF	41.52	41.66	41.5	41.6	5814500.0
2006-05-02 13:00:00	QQQ	ETF	41.59	41.68	41.56	41.59	5585700.0
2006-05-02 14:00:00	QQQ	ETF	41.59	41.63	41.49	41.55	9570000.0
2006-05-02 15:00:00	QQQ	ETF	41.55	41.59	41.52	41.54	11949400.0
2006-05-02 07:00:00	IWM	ETF	73.13	75.5	73.13	75.5	2100.0
2006-05-02 08:00:00	IWM	ETF	75.58	75.66	75.52	75.59	69000.0
2006-05-02 09:00:00	IWM	ETF	75.61	75.89	75.51	75.71	4633200.0
2006-05-02 10:00:00	IWM	ETF	75.71	75.89	75.41	75.61	4638300.0
2006-05-02 11:00:00	IWM	ETF	75.61	75.79	75.5025	75.69	2133200.0
2006-05-02 12:00:00	IWM	ETF	75.68	76.03	75.66	76.0	2392400.0
2006-05-02 13:00:00	IWM	ETF	75.99	76.15	75.96	76.12	1921700.0
2006-05-02 14:00:00	IWM	ETF	76.12	76.22	75.95	76.02	4087800.0
2006-05-02 15:00:00	IWM	ETF	76.02	76.3	76.0	76.24	7084700.0
2006-05-02 16:00:00	IWM	ETF	76.26	76.34	76.25	76.32	5142100.0
2006-05-02 17:00:00	IWM	ETF	76.25	76.25	76.25	76.25	480000.0
2006-05-02 18:00:00	IWM	ETF	76.31	76.31	76.31	76.31	300.0
2006-05-02 08:00:00	DIA	ETF	113.6	113.7	113.59	113.67	53700.0
2006-05-02 09:00:00	DIA	ETF	113.67	113.8	113.53	113.64	482000.0
2006-05-02 10:00:00	DIA	ETF	113.65	113.92	113.55	113.76	973700.0
2006-05-02 11:00:00	DIA	ETF	113.77	114.01	113.7	113.93	1963100.0
2006-05-02 12:00:00	DIA	ETF	113.93	114.14	113.89	114.05	775800.0
2006-05-02 13:00:00	DIA	ETF	114.03	114.2	114.0	114.06	476300.0
2006-05-02 14:00:00	DIA	ETF	114.06	114.13	113.92	113.98	616900.0
2006-05-02 15:00:00	DIA	ETF	113.97	114.14	113.9	114.1	634200.0
2006-05-02 16:00:00	DIA	ETF	114.09	114.2	114.08	114.13	37900.0
2006-05-02 17:00:00	DIA	ETF	114.04	114.04	114.04	114.04	100.0
2006-05-02 08:00:00	GLD	ETF	65.19	65.84	65.19	65.61	107900.0
2006-05-02 09:00:00	GLD	ETF	65.55	65.84	65.43	65.66	776900.0
2006-05-02 10:00:00	GLD	ETF	65.64	66.27	65.63	66.14	1428800.0
2006-05-02 11:00:00	GLD	ETF	66.16	66.22	65.99	66.16	797400.0
2006-05-02 12:00:00	GLD	ETF	66.1547	66.19	65.89	66.11	1118200.0
2006-05-02 13:00:00	GLD	ETF	66.08	66.35	66.08	66.19	618200.0

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

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