PREVIEW / etf_1hour / 2020-09-10

all etf 1-hour files

  file:    by_date/etf_1hour/2020/2020-09-10.parquet
  size:    376 KB
  rows:    12,905

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-10 04:00:00	SPY	ETF	338.36	338.75	337.6	338.52	66191.0
2020-09-10 05:00:00	SPY	ETF	338.29	339.4	338.11	339.35	36330.0
2020-09-10 06:00:00	SPY	ETF	339.3	340.05	337.94	338.12	129958.0
2020-09-10 07:00:00	SPY	ETF	338.01	339.44	337.95	339.3	324108.0
2020-09-10 08:00:00	SPY	ETF	338.1799	341.18	338.02	340.78	672552.0
2020-09-10 09:00:00	SPY	ETF	340.87	342.43	340.72	341.61	5483127.0
2020-09-10 10:00:00	SPY	ETF	341.62	342.53	338.64	338.8	11892479.0
2020-09-10 11:00:00	SPY	ETF	338.8	340.829	338.12	339.425	12372020.0
2020-09-10 12:00:00	SPY	ETF	339.43	339.9516	337.33	338.5084	6647931.0
2020-09-10 13:00:00	SPY	ETF	338.4959	339.6	337.57	337.78	5090521.0
2020-09-10 14:00:00	SPY	ETF	337.75	338.51	334.11	336.0217	14808363.0
2020-09-10 15:00:00	SPY	ETF	336.03	336.11	332.85	333.92	25357850.0
2020-09-10 16:00:00	SPY	ETF	333.94	334.81	333.54	334.33	5529815.0
2020-09-10 17:00:00	SPY	ETF	334.3	334.5	333.89	334.49	245609.0
2020-09-10 18:00:00	SPY	ETF	334.44	335.28	334.44	334.95	102394.0
2020-09-10 19:00:00	SPY	ETF	335.04	335.3899	334.4	334.82	157918.0
2020-09-10 04:00:00	QQQ	ETF	275.7	276.68	274.84	276.11	85362.0
2020-09-10 05:00:00	QQQ	ETF	276.07	277.8	275.99	277.71	24680.0
2020-09-10 06:00:00	QQQ	ETF	277.72	278.56	276.23	276.55	117412.0
2020-09-10 07:00:00	QQQ	ETF	276.54	278.62	276.54	278.37	315585.0
2020-09-10 08:00:00	QQQ	ETF	276.7999	280.54	276.07	280.31	850913.0
2020-09-10 09:00:00	QQQ	ETF	280.37	281.7	279.52	280.69	6460599.0
2020-09-10 10:00:00	QQQ	ETF	280.68	282.195	277.64	277.9401	8119426.0
2020-09-10 11:00:00	QQQ	ETF	277.99	280.52	277.01	278.97	6342843.0
2020-09-10 12:00:00	QQQ	ETF	279.0	279.48	276.3	277.68	5879927.0
2020-09-10 13:00:00	QQQ	ETF	277.7	278.525	276.07	276.23	4484842.0
2020-09-10 14:00:00	QQQ	ETF	276.2	276.88	271.85	273.79	11131287.0
2020-09-10 15:00:00	QQQ	ETF	273.83	273.88	270.56	272.19	13503603.0
2020-09-10 16:00:00	QQQ	ETF	272.19	272.97	271.62	272.7	2427004.0
2020-09-10 17:00:00	QQQ	ETF	272.67	273.1	272.43	273.01	92683.0
2020-09-10 18:00:00	QQQ	ETF	273.01	273.81	273.01	273.4	168557.0
2020-09-10 19:00:00	QQQ	ETF	273.4	273.83	273.3	273.38	79145.0
2020-09-10 04:00:00	IWM	ETF	151.17	151.18	150.8	150.97	17735.0
2020-09-10 05:00:00	IWM	ETF	150.99	151.34	150.99	151.31	3135.0
2020-09-10 06:00:00	IWM	ETF	151.4	151.62	150.83	151.08	10900.0
2020-09-10 07:00:00	IWM	ETF	151.07	151.61	150.95	151.61	30141.0
2020-09-10 08:00:00	IWM	ETF	151.15	152.66	151.0	152.39	69016.0
2020-09-10 09:00:00	IWM	ETF	152.59	153.875	152.51	153.2839	1732239.0
2020-09-10 10:00:00	IWM	ETF	153.33	153.8	151.62	151.76	2637009.0
2020-09-10 11:00:00	IWM	ETF	151.76	152.74	151.41	152.16	1961896.0
2020-09-10 12:00:00	IWM	ETF	152.11	152.61	151.59	152.11	1443749.0
2020-09-10 13:00:00	IWM	ETF	152.11	152.73	151.98	152.04	1301210.0
2020-09-10 14:00:00	IWM	ETF	152.02	152.35	150.78	151.54	2364306.0
2020-09-10 15:00:00	IWM	ETF	151.54	151.63	150.055	150.18	5017137.0
2020-09-10 16:00:00	IWM	ETF	150.15	150.6	149.9	150.2504	1466558.0
2020-09-10 17:00:00	IWM	ETF	150.2	150.25	150.1	150.24	24662.0
2020-09-10 18:00:00	IWM	ETF	150.27	150.7	150.27	150.7	32051.0
2020-09-10 19:00:00	IWM	ETF	150.75	150.75	150.59	150.63	5364.0
2020-09-10 04:00:00	DIA	ETF	279.0	279.0	278.89	278.89	900.0
2020-09-10 05:00:00	DIA	ETF	278.85	279.42	278.85	279.42	1200.0

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

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