PREVIEW / etf_30min / 2024-10-17

all etf 30-min files

  file:    by_date/etf_30min/2024/2024-10-17.parquet
  size:    854 KB
  rows:    33,979

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-17 04:00:00	SPY	ETF	583.0	584.0	583.0	584.0	25550.0
2024-10-17 04:30:00	SPY	ETF	584.19	584.52	584.11	584.52	14548.0
2024-10-17 05:00:00	SPY	ETF	584.5	584.7	584.45	584.47	30078.0
2024-10-17 05:30:00	SPY	ETF	584.35	584.9	584.33	584.79	11170.0
2024-10-17 06:00:00	SPY	ETF	584.72	584.9	584.67	584.8	17397.0
2024-10-17 06:30:00	SPY	ETF	584.83	585.05	584.52	584.95	37084.0
2024-10-17 07:00:00	SPY	ETF	584.95	585.0	584.4	584.8	227613.0
2024-10-17 07:30:00	SPY	ETF	584.75	584.86	584.55	584.64	76428.0
2024-10-17 08:00:00	SPY	ETF	584.84	585.34	581.07	584.9837	158644.0
2024-10-17 08:30:00	SPY	ETF	585.1	585.5565	584.85	585.46	194177.0
2024-10-17 09:00:00	SPY	ETF	585.51	586.3	585.49	585.95	254626.0
2024-10-17 09:30:00	SPY	ETF	585.91	586.12	583.2	584.06	4232320.0
2024-10-17 10:00:00	SPY	ETF	584.1	584.4286	582.845	583.87	1975925.0
2024-10-17 10:30:00	SPY	ETF	583.86	584.03	582.95	583.0974	1056738.0
2024-10-17 11:00:00	SPY	ETF	583.1	584.059	582.37	584.02	1116858.0
2024-10-17 11:30:00	SPY	ETF	584.03	584.75	583.88	584.72	902209.0
2024-10-17 12:00:00	SPY	ETF	584.705	585.0	584.16	584.29	850346.0
2024-10-17 12:30:00	SPY	ETF	584.27	584.625	583.73	584.3703	652087.0
2024-10-17 13:00:00	SPY	ETF	584.39	584.72	584.08	584.215	729478.0
2024-10-17 13:30:00	SPY	ETF	584.21	584.7	584.11	584.35	580970.0
2024-10-17 14:00:00	SPY	ETF	584.37	584.42	582.48	582.6404	1632149.0
2024-10-17 14:30:00	SPY	ETF	582.633	583.3444	582.42	583.32	1228814.0
2024-10-17 15:00:00	SPY	ETF	583.32	583.4	582.57	582.58	1188237.0
2024-10-17 15:30:00	SPY	ETF	582.58	582.74	582.16	582.28	4317538.0
2024-10-17 16:00:00	SPY	ETF	582.28	583.4983	582.18	582.53	2947804.0
2024-10-17 16:30:00	SPY	ETF	582.5	582.59	582.42	582.42	95447.0
2024-10-17 17:00:00	SPY	ETF	582.49	582.6	582.42	582.52	33789.0
2024-10-17 17:30:00	SPY	ETF	582.57	582.6	582.47	582.55	8123.0
2024-10-17 18:00:00	SPY	ETF	582.43	582.8	582.35	582.78	23501.0
2024-10-17 18:30:00	SPY	ETF	582.79	582.99	582.79	582.85	13105.0
2024-10-17 19:00:00	SPY	ETF	582.801	582.85	582.8	582.82	6988.0
2024-10-17 19:30:00	SPY	ETF	582.84	582.94	582.8314	582.9	16650.0
2024-10-17 04:00:00	QQQ	ETF	492.12	494.01	492.12	494.01	43676.0
2024-10-17 04:30:00	QQQ	ETF	494.02	494.56	494.0	494.43	25600.0
2024-10-17 05:00:00	QQQ	ETF	494.56	494.82	494.28	494.33	21772.0
2024-10-17 05:30:00	QQQ	ETF	494.14	494.63	493.98	494.44	27429.0
2024-10-17 06:00:00	QQQ	ETF	494.43	495.07	494.43	494.93	22178.0
2024-10-17 06:30:00	QQQ	ETF	495.0	495.53	494.9	495.44	58412.0
2024-10-17 07:00:00	QQQ	ETF	495.37	495.37	494.86	495.0	164992.0
2024-10-17 07:30:00	QQQ	ETF	494.95	495.22	494.8	495.11	99201.0
2024-10-17 08:00:00	QQQ	ETF	495.1	495.52	489.7	495.09	237167.0
2024-10-17 08:30:00	QQQ	ETF	495.24	496.11	495.06	496.11	314560.0
2024-10-17 09:00:00	QQQ	ETF	496.12	496.93	496.112	496.44	275906.0
2024-10-17 09:30:00	QQQ	ETF	496.42	496.49	492.34	493.07	4497116.0
2024-10-17 10:00:00	QQQ	ETF	493.13	493.83	491.5401	493.3699	2147043.0
2024-10-17 10:30:00	QQQ	ETF	493.4163	493.6201	491.79	492.32	1212787.0
2024-10-17 11:00:00	QQQ	ETF	492.34	493.65	491.57	493.59	1232123.0
2024-10-17 11:30:00	QQQ	ETF	493.57	494.93	493.4004	494.88	972800.0
2024-10-17 12:00:00	QQQ	ETF	494.87	495.35	494.05	494.285	1062100.0
2024-10-17 12:30:00	QQQ	ETF	494.28	494.44	493.45	493.89	915615.0

> showing 50 of 33,979 rows — these rows as CSV

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