PREVIEW / etf_1hour / 2013-05-10

all etf 1-hour files

  file:    by_date/etf_1hour/2013/2013-05-10.parquet
  size:    204 KB
  rows:    6,318

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-10 04:00:00	SPY	ETF	163.3	163.52	163.05	163.13	60783.0
2013-05-10 05:00:00	SPY	ETF	163.13	163.19	162.99	163.19	18200.0
2013-05-10 06:00:00	SPY	ETF	163.21	163.35	163.18	163.32	56099.0
2013-05-10 07:00:00	SPY	ETF	163.32	163.32	162.97	163.11	358960.0
2013-05-10 08:00:00	SPY	ETF	163.21	163.42	162.94	163.06	762045.0
2013-05-10 09:00:00	SPY	ETF	163.04	163.3	162.79	163.25	11884325.0
2013-05-10 10:00:00	SPY	ETF	163.241	163.4	162.61	162.91	18465155.0
2013-05-10 11:00:00	SPY	ETF	162.92	163.22	162.64	162.65	13381694.0
2013-05-10 12:00:00	SPY	ETF	162.65	162.96	162.51	162.83	9752390.0
2013-05-10 13:00:00	SPY	ETF	162.825	163.11	162.82	162.93	11412760.0
2013-05-10 14:00:00	SPY	ETF	162.935	163.17	162.93	163.05	6096138.0
2013-05-10 15:00:00	SPY	ETF	163.051	163.49	163.05	163.45	20836620.0
2013-05-10 16:00:00	SPY	ETF	163.45	163.5515	162.79	163.41	5274895.0
2013-05-10 17:00:00	SPY	ETF	163.43	163.49	163.36	163.36	95914.0
2013-05-10 18:00:00	SPY	ETF	163.4	163.47	163.4	163.45	13054.0
2013-05-10 19:00:00	SPY	ETF	163.47	163.47	163.21	163.25	114024.0
2013-05-10 04:00:00	QQQ	ETF	72.9	72.9	72.9	72.9	100.0
2013-05-10 05:00:00	QQQ	ETF	72.68	72.68	72.68	72.68	400.0
2013-05-10 06:00:00	QQQ	ETF	72.72	72.79	72.72	72.78	2700.0
2013-05-10 07:00:00	QQQ	ETF	72.75	72.75	72.68	72.71	46000.0
2013-05-10 08:00:00	QQQ	ETF	72.71	72.75	72.68	72.71	35290.0
2013-05-10 09:00:00	QQQ	ETF	72.68	72.99	72.63	72.96	3288871.0
2013-05-10 10:00:00	QQQ	ETF	72.97	73.059	72.64	72.7991	4026372.0
2013-05-10 11:00:00	QQQ	ETF	72.8	72.9399	72.69	72.691	3185126.0
2013-05-10 12:00:00	QQQ	ETF	72.69	72.81	72.64	72.77	1638642.0
2013-05-10 13:00:00	QQQ	ETF	72.77	72.92	72.77	72.85	1675207.0
2013-05-10 14:00:00	QQQ	ETF	72.85	72.97	72.85	72.92	1160427.0
2013-05-10 15:00:00	QQQ	ETF	72.92	73.08	72.89	73.06	3215906.0
2013-05-10 16:00:00	QQQ	ETF	73.06	73.0962	72.9199	73.06	858524.0
2013-05-10 17:00:00	QQQ	ETF	73.06	73.1	73.06	73.1	28400.0
2013-05-10 18:00:00	QQQ	ETF	73.1	73.16	73.05	73.05	9690.0
2013-05-10 19:00:00	QQQ	ETF	73.05	73.05	72.93	72.95	20861.0
2013-05-10 04:00:00	IWM	ETF	96.32	96.32	96.32	96.32	100.0
2013-05-10 05:00:00	IWM	ETF	96.35	96.35	96.35	96.35	500.0
2013-05-10 06:00:00	IWM	ETF	96.37	96.45	96.37	96.45	3000.0
2013-05-10 07:00:00	IWM	ETF	96.41	96.45	96.27	96.33	105900.0
2013-05-10 08:00:00	IWM	ETF	96.45	96.45	96.18	96.27	121236.0
2013-05-10 09:00:00	IWM	ETF	96.2	96.5	96.07	96.4701	3953980.0
2013-05-10 10:00:00	IWM	ETF	96.475	96.64	96.16	96.42	6283222.0
2013-05-10 11:00:00	IWM	ETF	96.43	96.62	96.31	96.43	5067196.0
2013-05-10 12:00:00	IWM	ETF	96.42	96.55	96.28	96.53	4972207.0
2013-05-10 13:00:00	IWM	ETF	96.53	96.85	96.52	96.73	3738969.0
2013-05-10 14:00:00	IWM	ETF	96.74	96.89	96.7306	96.745	2186185.0
2013-05-10 15:00:00	IWM	ETF	96.75	96.935	96.73	96.86	5294664.0
2013-05-10 16:00:00	IWM	ETF	96.86	96.92	96.5214	96.9	1652632.0
2013-05-10 17:00:00	IWM	ETF	96.92	96.92	96.92	96.92	2300.0
2013-05-10 19:00:00	IWM	ETF	96.89	96.89	96.56	96.8	12821.0
2013-05-10 07:00:00	DIA	ETF	151.07	151.07	150.95	150.95	1880.0
2013-05-10 08:00:00	DIA	ETF	151.02	151.04	150.92	150.94	13195.0
2013-05-10 09:00:00	DIA	ETF	150.93	151.0437	150.56	150.94	559319.0

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

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