PREVIEW / etf_30min / 2024-06-28

all etf 30-min files

  file:    by_date/etf_30min/2024/2024-06-28.parquet
  size:    805 KB
  rows:    32,319

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-06-28 04:00:00	SPY	ETF	547.78	547.99	547.6	547.98	8992.0
2024-06-28 04:30:00	SPY	ETF	548.06	548.19	547.95	548.19	2380.0
2024-06-28 05:00:00	SPY	ETF	548.12	548.4	548.11	548.38	12136.0
2024-06-28 05:30:00	SPY	ETF	548.44	548.57	548.3	548.49	13079.0
2024-06-28 06:00:00	SPY	ETF	548.39	548.47	548.24	548.38	34378.0
2024-06-28 06:30:00	SPY	ETF	548.43	548.48	548.42	548.45	14470.0
2024-06-28 07:00:00	SPY	ETF	548.45	548.48	548.02	548.27	169787.0
2024-06-28 07:30:00	SPY	ETF	548.3	548.45	548.26	548.31	38398.0
2024-06-28 08:00:00	SPY	ETF	548.35	548.66	547.51	548.55	173452.0
2024-06-28 08:30:00	SPY	ETF	548.0	549.01	547.44	547.56	270859.0
2024-06-28 09:00:00	SPY	ETF	547.64	547.76	546.92	547.13	257282.0
2024-06-28 09:30:00	SPY	ETF	547.19	548.26	546.67	548.055	3200773.0
2024-06-28 10:00:00	SPY	ETF	548.05	550.28	548.04	549.5257	4192108.0
2024-06-28 10:30:00	SPY	ETF	549.52	550.07	548.15	548.63	2321058.0
2024-06-28 11:00:00	SPY	ETF	548.62	548.63	547.25	547.7301	2671718.0
2024-06-28 11:30:00	SPY	ETF	547.74	548.32	547.54	547.72	1263872.0
2024-06-28 12:00:00	SPY	ETF	547.71	547.83	546.21	546.97	1974320.0
2024-06-28 12:30:00	SPY	ETF	546.96	547.13	545.49	546.33	2049959.0
2024-06-28 13:00:00	SPY	ETF	546.32	546.99	546.0	546.28	1476282.0
2024-06-28 13:30:00	SPY	ETF	546.28	546.47	545.85	546.03	1065981.0
2024-06-28 14:00:00	SPY	ETF	546.0234	546.58	545.24	545.39	1928188.0
2024-06-28 14:30:00	SPY	ETF	545.4	545.65	544.95	545.1	2711164.0
2024-06-28 15:00:00	SPY	ETF	545.105	545.1499	544.58	544.78	4131683.0
2024-06-28 15:30:00	SPY	ETF	544.8	545.47	542.95	544.09	13379938.0
2024-06-28 16:00:00	SPY	ETF	544.12	545.24	543.9565	545.23	6059999.0
2024-06-28 16:30:00	SPY	ETF	545.23	545.24	544.22	545.06	248464.0
2024-06-28 17:00:00	SPY	ETF	545.05	545.05	544.8	544.82	109794.0
2024-06-28 17:30:00	SPY	ETF	544.84	545.0	544.8	544.9	29086.0
2024-06-28 18:00:00	SPY	ETF	544.94	545.04	544.87	545.04	12143.0
2024-06-28 18:30:00	SPY	ETF	544.99	545.06	544.98	544.98	3856.0
2024-06-28 19:00:00	SPY	ETF	544.9804	545.1	544.93	544.95	16612.0
2024-06-28 19:30:00	SPY	ETF	545.08	545.18	545.01	545.1216	13221.0
2024-06-28 04:00:00	QQQ	ETF	483.38	483.46	482.94	483.4	21030.0
2024-06-28 04:30:00	QQQ	ETF	483.41	483.47	483.25	483.35	11456.0
2024-06-28 05:00:00	QQQ	ETF	483.5	483.72	483.43	483.65	23381.0
2024-06-28 05:30:00	QQQ	ETF	483.59	483.86	483.49	483.81	12727.0
2024-06-28 06:00:00	QQQ	ETF	483.74	483.79	483.51	483.73	13420.0
2024-06-28 06:30:00	QQQ	ETF	483.75	483.83	483.6	483.75	14938.0
2024-06-28 07:00:00	QQQ	ETF	483.72	483.76	483.54	483.63	34128.0
2024-06-28 07:30:00	QQQ	ETF	483.6	483.79	483.6	483.725	49328.0
2024-06-28 08:00:00	QQQ	ETF	483.7	484.3501	481.249	484.29	145617.0
2024-06-28 08:30:00	QQQ	ETF	484.2	485.31	482.63	482.66	380975.0
2024-06-28 09:00:00	QQQ	ETF	482.659	482.88	482.16	482.38	146360.0
2024-06-28 09:30:00	QQQ	ETF	482.41	484.27	481.67	484.24	2456793.0
2024-06-28 10:00:00	QQQ	ETF	484.24	487.2	484.24	485.79	2951176.0
2024-06-28 10:30:00	QQQ	ETF	485.79	486.555	483.56	484.07	1743451.0
2024-06-28 11:00:00	QQQ	ETF	484.07	484.07	482.56	483.1486	1835698.0
2024-06-28 11:30:00	QQQ	ETF	483.14	483.85	482.93	483.335	861675.0
2024-06-28 12:00:00	QQQ	ETF	483.32	483.48	481.25	482.42	1607073.0
2024-06-28 12:30:00	QQQ	ETF	482.41	482.5701	480.39	481.59	1301208.0

> showing 50 of 32,319 rows — these rows as CSV

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