PREVIEW / etf_1hour / 2021-09-03

all etf 1-hour files

  file:    by_date/etf_1hour/2021/2021-09-03.parquet
  size:    405 KB
  rows:    14,104

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-09-03 04:00:00	SPY	ETF	453.91	454.05	453.91	453.99	10724.0
2021-09-03 05:00:00	SPY	ETF	453.85	453.93	453.78	453.78	3604.0
2021-09-03 06:00:00	SPY	ETF	453.88	454.08	453.81	454.0	16521.0
2021-09-03 07:00:00	SPY	ETF	453.93	454.01	453.71	453.76	66813.0
2021-09-03 08:00:00	SPY	ETF	453.77	454.53	452.52	453.46	927242.0
2021-09-03 09:00:00	SPY	ETF	453.44	453.7	451.55	452.43	5831072.0
2021-09-03 10:00:00	SPY	ETF	452.44	452.9979	452.13	452.5431	5744766.0
2021-09-03 11:00:00	SPY	ETF	452.54	453.05	452.39	452.59	3245628.0
2021-09-03 12:00:00	SPY	ETF	452.59	452.89	452.485	452.72	2345981.0
2021-09-03 13:00:00	SPY	ETF	452.71	453.47	452.71	453.41	3319672.0
2021-09-03 14:00:00	SPY	ETF	453.405	453.47	453.21	453.37	2408021.0
2021-09-03 15:00:00	SPY	ETF	453.37	453.63	452.85	453.06	8786326.0
2021-09-03 16:00:00	SPY	ETF	453.06	453.08	452.9	452.99	2080064.0
2021-09-03 17:00:00	SPY	ETF	452.99	453.22	452.94	453.08	154611.0
2021-09-03 18:00:00	SPY	ETF	453.17	453.2	452.6	452.7	33562.0
2021-09-03 19:00:00	SPY	ETF	452.7	452.77	452.55	452.75	20016.0
2021-09-03 04:00:00	QQQ	ETF	380.87	381.02	380.63	380.63	73399.0
2021-09-03 05:00:00	QQQ	ETF	380.67	380.72	380.59	380.66	17674.0
2021-09-03 06:00:00	QQQ	ETF	380.65	380.83	380.65	380.72	16011.0
2021-09-03 07:00:00	QQQ	ETF	380.71	381.02	380.71	380.82	34418.0
2021-09-03 08:00:00	QQQ	ETF	380.86	382.19	379.53	380.49	1069096.0
2021-09-03 09:00:00	QQQ	ETF	380.43	381.36	379.14	381.29	4668818.0
2021-09-03 10:00:00	QQQ	ETF	381.28	381.95	380.4	380.93	3447433.0
2021-09-03 11:00:00	QQQ	ETF	380.9	381.6399	380.632	381.0892	1745688.0
2021-09-03 12:00:00	QQQ	ETF	381.07	381.62	380.98	381.415	1211202.0
2021-09-03 13:00:00	QQQ	ETF	381.41	381.96	381.4	381.67	1148582.0
2021-09-03 14:00:00	QQQ	ETF	381.68	381.72	381.38	381.61	1042184.0
2021-09-03 15:00:00	QQQ	ETF	381.61	381.98	381.275	381.59	3116837.0
2021-09-03 16:00:00	QQQ	ETF	381.59	381.65	381.42	381.64	762449.0
2021-09-03 17:00:00	QQQ	ETF	381.64	381.64	381.48	381.48	43783.0
2021-09-03 18:00:00	QQQ	ETF	381.48	381.49	381.31	381.31	11333.0
2021-09-03 19:00:00	QQQ	ETF	381.45	381.47	381.32	381.4	8302.0
2021-09-03 04:00:00	IWM	ETF	229.7	230.0	229.7	229.84	13942.0
2021-09-03 05:00:00	IWM	ETF	229.8	229.89	229.66	229.69	6485.0
2021-09-03 06:00:00	IWM	ETF	229.73	229.86	229.65	229.75	15264.0
2021-09-03 07:00:00	IWM	ETF	229.7	229.76	229.52	229.64	41700.0
2021-09-03 08:00:00	IWM	ETF	229.68	229.95	228.5	229.0	611860.0
2021-09-03 09:00:00	IWM	ETF	229.12	229.31	227.89	228.505	2812420.0
2021-09-03 10:00:00	IWM	ETF	228.51	228.97	227.64	228.11	2920018.0
2021-09-03 11:00:00	IWM	ETF	228.09	228.26	227.19	227.56	1780251.0
2021-09-03 12:00:00	IWM	ETF	227.56	227.72	227.26	227.68	1223776.0
2021-09-03 13:00:00	IWM	ETF	227.67	228.16	227.6	227.98	1109108.0
2021-09-03 14:00:00	IWM	ETF	227.98	227.98	227.44	227.8	1141832.0
2021-09-03 15:00:00	IWM	ETF	227.81	228.11	227.69	227.97	1947421.0
2021-09-03 16:00:00	IWM	ETF	227.96	227.99	227.66	227.74	612773.0
2021-09-03 17:00:00	IWM	ETF	227.96	227.96	227.72	227.8	89849.0
2021-09-03 18:00:00	IWM	ETF	227.79	227.96	227.4	227.55	16145.0
2021-09-03 19:00:00	IWM	ETF	227.55	227.56	227.0	227.24	8608.0
2021-09-03 04:00:00	DIA	ETF	355.35	355.37	355.35	355.37	873.0
2021-09-03 06:00:00	DIA	ETF	355.28	355.28	355.28	355.28	100.0

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

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