PREVIEW / etf_1hour / 2017-12-11

all etf 1-hour files

  file:    by_date/etf_1hour/2017/2017-12-11.parquet
  size:    287 KB
  rows:    9,511

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-12-11 04:00:00	SPY	ETF	265.72	265.75	265.55	265.55	5135.0
2017-12-11 05:00:00	SPY	ETF	265.71	265.78	265.67	265.67	5384.0
2017-12-11 06:00:00	SPY	ETF	265.68	265.75	265.6	265.6	6925.0
2017-12-11 07:00:00	SPY	ETF	265.6	265.74	265.42	265.43	479187.0
2017-12-11 08:00:00	SPY	ETF	265.43	265.66	265.25	265.62	826156.0
2017-12-11 09:00:00	SPY	ETF	265.56	265.97	265.49	265.965	4610752.0
2017-12-11 10:00:00	SPY	ETF	265.97	266.09	265.67	265.71	13364712.0
2017-12-11 11:00:00	SPY	ETF	265.71	265.99	265.6	265.87	4808731.0
2017-12-11 12:00:00	SPY	ETF	265.87	266.18	265.86	266.16	7520899.0
2017-12-11 13:00:00	SPY	ETF	266.16	266.29	266.02	266.155	4765969.0
2017-12-11 14:00:00	SPY	ETF	266.155	266.2	266.04	266.125	6532049.0
2017-12-11 15:00:00	SPY	ETF	266.125	266.38	265.9	266.34	17565980.0
2017-12-11 16:00:00	SPY	ETF	266.33	266.77	266.1055	266.63	19028399.0
2017-12-11 17:00:00	SPY	ETF	266.6	266.67	265.9805	266.64	1683824.0
2017-12-11 18:00:00	SPY	ETF	266.63	266.63	266.4	266.53	175017.0
2017-12-11 19:00:00	SPY	ETF	266.55	266.7	266.5	266.53	44996.0
2017-12-11 04:00:00	QQQ	ETF	154.6	154.85	154.6	154.71	9300.0
2017-12-11 05:00:00	QQQ	ETF	154.81	154.85	154.81	154.85	2379.0
2017-12-11 06:00:00	QQQ	ETF	154.78	155.0	154.73	154.73	36980.0
2017-12-11 07:00:00	QQQ	ETF	154.72	155.01	154.71	154.84	81287.0
2017-12-11 08:00:00	QQQ	ETF	154.75	154.95	154.57	154.77	257223.0
2017-12-11 09:00:00	QQQ	ETF	154.75	155.28	154.75	155.15	2332137.0
2017-12-11 10:00:00	QQQ	ETF	155.15	155.32	155.02	155.16	2917178.0
2017-12-11 11:00:00	QQQ	ETF	155.17	155.51	155.02	155.449	1581138.0
2017-12-11 12:00:00	QQQ	ETF	155.45	155.92	155.44	155.8953	2303063.0
2017-12-11 13:00:00	QQQ	ETF	155.895	155.95	155.69	155.81	1347566.0
2017-12-11 14:00:00	QQQ	ETF	155.81	155.875	155.671	155.761	1681181.0
2017-12-11 15:00:00	QQQ	ETF	155.76	155.91	155.63	155.9	4511988.0
2017-12-11 16:00:00	QQQ	ETF	155.9	156.26	155.87	156.14	986908.0
2017-12-11 17:00:00	QQQ	ETF	156.16	156.17	155.548	156.1	68844.0
2017-12-11 18:00:00	QQQ	ETF	156.11	156.14	156.01	156.11	60966.0
2017-12-11 19:00:00	QQQ	ETF	156.09	156.19	156.07	156.1	37313.0
2017-12-11 04:00:00	IWM	ETF	151.5	151.5	151.5	151.5	716.0
2017-12-11 07:00:00	IWM	ETF	151.57	151.7	151.41	151.44	55732.0
2017-12-11 08:00:00	IWM	ETF	151.37	151.78	151.33	151.77	436352.0
2017-12-11 09:00:00	IWM	ETF	151.74	152.13	151.52	151.86	1789066.0
2017-12-11 10:00:00	IWM	ETF	151.87	151.92	151.28	151.445	3810613.0
2017-12-11 11:00:00	IWM	ETF	151.45	151.74	151.225	151.66	2195294.0
2017-12-11 12:00:00	IWM	ETF	151.665	151.88	151.6	151.61	1425357.0
2017-12-11 13:00:00	IWM	ETF	151.61	151.66	151.23	151.425	1063406.0
2017-12-11 14:00:00	IWM	ETF	151.42	151.4501	151.1999	151.285	1290850.0
2017-12-11 15:00:00	IWM	ETF	151.285	151.33	151.02	151.33	3381712.0
2017-12-11 16:00:00	IWM	ETF	151.32	152.0093	151.2249	151.63	4308702.0
2017-12-11 17:00:00	IWM	ETF	151.473	151.67	151.473	151.53	21191.0
2017-12-11 18:00:00	IWM	ETF	151.55	151.64	151.35	151.64	3100.0
2017-12-11 19:00:00	IWM	ETF	151.62	151.72	151.62	151.65	8054.0
2017-12-11 07:00:00	DIA	ETF	244.0	244.0	243.8	243.8	542.0
2017-12-11 08:00:00	DIA	ETF	243.75	244.0	243.73	244.0	7792.0
2017-12-11 09:00:00	DIA	ETF	243.99	244.13	243.5	244.12	278375.0
2017-12-11 10:00:00	DIA	ETF	244.13	244.21	243.56	243.57	430100.0

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

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