PREVIEW / etf_30min / 2024-06-04

all etf 30-min files

  file:    by_date/etf_30min/2024/2024-06-04.parquet
  size:    784 KB
  rows:    32,498

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-06-04 04:00:00	SPY	ETF	526.81	526.81	526.08	526.19	28641.0
2024-06-04 04:30:00	SPY	ETF	526.08	526.19	524.97	525.24	32435.0
2024-06-04 05:00:00	SPY	ETF	525.06	525.06	524.31	524.56	11980.0
2024-06-04 05:30:00	SPY	ETF	524.89	525.1	524.4	524.72	10350.0
2024-06-04 06:00:00	SPY	ETF	524.76	525.1	524.27	524.85	48494.0
2024-06-04 06:30:00	SPY	ETF	524.88	525.04	524.78	524.95	12645.0
2024-06-04 07:00:00	SPY	ETF	525.03	525.5	525.0	525.33	100486.0
2024-06-04 07:30:00	SPY	ETF	525.32	526.0	525.27	525.96	120555.0
2024-06-04 08:00:00	SPY	ETF	525.22	527.96	524.335	525.8	223982.0
2024-06-04 08:30:00	SPY	ETF	525.84	526.25	525.73	526.1	101038.0
2024-06-04 09:00:00	SPY	ETF	526.18	526.64	526.03	526.48	268232.0
2024-06-04 09:30:00	SPY	ETF	526.46	526.79	525.77	526.49	2376754.0
2024-06-04 10:00:00	SPY	ETF	526.49	527.75	525.74	527.0	2985763.0
2024-06-04 10:30:00	SPY	ETF	526.985	527.4	525.82	525.93	1717854.0
2024-06-04 11:00:00	SPY	ETF	525.97	526.615	525.62	525.86	1524572.0
2024-06-04 11:30:00	SPY	ETF	525.86	525.895	525.14	525.2501	1277145.0
2024-06-04 12:00:00	SPY	ETF	525.265	526.1	524.96	526.01	1327158.0
2024-06-04 12:30:00	SPY	ETF	526.02	526.94	525.66	526.4799	1254054.0
2024-06-04 13:00:00	SPY	ETF	526.4713	527.0	525.695	526.975	942476.0
2024-06-04 13:30:00	SPY	ETF	526.98	527.11	526.34	526.84	915443.0
2024-06-04 14:00:00	SPY	ETF	526.81	528.97	526.71	528.93	2154486.0
2024-06-04 14:30:00	SPY	ETF	528.94	529.15	528.22	528.3999	1664202.0
2024-06-04 15:00:00	SPY	ETF	528.37	528.4	526.61	527.65	2387420.0
2024-06-04 15:30:00	SPY	ETF	527.66	528.6	527.005	528.35	4523664.0
2024-06-04 16:00:00	SPY	ETF	528.35	528.58	528.02	528.43	1631022.0
2024-06-04 16:30:00	SPY	ETF	528.45	528.61	528.35	528.45	337182.0
2024-06-04 17:00:00	SPY	ETF	528.41	528.47	528.3399	528.35	27618.0
2024-06-04 17:30:00	SPY	ETF	528.34	528.39	528.3	528.36	26154.0
2024-06-04 18:00:00	SPY	ETF	528.39	528.56	528.26	528.41	45876.0
2024-06-04 18:30:00	SPY	ETF	528.41	528.78	528.39	528.751	8837.0
2024-06-04 19:00:00	SPY	ETF	528.77	529.17	528.77	528.92	23250.0
2024-06-04 19:30:00	SPY	ETF	528.93	529.13	528.88	529.1	18699.0
2024-06-04 04:00:00	QQQ	ETF	452.27	452.33	451.56	451.75	28892.0
2024-06-04 04:30:00	QQQ	ETF	451.73	451.81	450.59	450.91	45523.0
2024-06-04 05:00:00	QQQ	ETF	450.91	451.01	449.9	450.5	25083.0
2024-06-04 05:30:00	QQQ	ETF	450.54	450.87	450.09	450.53	22749.0
2024-06-04 06:00:00	QQQ	ETF	450.7	451.15	450.25	450.75	79937.0
2024-06-04 06:30:00	QQQ	ETF	450.53	451.0	450.53	450.85	18356.0
2024-06-04 07:00:00	QQQ	ETF	450.83	451.55	450.83	451.35	47559.0
2024-06-04 07:30:00	QQQ	ETF	451.35	451.89	451.27	451.78	16974.0
2024-06-04 08:00:00	QQQ	ETF	451.02	453.41	450.55	451.66	101324.0
2024-06-04 08:30:00	QQQ	ETF	451.65	452.25	451.64	452.14	105466.0
2024-06-04 09:00:00	QQQ	ETF	452.13	452.89	452.02	452.85	137989.0
2024-06-04 09:30:00	QQQ	ETF	452.85	453.15	451.44	451.98	2392418.0
2024-06-04 10:00:00	QQQ	ETF	452.0	453.46	451.1311	452.4	1913250.0
2024-06-04 10:30:00	QQQ	ETF	452.36	453.21	451.781	451.93	1177899.0
2024-06-04 11:00:00	QQQ	ETF	451.95	452.84	451.6772	451.95	1028736.0
2024-06-04 11:30:00	QQQ	ETF	451.935	452.03	451.3	451.56	837385.0
2024-06-04 12:00:00	QQQ	ETF	451.54	452.18	451.2	452.08	801446.0
2024-06-04 12:30:00	QQQ	ETF	452.08	453.15	451.724	452.59	961115.0

> showing 50 of 32,498 rows — these rows as CSV

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