PREVIEW / etf_1hour / 2024-11-06

all etf 1-hour files

  file:    by_date/etf_1hour/2024/2024-11-06.parquet
  size:    645 KB
  rows:    24,090

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-11-06 04:00:00	SPY	ETF	583.0	590.6	583.0	590.11	268828.0
2024-11-06 05:00:00	SPY	ETF	590.1	590.71	589.3	589.53	258414.0
2024-11-06 06:00:00	SPY	ETF	589.65	589.99	587.3	587.78	362248.0
2024-11-06 07:00:00	SPY	ETF	587.76	590.41	587.46	589.7	738026.0
2024-11-06 08:00:00	SPY	ETF	587.65	590.52	582.5	588.68	927624.0
2024-11-06 09:00:00	SPY	ETF	588.63	589.43	585.39	586.11	9401308.0
2024-11-06 10:00:00	SPY	ETF	586.12	589.08	586.12	587.02	7146942.0
2024-11-06 11:00:00	SPY	ETF	586.99	588.86	586.31	588.78	3796256.0
2024-11-06 12:00:00	SPY	ETF	588.77	589.48	588.3101	589.265	2468796.0
2024-11-06 13:00:00	SPY	ETF	589.26	590.71	589.12	590.27	3318717.0
2024-11-06 14:00:00	SPY	ETF	590.28	590.85	589.79	590.54	3218582.0
2024-11-06 15:00:00	SPY	ETF	590.54	591.93	590.45	591.04	12186312.0
2024-11-06 16:00:00	SPY	ETF	591.03	591.87	590.65	591.79	4430337.0
2024-11-06 17:00:00	SPY	ETF	591.8199	591.87	591.04	591.45	201954.0
2024-11-06 18:00:00	SPY	ETF	591.55	591.55	590.79	590.84	458032.0
2024-11-06 19:00:00	SPY	ETF	590.89	591.33	590.3599	590.46	55692.0
2024-11-06 04:00:00	QQQ	ETF	501.0	501.6	498.22	501.56	152243.0
2024-11-06 05:00:00	QQQ	ETF	501.59	501.6	500.43	500.49	83721.0
2024-11-06 06:00:00	QQQ	ETF	500.51	500.74	498.09	498.61	441260.0
2024-11-06 07:00:00	QQQ	ETF	498.63	501.11	498.49	500.64	432560.0
2024-11-06 08:00:00	QQQ	ETF	498.68	501.5604	495.13	500.65	587746.0
2024-11-06 09:00:00	QQQ	ETF	500.6	503.46	499.6	500.33	6874247.0
2024-11-06 10:00:00	QQQ	ETF	500.35	503.7894	500.07	501.46	3903254.0
2024-11-06 11:00:00	QQQ	ETF	501.43	503.41	500.72	503.17	2695505.0
2024-11-06 12:00:00	QQQ	ETF	503.18	503.82	502.74	503.62	1438506.0
2024-11-06 13:00:00	QQQ	ETF	503.63	505.08	503.47	504.75	2456048.0
2024-11-06 14:00:00	QQQ	ETF	504.75	505.52	504.43	505.4	2068401.0
2024-11-06 15:00:00	QQQ	ETF	505.4	506.41	505.17	505.62	5601219.0
2024-11-06 16:00:00	QQQ	ETF	505.58	506.54	505.4	506.29	2438998.0
2024-11-06 17:00:00	QQQ	ETF	506.25	506.29	505.8	505.81	51253.0
2024-11-06 18:00:00	QQQ	ETF	505.95	506.1	505.47	505.5	176709.0
2024-11-06 19:00:00	QQQ	ETF	505.5	505.9	504.8	505.07	124282.0
2024-11-06 04:00:00	IWM	ETF	238.4	238.66	231.3	237.75	571158.0
2024-11-06 05:00:00	IWM	ETF	237.72	239.02	237.19	238.83	481587.0
2024-11-06 06:00:00	IWM	ETF	238.81	238.88	234.95	235.23	693439.0
2024-11-06 07:00:00	IWM	ETF	235.16	238.27	234.53	237.77	808829.0
2024-11-06 08:00:00	IWM	ETF	237.98	238.8	229.0	237.15	1400125.0
2024-11-06 09:00:00	IWM	ETF	237.23	238.22	232.75	233.78	14287718.0
2024-11-06 10:00:00	IWM	ETF	233.79	236.29	233.49	234.5	8392025.0
2024-11-06 11:00:00	IWM	ETF	234.5	235.45	233.9138	235.39	4564936.0
2024-11-06 12:00:00	IWM	ETF	235.38	236.29	235.02	236.27	3678279.0
2024-11-06 13:00:00	IWM	ETF	236.27	237.09	236.06	236.66	4045286.0
2024-11-06 14:00:00	IWM	ETF	236.65	237.27	236.49	236.76	3457010.0
2024-11-06 15:00:00	IWM	ETF	236.75	237.58	236.59	237.23	8370684.0
2024-11-06 16:00:00	IWM	ETF	237.22	237.25	236.7	236.96	3459381.0
2024-11-06 17:00:00	IWM	ETF	236.95	237.22	236.79	236.9	24259.0
2024-11-06 18:00:00	IWM	ETF	236.95	237.07	236.77	236.84	139840.0
2024-11-06 19:00:00	IWM	ETF	236.99	237.4	236.51	236.75	72379.0
2024-11-06 04:00:00	DIA	ETF	433.56	433.69	433.18	433.65	7272.0
2024-11-06 05:00:00	DIA	ETF	434.07	434.86	433.93	434.61	32013.0

> showing 50 of 24,090 rows — these rows as CSV

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