PREVIEW / etf_30min / 2024-05-29

all etf 30-min files

  file:    by_date/etf_30min/2024/2024-05-29.parquet
  size:    805 KB
  rows:    32,374

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-05-29 04:00:00	SPY	ETF	527.7	529.0	526.88	527.18	81663.0
2024-05-29 04:30:00	SPY	ETF	527.18	527.21	526.7	527.15	42075.0
2024-05-29 05:00:00	SPY	ETF	527.17	527.17	526.5	526.61	4815.0
2024-05-29 05:30:00	SPY	ETF	526.51	526.81	526.42	526.79	5561.0
2024-05-29 06:00:00	SPY	ETF	526.71	527.03	526.64	526.93	6564.0
2024-05-29 06:30:00	SPY	ETF	526.93	526.99	526.6	526.7	115757.0
2024-05-29 07:00:00	SPY	ETF	526.7	526.81	526.3	526.4	59701.0
2024-05-29 07:30:00	SPY	ETF	526.46	527.05	526.46	526.78	148020.0
2024-05-29 08:00:00	SPY	ETF	526.75	528.42	526.31	526.6296	124170.0
2024-05-29 08:30:00	SPY	ETF	526.59	526.59	525.93	526.0	138197.0
2024-05-29 09:00:00	SPY	ETF	526.01	526.04	525.6	525.71	198351.0
2024-05-29 09:30:00	SPY	ETF	525.68	526.42	525.37	526.205	3863781.0
2024-05-29 10:00:00	SPY	ETF	526.19	526.97	525.86	526.73	2380065.0
2024-05-29 10:30:00	SPY	ETF	526.756	527.305	526.7	527.03	1659131.0
2024-05-29 11:00:00	SPY	ETF	527.02	527.07	526.03	526.48	1351151.0
2024-05-29 11:30:00	SPY	ETF	526.48	526.725	526.151	526.6	1223124.0
2024-05-29 12:00:00	SPY	ETF	526.61	526.92	525.98	526.82	1858034.0
2024-05-29 12:30:00	SPY	ETF	526.82	527.31	526.62	527.0999	1472069.0
2024-05-29 13:00:00	SPY	ETF	527.1	527.1704	526.34	526.9301	1605285.0
2024-05-29 13:30:00	SPY	ETF	526.93	527.2	526.17	527.01	1509712.0
2024-05-29 14:00:00	SPY	ETF	527.03	527.14	526.59	526.59	1273928.0
2024-05-29 14:30:00	SPY	ETF	526.58	526.81	526.05	526.165	1668421.0
2024-05-29 15:00:00	SPY	ETF	526.165	527.19	526.01	526.86	1601458.0
2024-05-29 15:30:00	SPY	ETF	526.85	527.19	525.56	526.11	5878491.0
2024-05-29 16:00:00	SPY	ETF	526.11	526.29	524.75	524.88	2757222.0
2024-05-29 16:30:00	SPY	ETF	524.89	526.1	524.3	524.45	390325.0
2024-05-29 17:00:00	SPY	ETF	524.44	524.51	524.23	524.48	119662.0
2024-05-29 17:30:00	SPY	ETF	524.5382	524.544	524.3401	524.49	17511.0
2024-05-29 18:00:00	SPY	ETF	524.39	524.75	524.39	524.5	69671.0
2024-05-29 18:30:00	SPY	ETF	524.48	524.5	524.02	524.16	39158.0
2024-05-29 19:00:00	SPY	ETF	524.15	524.22	523.87	523.87	10302.0
2024-05-29 19:30:00	SPY	ETF	523.87	524.15	523.77	524.12	44784.0
2024-05-29 04:00:00	QQQ	ETF	457.6	458.11	456.79	457.07	28221.0
2024-05-29 04:30:00	QQQ	ETF	456.9	457.06	456.36	456.96	24343.0
2024-05-29 05:00:00	QQQ	ETF	456.89	456.91	456.27	456.46	29572.0
2024-05-29 05:30:00	QQQ	ETF	456.48	456.75	456.32	456.71	13285.0
2024-05-29 06:00:00	QQQ	ETF	456.7	457.08	456.7	456.9	8351.0
2024-05-29 06:30:00	QQQ	ETF	456.98	456.98	456.54	456.64	33965.0
2024-05-29 07:00:00	QQQ	ETF	456.56	456.83	456.23	456.23	98331.0
2024-05-29 07:30:00	QQQ	ETF	456.5	456.95	456.48	456.76	44296.0
2024-05-29 08:00:00	QQQ	ETF	456.43	458.45	456.23	456.63	109954.0
2024-05-29 08:30:00	QQQ	ETF	456.63	456.63	455.66	455.84	123036.0
2024-05-29 09:00:00	QQQ	ETF	455.84	455.84	455.25	455.4	417001.0
2024-05-29 09:30:00	QQQ	ETF	455.48	457.5	455.34	457.03	2909272.0
2024-05-29 10:00:00	QQQ	ETF	457.04	457.93	456.56	457.58	1203606.0
2024-05-29 10:30:00	QQQ	ETF	457.59	458.24	457.51	457.97	1210680.0
2024-05-29 11:00:00	QQQ	ETF	457.95	458.12	456.88	457.5	912290.0
2024-05-29 11:30:00	QQQ	ETF	457.48	457.66	456.955	457.5299	794136.0
2024-05-29 12:00:00	QQQ	ETF	457.505	457.71	456.84	457.59	845176.0
2024-05-29 12:30:00	QQQ	ETF	457.6	458.18	457.46	458.03	823210.0

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

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