PREVIEW / etf_1hour / 2016-02-08

all etf 1-hour files

  file:    by_date/etf_1hour/2016/2016-02-08.parquet
  size:    265 KB
  rows:    8,530

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-02-08 04:00:00	SPY	ETF	188.1	188.11	185.12	185.54	172924.0
2016-02-08 05:00:00	SPY	ETF	185.53	186.19	185.3	185.71	90127.0
2016-02-08 06:00:00	SPY	ETF	185.71	186.34	185.49	186.0	124761.0
2016-02-08 07:00:00	SPY	ETF	186.04	186.06	185.2	185.28	1329338.0
2016-02-08 08:00:00	SPY	ETF	185.29	186.1	185.05	186.08	1659319.0
2016-02-08 09:00:00	SPY	ETF	186.06	187.98	184.27	184.58	25922211.0
2016-02-08 10:00:00	SPY	ETF	184.57	185.08	183.93	184.21	28759726.0
2016-02-08 11:00:00	SPY	ETF	184.215	185.75	183.29	184.222	23914754.0
2016-02-08 12:00:00	SPY	ETF	184.229	185.75	184.1	184.3239	14524503.0
2016-02-08 13:00:00	SPY	ETF	184.33	184.36	183.04	183.05	17108331.0
2016-02-08 14:00:00	SPY	ETF	183.06	183.71	182.8	183.34	21873730.0
2016-02-08 15:00:00	SPY	ETF	183.345	186.12	183.28	185.37	46610443.0
2016-02-08 16:00:00	SPY	ETF	185.39	186.0	185.32	185.75	7358730.0
2016-02-08 17:00:00	SPY	ETF	185.74	185.75	185.42	185.56	474188.0
2016-02-08 18:00:00	SPY	ETF	185.53	185.54	184.95	185.22	293607.0
2016-02-08 19:00:00	SPY	ETF	185.24	185.33	184.9	185.01	88602.0
2016-02-08 04:00:00	QQQ	ETF	98.3	98.3	96.5	96.55	22356.0
2016-02-08 05:00:00	QQQ	ETF	96.6	96.84	96.28	96.55	15149.0
2016-02-08 06:00:00	QQQ	ETF	96.44	96.68	96.4	96.51	25999.0
2016-02-08 07:00:00	QQQ	ETF	96.48	96.48	95.81	96.0	136835.0
2016-02-08 08:00:00	QQQ	ETF	95.97	98.12	95.84	96.42	362660.0
2016-02-08 09:00:00	QQQ	ETF	96.42	96.5524	95.8	96.23	13346486.0
2016-02-08 10:00:00	QQQ	ETF	96.23	96.57	95.615	95.79	13229696.0
2016-02-08 11:00:00	QQQ	ETF	95.78	95.96	95.15	95.9	11155808.0
2016-02-08 12:00:00	QQQ	ETF	95.9	96.32	95.71	95.8	6381237.0
2016-02-08 13:00:00	QQQ	ETF	95.81	95.845	95.06	95.11	6265448.0
2016-02-08 14:00:00	QQQ	ETF	95.1	95.44	94.84	95.07	6670590.0
2016-02-08 15:00:00	QQQ	ETF	95.0642	97.05	95.02	96.62	18480628.0
2016-02-08 16:00:00	QQQ	ETF	96.62	96.9	96.6	96.77	1936985.0
2016-02-08 17:00:00	QQQ	ETF	96.8	96.8	96.58	96.6	34866.0
2016-02-08 18:00:00	QQQ	ETF	96.64	96.64	96.4	96.53	58500.0
2016-02-08 19:00:00	QQQ	ETF	96.55	96.55	96.35	96.37	51850.0
2016-02-08 20:00:00	QQQ	ETF	96.5933	96.5933	96.5933	96.5933	500000.0
2016-02-08 04:00:00	IWM	ETF	97.81	97.81	96.84	96.84	15285.0
2016-02-08 05:00:00	IWM	ETF	96.99	97.14	96.64	97.03	4500.0
2016-02-08 06:00:00	IWM	ETF	96.76	97.16	96.76	97.16	14223.0
2016-02-08 07:00:00	IWM	ETF	96.91	97.05	96.7	96.79	157890.0
2016-02-08 08:00:00	IWM	ETF	96.73	97.2	96.67	97.12	559474.0
2016-02-08 09:00:00	IWM	ETF	97.2	98.0	95.74	95.83	7208902.0
2016-02-08 10:00:00	IWM	ETF	95.84	96.2	95.475	95.68	8401015.0
2016-02-08 11:00:00	IWM	ETF	95.68	95.91	95.16	95.91	7198206.0
2016-02-08 12:00:00	IWM	ETF	95.91	96.44	95.74	95.9757	5196506.0
2016-02-08 13:00:00	IWM	ETF	95.98	96.03	95.0	95.0	3728499.0
2016-02-08 14:00:00	IWM	ETF	95.0	95.44	94.94	95.34	6997097.0
2016-02-08 15:00:00	IWM	ETF	95.35	96.74	95.3	96.41	13960620.0
2016-02-08 16:00:00	IWM	ETF	96.42	96.86	96.41	96.62	1555108.0
2016-02-08 17:00:00	IWM	ETF	96.55	96.55	96.48	96.48	964.0
2016-02-08 18:00:00	IWM	ETF	96.33	96.33	96.14	96.16	2950.0
2016-02-08 19:00:00	IWM	ETF	96.17	96.39	96.17	96.39	7085.0
2016-02-08 20:00:00	IWM	ETF	96.3312	96.3312	96.3312	96.3312	1000000.0

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

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