PREVIEW / etf_1hour / 2014-09-24

all etf 1-hour files

  file:    by_date/etf_1hour/2014/2014-09-24.parquet
  size:    225 KB
  rows:    7,116

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-24 04:00:00	SPY	ETF	198.01	198.09	197.89	197.95	8479.0
2014-09-24 05:00:00	SPY	ETF	197.98	198.03	197.95	197.96	5319.0
2014-09-24 06:00:00	SPY	ETF	197.97	198.32	197.97	198.17	72097.0
2014-09-24 07:00:00	SPY	ETF	198.16	198.25	198.11	198.17	328799.0
2014-09-24 08:00:00	SPY	ETF	198.16	198.27	198.03	198.04	549121.0
2014-09-24 09:00:00	SPY	ETF	198.05	198.35	197.7227	197.91	12057731.0
2014-09-24 10:00:00	SPY	ETF	197.91	198.31	197.52	198.16	17533211.0
2014-09-24 11:00:00	SPY	ETF	198.16	199.03	198.11	198.9	14401588.0
2014-09-24 12:00:00	SPY	ETF	198.91	198.96	198.63	198.73	6897444.0
2014-09-24 13:00:00	SPY	ETF	198.735	199.18	198.68	199.1	10695434.0
2014-09-24 14:00:00	SPY	ETF	199.1	199.55	199.03	199.51	11311744.0
2014-09-24 15:00:00	SPY	ETF	199.52	199.69	199.44	199.57	22610222.0
2014-09-24 16:00:00	SPY	ETF	199.57	199.59	197.9603	199.5	8853300.0
2014-09-24 17:00:00	SPY	ETF	199.5	199.6	199.46	199.54	156263.0
2014-09-24 18:00:00	SPY	ETF	199.51	199.57	199.49	199.55	56863.0
2014-09-24 19:00:00	SPY	ETF	199.55	199.57	199.54	199.57	58304.0
2014-09-24 04:00:00	QQQ	ETF	98.74	98.74	98.74	98.74	2500.0
2014-09-24 05:00:00	QQQ	ETF	98.8	98.82	98.76	98.76	1900.0
2014-09-24 06:00:00	QQQ	ETF	98.8	99.03	98.8	98.95	19000.0
2014-09-24 07:00:00	QQQ	ETF	98.89	98.95	98.88	98.91	33450.0
2014-09-24 08:00:00	QQQ	ETF	98.91	98.95	98.84	98.84	75968.0
2014-09-24 09:00:00	QQQ	ETF	98.83	99.15	98.71	98.89	4412294.0
2014-09-24 10:00:00	QQQ	ETF	98.87	99.04	98.54	98.92	5981252.0
2014-09-24 11:00:00	QQQ	ETF	98.93	99.55	98.905	99.52	4749050.0
2014-09-24 12:00:00	QQQ	ETF	99.525	99.54	99.35	99.3866	2638651.0
2014-09-24 13:00:00	QQQ	ETF	99.38	99.719	99.36	99.65	3312182.0
2014-09-24 14:00:00	QQQ	ETF	99.66	99.76	99.56	99.74	3234028.0
2014-09-24 15:00:00	QQQ	ETF	99.74	99.8868	99.69	99.83	5694411.0
2014-09-24 16:00:00	QQQ	ETF	99.84	99.9	98.7913	99.83	2438326.0
2014-09-24 17:00:00	QQQ	ETF	99.84	99.84	99.8	99.81	57790.0
2014-09-24 18:00:00	QQQ	ETF	99.81	99.84	99.78	99.84	17732.0
2014-09-24 19:00:00	QQQ	ETF	99.83	99.85	99.82	99.84	25850.0
2014-09-24 04:00:00	IWM	ETF	111.2	111.27	111.07	111.07	1620.0
2014-09-24 05:00:00	IWM	ETF	111.08	111.2	111.08	111.2	500.0
2014-09-24 06:00:00	IWM	ETF	111.26	111.44	111.26	111.4	15120.0
2014-09-24 07:00:00	IWM	ETF	111.4	111.5	111.36	111.36	43650.0
2014-09-24 08:00:00	IWM	ETF	111.38	111.46	111.26	111.26	207430.0
2014-09-24 09:00:00	IWM	ETF	111.26	111.5	110.88	111.04	4545208.0
2014-09-24 10:00:00	IWM	ETF	111.0501	111.43	110.6	111.26	7070078.0
2014-09-24 11:00:00	IWM	ETF	111.27	111.86	111.2	111.73	3814970.0
2014-09-24 12:00:00	IWM	ETF	111.73	111.81	111.36	111.45	2252189.0
2014-09-24 13:00:00	IWM	ETF	111.45	111.78	111.41	111.68	1623436.0
2014-09-24 14:00:00	IWM	ETF	111.68	112.0	111.62	111.985	2716466.0
2014-09-24 15:00:00	IWM	ETF	111.985	112.11	111.84	112.01	5346195.0
2014-09-24 16:00:00	IWM	ETF	112.0	112.08	111.0686	111.99	1335755.0
2014-09-24 17:00:00	IWM	ETF	112.0	112.08	111.97	112.0	212825.0
2014-09-24 18:00:00	IWM	ETF	111.9	112.0	111.85	112.0	15660.0
2014-09-24 19:00:00	IWM	ETF	112.02	112.02	111.95	111.95	3042.0
2014-09-24 06:00:00	DIA	ETF	170.34	170.34	170.34	170.34	100.0
2014-09-24 08:00:00	DIA	ETF	170.52	170.52	170.4	170.4	12037.0

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

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