PREVIEW / etf_1hour / 2021-08-20

all etf 1-hour files

  file:    by_date/etf_1hour/2021/2021-08-20.parquet
  size:    410 KB
  rows:    14,242

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
2021-08-20 04:00:00	SPY	ETF	437.57	438.07	437.15	437.96	29426.0
2021-08-20 05:00:00	SPY	ETF	437.73	438.65	437.63	438.08	34759.0
2021-08-20 06:00:00	SPY	ETF	438.08	438.35	437.84	438.08	101742.0
2021-08-20 07:00:00	SPY	ETF	438.08	438.57	437.58	437.96	317293.0
2021-08-20 08:00:00	SPY	ETF	438.0101	440.239	437.0	439.65	434155.0
2021-08-20 09:00:00	SPY	ETF	439.67	442.08	439.5	441.845	7661159.0
2021-08-20 10:00:00	SPY	ETF	441.85	443.01	441.74	442.19	9282620.0
2021-08-20 11:00:00	SPY	ETF	442.17	442.78	441.961	442.43	5156918.0
2021-08-20 12:00:00	SPY	ETF	442.44	443.55	442.33	443.22	4437120.0
2021-08-20 13:00:00	SPY	ETF	443.22	443.54	442.72	442.78	3561091.0
2021-08-20 14:00:00	SPY	ETF	442.79	443.21	442.46	442.83	4617094.0
2021-08-20 15:00:00	SPY	ETF	442.83	443.71	442.72	443.33	12690544.0
2021-08-20 16:00:00	SPY	ETF	443.33	443.48	443.0	443.45	3093208.0
2021-08-20 17:00:00	SPY	ETF	443.32	443.58	443.31	443.54	61622.0
2021-08-20 18:00:00	SPY	ETF	443.53	443.55	443.45	443.47	4412.0
2021-08-20 19:00:00	SPY	ETF	443.49	443.65	443.49	443.63	17720.0
2021-08-20 04:00:00	QQQ	ETF	362.96	363.08	362.4	362.88	43880.0
2021-08-20 05:00:00	QQQ	ETF	363.0	363.51	362.64	363.13	29598.0
2021-08-20 06:00:00	QQQ	ETF	363.17	363.28	362.85	363.08	24822.0
2021-08-20 07:00:00	QQQ	ETF	363.08	363.6	362.74	363.27	61159.0
2021-08-20 08:00:00	QQQ	ETF	362.73	364.67	362.73	364.67	159783.0
2021-08-20 09:00:00	QQQ	ETF	364.7	366.83	364.53	366.7	6027135.0
2021-08-20 10:00:00	QQQ	ETF	366.7	368.08	366.61	367.35	5586385.0
2021-08-20 11:00:00	QQQ	ETF	367.32	367.45	365.74	366.11	3493070.0
2021-08-20 12:00:00	QQQ	ETF	366.1	367.46	365.94	367.315	2479608.0
2021-08-20 13:00:00	QQQ	ETF	367.32	367.57	366.85	367.015	1495613.0
2021-08-20 14:00:00	QQQ	ETF	367.02	367.41	366.92	367.3175	1940011.0
2021-08-20 15:00:00	QQQ	ETF	367.31	368.14	367.25	367.75	4582954.0
2021-08-20 16:00:00	QQQ	ETF	367.76	368.05	367.64	368.01	2022992.0
2021-08-20 17:00:00	QQQ	ETF	367.99	368.06	367.73	368.0	81685.0
2021-08-20 18:00:00	QQQ	ETF	367.95	368.0	367.93	367.95	4299.0
2021-08-20 19:00:00	QQQ	ETF	367.91	368.05	367.91	368.04	16639.0
2021-08-20 04:00:00	IWM	ETF	211.2	211.2	210.23	210.87	24951.0
2021-08-20 05:00:00	IWM	ETF	210.79	211.24	210.52	210.79	44420.0
2021-08-20 06:00:00	IWM	ETF	210.8	211.06	210.75	210.96	58350.0
2021-08-20 07:00:00	IWM	ETF	210.98	211.06	210.39	210.58	82939.0
2021-08-20 08:00:00	IWM	ETF	211.0201	211.66	210.42	211.63	149773.0
2021-08-20 09:00:00	IWM	ETF	211.61	213.25	211.42	212.77	5013759.0
2021-08-20 10:00:00	IWM	ETF	212.78	213.56	212.47	213.28	4612812.0
2021-08-20 11:00:00	IWM	ETF	213.27	214.38	213.21	214.1419	3507733.0
2021-08-20 12:00:00	IWM	ETF	214.14	216.02	214.1	215.455	2795163.0
2021-08-20 13:00:00	IWM	ETF	215.46	215.85	214.885	214.98	2112346.0
2021-08-20 14:00:00	IWM	ETF	214.99	215.725	214.63	214.98	1938827.0
2021-08-20 15:00:00	IWM	ETF	214.975	215.545	214.92	215.51	3739222.0
2021-08-20 16:00:00	IWM	ETF	215.51	215.55	215.0333	215.47	1300287.0
2021-08-20 17:00:00	IWM	ETF	215.36	215.66	215.35	215.65	11399.0
2021-08-20 18:00:00	IWM	ETF	215.66	215.66	215.45	215.57	9428.0
2021-08-20 19:00:00	IWM	ETF	215.5	215.66	215.5	215.57	796.0
2021-08-20 04:00:00	DIA	ETF	347.2	347.44	346.91	346.91	1355.0
2021-08-20 05:00:00	DIA	ETF	347.3	347.34	347.3	347.31	500.0

> showing 50 of 14,242 rows — these rows as CSV

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