PREVIEW / etf_1hour / 2017-05-25

all etf 1-hour files

  file:    by_date/etf_1hour/2017/2017-05-25.parquet
  size:    279 KB
  rows:    9,089

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-25 04:00:00	SPY	ETF	241.01	241.13	240.97	241.12	35362.0
2017-05-25 05:00:00	SPY	ETF	241.12	241.34	241.12	241.27	23220.0
2017-05-25 06:00:00	SPY	ETF	241.3	241.3	241.16	241.19	208295.0
2017-05-25 07:00:00	SPY	ETF	241.18	241.27	241.01	241.09	285545.0
2017-05-25 08:00:00	SPY	ETF	241.09	241.24	240.98	241.19	427884.0
2017-05-25 09:00:00	SPY	ETF	241.21	241.52	240.96	241.41	6122433.0
2017-05-25 10:00:00	SPY	ETF	241.415	241.79	241.35	241.665	8964968.0
2017-05-25 11:00:00	SPY	ETF	241.659	241.96	241.42	241.4592	11911502.0
2017-05-25 12:00:00	SPY	ETF	241.46	241.88	241.36	241.86	5506974.0
2017-05-25 13:00:00	SPY	ETF	241.87	241.88	241.57	241.81	4670378.0
2017-05-25 14:00:00	SPY	ETF	241.81	241.98	241.7	241.87	4434425.0
2017-05-25 15:00:00	SPY	ETF	241.87	242.08	241.62	241.71	14216908.0
2017-05-25 16:00:00	SPY	ETF	241.7	241.82	239.8739	241.67	5616091.0
2017-05-25 17:00:00	SPY	ETF	241.66	241.76	241.6	241.65	84143.0
2017-05-25 18:00:00	SPY	ETF	241.66	241.7	241.5	241.57	79196.0
2017-05-25 19:00:00	SPY	ETF	241.56	241.64	241.55	241.62	20785.0
2017-05-25 04:00:00	QQQ	ETF	140.1	140.19	140.06	140.06	48720.0
2017-05-25 05:00:00	QQQ	ETF	140.21	140.26	140.21	140.25	3225.0
2017-05-25 06:00:00	QQQ	ETF	140.29	140.31	140.2	140.2	22200.0
2017-05-25 07:00:00	QQQ	ETF	140.25	140.29	140.19	140.22	188429.0
2017-05-25 08:00:00	QQQ	ETF	140.22	140.38	140.19	140.35	169229.0
2017-05-25 09:00:00	QQQ	ETF	140.35	140.36	140.01	140.29	2974370.0
2017-05-25 10:00:00	QQQ	ETF	140.29	140.715	140.23	140.67	3030231.0
2017-05-25 11:00:00	QQQ	ETF	140.67	140.935	140.645	140.78	1816712.0
2017-05-25 12:00:00	QQQ	ETF	140.7801	141.16	140.74	141.15	2189179.0
2017-05-25 13:00:00	QQQ	ETF	141.15	141.155	141.0	141.14	1187295.0
2017-05-25 14:00:00	QQQ	ETF	141.14	141.33	141.13	141.26	2183167.0
2017-05-25 15:00:00	QQQ	ETF	141.2569	141.26	140.9	140.97	5389438.0
2017-05-25 16:00:00	QQQ	ETF	140.97	141.05	140.94	141.02	1144618.0
2017-05-25 17:00:00	QQQ	ETF	140.98	141.0	140.98	141.0	2794.0
2017-05-25 18:00:00	QQQ	ETF	140.99	141.05	140.95	140.97	18546.0
2017-05-25 19:00:00	QQQ	ETF	140.98	141.04	140.98	141.03	5124.0
2017-05-25 04:00:00	IWM	ETF	138.0	138.05	137.95	137.95	1512.0
2017-05-25 05:00:00	IWM	ETF	138.1	138.11	138.1	138.11	400.0
2017-05-25 06:00:00	IWM	ETF	138.14	138.16	138.14	138.16	4300.0
2017-05-25 07:00:00	IWM	ETF	138.03	138.13	137.93	137.98	84049.0
2017-05-25 08:00:00	IWM	ETF	137.95	138.03	137.83	137.99	46743.0
2017-05-25 09:00:00	IWM	ETF	138.0	138.46	137.84	138.31	2944995.0
2017-05-25 10:00:00	IWM	ETF	138.31	138.61	138.12	138.12	2788716.0
2017-05-25 11:00:00	IWM	ETF	138.11	138.4	137.53	137.54	2710737.0
2017-05-25 12:00:00	IWM	ETF	137.545	137.81	137.36	137.68	2067020.0
2017-05-25 13:00:00	IWM	ETF	137.68	137.68	137.2	137.55	1907713.0
2017-05-25 14:00:00	IWM	ETF	137.54	137.76	137.36	137.695	1518715.0
2017-05-25 15:00:00	IWM	ETF	137.69	137.95	137.54	137.6	3632071.0
2017-05-25 16:00:00	IWM	ETF	137.6	137.6	137.4	137.47	2412303.0
2017-05-25 17:00:00	IWM	ETF	137.49	137.5	137.47	137.5	16500.0
2017-05-25 18:00:00	IWM	ETF	137.5	137.5	137.46	137.46	2194.0
2017-05-25 19:00:00	IWM	ETF	137.47	137.5	137.43	137.5	2240.0
2017-05-25 04:00:00	DIA	ETF	210.59	210.59	210.47	210.47	1011.0
2017-05-25 05:00:00	DIA	ETF	210.57	210.57	210.54	210.54	528.0

> showing 50 of 9,089 rows — these rows as CSV

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