PREVIEW / etf_30min / 2024-03-13

all etf 30-min files

  file:    by_date/etf_30min/2024/2024-03-13.parquet
  size:    799 KB
  rows:    31,751

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-03-13 04:00:00	SPY	ETF	517.36	517.44	516.9	516.94	20955.0
2024-03-13 04:30:00	SPY	ETF	516.77	516.89	516.6	516.89	6592.0
2024-03-13 05:00:00	SPY	ETF	516.69	516.99	516.6	516.94	6029.0
2024-03-13 05:30:00	SPY	ETF	516.82	516.9	516.7	516.88	4590.0
2024-03-13 06:00:00	SPY	ETF	516.9	517.01	516.71	517.0	64245.0
2024-03-13 06:30:00	SPY	ETF	516.99	517.25	516.99	517.25	1107.0
2024-03-13 07:00:00	SPY	ETF	517.2	517.4	517.14	517.36	95439.0
2024-03-13 07:30:00	SPY	ETF	517.39	517.49	517.07	517.1	122512.0
2024-03-13 08:00:00	SPY	ETF	517.34	517.4797	516.54	516.54	314373.0
2024-03-13 08:30:00	SPY	ETF	516.54	516.82	516.41	516.82	167684.0
2024-03-13 09:00:00	SPY	ETF	516.78	517.24	516.72	517.1	139289.0
2024-03-13 09:30:00	SPY	ETF	517.11	517.12	515.95	516.08	4342678.0
2024-03-13 10:00:00	SPY	ETF	516.08	516.59	515.67	516.425	3349085.0
2024-03-13 10:30:00	SPY	ETF	516.42	516.78	515.83	516.21	2443974.0
2024-03-13 11:00:00	SPY	ETF	516.21	516.7199	515.97	516.0598	1736804.0
2024-03-13 11:30:00	SPY	ETF	516.06	516.465	515.83	516.43	2008043.0
2024-03-13 12:00:00	SPY	ETF	516.44	516.5812	516.17	516.28	1479127.0
2024-03-13 12:30:00	SPY	ETF	516.29	516.68	516.08	516.45	1260820.0
2024-03-13 13:00:00	SPY	ETF	516.4526	517.2101	516.36	517.145	2619274.0
2024-03-13 13:30:00	SPY	ETF	517.13	517.29	516.66	517.08	1592471.0
2024-03-13 14:00:00	SPY	ETF	517.09	517.19	516.71	516.85	1665997.0
2024-03-13 14:30:00	SPY	ETF	516.8496	517.045	516.4	516.4901	2138011.0
2024-03-13 15:00:00	SPY	ETF	516.5	516.695	514.49	515.15	4196796.0
2024-03-13 15:30:00	SPY	ETF	515.17	516.3099	515.03	515.99	8173090.0
2024-03-13 16:00:00	SPY	ETF	515.99	516.36	515.85	516.36	1942667.0
2024-03-13 16:30:00	SPY	ETF	516.35	516.49	516.33	516.39	197105.0
2024-03-13 17:00:00	SPY	ETF	516.4	516.4	516.29	516.35	23216.0
2024-03-13 17:30:00	SPY	ETF	516.35	516.41	516.3	516.37	17917.0
2024-03-13 18:00:00	SPY	ETF	516.33	516.42	516.22	516.3	52565.0
2024-03-13 18:30:00	SPY	ETF	516.26	516.33	516.2	516.3	14743.0
2024-03-13 19:00:00	SPY	ETF	516.3	516.47	516.28	516.46	15143.0
2024-03-13 19:30:00	SPY	ETF	516.46	516.62	516.46	516.55	31576.0
2024-03-13 04:00:00	QQQ	ETF	444.32	444.48	443.21	443.21	82019.0
2024-03-13 04:30:00	QQQ	ETF	443.21	443.43	442.85	443.43	33024.0
2024-03-13 05:00:00	QQQ	ETF	443.29	443.4	442.97	443.38	25658.0
2024-03-13 05:30:00	QQQ	ETF	443.39	443.39	443.08	443.35	21212.0
2024-03-13 06:00:00	QQQ	ETF	443.3	443.4	443.06	443.4	16142.0
2024-03-13 06:30:00	QQQ	ETF	443.26	443.78	443.2	443.78	17432.0
2024-03-13 07:00:00	QQQ	ETF	443.77	444.01	443.65	443.87	60239.0
2024-03-13 07:30:00	QQQ	ETF	443.82	444.02	443.41	443.44	57493.0
2024-03-13 08:00:00	QQQ	ETF	443.9498	444.26	442.6	442.69	203153.0
2024-03-13 08:30:00	QQQ	ETF	442.69	442.69	442.3	442.5891	187063.0
2024-03-13 09:00:00	QQQ	ETF	442.58	442.95	442.44	442.65	194807.0
2024-03-13 09:30:00	QQQ	ETF	442.64	442.67	440.435	440.512	4174016.0
2024-03-13 10:00:00	QQQ	ETF	440.52	441.0	439.66	440.6	2644219.0
2024-03-13 10:30:00	QQQ	ETF	440.59	441.598	439.93	440.37	2492599.0
2024-03-13 11:00:00	QQQ	ETF	440.37	441.13	439.96	440.07	1506091.0
2024-03-13 11:30:00	QQQ	ETF	440.07	440.5	439.12	440.39	1971454.0
2024-03-13 12:00:00	QQQ	ETF	440.39	440.72	440.07	440.35	1147777.0
2024-03-13 12:30:00	QQQ	ETF	440.36	440.98	439.99	440.75	1073195.0

> showing 50 of 31,751 rows — these rows as CSV

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