PREVIEW / etf_1hour / 2014-09-16

all etf 1-hour files

  file:    by_date/etf_1hour/2014/2014-09-16.parquet
  size:    225 KB
  rows:    7,076

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-16 04:00:00	SPY	ETF	198.8	198.84	198.74	198.74	2800.0
2014-09-16 05:00:00	SPY	ETF	198.82	198.91	198.82	198.91	15738.0
2014-09-16 06:00:00	SPY	ETF	198.91	198.91	198.63	198.69	44365.0
2014-09-16 07:00:00	SPY	ETF	198.73	198.9	198.72	198.75	87198.0
2014-09-16 08:00:00	SPY	ETF	198.83	198.85	198.62	198.73	573580.0
2014-09-16 09:00:00	SPY	ETF	198.73	199.28	198.43	199.24	11658544.0
2014-09-16 10:00:00	SPY	ETF	199.24	199.53	199.1705	199.225	15932675.0
2014-09-16 11:00:00	SPY	ETF	199.22	200.337	199.05	200.19	21839813.0
2014-09-16 12:00:00	SPY	ETF	200.2	200.52	200.05	200.32	12372735.0
2014-09-16 13:00:00	SPY	ETF	200.32	200.84	200.32	200.68	11638022.0
2014-09-16 14:00:00	SPY	ETF	200.68	200.81	200.58	200.62	13398174.0
2014-09-16 15:00:00	SPY	ETF	200.625	200.75	200.47	200.49	17619370.0
2014-09-16 16:00:00	SPY	ETF	200.49	200.7192	200.1838	200.55	7302346.0
2014-09-16 17:00:00	SPY	ETF	200.56	200.57	200.46	200.53	356222.0
2014-09-16 18:00:00	SPY	ETF	200.53	200.6	200.52	200.53	51991.0
2014-09-16 19:00:00	SPY	ETF	200.53	200.59	200.51	200.58	102136.0
2014-09-16 04:00:00	QQQ	ETF	98.37	98.37	98.32	98.36	1600.0
2014-09-16 05:00:00	QQQ	ETF	98.39	98.43	98.39	98.43	68695.0
2014-09-16 06:00:00	QQQ	ETF	98.42	98.42	98.26	98.38	8358.0
2014-09-16 07:00:00	QQQ	ETF	98.41	98.47	98.37	98.37	61385.0
2014-09-16 08:00:00	QQQ	ETF	98.37	98.46	98.27	98.36	294552.0
2014-09-16 09:00:00	QQQ	ETF	98.37	98.62	98.05	98.52	6172712.0
2014-09-16 10:00:00	QQQ	ETF	98.52	98.78	98.43	98.49	4852643.0
2014-09-16 11:00:00	QQQ	ETF	98.49	99.07	98.33	99.01	5314898.0
2014-09-16 12:00:00	QQQ	ETF	99.01	99.19	98.94	99.05	3179285.0
2014-09-16 13:00:00	QQQ	ETF	99.06	99.4399	99.06	99.3231	3108477.0
2014-09-16 14:00:00	QQQ	ETF	99.32	99.5	99.29	99.4173	2804295.0
2014-09-16 15:00:00	QQQ	ETF	99.41	99.57	99.38	99.38	6025521.0
2014-09-16 16:00:00	QQQ	ETF	99.38	99.45	98.5005	99.4	2455243.0
2014-09-16 17:00:00	QQQ	ETF	98.5016	99.43	98.5016	99.38	94541.0
2014-09-16 18:00:00	QQQ	ETF	99.36	99.39	99.33	99.36	106812.0
2014-09-16 19:00:00	QQQ	ETF	99.33	99.37	99.32	99.37	6670.0
2014-09-16 04:00:00	IWM	ETF	113.9	113.9	113.9	113.9	200.0
2014-09-16 06:00:00	IWM	ETF	113.88	113.88	113.87	113.87	1000.0
2014-09-16 07:00:00	IWM	ETF	113.98	113.98	113.75	113.78	24300.0
2014-09-16 08:00:00	IWM	ETF	113.78	113.92	113.65	113.9	105225.0
2014-09-16 09:00:00	IWM	ETF	113.9	114.3	113.64	114.17	5818531.0
2014-09-16 10:00:00	IWM	ETF	114.17	114.42	113.655	113.72	6336608.0
2014-09-16 11:00:00	IWM	ETF	113.72	114.19	113.4	114.03	8481799.0
2014-09-16 12:00:00	IWM	ETF	114.04	114.57	113.9	114.35	5486399.0
2014-09-16 13:00:00	IWM	ETF	114.355	114.76	114.335	114.6	3837969.0
2014-09-16 14:00:00	IWM	ETF	114.605	114.715	114.44	114.45	2832657.0
2014-09-16 15:00:00	IWM	ETF	114.45	114.65	114.39	114.425	5351352.0
2014-09-16 16:00:00	IWM	ETF	114.44	114.5	114.38	114.44	2381381.0
2014-09-16 17:00:00	IWM	ETF	114.36	114.36	114.0	114.0	214.0
2014-09-16 18:00:00	IWM	ETF	114.33	114.33	114.33	114.33	300.0
2014-09-16 19:00:00	IWM	ETF	114.45	114.54	114.45	114.54	1600.0
2014-09-16 07:00:00	DIA	ETF	170.2	170.2	170.08	170.08	400.0
2014-09-16 08:00:00	DIA	ETF	170.08	170.08	169.97	169.97	5039.0
2014-09-16 09:00:00	DIA	ETF	169.96	170.4	169.8	170.36	899006.0

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

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