PREVIEW / etf_1hour / 2010-06-02

all etf 1-hour files

  file:    by_date/etf_1hour/2010/2010-06-02.parquet
  size:    161 KB
  rows:    4,907

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
2010-06-02 04:00:00	SPY	ETF	107.86	107.95	107.44	107.63	37200.0
2010-06-02 05:00:00	SPY	ETF	107.66	108.24	107.66	108.15	7000.0
2010-06-02 06:00:00	SPY	ETF	108.1	108.18	107.75	108.0	132150.0
2010-06-02 07:00:00	SPY	ETF	108.15	108.19	107.9	108.08	981485.0
2010-06-02 08:00:00	SPY	ETF	108.1	108.1	107.7	107.83	2472422.0
2010-06-02 09:00:00	SPY	ETF	107.82	108.28	107.61	107.94	28611111.0
2010-06-02 10:00:00	SPY	ETF	107.94	108.57	107.8	108.29	39168990.0
2010-06-02 11:00:00	SPY	ETF	108.3	109.1	108.29	108.94	23434321.0
2010-06-02 12:00:00	SPY	ETF	108.94	109.14	108.83	109.07	13120166.0
2010-06-02 13:00:00	SPY	ETF	109.07	109.25	108.75	108.82	18064079.0
2010-06-02 14:00:00	SPY	ETF	108.82	109.58	108.5217	109.46	32365086.0
2010-06-02 15:00:00	SPY	ETF	109.46	110.34	109.45	110.31	57230325.0
2010-06-02 16:00:00	SPY	ETF	110.31	110.33	107.5093	110.3	17851218.0
2010-06-02 17:00:00	SPY	ETF	110.26	110.5	110.26	110.45	513397.0
2010-06-02 18:00:00	SPY	ETF	110.43	110.43	110.15	110.18	178946.0
2010-06-02 19:00:00	SPY	ETF	110.19	110.34	110.15	110.25	54247.0
2010-06-02 20:00:00	SPY	ETF	110.29	110.29	110.29	110.29	100.0
2010-06-02 04:00:00	QQQ	ETF	45.32	45.32	45.32	45.32	600.0
2010-06-02 05:00:00	QQQ	ETF	45.26	45.44	45.26	45.44	1200.0
2010-06-02 06:00:00	QQQ	ETF	45.38	45.45	45.35	45.4	2000.0
2010-06-02 07:00:00	QQQ	ETF	45.47	45.51	45.42	45.49	730992.0
2010-06-02 08:00:00	QQQ	ETF	45.47	45.48	45.31	45.34	924561.0
2010-06-02 09:00:00	QQQ	ETF	45.35	45.51	45.13	45.31	18343514.0
2010-06-02 10:00:00	QQQ	ETF	45.31	45.65	45.27	45.54	16802627.0
2010-06-02 11:00:00	QQQ	ETF	45.54	45.82	45.535	45.77	8297513.0
2010-06-02 12:00:00	QQQ	ETF	45.77	45.91	45.75	45.9	6139569.0
2010-06-02 13:00:00	QQQ	ETF	45.9	45.95	45.75	45.76	7290043.0
2010-06-02 14:00:00	QQQ	ETF	45.7601	45.985	45.58	45.95	9854366.0
2010-06-02 15:00:00	QQQ	ETF	45.94	46.28	45.78	46.26	17125497.0
2010-06-02 16:00:00	QQQ	ETF	46.26	46.27	45.1955	46.22	6297970.0
2010-06-02 17:00:00	QQQ	ETF	46.25	46.36	46.25	46.35	32883.0
2010-06-02 18:00:00	QQQ	ETF	46.34	46.34	46.23	46.23	38478.0
2010-06-02 19:00:00	QQQ	ETF	46.23	46.28	46.22	46.23	18490.0
2010-06-02 05:00:00	IWM	ETF	64.38	64.59	64.38	64.59	10100.0
2010-06-02 06:00:00	IWM	ETF	64.46	64.55	64.35	64.55	800.0
2010-06-02 07:00:00	IWM	ETF	64.6	64.61	64.36	64.53	124711.0
2010-06-02 08:00:00	IWM	ETF	64.53	64.56	64.33	64.34	1400146.0
2010-06-02 09:00:00	IWM	ETF	64.34	64.86	64.02	64.39	7872892.0
2010-06-02 10:00:00	IWM	ETF	64.38	64.98	64.27	64.73	8884625.0
2010-06-02 11:00:00	IWM	ETF	64.74	65.27	64.73	65.19	4933352.0
2010-06-02 12:00:00	IWM	ETF	65.19	65.49	65.17	65.48	5287708.0
2010-06-02 13:00:00	IWM	ETF	65.49	65.58	65.14	65.2	3974558.0
2010-06-02 14:00:00	IWM	ETF	65.2	65.62	64.92	65.54	6337605.0
2010-06-02 15:00:00	IWM	ETF	65.54	66.1	64.65	66.07	16185277.0
2010-06-02 16:00:00	IWM	ETF	66.07	66.1	64.1893	65.99	3229489.0
2010-06-02 17:00:00	IWM	ETF	66.03	66.13	66.03	66.1	172716.0
2010-06-02 18:00:00	IWM	ETF	66.06	66.18	65.62	66.15	17126.0
2010-06-02 19:00:00	IWM	ETF	66.08	66.13	66.0	66.12	2500.0
2010-06-02 07:00:00	DIA	ETF	100.92	100.92	100.77	100.8	2000.0
2010-06-02 08:00:00	DIA	ETF	100.83	100.85	100.6	100.67	9550.0

> showing 50 of 4,907 rows — these rows as CSV

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