PREVIEW / etf_1hour / 2014-07-16

all etf 1-hour files

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

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-16 04:00:00	SPY	ETF	197.5	197.82	197.49	197.82	3620.0
2014-07-16 05:00:00	SPY	ETF	197.86	197.87	197.74	197.81	6153.0
2014-07-16 06:00:00	SPY	ETF	197.84	197.92	197.75	197.89	60135.0
2014-07-16 07:00:00	SPY	ETF	197.88	198.01	197.88	197.95	388754.0
2014-07-16 08:00:00	SPY	ETF	197.93	198.23	197.91	198.1	1696350.0
2014-07-16 09:00:00	SPY	ETF	198.1	198.26	197.74	197.93	11501008.0
2014-07-16 10:00:00	SPY	ETF	197.93	198.07	197.52	197.57	12267614.0
2014-07-16 11:00:00	SPY	ETF	197.59	197.8	197.42	197.64	7708208.0
2014-07-16 12:00:00	SPY	ETF	197.63	198.03	197.6	197.9301	8432599.0
2014-07-16 13:00:00	SPY	ETF	197.94	198.07	197.9	198.041	4824895.0
2014-07-16 14:00:00	SPY	ETF	198.04	198.15	197.92	197.92	7088392.0
2014-07-16 15:00:00	SPY	ETF	197.925	198.07	197.87	197.97	13247795.0
2014-07-16 16:00:00	SPY	ETF	197.98	198.04	197.2089	197.72	10854077.0
2014-07-16 17:00:00	SPY	ETF	197.72	197.74	197.63	197.63	144443.0
2014-07-16 18:00:00	SPY	ETF	197.63	197.73	197.61	197.62	52650.0
2014-07-16 19:00:00	SPY	ETF	197.63	197.68	197.62	197.66	37990.0
2014-07-16 05:00:00	QQQ	ETF	96.01	96.02	96.0	96.0	10150.0
2014-07-16 06:00:00	QQQ	ETF	96.05	96.11	96.02	96.05	41700.0
2014-07-16 07:00:00	QQQ	ETF	96.07	96.16	96.03	96.12	104596.0
2014-07-16 08:00:00	QQQ	ETF	96.12	96.27	96.08	96.22	550689.0
2014-07-16 09:00:00	QQQ	ETF	96.22	96.3	96.01	96.2	4520974.0
2014-07-16 10:00:00	QQQ	ETF	96.2	96.28	95.89	95.929	3750821.0
2014-07-16 11:00:00	QQQ	ETF	95.92	96.09	95.785	95.8999	2107791.0
2014-07-16 12:00:00	QQQ	ETF	95.89	96.18	95.88	96.09	1636105.0
2014-07-16 13:00:00	QQQ	ETF	96.1	96.18	96.03	96.1	1587250.0
2014-07-16 14:00:00	QQQ	ETF	96.09	96.17	96.05	96.0599	1554987.0
2014-07-16 15:00:00	QQQ	ETF	96.051	96.1	95.88	95.9	4378060.0
2014-07-16 16:00:00	QQQ	ETF	95.9	96.21	95.8	95.8	1170737.0
2014-07-16 17:00:00	QQQ	ETF	95.8	95.83	95.68	95.74	23099.0
2014-07-16 18:00:00	QQQ	ETF	95.75	95.79	95.74	95.74	3650.0
2014-07-16 19:00:00	QQQ	ETF	95.74	95.79	95.74	95.79	9074.0
2014-07-16 06:00:00	IWM	ETF	114.9	114.95	114.85	114.89	4250.0
2014-07-16 07:00:00	IWM	ETF	114.92	115.01	114.87	114.9	85754.0
2014-07-16 08:00:00	IWM	ETF	114.9	115.31	114.87	115.18	285521.0
2014-07-16 09:00:00	IWM	ETF	115.19	115.23	114.15	114.38	6099457.0
2014-07-16 10:00:00	IWM	ETF	114.41	114.88	113.82	114.02	10550947.0
2014-07-16 11:00:00	IWM	ETF	114.03	114.45	113.855	114.18	4314209.0
2014-07-16 12:00:00	IWM	ETF	114.17	114.74	114.13	114.66	4580604.0
2014-07-16 13:00:00	IWM	ETF	114.67	114.74	114.47	114.72	3087852.0
2014-07-16 14:00:00	IWM	ETF	114.71	114.9	114.2	114.231	5001383.0
2014-07-16 15:00:00	IWM	ETF	114.24	114.46	114.16	114.27	6745210.0
2014-07-16 16:00:00	IWM	ETF	114.27	114.69	114.11	114.11	927239.0
2014-07-16 17:00:00	IWM	ETF	114.08	114.08	113.97	114.0	19254.0
2014-07-16 18:00:00	IWM	ETF	114.03	114.08	114.02	114.02	700.0
2014-07-16 19:00:00	IWM	ETF	114.01	114.09	114.0	114.0	3685.0
2014-07-16 04:00:00	DIA	ETF	170.68	170.68	170.68	170.68	100.0
2014-07-16 06:00:00	DIA	ETF	170.87	170.9	170.87	170.89	4100.0
2014-07-16 07:00:00	DIA	ETF	170.9	170.93	170.86	170.86	5300.0
2014-07-16 08:00:00	DIA	ETF	170.88	171.03	170.88	170.96	18163.0
2014-07-16 09:00:00	DIA	ETF	170.96	171.1301	170.72	170.85	727274.0

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

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