PREVIEW / etf_1hour / 2014-10-28

all etf 1-hour files

  file:    by_date/etf_1hour/2014/2014-10-28.parquet
  size:    235 KB
  rows:    7,483

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-28 04:00:00	SPY	ETF	196.8	197.66	196.78	197.1	62050.0
2014-10-28 05:00:00	SPY	ETF	197.22	197.39	197.15	197.3	115380.0
2014-10-28 06:00:00	SPY	ETF	197.28	197.35	197.18	197.24	53448.0
2014-10-28 07:00:00	SPY	ETF	197.24	197.33	197.11	197.32	222390.0
2014-10-28 08:00:00	SPY	ETF	197.32	197.36	196.505	196.86	1012699.0
2014-10-28 09:00:00	SPY	ETF	196.88	197.25	196.71	197.05	13632394.0
2014-10-28 10:00:00	SPY	ETF	197.04	197.33	196.81	197.07	15773648.0
2014-10-28 11:00:00	SPY	ETF	197.08	197.43	196.97	196.98	10338287.0
2014-10-28 12:00:00	SPY	ETF	196.97	197.28	196.91	197.11	7380266.0
2014-10-28 13:00:00	SPY	ETF	197.105	197.5	197.065	197.44	6072917.0
2014-10-28 14:00:00	SPY	ETF	197.45	197.7	197.35	197.61	9412155.0
2014-10-28 15:00:00	SPY	ETF	197.61	198.42	197.6	198.37	28789167.0
2014-10-28 16:00:00	SPY	ETF	198.37	198.63	197.0641	198.49	8482500.0
2014-10-28 17:00:00	SPY	ETF	198.49	198.52	198.16	198.17	1817055.0
2014-10-28 18:00:00	SPY	ETF	198.17	198.26	198.02	198.04	492150.0
2014-10-28 19:00:00	SPY	ETF	198.04	198.16	198.01	198.12	119680.0
2014-10-28 04:00:00	QQQ	ETF	98.88	99.33	98.88	99.22	19606.0
2014-10-28 05:00:00	QQQ	ETF	99.24	99.34	99.24	99.28	30950.0
2014-10-28 06:00:00	QQQ	ETF	99.26	99.31	99.23	99.29	28350.0
2014-10-28 07:00:00	QQQ	ETF	99.26	99.31	99.22	99.29	56623.0
2014-10-28 08:00:00	QQQ	ETF	99.29	99.3	99.07	99.08	338412.0
2014-10-28 09:00:00	QQQ	ETF	99.08	99.57	99.02	99.48	4436316.0
2014-10-28 10:00:00	QQQ	ETF	99.48	99.64	99.45	99.56	3823431.0
2014-10-28 11:00:00	QQQ	ETF	99.57	99.76	99.49	99.49	3002626.0
2014-10-28 12:00:00	QQQ	ETF	99.49	99.61	99.41	99.51	2770246.0
2014-10-28 13:00:00	QQQ	ETF	99.509	99.79	99.49	99.7699	1864516.0
2014-10-28 14:00:00	QQQ	ETF	99.77	99.9	99.72	99.775	3066530.0
2014-10-28 15:00:00	QQQ	ETF	99.77	100.2	99.76	100.17	8930645.0
2014-10-28 16:00:00	QQQ	ETF	100.18	100.19	99.6022	100.05	2949554.0
2014-10-28 17:00:00	QQQ	ETF	100.06	100.06	99.66	99.7	158252.0
2014-10-28 18:00:00	QQQ	ETF	99.7	99.71	99.51	99.53	279178.0
2014-10-28 19:00:00	QQQ	ETF	99.54	99.61	99.54	99.61	81311.0
2014-10-28 04:00:00	IWM	ETF	111.51	111.51	111.51	111.51	450.0
2014-10-28 05:00:00	IWM	ETF	111.73	111.77	111.73	111.77	200.0
2014-10-28 06:00:00	IWM	ETF	111.75	111.8	111.65	111.8	1400.0
2014-10-28 07:00:00	IWM	ETF	111.74	111.88	111.74	111.82	29686.0
2014-10-28 08:00:00	IWM	ETF	111.82	111.83	111.47	111.47	206018.0
2014-10-28 09:00:00	IWM	ETF	111.45	112.11	111.3	112.03	5967065.0
2014-10-28 10:00:00	IWM	ETF	112.05	112.79	111.98	112.735	8841454.0
2014-10-28 11:00:00	IWM	ETF	112.74	113.2101	112.74	112.81	7696297.0
2014-10-28 12:00:00	IWM	ETF	112.82	113.11	112.8	112.95	4301079.0
2014-10-28 13:00:00	IWM	ETF	112.95	113.51	112.91	113.44	4215347.0
2014-10-28 14:00:00	IWM	ETF	113.44	113.83	113.39	113.67	5628439.0
2014-10-28 15:00:00	IWM	ETF	113.67	114.21	113.665	114.18	13990080.0
2014-10-28 16:00:00	IWM	ETF	114.17	114.43	111.015	114.0	8123909.0
2014-10-28 17:00:00	IWM	ETF	114.03	114.08	113.9	113.91	28342.0
2014-10-28 18:00:00	IWM	ETF	113.85	113.98	113.69	113.69	2717.0
2014-10-28 19:00:00	IWM	ETF	113.7	113.84	113.66	113.74	2879.0
2014-10-28 04:00:00	DIA	ETF	168.2	168.8	168.2	168.8	750.0
2014-10-28 06:00:00	DIA	ETF	168.65	168.75	168.65	168.75	5500.0

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

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