PREVIEW / etf_1hour / 2019-09-24

all etf 1-hour files

  file:    by_date/etf_1hour/2019/2019-09-24.parquet
  size:    341 KB
  rows:    11,026

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
2019-09-24 04:00:00	SPY	ETF	299.2	299.45	299.2	299.39	20062.0
2019-09-24 05:00:00	SPY	ETF	299.39	299.64	299.39	299.57	12536.0
2019-09-24 06:00:00	SPY	ETF	299.45	299.56	299.3	299.53	21252.0
2019-09-24 07:00:00	SPY	ETF	299.55	299.84	299.55	299.63	71756.0
2019-09-24 08:00:00	SPY	ETF	299.63	299.69	299.11	299.3	675205.0
2019-09-24 09:00:00	SPY	ETF	299.31	299.84	299.06	299.585	5335115.0
2019-09-24 10:00:00	SPY	ETF	299.585	299.61	298.62	298.8865	9450195.0
2019-09-24 11:00:00	SPY	ETF	298.89	298.91	297.21	297.5	9241520.0
2019-09-24 12:00:00	SPY	ETF	297.4902	297.89	295.13	295.25	13871626.0
2019-09-24 13:00:00	SPY	ETF	295.24	295.88	294.835	295.46	10456523.0
2019-09-24 14:00:00	SPY	ETF	295.4663	299.6	294.81	295.76	17934847.0
2019-09-24 15:00:00	SPY	ETF	295.74	299.24	295.05	295.81	18363517.0
2019-09-24 16:00:00	SPY	ETF	295.81	298.38	295.7402	296.11	8653126.0
2019-09-24 17:00:00	SPY	ETF	296.19	296.23	295.87	296.03	1729493.0
2019-09-24 18:00:00	SPY	ETF	296.01	296.25	295.72	296.17	165203.0
2019-09-24 19:00:00	SPY	ETF	296.2	296.59	296.2	296.46	89821.0
2019-09-24 04:00:00	QQQ	ETF	191.25	191.36	191.22	191.36	14030.0
2019-09-24 05:00:00	QQQ	ETF	191.34	191.5	191.33	191.45	12480.0
2019-09-24 06:00:00	QQQ	ETF	191.43	191.43	191.28	191.42	12209.0
2019-09-24 07:00:00	QQQ	ETF	191.46	191.62	191.4	191.46	67908.0
2019-09-24 08:00:00	QQQ	ETF	191.5	191.53	191.08	191.24	113717.0
2019-09-24 09:00:00	QQQ	ETF	191.24	191.79	191.14	191.5618	2674550.0
2019-09-24 10:00:00	QQQ	ETF	191.58	191.585	190.34	190.53	4135535.0
2019-09-24 11:00:00	QQQ	ETF	190.54	190.57	188.942	189.3	4417922.0
2019-09-24 12:00:00	QQQ	ETF	189.28	189.59	187.4	187.53	5557963.0
2019-09-24 13:00:00	QQQ	ETF	187.54	188.02	187.23	187.62	3077355.0
2019-09-24 14:00:00	QQQ	ETF	187.62	188.86	187.151	187.905	6113136.0
2019-09-24 15:00:00	QQQ	ETF	187.89	188.1534	187.39	187.87	6316249.0
2019-09-24 16:00:00	QQQ	ETF	187.88	188.27	187.8082	188.05	1095676.0
2019-09-24 17:00:00	QQQ	ETF	187.91	188.07	187.5	187.83	70757.0
2019-09-24 18:00:00	QQQ	ETF	187.9	188.19	187.68	188.13	66484.0
2019-09-24 19:00:00	QQQ	ETF	188.17	188.42	188.15	188.39	44574.0
2019-09-24 04:00:00	IWM	ETF	155.18	155.26	155.18	155.26	1523.0
2019-09-24 05:00:00	IWM	ETF	155.28	155.29	155.28	155.29	900.0
2019-09-24 06:00:00	IWM	ETF	155.3	155.3	155.2	155.27	8600.0
2019-09-24 07:00:00	IWM	ETF	155.3	155.44	155.3	155.34	11600.0
2019-09-24 08:00:00	IWM	ETF	155.3601	155.38	155.13	155.2	12985.0
2019-09-24 09:00:00	IWM	ETF	155.2	155.29	154.81	154.84	1775435.0
2019-09-24 10:00:00	IWM	ETF	154.82	154.9	153.84	153.92	3393390.0
2019-09-24 11:00:00	IWM	ETF	153.92	153.965	152.89	153.26	3156019.0
2019-09-24 12:00:00	IWM	ETF	153.25	153.57	152.16	152.22	3169116.0
2019-09-24 13:00:00	IWM	ETF	152.22	152.665	152.03	152.295	2333345.0
2019-09-24 14:00:00	IWM	ETF	152.2963	153.1	151.84	152.51	4359503.0
2019-09-24 15:00:00	IWM	ETF	152.49	152.71	151.99	152.42	4915931.0
2019-09-24 16:00:00	IWM	ETF	152.43	152.67	152.3389	152.46	1591141.0
2019-09-24 17:00:00	IWM	ETF	152.48	152.48	152.25	152.37	70077.0
2019-09-24 18:00:00	IWM	ETF	152.41	152.57	152.32	152.57	44106.0
2019-09-24 19:00:00	IWM	ETF	152.57	152.69	152.56	152.64	6630.0
2019-09-24 05:00:00	DIA	ETF	270.32	270.32	270.32	270.32	130.0
2019-09-24 07:00:00	DIA	ETF	270.56	270.6	270.52	270.52	680.0

> showing 50 of 11,026 rows — these rows as CSV

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