PREVIEW / etf_30min / 2023-12-13

all etf 30-min files

  file:    by_date/etf_30min/2023/2023-12-13.parquet
  size:    798 KB
  rows:    31,655

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-13 04:00:00	SPY	ETF	464.88	464.92	464.68	464.83	10411.0
2023-12-13 04:30:00	SPY	ETF	464.75	464.83	464.68	464.73	3633.0
2023-12-13 05:00:00	SPY	ETF	464.7	464.7	464.6	464.6	1273.0
2023-12-13 05:30:00	SPY	ETF	464.66	464.78	464.58	464.77	1600.0
2023-12-13 06:00:00	SPY	ETF	464.65	464.86	464.59	464.84	4209.0
2023-12-13 06:30:00	SPY	ETF	464.83	464.9	464.72	464.76	4295.0
2023-12-13 07:00:00	SPY	ETF	464.75	464.82	464.61	464.66	37916.0
2023-12-13 07:30:00	SPY	ETF	464.65	464.75	464.58	464.6	52772.0
2023-12-13 08:00:00	SPY	ETF	464.72	464.84	464.58	464.84	121807.0
2023-12-13 08:30:00	SPY	ETF	464.84	465.36	464.1	465.27	258476.0
2023-12-13 09:00:00	SPY	ETF	465.26	465.3	464.42	464.49	139389.0
2023-12-13 09:30:00	SPY	ETF	464.49	464.855	464.3	464.475	3862480.0
2023-12-13 10:00:00	SPY	ETF	464.475	464.91	464.24	464.83	2746068.0
2023-12-13 10:30:00	SPY	ETF	464.83	465.31	464.74	465.15	2298389.0
2023-12-13 11:00:00	SPY	ETF	465.145	465.335	464.85	464.885	2114255.0
2023-12-13 11:30:00	SPY	ETF	464.89	465.05	464.61	464.64	1539411.0
2023-12-13 12:00:00	SPY	ETF	464.65	464.705	464.44	464.53	1476836.0
2023-12-13 12:30:00	SPY	ETF	464.525	464.62	464.34	464.48	1785597.0
2023-12-13 13:00:00	SPY	ETF	464.495	464.51	464.12	464.18	1683705.0
2023-12-13 13:30:00	SPY	ETF	464.18	464.69	464.125	464.42	2308398.0
2023-12-13 14:00:00	SPY	ETF	464.37	467.84	464.37	467.4501	12300602.0
2023-12-13 14:30:00	SPY	ETF	467.45	470.1	467.05	469.78	10606095.0
2023-12-13 15:00:00	SPY	ETF	469.785	470.7599	468.13	468.865	10544951.0
2023-12-13 15:30:00	SPY	ETF	468.86	470.54	468.48	470.44	12898535.0
2023-12-13 16:00:00	SPY	ETF	470.44	470.7	465.0062	470.48	4883078.0
2023-12-13 16:30:00	SPY	ETF	470.48	473.38	470.23	470.23	401784.0
2023-12-13 17:00:00	SPY	ETF	470.2202	470.5	470.13	470.43	154649.0
2023-12-13 17:30:00	SPY	ETF	470.42	470.63	470.42	470.54	104400.0
2023-12-13 18:00:00	SPY	ETF	470.56	470.95	470.46	470.95	166514.0
2023-12-13 18:30:00	SPY	ETF	470.96	471.33	470.46	471.3	103526.0
2023-12-13 19:00:00	SPY	ETF	471.32	471.91	471.32	471.84	152595.0
2023-12-13 19:30:00	SPY	ETF	471.9	472.08	471.83	472.03	97736.0
2023-12-13 04:00:00	QQQ	ETF	399.52	399.61	399.32	399.41	22236.0
2023-12-13 04:30:00	QQQ	ETF	399.43	399.5	399.39	399.41	11154.0
2023-12-13 05:00:00	QQQ	ETF	399.37	399.4	399.23	399.27	9853.0
2023-12-13 05:30:00	QQQ	ETF	399.3	399.46	399.23	399.36	9680.0
2023-12-13 06:00:00	QQQ	ETF	399.35	399.58	399.34	399.58	6544.0
2023-12-13 06:30:00	QQQ	ETF	399.62	399.71	399.57	399.65	8452.0
2023-12-13 07:00:00	QQQ	ETF	399.65	399.73	399.5	399.53	58412.0
2023-12-13 07:30:00	QQQ	ETF	399.53	399.65	399.5	399.55	49889.0
2023-12-13 08:00:00	QQQ	ETF	399.71	399.74	398.969	399.6	151835.0
2023-12-13 08:30:00	QQQ	ETF	399.65	400.37	399.63	400.14	262231.0
2023-12-13 09:00:00	QQQ	ETF	400.15	400.25	399.45	399.53	256060.0
2023-12-13 09:30:00	QQQ	ETF	399.63	400.79	399.36	399.68	4314471.0
2023-12-13 10:00:00	QQQ	ETF	399.68	400.32	399.49	400.091	1870935.0
2023-12-13 10:30:00	QQQ	ETF	400.1	400.56	399.83	400.1	1420047.0
2023-12-13 11:00:00	QQQ	ETF	400.105	400.38	399.41	399.6	1569807.0
2023-12-13 11:30:00	QQQ	ETF	399.61	399.89	399.34	399.43	849073.0
2023-12-13 12:00:00	QQQ	ETF	399.45	399.69	399.17	399.5	935558.0
2023-12-13 12:30:00	QQQ	ETF	399.5	399.545	399.1303	399.24	912310.0

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

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