PREVIEW / etf_1hour / 2017-03-02

all etf 1-hour files

  file:    by_date/etf_1hour/2017/2017-03-02.parquet
  size:    280 KB
  rows:    9,000

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
2017-03-02 04:00:00	SPY	ETF	239.45	239.45	239.23	239.33	11126.0
2017-03-02 05:00:00	SPY	ETF	239.28	239.46	239.28	239.4	9933.0
2017-03-02 06:00:00	SPY	ETF	239.37	239.37	239.25	239.35	28487.0
2017-03-02 07:00:00	SPY	ETF	239.38	239.51	239.36	239.49	207077.0
2017-03-02 08:00:00	SPY	ETF	239.48	239.73	239.4	239.64	456611.0
2017-03-02 09:00:00	SPY	ETF	239.61	239.63	239.07	239.38	8371551.0
2017-03-02 10:00:00	SPY	ETF	239.38	239.38	238.99	239.05	7611063.0
2017-03-02 11:00:00	SPY	ETF	239.05	239.05	238.55	238.96	8823781.0
2017-03-02 12:00:00	SPY	ETF	238.96	238.99	238.6301	238.85	4731214.0
2017-03-02 13:00:00	SPY	ETF	238.85	238.94	238.7	238.83	4752466.0
2017-03-02 14:00:00	SPY	ETF	238.84	239.08	238.65	238.95	6421048.0
2017-03-02 15:00:00	SPY	ETF	238.955	238.955	238.21	238.33	19512780.0
2017-03-02 16:00:00	SPY	ETF	238.32	238.7316	238.11	238.39	6327295.0
2017-03-02 17:00:00	SPY	ETF	238.37	238.37	238.27	238.29	66695.0
2017-03-02 18:00:00	SPY	ETF	238.27	238.33	238.16	238.23	48810.0
2017-03-02 19:00:00	SPY	ETF	238.26	238.31	238.15	238.16	39018.0
2017-03-02 04:00:00	QQQ	ETF	131.34	131.34	131.3	131.3	1000.0
2017-03-02 06:00:00	QQQ	ETF	131.25	131.3	131.25	131.27	980.0
2017-03-02 07:00:00	QQQ	ETF	131.33	131.35	131.33	131.35	17099.0
2017-03-02 08:00:00	QQQ	ETF	131.41	131.53	131.38	131.51	47767.0
2017-03-02 09:00:00	QQQ	ETF	131.5	131.51	131.16	131.36	2133253.0
2017-03-02 10:00:00	QQQ	ETF	131.35	131.37	131.06	131.07	1679273.0
2017-03-02 11:00:00	QQQ	ETF	131.07	131.11	130.83	131.06	2029784.0
2017-03-02 12:00:00	QQQ	ETF	131.06	131.07	130.83	130.97	1074036.0
2017-03-02 13:00:00	QQQ	ETF	130.97	130.99	130.85	130.95	1336065.0
2017-03-02 14:00:00	QQQ	ETF	130.95	131.07	130.88	131.03	1843779.0
2017-03-02 15:00:00	QQQ	ETF	131.02	131.025	130.62	130.78	3435635.0
2017-03-02 16:00:00	QQQ	ETF	130.79	130.86	130.65	130.71	609319.0
2017-03-02 17:00:00	QQQ	ETF	130.75	130.75	130.67	130.67	2867.0
2017-03-02 18:00:00	QQQ	ETF	130.67	130.7	130.67	130.7	1473.0
2017-03-02 19:00:00	QQQ	ETF	130.71	130.73	130.67	130.67	2800.0
2017-03-02 04:00:00	IWM	ETF	140.6	140.6	140.25	140.25	4200.0
2017-03-02 05:00:00	IWM	ETF	140.25	140.25	140.25	140.25	1000.0
2017-03-02 06:00:00	IWM	ETF	140.28	140.28	140.2	140.27	6500.0
2017-03-02 07:00:00	IWM	ETF	140.31	140.43	140.31	140.4	17600.0
2017-03-02 08:00:00	IWM	ETF	140.4	140.61	140.4	140.54	49561.0
2017-03-02 09:00:00	IWM	ETF	140.52	140.52	139.74	140.15	1966081.0
2017-03-02 10:00:00	IWM	ETF	140.15	140.17	139.78	139.92	2135829.0
2017-03-02 11:00:00	IWM	ETF	139.91	139.95	139.23	139.66	3777470.0
2017-03-02 12:00:00	IWM	ETF	139.67	139.71	139.33	139.55	1492463.0
2017-03-02 13:00:00	IWM	ETF	139.54	139.61	139.3	139.56	2226319.0
2017-03-02 14:00:00	IWM	ETF	139.57	139.67	139.3	139.419	2248045.0
2017-03-02 15:00:00	IWM	ETF	139.415	139.44	138.64	138.79	6986401.0
2017-03-02 16:00:00	IWM	ETF	138.79	138.83	138.56	138.65	1215123.0
2017-03-02 17:00:00	IWM	ETF	138.67	138.67	138.6	138.6	2972.0
2017-03-02 18:00:00	IWM	ETF	138.57	138.75	138.57	138.75	4221.0
2017-03-02 19:00:00	IWM	ETF	138.73	138.75	138.65	138.65	7606.0
2017-03-02 08:00:00	DIA	ETF	211.08	211.44	211.08	211.18	4478.0
2017-03-02 09:00:00	DIA	ETF	211.18	211.29	210.71	211.09	701203.0
2017-03-02 10:00:00	DIA	ETF	211.08	211.081	210.81	210.81	299082.0

> showing 50 of 9,000 rows — these rows as CSV

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