PREVIEW / etf_1hour / 2021-08-31

all etf 1-hour files

  file:    by_date/etf_1hour/2021/2021-08-31.parquet
  size:    418 KB
  rows:    14,494

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-31 04:00:00	SPY	ETF	453.17	453.42	453.13	453.22	19312.0
2021-08-31 05:00:00	SPY	ETF	453.22	453.25	452.92	452.94	9977.0
2021-08-31 06:00:00	SPY	ETF	452.91	453.05	451.88	452.05	58259.0
2021-08-31 07:00:00	SPY	ETF	452.07	452.48	451.87	452.01	165948.0
2021-08-31 08:00:00	SPY	ETF	452.16	453.48	451.28	451.88	254291.0
2021-08-31 09:00:00	SPY	ETF	451.87	452.3	450.92	451.12	4580469.0
2021-08-31 10:00:00	SPY	ETF	451.11	452.12	451.04	452.08	5206231.0
2021-08-31 11:00:00	SPY	ETF	452.08	452.49	451.67	452.33	3340898.0
2021-08-31 12:00:00	SPY	ETF	452.34	452.47	452.13	452.27	1839087.0
2021-08-31 13:00:00	SPY	ETF	452.28	452.29	451.405	451.8599	3020513.0
2021-08-31 14:00:00	SPY	ETF	451.8522	451.905	451.33	451.84	4393368.0
2021-08-31 15:00:00	SPY	ETF	451.83	451.96	451.17	451.61	16141818.0
2021-08-31 16:00:00	SPY	ETF	451.61	452.44	451.55	452.38	5016047.0
2021-08-31 17:00:00	SPY	ETF	452.33	452.39	452.25	452.31	87196.0
2021-08-31 18:00:00	SPY	ETF	452.35	452.44	451.56	452.26	633256.0
2021-08-31 19:00:00	SPY	ETF	452.29	452.47	452.18	452.44	29289.0
2021-08-31 04:00:00	QQQ	ETF	381.22	381.91	381.22	381.6	64222.0
2021-08-31 05:00:00	QQQ	ETF	381.62	381.65	381.08	381.16	45693.0
2021-08-31 06:00:00	QQQ	ETF	381.13	381.23	379.7	379.87	135659.0
2021-08-31 07:00:00	QQQ	ETF	379.92	380.73	379.81	380.29	236167.0
2021-08-31 08:00:00	QQQ	ETF	380.23	382.04	379.45	380.01	427382.0
2021-08-31 09:00:00	QQQ	ETF	380.0	380.7	378.47	378.52	4711504.0
2021-08-31 10:00:00	QQQ	ETF	378.525	379.57	378.36	379.32	3782996.0
2021-08-31 11:00:00	QQQ	ETF	379.33	379.995	378.81	379.85	2183794.0
2021-08-31 12:00:00	QQQ	ETF	379.86	380.2605	379.48	380.2499	1758100.0
2021-08-31 13:00:00	QQQ	ETF	380.25	380.28	379.436	379.98	1777913.0
2021-08-31 14:00:00	QQQ	ETF	379.97	380.36	379.77	380.3	1932921.0
2021-08-31 15:00:00	QQQ	ETF	380.32	380.4	379.5	379.9	5839292.0
2021-08-31 16:00:00	QQQ	ETF	379.91	380.36	379.85	380.3	783239.0
2021-08-31 17:00:00	QQQ	ETF	380.39	380.39	379.95	380.23	96491.0
2021-08-31 18:00:00	QQQ	ETF	380.25	380.36	380.09	380.14	33365.0
2021-08-31 19:00:00	QQQ	ETF	380.06	380.26	380.02	380.25	33135.0
2021-08-31 04:00:00	IWM	ETF	226.14	226.14	225.86	226.05	8263.0
2021-08-31 05:00:00	IWM	ETF	226.06	226.2	226.0	226.0	3942.0
2021-08-31 06:00:00	IWM	ETF	226.09	226.19	225.39	225.67	148133.0
2021-08-31 07:00:00	IWM	ETF	225.59	225.82	225.2	225.3	33727.0
2021-08-31 08:00:00	IWM	ETF	225.41	226.96	224.82	225.23	58390.0
2021-08-31 09:00:00	IWM	ETF	225.27	226.285	224.33	224.67	2913426.0
2021-08-31 10:00:00	IWM	ETF	224.66	225.85	224.58	225.63	2566479.0
2021-08-31 11:00:00	IWM	ETF	225.64	226.09	225.25	225.8521	1398293.0
2021-08-31 12:00:00	IWM	ETF	225.863	226.475	225.77	226.35	893497.0
2021-08-31 13:00:00	IWM	ETF	226.34	226.46	226.01	226.28	1119980.0
2021-08-31 14:00:00	IWM	ETF	226.28	226.609	226.0	226.39	1248207.0
2021-08-31 15:00:00	IWM	ETF	226.4	226.43	225.29	225.92	3250003.0
2021-08-31 16:00:00	IWM	ETF	225.91	226.36	225.86	226.29	1632387.0
2021-08-31 17:00:00	IWM	ETF	226.17	226.33	226.14	226.15	17473.0
2021-08-31 18:00:00	IWM	ETF	226.29	226.44	225.92	226.36	319361.0
2021-08-31 19:00:00	IWM	ETF	226.35	226.55	226.3	226.52	12555.0
2021-08-31 06:00:00	DIA	ETF	354.82	354.82	354.1	354.27	2500.0
2021-08-31 07:00:00	DIA	ETF	354.06	354.18	353.95	353.95	3179.0

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

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