PREVIEW / etf_1hour / 2014-07-23

all etf 1-hour files

  file:    by_date/etf_1hour/2014/2014-07-23.parquet
  size:    221 KB
  rows:    7,316

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-23 04:00:00	SPY	ETF	198.14	198.23	198.12	198.2	16895.0
2014-07-23 05:00:00	SPY	ETF	198.21	198.27	198.2	198.21	1762.0
2014-07-23 06:00:00	SPY	ETF	198.27	198.41	198.24	198.24	67858.0
2014-07-23 07:00:00	SPY	ETF	198.26	198.4	198.25	198.25	200922.0
2014-07-23 08:00:00	SPY	ETF	198.29	198.4	198.21	198.36	246219.0
2014-07-23 09:00:00	SPY	ETF	198.37	198.61	198.1	198.28	8999676.0
2014-07-23 10:00:00	SPY	ETF	198.29	198.85	198.19	198.7	9958514.0
2014-07-23 11:00:00	SPY	ETF	198.7	198.81	198.65	198.73	5751704.0
2014-07-23 12:00:00	SPY	ETF	198.73	198.76	198.34	198.485	7432702.0
2014-07-23 13:00:00	SPY	ETF	198.49	198.76	198.42	198.73	5481866.0
2014-07-23 14:00:00	SPY	ETF	198.725	198.78	198.61	198.68	4317746.0
2014-07-23 15:00:00	SPY	ETF	198.69	198.76	198.6	198.65	9497410.0
2014-07-23 16:00:00	SPY	ETF	198.64	198.69	198.2562	198.63	4513292.0
2014-07-23 17:00:00	SPY	ETF	198.63	198.67	198.6	198.64	4170706.0
2014-07-23 18:00:00	SPY	ETF	198.61	198.66	198.55	198.55	34726.0
2014-07-23 19:00:00	SPY	ETF	198.58	198.63	198.58	198.62	30484.0
2014-07-23 06:00:00	QQQ	ETF	96.7	96.76	96.69	96.71	4800.0
2014-07-23 07:00:00	QQQ	ETF	96.67	96.97	96.67	96.85	174361.0
2014-07-23 08:00:00	QQQ	ETF	96.85	96.91	96.74	96.89	316890.0
2014-07-23 09:00:00	QQQ	ETF	96.89	97.1	96.77	96.95	5910528.0
2014-07-23 10:00:00	QQQ	ETF	96.96	97.34	96.87	97.2347	5667895.0
2014-07-23 11:00:00	QQQ	ETF	97.24	97.32	97.16	97.21	3083573.0
2014-07-23 12:00:00	QQQ	ETF	97.22	97.287	97.04	97.14	1696894.0
2014-07-23 13:00:00	QQQ	ETF	97.1454	97.2678	97.08	97.25	1059288.0
2014-07-23 14:00:00	QQQ	ETF	97.25	97.32	97.2	97.25	1652976.0
2014-07-23 15:00:00	QQQ	ETF	97.25	97.32	97.19	97.22	3367860.0
2014-07-23 16:00:00	QQQ	ETF	97.22	97.3	97.07	97.2	2908524.0
2014-07-23 17:00:00	QQQ	ETF	97.2	97.26	97.2	97.25	13637.0
2014-07-23 18:00:00	QQQ	ETF	97.25	97.25	97.2	97.2	10115.0
2014-07-23 19:00:00	QQQ	ETF	97.22	97.26	97.22	97.24	20986.0
2014-07-23 04:00:00	IWM	ETF	114.72	114.78	114.72	114.78	700.0
2014-07-23 05:00:00	IWM	ETF	114.78	114.82	114.78	114.8	300.0
2014-07-23 06:00:00	IWM	ETF	114.98	114.98	114.93	114.93	200.0
2014-07-23 07:00:00	IWM	ETF	114.87	114.94	114.87	114.89	15200.0
2014-07-23 08:00:00	IWM	ETF	114.89	115.02	114.87	114.99	103081.0
2014-07-23 09:00:00	IWM	ETF	114.99	115.07	114.51	114.76	4164438.0
2014-07-23 10:00:00	IWM	ETF	114.77	115.44	114.605	115.25	5957172.0
2014-07-23 11:00:00	IWM	ETF	115.25	115.44	115.16	115.36	3329093.0
2014-07-23 12:00:00	IWM	ETF	115.37	115.38	114.63	114.79	2352230.0
2014-07-23 13:00:00	IWM	ETF	114.79	115.02	114.73	114.96	1663671.0
2014-07-23 14:00:00	IWM	ETF	114.9631	114.99	114.73	114.805	1420755.0
2014-07-23 15:00:00	IWM	ETF	114.8	114.9699	114.74	114.88	3455789.0
2014-07-23 16:00:00	IWM	ETF	114.88	114.97	114.8	114.9	641649.0
2014-07-23 17:00:00	IWM	ETF	114.87	114.91	114.85	114.85	9166.0
2014-07-23 18:00:00	IWM	ETF	114.87	114.87	114.87	114.87	100.0
2014-07-23 19:00:00	IWM	ETF	114.87	114.87	114.87	114.87	622.0
2014-07-23 06:00:00	DIA	ETF	170.81	170.81	170.81	170.81	294.0
2014-07-23 07:00:00	DIA	ETF	170.83	170.83	170.8	170.8	394.0
2014-07-23 08:00:00	DIA	ETF	170.8	170.8	170.72	170.72	2400.0
2014-07-23 09:00:00	DIA	ETF	170.68	170.83	170.2	170.41	774633.0

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

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