PREVIEW / etf_1hour / 2013-05-09

all etf 1-hour files

  file:    by_date/etf_1hour/2013/2013-05-09.parquet
  size:    202 KB
  rows:    6,287

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-09 04:00:00	SPY	ETF	163.25	163.3	163.15	163.25	3300.0
2013-05-09 05:00:00	SPY	ETF	163.17	163.29	163.17	163.29	4900.0
2013-05-09 06:00:00	SPY	ETF	163.27	163.32	163.24	163.32	23800.0
2013-05-09 07:00:00	SPY	ETF	163.34	163.34	163.13	163.16	207195.0
2013-05-09 08:00:00	SPY	ETF	163.26	163.26	162.91	163.16	1096870.0
2013-05-09 09:00:00	SPY	ETF	163.17	163.47	163.15	163.365	10401627.0
2013-05-09 10:00:00	SPY	ETF	163.37	163.38	162.85	162.975	16217835.0
2013-05-09 11:00:00	SPY	ETF	162.975	163.23	162.93	163.12	10217308.0
2013-05-09 12:00:00	SPY	ETF	163.121	163.34	162.96	163.33	6378389.0
2013-05-09 13:00:00	SPY	ETF	163.33	163.7	163.28	163.61	10737439.0
2013-05-09 14:00:00	SPY	ETF	163.61	163.64	162.71	162.72	13982216.0
2013-05-09 15:00:00	SPY	ETF	162.72	163.12	162.47	162.88	27548882.0
2013-05-09 16:00:00	SPY	ETF	162.89	163.4393	162.838	163.09	8714882.0
2013-05-09 17:00:00	SPY	ETF	163.09	163.12	163.05	163.06	182571.0
2013-05-09 18:00:00	SPY	ETF	163.08	163.16	163.07	163.1	114572.0
2013-05-09 19:00:00	SPY	ETF	163.1	163.18	163.07	163.16	57561.0
2013-05-09 04:00:00	QQQ	ETF	72.61	72.61	72.61	72.61	300.0
2013-05-09 06:00:00	QQQ	ETF	72.6	72.6	72.6	72.6	150.0
2013-05-09 07:00:00	QQQ	ETF	72.59	72.59	72.55	72.58	1405.0
2013-05-09 08:00:00	QQQ	ETF	72.59	72.59	72.41	72.52	256765.0
2013-05-09 09:00:00	QQQ	ETF	72.53	72.78	72.52	72.7	2863307.0
2013-05-09 10:00:00	QQQ	ETF	72.7	72.71	72.51	72.59	3760821.0
2013-05-09 11:00:00	QQQ	ETF	72.58	72.77	72.58	72.7401	2423833.0
2013-05-09 12:00:00	QQQ	ETF	72.75	72.83	72.65	72.82	1631130.0
2013-05-09 13:00:00	QQQ	ETF	72.815	73.099	72.79	73.05	2550835.0
2013-05-09 14:00:00	QQQ	ETF	73.05	73.06	72.62	72.62	3305119.0
2013-05-09 15:00:00	QQQ	ETF	72.611	72.769	72.47	72.62	5956468.0
2013-05-09 16:00:00	QQQ	ETF	72.63	72.75	72.6	72.74	1298804.0
2013-05-09 17:00:00	QQQ	ETF	72.72	72.72	72.67	72.69	11200.0
2013-05-09 18:00:00	QQQ	ETF	72.68	72.73	72.68	72.68	10972.0
2013-05-09 19:00:00	QQQ	ETF	72.74	72.75	72.72	72.73	6500.0
2013-05-09 06:00:00	IWM	ETF	96.35	96.35	96.33	96.33	4278.0
2013-05-09 07:00:00	IWM	ETF	96.36	96.36	96.24	96.25	18800.0
2013-05-09 08:00:00	IWM	ETF	96.26	96.36	96.11	96.26	87390.0
2013-05-09 09:00:00	IWM	ETF	96.28	96.45	96.19	96.33	3045580.0
2013-05-09 10:00:00	IWM	ETF	96.33	96.35	95.75	96.085	6234712.0
2013-05-09 11:00:00	IWM	ETF	96.085	96.45	96.03	96.27	3475488.0
2013-05-09 12:00:00	IWM	ETF	96.27	96.34	96.1	96.33	1044484.0
2013-05-09 13:00:00	IWM	ETF	96.32	96.51	96.24	96.4	2672227.0
2013-05-09 14:00:00	IWM	ETF	96.4	96.46	96.04	96.05	3859008.0
2013-05-09 15:00:00	IWM	ETF	96.049	96.33	95.91	96.06	6159781.0
2013-05-09 16:00:00	IWM	ETF	96.06	96.29	96.05	96.0908	1317451.0
2013-05-09 17:00:00	IWM	ETF	96.25	96.27	96.23	96.23	3105.0
2013-05-09 18:00:00	IWM	ETF	96.24	96.24	96.2	96.2	5472.0
2013-05-09 19:00:00	IWM	ETF	96.2	96.23	96.2	96.23	2428.0
2013-05-09 05:00:00	DIA	ETF	150.92	150.92	150.92	150.92	500.0
2013-05-09 07:00:00	DIA	ETF	150.92	150.92	150.92	150.92	2500.0
2013-05-09 08:00:00	DIA	ETF	150.8	150.83	150.67	150.83	7500.0
2013-05-09 09:00:00	DIA	ETF	150.9	151.18	150.82	151.065	334649.0
2013-05-09 10:00:00	DIA	ETF	151.06	151.09	150.67	150.74	517707.0

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

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