PREVIEW / etf_1hour / 2014-08-07

all etf 1-hour files

  file:    by_date/etf_1hour/2014/2014-08-07.parquet
  size:    223 KB
  rows:    6,941

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-07 04:00:00	SPY	ETF	192.27	192.65	192.27	192.56	19225.0
2014-08-07 05:00:00	SPY	ETF	192.63	192.63	192.38	192.56	3006.0
2014-08-07 06:00:00	SPY	ETF	192.57	192.57	192.25	192.3	56715.0
2014-08-07 07:00:00	SPY	ETF	192.3	192.52	192.3	192.43	187839.0
2014-08-07 08:00:00	SPY	ETF	192.44	193.04	192.25	192.59	2050850.0
2014-08-07 09:00:00	SPY	ETF	192.6	193.13	192.41	192.71	13926060.0
2014-08-07 10:00:00	SPY	ETF	192.71	192.925	191.835	192.15	17372104.0
2014-08-07 11:00:00	SPY	ETF	192.15	192.15	191.34	191.63	19090503.0
2014-08-07 12:00:00	SPY	ETF	191.62	191.77	190.88	191.29	15489671.0
2014-08-07 13:00:00	SPY	ETF	191.28	191.928	191.28	191.82	11052663.0
2014-08-07 14:00:00	SPY	ETF	191.82	191.83	191.04	191.06	10154978.0
2014-08-07 15:00:00	SPY	ETF	191.06	191.28	190.55	191.01	33843147.0
2014-08-07 16:00:00	SPY	ETF	191.02	192.1286	190.94	191.01	8923430.0
2014-08-07 17:00:00	SPY	ETF	191.01	191.12	191.01	191.08	50985.0
2014-08-07 18:00:00	SPY	ETF	191.07	191.17	191.04	191.15	63169.0
2014-08-07 19:00:00	SPY	ETF	191.13	191.21	191.1	191.21	154301.0
2014-08-07 04:00:00	QQQ	ETF	94.71	94.76	94.71	94.75	500.0
2014-08-07 05:00:00	QQQ	ETF	94.71	94.71	94.7	94.7	200.0
2014-08-07 06:00:00	QQQ	ETF	94.69	94.74	94.6	94.61	6200.0
2014-08-07 07:00:00	QQQ	ETF	94.69	94.71	94.62	94.63	29728.0
2014-08-07 08:00:00	QQQ	ETF	94.67	94.98	94.67	94.76	343067.0
2014-08-07 09:00:00	QQQ	ETF	94.78	95.05	94.78	95.0	3655427.0
2014-08-07 10:00:00	QQQ	ETF	95.0	95.139	94.565	94.76	5542522.0
2014-08-07 11:00:00	QQQ	ETF	94.75	94.84	94.401	94.53	4205869.0
2014-08-07 12:00:00	QQQ	ETF	94.52	94.63	94.25	94.39	3365206.0
2014-08-07 13:00:00	QQQ	ETF	94.38	94.72	94.38	94.69	2518695.0
2014-08-07 14:00:00	QQQ	ETF	94.69	94.695	94.27	94.29	2703175.0
2014-08-07 15:00:00	QQQ	ETF	94.293	94.39	93.885	94.23	7654673.0
2014-08-07 16:00:00	QQQ	ETF	94.22	94.7303	94.18	94.22	1491892.0
2014-08-07 17:00:00	QQQ	ETF	94.25	94.28	94.24	94.24	14600.0
2014-08-07 18:00:00	QQQ	ETF	94.26	94.28	94.24	94.24	11100.0
2014-08-07 19:00:00	QQQ	ETF	94.24	94.24	94.21	94.22	15100.0
2014-08-07 07:00:00	IWM	ETF	112.27	112.27	112.07	112.08	22475.0
2014-08-07 08:00:00	IWM	ETF	112.09	112.53	111.72	111.82	525464.0
2014-08-07 09:00:00	IWM	ETF	111.89	112.42	111.81	112.31	4542020.0
2014-08-07 10:00:00	IWM	ETF	112.31	112.52	111.59	111.83	5896790.0
2014-08-07 11:00:00	IWM	ETF	111.82	111.825	111.055	111.3	5889493.0
2014-08-07 12:00:00	IWM	ETF	111.3	111.49	111.06	111.25	3339160.0
2014-08-07 13:00:00	IWM	ETF	111.24	111.72	111.23	111.675	2449544.0
2014-08-07 14:00:00	IWM	ETF	111.68	111.68	111.1	111.11	2075792.0
2014-08-07 15:00:00	IWM	ETF	111.115	111.3	110.77	111.2	7918405.0
2014-08-07 16:00:00	IWM	ETF	111.19	111.21	111.0	111.01	1169573.0
2014-08-07 17:00:00	IWM	ETF	111.07	111.12	111.07	111.1	13645.0
2014-08-07 18:00:00	IWM	ETF	111.04	111.09	111.01	111.06	5850.0
2014-08-07 19:00:00	IWM	ETF	111.06	111.09	110.97	110.97	6296.0
2014-08-07 08:00:00	DIA	ETF	164.66	164.9	164.5	164.5	2400.0
2014-08-07 09:00:00	DIA	ETF	164.7	164.89	164.49	164.76	607250.0
2014-08-07 10:00:00	DIA	ETF	164.76	164.87	163.961	164.2	657691.0
2014-08-07 11:00:00	DIA	ETF	164.19	164.19	163.61	163.84	737004.0
2014-08-07 12:00:00	DIA	ETF	163.83	163.93	163.3	163.6	546937.0

> showing 50 of 6,941 rows — these rows as CSV

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