PREVIEW / etf_30min / 2024-10-23

all etf 30-min files

  file:    by_date/etf_30min/2024/2024-10-23.parquet
  size:    870 KB
  rows:    34,492

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-10-23 04:00:00	SPY	ETF	582.9	583.23	582.9	583.06	10189.0
2024-10-23 04:30:00	SPY	ETF	583.05	583.06	582.43	582.46	20295.0
2024-10-23 05:00:00	SPY	ETF	582.59	582.78	582.38	582.71	8605.0
2024-10-23 05:30:00	SPY	ETF	582.7	582.7	582.37	582.59	1874.0
2024-10-23 06:00:00	SPY	ETF	582.3	582.43	582.06	582.06	5101.0
2024-10-23 06:30:00	SPY	ETF	582.06	582.12	581.8	581.93	31817.0
2024-10-23 07:00:00	SPY	ETF	581.93	582.34	581.91	582.02	28050.0
2024-10-23 07:30:00	SPY	ETF	581.98	582.25	581.87	582.1	28544.0
2024-10-23 08:00:00	SPY	ETF	581.99	583.43	581.85	582.01	67100.0
2024-10-23 08:30:00	SPY	ETF	582.0	582.1	581.3163	581.44	232418.0
2024-10-23 09:00:00	SPY	ETF	581.38	581.49	581.05	581.26	170817.0
2024-10-23 09:30:00	SPY	ETF	581.26	581.7086	580.96	581.31	1999578.0
2024-10-23 10:00:00	SPY	ETF	581.29	581.39	580.1	580.9922	1944034.0
2024-10-23 10:30:00	SPY	ETF	580.99	581.64	580.42	580.49	1335040.0
2024-10-23 11:00:00	SPY	ETF	580.51	580.76	578.83	578.8999	2414473.0
2024-10-23 11:30:00	SPY	ETF	578.88	579.898	578.78	579.835	1764969.0
2024-10-23 12:00:00	SPY	ETF	579.83	579.83	578.09	578.1986	1482473.0
2024-10-23 12:30:00	SPY	ETF	578.18	578.835	577.6302	578.15	1857328.0
2024-10-23 13:00:00	SPY	ETF	578.15	578.15	576.46	577.0	2345767.0
2024-10-23 13:30:00	SPY	ETF	576.9701	576.98	575.86	575.95	1668999.0
2024-10-23 14:00:00	SPY	ETF	575.96	575.97	574.415	575.51	3282124.0
2024-10-23 14:30:00	SPY	ETF	575.51	577.23	575.4	577.17	2600202.0
2024-10-23 15:00:00	SPY	ETF	577.15	577.55	576.66	577.28	2510179.0
2024-10-23 15:30:00	SPY	ETF	577.29	578.13	577.08	577.93	5710381.0
2024-10-23 16:00:00	SPY	ETF	577.93	578.88	577.68	578.83	3643010.0
2024-10-23 16:30:00	SPY	ETF	578.87	578.9	578.41	578.41	186128.0
2024-10-23 17:00:00	SPY	ETF	578.47	578.85	577.99	578.79	417610.0
2024-10-23 17:30:00	SPY	ETF	578.79	578.87	578.65	578.87	17335.0
2024-10-23 18:00:00	SPY	ETF	578.78	578.78	578.41	578.65	44848.0
2024-10-23 18:30:00	SPY	ETF	578.6	578.6	578.33	578.54	6768.0
2024-10-23 19:00:00	SPY	ETF	578.5	578.5	578.2	578.25	10951.0
2024-10-23 19:30:00	SPY	ETF	578.33	578.6	578.33	578.56	42261.0
2024-10-23 04:00:00	QQQ	ETF	495.24	495.61	495.24	495.39	23791.0
2024-10-23 04:30:00	QQQ	ETF	495.34	495.34	494.76	494.88	12317.0
2024-10-23 05:00:00	QQQ	ETF	494.87	495.22	494.5	495.1	19827.0
2024-10-23 05:30:00	QQQ	ETF	495.08	495.08	494.7	494.77	5468.0
2024-10-23 06:00:00	QQQ	ETF	494.78	494.78	494.31	494.31	11479.0
2024-10-23 06:30:00	QQQ	ETF	494.21	494.46	493.91	494.13	43984.0
2024-10-23 07:00:00	QQQ	ETF	494.13	494.75	494.02	494.429	44159.0
2024-10-23 07:30:00	QQQ	ETF	494.384	494.62	494.18	494.46	45025.0
2024-10-23 08:00:00	QQQ	ETF	494.27	496.05	493.9804	494.71	127905.0
2024-10-23 08:30:00	QQQ	ETF	494.62	495.589	493.8	494.07	111328.0
2024-10-23 09:00:00	QQQ	ETF	493.99	494.13	493.32	493.56	130882.0
2024-10-23 09:30:00	QQQ	ETF	493.58	494.25	492.95	493.56	2312145.0
2024-10-23 10:00:00	QQQ	ETF	493.53	493.65	491.45	493.19	2306186.0
2024-10-23 10:30:00	QQQ	ETF	493.17	494.1169	492.55	492.57	1605339.0
2024-10-23 11:00:00	QQQ	ETF	492.59	493.18	490.49	490.58	2205684.0
2024-10-23 11:30:00	QQQ	ETF	490.55	491.81	490.44	491.73	1446480.0
2024-10-23 12:00:00	QQQ	ETF	491.72	491.72	489.2926	489.38	1635055.0
2024-10-23 12:30:00	QQQ	ETF	489.3599	489.93	488.735	489.13	1283518.0

> showing 50 of 34,492 rows — these rows as CSV

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