PREVIEW / etf_1hour / 2016-09-29

all etf 1-hour files

  file:    by_date/etf_1hour/2016/2016-09-29.parquet
  size:    259 KB
  rows:    8,404

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-09-29 04:00:00	SPY	ETF	216.82	216.87	216.6	216.66	92512.0
2016-09-29 05:00:00	SPY	ETF	216.73	216.76	216.57	216.63	5924.0
2016-09-29 06:00:00	SPY	ETF	216.66	216.66	216.35	216.46	7769.0
2016-09-29 07:00:00	SPY	ETF	216.46	216.62	216.4	216.46	110208.0
2016-09-29 08:00:00	SPY	ETF	216.53	217.0	216.08	216.31	946203.0
2016-09-29 09:00:00	SPY	ETF	216.31	216.59	216.15	216.59	6950358.0
2016-09-29 10:00:00	SPY	ETF	216.58	216.87	216.29	216.3	10731273.0
2016-09-29 11:00:00	SPY	ETF	216.31	216.4	215.87	216.25	9959186.0
2016-09-29 12:00:00	SPY	ETF	216.26	216.62	214.71	214.99	18079778.0
2016-09-29 13:00:00	SPY	ETF	214.999	215.25	214.04	214.3	23228571.0
2016-09-29 14:00:00	SPY	ETF	214.3	215.69	214.14	215.16	22690059.0
2016-09-29 15:00:00	SPY	ETF	215.16	215.47	214.64	214.6863	23354503.0
2016-09-29 16:00:00	SPY	ETF	214.69	215.21	214.68	215.04	9448905.0
2016-09-29 17:00:00	SPY	ETF	215.08	215.08	214.79	214.84	619109.0
2016-09-29 18:00:00	SPY	ETF	214.85	214.89	214.68	214.82	316437.0
2016-09-29 19:00:00	SPY	ETF	214.82	214.86	214.6	214.76	104121.0
2016-09-29 04:00:00	QQQ	ETF	118.79	118.79	118.79	118.79	100.0
2016-09-29 05:00:00	QQQ	ETF	118.66	118.68	118.66	118.68	999.0
2016-09-29 06:00:00	QQQ	ETF	118.64	118.64	118.53	118.53	10700.0
2016-09-29 07:00:00	QQQ	ETF	118.53	118.58	118.52	118.54	21399.0
2016-09-29 08:00:00	QQQ	ETF	118.51	118.53	118.34	118.46	152081.0
2016-09-29 09:00:00	QQQ	ETF	118.47	118.635	118.41	118.62	1415696.0
2016-09-29 10:00:00	QQQ	ETF	118.62	118.72	118.15	118.23	3423492.0
2016-09-29 11:00:00	QQQ	ETF	118.235	118.32	118.01	118.24	1960836.0
2016-09-29 12:00:00	QQQ	ETF	118.245	118.47	117.5	117.615	3083786.0
2016-09-29 13:00:00	QQQ	ETF	117.6	118.005	117.3338	117.5899	5290944.0
2016-09-29 14:00:00	QQQ	ETF	117.589	118.31	117.49	118.0	2980793.0
2016-09-29 15:00:00	QQQ	ETF	117.99	118.15	117.75	117.83	3907604.0
2016-09-29 16:00:00	QQQ	ETF	117.83	118.13	117.83	118.05	378088.0
2016-09-29 17:00:00	QQQ	ETF	118.01	118.1	117.84	117.92	235765.0
2016-09-29 18:00:00	QQQ	ETF	117.92	117.94	117.86	117.92	32856.0
2016-09-29 19:00:00	QQQ	ETF	117.94	117.94	117.91	117.91	398.0
2016-09-29 06:00:00	IWM	ETF	124.56	124.56	124.56	124.56	1006.0
2016-09-29 07:00:00	IWM	ETF	124.59	124.65	124.55	124.55	1252.0
2016-09-29 08:00:00	IWM	ETF	124.5	124.5	124.35	124.45	24380.0
2016-09-29 09:00:00	IWM	ETF	124.44	124.64	124.04	124.37	1549268.0
2016-09-29 10:00:00	IWM	ETF	124.37	124.56	123.99	124.16	2372096.0
2016-09-29 11:00:00	IWM	ETF	124.16	124.26	123.8	124.06	1772196.0
2016-09-29 12:00:00	IWM	ETF	124.05	124.34	123.075	123.23	3508814.0
2016-09-29 13:00:00	IWM	ETF	123.23	123.56	122.7	122.93	3881971.0
2016-09-29 14:00:00	IWM	ETF	122.925	123.78	122.8446	123.355	3548503.0
2016-09-29 15:00:00	IWM	ETF	123.36	123.42	122.85	122.88	6887114.0
2016-09-29 16:00:00	IWM	ETF	122.88	124.4015	122.86	123.04	1382419.0
2016-09-29 17:00:00	IWM	ETF	123.05	123.05	122.86	122.86	270484.0
2016-09-29 18:00:00	IWM	ETF	122.89	122.98	122.89	122.95	2238.0
2016-09-29 19:00:00	IWM	ETF	122.93	122.96	122.86	122.95	6448.0
2016-09-29 04:00:00	DIA	ETF	183.3	183.3	183.3	183.3	100.0
2016-09-29 08:00:00	DIA	ETF	182.82	182.82	182.65	182.65	500.0
2016-09-29 09:00:00	DIA	ETF	182.65	183.16	182.65	183.12	387774.0
2016-09-29 10:00:00	DIA	ETF	183.12	183.42	182.79	182.8	424303.0

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

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