PREVIEW / etf_1hour / 2023-05-24

all etf 1-hour files

  file:    by_date/etf_1hour/2023/2023-05-24.parquet
  size:    474 KB
  rows:    17,425

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-05-24 04:00:00	SPY	ETF	413.85	414.02	412.86	414.0	39423.0
2023-05-24 05:00:00	SPY	ETF	413.91	414.16	413.33	413.36	135518.0
2023-05-24 06:00:00	SPY	ETF	413.34	413.6	412.52	412.9	323914.0
2023-05-24 07:00:00	SPY	ETF	412.89	413.05	412.4	412.46	253309.0
2023-05-24 08:00:00	SPY	ETF	413.02	414.87	412.21	412.29	314432.0
2023-05-24 09:00:00	SPY	ETF	412.28	412.53	410.97	411.135	7036695.0
2023-05-24 10:00:00	SPY	ETF	411.13	411.39	410.3	410.46	10260554.0
2023-05-24 11:00:00	SPY	ETF	410.47	411.93	410.1501	410.43	9800808.0
2023-05-24 12:00:00	SPY	ETF	410.43	410.98	409.8795	410.61	5423858.0
2023-05-24 13:00:00	SPY	ETF	410.61	411.54	409.9901	411.2	5268539.0
2023-05-24 14:00:00	SPY	ETF	411.2	411.57	410.13	410.45	5382889.0
2023-05-24 15:00:00	SPY	ETF	410.46	412.82	410.17	411.09	18868334.0
2023-05-24 16:00:00	SPY	ETF	411.085	413.48	410.8	413.48	5365502.0
2023-05-24 17:00:00	SPY	ETF	413.41	413.8	413.0	413.5	377774.0
2023-05-24 18:00:00	SPY	ETF	413.54	414.07	411.62	412.58	307929.0
2023-05-24 19:00:00	SPY	ETF	412.66	413.1504	412.54	412.9	128368.0
2023-05-24 04:00:00	QQQ	ETF	332.73	333.31	332.6	333.25	50976.0
2023-05-24 05:00:00	QQQ	ETF	333.21	333.46	333.05	333.17	20334.0
2023-05-24 06:00:00	QQQ	ETF	333.15	333.2	332.27	332.48	58044.0
2023-05-24 07:00:00	QQQ	ETF	332.52	332.63	331.85	331.99	248169.0
2023-05-24 08:00:00	QQQ	ETF	332.0899	333.97	331.42	331.47	532722.0
2023-05-24 09:00:00	QQQ	ETF	331.44	332.19	330.86	331.39	6195597.0
2023-05-24 10:00:00	QQQ	ETF	331.4	331.58	329.64	329.885	7360545.0
2023-05-24 11:00:00	QQQ	ETF	329.9	331.21	329.56	330.29	6131037.0
2023-05-24 12:00:00	QQQ	ETF	330.285	330.93	329.78	330.42	2892465.0
2023-05-24 13:00:00	QQQ	ETF	330.42	331.46	329.825	331.2075	4200002.0
2023-05-24 14:00:00	QQQ	ETF	331.22	331.52	330.42	330.67	3977798.0
2023-05-24 15:00:00	QQQ	ETF	330.68	332.905	330.4	331.65	9231108.0
2023-05-24 16:00:00	QQQ	ETF	331.64	336.28	331.34	336.21	4911444.0
2023-05-24 17:00:00	QQQ	ETF	336.2	337.51	331.65	336.94	783718.0
2023-05-24 18:00:00	QQQ	ETF	336.94	337.18	335.35	335.87	327070.0
2023-05-24 19:00:00	QQQ	ETF	336.0	336.6	335.78	336.33	124103.0
2023-05-24 04:00:00	IWM	ETF	176.98	177.04	176.53	176.96	40956.0
2023-05-24 05:00:00	IWM	ETF	177.2	177.3	176.75	176.75	29362.0
2023-05-24 06:00:00	IWM	ETF	176.71	176.85	176.24	176.57	67542.0
2023-05-24 07:00:00	IWM	ETF	176.56	176.8	176.45	176.6	73610.0
2023-05-24 08:00:00	IWM	ETF	176.62	177.77	176.3396	176.45	92399.0
2023-05-24 09:00:00	IWM	ETF	176.5	176.88	175.04	175.145	4052114.0
2023-05-24 10:00:00	IWM	ETF	175.14	175.72	174.86	175.09	3586900.0
2023-05-24 11:00:00	IWM	ETF	175.09	176.01	174.92	175.39	2928940.0
2023-05-24 12:00:00	IWM	ETF	175.38	175.69	174.99	175.22	2181228.0
2023-05-24 13:00:00	IWM	ETF	175.22	175.6	174.67	175.32	2231297.0
2023-05-24 14:00:00	IWM	ETF	175.3	175.52	174.86	175.04	1622909.0
2023-05-24 15:00:00	IWM	ETF	175.05	176.13	174.855	175.55	4773503.0
2023-05-24 16:00:00	IWM	ETF	175.54	176.26	175.07	175.6	1131184.0
2023-05-24 17:00:00	IWM	ETF	175.64	175.74	175.0	175.48	106858.0
2023-05-24 18:00:00	IWM	ETF	175.48	175.63	174.26	174.87	111902.0
2023-05-24 19:00:00	IWM	ETF	174.94	175.32	174.94	175.13	48690.0
2023-05-24 05:00:00	DIA	ETF	330.42	330.58	330.05	330.05	2400.0
2023-05-24 07:00:00	DIA	ETF	329.46	329.55	329.45	329.55	5262.0

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

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