PREVIEW / etf_1hour / 2011-06-02

all etf 1-hour files

  file:    by_date/etf_1hour/2011/2011-06-02.parquet
  size:    179 KB
  rows:    5,464

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
2011-06-02 04:00:00	SPY	ETF	131.83	131.9	131.63	131.9	2000.0
2011-06-02 05:00:00	SPY	ETF	131.9	132.09	131.88	132.09	3300.0
2011-06-02 06:00:00	SPY	ETF	132.14	132.26	132.09	132.12	69490.0
2011-06-02 07:00:00	SPY	ETF	132.14	132.18	131.79	131.84	425672.0
2011-06-02 08:00:00	SPY	ETF	131.85	132.1754	131.78	131.98	2000071.0
2011-06-02 09:00:00	SPY	ETF	131.99	132.24	131.361	131.94	33553288.0
2011-06-02 10:00:00	SPY	ETF	131.94	132.22	131.75	131.9	27513246.0
2011-06-02 11:00:00	SPY	ETF	131.9	132.0	130.96	131.2984	31196071.0
2011-06-02 12:00:00	SPY	ETF	131.3	131.74	131.11	131.62	16985743.0
2011-06-02 13:00:00	SPY	ETF	131.62	131.97	131.52	131.92	20761929.0
2011-06-02 14:00:00	SPY	ETF	131.92	132.14	131.59	132.09	19434989.0
2011-06-02 15:00:00	SPY	ETF	132.09	132.16	131.6	131.7	26212994.0
2011-06-02 16:00:00	SPY	ETF	131.71	131.84	131.68	131.81	14356920.0
2011-06-02 17:00:00	SPY	ETF	131.81	131.85	131.72	131.77	285260.0
2011-06-02 18:00:00	SPY	ETF	131.77	131.77	131.64	131.64	112241.0
2011-06-02 19:00:00	SPY	ETF	131.63	131.68	131.6	131.64	61692.0
2011-06-02 05:00:00	QQQ	ETF	57.12	57.21	57.12	57.21	500.0
2011-06-02 06:00:00	QQQ	ETF	57.28	57.3	57.2	57.3	4675.0
2011-06-02 07:00:00	QQQ	ETF	57.23	57.27	57.13	57.15	38607.0
2011-06-02 08:00:00	QQQ	ETF	57.13	57.23	57.06	57.19	233784.0
2011-06-02 09:00:00	QQQ	ETF	57.2	57.3	56.99	57.26	7513527.0
2011-06-02 10:00:00	QQQ	ETF	57.26	57.41	57.19	57.3	8129297.0
2011-06-02 11:00:00	QQQ	ETF	57.3	57.32	56.89	57.0414	6888954.0
2011-06-02 12:00:00	QQQ	ETF	57.05	57.17	56.97	57.13	4103129.0
2011-06-02 13:00:00	QQQ	ETF	57.14	57.26	57.09	57.23	4236434.0
2011-06-02 14:00:00	QQQ	ETF	57.23	57.31	57.12	57.3011	5104701.0
2011-06-02 15:00:00	QQQ	ETF	57.31	57.34	57.14	57.2	5600125.0
2011-06-02 16:00:00	QQQ	ETF	57.21	57.24	57.15	57.21	1836949.0
2011-06-02 17:00:00	QQQ	ETF	57.22	57.22	57.19	57.19	3007.0
2011-06-02 18:00:00	QQQ	ETF	57.19	57.19	57.16	57.16	23891.0
2011-06-02 19:00:00	QQQ	ETF	57.15	57.17	57.15	57.17	7771.0
2011-06-02 04:00:00	IWM	ETF	82.28	82.28	82.28	82.28	300.0
2011-06-02 05:00:00	IWM	ETF	82.24	82.24	82.24	82.24	200.0
2011-06-02 06:00:00	IWM	ETF	82.4	82.49	82.34	82.34	3475.0
2011-06-02 07:00:00	IWM	ETF	82.25	82.3	82.12	82.17	10800.0
2011-06-02 08:00:00	IWM	ETF	82.15	82.43	82.14	82.33	870646.0
2011-06-02 09:00:00	IWM	ETF	82.34	82.65	81.95	82.46	10172702.0
2011-06-02 10:00:00	IWM	ETF	82.46	82.66	82.04	82.29	11169187.0
2011-06-02 11:00:00	IWM	ETF	82.28	82.33	81.6	81.85	8228313.0
2011-06-02 12:00:00	IWM	ETF	81.84	82.1401	81.62	82.0916	5629688.0
2011-06-02 13:00:00	IWM	ETF	82.1	82.3275	81.86	82.18	5811203.0
2011-06-02 14:00:00	IWM	ETF	82.18	82.29	81.84	82.28	5300621.0
2011-06-02 15:00:00	IWM	ETF	82.28	82.36	81.91	82.07	6287012.0
2011-06-02 16:00:00	IWM	ETF	82.07	82.13	82.0	82.12	1050065.0
2011-06-02 17:00:00	IWM	ETF	82.1325	82.15	82.07	82.07	2022508.0
2011-06-02 18:00:00	IWM	ETF	82.09	82.09	82.07	82.08	3375.0
2011-06-02 19:00:00	IWM	ETF	82.05	82.07	82.04	82.07	1400.0
2011-06-02 04:00:00	DIA	ETF	122.73	122.81	122.73	122.81	5300.0
2011-06-02 05:00:00	DIA	ETF	122.81	122.89	122.81	122.89	7200.0
2011-06-02 06:00:00	DIA	ETF	122.91	123.01	122.91	123.01	12000.0

> showing 50 of 5,464 rows — these rows as CSV

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