PREVIEW / etf_1hour / 2013-03-19

all etf 1-hour files

  file:    by_date/etf_1hour/2013/2013-03-19.parquet
  size:    201 KB
  rows:    6,218

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-03-19 04:00:00	SPY	ETF	155.13	155.16	155.03	155.13	9750.0
2013-03-19 05:00:00	SPY	ETF	155.13	155.18	154.92	155.01	44751.0
2013-03-19 06:00:00	SPY	ETF	155.06	155.12	154.94	155.08	46800.0
2013-03-19 07:00:00	SPY	ETF	155.08	155.31	155.06	155.31	398666.0
2013-03-19 08:00:00	SPY	ETF	155.3	155.54	155.1	155.42	997357.0
2013-03-19 09:00:00	SPY	ETF	155.42	155.51	155.18	155.41	10409551.0
2013-03-19 10:00:00	SPY	ETF	155.41	155.5	154.76	155.0	19471429.0
2013-03-19 11:00:00	SPY	ETF	154.99	155.16	153.98	154.115	20984380.0
2013-03-19 12:00:00	SPY	ETF	154.11	154.42	153.86	154.12	23848727.0
2013-03-19 13:00:00	SPY	ETF	154.12	154.23	153.59	153.95	21594951.0
2013-03-19 14:00:00	SPY	ETF	153.95	154.49	153.835	154.19	21621734.0
2013-03-19 15:00:00	SPY	ETF	154.19	154.86	153.985	154.64	37212704.0
2013-03-19 16:00:00	SPY	ETF	154.63	154.72	154.24	154.42	8656830.0
2013-03-19 17:00:00	SPY	ETF	154.42	154.46	154.35	154.37	293664.0
2013-03-19 18:00:00	SPY	ETF	154.36	154.36	154.14	154.17	305009.0
2013-03-19 19:00:00	SPY	ETF	154.2	154.29	154.15	154.29	68826.0
2013-03-19 04:00:00	QQQ	ETF	68.33	68.41	68.33	68.41	8100.0
2013-03-19 07:00:00	QQQ	ETF	68.39	68.48	68.39	68.48	38000.0
2013-03-19 08:00:00	QQQ	ETF	68.52	68.64	68.52	68.6	331787.0
2013-03-19 09:00:00	QQQ	ETF	68.6	68.66	68.48	68.64	2417505.0
2013-03-19 10:00:00	QQQ	ETF	68.65	68.7	68.23	68.33	4304940.0
2013-03-19 11:00:00	QQQ	ETF	68.33	68.48	67.9	67.96	4067099.0
2013-03-19 12:00:00	QQQ	ETF	67.95	68.0699	67.83	67.94	2901342.0
2013-03-19 13:00:00	QQQ	ETF	67.93	67.9901	67.62	67.82	5512466.0
2013-03-19 14:00:00	QQQ	ETF	67.82	68.08	67.7841	67.9497	3499688.0
2013-03-19 15:00:00	QQQ	ETF	67.94	68.27	67.86	68.24	8709612.0
2013-03-19 16:00:00	QQQ	ETF	68.24	68.63	68.04	68.16	834295.0
2013-03-19 17:00:00	QQQ	ETF	68.14	68.16	68.14	68.15	46310.0
2013-03-19 18:00:00	QQQ	ETF	68.15	68.15	68.06	68.07	6720.0
2013-03-19 19:00:00	QQQ	ETF	68.08	68.1	68.07	68.1	5940.0
2013-03-19 07:00:00	IWM	ETF	94.29	94.39	94.28	94.39	38870.0
2013-03-19 08:00:00	IWM	ETF	94.41	94.52	94.4	94.44	151980.0
2013-03-19 09:00:00	IWM	ETF	94.45	94.6	94.34	94.55	3886745.0
2013-03-19 10:00:00	IWM	ETF	94.55	94.71	94.0632	94.13	5853596.0
2013-03-19 11:00:00	IWM	ETF	94.13	94.41	93.59	93.665	6083692.0
2013-03-19 12:00:00	IWM	ETF	93.67	93.91	93.451	93.55	6368129.0
2013-03-19 13:00:00	IWM	ETF	93.54	93.63	93.01	93.368	5960149.0
2013-03-19 14:00:00	IWM	ETF	93.37	93.76	93.33	93.6	4613552.0
2013-03-19 15:00:00	IWM	ETF	93.6	93.95	93.46	93.82	9989567.0
2013-03-19 16:00:00	IWM	ETF	93.82	93.94	93.67	93.67	985237.0
2013-03-19 17:00:00	IWM	ETF	93.67	93.71	93.57	93.64	85248.0
2013-03-19 18:00:00	IWM	ETF	93.63	93.63	93.6	93.61	28600.0
2013-03-19 19:00:00	IWM	ETF	93.6	93.6	93.6	93.6	4873.0
2013-03-19 04:00:00	DIA	ETF	144.32	144.35	144.32	144.35	400.0
2013-03-19 05:00:00	DIA	ETF	144.43	144.43	144.1	144.1	4700.0
2013-03-19 08:00:00	DIA	ETF	144.4	144.6	144.4	144.5	20901.0
2013-03-19 09:00:00	DIA	ETF	144.5	144.83	144.44	144.74	634226.0
2013-03-19 10:00:00	DIA	ETF	144.74	144.81	144.27	144.42	1068713.0
2013-03-19 11:00:00	DIA	ETF	144.42	144.64	143.72	143.83	1262892.0
2013-03-19 12:00:00	DIA	ETF	143.8	144.02	143.61	143.78	1084603.0

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

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