PREVIEW / etf_30min / 2024-07-17

all etf 30-min files

  file:    by_date/etf_30min/2024/2024-07-17.parquet
  size:    851 KB
  rows:    34,221

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-17 04:00:00	SPY	ETF	562.5	562.5	560.13	560.27	39630.0
2024-07-17 04:30:00	SPY	ETF	560.4	560.9	560.3	560.71	17695.0
2024-07-17 05:00:00	SPY	ETF	560.86	560.99	560.66	560.66	17147.0
2024-07-17 05:30:00	SPY	ETF	560.62	561.0	560.47	560.92	15799.0
2024-07-17 06:00:00	SPY	ETF	560.88	561.0	560.71	560.98	32387.0
2024-07-17 06:30:00	SPY	ETF	560.81	560.99	560.18	560.43	38465.0
2024-07-17 07:00:00	SPY	ETF	560.42	560.65	559.05	559.21	348702.0
2024-07-17 07:30:00	SPY	ETF	559.21	559.73	558.8	559.6	230688.0
2024-07-17 08:00:00	SPY	ETF	559.57	564.18	558.87	559.79	318207.0
2024-07-17 08:30:00	SPY	ETF	559.75	559.86	559.0	559.13	245290.0
2024-07-17 09:00:00	SPY	ETF	559.12	559.41	558.59	558.79	383014.0
2024-07-17 09:30:00	SPY	ETF	558.79	560.51	558.78	559.875	4654216.0
2024-07-17 10:00:00	SPY	ETF	559.87	559.89	557.9099	558.69	3884293.0
2024-07-17 10:30:00	SPY	ETF	558.68	559.105	558.2	558.25	1598612.0
2024-07-17 11:00:00	SPY	ETF	558.26	558.77	557.81	558.5999	1877960.0
2024-07-17 11:30:00	SPY	ETF	558.605	558.67	557.79	558.42	1384774.0
2024-07-17 12:00:00	SPY	ETF	558.43	558.55	557.29	557.3698	1522648.0
2024-07-17 12:30:00	SPY	ETF	557.35	558.04	557.05	557.97	1869784.0
2024-07-17 13:00:00	SPY	ETF	557.96	557.96	556.61	557.38	1479008.0
2024-07-17 13:30:00	SPY	ETF	557.3702	557.9	557.12	557.3156	1744858.0
2024-07-17 14:00:00	SPY	ETF	557.33	558.15	556.84	558.04	1752484.0
2024-07-17 14:30:00	SPY	ETF	558.04	558.375	557.25	557.45	1616809.0
2024-07-17 15:00:00	SPY	ETF	557.45	558.2199	557.04	558.07	1997138.0
2024-07-17 15:30:00	SPY	ETF	558.06	558.28	556.95	556.95	7164534.0
2024-07-17 16:00:00	SPY	ETF	556.95	558.167	556.4295	557.29	3183439.0
2024-07-17 16:30:00	SPY	ETF	557.29	557.49	556.94	557.48	126207.0
2024-07-17 17:00:00	SPY	ETF	557.45	557.54	557.3	557.43	62599.0
2024-07-17 17:30:00	SPY	ETF	557.32	557.5	557.25	557.49	32264.0
2024-07-17 18:00:00	SPY	ETF	557.5	558.1	557.41	558.02	96393.0
2024-07-17 18:30:00	SPY	ETF	558.02	558.2	557.83	558.14	13520.0
2024-07-17 19:00:00	SPY	ETF	558.17	558.17	558.0	558.05	20260.0
2024-07-17 19:30:00	SPY	ETF	558.05	558.19	558.02	558.08	99088.0
2024-07-17 04:00:00	QQQ	ETF	492.97	492.97	489.5	489.7	70400.0
2024-07-17 04:30:00	QQQ	ETF	489.72	490.37	489.52	490.37	60956.0
2024-07-17 05:00:00	QQQ	ETF	490.33	490.5	490.15	490.15	12156.0
2024-07-17 05:30:00	QQQ	ETF	490.04	490.5	489.79	490.41	24231.0
2024-07-17 06:00:00	QQQ	ETF	490.3	490.61	490.08	490.59	28341.0
2024-07-17 06:30:00	QQQ	ETF	490.38	490.87	489.73	490.13	74772.0
2024-07-17 07:00:00	QQQ	ETF	490.07	490.44	488.55	488.86	223323.0
2024-07-17 07:30:00	QQQ	ETF	488.82	489.08	488.31	488.94	191245.0
2024-07-17 08:00:00	QQQ	ETF	488.9	496.712	488.3201	489.46	277272.0
2024-07-17 08:30:00	QQQ	ETF	489.4	489.64	488.66	488.8	169343.0
2024-07-17 09:00:00	QQQ	ETF	488.76	489.18	488.13	488.18	749734.0
2024-07-17 09:30:00	QQQ	ETF	488.26	488.7984	487.0	487.055	5898653.0
2024-07-17 10:00:00	QQQ	ETF	487.04	487.1	484.36	485.15	4517668.0
2024-07-17 10:30:00	QQQ	ETF	485.14	486.34	484.54	484.98	2024247.0
2024-07-17 11:00:00	QQQ	ETF	484.96	485.65	484.21	485.16	1643952.0
2024-07-17 11:30:00	QQQ	ETF	485.16	485.26	483.29	484.09	1913472.0
2024-07-17 12:00:00	QQQ	ETF	484.11	484.18	482.64	482.86	1988284.0
2024-07-17 12:30:00	QQQ	ETF	482.85	483.66	482.2	483.5698	2450099.0

> showing 50 of 34,221 rows — these rows as CSV

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