PREVIEW / etf_1hour / 2014-09-22

all etf 1-hour files

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

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-22 04:00:00	SPY	ETF	199.96	199.97	199.73	199.92	9913.0
2014-09-22 05:00:00	SPY	ETF	199.89	200.04	199.85	200.04	2032.0
2014-09-22 06:00:00	SPY	ETF	199.98	200.18	199.98	200.15	38813.0
2014-09-22 07:00:00	SPY	ETF	200.17	200.28	200.05	200.17	133214.0
2014-09-22 08:00:00	SPY	ETF	200.6034	200.6034	199.82	200.16	591333.0
2014-09-22 09:00:00	SPY	ETF	200.18	200.38	199.83	199.95	12745670.0
2014-09-22 10:00:00	SPY	ETF	199.955	200.23	199.17	199.28	15682806.0
2014-09-22 11:00:00	SPY	ETF	199.27	199.45	198.92	199.025	13096881.0
2014-09-22 12:00:00	SPY	ETF	199.03	199.26	198.85	199.16	12284520.0
2014-09-22 13:00:00	SPY	ETF	199.16	199.37	198.94	199.035	13174550.0
2014-09-22 14:00:00	SPY	ETF	199.035	199.14	198.73	199.035	14689574.0
2014-09-22 15:00:00	SPY	ETF	199.04	199.29	198.81	199.14	17881685.0
2014-09-22 16:00:00	SPY	ETF	199.13	199.19	198.96	198.97	23539370.0
2014-09-22 17:00:00	SPY	ETF	198.95	198.97	198.76	198.87	314666.0
2014-09-22 18:00:00	SPY	ETF	198.86	199.01	198.86	198.99	82189.0
2014-09-22 19:00:00	SPY	ETF	198.99	199.0	198.93	198.93	35127.0
2014-09-22 04:00:00	QQQ	ETF	99.37	99.49	99.37	99.38	9700.0
2014-09-22 05:00:00	QQQ	ETF	99.45	99.45	99.43	99.43	450.0
2014-09-22 06:00:00	QQQ	ETF	99.46	99.66	99.46	99.65	43072.0
2014-09-22 07:00:00	QQQ	ETF	99.67	99.72	99.64	99.64	27635.0
2014-09-22 08:00:00	QQQ	ETF	99.65	99.73	99.56	99.63	197971.0
2014-09-22 09:00:00	QQQ	ETF	99.65	99.75	99.46	99.52	5992607.0
2014-09-22 10:00:00	QQQ	ETF	99.52	99.67	98.86	98.93	8784380.0
2014-09-22 11:00:00	QQQ	ETF	98.93	99.04	98.68	98.78	5649887.0
2014-09-22 12:00:00	QQQ	ETF	98.78	98.9	98.64	98.841	4603586.0
2014-09-22 13:00:00	QQQ	ETF	98.84	98.88	98.69	98.7	3173672.0
2014-09-22 14:00:00	QQQ	ETF	98.705	98.94	98.62	98.9	4121141.0
2014-09-22 15:00:00	QQQ	ETF	98.91	99.13	98.82	99.055	6411620.0
2014-09-22 16:00:00	QQQ	ETF	99.05	99.0829	98.93	98.94	1273965.0
2014-09-22 17:00:00	QQQ	ETF	98.94	98.96	98.81	98.81	61075.0
2014-09-22 18:00:00	QQQ	ETF	98.84	99.03	98.84	99.03	87858.0
2014-09-22 19:00:00	QQQ	ETF	98.95	98.95	98.88	98.89	8450.0
2014-09-22 04:00:00	IWM	ETF	113.35	113.35	112.57	112.57	1108.0
2014-09-22 05:00:00	IWM	ETF	112.5	112.5	112.5	112.5	300.0
2014-09-22 06:00:00	IWM	ETF	112.8	113.1	112.8	113.03	5700.0
2014-09-22 07:00:00	IWM	ETF	113.0	113.27	113.0	113.1	6620.0
2014-09-22 08:00:00	IWM	ETF	113.18	113.37	113.1	113.37	124652.0
2014-09-22 09:00:00	IWM	ETF	113.38	113.53	112.74	112.95	6455720.0
2014-09-22 10:00:00	IWM	ETF	112.96	113.38	112.28	112.42	10784945.0
2014-09-22 11:00:00	IWM	ETF	112.41	112.55	112.1	112.175	4359716.0
2014-09-22 12:00:00	IWM	ETF	112.175	112.5	112.05	112.38	3284402.0
2014-09-22 13:00:00	IWM	ETF	112.38	112.54	112.23	112.4	2566585.0
2014-09-22 14:00:00	IWM	ETF	112.4	112.5	112.16	112.45	2575266.0
2014-09-22 15:00:00	IWM	ETF	112.445	112.56	112.27	112.385	6458912.0
2014-09-22 16:00:00	IWM	ETF	112.38	112.41	112.05	112.08	1460249.0
2014-09-22 17:00:00	IWM	ETF	112.06	112.06	111.94	112.0	22371.0
2014-09-22 18:00:00	IWM	ETF	112.43	112.43	112.06	112.15	13539.0
2014-09-22 19:00:00	IWM	ETF	112.15	112.15	112.15	112.15	200.0
2014-09-22 07:00:00	DIA	ETF	172.23	172.23	172.21	172.21	3310.0
2014-09-22 08:00:00	DIA	ETF	172.29	172.3	172.17	172.19	11511.0

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

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