PREVIEW / etf_1hour / 2014-09-30

all etf 1-hour files

  file:    by_date/etf_1hour/2014/2014-09-30.parquet
  size:    228 KB
  rows:    7,243

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
2014-09-30 04:00:00	SPY	ETF	197.57	197.9	197.57	197.7	9230.0
2014-09-30 05:00:00	SPY	ETF	197.8	198.22	197.8	198.11	28660.0
2014-09-30 06:00:00	SPY	ETF	198.08	198.14	197.97	198.12	34686.0
2014-09-30 07:00:00	SPY	ETF	198.08	198.23	197.96	198.17	226031.0
2014-09-30 08:00:00	SPY	ETF	198.05	198.19	197.91	197.91	594361.0
2014-09-30 09:00:00	SPY	ETF	197.92	197.925	196.91	197.21	14078801.0
2014-09-30 10:00:00	SPY	ETF	197.2	198.03	196.76	197.92	16960129.0
2014-09-30 11:00:00	SPY	ETF	197.91	198.3	197.74	197.84	13095552.0
2014-09-30 12:00:00	SPY	ETF	197.84	197.89	197.01	197.22	13891484.0
2014-09-30 13:00:00	SPY	ETF	197.22	197.61	196.61	196.879	10501935.0
2014-09-30 14:00:00	SPY	ETF	196.879	197.28	196.62	197.09	13789905.0
2014-09-30 15:00:00	SPY	ETF	197.09	197.55	196.82	197.0	22788973.0
2014-09-30 16:00:00	SPY	ETF	196.99	197.5268	196.61	196.67	13114380.0
2014-09-30 17:00:00	SPY	ETF	196.67	197.5268	196.47	196.5	9518876.0
2014-09-30 18:00:00	SPY	ETF	196.5	197.02	196.49	196.65	1080911.0
2014-09-30 19:00:00	SPY	ETF	196.66	196.7	196.54	196.61	126942.0
2014-09-30 04:00:00	QQQ	ETF	98.9	98.9	98.9	98.9	5000.0
2014-09-30 05:00:00	QQQ	ETF	98.88	99.08	98.88	99.03	41980.0
2014-09-30 06:00:00	QQQ	ETF	99.03	99.05	98.96	99.03	25890.0
2014-09-30 07:00:00	QQQ	ETF	99.04	99.26	99.03	99.16	101957.0
2014-09-30 08:00:00	QQQ	ETF	99.18	99.19	99.05	99.05	347876.0
2014-09-30 09:00:00	QQQ	ETF	99.05	99.09	98.39	98.63	6268816.0
2014-09-30 10:00:00	QQQ	ETF	98.63	99.135	98.32	99.06	6698217.0
2014-09-30 11:00:00	QQQ	ETF	99.05	99.3	99.021	99.1	4858722.0
2014-09-30 12:00:00	QQQ	ETF	99.105	99.17	98.7	98.87	3685042.0
2014-09-30 13:00:00	QQQ	ETF	98.86	99.05	98.51	98.64	3485336.0
2014-09-30 14:00:00	QQQ	ETF	98.64	98.8	98.45	98.715	3685977.0
2014-09-30 15:00:00	QQQ	ETF	98.715	99.02	98.586	98.814	6629333.0
2014-09-30 16:00:00	QQQ	ETF	98.81	98.8354	98.58	98.79	3687750.0
2014-09-30 17:00:00	QQQ	ETF	98.61	98.79	98.56	98.65	125451.0
2014-09-30 18:00:00	QQQ	ETF	98.6	98.64	98.55	98.61	67637.0
2014-09-30 19:00:00	QQQ	ETF	98.59	98.61	98.51	98.61	3282.0
2014-09-30 05:00:00	IWM	ETF	111.47	111.54	111.47	111.54	500.0
2014-09-30 06:00:00	IWM	ETF	111.3	111.41	111.2	111.2	700.0
2014-09-30 07:00:00	IWM	ETF	111.32	111.42	111.22	111.3	30900.0
2014-09-30 08:00:00	IWM	ETF	111.31	111.45	111.07	111.08	196991.0
2014-09-30 09:00:00	IWM	ETF	111.03	111.03	110.14	110.31	6240163.0
2014-09-30 10:00:00	IWM	ETF	110.31	110.8	110.03	110.615	6596372.0
2014-09-30 11:00:00	IWM	ETF	110.6	110.92	110.38	110.5	3835428.0
2014-09-30 12:00:00	IWM	ETF	110.51	110.57	109.83	110.04	4858857.0
2014-09-30 13:00:00	IWM	ETF	110.04	110.31	109.84	109.93	3231593.0
2014-09-30 14:00:00	IWM	ETF	109.92	110.03	109.63	109.91	4972004.0
2014-09-30 15:00:00	IWM	ETF	109.91	110.12	109.31	109.34	10248941.0
2014-09-30 16:00:00	IWM	ETF	109.35	109.43	109.18	109.19	2539896.0
2014-09-30 17:00:00	IWM	ETF	109.15	109.35	109.04	109.35	43183.0
2014-09-30 18:00:00	IWM	ETF	109.23	109.26	109.14	109.21	7975.0
2014-09-30 19:00:00	IWM	ETF	109.22	109.22	109.17	109.17	8675.0
2014-09-30 04:00:00	DIA	ETF	170.5	170.5	170.5	170.5	100.0
2014-09-30 05:00:00	DIA	ETF	170.8	170.8	170.8	170.8	100.0
2014-09-30 09:00:00	DIA	ETF	170.6	170.62	169.96	170.14	803407.0

> showing 50 of 7,243 rows — these rows as CSV

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