PREVIEW / etf_1hour / 2023-06-13

all etf 1-hour files

  file:    by_date/etf_1hour/2023/2023-06-13.parquet
  size:    490 KB
  rows:    17,810

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
2023-06-13 04:00:00	SPY	ETF	434.74	435.09	434.63	434.96	57635.0
2023-06-13 05:00:00	SPY	ETF	434.98	435.13	434.57	434.57	23050.0
2023-06-13 06:00:00	SPY	ETF	434.56	434.61	434.05	434.29	29344.0
2023-06-13 07:00:00	SPY	ETF	434.29	434.44	433.93	434.02	224658.0
2023-06-13 08:00:00	SPY	ETF	434.169	436.14	433.0	436.13	1626623.0
2023-06-13 09:00:00	SPY	ETF	436.12	437.18	435.09	435.72	9272772.0
2023-06-13 10:00:00	SPY	ETF	435.73	436.395	434.63	436.0	9586717.0
2023-06-13 11:00:00	SPY	ETF	436.005	437.27	435.69	436.03	9178446.0
2023-06-13 12:00:00	SPY	ETF	436.035	437.0	435.72	436.9901	6634159.0
2023-06-13 13:00:00	SPY	ETF	436.995	437.33	436.43	436.845	6313153.0
2023-06-13 14:00:00	SPY	ETF	436.845	436.96	435.355	436.06	8616066.0
2023-06-13 15:00:00	SPY	ETF	436.06	436.785	436.06	436.66	12554354.0
2023-06-13 16:00:00	SPY	ETF	436.65	437.05	433.6544	436.81	3592034.0
2023-06-13 17:00:00	SPY	ETF	436.81	437.08	436.8	436.82	193520.0
2023-06-13 18:00:00	SPY	ETF	436.8	437.0	436.55	436.96	249228.0
2023-06-13 19:00:00	SPY	ETF	436.94	437.0	436.69	436.77	50053.0
2023-06-13 04:00:00	QQQ	ETF	362.46	362.89	362.31	362.7	99909.0
2023-06-13 05:00:00	QQQ	ETF	362.65	362.71	361.86	362.05	36025.0
2023-06-13 06:00:00	QQQ	ETF	362.03	362.22	361.46	361.54	161981.0
2023-06-13 07:00:00	QQQ	ETF	361.55	361.98	361.07	361.25	290601.0
2023-06-13 08:00:00	QQQ	ETF	361.5617	363.65	360.0	363.63	1831561.0
2023-06-13 09:00:00	QQQ	ETF	363.65	364.6	361.24	361.49	8176194.0
2023-06-13 10:00:00	QQQ	ETF	361.515	362.3	360.03	362.09	6763834.0
2023-06-13 11:00:00	QQQ	ETF	362.1	363.64	361.68	362.23	4624917.0
2023-06-13 12:00:00	QQQ	ETF	362.25	363.4	361.84	363.3986	3245419.0
2023-06-13 13:00:00	QQQ	ETF	363.4	363.71	362.46	363.09	3916090.0
2023-06-13 14:00:00	QQQ	ETF	363.095	363.24	361.26	362.53	4878604.0
2023-06-13 15:00:00	QQQ	ETF	362.53	363.41	362.4	363.26	6624101.0
2023-06-13 16:00:00	QQQ	ETF	363.26	363.63	363.1	363.55	2065954.0
2023-06-13 17:00:00	QQQ	ETF	363.56	363.84	363.5	363.76	69028.0
2023-06-13 18:00:00	QQQ	ETF	363.73	363.78	363.46	363.75	61469.0
2023-06-13 19:00:00	QQQ	ETF	363.75	363.77	363.4	363.53	64774.0
2023-06-13 04:00:00	IWM	ETF	186.29	186.43	186.11	186.17	35293.0
2023-06-13 05:00:00	IWM	ETF	186.22	186.4	185.96	185.96	12083.0
2023-06-13 06:00:00	IWM	ETF	185.92	185.98	185.71	185.95	16971.0
2023-06-13 07:00:00	IWM	ETF	185.94	186.07	185.73	185.91	77891.0
2023-06-13 08:00:00	IWM	ETF	185.9484	187.0	185.73	186.89	580089.0
2023-06-13 09:00:00	IWM	ETF	186.91	188.235	186.27	187.51	5559381.0
2023-06-13 10:00:00	IWM	ETF	187.5	188.98	187.39	187.93	4399035.0
2023-06-13 11:00:00	IWM	ETF	187.93	188.18	187.49	187.55	3082744.0
2023-06-13 12:00:00	IWM	ETF	187.55	188.33	187.37	188.25	2045897.0
2023-06-13 13:00:00	IWM	ETF	188.24	188.385	187.99	188.205	1895753.0
2023-06-13 14:00:00	IWM	ETF	188.205	188.355	187.41	188.03	2933080.0
2023-06-13 15:00:00	IWM	ETF	188.03	188.42	187.835	187.94	6695363.0
2023-06-13 16:00:00	IWM	ETF	187.93	188.32	187.86	188.23	1284064.0
2023-06-13 17:00:00	IWM	ETF	188.22	188.3	188.16	188.29	8952.0
2023-06-13 18:00:00	IWM	ETF	188.3	188.31	188.07	188.31	18626.0
2023-06-13 19:00:00	IWM	ETF	188.32	188.34	188.14	188.16	10814.0
2023-06-13 04:00:00	DIA	ETF	341.47	341.47	341.47	341.47	118.0
2023-06-13 06:00:00	DIA	ETF	341.19	341.31	341.19	341.28	1400.0

> showing 50 of 17,810 rows — these rows as CSV

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