PREVIEW / etf_1hour / 2020-10-07

all etf 1-hour files

  file:    by_date/etf_1hour/2020/2020-10-07.parquet
  size:    371 KB
  rows:    12,671

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-07 04:00:00	SPY	ETF	337.35	337.45	336.84	337.33	57360.0
2020-10-07 05:00:00	SPY	ETF	337.28	337.33	336.85	336.9	22536.0
2020-10-07 06:00:00	SPY	ETF	336.7	337.51	336.59	337.46	163396.0
2020-10-07 07:00:00	SPY	ETF	337.41	337.87	337.16	337.8	358173.0
2020-10-07 08:00:00	SPY	ETF	337.8	338.45	335.1	337.99	1108562.0
2020-10-07 09:00:00	SPY	ETF	337.95	339.51	337.67	339.0	5787226.0
2020-10-07 10:00:00	SPY	ETF	339.0	339.76	338.37	339.4765	5281155.0
2020-10-07 11:00:00	SPY	ETF	339.48	339.88	339.15	339.39	3598827.0
2020-10-07 12:00:00	SPY	ETF	339.4	339.64	338.51	339.58	3979902.0
2020-10-07 13:00:00	SPY	ETF	339.57	340.8367	339.5621	340.38	6208415.0
2020-10-07 14:00:00	SPY	ETF	340.38	341.39	340.24	341.24	6217487.0
2020-10-07 15:00:00	SPY	ETF	341.25	341.63	340.69	340.73	11928949.0
2020-10-07 16:00:00	SPY	ETF	340.73	340.917	340.37	340.76	10065962.0
2020-10-07 17:00:00	SPY	ETF	340.75	340.9	340.69	340.81	60646.0
2020-10-07 18:00:00	SPY	ETF	340.81	341.35	340.64	341.1	116254.0
2020-10-07 19:00:00	SPY	ETF	341.1	341.54	340.92	341.42	77472.0
2020-10-07 04:00:00	QQQ	ETF	276.9	277.0	276.31	276.5	75503.0
2020-10-07 05:00:00	QQQ	ETF	276.49	276.85	276.17	276.17	71274.0
2020-10-07 06:00:00	QQQ	ETF	276.13	276.65	275.94	276.54	62556.0
2020-10-07 07:00:00	QQQ	ETF	276.54	277.26	276.42	277.2	227504.0
2020-10-07 08:00:00	QQQ	ETF	276.51	277.88	275.28	277.57	329512.0
2020-10-07 09:00:00	QQQ	ETF	277.6	279.088	277.43	278.42	3297438.0
2020-10-07 10:00:00	QQQ	ETF	278.42	278.67	277.28	278.5366	4209433.0
2020-10-07 11:00:00	QQQ	ETF	278.525	279.22	278.42	278.85	2376093.0
2020-10-07 12:00:00	QQQ	ETF	278.86	279.59	278.01	279.53	2308820.0
2020-10-07 13:00:00	QQQ	ETF	279.52	280.56	279.51	280.0899	2346878.0
2020-10-07 14:00:00	QQQ	ETF	280.06	280.69	279.73	280.42	2450718.0
2020-10-07 15:00:00	QQQ	ETF	280.422	280.74	280.01	280.11	3996151.0
2020-10-07 16:00:00	QQQ	ETF	280.1	280.2	279.62	279.95	762697.0
2020-10-07 17:00:00	QQQ	ETF	279.99	280.12	279.88	280.01	18595.0
2020-10-07 18:00:00	QQQ	ETF	280.0	280.51	279.92	280.31	145534.0
2020-10-07 19:00:00	QQQ	ETF	280.31	280.65	280.19	280.63	121259.0
2020-10-07 04:00:00	IWM	ETF	158.13	158.22	157.84	158.0	18571.0
2020-10-07 05:00:00	IWM	ETF	158.11	158.11	157.73	157.83	9300.0
2020-10-07 06:00:00	IWM	ETF	157.73	158.31	157.73	158.31	47205.0
2020-10-07 07:00:00	IWM	ETF	158.31	158.65	158.08	158.58	150743.0
2020-10-07 08:00:00	IWM	ETF	158.046	159.05	157.22	158.62	315267.0
2020-10-07 09:00:00	IWM	ETF	158.58	159.9	158.4638	159.53	4365283.0
2020-10-07 10:00:00	IWM	ETF	159.54	160.04	159.05	159.54	3056765.0
2020-10-07 11:00:00	IWM	ETF	159.53	159.8	159.24	159.49	1877598.0
2020-10-07 12:00:00	IWM	ETF	159.48	159.71	159.1025	159.415	1562055.0
2020-10-07 13:00:00	IWM	ETF	159.41	159.865	159.115	159.41	2598929.0
2020-10-07 14:00:00	IWM	ETF	159.41	159.975	159.35	159.875	1976771.0
2020-10-07 15:00:00	IWM	ETF	159.88	160.56	159.83	160.04	4631512.0
2020-10-07 16:00:00	IWM	ETF	160.04	160.39	159.8526	160.31	1130700.0
2020-10-07 17:00:00	IWM	ETF	160.15	160.38	160.12	160.17	13490.0
2020-10-07 18:00:00	IWM	ETF	160.28	160.54	160.28	160.5	18847.0
2020-10-07 19:00:00	IWM	ETF	160.49	160.65	160.41	160.6	19291.0
2020-10-07 04:00:00	DIA	ETF	279.2	279.97	279.2	279.89	1166.0
2020-10-07 05:00:00	DIA	ETF	279.83	279.86	279.8	279.86	500.0

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

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