PREVIEW / etf_1hour / 2020-09-04

all etf 1-hour files

  file:    by_date/etf_1hour/2020/2020-09-04.parquet
  size:    389 KB
  rows:    13,308

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-09-04 04:00:00	SPY	ETF	347.0	347.8	346.69	347.36	72112.0
2020-09-04 05:00:00	SPY	ETF	347.6	348.32	347.22	348.26	59164.0
2020-09-04 06:00:00	SPY	ETF	348.36	348.5	347.16	347.28	157465.0
2020-09-04 07:00:00	SPY	ETF	347.2	347.27	344.79	345.06	610222.0
2020-09-04 08:00:00	SPY	ETF	345.4901	348.3904	344.23	346.54	1444369.0
2020-09-04 09:00:00	SPY	ETF	346.49	347.83	343.05	343.56	14419630.0
2020-09-04 10:00:00	SPY	ETF	343.55	345.427	334.87	338.42	29432810.0
2020-09-04 11:00:00	SPY	ETF	338.41	339.55	335.42	339.21	14543342.0
2020-09-04 12:00:00	SPY	ETF	339.22	341.6	338.05	340.91	12245534.0
2020-09-04 13:00:00	SPY	ETF	340.89	340.9	338.46	340.355	10159684.0
2020-09-04 14:00:00	SPY	ETF	340.355	344.625	339.69	344.55	10739433.0
2020-09-04 15:00:00	SPY	ETF	344.56	345.4	342.26	342.6	27407864.0
2020-09-04 16:00:00	SPY	ETF	342.59	343.5	341.1628	341.55	14396245.0
2020-09-04 17:00:00	SPY	ETF	341.64	342.52	341.64	342.45	386722.0
2020-09-04 18:00:00	SPY	ETF	342.45	342.51	342.29	342.31	68546.0
2020-09-04 19:00:00	SPY	ETF	342.29	342.3	341.86	342.0	34606.0
2020-09-04 04:00:00	QQQ	ETF	287.05	287.57	286.19	287.12	106559.0
2020-09-04 05:00:00	QQQ	ETF	287.11	287.73	286.35	287.6	78257.0
2020-09-04 06:00:00	QQQ	ETF	287.66	287.85	286.54	286.63	148249.0
2020-09-04 07:00:00	QQQ	ETF	286.58	286.64	283.34	284.0	596520.0
2020-09-04 08:00:00	QQQ	ETF	283.97	287.8496	283.4101	285.15	1449346.0
2020-09-04 09:00:00	QQQ	ETF	285.15	288.93	280.51	281.58	14430556.0
2020-09-04 10:00:00	QQQ	ETF	281.52	283.25	271.8	276.89	28444964.0
2020-09-04 11:00:00	QQQ	ETF	276.86	280.46	274.12	280.275	13803452.0
2020-09-04 12:00:00	QQQ	ETF	280.28	282.55	278.28	280.75	10026779.0
2020-09-04 13:00:00	QQQ	ETF	280.7411	280.79	277.33	280.01	5722917.0
2020-09-04 14:00:00	QQQ	ETF	279.98	285.14	279.28	285.02	8266590.0
2020-09-04 15:00:00	QQQ	ETF	285.03	286.66	283.37	283.47	13864872.0
2020-09-04 16:00:00	QQQ	ETF	283.47	283.58	281.46	281.52	4118248.0
2020-09-04 17:00:00	QQQ	ETF	281.56	282.7	281.4	281.95	306939.0
2020-09-04 18:00:00	QQQ	ETF	281.82	282.0	281.54	281.6	344588.0
2020-09-04 19:00:00	QQQ	ETF	281.6	281.8	281.39	281.39	51329.0
2020-09-04 04:00:00	IWM	ETF	155.34	155.78	155.21	155.57	14561.0
2020-09-04 05:00:00	IWM	ETF	155.72	156.19	155.61	156.12	16340.0
2020-09-04 06:00:00	IWM	ETF	156.22	156.43	156.02	156.22	68297.0
2020-09-04 07:00:00	IWM	ETF	156.21	156.29	155.1	155.19	241410.0
2020-09-04 08:00:00	IWM	ETF	156.2799	156.42	154.0	156.17	361869.0
2020-09-04 09:00:00	IWM	ETF	156.15	156.44	153.2	153.37	3303760.0
2020-09-04 10:00:00	IWM	ETF	153.35	154.05	149.29	150.92	6581115.0
2020-09-04 11:00:00	IWM	ETF	150.89	151.79	150.19	151.65	4462573.0
2020-09-04 12:00:00	IWM	ETF	151.66	152.45	151.13	152.17	3111929.0
2020-09-04 13:00:00	IWM	ETF	152.14	152.14	151.1	151.99	1574586.0
2020-09-04 14:00:00	IWM	ETF	151.96	153.65	151.7	153.57	2260815.0
2020-09-04 15:00:00	IWM	ETF	153.58	153.94	152.51	152.83	3789704.0
2020-09-04 16:00:00	IWM	ETF	152.82	152.92	152.38	152.5	852025.0
2020-09-04 17:00:00	IWM	ETF	152.6	152.8	152.6	152.8	4887.0
2020-09-04 18:00:00	IWM	ETF	152.8	152.89	152.7	152.89	1730.0
2020-09-04 19:00:00	IWM	ETF	152.81	152.97	152.69	152.97	3761.0
2020-09-04 04:00:00	DIA	ETF	284.96	285.67	284.96	285.6	4800.0
2020-09-04 05:00:00	DIA	ETF	285.56	286.22	285.24	286.22	10525.0

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

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