PREVIEW / etf_1hour / 2013-09-19

all etf 1-hour files

  file:    by_date/etf_1hour/2013/2013-09-19.parquet
  size:    215 KB
  rows:    6,739

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-09-19 04:00:00	SPY	ETF	173.46	173.54	173.45	173.51	62101.0
2013-09-19 05:00:00	SPY	ETF	173.57	173.86	173.56	173.78	30300.0
2013-09-19 06:00:00	SPY	ETF	173.76	173.85	173.7	173.7	64515.0
2013-09-19 07:00:00	SPY	ETF	173.72	173.79	173.4	173.51	283625.0
2013-09-19 08:00:00	SPY	ETF	173.5	173.75	173.34	173.39	1074248.0
2013-09-19 09:00:00	SPY	ETF	173.39	173.6	173.06	173.4	23021427.0
2013-09-19 10:00:00	SPY	ETF	173.39	173.49	173.01	173.19	25407624.0
2013-09-19 11:00:00	SPY	ETF	173.19	173.2	172.79	172.911	16608987.0
2013-09-19 12:00:00	SPY	ETF	172.92	173.11	172.84	172.849	13986774.0
2013-09-19 13:00:00	SPY	ETF	172.84	172.93	172.6	172.6199	11275882.0
2013-09-19 14:00:00	SPY	ETF	172.62	172.88	172.585	172.8	12866199.0
2013-09-19 15:00:00	SPY	ETF	172.8	172.99	172.71	172.81	21038026.0
2013-09-19 16:00:00	SPY	ETF	172.81	173.1098	172.75	172.9	18001344.0
2013-09-19 17:00:00	SPY	ETF	172.9	173.0915	172.82	172.92	991466.0
2013-09-19 18:00:00	SPY	ETF	172.94	172.94	172.83	172.89	134688.0
2013-09-19 19:00:00	SPY	ETF	172.9	172.9	172.82	172.82	40225.0
2013-09-19 04:00:00	QQQ	ETF	79.46	79.5	79.46	79.5	800.0
2013-09-19 05:00:00	QQQ	ETF	79.5	79.61	79.48	79.59	27400.0
2013-09-19 06:00:00	QQQ	ETF	79.59	79.61	79.57	79.57	9550.0
2013-09-19 07:00:00	QQQ	ETF	79.57	79.59	79.47	79.47	48480.0
2013-09-19 08:00:00	QQQ	ETF	79.48	79.57	79.44	79.48	307912.0
2013-09-19 09:00:00	QQQ	ETF	79.49	79.685	79.41	79.64	4095076.0
2013-09-19 10:00:00	QQQ	ETF	79.635	79.67	79.36	79.52	3718598.0
2013-09-19 11:00:00	QQQ	ETF	79.52	79.53	79.37	79.42	2533570.0
2013-09-19 12:00:00	QQQ	ETF	79.41	79.54	79.4	79.46	1662574.0
2013-09-19 13:00:00	QQQ	ETF	79.46	79.56	79.37	79.385	4837402.0
2013-09-19 14:00:00	QQQ	ETF	79.38	79.53	79.37	79.5255	1273310.0
2013-09-19 15:00:00	QQQ	ETF	79.5255	79.61	79.46	79.5	3701593.0
2013-09-19 16:00:00	QQQ	ETF	79.5	79.61	79.4497	79.53	846279.0
2013-09-19 17:00:00	QQQ	ETF	79.53	79.55	79.51	79.51	61200.0
2013-09-19 18:00:00	QQQ	ETF	79.55	79.55	79.47	79.5	148625.0
2013-09-19 19:00:00	QQQ	ETF	79.51	79.51	79.46	79.46	6075.0
2013-09-19 06:00:00	IWM	ETF	108.25	108.25	108.25	108.25	100.0
2013-09-19 07:00:00	IWM	ETF	107.62	107.64	107.36	107.38	35870.0
2013-09-19 08:00:00	IWM	ETF	107.41	107.41	107.27	107.27	116938.0
2013-09-19 09:00:00	IWM	ETF	107.29	107.43	106.9	107.18	3943451.0
2013-09-19 10:00:00	IWM	ETF	107.18	107.24	106.75	106.83	7082393.0
2013-09-19 11:00:00	IWM	ETF	106.84	107.0	106.62	106.719	5323530.0
2013-09-19 12:00:00	IWM	ETF	106.71	106.95	106.67	106.79	2501349.0
2013-09-19 13:00:00	IWM	ETF	106.77	106.84	106.675	106.701	1689346.0
2013-09-19 14:00:00	IWM	ETF	106.7	106.939	106.68	106.939	2533992.0
2013-09-19 15:00:00	IWM	ETF	106.935	107.0725	106.89	106.95	5144641.0
2013-09-19 16:00:00	IWM	ETF	106.95	107.23	106.94	107.11	1205551.0
2013-09-19 17:00:00	IWM	ETF	107.11	107.15	106.9604	107.14	620434.0
2013-09-19 18:00:00	IWM	ETF	107.11	107.11	107.11	107.11	500.0
2013-09-19 19:00:00	IWM	ETF	107.02	107.02	106.97	106.97	1614.0
2013-09-19 04:00:00	DIA	ETF	157.01	157.01	156.89	156.89	200.0
2013-09-19 05:00:00	DIA	ETF	156.92	157.0	156.92	156.99	9940.0
2013-09-19 07:00:00	DIA	ETF	156.99	156.99	156.87	156.87	200.0
2013-09-19 08:00:00	DIA	ETF	157.1	157.1	156.75	156.8	18700.0

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

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