PREVIEW / etf_1hour / 2017-05-02

all etf 1-hour files

  file:    by_date/etf_1hour/2017/2017-05-02.parquet
  size:    276 KB
  rows:    8,977

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
2017-05-02 04:00:00	SPY	ETF	238.5	238.62	238.5	238.51	2005.0
2017-05-02 05:00:00	SPY	ETF	238.56	238.75	238.54	238.71	10625.0
2017-05-02 06:00:00	SPY	ETF	238.74	238.74	238.54	238.63	62500.0
2017-05-02 07:00:00	SPY	ETF	238.63	238.69	238.6	238.66	88155.0
2017-05-02 08:00:00	SPY	ETF	238.68	238.81	238.6	238.79	315954.0
2017-05-02 09:00:00	SPY	ETF	238.79	238.98	238.35	238.36	7234218.0
2017-05-02 10:00:00	SPY	ETF	238.36	238.62	238.3	238.465	7253086.0
2017-05-02 11:00:00	SPY	ETF	238.47	238.62	238.38	238.565	7062647.0
2017-05-02 12:00:00	SPY	ETF	238.57	238.9	238.56	238.8164	4873925.0
2017-05-02 13:00:00	SPY	ETF	238.82	238.8959	238.63	238.66	4616365.0
2017-05-02 14:00:00	SPY	ETF	238.66	238.78	238.39	238.455	7401728.0
2017-05-02 15:00:00	SPY	ETF	238.46	238.81	238.38	238.79	10593308.0
2017-05-02 16:00:00	SPY	ETF	238.78	238.8315	238.51	238.54	7004011.0
2017-05-02 17:00:00	SPY	ETF	238.55	238.56	238.41	238.46	167351.0
2017-05-02 18:00:00	SPY	ETF	238.47	238.83	238.37	238.57	166407.0
2017-05-02 19:00:00	SPY	ETF	238.56	238.6	238.53	238.57	49938.0
2017-05-02 04:00:00	QQQ	ETF	137.25	137.31	137.21	137.31	2099.0
2017-05-02 05:00:00	QQQ	ETF	137.32	137.34	137.3	137.34	16100.0
2017-05-02 06:00:00	QQQ	ETF	137.39	137.39	137.27	137.27	20300.0
2017-05-02 07:00:00	QQQ	ETF	137.28	137.33	137.26	137.32	59550.0
2017-05-02 08:00:00	QQQ	ETF	137.27	137.42	137.27	137.42	86247.0
2017-05-02 09:00:00	QQQ	ETF	137.41	137.42	137.06	137.1038	3310403.0
2017-05-02 10:00:00	QQQ	ETF	137.1	137.295	137.02	137.26	2530177.0
2017-05-02 11:00:00	QQQ	ETF	137.26	137.38	137.22	137.32	1685825.0
2017-05-02 12:00:00	QQQ	ETF	137.31	137.49	137.31	137.43	1862609.0
2017-05-02 13:00:00	QQQ	ETF	137.43	137.465	137.27	137.3	908880.0
2017-05-02 14:00:00	QQQ	ETF	137.3	137.4	137.2	137.22	1240270.0
2017-05-02 15:00:00	QQQ	ETF	137.22	137.44	137.21	137.44	2923086.0
2017-05-02 16:00:00	QQQ	ETF	137.43	137.46	137.0	137.03	677926.0
2017-05-02 17:00:00	QQQ	ETF	137.02	137.09	136.9	136.95	121896.0
2017-05-02 18:00:00	QQQ	ETF	136.95	137.05	136.87	137.02	36635.0
2017-05-02 19:00:00	QQQ	ETF	137.02	137.07	137.02	137.07	7695.0
2017-05-02 06:00:00	IWM	ETF	139.95	139.95	139.95	139.95	200.0
2017-05-02 07:00:00	IWM	ETF	139.85	139.89	139.83	139.89	10200.0
2017-05-02 08:00:00	IWM	ETF	139.92	140.08	139.82	139.91	25271.0
2017-05-02 09:00:00	IWM	ETF	139.89	140.34	139.25	139.28	2105914.0
2017-05-02 10:00:00	IWM	ETF	139.27	139.565	139.06	139.14	2871163.0
2017-05-02 11:00:00	IWM	ETF	139.14	139.375	139.08	139.16	1616551.0
2017-05-02 12:00:00	IWM	ETF	139.17	139.46	139.16	139.33	1389089.0
2017-05-02 13:00:00	IWM	ETF	139.32	139.32	139.0	139.0419	1273650.0
2017-05-02 14:00:00	IWM	ETF	139.04	139.21	138.6906	138.8	2374503.0
2017-05-02 15:00:00	IWM	ETF	138.8	139.18	138.69	139.14	3775501.0
2017-05-02 16:00:00	IWM	ETF	139.15	139.24	138.87	139.02	725407.0
2017-05-02 17:00:00	IWM	ETF	138.82	138.95	138.82	138.85	4795.0
2017-05-02 18:00:00	IWM	ETF	138.82	139.1	138.82	138.9	57870.0
2017-05-02 19:00:00	IWM	ETF	138.9	138.9	138.89	138.89	2100.0
2017-05-02 04:00:00	DIA	ETF	208.92	208.92	208.92	208.92	100.0
2017-05-02 06:00:00	DIA	ETF	208.95	208.95	208.95	208.95	200.0
2017-05-02 08:00:00	DIA	ETF	209.04	209.04	209.04	209.04	2044.0
2017-05-02 09:00:00	DIA	ETF	209.14	209.3	208.81	208.81	249235.0

> showing 50 of 8,977 rows — these rows as CSV

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