PREVIEW / etf_30min / 2024-07-29

all etf 30-min files

  file:    by_date/etf_30min/2024/2024-07-29.parquet
  size:    815 KB
  rows:    33,063

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-07-29 04:00:00	SPY	ETF	545.24	546.09	545.11	545.87	9006.0
2024-07-29 04:30:00	SPY	ETF	545.77	545.86	545.21	545.64	2981.0
2024-07-29 05:00:00	SPY	ETF	545.62	545.76	545.42	545.76	1850.0
2024-07-29 05:30:00	SPY	ETF	545.87	546.02	545.87	546.02	2300.0
2024-07-29 06:00:00	SPY	ETF	546.33	546.66	546.3	546.66	2249.0
2024-07-29 06:30:00	SPY	ETF	546.73	546.8	546.59	546.64	11962.0
2024-07-29 07:00:00	SPY	ETF	546.46	546.83	545.8	546.8	226830.0
2024-07-29 07:30:00	SPY	ETF	546.85	547.06	546.66	546.82	29002.0
2024-07-29 08:00:00	SPY	ETF	546.45	547.11	545.32	547.07	105935.0
2024-07-29 08:30:00	SPY	ETF	547.16	547.91	546.81	546.81	94549.0
2024-07-29 09:00:00	SPY	ETF	546.76	546.76	545.77	546.04	336649.0
2024-07-29 09:30:00	SPY	ETF	546.02	546.65	544.75	546.63	3793924.0
2024-07-29 10:00:00	SPY	ETF	546.64	547.04	544.91	545.37	1908611.0
2024-07-29 10:30:00	SPY	ETF	545.39	545.65	544.28	544.35	1918158.0
2024-07-29 11:00:00	SPY	ETF	544.33	544.41	543.35	544.15	1304873.0
2024-07-29 11:30:00	SPY	ETF	544.15	545.8	542.72	545.61	1770160.0
2024-07-29 12:00:00	SPY	ETF	545.615	546.78	545.615	545.9963	1484825.0
2024-07-29 12:30:00	SPY	ETF	546.0	546.67	545.87	546.22	839224.0
2024-07-29 13:00:00	SPY	ETF	546.21	547.05	545.3	545.31	1285293.0
2024-07-29 13:30:00	SPY	ETF	545.32	545.99	544.97	545.4593	1060982.0
2024-07-29 14:00:00	SPY	ETF	545.47	545.49	544.59	544.96	981682.0
2024-07-29 14:30:00	SPY	ETF	544.94	545.2499	544.46	545.14	1061213.0
2024-07-29 15:00:00	SPY	ETF	545.15	545.645	544.82	545.43	1309453.0
2024-07-29 15:30:00	SPY	ETF	545.43	546.05	544.52	544.76	4535782.0
2024-07-29 16:00:00	SPY	ETF	544.75	544.98	544.5	544.96	2993509.0
2024-07-29 16:30:00	SPY	ETF	544.98	545.05	544.75	544.88	58122.0
2024-07-29 17:00:00	SPY	ETF	544.98	545.02	544.78	544.8	15957.0
2024-07-29 17:30:00	SPY	ETF	544.8585	544.9	544.82	544.88	7317.0
2024-07-29 18:00:00	SPY	ETF	544.88	545.31	544.88	545.12	55657.0
2024-07-29 18:30:00	SPY	ETF	545.14	545.14	544.72	544.91	27481.0
2024-07-29 19:00:00	SPY	ETF	544.91	544.91	543.841	543.9018	45853.0
2024-07-29 19:30:00	SPY	ETF	543.94	544.08	543.1	543.45	26050.0
2024-07-29 04:00:00	QQQ	ETF	464.61	465.66	464.4	465.27	22580.0
2024-07-29 04:30:00	QQQ	ETF	465.17	465.17	464.38	464.89	26759.0
2024-07-29 05:00:00	QQQ	ETF	464.79	464.99	464.61	464.8	7781.0
2024-07-29 05:30:00	QQQ	ETF	465.02	465.37	464.94	465.37	13701.0
2024-07-29 06:00:00	QQQ	ETF	465.43	465.8	465.18	465.8	15158.0
2024-07-29 06:30:00	QQQ	ETF	465.78	465.9	465.69	465.74	8986.0
2024-07-29 07:00:00	QQQ	ETF	465.66	466.17	465.55	466.17	93463.0
2024-07-29 07:30:00	QQQ	ETF	466.17	466.49	465.96	466.0	181720.0
2024-07-29 08:00:00	QQQ	ETF	465.75	466.7686	464.44	466.69	228829.0
2024-07-29 08:30:00	QQQ	ETF	466.68	467.57	466.31	466.37	224933.0
2024-07-29 09:00:00	QQQ	ETF	466.32	466.35	465.52	465.76	247557.0
2024-07-29 09:30:00	QQQ	ETF	465.71	467.67	464.2	467.47	3461009.0
2024-07-29 10:00:00	QQQ	ETF	467.45	467.91	464.67	465.915	2054648.0
2024-07-29 10:30:00	QQQ	ETF	465.94	466.6	464.11	464.22	1407836.0
2024-07-29 11:00:00	QQQ	ETF	464.225	464.43	462.436	463.39	1396156.0
2024-07-29 11:30:00	QQQ	ETF	463.4	465.37	461.615	465.09	1583307.0
2024-07-29 12:00:00	QQQ	ETF	465.15	466.98	465.14	466.09	1844981.0
2024-07-29 12:30:00	QQQ	ETF	466.092	467.05	465.83	466.1852	828155.0

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

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