PREVIEW / etf_1hour / 2020-10-02

all etf 1-hour files

  file:    by_date/etf_1hour/2020/2020-10-02.parquet
  size:    379 KB
  rows:    12,980

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-02 04:00:00	SPY	ETF	332.89	333.25	332.16	332.85	86460.0
2020-10-02 05:00:00	SPY	ETF	332.83	333.44	331.05	331.34	190341.0
2020-10-02 06:00:00	SPY	ETF	331.3	332.32	330.47	332.17	582931.0
2020-10-02 07:00:00	SPY	ETF	332.15	332.52	331.13	331.36	1057099.0
2020-10-02 08:00:00	SPY	ETF	331.38	336.4	330.67	331.5	1703651.0
2020-10-02 09:00:00	SPY	ETF	331.54	334.38	330.62	334.03	11771325.0
2020-10-02 10:00:00	SPY	ETF	334.05	335.35	333.62	334.52	9832822.0
2020-10-02 11:00:00	SPY	ETF	334.52	335.33	332.69	332.79	7949542.0
2020-10-02 12:00:00	SPY	ETF	332.79	335.92	331.95	335.42	14620194.0
2020-10-02 13:00:00	SPY	ETF	335.415	337.0126	333.84	334.5	8472573.0
2020-10-02 14:00:00	SPY	ETF	334.5	337.0126	334.455	335.205	8133346.0
2020-10-02 15:00:00	SPY	ETF	335.2299	335.58	333.66	333.87	16695011.0
2020-10-02 16:00:00	SPY	ETF	333.88	334.84	333.57	334.6	5165645.0
2020-10-02 17:00:00	SPY	ETF	334.55	334.55	332.55	332.97	815363.0
2020-10-02 18:00:00	SPY	ETF	333.0	333.25	332.06	332.41	159184.0
2020-10-02 19:00:00	SPY	ETF	332.35	332.75	332.16	332.64	98621.0
2020-10-02 04:00:00	QQQ	ETF	277.9	278.15	277.12	277.66	133976.0
2020-10-02 05:00:00	QQQ	ETF	277.61	277.97	275.64	276.18	122455.0
2020-10-02 06:00:00	QQQ	ETF	276.2	277.19	275.45	277.13	223250.0
2020-10-02 07:00:00	QQQ	ETF	276.99	277.29	275.2	275.37	442322.0
2020-10-02 08:00:00	QQQ	ETF	275.34	282.03	275.25	276.1	914841.0
2020-10-02 09:00:00	QQQ	ETF	276.08	278.88	275.19	278.32	6757589.0
2020-10-02 10:00:00	QQQ	ETF	278.31	279.7798	277.75	278.66	5584095.0
2020-10-02 11:00:00	QQQ	ETF	278.63	278.73	274.855	275.0099	7984974.0
2020-10-02 12:00:00	QQQ	ETF	275.02	277.0	273.44	276.112	11175173.0
2020-10-02 13:00:00	QQQ	ETF	276.13	276.36	274.792	275.425	5691951.0
2020-10-02 14:00:00	QQQ	ETF	275.38	276.6084	274.611	275.76	5563027.0
2020-10-02 15:00:00	QQQ	ETF	275.77	276.14	274.18	274.34	8288301.0
2020-10-02 16:00:00	QQQ	ETF	274.35	274.81	273.84	274.57	1798849.0
2020-10-02 17:00:00	QQQ	ETF	274.62	274.64	273.21	273.3	242911.0
2020-10-02 18:00:00	QQQ	ETF	273.3	273.34	272.9	273.0	64320.0
2020-10-02 19:00:00	QQQ	ETF	272.9	273.31	272.9	273.15	47527.0
2020-10-02 04:00:00	IWM	ETF	149.84	150.84	149.71	150.02	17332.0
2020-10-02 05:00:00	IWM	ETF	150.0	150.43	149.28	149.56	24470.0
2020-10-02 06:00:00	IWM	ETF	149.11	149.57	148.75	149.57	80415.0
2020-10-02 07:00:00	IWM	ETF	149.52	149.75	148.56	149.41	203179.0
2020-10-02 08:00:00	IWM	ETF	149.57	150.67	148.95	149.3	386959.0
2020-10-02 09:00:00	IWM	ETF	149.25	150.89	148.86	150.63	3098154.0
2020-10-02 10:00:00	IWM	ETF	150.63	151.87	150.58	151.34	2672862.0
2020-10-02 11:00:00	IWM	ETF	151.32	152.39	151.091	151.3	3031266.0
2020-10-02 12:00:00	IWM	ETF	151.28	153.58	150.97	153.15	5262279.0
2020-10-02 13:00:00	IWM	ETF	153.15	153.37	151.95	152.17	1856494.0
2020-10-02 14:00:00	IWM	ETF	152.17	153.24	152.16	153.03	2485247.0
2020-10-02 15:00:00	IWM	ETF	153.04	153.53	152.62	152.84	4737459.0
2020-10-02 16:00:00	IWM	ETF	152.85	153.5125	152.58	153.37	1731272.0
2020-10-02 17:00:00	IWM	ETF	153.31	153.35	152.2	152.32	150325.0
2020-10-02 18:00:00	IWM	ETF	152.35	152.85	152.1	152.15	22483.0
2020-10-02 19:00:00	IWM	ETF	152.25	152.3	152.14	152.16	7742.0
2020-10-02 04:00:00	DIA	ETF	274.84	275.03	274.7	274.77	1082.0
2020-10-02 05:00:00	DIA	ETF	274.79	275.2	273.79	273.8	6646.0

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

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