PREVIEW / etf_1hour / 2018-01-02

all etf 1-hour files

  file:    by_date/etf_1hour/2018/2018-01-02.parquet
  size:    313 KB
  rows:    10,248

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
2018-01-02 04:00:00	SPY	ETF	266.89	267.03	266.62	266.77	90496.0
2018-01-02 05:00:00	SPY	ETF	266.84	267.1	266.84	267.03	47172.0
2018-01-02 06:00:00	SPY	ETF	267.1	267.35	267.1	267.3	160901.0
2018-01-02 07:00:00	SPY	ETF	267.31	267.61	267.29	267.56	593908.0
2018-01-02 08:00:00	SPY	ETF	267.57	267.74	267.31	267.63	427802.0
2018-01-02 09:00:00	SPY	ETF	267.63	268.0	267.4	267.98	14109342.0
2018-01-02 10:00:00	SPY	ETF	267.975	268.45	267.96	268.28	9729629.0
2018-01-02 11:00:00	SPY	ETF	268.28	268.41	267.99	268.15	6252777.0
2018-01-02 12:00:00	SPY	ETF	268.15	268.3001	268.07	268.135	3828881.0
2018-01-02 13:00:00	SPY	ETF	268.13	268.34	268.1215	268.28	5474837.0
2018-01-02 14:00:00	SPY	ETF	268.27	268.36	268.21	268.32	5899552.0
2018-01-02 15:00:00	SPY	ETF	268.33	268.81	268.27	268.8	15493029.0
2018-01-02 16:00:00	SPY	ETF	268.78	268.8	268.29	268.6	13077206.0
2018-01-02 17:00:00	SPY	ETF	268.56	268.7744	268.55	268.64	10138602.0
2018-01-02 18:00:00	SPY	ETF	268.64	268.66	268.49	268.61	134502.0
2018-01-02 19:00:00	SPY	ETF	268.62	268.81	268.62	268.73	106334.0
2018-01-02 04:00:00	QQQ	ETF	156.0	156.0	155.56	155.62	37802.0
2018-01-02 05:00:00	QQQ	ETF	155.69	155.73	155.64	155.72	19163.0
2018-01-02 06:00:00	QQQ	ETF	155.88	155.96	155.86	155.92	4400.0
2018-01-02 07:00:00	QQQ	ETF	155.98	156.43	155.98	156.38	59827.0
2018-01-02 08:00:00	QQQ	ETF	155.76	156.44	155.76	156.3	287238.0
2018-01-02 09:00:00	QQQ	ETF	156.33	157.52	156.17	157.49	5975352.0
2018-01-02 10:00:00	QQQ	ETF	157.49	157.98	157.47	157.97	5633953.0
2018-01-02 11:00:00	QQQ	ETF	157.965	158.16	157.8936	157.98	2590301.0
2018-01-02 12:00:00	QQQ	ETF	157.98	158.07	157.895	157.955	1568576.0
2018-01-02 13:00:00	QQQ	ETF	157.95	158.16	157.91	158.15	1880679.0
2018-01-02 14:00:00	QQQ	ETF	158.15	158.35	158.14	158.29	1961303.0
2018-01-02 15:00:00	QQQ	ETF	158.28	158.525	158.25	158.47	5022037.0
2018-01-02 16:00:00	QQQ	ETF	158.46	158.49	158.29	158.33	2794527.0
2018-01-02 17:00:00	QQQ	ETF	158.31	158.43	158.31	158.43	35104.0
2018-01-02 18:00:00	QQQ	ETF	158.36	158.36	158.27	158.33	31762.0
2018-01-02 19:00:00	QQQ	ETF	158.39	158.49	158.39	158.45	16096.0
2018-01-02 04:00:00	IWM	ETF	152.54	152.54	152.12	152.13	11438.0
2018-01-02 05:00:00	IWM	ETF	152.22	152.31	152.2	152.31	6108.0
2018-01-02 06:00:00	IWM	ETF	152.36	152.65	152.36	152.65	8595.0
2018-01-02 07:00:00	IWM	ETF	152.63	153.02	152.63	152.96	26883.0
2018-01-02 08:00:00	IWM	ETF	152.93	153.2	152.46	153.13	58383.0
2018-01-02 09:00:00	IWM	ETF	153.2	153.475	152.46	153.475	1990363.0
2018-01-02 10:00:00	IWM	ETF	153.47	153.94	153.44	153.775	2113625.0
2018-01-02 11:00:00	IWM	ETF	153.77	153.85	153.26	153.5718	1204932.0
2018-01-02 12:00:00	IWM	ETF	153.58	153.73	153.34	153.5154	1076932.0
2018-01-02 13:00:00	IWM	ETF	153.51	153.6	153.41	153.53	1086544.0
2018-01-02 14:00:00	IWM	ETF	153.53	153.57	153.23	153.32	1590552.0
2018-01-02 15:00:00	IWM	ETF	153.32	153.97	153.27	153.96	3172549.0
2018-01-02 16:00:00	IWM	ETF	153.94	153.95	153.447	153.63	3139246.0
2018-01-02 17:00:00	IWM	ETF	153.69	153.72	153.66	153.66	7554.0
2018-01-02 18:00:00	IWM	ETF	153.68	153.72	153.57	153.71	10514.0
2018-01-02 19:00:00	IWM	ETF	153.75	153.86	153.73	153.83	10999.0
2018-01-02 07:00:00	DIA	ETF	247.58	248.03	247.58	248.03	4280.0
2018-01-02 08:00:00	DIA	ETF	247.98	248.48	247.38	248.36	35457.0

> showing 50 of 10,248 rows — these rows as CSV

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