PREVIEW / etf_1hour / 2016-10-19

all etf 1-hour files

  file:    by_date/etf_1hour/2016/2016-10-19.parquet
  size:    254 KB
  rows:    8,185

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-10-19 04:00:00	SPY	ETF	213.32	213.48	213.22	213.48	209740.0
2016-10-19 05:00:00	SPY	ETF	213.53	213.53	213.38	213.5	8357.0
2016-10-19 06:00:00	SPY	ETF	213.47	213.71	213.47	213.62	7757.0
2016-10-19 07:00:00	SPY	ETF	213.68	213.79	213.53	213.64	423071.0
2016-10-19 08:00:00	SPY	ETF	213.56	214.05	213.508	213.97	831360.0
2016-10-19 09:00:00	SPY	ETF	214.01	214.08	213.65	213.76	7830713.0
2016-10-19 10:00:00	SPY	ETF	213.76	214.484	213.6	214.42	12441188.0
2016-10-19 11:00:00	SPY	ETF	214.42	214.44	214.16	214.24	6257509.0
2016-10-19 12:00:00	SPY	ETF	214.23	214.51	214.17	214.43	3686097.0
2016-10-19 13:00:00	SPY	ETF	214.43	214.61	214.41	214.52	4684653.0
2016-10-19 14:00:00	SPY	ETF	214.515	214.64	214.3	214.43	4929378.0
2016-10-19 15:00:00	SPY	ETF	214.42	214.59	214.19	214.25	12974051.0
2016-10-19 16:00:00	SPY	ETF	214.26	214.33	214.16	214.19	6720361.0
2016-10-19 17:00:00	SPY	ETF	214.2	214.22	214.13	214.15	46032.0
2016-10-19 18:00:00	SPY	ETF	214.15	214.21	214.06	214.2	90091.0
2016-10-19 19:00:00	SPY	ETF	214.19	214.35	214.19	214.3	475174.0
2016-10-19 04:00:00	QQQ	ETF	117.45	117.51	117.41	117.49	26197.0
2016-10-19 05:00:00	QQQ	ETF	117.48	117.5	117.48	117.5	1000.0
2016-10-19 06:00:00	QQQ	ETF	117.48	117.59	117.48	117.59	14798.0
2016-10-19 07:00:00	QQQ	ETF	117.58	117.66	117.55	117.61	83496.0
2016-10-19 08:00:00	QQQ	ETF	117.6	117.84	117.58	117.78	109671.0
2016-10-19 09:00:00	QQQ	ETF	117.79	117.89	117.64	117.75	2532838.0
2016-10-19 10:00:00	QQQ	ETF	117.76	118.02	117.69	117.96	3204133.0
2016-10-19 11:00:00	QQQ	ETF	117.9656	117.9656	117.71	117.71	1633701.0
2016-10-19 12:00:00	QQQ	ETF	117.7	117.88	117.65	117.86	1082158.0
2016-10-19 13:00:00	QQQ	ETF	117.87	117.97	117.83	117.9	795244.0
2016-10-19 14:00:00	QQQ	ETF	117.91	117.9848	117.8	117.8575	849314.0
2016-10-19 15:00:00	QQQ	ETF	117.87	117.98	117.8	117.83	2347606.0
2016-10-19 16:00:00	QQQ	ETF	117.84	117.85	117.74	117.79	645649.0
2016-10-19 17:00:00	QQQ	ETF	117.8	117.8	117.73	117.77	9494.0
2016-10-19 18:00:00	QQQ	ETF	117.77	117.77	117.73	117.77	7841.0
2016-10-19 19:00:00	QQQ	ETF	117.8	117.84	117.79	117.8	6292.0
2016-10-19 06:00:00	IWM	ETF	120.95	120.95	120.95	120.95	110.0
2016-10-19 07:00:00	IWM	ETF	120.92	121.0	120.89	120.98	4724.0
2016-10-19 08:00:00	IWM	ETF	121.03	121.26	121.03	121.23	83821.0
2016-10-19 09:00:00	IWM	ETF	121.24	121.24	120.69	120.77	2034936.0
2016-10-19 10:00:00	IWM	ETF	120.77	121.31	120.5001	121.22	3627042.0
2016-10-19 11:00:00	IWM	ETF	121.23	121.94	121.06	121.61	3681382.0
2016-10-19 12:00:00	IWM	ETF	121.62	121.9	121.53	121.78	1403565.0
2016-10-19 13:00:00	IWM	ETF	121.79	121.92	121.69	121.775	1139632.0
2016-10-19 14:00:00	IWM	ETF	121.775	121.95	121.54	121.64	1893026.0
2016-10-19 15:00:00	IWM	ETF	121.65	121.79	121.43	121.46	3084276.0
2016-10-19 16:00:00	IWM	ETF	121.49	121.49	121.34	121.41	620851.0
2016-10-19 17:00:00	IWM	ETF	121.4	121.4	121.37	121.37	514.0
2016-10-19 18:00:00	IWM	ETF	121.37	121.41	121.37	121.38	1054.0
2016-10-19 19:00:00	IWM	ETF	121.41	121.58	121.4	121.43	1784.0
2016-10-19 04:00:00	DIA	ETF	181.1	181.1	181.1	181.1	100.0
2016-10-19 07:00:00	DIA	ETF	181.5	181.5	181.5	181.5	100.0
2016-10-19 09:00:00	DIA	ETF	181.73	181.93	181.57	181.66	259030.0
2016-10-19 10:00:00	DIA	ETF	181.6601	182.34	181.57	182.24	288138.0

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

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