PREVIEW / etf_1hour / 2018-01-23

all etf 1-hour files

  file:    by_date/etf_1hour/2018/2018-01-23.parquet
  size:    312 KB
  rows:    10,326

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-23 04:00:00	SPY	ETF	283.02	283.26	283.02	283.15	6855.0
2018-01-23 05:00:00	SPY	ETF	283.13	283.2	282.96	282.98	4800.0
2018-01-23 06:00:00	SPY	ETF	282.95	282.95	282.08	282.45	138181.0
2018-01-23 07:00:00	SPY	ETF	282.48	282.66	282.4	282.5	170734.0
2018-01-23 08:00:00	SPY	ETF	283.51	283.51	282.37	282.37	608113.0
2018-01-23 09:00:00	SPY	ETF	282.37	283.31	282.34	282.65	10323160.0
2018-01-23 10:00:00	SPY	ETF	282.65	283.53	282.47	283.45	12431061.0
2018-01-23 11:00:00	SPY	ETF	283.445	283.62	282.93	283.0625	12344655.0
2018-01-23 12:00:00	SPY	ETF	283.06	283.22	282.84	283.08	7079817.0
2018-01-23 13:00:00	SPY	ETF	283.08	283.5	282.99	283.46	8985622.0
2018-01-23 14:00:00	SPY	ETF	283.47	283.51	282.88	283.38	8838566.0
2018-01-23 15:00:00	SPY	ETF	283.38	283.54	283.02	283.26	16407120.0
2018-01-23 16:00:00	SPY	ETF	283.24	283.4571	282.76	283.03	11061345.0
2018-01-23 17:00:00	SPY	ETF	283.03	283.1591	282.92	282.92	4813088.0
2018-01-23 18:00:00	SPY	ETF	282.92	283.09	282.87	283.04	118790.0
2018-01-23 19:00:00	SPY	ETF	283.09	283.25	283.09	283.19	52831.0
2018-01-23 04:00:00	QQQ	ETF	168.88	168.94	168.83	168.86	15350.0
2018-01-23 05:00:00	QQQ	ETF	168.84	168.84	168.71	168.73	3700.0
2018-01-23 06:00:00	QQQ	ETF	168.6	168.6	168.2	168.47	70030.0
2018-01-23 07:00:00	QQQ	ETF	168.46	168.64	168.46	168.55	155503.0
2018-01-23 08:00:00	QQQ	ETF	168.58	169.07	168.34	168.35	407196.0
2018-01-23 09:00:00	QQQ	ETF	168.34	169.2275	168.33	168.82	6081669.0
2018-01-23 10:00:00	QQQ	ETF	168.82	169.53	168.72	169.47	4259186.0
2018-01-23 11:00:00	QQQ	ETF	169.47	169.61	169.16	169.23	2645844.0
2018-01-23 12:00:00	QQQ	ETF	169.23	169.4698	169.16	169.23	1596659.0
2018-01-23 13:00:00	QQQ	ETF	169.24	169.59	169.18	169.57	2006422.0
2018-01-23 14:00:00	QQQ	ETF	169.57	169.57	168.95	169.35	3060355.0
2018-01-23 15:00:00	QQQ	ETF	169.36	169.66	169.23	169.49	5295451.0
2018-01-23 16:00:00	QQQ	ETF	169.49	169.52	169.08	169.11	1894901.0
2018-01-23 17:00:00	QQQ	ETF	169.09	169.18	169.0	169.07	57788.0
2018-01-23 18:00:00	QQQ	ETF	169.01	169.2	169.0	169.1	36504.0
2018-01-23 19:00:00	QQQ	ETF	169.17	169.3	169.17	169.27	15118.0
2018-01-23 04:00:00	IWM	ETF	159.64	159.64	159.58	159.58	650.0
2018-01-23 05:00:00	IWM	ETF	159.56	159.56	159.45	159.45	1535.0
2018-01-23 06:00:00	IWM	ETF	159.31	159.31	158.84	158.84	22752.0
2018-01-23 07:00:00	IWM	ETF	159.2	159.28	159.04	159.19	27367.0
2018-01-23 08:00:00	IWM	ETF	159.15	159.18	158.98	158.99	78721.0
2018-01-23 09:00:00	IWM	ETF	159.0	159.45	158.78	158.8861	1983026.0
2018-01-23 10:00:00	IWM	ETF	158.87	159.29	158.67	159.25	2495918.0
2018-01-23 11:00:00	IWM	ETF	159.25	159.61	159.17	159.5	1729275.0
2018-01-23 12:00:00	IWM	ETF	159.51	159.71	159.43	159.62	811385.0
2018-01-23 13:00:00	IWM	ETF	159.62	160.07	159.59	159.87	1349249.0
2018-01-23 14:00:00	IWM	ETF	159.87	160.3	159.58	160.12	1279725.0
2018-01-23 15:00:00	IWM	ETF	160.13	160.145	159.7	159.95	2596932.0
2018-01-23 16:00:00	IWM	ETF	159.94	160.0	159.79	159.81	894294.0
2018-01-23 17:00:00	IWM	ETF	159.8	159.89	159.8	159.89	7645.0
2018-01-23 18:00:00	IWM	ETF	159.8	159.94	159.79	159.93	4962.0
2018-01-23 19:00:00	IWM	ETF	159.95	160.05	159.95	159.96	4398.0
2018-01-23 04:00:00	DIA	ETF	262.3	262.3	262.3	262.3	200.0
2018-01-23 06:00:00	DIA	ETF	262.5	262.5	261.65	261.65	1150.0

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

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