PREVIEW / etf_1hour / 2013-11-20

all etf 1-hour files

  file:    by_date/etf_1hour/2013/2013-11-20.parquet
  size:    210 KB
  rows:    6,620

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-11-20 04:00:00	SPY	ETF	179.1	179.13	179.0	179.05	27247.0
2013-11-20 05:00:00	SPY	ETF	179.04	179.05	178.75	178.78	47084.0
2013-11-20 06:00:00	SPY	ETF	178.76	178.94	178.71	178.94	78069.0
2013-11-20 07:00:00	SPY	ETF	178.92	179.04	178.91	178.91	125685.0
2013-11-20 08:00:00	SPY	ETF	178.91	179.42	178.88	179.42	964795.0
2013-11-20 09:00:00	SPY	ETF	179.42	179.54	179.09	179.342	10534691.0
2013-11-20 10:00:00	SPY	ETF	179.35	179.93	179.1	179.525	19681871.0
2013-11-20 11:00:00	SPY	ETF	179.53	179.6	179.31	179.45	6956893.0
2013-11-20 12:00:00	SPY	ETF	179.45	179.6	179.32	179.32	6607172.0
2013-11-20 13:00:00	SPY	ETF	179.31	179.479	179.24	179.37	4834458.0
2013-11-20 14:00:00	SPY	ETF	179.38	179.4	178.38	178.5703	33832579.0
2013-11-20 15:00:00	SPY	ETF	178.58	178.58	177.98	178.44	29082840.0
2013-11-20 16:00:00	SPY	ETF	178.45	179.51	178.1	178.53	6245416.0
2013-11-20 17:00:00	SPY	ETF	178.53	178.57	178.46	178.48	3030733.0
2013-11-20 18:00:00	SPY	ETF	178.49	178.55	178.4	178.48	85325.0
2013-11-20 19:00:00	SPY	ETF	178.49	178.54	178.38	178.51	90660.0
2013-11-20 04:00:00	QQQ	ETF	82.94	82.94	82.94	82.94	2600.0
2013-11-20 05:00:00	QQQ	ETF	82.82	82.82	82.77	82.78	9300.0
2013-11-20 06:00:00	QQQ	ETF	82.78	82.87	82.78	82.87	14100.0
2013-11-20 07:00:00	QQQ	ETF	82.92	82.97	82.92	82.92	20248.0
2013-11-20 08:00:00	QQQ	ETF	82.95	83.17	82.9	83.16	234977.0
2013-11-20 09:00:00	QQQ	ETF	83.17	83.34	82.97	83.11	3774261.0
2013-11-20 10:00:00	QQQ	ETF	83.11	83.4301	82.97	83.27	5050814.0
2013-11-20 11:00:00	QQQ	ETF	83.27	83.3474	83.14	83.23	1904813.0
2013-11-20 12:00:00	QQQ	ETF	83.23	83.3399	83.14	83.15	1485475.0
2013-11-20 13:00:00	QQQ	ETF	83.14	83.23	83.07	83.17	1312771.0
2013-11-20 14:00:00	QQQ	ETF	83.17	83.2	82.66	82.76	8031645.0
2013-11-20 15:00:00	QQQ	ETF	82.765	82.77	82.455	82.67	6787658.0
2013-11-20 16:00:00	QQQ	ETF	82.67	83.326	82.64	82.68	1340864.0
2013-11-20 17:00:00	QQQ	ETF	82.68	82.72	82.68	82.72	4900.0
2013-11-20 18:00:00	QQQ	ETF	82.68	82.71	82.65	82.68	34235.0
2013-11-20 19:00:00	QQQ	ETF	82.67	82.7	82.66	82.7	720.0
2013-11-20 05:00:00	IWM	ETF	109.31	109.31	109.31	109.31	100.0
2013-11-20 06:00:00	IWM	ETF	109.41	109.41	109.36	109.41	1200.0
2013-11-20 07:00:00	IWM	ETF	109.41	109.49	109.36	109.36	13195.0
2013-11-20 08:00:00	IWM	ETF	109.36	109.97	109.36	109.97	254987.0
2013-11-20 09:00:00	IWM	ETF	109.99	110.01	109.31	109.6	3589866.0
2013-11-20 10:00:00	IWM	ETF	109.58	110.2	109.37	109.93	6063852.0
2013-11-20 11:00:00	IWM	ETF	109.93	110.08	109.76	109.96	2471324.0
2013-11-20 12:00:00	IWM	ETF	109.955	110.15	109.94	109.98	1717929.0
2013-11-20 13:00:00	IWM	ETF	109.975	110.07	109.84	110.06	1858138.0
2013-11-20 14:00:00	IWM	ETF	110.06	110.07	109.32	109.4	8871425.0
2013-11-20 15:00:00	IWM	ETF	109.4	109.43	108.85	109.33	10691269.0
2013-11-20 16:00:00	IWM	ETF	109.34	109.9908	109.1236	109.33	5796025.0
2013-11-20 17:00:00	IWM	ETF	109.33	109.38	109.33	109.35	4605.0
2013-11-20 18:00:00	IWM	ETF	109.35	109.35	109.3	109.3	200.0
2013-11-20 06:00:00	DIA	ETF	159.17	159.17	159.17	159.17	100.0
2013-11-20 07:00:00	DIA	ETF	159.23	159.28	159.23	159.28	200.0
2013-11-20 08:00:00	DIA	ETF	159.22	159.58	159.22	159.57	6060.0
2013-11-20 09:00:00	DIA	ETF	159.62	159.64	159.21	159.4877	766686.0

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

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