PREVIEW / etf_30min / 2024-07-26

all etf 30-min files

  file:    by_date/etf_30min/2024/2024-07-26.parquet
  size:    807 KB
  rows:    32,472

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-26 04:00:00	SPY	ETF	541.5	542.49	541.5	542.32	17218.0
2024-07-26 04:30:00	SPY	ETF	542.41	543.15	542.25	543.15	36163.0
2024-07-26 05:00:00	SPY	ETF	543.09	543.1	542.63	542.67	22355.0
2024-07-26 05:30:00	SPY	ETF	542.65	542.84	542.53	542.61	8940.0
2024-07-26 06:00:00	SPY	ETF	542.63	542.75	542.4	542.55	15803.0
2024-07-26 06:30:00	SPY	ETF	542.64	543.0	542.43	542.43	59418.0
2024-07-26 07:00:00	SPY	ETF	542.46	542.92	541.45	542.7	242747.0
2024-07-26 07:30:00	SPY	ETF	542.75	543.21	542.68	543.21	92416.0
2024-07-26 08:00:00	SPY	ETF	542.8	543.3103	540.6	543.0	189389.0
2024-07-26 08:30:00	SPY	ETF	543.19	543.83	542.28	542.59	514045.0
2024-07-26 09:00:00	SPY	ETF	542.6	542.62	542.08	542.32	170591.0
2024-07-26 09:30:00	SPY	ETF	542.28	543.18	541.49	542.9	4069737.0
2024-07-26 10:00:00	SPY	ETF	542.88	544.63	542.035	543.6309	2863658.0
2024-07-26 10:30:00	SPY	ETF	543.63	543.83	541.67	543.42	2458416.0
2024-07-26 11:00:00	SPY	ETF	543.43	544.03	542.7802	543.21	1990861.0
2024-07-26 11:30:00	SPY	ETF	543.21	544.96	542.889	544.85	1579294.0
2024-07-26 12:00:00	SPY	ETF	544.86	546.02	544.78	545.5712	2579881.0
2024-07-26 12:30:00	SPY	ETF	545.57	546.875	545.3	546.7306	1588575.0
2024-07-26 13:00:00	SPY	ETF	546.73	547.19	546.23	547.05	1880440.0
2024-07-26 13:30:00	SPY	ETF	547.05	547.13	544.01	544.96	3621559.0
2024-07-26 14:00:00	SPY	ETF	544.94	545.46	544.36	544.49	1586539.0
2024-07-26 14:30:00	SPY	ETF	544.51	544.92	543.38	543.57	1692435.0
2024-07-26 15:00:00	SPY	ETF	543.58	545.07	543.03	544.76	2199390.0
2024-07-26 15:30:00	SPY	ETF	544.75	544.84	542.725	544.38	7603336.0
2024-07-26 16:00:00	SPY	ETF	544.37	544.72	544.03	544.58	3621935.0
2024-07-26 16:30:00	SPY	ETF	544.58	544.62	544.31	544.33	66017.0
2024-07-26 17:00:00	SPY	ETF	544.3	544.38	543.99	544.25	61229.0
2024-07-26 17:30:00	SPY	ETF	544.26	544.44	544.15	544.16	21387.0
2024-07-26 18:00:00	SPY	ETF	544.3228	544.33	544.15	544.2	7009.0
2024-07-26 18:30:00	SPY	ETF	544.2	544.43	544.162	544.4	4788.0
2024-07-26 19:00:00	SPY	ETF	544.43	544.43	544.4	544.4	14034.0
2024-07-26 19:30:00	SPY	ETF	544.4	544.4	544.21	544.27	31419.0
2024-07-26 04:00:00	QQQ	ETF	461.91	462.93	461.91	462.87	59218.0
2024-07-26 04:30:00	QQQ	ETF	462.73	463.98	462.55	463.95	25630.0
2024-07-26 05:00:00	QQQ	ETF	464.09	464.09	463.11	463.17	107560.0
2024-07-26 05:30:00	QQQ	ETF	463.23	463.62	463.23	463.44	30675.0
2024-07-26 06:00:00	QQQ	ETF	463.45	463.51	462.82	462.97	37185.0
2024-07-26 06:30:00	QQQ	ETF	463.1	463.54	462.75	462.78	40274.0
2024-07-26 07:00:00	QQQ	ETF	462.77	463.37	462.6	463.25	133658.0
2024-07-26 07:30:00	QQQ	ETF	463.45	463.92	463.32	463.85	77951.0
2024-07-26 08:00:00	QQQ	ETF	462.771	464.05	457.917	463.6002	218428.0
2024-07-26 08:30:00	QQQ	ETF	463.81	464.75	462.6	463.08	586326.0
2024-07-26 09:00:00	QQQ	ETF	463.04	463.19	462.5	462.69	211309.0
2024-07-26 09:30:00	QQQ	ETF	462.66	462.71	460.23	461.98	3626817.0
2024-07-26 10:00:00	QQQ	ETF	462.02	463.37	459.86	462.05	3132168.0
2024-07-26 10:30:00	QQQ	ETF	462.04	462.32	459.77	461.81	2654833.0
2024-07-26 11:00:00	QQQ	ETF	461.82	462.64	460.99	461.4	1592661.0
2024-07-26 11:30:00	QQQ	ETF	461.4	463.45	461.16	463.22	2233923.0
2024-07-26 12:00:00	QQQ	ETF	463.23	464.77	463.05	464.36	2348607.0
2024-07-26 12:30:00	QQQ	ETF	464.37	465.72	464.3	465.46	1567518.0

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

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