PREVIEW / etf_1hour / 2020-04-15

all etf 1-hour files

  file:    by_date/etf_1hour/2020/2020-04-15.parquet
  size:    382 KB
  rows:    13,055

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-04-15 04:00:00	SPY	ETF	280.36	280.96	279.21	279.6	127647.0
2020-04-15 05:00:00	SPY	ETF	279.6	279.66	278.86	279.52	96537.0
2020-04-15 06:00:00	SPY	ETF	279.54	280.1	278.6	279.45	265560.0
2020-04-15 07:00:00	SPY	ETF	279.49	280.23	279.28	279.29	1031917.0
2020-04-15 08:00:00	SPY	ETF	279.3799	283.68	275.96	276.23	2410522.0
2020-04-15 09:00:00	SPY	ETF	276.21	278.39	275.78	277.369	16683063.0
2020-04-15 10:00:00	SPY	ETF	277.37	283.9407	275.46	276.7847	19333282.0
2020-04-15 11:00:00	SPY	ETF	276.77	277.28	275.63	276.14	12720330.0
2020-04-15 12:00:00	SPY	ETF	276.13	277.87	275.76	277.3586	11821594.0
2020-04-15 13:00:00	SPY	ETF	277.35	278.75	277.03	277.1699	12513361.0
2020-04-15 14:00:00	SPY	ETF	277.18	279.41	277.17	279.38	14052401.0
2020-04-15 15:00:00	SPY	ETF	279.385	279.59	277.07	277.75	23014091.0
2020-04-15 16:00:00	SPY	ETF	277.73	278.79	276.82	277.08	6077939.0
2020-04-15 17:00:00	SPY	ETF	277.2	277.2	276.95	277.05	757174.0
2020-04-15 18:00:00	SPY	ETF	277.08	277.76	275.64	275.9	366497.0
2020-04-15 19:00:00	SPY	ETF	275.92	276.03	275.4	275.7	251269.0
2020-04-15 04:00:00	QQQ	ETF	209.75	210.14	209.16	209.5	52406.0
2020-04-15 05:00:00	QQQ	ETF	209.3	209.53	208.83	209.44	60654.0
2020-04-15 06:00:00	QQQ	ETF	209.48	209.74	208.95	209.56	101997.0
2020-04-15 07:00:00	QQQ	ETF	209.62	210.33	209.57	209.77	281342.0
2020-04-15 08:00:00	QQQ	ETF	209.78	211.86	207.65	207.88	847188.0
2020-04-15 09:00:00	QQQ	ETF	207.82	209.06	207.12	207.9134	5629034.0
2020-04-15 10:00:00	QQQ	ETF	207.92	209.44	207.48	209.2	5917856.0
2020-04-15 11:00:00	QQQ	ETF	209.205	209.4298	207.91	208.1814	4176282.0
2020-04-15 12:00:00	QQQ	ETF	208.16	209.56	208.02	209.196	3325523.0
2020-04-15 13:00:00	QQQ	ETF	209.17	209.763	208.91	209.2155	3400852.0
2020-04-15 14:00:00	QQQ	ETF	209.22	211.0315	209.205	211.0305	4522010.0
2020-04-15 15:00:00	QQQ	ETF	211.02	211.26	209.04	209.43	8504640.0
2020-04-15 16:00:00	QQQ	ETF	209.44	209.82	209.0187	209.28	1797296.0
2020-04-15 17:00:00	QQQ	ETF	209.35	209.52	209.13	209.38	46867.0
2020-04-15 18:00:00	QQQ	ETF	209.38	209.6	208.15	208.37	163740.0
2020-04-15 19:00:00	QQQ	ETF	208.41	208.41	207.88	208.24	120308.0
2020-04-15 04:00:00	IWM	ETF	120.38	120.85	120.1	120.22	31536.0
2020-04-15 05:00:00	IWM	ETF	120.28	120.28	119.9	119.91	23733.0
2020-04-15 06:00:00	IWM	ETF	120.02	120.1	119.55	119.8	19092.0
2020-04-15 07:00:00	IWM	ETF	119.91	120.3	119.76	119.89	217815.0
2020-04-15 08:00:00	IWM	ETF	120.23	121.62	117.6	117.94	392806.0
2020-04-15 09:00:00	IWM	ETF	117.87	118.75	117.34	118.19	5062784.0
2020-04-15 10:00:00	IWM	ETF	118.18	118.2	116.82	117.715	5230094.0
2020-04-15 11:00:00	IWM	ETF	117.71	118.03	116.94	117.24	3246582.0
2020-04-15 12:00:00	IWM	ETF	117.235	117.99	116.66	117.781	3209524.0
2020-04-15 13:00:00	IWM	ETF	117.78	118.742	117.55	117.95	2744036.0
2020-04-15 14:00:00	IWM	ETF	117.96	119.11	117.955	118.967	2921609.0
2020-04-15 15:00:00	IWM	ETF	118.965	119.11	117.37	117.79	5922827.0
2020-04-15 16:00:00	IWM	ETF	117.79	118.15	117.43	117.45	1345882.0
2020-04-15 17:00:00	IWM	ETF	117.59	117.76	117.43	117.53	27700.0
2020-04-15 18:00:00	IWM	ETF	117.43	117.8	116.7	116.75	162434.0
2020-04-15 19:00:00	IWM	ETF	116.58	116.88	116.53	116.57	68868.0
2020-04-15 04:00:00	DIA	ETF	236.98	237.29	235.82	236.21	8559.0
2020-04-15 05:00:00	DIA	ETF	236.2	236.32	235.77	235.92	14977.0

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

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