PREVIEW / etf_1hour / 2024-01-23

all etf 1-hour files

  file:    by_date/etf_1hour/2024/2024-01-23.parquet
  size:    538 KB
  rows:    19,674

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
2024-01-23 04:00:00	SPY	ETF	483.35	483.76	483.35	483.67	7126.0
2024-01-23 05:00:00	SPY	ETF	483.64	483.64	483.32	483.53	6124.0
2024-01-23 06:00:00	SPY	ETF	483.51	483.72	483.43	483.72	15407.0
2024-01-23 07:00:00	SPY	ETF	483.69	483.94	483.65	483.93	88267.0
2024-01-23 08:00:00	SPY	ETF	483.84	484.62	483.29	484.27	206962.0
2024-01-23 09:00:00	SPY	ETF	484.27	484.3737	483.54	483.96	3616039.0
2024-01-23 10:00:00	SPY	ETF	483.95	484.23	483.06	483.265	6089917.0
2024-01-23 11:00:00	SPY	ETF	483.27	483.69	482.89	483.505	4637318.0
2024-01-23 12:00:00	SPY	ETF	483.5	483.98	483.0779	483.91	2788816.0
2024-01-23 13:00:00	SPY	ETF	483.91	484.03	483.5613	483.97	3359023.0
2024-01-23 14:00:00	SPY	ETF	483.9701	484.48	483.625	484.33	3509448.0
2024-01-23 15:00:00	SPY	ETF	484.33	485.105	484.19	484.88	10140143.0
2024-01-23 16:00:00	SPY	ETF	484.88	485.58	483.083	485.51	3146873.0
2024-01-23 17:00:00	SPY	ETF	485.47	485.55	485.29	485.45	116135.0
2024-01-23 18:00:00	SPY	ETF	485.47	485.92	485.47	485.9	154324.0
2024-01-23 19:00:00	SPY	ETF	485.84	485.99	485.75	485.97	38917.0
2024-01-23 04:00:00	QQQ	ETF	421.68	421.93	421.25	421.89	48381.0
2024-01-23 05:00:00	QQQ	ETF	421.84	421.84	421.24	421.47	30368.0
2024-01-23 06:00:00	QQQ	ETF	421.5	422.21	421.5	422.11	52930.0
2024-01-23 07:00:00	QQQ	ETF	422.13	422.46	421.93	422.32	71247.0
2024-01-23 08:00:00	QQQ	ETF	422.37	423.35	420.97	422.74	245652.0
2024-01-23 09:00:00	QQQ	ETF	422.72	422.77	420.57	422.125	4119477.0
2024-01-23 10:00:00	QQQ	ETF	422.12	422.37	421.0	421.615	4298914.0
2024-01-23 11:00:00	QQQ	ETF	421.63	422.255	421.03	421.97	2741365.0
2024-01-23 12:00:00	QQQ	ETF	421.9545	422.6	421.35	422.505	1708587.0
2024-01-23 13:00:00	QQQ	ETF	422.51	422.5701	421.795	422.3204	2336022.0
2024-01-23 14:00:00	QQQ	ETF	422.315	422.77	421.902	422.62	1952401.0
2024-01-23 15:00:00	QQQ	ETF	422.62	423.65	422.51	423.41	4994573.0
2024-01-23 16:00:00	QQQ	ETF	423.43	424.14	422.2251	424.0	1494725.0
2024-01-23 17:00:00	QQQ	ETF	424.0	424.16	423.881	424.1	59324.0
2024-01-23 18:00:00	QQQ	ETF	424.07	424.6	424.07	424.56	71381.0
2024-01-23 19:00:00	QQQ	ETF	424.56	424.83	424.43	424.81	82904.0
2024-01-23 04:00:00	IWM	ETF	196.98	198.32	196.98	198.16	84253.0
2024-01-23 05:00:00	IWM	ETF	198.06	198.4	197.92	198.37	52602.0
2024-01-23 06:00:00	IWM	ETF	198.35	198.35	197.92	198.15	55567.0
2024-01-23 07:00:00	IWM	ETF	198.15	198.26	197.73	198.08	217356.0
2024-01-23 08:00:00	IWM	ETF	198.3	198.3	196.99	198.15	325063.0
2024-01-23 09:00:00	IWM	ETF	198.06	198.59	197.25	197.64	5883154.0
2024-01-23 10:00:00	IWM	ETF	197.63	198.11	195.61	195.73	5994614.0
2024-01-23 11:00:00	IWM	ETF	195.74	196.3599	194.98	195.61	3945744.0
2024-01-23 12:00:00	IWM	ETF	195.61	195.73	195.0596	195.455	2457577.0
2024-01-23 13:00:00	IWM	ETF	195.46	196.11	195.21	195.9	2170755.0
2024-01-23 14:00:00	IWM	ETF	195.89	196.45	195.77	196.34	2137574.0
2024-01-23 15:00:00	IWM	ETF	196.34	196.76	195.81	195.92	5727706.0
2024-01-23 16:00:00	IWM	ETF	195.97	196.025	195.7	195.9	2514632.0
2024-01-23 17:00:00	IWM	ETF	195.89	196.0	195.84	196.0	18087.0
2024-01-23 18:00:00	IWM	ETF	196.0	196.29	195.92	196.21	38816.0
2024-01-23 19:00:00	IWM	ETF	196.18	196.3	195.98	196.3	84412.0
2024-01-23 05:00:00	DIA	ETF	379.94	379.94	379.82	379.82	300.0
2024-01-23 06:00:00	DIA	ETF	379.97	379.97	379.32	379.33	2800.0

> showing 50 of 19,674 rows — these rows as CSV

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