PREVIEW / etf_30min / 2023-02-17

all etf 30-min files

  file:    by_date/etf_30min/2023/2023-02-17.parquet
  size:    687 KB
  rows:    27,251

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-02-17 04:00:00	SPY	ETF	405.84	406.07	405.37	406.07	28572.0
2023-02-17 04:30:00	SPY	ETF	406.14	406.49	405.86	405.96	13557.0
2023-02-17 05:00:00	SPY	ETF	406.07	406.07	405.45	406.04	20068.0
2023-02-17 05:30:00	SPY	ETF	405.78	405.92	405.37	405.37	13803.0
2023-02-17 06:00:00	SPY	ETF	405.37	405.73	405.05	405.64	86644.0
2023-02-17 06:30:00	SPY	ETF	405.57	405.57	405.19	405.53	100888.0
2023-02-17 07:00:00	SPY	ETF	405.54	406.04	405.46	405.63	270084.0
2023-02-17 07:30:00	SPY	ETF	405.62	406.26	405.43	406.1	122610.0
2023-02-17 08:00:00	SPY	ETF	406.0	406.55	404.94	405.63	349304.0
2023-02-17 08:30:00	SPY	ETF	405.69	408.3431	405.63	406.19	454347.0
2023-02-17 09:00:00	SPY	ETF	406.16	406.71	406.05	406.09	350394.0
2023-02-17 09:30:00	SPY	ETF	406.06	406.81	404.18	404.74	8446901.0
2023-02-17 10:00:00	SPY	ETF	404.75	407.04	404.68	405.91	6051321.0
2023-02-17 10:30:00	SPY	ETF	405.89	407.23	404.8	404.94	3921359.0
2023-02-17 11:00:00	SPY	ETF	404.935	405.37	404.24	404.47	3263786.0
2023-02-17 11:30:00	SPY	ETF	404.47	405.52	404.12	404.8	3664390.0
2023-02-17 12:00:00	SPY	ETF	404.79	405.9808	404.77	405.4799	2966656.0
2023-02-17 12:30:00	SPY	ETF	405.4601	405.5312	404.05	404.4699	2648765.0
2023-02-17 13:00:00	SPY	ETF	404.47	405.46	404.25	404.67	3654815.0
2023-02-17 13:30:00	SPY	ETF	404.6691	405.31	404.41	405.16	2385209.0
2023-02-17 14:00:00	SPY	ETF	405.17	406.33	405.1	406.075	4336556.0
2023-02-17 14:30:00	SPY	ETF	406.07	407.25	406.04	407.089	4022308.0
2023-02-17 15:00:00	SPY	ETF	407.11	407.51	406.3787	406.54	4183284.0
2023-02-17 15:30:00	SPY	ETF	406.535	407.47	406.38	407.24	8943000.0
2023-02-17 16:00:00	SPY	ETF	407.24	407.34	406.95	407.03	3113056.0
2023-02-17 16:30:00	SPY	ETF	407.04	408.04	406.96	407.07	730455.0
2023-02-17 17:00:00	SPY	ETF	407.11	407.26	407.05	407.15	274498.0
2023-02-17 17:30:00	SPY	ETF	407.21	407.21	407.0	407.1716	59335.0
2023-02-17 18:00:00	SPY	ETF	407.08	407.08	406.94	407.07	22277.0
2023-02-17 18:30:00	SPY	ETF	407.26	407.26	407.07	407.2	47480.0
2023-02-17 19:00:00	SPY	ETF	407.25	407.28	407.21	407.27	6390.0
2023-02-17 19:30:00	SPY	ETF	407.26	407.6	407.21	407.38	21883.0
2023-02-17 04:00:00	QQQ	ETF	300.73	301.38	300.49	301.03	76281.0
2023-02-17 04:30:00	QQQ	ETF	301.16	301.52	300.77	300.83	37711.0
2023-02-17 05:00:00	QQQ	ETF	300.95	300.96	300.4	300.82	49126.0
2023-02-17 05:30:00	QQQ	ETF	300.77	300.77	300.34	300.34	11803.0
2023-02-17 06:00:00	QQQ	ETF	300.31	300.71	300.01	300.67	52649.0
2023-02-17 06:30:00	QQQ	ETF	300.59	300.59	300.15	300.54	39354.0
2023-02-17 07:00:00	QQQ	ETF	300.62	301.05	300.58	300.7	166262.0
2023-02-17 07:30:00	QQQ	ETF	300.67	301.2	300.52	300.9	135241.0
2023-02-17 08:00:00	QQQ	ETF	300.75	301.57	300.0	300.62	367300.0
2023-02-17 08:30:00	QQQ	ETF	300.62	301.36	300.62	301.13	292195.0
2023-02-17 09:00:00	QQQ	ETF	301.04	301.82	300.94	301.15	610757.0
2023-02-17 09:30:00	QQQ	ETF	301.07	301.93	298.88	299.67	6700077.0
2023-02-17 10:00:00	QQQ	ETF	299.66	301.42	299.56	300.22	4298168.0
2023-02-17 10:30:00	QQQ	ETF	300.18	301.5695	299.33	299.405	2825011.0
2023-02-17 11:00:00	QQQ	ETF	299.39	299.86	298.64	298.79	2228458.0
2023-02-17 11:30:00	QQQ	ETF	298.81	299.62	298.34	299.0094	2731167.0
2023-02-17 12:00:00	QQQ	ETF	299.0	300.09	298.99	299.22	2284211.0
2023-02-17 12:30:00	QQQ	ETF	299.18	299.2955	298.1	298.5	1754862.0

> showing 50 of 27,251 rows — these rows as CSV

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