PREVIEW / etf_1hour / 2013-05-13

all etf 1-hour files

  file:    by_date/etf_1hour/2013/2013-05-13.parquet
  size:    200 KB
  rows:    6,320

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-05-13 04:00:00	SPY	ETF	163.01	163.01	162.86	162.93	6499.0
2013-05-13 05:00:00	SPY	ETF	162.9	162.9	162.71	162.71	15928.0
2013-05-13 06:00:00	SPY	ETF	162.73	162.92	162.71	162.84	57674.0
2013-05-13 07:00:00	SPY	ETF	162.83	163.08	162.83	163.06	441545.0
2013-05-13 08:00:00	SPY	ETF	163.06	163.27	162.71	163.21	1502930.0
2013-05-13 09:00:00	SPY	ETF	163.19	163.33	162.82	162.93	11265599.0
2013-05-13 10:00:00	SPY	ETF	162.93	163.46	162.85	163.3196	15003336.0
2013-05-13 11:00:00	SPY	ETF	163.32	163.67	163.16	163.63	10545461.0
2013-05-13 12:00:00	SPY	ETF	163.63	163.81	162.93	163.6201	6272229.0
2013-05-13 13:00:00	SPY	ETF	163.63	163.73	163.35	163.41	6488912.0
2013-05-13 14:00:00	SPY	ETF	163.41	163.64	163.34	163.64	7564567.0
2013-05-13 15:00:00	SPY	ETF	163.64	163.67	163.29	163.54	15898214.0
2013-05-13 16:00:00	SPY	ETF	163.54	163.63	163.3392	163.57	2980882.0
2013-05-13 17:00:00	SPY	ETF	163.58	163.61	163.54	163.59	1664313.0
2013-05-13 18:00:00	SPY	ETF	163.58	163.6	163.56	163.58	65806.0
2013-05-13 19:00:00	SPY	ETF	163.58	163.77	163.58	163.76	89325.0
2013-05-13 04:00:00	QQQ	ETF	72.78	72.78	72.77	72.77	300.0
2013-05-13 05:00:00	QQQ	ETF	72.69	72.69	72.69	72.69	400.0
2013-05-13 06:00:00	QQQ	ETF	72.71	72.74	72.71	72.74	900.0
2013-05-13 07:00:00	QQQ	ETF	72.74	72.84	72.74	72.84	31549.0
2013-05-13 08:00:00	QQQ	ETF	72.85	72.98	72.72	72.96	147078.0
2013-05-13 09:00:00	QQQ	ETF	72.96	73.08	72.88	72.93	3882818.0
2013-05-13 10:00:00	QQQ	ETF	72.93	73.18	72.86	73.04	5639651.0
2013-05-13 11:00:00	QQQ	ETF	73.05	73.22	72.9299	73.21	2902097.0
2013-05-13 12:00:00	QQQ	ETF	73.21	73.32	73.19	73.21	1855862.0
2013-05-13 13:00:00	QQQ	ETF	73.211	73.26	73.0	73.06	1760712.0
2013-05-13 14:00:00	QQQ	ETF	73.06	73.175	73.03	73.175	1159731.0
2013-05-13 15:00:00	QQQ	ETF	73.18	73.2	72.98	73.14	2977313.0
2013-05-13 16:00:00	QQQ	ETF	73.14	73.19	73.0579	73.1253	5332463.0
2013-05-13 17:00:00	QQQ	ETF	73.19	73.21	73.19	73.19	916.0
2013-05-13 18:00:00	QQQ	ETF	73.19	73.19	73.18	73.18	5134.0
2013-05-13 19:00:00	QQQ	ETF	73.2	73.28	73.2	73.28	15837.0
2013-05-13 04:00:00	IWM	ETF	96.5	96.58	96.5	96.58	2500.0
2013-05-13 06:00:00	IWM	ETF	96.5	96.5	96.5	96.5	3500.0
2013-05-13 07:00:00	IWM	ETF	96.53	96.67	96.53	96.67	24900.0
2013-05-13 08:00:00	IWM	ETF	96.72	96.86	96.53	96.8	165131.0
2013-05-13 09:00:00	IWM	ETF	96.81	96.86	96.43	96.47	3496744.0
2013-05-13 10:00:00	IWM	ETF	96.485	96.9	96.43	96.63	3921045.0
2013-05-13 11:00:00	IWM	ETF	96.64	96.95	96.51	96.9301	2209414.0
2013-05-13 12:00:00	IWM	ETF	96.94	97.12	96.84	96.8999	1957919.0
2013-05-13 13:00:00	IWM	ETF	96.89	97.0599	96.655	96.71	2830594.0
2013-05-13 14:00:00	IWM	ETF	96.701	96.79	96.6	96.76	1597631.0
2013-05-13 15:00:00	IWM	ETF	96.765	96.82	96.53	96.75	4036648.0
2013-05-13 16:00:00	IWM	ETF	96.74	96.86	96.74	96.82	902468.0
2013-05-13 17:00:00	IWM	ETF	96.83	96.89	96.83	96.86	12800.0
2013-05-13 19:00:00	IWM	ETF	96.82	96.9	96.82	96.9	5870.0
2013-05-13 07:00:00	DIA	ETF	150.63	150.69	150.63	150.68	6500.0
2013-05-13 08:00:00	DIA	ETF	150.67	150.85	150.64	150.84	3500.0
2013-05-13 09:00:00	DIA	ETF	150.85	150.88	150.484	150.6	455513.0
2013-05-13 10:00:00	DIA	ETF	150.58	150.92	150.51	150.798	576779.0

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

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