PREVIEW / etf_1hour / 2015-02-13

all etf 1-hour files

  file:    by_date/etf_1hour/2015/2015-02-13.parquet
  size:    237 KB
  rows:    7,599

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
2015-02-13 04:00:00	SPY	ETF	209.1	209.44	208.92	209.34	14537.0
2015-02-13 05:00:00	SPY	ETF	209.28	209.34	209.23	209.34	8300.0
2015-02-13 06:00:00	SPY	ETF	209.28	209.28	209.12	209.22	8200.0
2015-02-13 07:00:00	SPY	ETF	209.17	209.29	209.1	209.2	135386.0
2015-02-13 08:00:00	SPY	ETF	209.17	209.36	209.14	209.3	470020.0
2015-02-13 09:00:00	SPY	ETF	209.32	209.48	208.92	209.437	11995754.0
2015-02-13 10:00:00	SPY	ETF	209.42	209.55	209.07	209.385	13285830.0
2015-02-13 11:00:00	SPY	ETF	209.39	209.6648	209.33	209.55	8381173.0
2015-02-13 12:00:00	SPY	ETF	209.5457	209.59	209.215	209.25	4819938.0
2015-02-13 13:00:00	SPY	ETF	209.25	209.4	208.76	209.015	11324942.0
2015-02-13 14:00:00	SPY	ETF	209.02	209.38	208.96	209.345	8890611.0
2015-02-13 15:00:00	SPY	ETF	209.345	209.84	209.265	209.8	19512847.0
2015-02-13 16:00:00	SPY	ETF	209.81	209.91	209.1373	209.86	13639064.0
2015-02-13 17:00:00	SPY	ETF	209.9	209.97	209.88	209.95	344933.0
2015-02-13 18:00:00	SPY	ETF	209.96	209.96	209.92	209.93	30463.0
2015-02-13 19:00:00	SPY	ETF	209.92	209.97	209.9	209.97	35566.0
2015-02-13 04:00:00	QQQ	ETF	106.2	106.36	106.2	106.36	13000.0
2015-02-13 05:00:00	QQQ	ETF	106.34	106.42	106.34	106.42	5422.0
2015-02-13 06:00:00	QQQ	ETF	106.27	106.3	106.21	106.21	1100.0
2015-02-13 07:00:00	QQQ	ETF	106.29	106.33	106.24	106.29	8600.0
2015-02-13 08:00:00	QQQ	ETF	106.24	106.36	106.23	106.35	41335.0
2015-02-13 09:00:00	QQQ	ETF	106.34	106.5	106.2	106.38	5065909.0
2015-02-13 10:00:00	QQQ	ETF	106.36	106.43	106.101	106.29	4152901.0
2015-02-13 11:00:00	QQQ	ETF	106.2991	106.59	106.29	106.55	1848831.0
2015-02-13 12:00:00	QQQ	ETF	106.56	106.58	106.44	106.491	1438261.0
2015-02-13 13:00:00	QQQ	ETF	106.48	106.601	106.22	106.39	1912140.0
2015-02-13 14:00:00	QQQ	ETF	106.38	106.53	106.31	106.52	1431310.0
2015-02-13 15:00:00	QQQ	ETF	106.52	106.93	106.49	106.9	5828953.0
2015-02-13 16:00:00	QQQ	ETF	106.91	106.91	106.0429	106.88	2015327.0
2015-02-13 17:00:00	QQQ	ETF	106.87	106.91	106.81	106.85	13225.0
2015-02-13 18:00:00	QQQ	ETF	106.87	106.89	106.87	106.89	2540.0
2015-02-13 19:00:00	QQQ	ETF	106.85	106.98	106.85	106.95	3010.0
2015-02-13 04:00:00	IWM	ETF	121.02	121.02	121.02	121.02	100.0
2015-02-13 07:00:00	IWM	ETF	121.09	121.13	120.95	121.08	1800.0
2015-02-13 08:00:00	IWM	ETF	121.1	121.19	121.08	121.13	47253.0
2015-02-13 09:00:00	IWM	ETF	121.11	121.49	120.85	121.24	2459916.0
2015-02-13 10:00:00	IWM	ETF	121.22	121.29	120.65	121.11	3512780.0
2015-02-13 11:00:00	IWM	ETF	121.11	121.46	121.09	121.39	3212278.0
2015-02-13 12:00:00	IWM	ETF	121.38	121.4401	121.05	121.15	1578049.0
2015-02-13 13:00:00	IWM	ETF	121.14	121.25	120.75	121.08	1574954.0
2015-02-13 14:00:00	IWM	ETF	121.07	121.46	121.05	121.42	1347821.0
2015-02-13 15:00:00	IWM	ETF	121.42	121.69	121.35	121.54	4039723.0
2015-02-13 16:00:00	IWM	ETF	121.53	121.6109	121.45	121.55	1187848.0
2015-02-13 17:00:00	IWM	ETF	121.55	121.6	121.54	121.55	5386.0
2015-02-13 18:00:00	IWM	ETF	121.57	121.57	121.57	121.57	200.0
2015-02-13 19:00:00	IWM	ETF	121.53	121.55	121.53	121.55	968.0
2015-02-13 07:00:00	DIA	ETF	180.15	180.19	180.11	180.11	600.0
2015-02-13 08:00:00	DIA	ETF	180.1	180.26	180.0	180.24	14475.0
2015-02-13 09:00:00	DIA	ETF	180.22	180.34	179.86	180.28	508478.0
2015-02-13 10:00:00	DIA	ETF	180.28	180.54	179.98	180.34	799171.0

> showing 50 of 7,599 rows — these rows as CSV

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