PREVIEW / etf_1hour / 2024-05-02

all etf 1-hour files

  file:    by_date/etf_1hour/2024/2024-05-02.parquet
  size:    534 KB
  rows:    19,636

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-02 04:00:00	SPY	ETF	503.42	504.01	503.2	503.2	26623.0
2024-05-02 05:00:00	SPY	ETF	503.15	503.65	503.15	503.58	9824.0
2024-05-02 06:00:00	SPY	ETF	503.75	504.09	503.44	503.92	83064.0
2024-05-02 07:00:00	SPY	ETF	503.92	504.32	503.33	503.59	207298.0
2024-05-02 08:00:00	SPY	ETF	503.58	504.8	502.84	503.78	422867.0
2024-05-02 09:00:00	SPY	ETF	503.85	504.68	501.6604	501.99	6375210.0
2024-05-02 10:00:00	SPY	ETF	501.98	502.64	499.55	502.44	8717871.0
2024-05-02 11:00:00	SPY	ETF	502.45	503.12	501.38	502.765	4873741.0
2024-05-02 12:00:00	SPY	ETF	502.77	502.86	501.32	502.295	4327390.0
2024-05-02 13:00:00	SPY	ETF	502.33	504.38	502.3	503.85	4592113.0
2024-05-02 14:00:00	SPY	ETF	503.86	505.63	503.68	505.45	5748746.0
2024-05-02 15:00:00	SPY	ETF	505.46	505.89	503.86	505.02	12493188.0
2024-05-02 16:00:00	SPY	ETF	505.01	507.08	504.7	506.89	3967191.0
2024-05-02 17:00:00	SPY	ETF	506.9	506.9	505.75	506.74	160700.0
2024-05-02 18:00:00	SPY	ETF	506.67	507.53	506.26	506.41	142672.0
2024-05-02 19:00:00	SPY	ETF	506.27	506.59	506.27	506.49	36272.0
2024-05-02 04:00:00	QQQ	ETF	425.05	425.68	424.6	424.79	60269.0
2024-05-02 05:00:00	QQQ	ETF	424.85	425.43	424.84	425.43	19840.0
2024-05-02 06:00:00	QQQ	ETF	425.5	425.82	425.16	425.67	60472.0
2024-05-02 07:00:00	QQQ	ETF	425.6	426.04	424.96	425.07	157671.0
2024-05-02 08:00:00	QQQ	ETF	425.62	426.16	424.0	425.1	424618.0
2024-05-02 09:00:00	QQQ	ETF	425.15	425.76	422.92	423.33	4763573.0
2024-05-02 10:00:00	QQQ	ETF	423.31	424.28	420.63	424.04	5137890.0
2024-05-02 11:00:00	QQQ	ETF	424.03	425.05	423.08	424.805	2641241.0
2024-05-02 12:00:00	QQQ	ETF	424.82	424.93	423.1816	424.09	1902599.0
2024-05-02 13:00:00	QQQ	ETF	424.13	426.13	424.13	425.63	2357762.0
2024-05-02 14:00:00	QQQ	ETF	425.65	427.4699	425.45	427.31	2693676.0
2024-05-02 15:00:00	QQQ	ETF	427.32	427.81	426.05	426.93	5534705.0
2024-05-02 16:00:00	QQQ	ETF	426.93	429.44	426.64	429.17	2070819.0
2024-05-02 17:00:00	QQQ	ETF	429.17	429.7	428.72	429.1	254153.0
2024-05-02 18:00:00	QQQ	ETF	429.1	430.59	428.72	429.27	288928.0
2024-05-02 19:00:00	QQQ	ETF	429.29	429.52	429.13	429.45	35362.0
2024-05-02 04:00:00	IWM	ETF	198.55	198.96	198.51	198.51	23693.0
2024-05-02 05:00:00	IWM	ETF	198.46	198.61	198.44	198.47	9108.0
2024-05-02 06:00:00	IWM	ETF	198.41	198.6	198.25	198.51	22771.0
2024-05-02 07:00:00	IWM	ETF	198.57	198.71	198.07	198.16	219499.0
2024-05-02 08:00:00	IWM	ETF	198.5003	199.0899	197.85	198.6	299832.0
2024-05-02 09:00:00	IWM	ETF	198.64	199.16	197.28	197.5	3179066.0
2024-05-02 10:00:00	IWM	ETF	197.51	198.41	196.54	198.33	3135181.0
2024-05-02 11:00:00	IWM	ETF	198.34	198.68	198.17	198.61	1769782.0
2024-05-02 12:00:00	IWM	ETF	198.61	198.795	198.01	198.73	1469155.0
2024-05-02 13:00:00	IWM	ETF	198.75	199.455	198.73	199.29	2047463.0
2024-05-02 14:00:00	IWM	ETF	199.31	199.94	199.18	199.79	1840539.0
2024-05-02 15:00:00	IWM	ETF	199.8	200.12	199.365	199.98	4873463.0
2024-05-02 16:00:00	IWM	ETF	199.92	200.4	199.6	199.69	1871153.0
2024-05-02 17:00:00	IWM	ETF	199.67	199.85	199.6	199.83	14837.0
2024-05-02 18:00:00	IWM	ETF	199.83	199.97	199.67	199.79	16794.0
2024-05-02 19:00:00	IWM	ETF	199.8	199.92	199.61	199.9	39170.0
2024-05-02 04:00:00	DIA	ETF	380.9	380.9	380.53	380.53	1650.0
2024-05-02 05:00:00	DIA	ETF	380.42	380.42	380.42	380.42	723.0

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

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