PREVIEW / etf_1hour / 2021-10-18

all etf 1-hour files

  file:    by_date/etf_1hour/2021/2021-10-18.parquet
  size:    427 KB
  rows:    15,051

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-10-18 04:00:00	SPY	ETF	445.1	445.62	444.35	444.41	80675.0
2021-10-18 05:00:00	SPY	ETF	444.37	444.57	444.08	444.19	21595.0
2021-10-18 06:00:00	SPY	ETF	444.19	444.42	443.7	444.24	49271.0
2021-10-18 07:00:00	SPY	ETF	444.16	445.04	444.16	444.51	298954.0
2021-10-18 08:00:00	SPY	ETF	443.9596	446.204	443.25	443.55	516639.0
2021-10-18 09:00:00	SPY	ETF	443.58	445.49	443.27	445.29	6937674.0
2021-10-18 10:00:00	SPY	ETF	445.3	446.05	445.1	445.83	5361892.0
2021-10-18 11:00:00	SPY	ETF	445.82	446.99	445.79	446.7941	4640630.0
2021-10-18 12:00:00	SPY	ETF	446.7899	447.02	446.42	446.57	2464021.0
2021-10-18 13:00:00	SPY	ETF	446.58	446.9299	446.52	446.69	1938414.0
2021-10-18 14:00:00	SPY	ETF	446.69	447.09	446.45	446.94	3779427.0
2021-10-18 15:00:00	SPY	ETF	446.94	447.55	446.78	447.2225	13529326.0
2021-10-18 16:00:00	SPY	ETF	447.23	447.28	447.05	447.12	3392104.0
2021-10-18 17:00:00	SPY	ETF	447.2	447.3	447.17	447.21	279241.0
2021-10-18 18:00:00	SPY	ETF	447.19	447.22	446.79	446.8	71480.0
2021-10-18 19:00:00	SPY	ETF	446.88	447.37	446.8	447.29	60319.0
2021-10-18 04:00:00	QQQ	ETF	368.23	368.23	367.08	367.61	64846.0
2021-10-18 05:00:00	QQQ	ETF	367.58	367.79	367.25	367.44	89229.0
2021-10-18 06:00:00	QQQ	ETF	367.38	367.53	366.85	367.4	46543.0
2021-10-18 07:00:00	QQQ	ETF	367.39	368.63	367.39	368.13	145373.0
2021-10-18 08:00:00	QQQ	ETF	367.8201	369.216	366.9301	367.31	409729.0
2021-10-18 09:00:00	QQQ	ETF	367.34	369.32	366.99	369.08	3916066.0
2021-10-18 10:00:00	QQQ	ETF	369.08	369.905	368.79	369.81	3550622.0
2021-10-18 11:00:00	QQQ	ETF	369.8195	371.02	369.8195	370.7599	3433962.0
2021-10-18 12:00:00	QQQ	ETF	370.77	371.19	370.66	371.06	1907907.0
2021-10-18 13:00:00	QQQ	ETF	371.07	371.83	370.98	371.73	2084050.0
2021-10-18 14:00:00	QQQ	ETF	371.72	372.33	371.56	372.185	2318247.0
2021-10-18 15:00:00	QQQ	ETF	372.18	372.87	372.08	372.65	6164763.0
2021-10-18 16:00:00	QQQ	ETF	372.66	372.92	371.9	372.71	1963547.0
2021-10-18 17:00:00	QQQ	ETF	372.64	372.78	372.64	372.73	358450.0
2021-10-18 18:00:00	QQQ	ETF	372.75	372.78	372.309	372.35	114011.0
2021-10-18 19:00:00	QQQ	ETF	372.37	372.84	372.37	372.78	74606.0
2021-10-18 04:00:00	IWM	ETF	224.0	224.31	223.82	223.86	13593.0
2021-10-18 05:00:00	IWM	ETF	223.81	223.92	223.58	223.77	20738.0
2021-10-18 06:00:00	IWM	ETF	223.74	224.04	223.53	223.88	21088.0
2021-10-18 07:00:00	IWM	ETF	223.79	224.25	223.77	223.96	113735.0
2021-10-18 08:00:00	IWM	ETF	223.8496	224.74	223.41	223.56	165571.0
2021-10-18 09:00:00	IWM	ETF	223.56	224.87	223.52	224.36	2717220.0
2021-10-18 10:00:00	IWM	ETF	224.38	225.075	224.2651	224.76	2482935.0
2021-10-18 11:00:00	IWM	ETF	224.76	225.48	224.51	225.45	1766629.0
2021-10-18 12:00:00	IWM	ETF	225.45	225.675	224.99	225.14	1070150.0
2021-10-18 13:00:00	IWM	ETF	225.15	225.59	225.1	225.155	1214792.0
2021-10-18 14:00:00	IWM	ETF	225.15	225.34	224.75	224.97	1734257.0
2021-10-18 15:00:00	IWM	ETF	224.99	225.275	224.85	225.07	2826534.0
2021-10-18 16:00:00	IWM	ETF	225.07	225.09	224.73	224.84	732514.0
2021-10-18 17:00:00	IWM	ETF	224.92	225.03	224.8	225.0	29337.0
2021-10-18 18:00:00	IWM	ETF	224.94	225.03	224.62	224.62	34400.0
2021-10-18 19:00:00	IWM	ETF	224.72	225.06	224.55	224.98	30719.0
2021-10-18 04:00:00	DIA	ETF	352.08	352.4	351.94	351.94	4300.0
2021-10-18 05:00:00	DIA	ETF	351.92	351.92	351.66	351.66	783.0

> showing 50 of 15,051 rows — these rows as CSV

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