PREVIEW / etf_1hour / 2013-07-22

all etf 1-hour files

  file:    by_date/etf_1hour/2013/2013-07-22.parquet
  size:    203 KB
  rows:    6,414

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-07-22 04:00:00	SPY	ETF	169.35	169.7	169.35	169.67	8800.0
2013-07-22 05:00:00	SPY	ETF	169.64	169.65	169.58	169.59	5080.0
2013-07-22 06:00:00	SPY	ETF	169.63	169.63	169.42	169.48	96700.0
2013-07-22 07:00:00	SPY	ETF	169.48	169.65	169.44	169.49	204490.0
2013-07-22 08:00:00	SPY	ETF	169.52	169.62	169.33	169.4	471652.0
2013-07-22 09:00:00	SPY	ETF	169.4	169.48	169.06	169.09	11734186.0
2013-07-22 10:00:00	SPY	ETF	169.1	169.44	169.01	169.37	14339009.0
2013-07-22 11:00:00	SPY	ETF	169.37	169.74	169.36	169.48	11420827.0
2013-07-22 12:00:00	SPY	ETF	169.48	169.62	169.45	169.54	5563747.0
2013-07-22 13:00:00	SPY	ETF	169.5366	169.58	169.24	169.36	6193858.0
2013-07-22 14:00:00	SPY	ETF	169.355	169.59	169.31	169.58	6240355.0
2013-07-22 15:00:00	SPY	ETF	169.58	169.59	169.28	169.5	11643338.0
2013-07-22 16:00:00	SPY	ETF	169.5	169.55	169.03	169.5	5222394.0
2013-07-22 17:00:00	SPY	ETF	169.51	169.55	169.49	169.52	1327900.0
2013-07-22 18:00:00	SPY	ETF	169.5	169.66	169.49	169.64	111323.0
2013-07-22 19:00:00	SPY	ETF	169.61	169.63	169.58	169.6	10187.0
2013-07-22 04:00:00	QQQ	ETF	74.7	74.84	74.7	74.82	5500.0
2013-07-22 05:00:00	QQQ	ETF	74.8	74.8	74.8	74.8	850.0
2013-07-22 06:00:00	QQQ	ETF	74.78	74.78	74.7	74.7	4800.0
2013-07-22 07:00:00	QQQ	ETF	74.72	74.78	74.71	74.74	16895.0
2013-07-22 08:00:00	QQQ	ETF	74.75	74.75	74.64	74.7	44618.0
2013-07-22 09:00:00	QQQ	ETF	74.7	74.98	74.58	74.6	5807327.0
2013-07-22 10:00:00	QQQ	ETF	74.6	74.83	74.59	74.77	2946119.0
2013-07-22 11:00:00	QQQ	ETF	74.77	74.9	74.77	74.79	2086024.0
2013-07-22 12:00:00	QQQ	ETF	74.79	74.872	74.78	74.82	1491768.0
2013-07-22 13:00:00	QQQ	ETF	74.82	74.84	74.58	74.69	1448424.0
2013-07-22 14:00:00	QQQ	ETF	74.69	74.89	74.67	74.88	1751796.0
2013-07-22 15:00:00	QQQ	ETF	74.88	74.88	74.72	74.81	3264977.0
2013-07-22 16:00:00	QQQ	ETF	74.82	74.8445	74.5918	74.81	2139081.0
2013-07-22 17:00:00	QQQ	ETF	74.82	74.87	74.82	74.85	36135.0
2013-07-22 18:00:00	QQQ	ETF	74.85	74.93	74.85	74.92	32960.0
2013-07-22 19:00:00	QQQ	ETF	74.93	74.93	74.88	74.89	7395.0
2013-07-22 06:00:00	IWM	ETF	104.4	104.42	104.4	104.42	200.0
2013-07-22 07:00:00	IWM	ETF	104.45	104.45	104.45	104.45	624.0
2013-07-22 08:00:00	IWM	ETF	104.48	104.48	104.35	104.41	34260.0
2013-07-22 09:00:00	IWM	ETF	104.42	104.48	104.14	104.27	2897880.0
2013-07-22 10:00:00	IWM	ETF	104.25	104.55	104.13	104.47	4552838.0
2013-07-22 11:00:00	IWM	ETF	104.46	104.76	104.46	104.639	3195187.0
2013-07-22 12:00:00	IWM	ETF	104.63	104.67	104.54	104.62	1876383.0
2013-07-22 13:00:00	IWM	ETF	104.6251	104.67	104.37	104.5	1816487.0
2013-07-22 14:00:00	IWM	ETF	104.5	104.71	104.48	104.66	2064266.0
2013-07-22 15:00:00	IWM	ETF	104.6599	104.67	104.41	104.55	4673160.0
2013-07-22 16:00:00	IWM	ETF	104.55	104.69	104.2314	104.68	1865707.0
2013-07-22 17:00:00	IWM	ETF	104.69	104.72	104.69	104.72	4394.0
2013-07-22 18:00:00	IWM	ETF	104.71	104.72	104.71	104.72	1100.0
2013-07-22 19:00:00	IWM	ETF	104.78	104.78	104.71	104.71	1970.0
2013-07-22 07:00:00	DIA	ETF	155.36	155.36	155.36	155.36	600.0
2013-07-22 08:00:00	DIA	ETF	155.3	155.3	155.12	155.14	7745.0
2013-07-22 09:00:00	DIA	ETF	155.08	155.17	154.8256	154.95	619667.0
2013-07-22 10:00:00	DIA	ETF	154.93	155.18	154.81	155.12	578306.0

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

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