PREVIEW / etf_30min / 2023-12-11

all etf 30-min files

  file:    by_date/etf_30min/2023/2023-12-11.parquet
  size:    776 KB
  rows:    30,332

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-11 04:00:00	SPY	ETF	459.82	460.4	459.69	460.35	9477.0
2023-12-11 04:30:00	SPY	ETF	460.38	460.38	459.96	459.96	8586.0
2023-12-11 05:00:00	SPY	ETF	459.9	460.13	459.87	459.87	4153.0
2023-12-11 05:30:00	SPY	ETF	459.81	460.06	459.69	459.69	7965.0
2023-12-11 06:00:00	SPY	ETF	459.68	459.88	459.41	459.6	13451.0
2023-12-11 06:30:00	SPY	ETF	459.63	459.98	459.63	459.98	17974.0
2023-12-11 07:00:00	SPY	ETF	459.95	460.11	459.85	459.96	22266.0
2023-12-11 07:30:00	SPY	ETF	460.01	460.05	459.8	460.05	35681.0
2023-12-11 08:00:00	SPY	ETF	460.05	460.2796	459.41	459.92	60720.0
2023-12-11 08:30:00	SPY	ETF	459.91	460.0	459.73	459.94	106630.0
2023-12-11 09:00:00	SPY	ETF	459.92	460.13	459.55	459.7	191074.0
2023-12-11 09:30:00	SPY	ETF	459.69	460.42	459.47	460.405	5991675.0
2023-12-11 10:00:00	SPY	ETF	460.4	460.58	459.95	460.2	3420063.0
2023-12-11 10:30:00	SPY	ETF	460.205	461.16	460.09	460.79	3917018.0
2023-12-11 11:00:00	SPY	ETF	460.795	461.23	460.04	460.48	3768506.0
2023-12-11 11:30:00	SPY	ETF	460.49	460.57	459.905	460.53	2578302.0
2023-12-11 12:00:00	SPY	ETF	460.53	460.81	460.3034	460.68	1953805.0
2023-12-11 12:30:00	SPY	ETF	460.7	461.02	460.58	460.9603	1719587.0
2023-12-11 13:00:00	SPY	ETF	460.965	461.6	460.655	461.465	2819531.0
2023-12-11 13:30:00	SPY	ETF	461.47	461.7487	461.415	461.6408	1898282.0
2023-12-11 14:00:00	SPY	ETF	461.64	461.85	461.46	461.73	1883832.0
2023-12-11 14:30:00	SPY	ETF	461.745	461.83	461.44	461.54	2041289.0
2023-12-11 15:00:00	SPY	ETF	461.545	461.825	461.3396	461.48	3060863.0
2023-12-11 15:30:00	SPY	ETF	461.48	462.17	461.4	461.97	8549610.0
2023-12-11 16:00:00	SPY	ETF	461.96	462.14	461.4146	462.04	3362595.0
2023-12-11 16:30:00	SPY	ETF	462.03	462.05	461.9	461.95	177743.0
2023-12-11 17:00:00	SPY	ETF	462.0	462.0	461.87	461.95	353713.0
2023-12-11 17:30:00	SPY	ETF	461.97	461.99	461.85	461.99	337046.0
2023-12-11 18:00:00	SPY	ETF	461.92	462.0	456.99	461.89	835571.0
2023-12-11 18:30:00	SPY	ETF	461.91	462.06	461.91	462.03	24163.0
2023-12-11 19:00:00	SPY	ETF	462.06	462.42	462.01	462.26	41076.0
2023-12-11 19:30:00	SPY	ETF	462.25	462.3	462.12	462.3	20815.0
2023-12-11 04:00:00	QQQ	ETF	391.4	392.01	391.28	391.97	23144.0
2023-12-11 04:30:00	QQQ	ETF	391.98	391.99	391.57	391.6	13014.0
2023-12-11 05:00:00	QQQ	ETF	391.56	391.81	391.5	391.5	13948.0
2023-12-11 05:30:00	QQQ	ETF	391.47	391.7	391.3	391.31	10483.0
2023-12-11 06:00:00	QQQ	ETF	391.32	391.5	390.96	391.23	15122.0
2023-12-11 06:30:00	QQQ	ETF	391.28	391.56	391.2	391.5	21024.0
2023-12-11 07:00:00	QQQ	ETF	391.54	391.92	391.54	391.7	33066.0
2023-12-11 07:30:00	QQQ	ETF	391.7	391.75	391.44	391.74	55736.0
2023-12-11 08:00:00	QQQ	ETF	391.5397	392.464	391.14	391.49	85392.0
2023-12-11 08:30:00	QQQ	ETF	391.45	391.86	391.3173	391.7735	63070.0
2023-12-11 09:00:00	QQQ	ETF	391.81	392.13	391.54	391.69	259562.0
2023-12-11 09:30:00	QQQ	ETF	391.73	393.81	391.53	393.73	6451217.0
2023-12-11 10:00:00	QQQ	ETF	393.73	394.06	393.3	393.37	2891677.0
2023-12-11 10:30:00	QQQ	ETF	393.38	394.6697	393.12	394.1203	2436212.0
2023-12-11 11:00:00	QQQ	ETF	394.13	394.35	393.045	393.53	2557635.0
2023-12-11 11:30:00	QQQ	ETF	393.54	393.81	392.8	393.7687	1730652.0
2023-12-11 12:00:00	QQQ	ETF	393.76	394.45	393.41	394.3999	1429269.0
2023-12-11 12:30:00	QQQ	ETF	394.4	394.78	394.28	394.73	1237457.0

> showing 50 of 30,332 rows — these rows as CSV

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