PREVIEW / etf_30min / 2023-12-15

all etf 30-min files

  file:    by_date/etf_30min/2023/2023-12-15.parquet
  size:    800 KB
  rows:    31,528

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
2023-12-15 04:00:00	SPY	ETF	471.18	471.36	471.0	471.29	37856.0
2023-12-15 04:30:00	SPY	ETF	471.32	471.48	471.23	471.43	11067.0
2023-12-15 05:00:00	SPY	ETF	471.47	471.65	471.44	471.56	21237.0
2023-12-15 05:30:00	SPY	ETF	471.43	471.44	471.17	471.32	6695.0
2023-12-15 06:00:00	SPY	ETF	471.3	471.45	471.21	471.37	12017.0
2023-12-15 06:30:00	SPY	ETF	471.34	471.48	471.27	471.27	109874.0
2023-12-15 07:00:00	SPY	ETF	471.3	471.37	471.0	471.29	68680.0
2023-12-15 07:30:00	SPY	ETF	471.33	471.35	470.79	470.93	70247.0
2023-12-15 08:00:00	SPY	ETF	471.0	472.58	470.5	471.02	227040.0
2023-12-15 08:30:00	SPY	ETF	471.03	471.17	469.28	469.99	745229.0
2023-12-15 09:00:00	SPY	ETF	470.0	470.61	469.36	469.48	637962.0
2023-12-15 09:30:00	SPY	ETF	469.49	469.82	468.81	469.15	8632144.0
2023-12-15 10:00:00	SPY	ETF	469.16	470.22	469.12	470.06	3791545.0
2023-12-15 10:30:00	SPY	ETF	470.07	470.54	469.82	470.32	3720558.0
2023-12-15 11:00:00	SPY	ETF	470.32	470.52	469.74	470.33	3042189.0
2023-12-15 11:30:00	SPY	ETF	470.33	470.5	469.825	470.0799	2740407.0
2023-12-15 12:00:00	SPY	ETF	470.08	470.405	469.79	470.3	2319863.0
2023-12-15 12:30:00	SPY	ETF	470.31	470.34	469.27	469.355	3448709.0
2023-12-15 13:00:00	SPY	ETF	469.35	469.8	469.27	469.79	3179926.0
2023-12-15 13:30:00	SPY	ETF	469.79	469.95	468.44	468.68	4648384.0
2023-12-15 14:00:00	SPY	ETF	468.68	469.16	468.465	468.49	4000953.0
2023-12-15 14:30:00	SPY	ETF	468.49	469.29	468.48	468.99	3336556.0
2023-12-15 15:00:00	SPY	ETF	468.99	469.56	468.83	469.405	3722807.0
2023-12-15 15:30:00	SPY	ETF	469.405	470.7	468.94	469.37	21759648.0
2023-12-15 16:00:00	SPY	ETF	469.36	470.5382	469.32	469.87	7964313.0
2023-12-15 16:30:00	SPY	ETF	469.86	469.93	469.65	469.68	401450.0
2023-12-15 17:00:00	SPY	ETF	469.67	469.99	469.67	469.8	86715.0
2023-12-15 17:30:00	SPY	ETF	469.8299	469.85	469.69	469.79	6762.0
2023-12-15 18:00:00	SPY	ETF	469.77	469.9399	469.4	469.65	82723.0
2023-12-15 18:30:00	SPY	ETF	469.65	470.15	469.4	470.0	158257.0
2023-12-15 19:00:00	SPY	ETF	470.0	470.05	469.9401	470.0	2967.0
2023-12-15 19:30:00	SPY	ETF	469.95	470.1	469.95	470.1	12084.0
2023-12-15 04:00:00	QQQ	ETF	404.0	404.71	404.0	404.68	23125.0
2023-12-15 04:30:00	QQQ	ETF	404.7	404.81	404.59	404.81	15233.0
2023-12-15 05:00:00	QQQ	ETF	404.8	404.86	404.67	404.8	16726.0
2023-12-15 05:30:00	QQQ	ETF	404.75	404.75	404.4	404.52	14824.0
2023-12-15 06:00:00	QQQ	ETF	404.54	404.91	404.45	404.76	26221.0
2023-12-15 06:30:00	QQQ	ETF	404.81	404.88	404.7	404.75	10895.0
2023-12-15 07:00:00	QQQ	ETF	404.75	404.8	404.6	404.68	87097.0
2023-12-15 07:30:00	QQQ	ETF	404.76	404.83	404.36	404.46	55831.0
2023-12-15 08:00:00	QQQ	ETF	404.7	404.8187	403.692	404.6104	134644.0
2023-12-15 08:30:00	QQQ	ETF	404.66	404.8	403.51	404.27	445067.0
2023-12-15 09:00:00	QQQ	ETF	404.29	404.98	403.39	404.19	1653990.0
2023-12-15 09:30:00	QQQ	ETF	404.18	405.57	403.8	405.0	4793276.0
2023-12-15 10:00:00	QQQ	ETF	405.01	406.05	404.71	405.99	3009455.0
2023-12-15 10:30:00	QQQ	ETF	405.99	406.29	405.52	405.87	2260260.0
2023-12-15 11:00:00	QQQ	ETF	405.88	406.355	405.38	406.29	1745211.0
2023-12-15 11:30:00	QQQ	ETF	406.29	406.5399	405.66	405.97	2178284.0
2023-12-15 12:00:00	QQQ	ETF	405.98	406.15	405.43	405.99	1570895.0
2023-12-15 12:30:00	QQQ	ETF	406.0	406.02	404.435	404.505	2062146.0

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

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