PREVIEW / etf_1hour / 2023-08-17

all etf 1-hour files

  file:    by_date/etf_1hour/2023/2023-08-17.parquet
  size:    485 KB
  rows:    17,631

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-08-17 04:00:00	SPY	ETF	440.16	440.85	440.16	440.44	20365.0
2023-08-17 05:00:00	SPY	ETF	440.45	440.8	440.24	440.77	29392.0
2023-08-17 06:00:00	SPY	ETF	440.75	440.96	440.38	440.61	49707.0
2023-08-17 07:00:00	SPY	ETF	440.54	440.99	440.45	440.96	475007.0
2023-08-17 08:00:00	SPY	ETF	440.8112	441.5	439.48	441.4	615741.0
2023-08-17 09:00:00	SPY	ETF	441.42	441.43	439.8	440.3803	6330897.0
2023-08-17 10:00:00	SPY	ETF	440.4	440.74	439.39	439.9699	7972692.0
2023-08-17 11:00:00	SPY	ETF	439.97	440.075	438.97	439.571	7266257.0
2023-08-17 12:00:00	SPY	ETF	439.58	440.6	438.98	440.495	4928866.0
2023-08-17 13:00:00	SPY	ETF	440.495	440.61	438.5099	438.82	5827316.0
2023-08-17 14:00:00	SPY	ETF	438.825	438.885	436.99	437.2	7825851.0
2023-08-17 15:00:00	SPY	ETF	437.185	437.44	435.75	436.26	19190722.0
2023-08-17 16:00:00	SPY	ETF	436.25	437.05	435.72	435.8	5326996.0
2023-08-17 17:00:00	SPY	ETF	435.8	435.93	435.75	435.83	99642.0
2023-08-17 18:00:00	SPY	ETF	435.88	436.19	435.54	435.769	128525.0
2023-08-17 19:00:00	SPY	ETF	435.8	436.34	435.8	436.06	76355.0
2023-08-17 04:00:00	QQQ	ETF	362.94	363.6	362.83	363.2	44878.0
2023-08-17 05:00:00	QQQ	ETF	363.2	363.58	363.14	363.52	30597.0
2023-08-17 06:00:00	QQQ	ETF	363.54	363.73	363.03	363.16	72564.0
2023-08-17 07:00:00	QQQ	ETF	363.18	363.77	363.0	363.73	308620.0
2023-08-17 08:00:00	QQQ	ETF	363.3601	364.52	362.12	364.36	528856.0
2023-08-17 09:00:00	QQQ	ETF	364.32	364.45	361.87	362.3899	5995397.0
2023-08-17 10:00:00	QQQ	ETF	362.385	362.739	360.65	361.44	7686905.0
2023-08-17 11:00:00	QQQ	ETF	361.46	361.875	360.69	361.81	5343469.0
2023-08-17 12:00:00	QQQ	ETF	361.82	362.97	361.09	362.96	4882141.0
2023-08-17 13:00:00	QQQ	ETF	362.96	363.0686	360.74	361.16	4921998.0
2023-08-17 14:00:00	QQQ	ETF	361.18	361.27	359.27	359.56	5646513.0
2023-08-17 15:00:00	QQQ	ETF	359.57	359.82	358.16	358.59	11665414.0
2023-08-17 16:00:00	QQQ	ETF	358.59	359.365	357.79	357.9	1393529.0
2023-08-17 17:00:00	QQQ	ETF	357.9	358.2	357.65	357.86	148079.0
2023-08-17 18:00:00	QQQ	ETF	357.9	358.24	357.62	357.91	117009.0
2023-08-17 19:00:00	QQQ	ETF	357.98	358.38	357.98	358.16	73785.0
2023-08-17 04:00:00	IWM	ETF	185.94	186.29	185.93	186.07	13639.0
2023-08-17 05:00:00	IWM	ETF	186.05	186.13	185.8	186.1	7737.0
2023-08-17 06:00:00	IWM	ETF	186.25	186.44	186.15	186.44	15199.0
2023-08-17 07:00:00	IWM	ETF	186.38	186.88	186.31	186.81	169298.0
2023-08-17 08:00:00	IWM	ETF	186.6001	186.98	185.77	186.79	88413.0
2023-08-17 09:00:00	IWM	ETF	186.81	186.81	185.41	185.63	3288671.0
2023-08-17 10:00:00	IWM	ETF	185.62	186.17	185.13	185.38	2765239.0
2023-08-17 11:00:00	IWM	ETF	185.385	185.51	184.8	185.03	2308289.0
2023-08-17 12:00:00	IWM	ETF	185.03	185.59	184.89	185.54	1922171.0
2023-08-17 13:00:00	IWM	ETF	185.55	185.58	184.66	184.78	1467925.0
2023-08-17 14:00:00	IWM	ETF	184.79	184.805	183.87	183.95	2303601.0
2023-08-17 15:00:00	IWM	ETF	183.94	184.15	183.63	183.69	5727461.0
2023-08-17 16:00:00	IWM	ETF	183.65	183.82	183.4	183.57	920394.0
2023-08-17 17:00:00	IWM	ETF	183.6	183.6	183.4	183.4	18704.0
2023-08-17 18:00:00	IWM	ETF	183.54	183.75	183.32	183.55	43196.0
2023-08-17 19:00:00	IWM	ETF	183.6	183.85	183.6	183.75	41558.0
2023-08-17 04:00:00	DIA	ETF	348.7	348.77	348.45	348.48	1880.0
2023-08-17 05:00:00	DIA	ETF	348.57	348.71	348.31	348.7	2990.0

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

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