PREVIEW / etf_1hour / 2014-08-01

all etf 1-hour files

  file:    by_date/etf_1hour/2014/2014-08-01.parquet
  size:    235 KB
  rows:    7,401

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-08-01 04:00:00	SPY	ETF	193.03	193.08	192.2	192.31	17119.0
2014-08-01 05:00:00	SPY	ETF	192.31	192.31	191.64	191.69	149378.0
2014-08-01 06:00:00	SPY	ETF	191.72	192.19	191.67	192.02	341124.0
2014-08-01 07:00:00	SPY	ETF	192.0	192.26	191.76	192.16	1912886.0
2014-08-01 08:00:00	SPY	ETF	192.08	193.67	191.75	192.76	9527681.0
2014-08-01 09:00:00	SPY	ETF	192.78	193.54	192.34	193.41	23731390.0
2014-08-01 10:00:00	SPY	ETF	193.41	193.76	192.75	192.87	30443635.0
2014-08-01 11:00:00	SPY	ETF	192.86	192.89	191.57	191.7401	28479356.0
2014-08-01 12:00:00	SPY	ETF	191.74	192.2	191.63	192.04	20899370.0
2014-08-01 13:00:00	SPY	ETF	192.03	192.99	191.78	192.91	20116451.0
2014-08-01 14:00:00	SPY	ETF	192.92	193.2	192.59	192.74	13396391.0
2014-08-01 15:00:00	SPY	ETF	192.75	193.03	192.34	192.49	23561139.0
2014-08-01 16:00:00	SPY	ETF	192.51	193.098	192.13	192.39	13481834.0
2014-08-01 17:00:00	SPY	ETF	192.37	192.4	192.19	192.2	279538.0
2014-08-01 18:00:00	SPY	ETF	192.2	192.27	192.2	192.22	113822.0
2014-08-01 19:00:00	SPY	ETF	192.21	192.4	192.2	192.34	55898.0
2014-08-01 04:00:00	QQQ	ETF	95.08	95.08	94.55	94.6	15200.0
2014-08-01 05:00:00	QQQ	ETF	94.55	94.57	94.2	94.26	49100.0
2014-08-01 06:00:00	QQQ	ETF	94.36	94.48	94.21	94.35	33575.0
2014-08-01 07:00:00	QQQ	ETF	94.32	94.55	94.25	94.54	86350.0
2014-08-01 08:00:00	QQQ	ETF	94.52	95.04	94.32	94.89	1250948.0
2014-08-01 09:00:00	QQQ	ETF	94.9	95.34	94.73	95.26	7109809.0
2014-08-01 10:00:00	QQQ	ETF	95.26	95.34	94.689	94.76	7542191.0
2014-08-01 11:00:00	QQQ	ETF	94.755	94.8	94.151	94.24	13174865.0
2014-08-01 12:00:00	QQQ	ETF	94.235	94.44	94.04	94.285	6570731.0
2014-08-01 13:00:00	QQQ	ETF	94.29	94.73	94.13	94.69	10573698.0
2014-08-01 14:00:00	QQQ	ETF	94.69	94.9	94.56	94.631	3693253.0
2014-08-01 15:00:00	QQQ	ETF	94.63	94.81	94.56	94.66	5393084.0
2014-08-01 16:00:00	QQQ	ETF	94.67	94.82	94.54	94.66	1300527.0
2014-08-01 17:00:00	QQQ	ETF	94.66	94.68	94.57	94.61	25947.0
2014-08-01 18:00:00	QQQ	ETF	94.61	94.61	94.6	94.6	6389.0
2014-08-01 19:00:00	QQQ	ETF	94.6	94.61	94.6	94.61	8250.0
2014-08-01 04:00:00	IWM	ETF	111.36	111.36	110.92	110.92	600.0
2014-08-01 05:00:00	IWM	ETF	110.8	110.8	110.74	110.74	200.0
2014-08-01 06:00:00	IWM	ETF	110.51	110.65	110.51	110.65	2000.0
2014-08-01 07:00:00	IWM	ETF	110.76	110.99	110.75	110.92	33672.0
2014-08-01 08:00:00	IWM	ETF	110.9	111.67	110.76	111.58	901998.0
2014-08-01 09:00:00	IWM	ETF	111.58	111.7	110.99	111.49	5673167.0
2014-08-01 10:00:00	IWM	ETF	111.5	111.56	110.63	110.64	7382038.0
2014-08-01 11:00:00	IWM	ETF	110.645	110.675	109.87	109.94	7625280.0
2014-08-01 12:00:00	IWM	ETF	109.94	110.26	109.86	110.16	5107989.0
2014-08-01 13:00:00	IWM	ETF	110.155	110.52	110.02	110.46	6363890.0
2014-08-01 14:00:00	IWM	ETF	110.455	110.81	110.35	110.43	5995278.0
2014-08-01 15:00:00	IWM	ETF	110.435	110.73	110.37	110.73	7901484.0
2014-08-01 16:00:00	IWM	ETF	110.71	110.79	110.5525	110.65	1287765.0
2014-08-01 17:00:00	IWM	ETF	110.67	110.67	110.43	110.43	15048.0
2014-08-01 04:00:00	DIA	ETF	164.88	164.88	164.88	164.88	100.0
2014-08-01 05:00:00	DIA	ETF	164.56	164.56	164.13	164.13	14900.0
2014-08-01 07:00:00	DIA	ETF	164.2	164.66	164.2	164.66	46213.0
2014-08-01 08:00:00	DIA	ETF	164.66	165.3	164.14	165.06	37326.0

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

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