PREVIEW / etf_1hour / 2023-10-02

all etf 1-hour files

  file:    by_date/etf_1hour/2023/2023-10-02.parquet
  size:    492 KB
  rows:    18,133

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
2023-10-02 04:00:00	SPY	ETF	429.0	430.18	429.0	429.5	32574.0
2023-10-02 05:00:00	SPY	ETF	429.42	429.5	427.55	427.72	59896.0
2023-10-02 06:00:00	SPY	ETF	427.64	427.75	427.31	427.48	73448.0
2023-10-02 07:00:00	SPY	ETF	427.48	427.75	426.75	426.87	290145.0
2023-10-02 08:00:00	SPY	ETF	427.47	430.19	426.22	426.44	362016.0
2023-10-02 09:00:00	SPY	ETF	426.41	427.75	425.85	426.7238	7190793.0
2023-10-02 10:00:00	SPY	ETF	426.68	428.0973	425.91	426.365	11378554.0
2023-10-02 11:00:00	SPY	ETF	426.39	428.6	425.5	425.8096	10236404.0
2023-10-02 12:00:00	SPY	ETF	425.81	426.07	424.46	424.82	8764316.0
2023-10-02 13:00:00	SPY	ETF	424.82	426.0	424.575	425.4973	6536940.0
2023-10-02 14:00:00	SPY	ETF	425.5	426.78	424.55	425.1299	8878092.0
2023-10-02 15:00:00	SPY	ETF	425.11	427.37	424.515	427.36	15831482.0
2023-10-02 16:00:00	SPY	ETF	427.36	427.76	425.1785	427.5	2436537.0
2023-10-02 17:00:00	SPY	ETF	427.61	427.61	427.25	427.25	107835.0
2023-10-02 18:00:00	SPY	ETF	427.36	427.69	427.31	427.32	92775.0
2023-10-02 19:00:00	SPY	ETF	427.4	427.63	427.09	427.4	92722.0
2023-10-02 04:00:00	QQQ	ETF	361.28	361.54	360.74	360.75	49367.0
2023-10-02 05:00:00	QQQ	ETF	360.7	360.72	359.0	359.18	154907.0
2023-10-02 06:00:00	QQQ	ETF	359.16	359.36	358.73	358.88	84849.0
2023-10-02 07:00:00	QQQ	ETF	358.97	359.3	358.41	358.56	263916.0
2023-10-02 08:00:00	QQQ	ETF	358.9784	361.69	357.88	358.06	430339.0
2023-10-02 09:00:00	QQQ	ETF	358.0	360.63	357.4	359.6599	5154209.0
2023-10-02 10:00:00	QQQ	ETF	359.65	361.4	359.33	359.97	8004596.0
2023-10-02 11:00:00	QQQ	ETF	359.97	362.68	359.41	359.63	7170265.0
2023-10-02 12:00:00	QQQ	ETF	359.64	360.01	358.7138	358.95	4114689.0
2023-10-02 13:00:00	QQQ	ETF	358.95	359.93	358.39	359.4	3316646.0
2023-10-02 14:00:00	QQQ	ETF	359.4	360.57	358.34	359.01	4188854.0
2023-10-02 15:00:00	QQQ	ETF	359.0	361.32	358.4	361.3	6922773.0
2023-10-02 16:00:00	QQQ	ETF	361.31	361.68	359.2573	361.42	1540531.0
2023-10-02 17:00:00	QQQ	ETF	361.42	361.43	361.26	361.3	169335.0
2023-10-02 18:00:00	QQQ	ETF	361.28	361.66	361.27	361.32	54256.0
2023-10-02 19:00:00	QQQ	ETF	361.33	361.6	361.08	361.42	89735.0
2023-10-02 04:00:00	IWM	ETF	177.41	177.79	177.41	177.57	13878.0
2023-10-02 05:00:00	IWM	ETF	177.51	177.51	176.78	176.84	46653.0
2023-10-02 06:00:00	IWM	ETF	176.79	176.86	176.68	176.72	6819.0
2023-10-02 07:00:00	IWM	ETF	176.74	176.9	176.41	176.53	62627.0
2023-10-02 08:00:00	IWM	ETF	176.58	177.89	176.27	176.37	49096.0
2023-10-02 09:00:00	IWM	ETF	176.33	176.73	175.16	175.51	3993067.0
2023-10-02 10:00:00	IWM	ETF	175.51	175.925	174.575	174.77	6497850.0
2023-10-02 11:00:00	IWM	ETF	174.77	175.46	174.2	174.31	4129022.0
2023-10-02 12:00:00	IWM	ETF	174.3	174.355	173.64	173.82	3774981.0
2023-10-02 13:00:00	IWM	ETF	173.81	174.2	173.66	173.91	2580766.0
2023-10-02 14:00:00	IWM	ETF	173.91	174.32	173.3338	173.4	3094594.0
2023-10-02 15:00:00	IWM	ETF	173.4	174.04	173.15	174.03	8024905.0
2023-10-02 16:00:00	IWM	ETF	174.03	174.25	174.01	174.23	1668253.0
2023-10-02 17:00:00	IWM	ETF	174.23	174.23	173.95	174.01	33539.0
2023-10-02 18:00:00	IWM	ETF	174.07	174.28	174.05	174.13	44336.0
2023-10-02 19:00:00	IWM	ETF	174.12	174.25	174.03	174.15	10670.0
2023-10-02 04:00:00	DIA	ETF	336.71	336.81	336.61	336.61	950.0
2023-10-02 05:00:00	DIA	ETF	336.05	336.05	335.03	335.03	1230.0

> showing 50 of 18,133 rows — these rows as CSV

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