PREVIEW / etf_30min / 2024-07-30

all etf 30-min files

  file:    by_date/etf_30min/2024/2024-07-30.parquet
  size:    814 KB
  rows:    32,805

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-07-30 04:00:00	SPY	ETF	545.05	545.91	545.05	545.29	7844.0
2024-07-30 04:30:00	SPY	ETF	545.31	545.94	545.31	545.79	4448.0
2024-07-30 05:00:00	SPY	ETF	545.71	545.99	545.61	545.61	2480.0
2024-07-30 05:30:00	SPY	ETF	545.54	545.71	545.18	545.71	2039.0
2024-07-30 06:00:00	SPY	ETF	545.65	545.98	545.53	545.98	2308.0
2024-07-30 06:30:00	SPY	ETF	546.0	546.11	545.87	545.88	16298.0
2024-07-30 07:00:00	SPY	ETF	545.88	546.05	545.36	545.87	231355.0
2024-07-30 07:30:00	SPY	ETF	545.9	546.18	545.82	545.83	22427.0
2024-07-30 08:00:00	SPY	ETF	546.0	546.13	544.0	545.74	64685.0
2024-07-30 08:30:00	SPY	ETF	545.74	546.02	545.72	545.8	83684.0
2024-07-30 09:00:00	SPY	ETF	545.86	546.31	545.82	546.22	124091.0
2024-07-30 09:30:00	SPY	ETF	546.26	547.34	545.74	546.25	3782280.0
2024-07-30 10:00:00	SPY	ETF	546.24	546.43	544.78	544.96	2069574.0
2024-07-30 10:30:00	SPY	ETF	544.98	545.08	543.68	543.85	1582615.0
2024-07-30 11:00:00	SPY	ETF	543.84	543.99	541.2135	542.14	3397498.0
2024-07-30 11:30:00	SPY	ETF	542.12	542.39	540.44	540.53	1871676.0
2024-07-30 12:00:00	SPY	ETF	540.54	541.27	540.1	540.81	1743127.0
2024-07-30 12:30:00	SPY	ETF	540.81	541.15	538.79	538.835	1648477.0
2024-07-30 13:00:00	SPY	ETF	538.87	540.6299	538.515	540.5126	1908731.0
2024-07-30 13:30:00	SPY	ETF	540.5	541.51	540.19	541.32	1169722.0
2024-07-30 14:00:00	SPY	ETF	541.31	542.66	541.0559	541.9351	1162951.0
2024-07-30 14:30:00	SPY	ETF	541.91	542.22	540.98	541.45	1789540.0
2024-07-30 15:00:00	SPY	ETF	541.44	541.95	540.77	541.72	1393903.0
2024-07-30 15:30:00	SPY	ETF	541.71	543.655	541.25	541.91	6466442.0
2024-07-30 16:00:00	SPY	ETF	541.92	542.38	537.97	539.69	3039188.0
2024-07-30 16:30:00	SPY	ETF	539.66	540.54	539.4	540.03	247598.0
2024-07-30 17:00:00	SPY	ETF	539.88	540.53	539.62	539.95	122214.0
2024-07-30 17:30:00	SPY	ETF	539.93	540.55	539.0	540.0	66507.0
2024-07-30 18:00:00	SPY	ETF	540.16	542.04	539.94	541.31	169312.0
2024-07-30 18:30:00	SPY	ETF	541.31	541.7	541.31	541.35	34985.0
2024-07-30 19:00:00	SPY	ETF	541.31	542.34	541.31	542.31	179695.0
2024-07-30 19:30:00	SPY	ETF	542.32	542.82	542.24	542.72	62918.0
2024-07-30 04:00:00	QQQ	ETF	464.02	465.03	463.52	464.07	34115.0
2024-07-30 04:30:00	QQQ	ETF	464.23	465.01	464.23	464.8	22629.0
2024-07-30 05:00:00	QQQ	ETF	464.88	465.27	464.66	464.66	18366.0
2024-07-30 05:30:00	QQQ	ETF	464.61	464.69	463.89	464.39	22550.0
2024-07-30 06:00:00	QQQ	ETF	464.32	464.82	464.32	464.82	8894.0
2024-07-30 06:30:00	QQQ	ETF	464.83	465.04	464.73	464.92	13408.0
2024-07-30 07:00:00	QQQ	ETF	464.96	465.25	464.84	465.12	37860.0
2024-07-30 07:30:00	QQQ	ETF	465.21	465.59	465.1	465.24	31097.0
2024-07-30 08:00:00	QQQ	ETF	465.24	465.5993	462.47	465.07	117939.0
2024-07-30 08:30:00	QQQ	ETF	465.06	465.42	465.0	465.3301	77455.0
2024-07-30 09:00:00	QQQ	ETF	465.42	465.92	465.27	465.83	153099.0
2024-07-30 09:30:00	QQQ	ETF	465.85	466.561	463.86	464.31	2418728.0
2024-07-30 10:00:00	QQQ	ETF	464.33	464.77	462.74	462.8801	1726148.0
2024-07-30 10:30:00	QQQ	ETF	462.9	463.165	461.27	461.465	1595342.0
2024-07-30 11:00:00	QQQ	ETF	461.42	461.675	458.33	459.46	2506220.0
2024-07-30 11:30:00	QQQ	ETF	459.4	459.729	457.12	457.2	1897167.0
2024-07-30 12:00:00	QQQ	ETF	457.21	458.25	456.68	457.37	1234359.0
2024-07-30 12:30:00	QQQ	ETF	457.31	457.66	454.37	454.48	1550934.0

> showing 50 of 32,805 rows — these rows as CSV

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