PREVIEW / etf_30min / 2024-11-13

all etf 30-min files

  file:    by_date/etf_30min/2024/2024-11-13.parquet
  size:    922 KB
  rows:    36,594

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-11-13 04:00:00	SPY	ETF	596.4	596.49	596.29	596.36	12751.0
2024-11-13 04:30:00	SPY	ETF	596.45	596.71	596.45	596.56	8998.0
2024-11-13 05:00:00	SPY	ETF	596.69	596.69	596.19	596.23	2819.0
2024-11-13 05:30:00	SPY	ETF	596.16	596.18	595.98	596.0	3049.0
2024-11-13 06:00:00	SPY	ETF	595.78	595.99	595.7	595.85	5001.0
2024-11-13 06:30:00	SPY	ETF	595.79	595.79	595.42	595.5	30586.0
2024-11-13 07:00:00	SPY	ETF	595.42	596.23	595.39	596.14	55229.0
2024-11-13 07:30:00	SPY	ETF	596.14	596.14	595.49	595.85	72177.0
2024-11-13 08:00:00	SPY	ETF	595.5001	596.2	595.23	596.1	189684.0
2024-11-13 08:30:00	SPY	ETF	596.0	598.731	596.0	597.15	760964.0
2024-11-13 09:00:00	SPY	ETF	597.13	597.7	596.87	597.36	308119.0
2024-11-13 09:30:00	SPY	ETF	597.32	597.72	596.3404	597.1	2546060.0
2024-11-13 10:00:00	SPY	ETF	597.1399	597.1399	594.96	596.32	1945843.0
2024-11-13 10:30:00	SPY	ETF	596.35	597.38	596.05	597.15	1726338.0
2024-11-13 11:00:00	SPY	ETF	597.17	598.14	596.66	597.98	1022298.0
2024-11-13 11:30:00	SPY	ETF	597.97	598.33	597.22	598.07	1392937.0
2024-11-13 12:00:00	SPY	ETF	598.07	599.06	597.93	598.46	1104185.0
2024-11-13 12:30:00	SPY	ETF	598.45	599.18	598.29	599.13	1403871.0
2024-11-13 13:00:00	SPY	ETF	599.13	599.23	598.3443	598.76	1083056.0
2024-11-13 13:30:00	SPY	ETF	598.755	599.15	598.53	598.91	1030447.0
2024-11-13 14:00:00	SPY	ETF	598.9	598.934	597.8	597.9425	1322742.0
2024-11-13 14:30:00	SPY	ETF	597.92	598.01	597.02	597.21	1535076.0
2024-11-13 15:00:00	SPY	ETF	597.21	598.14	596.685	597.59	2128432.0
2024-11-13 15:30:00	SPY	ETF	597.57	598.54	596.48	597.17	7955606.0
2024-11-13 16:00:00	SPY	ETF	597.19	597.69	596.93	597.68	2509510.0
2024-11-13 16:30:00	SPY	ETF	597.68	597.9	597.19	597.41	176824.0
2024-11-13 17:00:00	SPY	ETF	597.4	597.53	597.26	597.39	79988.0
2024-11-13 17:30:00	SPY	ETF	597.3901	597.43	597.31	597.42	27054.0
2024-11-13 18:00:00	SPY	ETF	597.42	597.56	596.9284	597.54	390536.0
2024-11-13 18:30:00	SPY	ETF	597.55	597.8	597.48	597.67	15044.0
2024-11-13 19:00:00	SPY	ETF	597.76	597.8199	597.07	597.39	25121.0
2024-11-13 19:30:00	SPY	ETF	597.4	597.52	597.29	597.42	18960.0
2024-11-13 04:00:00	QQQ	ETF	512.82	512.9	512.51	512.57	22853.0
2024-11-13 04:30:00	QQQ	ETF	512.67	512.9	512.63	512.68	5225.0
2024-11-13 05:00:00	QQQ	ETF	512.87	512.92	512.38	512.38	27217.0
2024-11-13 05:30:00	QQQ	ETF	512.31	512.5	512.21	512.34	12249.0
2024-11-13 06:00:00	QQQ	ETF	512.17	512.19	511.9	512.01	14645.0
2024-11-13 06:30:00	QQQ	ETF	512.0	512.0	511.62	511.67	15137.0
2024-11-13 07:00:00	QQQ	ETF	511.66	512.35	511.55	512.21	49793.0
2024-11-13 07:30:00	QQQ	ETF	512.21	512.21	511.42	511.76	29661.0
2024-11-13 08:00:00	QQQ	ETF	511.72	513.284	511.15	512.1	162736.0
2024-11-13 08:30:00	QQQ	ETF	512.02	514.45	511.98	512.8	345131.0
2024-11-13 09:00:00	QQQ	ETF	512.79	513.35	512.41	512.41	173014.0
2024-11-13 09:30:00	QQQ	ETF	512.4	513.04	511.51	511.96	1719103.0
2024-11-13 10:00:00	QQQ	ETF	511.89	511.91	509.95	510.98	1456123.0
2024-11-13 10:30:00	QQQ	ETF	510.98	511.93	510.6425	511.36	955656.0
2024-11-13 11:00:00	QQQ	ETF	511.37	512.53	510.77	512.2828	617706.0
2024-11-13 11:30:00	QQQ	ETF	512.26	512.79	511.025	512.52	887097.0
2024-11-13 12:00:00	QQQ	ETF	512.52	513.7	512.35	513.0518	1109229.0
2024-11-13 12:30:00	QQQ	ETF	513.07	514.11	512.64	514.015	818306.0

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

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