PREVIEW / etf_1hour / 2022-09-12

all etf 1-hour files

  file:    by_date/etf_1hour/2022/2022-09-12.parquet
  size:    448 KB
  rows:    16,314

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
2022-09-12 04:00:00	SPY	ETF	406.74	409.24	406.74	409.24	38820.0
2022-09-12 05:00:00	SPY	ETF	409.25	409.53	408.72	408.75	34678.0
2022-09-12 06:00:00	SPY	ETF	408.64	408.77	408.3	408.45	32926.0
2022-09-12 07:00:00	SPY	ETF	408.37	409.01	408.13	408.9	218094.0
2022-09-12 08:00:00	SPY	ETF	408.4097	409.3296	406.7	408.42	287960.0
2022-09-12 09:00:00	SPY	ETF	408.44	411.03	408.07	411.01	7215687.0
2022-09-12 10:00:00	SPY	ETF	411.02	411.73	410.3	410.51	9039602.0
2022-09-12 11:00:00	SPY	ETF	410.52	411.23	408.63	409.2083	6807427.0
2022-09-12 12:00:00	SPY	ETF	409.22	410.28	408.47	410.25	5930092.0
2022-09-12 13:00:00	SPY	ETF	410.26	411.08	409.51	410.92	4428423.0
2022-09-12 14:00:00	SPY	ETF	410.91	410.98	409.46	410.29	4657394.0
2022-09-12 15:00:00	SPY	ETF	410.28	411.05	409.79	410.95	9960897.0
2022-09-12 16:00:00	SPY	ETF	410.93	411.67	410.82	411.62	3608004.0
2022-09-12 17:00:00	SPY	ETF	411.63	411.67	410.97	411.65	182316.0
2022-09-12 18:00:00	SPY	ETF	411.67	411.94	411.24	411.37	103037.0
2022-09-12 19:00:00	SPY	ETF	411.38	411.6	411.29	411.38	55792.0
2022-09-12 04:00:00	QQQ	ETF	308.02	309.41	307.82	309.3	133776.0
2022-09-12 05:00:00	QQQ	ETF	309.35	309.64	308.85	308.95	35111.0
2022-09-12 06:00:00	QQQ	ETF	308.87	308.9	308.43	308.63	43921.0
2022-09-12 07:00:00	QQQ	ETF	308.52	309.24	308.29	309.09	152597.0
2022-09-12 08:00:00	QQQ	ETF	309.11	309.3001	307.25	308.35	556807.0
2022-09-12 09:00:00	QQQ	ETF	308.33	310.62	308.02	310.6	4636674.0
2022-09-12 10:00:00	QQQ	ETF	310.62	311.08	309.57	309.76	6279629.0
2022-09-12 11:00:00	QQQ	ETF	309.76	310.65	308.31	308.7702	5001357.0
2022-09-12 12:00:00	QQQ	ETF	308.775	310.11	308.18	310.01	3209413.0
2022-09-12 13:00:00	QQQ	ETF	310.0343	310.76	309.38	310.62	2464549.0
2022-09-12 14:00:00	QQQ	ETF	310.63	310.68	309.25	309.99	2682633.0
2022-09-12 15:00:00	QQQ	ETF	310.0	310.79	309.73	310.76	4383046.0
2022-09-12 16:00:00	QQQ	ETF	310.75	311.5	310.5	311.44	1943140.0
2022-09-12 17:00:00	QQQ	ETF	311.45	311.49	310.74	311.44	41593.0
2022-09-12 18:00:00	QQQ	ETF	311.44	311.58	311.03	311.24	117967.0
2022-09-12 19:00:00	QQQ	ETF	311.25	311.43	311.13	311.25	178872.0
2022-09-12 04:00:00	IWM	ETF	188.02	188.59	187.87	188.55	28264.0
2022-09-12 05:00:00	IWM	ETF	188.58	188.77	188.38	188.38	22268.0
2022-09-12 06:00:00	IWM	ETF	188.23	188.36	188.15	188.23	8709.0
2022-09-12 07:00:00	IWM	ETF	188.08	188.48	188.06	188.41	37128.0
2022-09-12 08:00:00	IWM	ETF	188.32	188.44	187.4	188.27	55078.0
2022-09-12 09:00:00	IWM	ETF	188.23	189.79	188.14	189.78	2771076.0
2022-09-12 10:00:00	IWM	ETF	189.78	189.86	188.74	188.85	2612608.0
2022-09-12 11:00:00	IWM	ETF	188.85	189.17	187.97	188.27	1863044.0
2022-09-12 12:00:00	IWM	ETF	188.275	189.03	188.05	189.02	1533101.0
2022-09-12 13:00:00	IWM	ETF	189.01	189.2661	188.63	189.235	1250302.0
2022-09-12 14:00:00	IWM	ETF	189.23	189.38	188.73	189.24	1743157.0
2022-09-12 15:00:00	IWM	ETF	189.25	189.74	189.12	189.72	3225461.0
2022-09-12 16:00:00	IWM	ETF	189.67	190.12	189.5331	190.05	1000350.0
2022-09-12 17:00:00	IWM	ETF	189.67	190.12	189.67	190.07	29071.0
2022-09-12 18:00:00	IWM	ETF	190.07	190.19	189.83	189.9	23458.0
2022-09-12 19:00:00	IWM	ETF	189.85	190.02	189.83	189.95	18089.0
2022-09-12 04:00:00	DIA	ETF	323.24	323.84	323.0	323.84	1314.0
2022-09-12 05:00:00	DIA	ETF	324.03	324.05	323.81	323.81	2641.0

> showing 50 of 16,314 rows — these rows as CSV

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