PREVIEW / etf_1hour / 2014-10-31

all etf 1-hour files

  file:    by_date/etf_1hour/2014/2014-10-31.parquet
  size:    241 KB
  rows:    7,700

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-10-31 04:00:00	SPY	ETF	201.15	201.44	199.95	201.43	151259.0
2014-10-31 05:00:00	SPY	ETF	201.43	201.75	201.31	201.75	95762.0
2014-10-31 06:00:00	SPY	ETF	201.72	201.78	201.56	201.65	387119.0
2014-10-31 07:00:00	SPY	ETF	201.57	201.73	201.38	201.64	667802.0
2014-10-31 08:00:00	SPY	ETF	201.45	201.715	201.26	201.57	3361871.0
2014-10-31 09:00:00	SPY	ETF	201.55	201.93	200.81	200.99	28792440.0
2014-10-31 10:00:00	SPY	ETF	200.99	201.53	200.77	201.39	24084355.0
2014-10-31 11:00:00	SPY	ETF	201.38	201.74	201.24	201.35	15107640.0
2014-10-31 12:00:00	SPY	ETF	201.355	201.43	201.03	201.409	8899258.0
2014-10-31 13:00:00	SPY	ETF	201.405	201.47	201.1	201.15	10943533.0
2014-10-31 14:00:00	SPY	ETF	201.15	201.38	201.05	201.21	9354199.0
2014-10-31 15:00:00	SPY	ETF	201.205	201.79	201.02	201.66	24348921.0
2014-10-31 16:00:00	SPY	ETF	201.66	201.7702	201.46	201.48	16631940.0
2014-10-31 17:00:00	SPY	ETF	201.47	201.66	201.33	201.64	396324.0
2014-10-31 18:00:00	SPY	ETF	201.62	201.64	201.57	201.62	17121.0
2014-10-31 19:00:00	SPY	ETF	201.59	201.62	201.57	201.62	20507.0
2014-10-31 04:00:00	QQQ	ETF	100.44	101.68	100.44	101.35	94566.0
2014-10-31 05:00:00	QQQ	ETF	101.41	101.5	101.3	101.46	31801.0
2014-10-31 06:00:00	QQQ	ETF	101.44	101.51	101.38	101.4	61650.0
2014-10-31 07:00:00	QQQ	ETF	101.4	101.46	101.31	101.4	120391.0
2014-10-31 08:00:00	QQQ	ETF	101.41	101.47	101.32	101.47	2823124.0
2014-10-31 09:00:00	QQQ	ETF	101.47	101.75	101.23	101.31	8344711.0
2014-10-31 10:00:00	QQQ	ETF	101.31	101.48	101.105	101.33	5524568.0
2014-10-31 11:00:00	QQQ	ETF	101.32	101.525	101.2	101.24	4941725.0
2014-10-31 12:00:00	QQQ	ETF	101.24	101.38	101.145	101.36	2776258.0
2014-10-31 13:00:00	QQQ	ETF	101.37	101.4	101.195	101.25	2600560.0
2014-10-31 14:00:00	QQQ	ETF	101.24	101.33	101.07	101.16	4436423.0
2014-10-31 15:00:00	QQQ	ETF	101.16	101.44	101.07	101.4	9997121.0
2014-10-31 16:00:00	QQQ	ETF	101.4	101.4386	100.0338	101.27	4991362.0
2014-10-31 17:00:00	QQQ	ETF	101.27	101.33	101.25	101.32	608300.0
2014-10-31 18:00:00	QQQ	ETF	101.32	101.37	101.32	101.37	3520.0
2014-10-31 19:00:00	QQQ	ETF	101.33	101.38	101.3	101.38	3925.0
2014-10-31 04:00:00	IWM	ETF	115.47	115.81	115.47	115.81	762.0
2014-10-31 05:00:00	IWM	ETF	115.98	116.2	115.98	116.03	1800.0
2014-10-31 06:00:00	IWM	ETF	116.25	116.35	116.24	116.35	5828.0
2014-10-31 07:00:00	IWM	ETF	116.35	116.54	116.23	116.53	154874.0
2014-10-31 08:00:00	IWM	ETF	116.51	116.64	116.31	116.63	766984.0
2014-10-31 09:00:00	IWM	ETF	116.65	117.13	115.94	116.11	8984067.0
2014-10-31 10:00:00	IWM	ETF	116.12	116.65	115.95	116.36	7522020.0
2014-10-31 11:00:00	IWM	ETF	116.36	116.58	116.05	116.11	3902758.0
2014-10-31 12:00:00	IWM	ETF	116.11	116.28	115.875	116.25	3832328.0
2014-10-31 13:00:00	IWM	ETF	116.25	116.51	116.25	116.28	3116728.0
2014-10-31 14:00:00	IWM	ETF	116.285	116.59	116.22	116.47	4354818.0
2014-10-31 15:00:00	IWM	ETF	116.46	116.77	116.37	116.55	10413531.0
2014-10-31 16:00:00	IWM	ETF	116.55	116.62	116.32	116.42	2308648.0
2014-10-31 17:00:00	IWM	ETF	116.41	116.5	116.34	116.4	85997.0
2014-10-31 18:00:00	IWM	ETF	116.4	116.54	116.4	116.48	700.0
2014-10-31 19:00:00	IWM	ETF	116.48	116.56	116.43	116.56	483.0
2014-10-31 04:00:00	DIA	ETF	172.0	173.17	172.0	173.07	579.0
2014-10-31 05:00:00	DIA	ETF	173.54	173.54	173.54	173.54	350.0

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

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