PREVIEW / etf_1hour / 2014-09-02

all etf 1-hour files

  file:    by_date/etf_1hour/2014/2014-09-02.parquet
  size:    227 KB
  rows:    7,238

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-09-02 04:00:00	SPY	ETF	200.91	201.18	200.91	201.18	6720.0
2014-09-02 05:00:00	SPY	ETF	201.15	201.15	201.08	201.08	1427.0
2014-09-02 06:00:00	SPY	ETF	201.08	201.15	201.07	201.07	43561.0
2014-09-02 07:00:00	SPY	ETF	201.07	201.11	200.75	200.88	221461.0
2014-09-02 08:00:00	SPY	ETF	201.07	201.07	200.7809	200.82	451835.0
2014-09-02 09:00:00	SPY	ETF	200.83	201.09	200.48	200.67	11605490.0
2014-09-02 10:00:00	SPY	ETF	200.69	200.94	200.46	200.94	8613430.0
2014-09-02 11:00:00	SPY	ETF	200.93	200.98	200.22	200.28	9402599.0
2014-09-02 12:00:00	SPY	ETF	200.28	200.6	199.94	199.98	7124915.0
2014-09-02 13:00:00	SPY	ETF	199.96	200.16	199.86	200.13	9474888.0
2014-09-02 14:00:00	SPY	ETF	200.13	200.48	200.1	200.43	6447933.0
2014-09-02 15:00:00	SPY	ETF	200.43	200.65	200.31	200.59	10325368.0
2014-09-02 16:00:00	SPY	ETF	200.6	200.7343	200.003	200.65	6554583.0
2014-09-02 17:00:00	SPY	ETF	200.68	200.69	200.56	200.57	812592.0
2014-09-02 18:00:00	SPY	ETF	200.58	200.61	200.51	200.57	251742.0
2014-09-02 19:00:00	SPY	ETF	200.57	200.64	200.57	200.62	28105.0
2014-09-02 04:00:00	QQQ	ETF	99.9	99.9	99.9	99.9	100.0
2014-09-02 06:00:00	QQQ	ETF	99.99	100.04	99.99	100.02	8420.0
2014-09-02 07:00:00	QQQ	ETF	100.02	100.03	99.87	99.91	43993.0
2014-09-02 08:00:00	QQQ	ETF	99.91	99.98	99.9	99.9	189146.0
2014-09-02 09:00:00	QQQ	ETF	99.94	100.1	99.8	99.87	2823981.0
2014-09-02 10:00:00	QQQ	ETF	99.88	100.08	99.81	100.08	3333032.0
2014-09-02 11:00:00	QQQ	ETF	100.08	100.1	99.81	99.83	2373233.0
2014-09-02 12:00:00	QQQ	ETF	99.82	99.95	99.7	99.7	2404779.0
2014-09-02 13:00:00	QQQ	ETF	99.7	99.85	99.6601	99.83	1521238.0
2014-09-02 14:00:00	QQQ	ETF	99.831	99.9311	99.81	99.89	1235160.0
2014-09-02 15:00:00	QQQ	ETF	99.89	100.089	99.86	100.07	2631800.0
2014-09-02 16:00:00	QQQ	ETF	100.07	100.097	99.904	100.09	1326110.0
2014-09-02 17:00:00	QQQ	ETF	100.06	100.12	100.06	100.06	22058.0
2014-09-02 18:00:00	QQQ	ETF	100.03	100.03	100.0	100.02	9027.0
2014-09-02 19:00:00	QQQ	ETF	100.02	100.03	100.02	100.02	4090.0
2014-09-02 04:00:00	IWM	ETF	116.63	117.25	116.63	117.25	1000.0
2014-09-02 07:00:00	IWM	ETF	117.02	117.17	116.99	117.05	82500.0
2014-09-02 08:00:00	IWM	ETF	117.07	117.21	116.93	116.95	101844.0
2014-09-02 09:00:00	IWM	ETF	116.95	117.24	116.59	117.24	3607598.0
2014-09-02 10:00:00	IWM	ETF	117.24	117.5	117.09	117.49	4383730.0
2014-09-02 11:00:00	IWM	ETF	117.48	117.5	116.545	116.625	3772592.0
2014-09-02 12:00:00	IWM	ETF	116.62	116.96	116.5	116.6	2555263.0
2014-09-02 13:00:00	IWM	ETF	116.605	116.97	116.54	116.955	2966816.0
2014-09-02 14:00:00	IWM	ETF	116.95	117.355	116.93	117.265	3313123.0
2014-09-02 15:00:00	IWM	ETF	117.255	117.31	117.13	117.2	6017366.0
2014-09-02 16:00:00	IWM	ETF	117.2	117.332	115.14	117.2	4139474.0
2014-09-02 17:00:00	IWM	ETF	117.23	117.23	117.23	117.23	934.0
2014-09-02 19:00:00	IWM	ETF	117.19	117.19	117.19	117.19	2340.0
2014-09-02 08:00:00	DIA	ETF	171.05	171.06	171.05	171.06	585.0
2014-09-02 09:00:00	DIA	ETF	170.95	171.22	170.45	170.59	670953.0
2014-09-02 10:00:00	DIA	ETF	170.63	171.021	170.42	171.02	544918.0
2014-09-02 11:00:00	DIA	ETF	171.02	171.07	170.46	170.51	447141.0
2014-09-02 12:00:00	DIA	ETF	170.5	170.58	170.151	170.18	352475.0
2014-09-02 13:00:00	DIA	ETF	170.19	170.3	170.04	170.24	344746.0

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

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