PREVIEW / etf_1hour / 2014-07-30

all etf 1-hour files

  file:    by_date/etf_1hour/2014/2014-07-30.parquet
  size:    229 KB
  rows:    7,465

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-30 04:00:00	SPY	ETF	197.06	197.15	197.02	197.14	2185.0
2014-07-30 05:00:00	SPY	ETF	197.08	197.25	197.08	197.25	23820.0
2014-07-30 06:00:00	SPY	ETF	197.14	197.31	197.14	197.31	55177.0
2014-07-30 07:00:00	SPY	ETF	197.28	197.49	197.23	197.47	304891.0
2014-07-30 08:00:00	SPY	ETF	197.38	197.88	197.15	197.67	2311012.0
2014-07-30 09:00:00	SPY	ETF	197.67	197.91	197.18	197.23	10154805.0
2014-07-30 10:00:00	SPY	ETF	197.23	197.29	196.5	196.68	18444911.0
2014-07-30 11:00:00	SPY	ETF	196.66	196.8889	196.24	196.3	10960744.0
2014-07-30 12:00:00	SPY	ETF	196.3	196.79	196.16	196.71	8708398.0
2014-07-30 13:00:00	SPY	ETF	196.71	196.74	196.34	196.65	7750340.0
2014-07-30 14:00:00	SPY	ETF	196.63	197.63	196.39	196.92	26927035.0
2014-07-30 15:00:00	SPY	ETF	196.92	197.2	196.61	196.99	15121482.0
2014-07-30 16:00:00	SPY	ETF	196.99	197.04	196.7762	197.0	2808256.0
2014-07-30 17:00:00	SPY	ETF	197.0	197.05	196.96	197.04	94496.0
2014-07-30 18:00:00	SPY	ETF	197.04	197.04	196.95	197.0	84739.0
2014-07-30 19:00:00	SPY	ETF	197.0	197.0	196.9	196.9	23354.0
2014-07-30 04:00:00	QQQ	ETF	96.73	96.78	96.73	96.78	200.0
2014-07-30 05:00:00	QQQ	ETF	96.82	96.88	96.82	96.87	3800.0
2014-07-30 06:00:00	QQQ	ETF	96.85	96.92	96.85	96.92	44100.0
2014-07-30 07:00:00	QQQ	ETF	96.91	97.02	96.91	97.01	85190.0
2014-07-30 08:00:00	QQQ	ETF	96.99	97.22	96.87	97.15	476887.0
2014-07-30 09:00:00	QQQ	ETF	97.17	97.32	96.98	97.02	4210568.0
2014-07-30 10:00:00	QQQ	ETF	97.02	97.09	96.669	96.8	5589697.0
2014-07-30 11:00:00	QQQ	ETF	96.79	96.955	96.63	96.69	3619816.0
2014-07-30 12:00:00	QQQ	ETF	96.7	96.88	96.6	96.835	2779909.0
2014-07-30 13:00:00	QQQ	ETF	96.84	96.94	96.7	96.88	1648725.0
2014-07-30 14:00:00	QQQ	ETF	96.87	97.24	96.75	96.97	8238767.0
2014-07-30 15:00:00	QQQ	ETF	96.975	97.091	96.79	96.98	4062003.0
2014-07-30 16:00:00	QQQ	ETF	96.98	97.066	96.5825	96.99	3683431.0
2014-07-30 17:00:00	QQQ	ETF	97.0	97.0	96.96	97.0	9653.0
2014-07-30 18:00:00	QQQ	ETF	97.0	97.0	96.97	97.0	5600.0
2014-07-30 19:00:00	QQQ	ETF	96.99	96.99	96.96	96.96	8128.0
2014-07-30 04:00:00	IWM	ETF	113.57	113.62	113.57	113.62	700.0
2014-07-30 06:00:00	IWM	ETF	113.9	113.94	113.9	113.94	15000.0
2014-07-30 07:00:00	IWM	ETF	113.93	114.08	113.9	114.08	78699.0
2014-07-30 08:00:00	IWM	ETF	113.9545	114.41	113.8	114.25	444167.0
2014-07-30 09:00:00	IWM	ETF	114.28	114.33	113.86	113.92	4072413.0
2014-07-30 10:00:00	IWM	ETF	113.92	114.0	113.4	113.61	5383827.0
2014-07-30 11:00:00	IWM	ETF	113.58	113.76	113.35	113.42	3089649.0
2014-07-30 12:00:00	IWM	ETF	113.41	113.72	113.31	113.64	2616670.0
2014-07-30 13:00:00	IWM	ETF	113.63	113.68	113.34	113.54	1602611.0
2014-07-30 14:00:00	IWM	ETF	113.51	114.01	113.35	113.65	5314424.0
2014-07-30 15:00:00	IWM	ETF	113.65	113.88	113.46	113.82	3611470.0
2014-07-30 16:00:00	IWM	ETF	113.81	113.9195	113.5983	113.89	694661.0
2014-07-30 17:00:00	IWM	ETF	113.89	114.0	113.78	113.78	54890.0
2014-07-30 19:00:00	IWM	ETF	113.78	113.78	113.77	113.77	989.0
2014-07-30 05:00:00	DIA	ETF	168.99	168.99	168.99	168.99	100.0
2014-07-30 08:00:00	DIA	ETF	169.24	169.54	169.0	169.39	8400.0
2014-07-30 09:00:00	DIA	ETF	169.4	169.52	168.72	168.75	689263.0
2014-07-30 10:00:00	DIA	ETF	168.75	168.81	168.05	168.18	945059.0

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

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