PREVIEW / etf_1hour / 2014-07-15

all etf 1-hour files

  file:    by_date/etf_1hour/2014/2014-07-15.parquet
  size:    226 KB
  rows:    7,337

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-07-15 04:00:00	SPY	ETF	197.54	197.54	197.5	197.52	2286.0
2014-07-15 05:00:00	SPY	ETF	197.47	197.47	197.28	197.31	1057.0
2014-07-15 06:00:00	SPY	ETF	197.33	197.37	197.21	197.37	17398.0
2014-07-15 07:00:00	SPY	ETF	197.36	197.8	197.34	197.67	310625.0
2014-07-15 08:00:00	SPY	ETF	197.67	197.92	197.57	197.78	635009.0
2014-07-15 09:00:00	SPY	ETF	197.78	198.1	197.62	197.73	10299433.0
2014-07-15 10:00:00	SPY	ETF	197.73	197.96	196.71	197.07	26487850.0
2014-07-15 11:00:00	SPY	ETF	197.06	197.38	196.5	196.56	14616027.0
2014-07-15 12:00:00	SPY	ETF	196.5599	197.9714	196.36	196.91	10456973.0
2014-07-15 13:00:00	SPY	ETF	196.91	197.41	196.87	197.16	8894809.0
2014-07-15 14:00:00	SPY	ETF	197.17	197.5	197.12	197.42	12981401.0
2014-07-15 15:00:00	SPY	ETF	197.41	197.45	197.06	197.23	15207522.0
2014-07-15 16:00:00	SPY	ETF	197.23	197.32	197.18	197.29	5920811.0
2014-07-15 17:00:00	SPY	ETF	197.29	197.37	197.28	197.32	57959.0
2014-07-15 18:00:00	SPY	ETF	197.3	197.3	197.16	197.28	38197.0
2014-07-15 19:00:00	SPY	ETF	197.26	197.32	197.26	197.26	10425.0
2014-07-15 05:00:00	QQQ	ETF	95.78	95.78	95.78	95.78	100.0
2014-07-15 06:00:00	QQQ	ETF	95.71	95.76	95.71	95.76	2200.0
2014-07-15 07:00:00	QQQ	ETF	95.82	95.98	95.82	95.93	31400.0
2014-07-15 08:00:00	QQQ	ETF	95.95	96.03	95.91	95.96	148885.0
2014-07-15 09:00:00	QQQ	ETF	95.98	96.13	95.85	95.9524	2969032.0
2014-07-15 10:00:00	QQQ	ETF	95.96	96.04	95.21	95.37	9020617.0
2014-07-15 11:00:00	QQQ	ETF	95.37	95.58	94.92	94.9463	5400830.0
2014-07-15 12:00:00	QQQ	ETF	94.95	95.47	94.83	95.34	4937352.0
2014-07-15 13:00:00	QQQ	ETF	95.34	95.61	95.28	95.465	2792724.0
2014-07-15 14:00:00	QQQ	ETF	95.46	95.67	95.42	95.56	2697497.0
2014-07-15 15:00:00	QQQ	ETF	95.565	95.6	95.341	95.52	5226756.0
2014-07-15 16:00:00	QQQ	ETF	95.52	95.76	95.4926	95.74	4330966.0
2014-07-15 17:00:00	QQQ	ETF	95.73	95.78	95.73	95.73	52311.0
2014-07-15 18:00:00	QQQ	ETF	95.72	95.72	95.63	95.66	18440.0
2014-07-15 19:00:00	QQQ	ETF	95.7	95.71	95.68	95.68	6550.0
2014-07-15 06:00:00	IWM	ETF	115.12	115.16	115.08	115.16	3150.0
2014-07-15 07:00:00	IWM	ETF	115.44	115.74	115.44	115.62	32100.0
2014-07-15 08:00:00	IWM	ETF	115.61	115.86	115.55	115.76	88141.0
2014-07-15 09:00:00	IWM	ETF	115.74	116.0	115.25	115.3701	4244046.0
2014-07-15 10:00:00	IWM	ETF	115.37	115.64	114.11	114.49	13943973.0
2014-07-15 11:00:00	IWM	ETF	114.49	114.94	113.94	113.99	8364884.0
2014-07-15 12:00:00	IWM	ETF	113.99	114.815	113.87	114.39	6079789.0
2014-07-15 13:00:00	IWM	ETF	114.4	115.01	114.38	114.665	3433294.0
2014-07-15 14:00:00	IWM	ETF	114.67	114.855	114.52	114.62	2422033.0
2014-07-15 15:00:00	IWM	ETF	114.63	114.65	114.33	114.56	4532588.0
2014-07-15 16:00:00	IWM	ETF	114.55	114.76	114.54	114.69	949824.0
2014-07-15 17:00:00	IWM	ETF	114.73	114.78	114.5	114.71	175674.0
2014-07-15 18:00:00	IWM	ETF	114.62	114.62	114.62	114.62	4274.0
2014-07-15 19:00:00	IWM	ETF	114.63	114.63	114.62	114.62	600.0
2014-07-15 06:00:00	DIA	ETF	170.05	170.17	170.05	170.17	1000.0
2014-07-15 07:00:00	DIA	ETF	170.28	170.5	170.28	170.5	7361.0
2014-07-15 08:00:00	DIA	ETF	170.48	170.62	170.48	170.52	6577.0
2014-07-15 09:00:00	DIA	ETF	170.52	170.91	170.44	170.62	710640.0
2014-07-15 10:00:00	DIA	ETF	170.62	170.8	169.88	170.2	1305017.0

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

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