PREVIEW / etf_1hour / 2024-06-06

all etf 1-hour files

  file:    by_date/etf_1hour/2024/2024-06-06.parquet
  size:    530 KB
  rows:    19,788

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-06-06 04:00:00	SPY	ETF	534.67	535.01	534.57	534.57	7041.0
2024-06-06 05:00:00	SPY	ETF	534.65	534.68	534.41	534.48	9845.0
2024-06-06 06:00:00	SPY	ETF	534.64	534.72	534.55	534.72	2251.0
2024-06-06 07:00:00	SPY	ETF	534.71	534.86	534.65	534.86	48206.0
2024-06-06 08:00:00	SPY	ETF	534.72	535.16	533.98	534.72	332714.0
2024-06-06 09:00:00	SPY	ETF	534.74	535.42	534.33	534.345	3883265.0
2024-06-06 10:00:00	SPY	ETF	534.34	535.2	534.34	534.4575	3210512.0
2024-06-06 11:00:00	SPY	ETF	534.45	534.78	534.055	534.132	2008685.0
2024-06-06 12:00:00	SPY	ETF	534.13	534.27	533.2401	533.4499	2474377.0
2024-06-06 13:00:00	SPY	ETF	533.445	534.4599	533.3	534.19	1984290.0
2024-06-06 14:00:00	SPY	ETF	534.16	534.58	532.68	534.405	2929673.0
2024-06-06 15:00:00	SPY	ETF	534.405	534.67	533.9901	534.63	4858570.0
2024-06-06 16:00:00	SPY	ETF	534.62	534.67	534.09	534.42	2133580.0
2024-06-06 17:00:00	SPY	ETF	534.43	534.66	534.2	534.28	39221.0
2024-06-06 18:00:00	SPY	ETF	534.3	534.59	534.24	534.54	42548.0
2024-06-06 19:00:00	SPY	ETF	534.48	534.58	534.46	534.49	19519.0
2024-06-06 04:00:00	QQQ	ETF	463.97	464.41	463.91	463.97	81891.0
2024-06-06 05:00:00	QQQ	ETF	464.03	464.21	463.52	463.72	25401.0
2024-06-06 06:00:00	QQQ	ETF	463.72	464.11	463.72	463.95	53548.0
2024-06-06 07:00:00	QQQ	ETF	463.95	464.2	463.89	464.12	49417.0
2024-06-06 08:00:00	QQQ	ETF	464.0605	464.7389	463.2	464.09	261039.0
2024-06-06 09:00:00	QQQ	ETF	464.02	464.54	462.48	462.5	3258761.0
2024-06-06 10:00:00	QQQ	ETF	462.51	464.33	462.48	463.76	2676292.0
2024-06-06 11:00:00	QQQ	ETF	463.72	464.08	463.03	463.3	1366213.0
2024-06-06 12:00:00	QQQ	ETF	463.29	463.62	462.6109	463.13	1386233.0
2024-06-06 13:00:00	QQQ	ETF	463.11	463.97	462.94	463.54	1382203.0
2024-06-06 14:00:00	QQQ	ETF	463.53	463.66	462.19	463.39	1886858.0
2024-06-06 15:00:00	QQQ	ETF	463.39	463.6	462.78	463.41	2870287.0
2024-06-06 16:00:00	QQQ	ETF	463.38	463.5	462.88	463.4708	375546.0
2024-06-06 17:00:00	QQQ	ETF	463.43	463.45	463.1	463.39	73594.0
2024-06-06 18:00:00	QQQ	ETF	463.34	463.74	463.28	463.7	83684.0
2024-06-06 19:00:00	QQQ	ETF	463.68	463.7	463.55	463.6	20630.0
2024-06-06 04:00:00	IWM	ETF	204.85	204.85	204.16	204.16	30952.0
2024-06-06 05:00:00	IWM	ETF	204.2	204.4	204.1	204.4	28390.0
2024-06-06 06:00:00	IWM	ETF	204.41	204.48	204.28	204.33	22907.0
2024-06-06 07:00:00	IWM	ETF	204.36	204.44	204.22	204.38	38514.0
2024-06-06 08:00:00	IWM	ETF	204.4	204.93	203.85	204.11	325829.0
2024-06-06 09:00:00	IWM	ETF	204.09	204.81	203.75	204.39	1971941.0
2024-06-06 10:00:00	IWM	ETF	204.41	204.5	203.63	203.72	2154280.0
2024-06-06 11:00:00	IWM	ETF	203.71	204.23	203.68	203.88	1056829.0
2024-06-06 12:00:00	IWM	ETF	203.87	203.88	203.14	203.29	1195694.0
2024-06-06 13:00:00	IWM	ETF	203.29	204.09	203.21	203.78	1736072.0
2024-06-06 14:00:00	IWM	ETF	203.78	203.8	202.9875	203.64	1772111.0
2024-06-06 15:00:00	IWM	ETF	203.62	203.755	203.34	203.55	2643938.0
2024-06-06 16:00:00	IWM	ETF	203.59	203.62	203.4	203.62	650272.0
2024-06-06 17:00:00	IWM	ETF	203.65	203.75	203.58	203.6776	10899.0
2024-06-06 18:00:00	IWM	ETF	203.66	203.9	203.65	203.8	19967.0
2024-06-06 19:00:00	IWM	ETF	203.81	203.9	203.75	203.84	11983.0
2024-06-06 04:00:00	DIA	ETF	388.15	388.32	388.11	388.32	2927.0
2024-06-06 05:00:00	DIA	ETF	388.18	388.22	388.18	388.19	1270.0

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

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