PREVIEW / etf_30min / 2024-10-28

all etf 30-min files

  file:    by_date/etf_30min/2024/2024-10-28.parquet
  size:    858 KB
  rows:    34,735

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-10-28 04:00:00	SPY	ETF	581.22	582.38	581.22	582.3	67841.0
2024-10-28 04:30:00	SPY	ETF	582.3	582.79	582.29	582.65	13770.0
2024-10-28 05:00:00	SPY	ETF	582.58	582.75	582.35	582.39	10247.0
2024-10-28 05:30:00	SPY	ETF	582.4	582.79	582.4	582.79	9469.0
2024-10-28 06:00:00	SPY	ETF	582.8	582.98	582.57	582.63	14772.0
2024-10-28 06:30:00	SPY	ETF	582.68	582.71	582.19	582.2	15945.0
2024-10-28 07:00:00	SPY	ETF	582.2	582.26	581.43	581.99	291325.0
2024-10-28 07:30:00	SPY	ETF	581.95	582.0	581.65	581.67	70393.0
2024-10-28 08:00:00	SPY	ETF	581.91	582.35	581.02	581.32	159112.0
2024-10-28 08:30:00	SPY	ETF	581.3	582.58	581.3	582.42	125894.0
2024-10-28 09:00:00	SPY	ETF	582.53	582.7	582.21	582.54	154418.0
2024-10-28 09:30:00	SPY	ETF	582.54	582.71	581.35	581.49	3301473.0
2024-10-28 10:00:00	SPY	ETF	581.515	582.49	581.24	582.41	1755833.0
2024-10-28 10:30:00	SPY	ETF	582.4	582.5	581.77	581.9201	959413.0
2024-10-28 11:00:00	SPY	ETF	581.96	582.05	581.23	581.59	1019496.0
2024-10-28 11:30:00	SPY	ETF	581.58	581.63	580.68	580.92	968630.0
2024-10-28 12:00:00	SPY	ETF	580.9	581.72	580.57	581.535	718223.0
2024-10-28 12:30:00	SPY	ETF	581.54	581.6399	580.72	581.02	853379.0
2024-10-28 13:00:00	SPY	ETF	581.01	581.61	580.6	581.33	749710.0
2024-10-28 13:30:00	SPY	ETF	581.36	581.87	581.28	581.68	770760.0
2024-10-28 14:00:00	SPY	ETF	581.69	581.84	581.245	581.32	1183060.0
2024-10-28 14:30:00	SPY	ETF	581.33	581.78	580.8601	581.14	1179471.0
2024-10-28 15:00:00	SPY	ETF	581.11	581.555	580.79	581.4525	1108822.0
2024-10-28 15:30:00	SPY	ETF	581.48	581.7099	580.52	580.77	4629556.0
2024-10-28 16:00:00	SPY	ETF	580.78	581.29	580.63	580.99	2095957.0
2024-10-28 16:30:00	SPY	ETF	580.97	581.18	580.95	580.96	93786.0
2024-10-28 17:00:00	SPY	ETF	580.9787	581.02	580.95	581.01	15164.0
2024-10-28 17:30:00	SPY	ETF	581.0425	581.1	580.95	581.09	10159.0
2024-10-28 18:00:00	SPY	ETF	581.04	581.06	580.49	580.5	36973.0
2024-10-28 18:30:00	SPY	ETF	580.52	580.69	580.52	580.6	3276.0
2024-10-28 19:00:00	SPY	ETF	580.7	580.8	580.61	580.71	6076.0
2024-10-28 19:30:00	SPY	ETF	580.71	580.73	580.54	580.73	3788.0
2024-10-28 04:00:00	QQQ	ETF	498.0	499.0	498.0	499.0	52196.0
2024-10-28 04:30:00	QQQ	ETF	498.93	499.45	498.93	499.35	20869.0
2024-10-28 05:00:00	QQQ	ETF	499.23	499.43	498.89	499.1	17145.0
2024-10-28 05:30:00	QQQ	ETF	499.08	499.5	499.08	499.5	8844.0
2024-10-28 06:00:00	QQQ	ETF	499.59	499.69	499.08	499.08	39021.0
2024-10-28 06:30:00	QQQ	ETF	499.15	499.3	498.68	498.73	38524.0
2024-10-28 07:00:00	QQQ	ETF	498.62	498.77	498.18	498.42	74304.0
2024-10-28 07:30:00	QQQ	ETF	498.31	498.64	498.15	498.33	54202.0
2024-10-28 08:00:00	QQQ	ETF	498.22	499.374	495.691	498.05	176771.0
2024-10-28 08:30:00	QQQ	ETF	497.95	499.2899	497.95	499.25	118493.0
2024-10-28 09:00:00	QQQ	ETF	499.3	499.4	498.31	498.5	119220.0
2024-10-28 09:30:00	QQQ	ETF	498.46	498.52	496.15	496.73	2109863.0
2024-10-28 10:00:00	QQQ	ETF	496.75	497.99	496.74	497.81	1033949.0
2024-10-28 10:30:00	QQQ	ETF	497.82	498.23	497.01	497.22	884474.0
2024-10-28 11:00:00	QQQ	ETF	497.3	497.32	496.21	496.865	948367.0
2024-10-28 11:30:00	QQQ	ETF	496.86	496.9099	495.94	496.2075	841765.0
2024-10-28 12:00:00	QQQ	ETF	496.19	497.12	495.825	496.81	929045.0
2024-10-28 12:30:00	QQQ	ETF	496.8	496.84	495.88	496.19	794104.0

> showing 50 of 34,735 rows — these rows as CSV

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