PREVIEW / etf_1hour / 2016-10-20

all etf 1-hour files

  file:    by_date/etf_1hour/2016/2016-10-20.parquet
  size:    249 KB
  rows:    8,017

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-20 04:00:00	SPY	ETF	214.33	214.39	214.29	214.29	10103.0
2016-10-20 05:00:00	SPY	ETF	214.28	214.44	214.28	214.41	4979.0
2016-10-20 06:00:00	SPY	ETF	214.46	214.51	214.43	214.46	25904.0
2016-10-20 07:00:00	SPY	ETF	214.46	214.47	214.28	214.38	295180.0
2016-10-20 08:00:00	SPY	ETF	214.38	214.611	213.62	213.96	1183371.0
2016-10-20 09:00:00	SPY	ETF	213.95	214.18	213.52	214.14	10588544.0
2016-10-20 10:00:00	SPY	ETF	214.132	214.53	213.11	213.3367	16504683.0
2016-10-20 11:00:00	SPY	ETF	213.33	213.945	213.2	213.93	8597142.0
2016-10-20 12:00:00	SPY	ETF	213.93	214.42	213.8779	214.16	8506814.0
2016-10-20 13:00:00	SPY	ETF	214.16	214.3	213.639	213.8	6650773.0
2016-10-20 14:00:00	SPY	ETF	213.805	214.239	213.78	214.1	4947855.0
2016-10-20 15:00:00	SPY	ETF	214.0999	214.24	213.79	213.89	11639728.0
2016-10-20 16:00:00	SPY	ETF	213.9	214.17	213.88	214.08	3826311.0
2016-10-20 17:00:00	SPY	ETF	214.1	214.14	214.04	214.05	68284.0
2016-10-20 18:00:00	SPY	ETF	214.04	214.11	213.9	214.1	65552.0
2016-10-20 19:00:00	SPY	ETF	214.1	214.24	214.06	214.15	76420.0
2016-10-20 06:00:00	QQQ	ETF	117.93	117.93	117.93	117.93	100.0
2016-10-20 07:00:00	QQQ	ETF	117.98	117.98	117.93	117.93	75528.0
2016-10-20 08:00:00	QQQ	ETF	117.93	117.93	117.58	117.7	106274.0
2016-10-20 09:00:00	QQQ	ETF	117.7	117.76	117.24	117.66	2476177.0
2016-10-20 10:00:00	QQQ	ETF	117.66	117.97	117.03	117.21	3351383.0
2016-10-20 11:00:00	QQQ	ETF	117.22	117.54	117.12	117.54	1648853.0
2016-10-20 12:00:00	QQQ	ETF	117.54	117.94	117.49	117.8	2631291.0
2016-10-20 13:00:00	QQQ	ETF	117.79	117.83	117.37	117.45	1600274.0
2016-10-20 14:00:00	QQQ	ETF	117.44	117.907	117.44	117.8	1175006.0
2016-10-20 15:00:00	QQQ	ETF	117.81	117.89	117.65	117.71	2287932.0
2016-10-20 16:00:00	QQQ	ETF	117.71	118.19	117.5857	118.13	936170.0
2016-10-20 17:00:00	QQQ	ETF	118.13	118.21	118.11	118.18	26718.0
2016-10-20 18:00:00	QQQ	ETF	118.14	118.15	118.08	118.1	19085.0
2016-10-20 19:00:00	QQQ	ETF	118.14	118.24	118.14	118.19	8895.0
2016-10-20 07:00:00	IWM	ETF	121.61	121.65	121.6	121.61	9694.0
2016-10-20 08:00:00	IWM	ETF	121.61	121.61	121.07	121.17	75194.0
2016-10-20 09:00:00	IWM	ETF	121.19	121.44	120.79	121.38	2498070.0
2016-10-20 10:00:00	IWM	ETF	121.379	121.585	120.41	120.595	3960056.0
2016-10-20 11:00:00	IWM	ETF	120.58	121.06	120.54	120.91	2247541.0
2016-10-20 12:00:00	IWM	ETF	120.91	122.0	120.83	121.335	2990765.0
2016-10-20 13:00:00	IWM	ETF	121.33	121.56	120.95	121.04	2017643.0
2016-10-20 14:00:00	IWM	ETF	121.04	121.4255	121.03	121.34	1070940.0
2016-10-20 15:00:00	IWM	ETF	121.35	121.385	121.1	121.14	2933965.0
2016-10-20 16:00:00	IWM	ETF	121.13	121.39	120.6444	121.31	803670.0
2016-10-20 17:00:00	IWM	ETF	121.29	121.3	121.27	121.3	795.0
2016-10-20 18:00:00	IWM	ETF	121.28	121.29	121.21	121.29	5699.0
2016-10-20 19:00:00	IWM	ETF	121.33	121.33	121.33	121.33	500.0
2016-10-20 08:00:00	DIA	ETF	182.15	182.25	181.58	181.72	5500.0
2016-10-20 09:00:00	DIA	ETF	181.79	182.1	181.47	182.09	384759.0
2016-10-20 10:00:00	DIA	ETF	182.14	182.45	181.22	181.43	476176.0
2016-10-20 11:00:00	DIA	ETF	181.44	181.97	181.32	181.97	224167.0
2016-10-20 12:00:00	DIA	ETF	181.97	182.31	181.93	182.07	187547.0
2016-10-20 13:00:00	DIA	ETF	182.05	182.14	181.49	181.63	192234.0
2016-10-20 14:00:00	DIA	ETF	181.62	181.94	181.62	181.8275	224890.0

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

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