PREVIEW / etf_1hour / 2020-03-02

all etf 1-hour files

  file:    by_date/etf_1hour/2020/2020-03-02.parquet
  size:    412 KB
  rows:    13,890

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-03-02 04:00:00	SPY	ETF	300.2	300.57	296.22	297.24	238326.0
2020-03-02 05:00:00	SPY	ETF	297.51	297.9	295.95	296.12	159153.0
2020-03-02 06:00:00	SPY	ETF	296.0	296.08	290.65	291.1	965795.0
2020-03-02 07:00:00	SPY	ETF	291.14	294.86	290.9	294.29	1408093.0
2020-03-02 08:00:00	SPY	ETF	294.42	302.07	290.99	296.14	3203023.0
2020-03-02 09:00:00	SPY	ETF	296.2	299.11	295.87	296.48	27687072.0
2020-03-02 10:00:00	SPY	ETF	296.49	300.06	294.46	298.52	32649918.0
2020-03-02 11:00:00	SPY	ETF	298.52	303.88	298.15	303.61	30340445.0
2020-03-02 12:00:00	SPY	ETF	303.6	304.07	301.49	303.63	23477460.0
2020-03-02 13:00:00	SPY	ETF	303.62	303.99	300.79	302.57	22452355.0
2020-03-02 14:00:00	SPY	ETF	302.54	303.43	298.98	300.06	22682966.0
2020-03-02 15:00:00	SPY	ETF	300.06	309.16	299.94	309.08	48650507.0
2020-03-02 16:00:00	SPY	ETF	309.09	309.42	306.32	307.29	19483948.0
2020-03-02 17:00:00	SPY	ETF	307.15	309.09	307.01	308.01	2104166.0
2020-03-02 18:00:00	SPY	ETF	308.02	308.53	306.94	308.53	817256.0
2020-03-02 19:00:00	SPY	ETF	308.6	309.63	308.5	309.4	486380.0
2020-03-02 04:00:00	QQQ	ETF	209.61	210.55	207.42	208.32	215533.0
2020-03-02 05:00:00	QQQ	ETF	208.0	208.71	207.26	207.38	185427.0
2020-03-02 06:00:00	QQQ	ETF	207.33	207.33	204.04	204.44	315350.0
2020-03-02 07:00:00	QQQ	ETF	204.46	206.43	204.39	206.07	1246398.0
2020-03-02 08:00:00	QQQ	ETF	206.16	211.5	204.22	207.55	1592906.0
2020-03-02 09:00:00	QQQ	ETF	207.57	209.67	206.94	207.69	14643400.0
2020-03-02 10:00:00	QQQ	ETF	207.69	209.7	205.94	208.706	11287956.0
2020-03-02 11:00:00	QQQ	ETF	208.67	212.92	208.61	212.8008	12545753.0
2020-03-02 12:00:00	QQQ	ETF	212.81	213.08	211.09	212.85	7190700.0
2020-03-02 13:00:00	QQQ	ETF	212.85	213.05	210.55	211.67	7218305.0
2020-03-02 14:00:00	QQQ	ETF	211.66	212.33	209.12	210.03	8559656.0
2020-03-02 15:00:00	QQQ	ETF	210.04	216.57	209.93	216.48	15413593.0
2020-03-02 16:00:00	QQQ	ETF	216.47	216.64	206.3908	215.08	3946456.0
2020-03-02 17:00:00	QQQ	ETF	215.1	216.42	215.03	215.6	360824.0
2020-03-02 18:00:00	QQQ	ETF	215.55	216.05	214.69	216.05	213092.0
2020-03-02 19:00:00	QQQ	ETF	216.11	216.82	214.42	216.62	1179199.0
2020-03-02 04:00:00	IWM	ETF	149.38	149.85	147.83	147.83	30340.0
2020-03-02 05:00:00	IWM	ETF	148.0	148.05	147.34	147.34	22256.0
2020-03-02 06:00:00	IWM	ETF	147.31	147.42	144.69	144.69	63471.0
2020-03-02 07:00:00	IWM	ETF	144.92	146.5	144.9	146.49	127589.0
2020-03-02 08:00:00	IWM	ETF	145.43	148.11	144.93	147.2498	282859.0
2020-03-02 09:00:00	IWM	ETF	147.25	148.06	146.21	146.42	5083662.0
2020-03-02 10:00:00	IWM	ETF	146.3	148.33	145.39	147.71	4408245.0
2020-03-02 11:00:00	IWM	ETF	147.7	149.4	147.29	149.31	3822839.0
2020-03-02 12:00:00	IWM	ETF	149.32	149.46	148.22	149.4	2424011.0
2020-03-02 13:00:00	IWM	ETF	149.39	149.51	148.04	148.92	2104188.0
2020-03-02 14:00:00	IWM	ETF	148.89	149.45	147.5	147.82	2837577.0
2020-03-02 15:00:00	IWM	ETF	147.82	151.23	147.78	151.14	5906777.0
2020-03-02 16:00:00	IWM	ETF	151.13	151.4	149.37	149.91	1434171.0
2020-03-02 17:00:00	IWM	ETF	150.24	150.5	149.76	150.5	105384.0
2020-03-02 18:00:00	IWM	ETF	150.33	151.03	150.01	150.7	88923.0
2020-03-02 19:00:00	IWM	ETF	150.94	151.18	150.8	151.18	17918.0
2020-03-02 04:00:00	DIA	ETF	258.29	258.97	255.44	255.56	14994.0
2020-03-02 05:00:00	DIA	ETF	256.18	256.43	255.07	255.35	8234.0

> showing 50 of 13,890 rows — these rows as CSV

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