PREVIEW / etf_1hour / 2024-05-08

all etf 1-hour files

  file:    by_date/etf_1hour/2024/2024-05-08.parquet
  size:    517 KB
  rows:    19,212

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-05-08 04:00:00	SPY	ETF	517.37	517.63	517.18	517.18	8578.0
2024-05-08 05:00:00	SPY	ETF	517.16	517.52	517.15	517.35	9305.0
2024-05-08 06:00:00	SPY	ETF	517.3	517.43	516.95	516.98	25485.0
2024-05-08 07:00:00	SPY	ETF	516.84	516.87	516.29	516.47	218746.0
2024-05-08 08:00:00	SPY	ETF	516.59	517.37	514.979	515.41	441983.0
2024-05-08 09:00:00	SPY	ETF	515.46	516.53	515.14	516.5085	4062541.0
2024-05-08 10:00:00	SPY	ETF	516.495	517.7171	516.04	517.395	4789519.0
2024-05-08 11:00:00	SPY	ETF	517.395	517.6797	516.635	516.81	3884783.0
2024-05-08 12:00:00	SPY	ETF	516.8	517.12	516.26	516.63	2532368.0
2024-05-08 13:00:00	SPY	ETF	516.64	517.1001	516.1	517.07	2856693.0
2024-05-08 14:00:00	SPY	ETF	517.07	517.42	516.89	517.0099	2510409.0
2024-05-08 15:00:00	SPY	ETF	517.0	517.74	516.5699	517.19	7942700.0
2024-05-08 16:00:00	SPY	ETF	517.18	517.2873	516.81	517.03	3392615.0
2024-05-08 17:00:00	SPY	ETF	517.04	517.05	516.76	516.85	71129.0
2024-05-08 18:00:00	SPY	ETF	516.85	517.26	516.85	517.14	69523.0
2024-05-08 19:00:00	SPY	ETF	517.1	517.15	516.97	516.99	38500.0
2024-05-08 04:00:00	QQQ	ETF	440.5	440.83	440.3	440.3	9868.0
2024-05-08 05:00:00	QQQ	ETF	440.22	440.56	440.22	440.33	6853.0
2024-05-08 06:00:00	QQQ	ETF	440.19	440.46	440.04	440.04	12855.0
2024-05-08 07:00:00	QQQ	ETF	440.03	440.03	439.21	439.34	114654.0
2024-05-08 08:00:00	QQQ	ETF	439.8303	440.66	437.43	437.85	326560.0
2024-05-08 09:00:00	QQQ	ETF	437.9	439.85	437.55	439.705	2915196.0
2024-05-08 10:00:00	QQQ	ETF	439.71	441.48	439.31	440.92	3219244.0
2024-05-08 11:00:00	QQQ	ETF	440.945	441.3	439.61	439.855	2320588.0
2024-05-08 12:00:00	QQQ	ETF	439.855	440.25	439.39	439.71	1620465.0
2024-05-08 13:00:00	QQQ	ETF	439.72	440.0	439.01	439.93	2855558.0
2024-05-08 14:00:00	QQQ	ETF	439.94	440.32	439.71	439.8	1458947.0
2024-05-08 15:00:00	QQQ	ETF	439.79	440.48	439.39	440.08	3657352.0
2024-05-08 16:00:00	QQQ	ETF	440.08	440.1	439.36	439.521	747822.0
2024-05-08 17:00:00	QQQ	ETF	439.52	439.5699	439.36	439.4	29272.0
2024-05-08 18:00:00	QQQ	ETF	439.48	439.88	439.42	439.64	37658.0
2024-05-08 19:00:00	QQQ	ETF	439.65	439.74	439.51	439.55	17104.0
2024-05-08 04:00:00	IWM	ETF	204.53	204.54	204.18	204.21	9374.0
2024-05-08 05:00:00	IWM	ETF	204.22	204.35	204.15	204.21	6662.0
2024-05-08 06:00:00	IWM	ETF	204.19	204.23	203.8	203.8	9901.0
2024-05-08 07:00:00	IWM	ETF	203.82	204.0	203.74	203.84	72929.0
2024-05-08 08:00:00	IWM	ETF	203.8	204.67	202.861	203.02	303498.0
2024-05-08 09:00:00	IWM	ETF	203.09	204.97	202.555	203.38	3527564.0
2024-05-08 10:00:00	IWM	ETF	203.38	203.9136	203.1	203.68	2275683.0
2024-05-08 11:00:00	IWM	ETF	203.68	203.87	203.51	203.595	1161075.0
2024-05-08 12:00:00	IWM	ETF	203.6	203.66	202.94	203.17	1382267.0
2024-05-08 13:00:00	IWM	ETF	203.16	203.43	202.91	203.4	1646020.0
2024-05-08 14:00:00	IWM	ETF	203.4	203.77	203.28	203.53	957287.0
2024-05-08 15:00:00	IWM	ETF	203.52	203.955	203.39	203.82	2865253.0
2024-05-08 16:00:00	IWM	ETF	203.82	203.84	203.58	203.75	574681.0
2024-05-08 17:00:00	IWM	ETF	203.71	203.74	203.46	203.58	21213.0
2024-05-08 18:00:00	IWM	ETF	203.56	203.81	203.51	203.68	26036.0
2024-05-08 19:00:00	IWM	ETF	203.7	203.72	203.54	203.61	33474.0
2024-05-08 05:00:00	DIA	ETF	388.88	388.88	388.88	388.88	102.0
2024-05-08 07:00:00	DIA	ETF	388.6	388.73	388.57	388.73	2090.0

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

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