PREVIEW / etf_30min / 2024-02-15

all etf 30-min files

  file:    by_date/etf_30min/2024/2024-02-15.parquet
  size:    819 KB
  rows:    31,791

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-02-15 04:00:00	SPY	ETF	499.7	500.26	499.7	500.01	12204.0
2024-02-15 04:30:00	SPY	ETF	499.97	499.98	499.74	499.96	34802.0
2024-02-15 05:00:00	SPY	ETF	499.95	500.04	499.69	499.8	3026.0
2024-02-15 05:30:00	SPY	ETF	499.73	499.79	499.66	499.76	1248.0
2024-02-15 06:00:00	SPY	ETF	499.78	499.99	499.73	499.81	5225.0
2024-02-15 06:30:00	SPY	ETF	499.83	499.85	499.76	499.79	13484.0
2024-02-15 07:00:00	SPY	ETF	499.79	499.99	499.66	499.9	123335.0
2024-02-15 07:30:00	SPY	ETF	499.9	500.09	499.79	499.91	22537.0
2024-02-15 08:00:00	SPY	ETF	499.8	500.23	499.3	499.61	127421.0
2024-02-15 08:30:00	SPY	ETF	499.54	500.55	499.38	499.7	319352.0
2024-02-15 09:00:00	SPY	ETF	499.68	499.75	499.03	499.32	114768.0
2024-02-15 09:30:00	SPY	ETF	499.3	500.38	499.2699	499.6499	4059855.0
2024-02-15 10:00:00	SPY	ETF	499.65	500.57	499.52	499.69	3486881.0
2024-02-15 10:30:00	SPY	ETF	499.7	499.99	499.3	499.82	2529641.0
2024-02-15 11:00:00	SPY	ETF	499.82	499.95	498.795	499.48	3251890.0
2024-02-15 11:30:00	SPY	ETF	499.48	500.15	499.35	499.805	2246209.0
2024-02-15 12:00:00	SPY	ETF	499.805	500.45	499.665	500.4399	2209756.0
2024-02-15 12:30:00	SPY	ETF	500.45	500.59	500.01	500.05	2269978.0
2024-02-15 13:00:00	SPY	ETF	500.045	501.49	499.95	501.46	3293802.0
2024-02-15 13:30:00	SPY	ETF	501.47	501.6806	500.905	501.38	2814466.0
2024-02-15 14:00:00	SPY	ETF	501.39	501.78	500.99	501.51	3136080.0
2024-02-15 14:30:00	SPY	ETF	501.505	502.2	501.424	501.84	2813987.0
2024-02-15 15:00:00	SPY	ETF	501.84	501.92	501.165	501.63	2915485.0
2024-02-15 15:30:00	SPY	ETF	501.63	502.05	501.15	501.95	9593775.0
2024-02-15 16:00:00	SPY	ETF	501.96	502.43	501.752	502.43	2141439.0
2024-02-15 16:30:00	SPY	ETF	502.42	502.5	502.24	502.36	273479.0
2024-02-15 17:00:00	SPY	ETF	502.41	502.42	502.16	502.17	67394.0
2024-02-15 17:30:00	SPY	ETF	502.18	502.26	502.01	502.2	421237.0
2024-02-15 18:00:00	SPY	ETF	502.2	502.3	502.12	502.1509	52540.0
2024-02-15 18:30:00	SPY	ETF	502.15	502.29	502.1	502.13	3815.0
2024-02-15 19:00:00	SPY	ETF	502.13	502.16	501.71	501.72	13852.0
2024-02-15 19:30:00	SPY	ETF	501.75	501.78	501.49	501.61	65315.0
2024-02-15 04:00:00	QQQ	ETF	434.7	434.72	434.05	434.37	35084.0
2024-02-15 04:30:00	QQQ	ETF	434.3	434.3	433.82	434.0	45767.0
2024-02-15 05:00:00	QQQ	ETF	434.12	434.19	433.88	434.0	5200.0
2024-02-15 05:30:00	QQQ	ETF	433.94	434.21	433.94	434.15	7151.0
2024-02-15 06:00:00	QQQ	ETF	434.18	434.4	434.18	434.28	11714.0
2024-02-15 06:30:00	QQQ	ETF	434.3	434.4	434.15	434.25	10728.0
2024-02-15 07:00:00	QQQ	ETF	434.18	434.64	434.18	434.48	58666.0
2024-02-15 07:30:00	QQQ	ETF	434.61	434.61	434.33	434.34	18644.0
2024-02-15 08:00:00	QQQ	ETF	434.24	434.78	432.896	434.08	103884.0
2024-02-15 08:30:00	QQQ	ETF	434.0	435.05	433.801	434.2	351030.0
2024-02-15 09:00:00	QQQ	ETF	434.05	434.22	433.69	433.92	73221.0
2024-02-15 09:30:00	QQQ	ETF	433.92	434.28	432.03	432.18	3514414.0
2024-02-15 10:00:00	QQQ	ETF	432.18	433.32	431.725	432.23	2947863.0
2024-02-15 10:30:00	QQQ	ETF	432.27	433.15	432.04	432.92	2242182.0
2024-02-15 11:00:00	QQQ	ETF	432.95	433.07	431.33	432.575	2618236.0
2024-02-15 11:30:00	QQQ	ETF	432.58	433.03	432.12	432.64	1590237.0
2024-02-15 12:00:00	QQQ	ETF	432.66	433.56	432.2601	433.4447	1641648.0
2024-02-15 12:30:00	QQQ	ETF	433.47	433.79	433.03	433.08	1372304.0

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

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