PREVIEW / etf_1hour / 2024-04-04

all etf 1-hour files

  file:    by_date/etf_1hour/2024/2024-04-04.parquet
  size:    539 KB
  rows:    20,070

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-04-04 04:00:00	SPY	ETF	520.61	521.54	520.61	521.26	60571.0
2024-04-04 05:00:00	SPY	ETF	521.24	521.43	521.05	521.35	12784.0
2024-04-04 06:00:00	SPY	ETF	521.32	521.61	521.13	521.56	18210.0
2024-04-04 07:00:00	SPY	ETF	521.62	521.64	520.8	521.39	125618.0
2024-04-04 08:00:00	SPY	ETF	521.6208	523.1	519.41	522.98	578740.0
2024-04-04 09:00:00	SPY	ETF	523.01	523.7	522.58	522.84	6140274.0
2024-04-04 10:00:00	SPY	ETF	522.84	523.04	522.47	522.73	3893763.0
2024-04-04 11:00:00	SPY	ETF	522.73	523.31	522.36	523.26	3349252.0
2024-04-04 12:00:00	SPY	ETF	523.27	523.8674	523.18	523.44	3587584.0
2024-04-04 13:00:00	SPY	ETF	523.44	523.47	521.71	521.86	3879730.0
2024-04-04 14:00:00	SPY	ETF	521.865	521.865	515.5	515.891	21835249.0
2024-04-04 15:00:00	SPY	ETF	515.89	516.06	512.755	513.03	27649047.0
2024-04-04 16:00:00	SPY	ETF	513.03	519.8062	512.56	513.04	3427570.0
2024-04-04 17:00:00	SPY	ETF	513.05	513.39	513.05	513.3	143145.0
2024-04-04 18:00:00	SPY	ETF	513.35	514.02	513.12	513.43	149596.0
2024-04-04 19:00:00	SPY	ETF	513.36	513.79	513.32	513.38	42575.0
2024-04-04 04:00:00	QQQ	ETF	443.95	444.44	443.86	444.07	37056.0
2024-04-04 05:00:00	QQQ	ETF	444.07	444.35	443.93	444.34	10684.0
2024-04-04 06:00:00	QQQ	ETF	444.21	444.47	443.92	444.45	12658.0
2024-04-04 07:00:00	QQQ	ETF	444.46	444.48	444.09	444.28	38629.0
2024-04-04 08:00:00	QQQ	ETF	444.35	446.32	441.769	446.2	349421.0
2024-04-04 09:00:00	QQQ	ETF	446.25	446.95	445.4906	445.77	5038983.0
2024-04-04 10:00:00	QQQ	ETF	445.77	446.08	445.03	445.39	3075311.0
2024-04-04 11:00:00	QQQ	ETF	445.39	446.2	444.91	446.2	2315548.0
2024-04-04 12:00:00	QQQ	ETF	446.2	446.929	446.115	446.705	2904649.0
2024-04-04 13:00:00	QQQ	ETF	446.69	446.735	445.07	445.31	2546635.0
2024-04-04 14:00:00	QQQ	ETF	445.32	445.32	438.44	438.88	11518646.0
2024-04-04 15:00:00	QQQ	ETF	438.84	438.84	435.11	435.24	14629470.0
2024-04-04 16:00:00	QQQ	ETF	435.245	443.5676	434.799	435.22	2411973.0
2024-04-04 17:00:00	QQQ	ETF	435.25	435.8891	435.22	435.77	132624.0
2024-04-04 18:00:00	QQQ	ETF	435.71	436.3	435.33	435.71	196150.0
2024-04-04 19:00:00	QQQ	ETF	435.7	436.01	435.4901	435.7	64818.0
2024-04-04 04:00:00	IWM	ETF	206.57	207.09	206.52	206.73	19634.0
2024-04-04 05:00:00	IWM	ETF	206.65	206.77	206.59	206.69	7457.0
2024-04-04 06:00:00	IWM	ETF	206.66	206.89	206.59	206.89	5015.0
2024-04-04 07:00:00	IWM	ETF	206.87	206.91	206.49	206.54	31201.0
2024-04-04 08:00:00	IWM	ETF	206.83	207.66	206.18	207.54	223484.0
2024-04-04 09:00:00	IWM	ETF	207.52	208.55	207.41	207.85	2802538.0
2024-04-04 10:00:00	IWM	ETF	207.85	208.225	207.46	208.1241	2142152.0
2024-04-04 11:00:00	IWM	ETF	208.13	208.16	207.51	207.985	1538637.0
2024-04-04 12:00:00	IWM	ETF	207.99	208.17	207.86	207.9	1184268.0
2024-04-04 13:00:00	IWM	ETF	207.91	207.91	207.14	207.1617	1542901.0
2024-04-04 14:00:00	IWM	ETF	207.16	207.21	204.2601	204.475	4860659.0
2024-04-04 15:00:00	IWM	ETF	204.44	204.568	203.21	203.71	7700533.0
2024-04-04 16:00:00	IWM	ETF	203.77	204.12	203.62	203.79	2432321.0
2024-04-04 17:00:00	IWM	ETF	203.78	203.96	203.78	203.84	24377.0
2024-04-04 18:00:00	IWM	ETF	203.96	204.28	203.82	204.04	46011.0
2024-04-04 19:00:00	IWM	ETF	204.05	204.16	203.9	203.96	23690.0
2024-04-04 05:00:00	DIA	ETF	392.5	392.62	392.5	392.62	300.0
2024-04-04 07:00:00	DIA	ETF	392.7	392.7	392.43	392.54	2823.0

> showing 50 of 20,070 rows — these rows as CSV

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