PREVIEW / etf_1hour / 2013-06-21

all etf 1-hour files

  file:    by_date/etf_1hour/2013/2013-06-21.parquet
  size:    218 KB
  rows:    6,766

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-06-21 04:00:00	SPY	ETF	159.97	159.97	159.55	159.65	16814.0
2013-06-21 05:00:00	SPY	ETF	159.7	160.12	159.7	160.05	86295.0
2013-06-21 06:00:00	SPY	ETF	160.05	160.11	160.0	160.04	143109.0
2013-06-21 07:00:00	SPY	ETF	160.02	160.03	159.65	159.76	866496.0
2013-06-21 08:00:00	SPY	ETF	159.76	160.88	159.06	159.25	2861013.0
2013-06-21 09:00:00	SPY	ETF	159.24	159.83	159.07	159.082	32151618.0
2013-06-21 10:00:00	SPY	ETF	159.09	159.7423	158.25	158.779	41605498.0
2013-06-21 11:00:00	SPY	ETF	158.775	158.9	157.47	157.72	42213139.0
2013-06-21 12:00:00	SPY	ETF	157.72	158.9101	157.585	158.9	33450745.0
2013-06-21 13:00:00	SPY	ETF	158.8965	159.27	158.32	158.45	22938117.0
2013-06-21 14:00:00	SPY	ETF	158.45	159.1	158.25	159.099	23910193.0
2013-06-21 15:00:00	SPY	ETF	159.09	159.59	158.83	158.985	39164510.0
2013-06-21 16:00:00	SPY	ETF	159.07	159.5	158.3829	158.72	18555487.0
2013-06-21 17:00:00	SPY	ETF	158.73	158.9851	158.73	158.89	5673766.0
2013-06-21 18:00:00	SPY	ETF	158.9	158.98	158.85	158.85	503038.0
2013-06-21 19:00:00	SPY	ETF	158.85	158.87	158.82	158.84	28908.0
2013-06-21 04:00:00	QQQ	ETF	70.95	70.96	70.85	70.93	5205.0
2013-06-21 05:00:00	QQQ	ETF	70.94	71.12	70.94	71.12	7892.0
2013-06-21 06:00:00	QQQ	ETF	71.09	71.09	71.06	71.06	800.0
2013-06-21 07:00:00	QQQ	ETF	71.05	71.12	71.0	71.08	68696.0
2013-06-21 08:00:00	QQQ	ETF	71.1	71.1	70.77	70.77	175241.0
2013-06-21 09:00:00	QQQ	ETF	70.77	70.97	70.54	70.55	8271103.0
2013-06-21 10:00:00	QQQ	ETF	70.55	70.71	70.22	70.42	8133912.0
2013-06-21 11:00:00	QQQ	ETF	70.42	70.44	69.84	69.961	7404750.0
2013-06-21 12:00:00	QQQ	ETF	69.965	70.45	69.94	70.45	5861071.0
2013-06-21 13:00:00	QQQ	ETF	70.455	70.59	70.12	70.1699	4895209.0
2013-06-21 14:00:00	QQQ	ETF	70.16	70.38	70.07	70.38	4952863.0
2013-06-21 15:00:00	QQQ	ETF	70.374	70.61	70.34	70.47	8697461.0
2013-06-21 16:00:00	QQQ	ETF	70.465	70.5774	70.0198	70.27	2298345.0
2013-06-21 17:00:00	QQQ	ETF	70.3	70.34	70.26	70.33	34617.0
2013-06-21 18:00:00	QQQ	ETF	70.33	70.34	70.3	70.3	5907.0
2013-06-21 19:00:00	QQQ	ETF	70.29	70.34	70.29	70.34	3200.0
2013-06-21 05:00:00	IWM	ETF	96.49	96.49	95.5	95.5	1500.0
2013-06-21 06:00:00	IWM	ETF	95.9	95.96	95.9	95.96	3100.0
2013-06-21 07:00:00	IWM	ETF	95.99	96.02	95.78	95.83	366549.0
2013-06-21 08:00:00	IWM	ETF	95.86	95.86	95.46	95.59	1273014.0
2013-06-21 09:00:00	IWM	ETF	95.57	96.03	95.51	95.69	7673622.0
2013-06-21 10:00:00	IWM	ETF	95.69	95.94	95.08	95.4477	10710524.0
2013-06-21 11:00:00	IWM	ETF	95.4399	95.5	94.63	94.87	8033062.0
2013-06-21 12:00:00	IWM	ETF	94.87	95.75	94.87	95.715	7072710.0
2013-06-21 13:00:00	IWM	ETF	95.72	96.06	95.38	95.48	6665041.0
2013-06-21 14:00:00	IWM	ETF	95.47	95.815	95.28	95.78	4341616.0
2013-06-21 15:00:00	IWM	ETF	95.77	96.18	95.69	95.97	11330548.0
2013-06-21 16:00:00	IWM	ETF	95.96	96.02	95.63	95.73	2232847.0
2013-06-21 17:00:00	IWM	ETF	95.74	95.82	95.71	95.75	43866.0
2013-06-21 18:00:00	IWM	ETF	95.81	95.81	95.81	95.81	500.0
2013-06-21 19:00:00	IWM	ETF	95.81	95.81	95.81	95.81	590.0
2013-06-21 04:00:00	DIA	ETF	148.05	148.05	148.05	148.05	177.0
2013-06-21 05:00:00	DIA	ETF	148.13	148.31	148.13	148.31	18861.0
2013-06-21 06:00:00	DIA	ETF	148.2	148.2	148.19	148.19	300.0

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

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