PREVIEW / etf_1hour / 2021-01-05

all etf 1-hour files

  file:    by_date/etf_1hour/2021/2021-01-05.parquet
  size:    414 KB
  rows:    14,398

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-01-05 04:00:00	SPY	ETF	369.1	369.74	368.89	369.64	60903.0
2021-01-05 05:00:00	SPY	ETF	369.36	369.59	369.26	369.42	13964.0
2021-01-05 06:00:00	SPY	ETF	369.39	369.88	368.67	368.92	168817.0
2021-01-05 07:00:00	SPY	ETF	368.93	369.05	367.63	368.46	308223.0
2021-01-05 08:00:00	SPY	ETF	368.0601	369.51	366.97	367.0	814653.0
2021-01-05 09:00:00	SPY	ETF	367.01	370.745	366.84	370.1301	6118390.0
2021-01-05 10:00:00	SPY	ETF	370.16	370.92	368.43	368.815	11813913.0
2021-01-05 11:00:00	SPY	ETF	368.82	370.09	368.31	369.75	6521447.0
2021-01-05 12:00:00	SPY	ETF	369.75	370.55	369.66	370.5	4338516.0
2021-01-05 13:00:00	SPY	ETF	370.51	370.885	370.33	370.87	3155509.0
2021-01-05 14:00:00	SPY	ETF	370.88	372.5	370.8789	371.44	6763266.0
2021-01-05 15:00:00	SPY	ETF	371.44	372.22	370.86	371.32	15446543.0
2021-01-05 16:00:00	SPY	ETF	371.3	371.53	370.96	371.2	8497634.0
2021-01-05 17:00:00	SPY	ETF	371.39	371.4	371.07	371.23	324174.0
2021-01-05 18:00:00	SPY	ETF	371.23	371.48	370.65	370.92	157418.0
2021-01-05 19:00:00	SPY	ETF	371.04	372.89	370.81	371.41	334697.0
2021-01-05 04:00:00	QQQ	ETF	309.31	309.9	309.15	309.61	44277.0
2021-01-05 05:00:00	QQQ	ETF	309.67	309.82	309.51	309.64	21674.0
2021-01-05 06:00:00	QQQ	ETF	309.75	310.14	309.0	309.35	47769.0
2021-01-05 07:00:00	QQQ	ETF	309.37	309.37	308.45	309.05	168634.0
2021-01-05 08:00:00	QQQ	ETF	308.8101	309.45	307.38	307.41	569774.0
2021-01-05 09:00:00	QQQ	ETF	307.37	311.1901	307.3604	310.76	3665618.0
2021-01-05 10:00:00	QQQ	ETF	310.77	311.55	309.84	309.87	3496509.0
2021-01-05 11:00:00	QQQ	ETF	309.89	310.65	309.24	310.22	2447939.0
2021-01-05 12:00:00	QQQ	ETF	310.28	310.55	309.59	310.24	2623817.0
2021-01-05 13:00:00	QQQ	ETF	310.24	310.94	310.1113	310.83	1169733.0
2021-01-05 14:00:00	QQQ	ETF	310.865	312.04	310.82	311.34	2498776.0
2021-01-05 15:00:00	QQQ	ETF	311.35	312.14	310.86	311.77	4165166.0
2021-01-05 16:00:00	QQQ	ETF	311.8	312.18	311.393	312.05	2322945.0
2021-01-05 17:00:00	QQQ	ETF	312.02	312.19	311.81	311.9	135336.0
2021-01-05 18:00:00	QQQ	ETF	311.95	312.16	311.57	311.85	80279.0
2021-01-05 19:00:00	QQQ	ETF	311.86	313.0	311.15	311.41	201017.0
2021-01-05 04:00:00	IWM	ETF	193.36	194.21	193.36	194.21	1987.0
2021-01-05 05:00:00	IWM	ETF	194.21	194.21	193.88	194.01	2753.0
2021-01-05 06:00:00	IWM	ETF	194.21	194.21	193.3	193.5	18955.0
2021-01-05 07:00:00	IWM	ETF	193.54	193.57	192.71	193.21	79459.0
2021-01-05 08:00:00	IWM	ETF	193.29	193.77	192.53	192.53	82748.0
2021-01-05 09:00:00	IWM	ETF	192.57	195.98	192.54	195.08	2578076.0
2021-01-05 10:00:00	IWM	ETF	195.35	196.07	194.73	195.17	3262398.0
2021-01-05 11:00:00	IWM	ETF	195.18	196.17	195.01	195.79	1641084.0
2021-01-05 12:00:00	IWM	ETF	195.79	196.79	195.75	196.78	1876465.0
2021-01-05 13:00:00	IWM	ETF	196.7838	197.24	196.3	197.19	1514013.0
2021-01-05 14:00:00	IWM	ETF	197.19	197.615	196.82	196.85	2091726.0
2021-01-05 15:00:00	IWM	ETF	196.84	197.46	196.35	196.5	4054769.0
2021-01-05 16:00:00	IWM	ETF	196.49	196.78	196.39	196.57	5893647.0
2021-01-05 17:00:00	IWM	ETF	196.82	196.82	196.49	196.7	31114.0
2021-01-05 18:00:00	IWM	ETF	196.7	196.74	196.21	196.34	22612.0
2021-01-05 19:00:00	IWM	ETF	196.52	197.55	196.36	196.77	55604.0
2021-01-05 05:00:00	DIA	ETF	302.73	302.73	302.73	302.73	196.0
2021-01-05 06:00:00	DIA	ETF	302.88	302.93	302.32	302.32	2410.0

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

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