PREVIEW / etf_30min / 2024-12-06

all etf 30-min files

  file:    by_date/etf_30min/2024/2024-12-06.parquet
  size:    915 KB
  rows:    36,034

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-12-06 04:00:00	SPY	ETF	606.39	606.75	606.36	606.59	14926.0
2024-12-06 04:30:00	SPY	ETF	606.53	606.68	606.5	606.5	2000.0
2024-12-06 05:00:00	SPY	ETF	606.39	606.44	606.3	606.44	4629.0
2024-12-06 05:30:00	SPY	ETF	606.5	606.5	606.07	606.07	1677.0
2024-12-06 06:00:00	SPY	ETF	606.19	606.19	605.85	606.03	8044.0
2024-12-06 06:30:00	SPY	ETF	606.07	606.26	605.95	606.26	2621.0
2024-12-06 07:00:00	SPY	ETF	606.23	606.66	606.23	606.66	21810.0
2024-12-06 07:30:00	SPY	ETF	606.49	606.51	606.34	606.38	18930.0
2024-12-06 08:00:00	SPY	ETF	606.4	606.6594	606.12	606.43	83456.0
2024-12-06 08:30:00	SPY	ETF	606.5	608.06	605.74	607.5	364623.0
2024-12-06 09:00:00	SPY	ETF	607.51	607.91	607.33	607.42	144964.0
2024-12-06 09:30:00	SPY	ETF	607.44	609.04	607.34	608.98	2402793.0
2024-12-06 10:00:00	SPY	ETF	608.975	609.07	608.43	608.88	1088294.0
2024-12-06 10:30:00	SPY	ETF	608.88	608.977	608.235	608.7	831824.0
2024-12-06 11:00:00	SPY	ETF	608.71	608.7499	607.56	608.0	1139003.0
2024-12-06 11:30:00	SPY	ETF	607.99	608.29	607.74	607.815	839159.0
2024-12-06 12:00:00	SPY	ETF	607.82	607.86	607.32	607.6999	829011.0
2024-12-06 12:30:00	SPY	ETF	607.7	607.74	607.06	607.36	623240.0
2024-12-06 13:00:00	SPY	ETF	607.355	608.39	607.3	608.065	766479.0
2024-12-06 13:30:00	SPY	ETF	608.065	608.0663	607.57	608.04	630333.0
2024-12-06 14:00:00	SPY	ETF	608.03	608.06	607.03	607.125	1587215.0
2024-12-06 14:30:00	SPY	ETF	607.13	607.65	607.02	607.34	982512.0
2024-12-06 15:00:00	SPY	ETF	607.32	607.7499	607.14	607.615	1060995.0
2024-12-06 15:30:00	SPY	ETF	607.62	608.12	607.45	607.88	3548935.0
2024-12-06 16:00:00	SPY	ETF	607.89	608.065	606.5454	607.63	2993353.0
2024-12-06 16:30:00	SPY	ETF	607.6	607.66	607.46	607.6	128824.0
2024-12-06 17:00:00	SPY	ETF	607.65	607.86	607.46	607.68	39268.0
2024-12-06 17:30:00	SPY	ETF	607.68	607.75	607.4	607.45	30289.0
2024-12-06 18:00:00	SPY	ETF	607.45	607.45	607.3	607.34	19753.0
2024-12-06 18:30:00	SPY	ETF	607.32	607.32	607.2	607.22	11688.0
2024-12-06 19:00:00	SPY	ETF	607.22	607.22	607.2004	607.21	8443.0
2024-12-06 19:30:00	SPY	ETF	607.25	607.38	607.25	607.37	8019.0
2024-12-06 04:00:00	QQQ	ETF	522.15	522.4	521.81	521.98	31279.0
2024-12-06 04:30:00	QQQ	ETF	521.9	522.07	521.9	521.93	6848.0
2024-12-06 05:00:00	QQQ	ETF	521.91	521.93	521.68	521.93	9402.0
2024-12-06 05:30:00	QQQ	ETF	521.88	522.0	521.47	521.47	12228.0
2024-12-06 06:00:00	QQQ	ETF	521.59	521.69	521.4	521.49	14106.0
2024-12-06 06:30:00	QQQ	ETF	521.46	521.75	521.28	521.75	9946.0
2024-12-06 07:00:00	QQQ	ETF	521.69	522.28	521.61	522.28	27571.0
2024-12-06 07:30:00	QQQ	ETF	522.22	522.22	522.0	522.15	25277.0
2024-12-06 08:00:00	QQQ	ETF	521.65	522.37	521.286	521.97	103512.0
2024-12-06 08:30:00	QQQ	ETF	521.95	523.4	521.34	522.5	446506.0
2024-12-06 09:00:00	QQQ	ETF	522.49	523.02	522.47	522.49	93599.0
2024-12-06 09:30:00	QQQ	ETF	522.46	525.4	522.35	525.24	2000587.0
2024-12-06 10:00:00	QQQ	ETF	525.28	526.19	524.9	525.87	1316386.0
2024-12-06 10:30:00	QQQ	ETF	525.885	526.03	524.94	525.53	1007994.0
2024-12-06 11:00:00	QQQ	ETF	525.57	525.88	524.42	525.55	1082070.0
2024-12-06 11:30:00	QQQ	ETF	525.5	525.95	525.12	525.42	645854.0
2024-12-06 12:00:00	QQQ	ETF	525.42	525.94	524.99	525.88	574325.0
2024-12-06 12:30:00	QQQ	ETF	525.89	525.97	525.2	525.52	550752.0

> showing 50 of 36,034 rows — these rows as CSV

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