PREVIEW / etf_1hour / 2016-05-31

all etf 1-hour files

  file:    by_date/etf_1hour/2016/2016-05-31.parquet
  size:    254 KB
  rows:    8,184

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-05-31 04:00:00	SPY	ETF	210.17	210.31	210.1	210.21	17139.0
2016-05-31 05:00:00	SPY	ETF	210.19	210.37	210.19	210.37	9736.0
2016-05-31 06:00:00	SPY	ETF	210.4	210.43	210.26	210.26	14064.0
2016-05-31 07:00:00	SPY	ETF	210.36	210.61	210.27	210.58	136201.0
2016-05-31 08:00:00	SPY	ETF	210.59	210.63	210.32	210.54	433941.0
2016-05-31 09:00:00	SPY	ETF	210.54	210.64	210.29	210.3908	7614520.0
2016-05-31 10:00:00	SPY	ETF	210.4	210.69	210.11	210.27	12036471.0
2016-05-31 11:00:00	SPY	ETF	210.25	210.265	209.78	209.85	11272381.0
2016-05-31 12:00:00	SPY	ETF	209.85	209.87	209.65	209.745	7082888.0
2016-05-31 13:00:00	SPY	ETF	209.74	210.01	209.62	209.788	6611360.0
2016-05-31 14:00:00	SPY	ETF	209.78	209.78	209.21	209.3	10968774.0
2016-05-31 15:00:00	SPY	ETF	209.305	210.27	209.18	209.9	27943273.0
2016-05-31 16:00:00	SPY	ETF	209.89	210.1465	209.62	209.99	20570579.0
2016-05-31 17:00:00	SPY	ETF	209.97	210.08	209.86	209.92	206541.0
2016-05-31 18:00:00	SPY	ETF	209.93	210.09	209.87	210.09	160558.0
2016-05-31 19:00:00	SPY	ETF	210.07	210.1	209.9666	210.08	45268.0
2016-05-31 04:00:00	QQQ	ETF	110.26	110.3	110.26	110.26	1197.0
2016-05-31 05:00:00	QQQ	ETF	110.29	110.29	110.28	110.28	7040.0
2016-05-31 06:00:00	QQQ	ETF	110.26	110.26	110.23	110.23	500.0
2016-05-31 07:00:00	QQQ	ETF	110.21	110.25	110.15	110.24	30941.0
2016-05-31 08:00:00	QQQ	ETF	110.26	110.3	110.23	110.27	26451.0
2016-05-31 09:00:00	QQQ	ETF	110.31	110.42	110.18	110.3001	2180168.0
2016-05-31 10:00:00	QQQ	ETF	110.31	110.5	110.1665	110.32	2162958.0
2016-05-31 11:00:00	QQQ	ETF	110.31	110.325	110.13	110.18	1860336.0
2016-05-31 12:00:00	QQQ	ETF	110.18	110.18	110.02	110.1	1148502.0
2016-05-31 13:00:00	QQQ	ETF	110.0911	110.32	110.06	110.21	1489847.0
2016-05-31 14:00:00	QQQ	ETF	110.215	110.215	109.84	109.8864	1897995.0
2016-05-31 15:00:00	QQQ	ETF	109.88	110.51	109.7837	110.36	8694604.0
2016-05-31 16:00:00	QQQ	ETF	110.38	110.45	110.23	110.41	1268723.0
2016-05-31 17:00:00	QQQ	ETF	110.37	110.37	110.19	110.28	55121.0
2016-05-31 18:00:00	QQQ	ETF	110.34	110.43	110.3	110.43	265671.0
2016-05-31 19:00:00	QQQ	ETF	110.44	110.44	110.4	110.41	14696.0
2016-05-31 07:00:00	IWM	ETF	114.64	114.73	114.64	114.73	5975.0
2016-05-31 08:00:00	IWM	ETF	114.73	114.78	114.71	114.77	30053.0
2016-05-31 09:00:00	IWM	ETF	114.8	115.0199	114.71	114.71	1849554.0
2016-05-31 10:00:00	IWM	ETF	114.7145	115.185	114.65	115.165	4710991.0
2016-05-31 11:00:00	IWM	ETF	115.16	115.27	114.84	115.029	3522873.0
2016-05-31 12:00:00	IWM	ETF	115.02	115.23	114.81	115.09	2030010.0
2016-05-31 13:00:00	IWM	ETF	115.09	115.54	115.04	115.2	2348274.0
2016-05-31 14:00:00	IWM	ETF	115.2	115.2	114.61	114.62	3294918.0
2016-05-31 15:00:00	IWM	ETF	114.62	115.2	114.5	114.95	5411823.0
2016-05-31 16:00:00	IWM	ETF	114.95	115.05	114.91	115.03	3734142.0
2016-05-31 17:00:00	IWM	ETF	115.0191	115.04	114.95	114.95	57576.0
2016-05-31 18:00:00	IWM	ETF	114.95	114.95	114.95	114.95	350.0
2016-05-31 19:00:00	IWM	ETF	114.96	114.96	114.96	114.96	1100.0
2016-05-31 07:00:00	DIA	ETF	178.84	178.84	178.84	178.84	1509.0
2016-05-31 08:00:00	DIA	ETF	178.77	178.85	178.77	178.83	535.0
2016-05-31 09:00:00	DIA	ETF	178.88	178.98	178.46	178.48	341779.0
2016-05-31 10:00:00	DIA	ETF	178.49	178.65	178.1	178.2	362906.0
2016-05-31 11:00:00	DIA	ETF	178.18	178.18	177.75	177.78	292237.0

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

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