PREVIEW / etf_1hour / 2020-10-05

all etf 1-hour files

  file:    by_date/etf_1hour/2020/2020-10-05.parquet
  size:    378 KB
  rows:    12,975

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
2020-10-05 04:00:00	SPY	ETF	335.19	335.77	335.02	335.68	62720.0
2020-10-05 05:00:00	SPY	ETF	335.41	336.13	335.41	336.13	25926.0
2020-10-05 06:00:00	SPY	ETF	336.03	336.3	335.65	336.3	33243.0
2020-10-05 07:00:00	SPY	ETF	336.31	336.67	336.05	336.1	258928.0
2020-10-05 08:00:00	SPY	ETF	335.9796	336.65	335.2	336.05	296760.0
2020-10-05 09:00:00	SPY	ETF	336.06	337.23	336.0	336.58	4510667.0
2020-10-05 10:00:00	SPY	ETF	336.59	338.57	336.58	338.255	5987078.0
2020-10-05 11:00:00	SPY	ETF	338.25	338.87	338.16	338.4259	4663674.0
2020-10-05 12:00:00	SPY	ETF	338.44	338.695	338.245	338.6199	2185915.0
2020-10-05 13:00:00	SPY	ETF	338.62	338.76	337.72	337.845	3602149.0
2020-10-05 14:00:00	SPY	ETF	337.85	339.19	337.51	339.17	5403811.0
2020-10-05 15:00:00	SPY	ETF	339.16	339.96	338.93	339.73	13711878.0
2020-10-05 16:00:00	SPY	ETF	339.72	339.8177	339.2	339.24	3352950.0
2020-10-05 17:00:00	SPY	ETF	339.35	339.76	339.11	339.25	106677.0
2020-10-05 18:00:00	SPY	ETF	339.25	339.67	339.25	339.53	81696.0
2020-10-05 19:00:00	SPY	ETF	339.59	339.59	338.7	338.84	151516.0
2020-10-05 04:00:00	QQQ	ETF	275.47	276.5	275.47	276.28	475518.0
2020-10-05 05:00:00	QQQ	ETF	276.08	276.8	276.04	276.8	86297.0
2020-10-05 06:00:00	QQQ	ETF	276.8	277.12	276.5	277.12	52398.0
2020-10-05 07:00:00	QQQ	ETF	277.11	277.17	276.23	276.26	230054.0
2020-10-05 08:00:00	QQQ	ETF	277.0002	277.1399	275.56	276.06	279952.0
2020-10-05 09:00:00	QQQ	ETF	276.08	277.46	276.04	277.315	3468265.0
2020-10-05 10:00:00	QQQ	ETF	277.32	278.99	277.315	278.42	3597319.0
2020-10-05 11:00:00	QQQ	ETF	278.42	279.07	278.15	278.8001	2270486.0
2020-10-05 12:00:00	QQQ	ETF	278.81	279.32	278.56	279.25	1601284.0
2020-10-05 13:00:00	QQQ	ETF	279.245	279.42	278.061	278.35	1690749.0
2020-10-05 14:00:00	QQQ	ETF	278.32	279.7	277.85	279.68	2647935.0
2020-10-05 15:00:00	QQQ	ETF	279.67	280.49	279.43	280.32	5446176.0
2020-10-05 16:00:00	QQQ	ETF	280.3	280.35	279.78	279.87	911874.0
2020-10-05 17:00:00	QQQ	ETF	279.8	280.06	279.73	280.04	47924.0
2020-10-05 18:00:00	QQQ	ETF	280.0	280.35	279.9	280.19	121117.0
2020-10-05 19:00:00	QQQ	ETF	280.19	280.21	278.63	279.01	277252.0
2020-10-05 04:00:00	IWM	ETF	153.51	153.85	153.44	153.72	6368.0
2020-10-05 05:00:00	IWM	ETF	153.69	153.86	153.59	153.85	2008.0
2020-10-05 06:00:00	IWM	ETF	153.73	154.13	153.58	154.13	14058.0
2020-10-05 07:00:00	IWM	ETF	154.11	154.59	154.041	154.45	91655.0
2020-10-05 08:00:00	IWM	ETF	154.3001	154.83	154.25	154.83	133398.0
2020-10-05 09:00:00	IWM	ETF	154.59	155.84	154.47	155.365	2517854.0
2020-10-05 10:00:00	IWM	ETF	155.39	156.08	155.2	155.86	2626665.0
2020-10-05 11:00:00	IWM	ETF	155.85	156.275	155.7084	155.9995	1982862.0
2020-10-05 12:00:00	IWM	ETF	156.0	156.38	155.93	156.29	770766.0
2020-10-05 13:00:00	IWM	ETF	156.285	156.4	155.955	155.975	1077554.0
2020-10-05 14:00:00	IWM	ETF	155.99	156.86	155.84	156.86	1349350.0
2020-10-05 15:00:00	IWM	ETF	156.8404	157.305	156.67	157.04	3905178.0
2020-10-05 16:00:00	IWM	ETF	157.07	157.1	156.83	156.9	1055741.0
2020-10-05 17:00:00	IWM	ETF	156.61	156.99	156.61	156.8	4619.0
2020-10-05 18:00:00	IWM	ETF	156.9	157.07	156.9	157.0	4802.0
2020-10-05 19:00:00	IWM	ETF	156.96	157.07	156.76	156.82	19299.0
2020-10-05 04:00:00	DIA	ETF	278.33	278.54	278.3	278.43	2013.0
2020-10-05 05:00:00	DIA	ETF	278.5	278.66	278.5	278.5	1500.0

> showing 50 of 12,975 rows — these rows as CSV

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