PREVIEW / etf_1hour / 2013-06-13

all etf 1-hour files

  file:    by_date/etf_1hour/2013/2013-06-13.parquet
  size:    213 KB
  rows:    6,585

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
2013-06-13 04:00:00	SPY	ETF	161.04	161.04	160.44	160.81	73115.0
2013-06-13 05:00:00	SPY	ETF	160.85	160.99	160.61	160.83	87295.0
2013-06-13 06:00:00	SPY	ETF	160.86	161.29	160.84	161.11	403000.0
2013-06-13 07:00:00	SPY	ETF	161.11	161.21	160.95	161.17	644224.0
2013-06-13 08:00:00	SPY	ETF	161.15	161.79	160.75	161.71	2416710.0
2013-06-13 09:00:00	SPY	ETF	161.68	162.03	161.3	162.01	23535412.0
2013-06-13 10:00:00	SPY	ETF	162.01	162.43	161.72	162.13	22789962.0
2013-06-13 11:00:00	SPY	ETF	162.13	162.53	162.04	162.499	13796028.0
2013-06-13 12:00:00	SPY	ETF	162.5	163.06	162.36	163.06	10956089.0
2013-06-13 13:00:00	SPY	ETF	163.05	163.07	162.7	162.9399	11086673.0
2013-06-13 14:00:00	SPY	ETF	162.94	163.54	162.93	163.529	13692917.0
2013-06-13 15:00:00	SPY	ETF	163.53	164.5	163.52	164.21	41536530.0
2013-06-13 16:00:00	SPY	ETF	164.21	164.28	161.8005	164.25	14207112.0
2013-06-13 17:00:00	SPY	ETF	164.24	164.29	164.2	164.28	4682685.0
2013-06-13 18:00:00	SPY	ETF	164.28	164.54	164.27	164.32	308662.0
2013-06-13 19:00:00	SPY	ETF	164.31	164.44	164.3	164.42	90599.0
2013-06-13 04:00:00	QQQ	ETF	71.5	71.5	71.26	71.42	12375.0
2013-06-13 05:00:00	QQQ	ETF	71.38	71.46	71.32	71.41	6200.0
2013-06-13 06:00:00	QQQ	ETF	71.44	71.56	71.44	71.5	5629.0
2013-06-13 07:00:00	QQQ	ETF	71.51	71.56	71.49	71.56	5660.0
2013-06-13 08:00:00	QQQ	ETF	71.56	71.81	71.52	71.8	115595.0
2013-06-13 09:00:00	QQQ	ETF	71.8	71.91	71.55	71.89	4764689.0
2013-06-13 10:00:00	QQQ	ETF	71.9	72.12	71.71	71.98	4807177.0
2013-06-13 11:00:00	QQQ	ETF	71.99	72.155	71.92	72.1301	2802953.0
2013-06-13 12:00:00	QQQ	ETF	72.14	72.34	72.07	72.34	2180717.0
2013-06-13 13:00:00	QQQ	ETF	72.34	72.35	72.1845	72.32	1973500.0
2013-06-13 14:00:00	QQQ	ETF	72.32	72.59	72.32	72.54	2247174.0
2013-06-13 15:00:00	QQQ	ETF	72.54	72.92	72.5399	72.75	7744301.0
2013-06-13 16:00:00	QQQ	ETF	72.74	72.76	71.839	72.74	1421127.0
2013-06-13 17:00:00	QQQ	ETF	72.77	72.81	72.76	72.76	9621.0
2013-06-13 18:00:00	QQQ	ETF	72.79	72.86	72.79	72.85	6542.0
2013-06-13 19:00:00	QQQ	ETF	72.81	72.87	72.81	72.85	8250.0
2013-06-13 04:00:00	IWM	ETF	96.38	96.38	96.0	96.0	600.0
2013-06-13 05:00:00	IWM	ETF	96.0	96.0	96.0	96.0	200.0
2013-06-13 06:00:00	IWM	ETF	96.3	96.56	96.28	96.28	2300.0
2013-06-13 07:00:00	IWM	ETF	96.25	96.32	96.22	96.27	35525.0
2013-06-13 08:00:00	IWM	ETF	96.28	96.9	96.0	96.84	694344.0
2013-06-13 09:00:00	IWM	ETF	96.83	97.0	96.37	96.92	5444985.0
2013-06-13 10:00:00	IWM	ETF	96.9	97.16	96.57	97.05	7521311.0
2013-06-13 11:00:00	IWM	ETF	97.05	97.45	96.98	97.42	5182456.0
2013-06-13 12:00:00	IWM	ETF	97.43	97.76	97.37	97.75	3774556.0
2013-06-13 13:00:00	IWM	ETF	97.76	97.8	97.56	97.76	3061434.0
2013-06-13 14:00:00	IWM	ETF	97.77	98.18	97.77	98.13	3570214.0
2013-06-13 15:00:00	IWM	ETF	98.13	98.7	98.13	98.45	11238489.0
2013-06-13 16:00:00	IWM	ETF	98.45	98.54	97.8215	98.49	1971032.0
2013-06-13 17:00:00	IWM	ETF	98.49	98.52	98.4	98.45	63667.0
2013-06-13 18:00:00	IWM	ETF	98.5	98.54	98.5	98.5	11434.0
2013-06-13 07:00:00	DIA	ETF	149.36	149.49	149.36	149.44	3117.0
2013-06-13 08:00:00	DIA	ETF	149.49	149.74	149.29	149.74	15716.0
2013-06-13 09:00:00	DIA	ETF	149.83	150.12	149.48	150.07	831177.0

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

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