PREVIEW / etf_1hour / 2016-04-04

all etf 1-hour files

  file:    by_date/etf_1hour/2016/2016-04-04.parquet
  size:    252 KB
  rows:    8,010

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-04-04 04:00:00	SPY	ETF	207.12	207.4	207.12	207.31	22889.0
2016-04-04 05:00:00	SPY	ETF	207.21	207.57	207.21	207.36	28066.0
2016-04-04 06:00:00	SPY	ETF	207.43	207.44	207.26	207.42	24866.0
2016-04-04 07:00:00	SPY	ETF	207.48	207.57	207.35	207.37	337740.0
2016-04-04 08:00:00	SPY	ETF	207.37	207.53	206.92	207.12	966480.0
2016-04-04 09:00:00	SPY	ETF	207.11	207.11	206.53	206.94	7320061.0
2016-04-04 10:00:00	SPY	ETF	206.94	207.07	206.27	206.305	8931974.0
2016-04-04 11:00:00	SPY	ETF	206.31	206.54	206.165	206.4689	7171525.0
2016-04-04 12:00:00	SPY	ETF	206.47	206.87	206.44	206.76	4610607.0
2016-04-04 13:00:00	SPY	ETF	206.76	206.77	206.22	206.28	3676538.0
2016-04-04 14:00:00	SPY	ETF	206.27	206.35	205.925	206.235	6916755.0
2016-04-04 15:00:00	SPY	ETF	206.22	206.39	205.89	206.27	14304509.0
2016-04-04 16:00:00	SPY	ETF	206.25	207.0072	206.03	206.12	3125321.0
2016-04-04 17:00:00	SPY	ETF	206.07	206.09	205.94	205.96	250771.0
2016-04-04 18:00:00	SPY	ETF	205.97	205.97	205.71	205.89	538324.0
2016-04-04 19:00:00	SPY	ETF	205.85	205.99	205.78	205.8	127658.0
2016-04-04 04:00:00	QQQ	ETF	110.6	110.69	110.55	110.69	1200.0
2016-04-04 05:00:00	QQQ	ETF	110.69	110.82	110.69	110.81	4101.0
2016-04-04 06:00:00	QQQ	ETF	110.75	110.76	110.67	110.76	3397.0
2016-04-04 07:00:00	QQQ	ETF	110.76	110.8	110.69	110.7	16587.0
2016-04-04 08:00:00	QQQ	ETF	110.36	110.7	110.36	110.46	471737.0
2016-04-04 09:00:00	QQQ	ETF	110.45	110.48	110.02	110.285	2744926.0
2016-04-04 10:00:00	QQQ	ETF	110.28	110.435	109.8375	109.845	2719142.0
2016-04-04 11:00:00	QQQ	ETF	109.85	110.0	109.68	109.9585	1250176.0
2016-04-04 12:00:00	QQQ	ETF	109.96	110.35	109.9288	110.29	1028217.0
2016-04-04 13:00:00	QQQ	ETF	110.28	110.29	109.93	109.95	1405205.0
2016-04-04 14:00:00	QQQ	ETF	109.96	109.97	109.74	109.89	1366641.0
2016-04-04 15:00:00	QQQ	ETF	109.88	110.0	109.69	109.89	2364207.0
2016-04-04 16:00:00	QQQ	ETF	109.89	109.94	109.74	109.74	1259683.0
2016-04-04 17:00:00	QQQ	ETF	109.83	109.87	109.78	109.82	15638.0
2016-04-04 18:00:00	QQQ	ETF	109.77	109.77	109.68	109.73	20688.0
2016-04-04 19:00:00	QQQ	ETF	109.79	109.8	109.73	109.73	3100.0
2016-04-04 05:00:00	IWM	ETF	111.22	111.24	111.22	111.24	2100.0
2016-04-04 06:00:00	IWM	ETF	111.19	111.29	111.19	111.29	5600.0
2016-04-04 07:00:00	IWM	ETF	111.33	111.33	111.21	111.22	18473.0
2016-04-04 08:00:00	IWM	ETF	111.23	111.24	111.05	111.05	44079.0
2016-04-04 09:00:00	IWM	ETF	111.05	111.14	110.65	111.11	1827750.0
2016-04-04 10:00:00	IWM	ETF	111.1	111.32	110.57	110.61	2649906.0
2016-04-04 11:00:00	IWM	ETF	110.61	110.7211	110.46	110.61	1784594.0
2016-04-04 12:00:00	IWM	ETF	110.62	111.005	110.61	110.885	1500508.0
2016-04-04 13:00:00	IWM	ETF	110.88	110.91	110.55	110.57	1609381.0
2016-04-04 14:00:00	IWM	ETF	110.57	110.57	110.33	110.3701	1649598.0
2016-04-04 15:00:00	IWM	ETF	110.38	110.505	110.1	110.2	4762051.0
2016-04-04 16:00:00	IWM	ETF	110.19	110.28	110.12	110.19	1086019.0
2016-04-04 17:00:00	IWM	ETF	110.22	110.22	110.04	110.04	7548.0
2016-04-04 18:00:00	IWM	ETF	110.1	110.17	110.03	110.04	8999.0
2016-04-04 19:00:00	IWM	ETF	110.15	110.15	110.15	110.15	200.0
2016-04-04 05:00:00	DIA	ETF	178.21	178.21	178.21	178.21	3000.0
2016-04-04 07:00:00	DIA	ETF	178.01	178.15	178.01	178.15	1300.0
2016-04-04 08:00:00	DIA	ETF	178.0	178.0	177.72	177.81	37377.0

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

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