PREVIEW / etf_30min / 2024-08-14

all etf 30-min files

  file:    by_date/etf_30min/2024/2024-08-14.parquet
  size:    806 KB
  rows:    32,316

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-08-14 04:00:00	SPY	ETF	542.04	542.09	541.64	541.89	14642.0
2024-08-14 04:30:00	SPY	ETF	542.12	542.15	541.99	542.13	4234.0
2024-08-14 05:00:00	SPY	ETF	542.15	542.28	542.05	542.16	4200.0
2024-08-14 05:30:00	SPY	ETF	542.16	542.3	542.1	542.12	12917.0
2024-08-14 06:00:00	SPY	ETF	542.15	542.4	542.09	542.31	7893.0
2024-08-14 06:30:00	SPY	ETF	542.32	542.5	542.13	542.2	8504.0
2024-08-14 07:00:00	SPY	ETF	542.28	542.32	541.99	542.12	84800.0
2024-08-14 07:30:00	SPY	ETF	542.21	542.43	542.01	542.28	66356.0
2024-08-14 08:00:00	SPY	ETF	542.25	542.78	542.01	542.58	228909.0
2024-08-14 08:30:00	SPY	ETF	542.58	543.54	541.0	542.9182	972017.0
2024-08-14 09:00:00	SPY	ETF	542.93	543.09	542.56	542.87	280225.0
2024-08-14 09:30:00	SPY	ETF	542.87	543.27	541.29	541.49	3704773.0
2024-08-14 10:00:00	SPY	ETF	541.495	542.0	540.84	541.865	1881421.0
2024-08-14 10:30:00	SPY	ETF	541.885	542.42	540.12	542.36	1995374.0
2024-08-14 11:00:00	SPY	ETF	542.364	543.17	542.25	543.1577	1249551.0
2024-08-14 11:30:00	SPY	ETF	543.2	544.78	543.1887	544.68	2115149.0
2024-08-14 12:00:00	SPY	ETF	544.67	544.96	542.14	542.645	2234395.0
2024-08-14 12:30:00	SPY	ETF	542.65	543.25	541.8	543.08	1471987.0
2024-08-14 13:00:00	SPY	ETF	543.07	543.55	542.4803	543.22	993517.0
2024-08-14 13:30:00	SPY	ETF	543.16	543.62	542.9101	543.28	829636.0
2024-08-14 14:00:00	SPY	ETF	543.23	543.42	542.63	543.3775	1166814.0
2024-08-14 14:30:00	SPY	ETF	543.35	544.35	543.27	544.28	1372910.0
2024-08-14 15:00:00	SPY	ETF	544.27	544.3	542.845	543.11	1932489.0
2024-08-14 15:30:00	SPY	ETF	543.11	544.69	542.75	543.78	6683728.0
2024-08-14 16:00:00	SPY	ETF	543.78	544.75	543.72	544.54	2243871.0
2024-08-14 16:30:00	SPY	ETF	544.55	544.61	544.3	544.301	100899.0
2024-08-14 17:00:00	SPY	ETF	544.44	544.67	544.35	544.35	50268.0
2024-08-14 17:30:00	SPY	ETF	544.31	544.5	544.31	544.5	3684.0
2024-08-14 18:00:00	SPY	ETF	544.4	544.43	543.88	544.03	21168.0
2024-08-14 18:30:00	SPY	ETF	543.99	544.16	543.99	544.1	13069.0
2024-08-14 19:00:00	SPY	ETF	544.12	544.34	544.12	544.16	5880.0
2024-08-14 19:30:00	SPY	ETF	544.08	544.08	543.51	543.73	24815.0
2024-08-14 04:00:00	QQQ	ETF	462.55	462.91	461.71	462.14	46005.0
2024-08-14 04:30:00	QQQ	ETF	462.27	462.47	462.01	462.34	9768.0
2024-08-14 05:00:00	QQQ	ETF	462.29	462.32	462.03	462.26	44459.0
2024-08-14 05:30:00	QQQ	ETF	462.35	462.62	462.31	462.53	26306.0
2024-08-14 06:00:00	QQQ	ETF	462.6	462.95	462.6	462.89	11100.0
2024-08-14 06:30:00	QQQ	ETF	463.0	463.11	462.61	462.71	14878.0
2024-08-14 07:00:00	QQQ	ETF	462.85	463.07	462.45	462.69	53324.0
2024-08-14 07:30:00	QQQ	ETF	462.81	462.98	462.6	462.81	37550.0
2024-08-14 08:00:00	QQQ	ETF	462.81	463.2	461.84	463.2	196835.0
2024-08-14 08:30:00	QQQ	ETF	463.44	464.21	460.26	463.37	1015343.0
2024-08-14 09:00:00	QQQ	ETF	463.4	463.9	463.16	463.5	261309.0
2024-08-14 09:30:00	QQQ	ETF	463.56	464.43	460.48	460.89	4459588.0
2024-08-14 10:00:00	QQQ	ETF	460.91	461.52	459.38	460.395	2822492.0
2024-08-14 10:30:00	QQQ	ETF	460.42	461.95	458.4	461.805	2369047.0
2024-08-14 11:00:00	QQQ	ETF	461.84	462.82	461.49	462.79	1326649.0
2024-08-14 11:30:00	QQQ	ETF	462.82	465.1093	462.81	464.95	1934093.0
2024-08-14 12:00:00	QQQ	ETF	464.94	464.98	461.24	461.965	1768746.0
2024-08-14 12:30:00	QQQ	ETF	461.9603	462.27	460.65	461.93	1154878.0

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

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