PREVIEW / etf_1hour / 2016-04-19

all etf 1-hour files

  file:    by_date/etf_1hour/2016/2016-04-19.parquet
  size:    255 KB
  rows:    8,153

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
2016-04-19 04:00:00	SPY	ETF	209.83	210.05	209.83	210.03	38540.0
2016-04-19 05:00:00	SPY	ETF	210.04	210.25	209.97	210.17	25347.0
2016-04-19 06:00:00	SPY	ETF	210.21	210.23	209.97	210.06	44724.0
2016-04-19 07:00:00	SPY	ETF	210.06	210.15	209.9	210.1	526067.0
2016-04-19 08:00:00	SPY	ETF	210.09	210.09	209.04	209.85	823874.0
2016-04-19 09:00:00	SPY	ETF	209.85	210.0	209.47	209.98	11148490.0
2016-04-19 10:00:00	SPY	ETF	209.98	210.2	209.72	210.06	14340997.0
2016-04-19 11:00:00	SPY	ETF	210.06	210.17	209.3	209.315	9035849.0
2016-04-19 12:00:00	SPY	ETF	209.315	209.395	208.94	209.3199	11517283.0
2016-04-19 13:00:00	SPY	ETF	209.31	209.72	209.27	209.67	8061569.0
2016-04-19 14:00:00	SPY	ETF	209.68	209.83	209.49	209.57	8666521.0
2016-04-19 15:00:00	SPY	ETF	209.56	209.9	209.45	209.87	13858607.0
2016-04-19 16:00:00	SPY	ETF	209.88	209.98	209.43	209.84	3010888.0
2016-04-19 17:00:00	SPY	ETF	209.83	209.85	209.76	209.82	136306.0
2016-04-19 18:00:00	SPY	ETF	209.82	209.82	209.54	209.58	215700.0
2016-04-19 19:00:00	SPY	ETF	209.64	209.64	209.48	209.53	67117.0
2016-04-19 04:00:00	QQQ	ETF	111.53	111.55	111.53	111.55	261.0
2016-04-19 05:00:00	QQQ	ETF	111.65	111.77	111.64	111.77	11720.0
2016-04-19 06:00:00	QQQ	ETF	111.75	111.77	111.66	111.66	8246.0
2016-04-19 07:00:00	QQQ	ETF	111.66	111.74	111.57	111.72	107484.0
2016-04-19 08:00:00	QQQ	ETF	111.62	111.7	111.49	111.51	312679.0
2016-04-19 09:00:00	QQQ	ETF	111.53	111.54	110.52	110.68	6089126.0
2016-04-19 10:00:00	QQQ	ETF	110.67	111.02	110.581	110.86	8107636.0
2016-04-19 11:00:00	QQQ	ETF	110.8501	110.895	110.17	110.1805	2916027.0
2016-04-19 12:00:00	QQQ	ETF	110.19	110.27	109.88	110.2601	3616056.0
2016-04-19 13:00:00	QQQ	ETF	110.26	110.5899	110.22	110.56	1773893.0
2016-04-19 14:00:00	QQQ	ETF	110.55	110.66	110.34	110.39	2287164.0
2016-04-19 15:00:00	QQQ	ETF	110.38	110.62	110.27	110.53	5762874.0
2016-04-19 16:00:00	QQQ	ETF	110.53	110.71	110.4	110.51	1844329.0
2016-04-19 17:00:00	QQQ	ETF	110.5	110.6	110.49	110.51	11350.0
2016-04-19 18:00:00	QQQ	ETF	110.5	110.51	110.38	110.38	81011.0
2016-04-19 19:00:00	QQQ	ETF	110.42	110.42	110.33	110.35	15313.0
2016-04-19 04:00:00	IWM	ETF	113.78	113.78	113.71	113.71	700.0
2016-04-19 05:00:00	IWM	ETF	113.89	113.93	113.89	113.93	200.0
2016-04-19 07:00:00	IWM	ETF	113.8	113.81	113.71	113.79	13997.0
2016-04-19 08:00:00	IWM	ETF	113.82	113.83	113.59	113.6	200279.0
2016-04-19 09:00:00	IWM	ETF	113.6	113.91	113.35	113.91	2265112.0
2016-04-19 10:00:00	IWM	ETF	113.9	114.125	113.6	113.83	2866723.0
2016-04-19 11:00:00	IWM	ETF	113.85	113.875	113.17	113.1799	2290540.0
2016-04-19 12:00:00	IWM	ETF	113.18	113.25	112.89	113.15	2955861.0
2016-04-19 13:00:00	IWM	ETF	113.14	113.39	113.09	113.351	1344493.0
2016-04-19 14:00:00	IWM	ETF	113.36	113.435	113.26	113.335	1546086.0
2016-04-19 15:00:00	IWM	ETF	113.335	113.5	113.25	113.37	3525157.0
2016-04-19 16:00:00	IWM	ETF	113.37	113.48	113.36	113.42	1385225.0
2016-04-19 17:00:00	IWM	ETF	113.42	113.42	113.42	113.42	1000.0
2016-04-19 18:00:00	IWM	ETF	113.42	113.42	113.32	113.36	1244.0
2016-04-19 19:00:00	IWM	ETF	113.35	113.35	113.29	113.29	4500.0
2016-04-19 07:00:00	DIA	ETF	180.49	180.5	180.28	180.28	3020.0
2016-04-19 08:00:00	DIA	ETF	180.41	180.42	180.25	180.26	3366.0
2016-04-19 09:00:00	DIA	ETF	180.26	180.6259	179.9938	180.58	1001887.0

> showing 50 of 8,153 rows — these rows as CSV

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