PREVIEW / etf_1hour / 2024-04-08

all etf 1-hour files

  file:    by_date/etf_1hour/2024/2024-04-08.parquet
  size:    530 KB
  rows:    19,551

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-08 04:00:00	SPY	ETF	518.83	519.04	517.09	517.54	39882.0
2024-04-08 05:00:00	SPY	ETF	517.92	518.48	517.77	518.25	11388.0
2024-04-08 06:00:00	SPY	ETF	518.1	518.66	517.85	518.65	17664.0
2024-04-08 07:00:00	SPY	ETF	518.63	518.93	518.15	518.75	80982.0
2024-04-08 08:00:00	SPY	ETF	518.83	519.89	517.86	519.8	298187.0
2024-04-08 09:00:00	SPY	ETF	519.81	519.95	517.98	518.83	4167007.0
2024-04-08 10:00:00	SPY	ETF	518.84	520.18	518.2	519.99	5544900.0
2024-04-08 11:00:00	SPY	ETF	519.99	520.13	518.28	518.73	4413551.0
2024-04-08 12:00:00	SPY	ETF	518.73	519.44	517.89	519.44	3904441.0
2024-04-08 13:00:00	SPY	ETF	519.43	519.46	518.65	519.31	2803950.0
2024-04-08 14:00:00	SPY	ETF	519.31	519.48	518.6699	519.255	3193761.0
2024-04-08 15:00:00	SPY	ETF	519.26	519.7	518.23	518.67	10191953.0
2024-04-08 16:00:00	SPY	ETF	518.66	519.05	518.63	518.92	2002479.0
2024-04-08 17:00:00	SPY	ETF	518.89	519.0	518.74	518.98	34421.0
2024-04-08 18:00:00	SPY	ETF	519.03	519.2	518.88	519.059	25132.0
2024-04-08 19:00:00	SPY	ETF	519.0599	519.0599	518.8	518.81	12603.0
2024-04-08 04:00:00	QQQ	ETF	441.25	441.44	439.48	440.02	73200.0
2024-04-08 05:00:00	QQQ	ETF	440.11	440.85	440.07	440.75	17703.0
2024-04-08 06:00:00	QQQ	ETF	440.64	441.0	440.2	440.97	22333.0
2024-04-08 07:00:00	QQQ	ETF	441.02	441.279	440.32	440.85	88962.0
2024-04-08 08:00:00	QQQ	ETF	441.01	442.3	439.8696	442.1	298622.0
2024-04-08 09:00:00	QQQ	ETF	442.17	442.31	439.2	440.76	3142461.0
2024-04-08 10:00:00	QQQ	ETF	440.74	442.5	440.15	442.2499	3817838.0
2024-04-08 11:00:00	QQQ	ETF	442.25	442.43	440.21	440.7464	3080663.0
2024-04-08 12:00:00	QQQ	ETF	440.77	441.12	439.58	441.09	2589658.0
2024-04-08 13:00:00	QQQ	ETF	441.09	441.14	440.2206	440.86	1916547.0
2024-04-08 14:00:00	QQQ	ETF	440.9	441.28	440.36	441.135	1400512.0
2024-04-08 15:00:00	QQQ	ETF	441.14	441.45	440.34	440.62	4937119.0
2024-04-08 16:00:00	QQQ	ETF	440.63	441.08	440.58	440.93	599998.0
2024-04-08 17:00:00	QQQ	ETF	440.97	441.08	440.6	441.08	282033.0
2024-04-08 18:00:00	QQQ	ETF	441.09	441.24	440.6	441.05	14428.0
2024-04-08 19:00:00	QQQ	ETF	441.05	441.05	440.71	440.74	17530.0
2024-04-08 04:00:00	IWM	ETF	204.44	204.64	203.81	204.25	14442.0
2024-04-08 05:00:00	IWM	ETF	204.37	204.73	204.29	204.29	6904.0
2024-04-08 06:00:00	IWM	ETF	204.31	204.85	204.24	204.76	8142.0
2024-04-08 07:00:00	IWM	ETF	204.77	205.19	204.77	205.13	53457.0
2024-04-08 08:00:00	IWM	ETF	204.9	205.81	204.2	205.75	118892.0
2024-04-08 09:00:00	IWM	ETF	205.81	206.4197	205.23	205.32	3200940.0
2024-04-08 10:00:00	IWM	ETF	205.32	205.92	204.58	205.77	2914300.0
2024-04-08 11:00:00	IWM	ETF	205.79	206.0	205.15	205.4	1910220.0
2024-04-08 12:00:00	IWM	ETF	205.4	205.99	205.205	205.99	1757664.0
2024-04-08 13:00:00	IWM	ETF	206.0	206.1	205.715	206.042	1307582.0
2024-04-08 14:00:00	IWM	ETF	206.06	206.185	205.81	206.0	1403172.0
2024-04-08 15:00:00	IWM	ETF	206.0	206.06	205.43	205.6	3501759.0
2024-04-08 16:00:00	IWM	ETF	205.57	205.7129	205.44	205.47	871477.0
2024-04-08 17:00:00	IWM	ETF	205.49	205.6	205.46	205.6	8364.0
2024-04-08 18:00:00	IWM	ETF	205.63	205.7	205.53	205.65	12449.0
2024-04-08 19:00:00	IWM	ETF	205.67	205.69	205.48	205.52	13032.0
2024-04-08 04:00:00	DIA	ETF	389.42	389.42	389.42	389.42	116.0
2024-04-08 07:00:00	DIA	ETF	389.37	389.37	388.88	389.11	3700.0

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

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