PREVIEW / etf_30min / 2024-05-09

all etf 30-min files

  file:    by_date/etf_30min/2024/2024-05-09.parquet
  size:    783 KB
  rows:    31,050

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-09 04:00:00	SPY	ETF	516.49	516.63	516.36	516.52	2698.0
2024-05-09 04:30:00	SPY	ETF	516.34	516.37	516.32	516.34	17620.0
2024-05-09 05:00:00	SPY	ETF	516.32	516.32	515.85	516.04	2775.0
2024-05-09 05:30:00	SPY	ETF	516.03	516.2	516.03	516.19	1193.0
2024-05-09 06:00:00	SPY	ETF	516.3	516.79	516.3	516.65	3568.0
2024-05-09 06:30:00	SPY	ETF	516.68	516.78	516.35	516.44	22291.0
2024-05-09 07:00:00	SPY	ETF	516.46	516.72	516.3	516.42	18432.0
2024-05-09 07:30:00	SPY	ETF	516.53	517.0	516.53	516.85	89594.0
2024-05-09 08:00:00	SPY	ETF	516.46	517.0	516.0496	516.74	107803.0
2024-05-09 08:30:00	SPY	ETF	516.77	517.73	516.77	517.41	271239.0
2024-05-09 09:00:00	SPY	ETF	517.34	517.85	517.11	517.37	262770.0
2024-05-09 09:30:00	SPY	ETF	517.38	517.79	516.705	517.5818	3366216.0
2024-05-09 10:00:00	SPY	ETF	517.58	518.39	517.505	518.065	3236335.0
2024-05-09 10:30:00	SPY	ETF	518.06	519.28	518.06	519.165	2884722.0
2024-05-09 11:00:00	SPY	ETF	519.16	519.51	519.0	519.34	2237106.0
2024-05-09 11:30:00	SPY	ETF	519.34	519.455	518.34	518.5	1812417.0
2024-05-09 12:00:00	SPY	ETF	518.49	518.97	518.37	518.8	1268948.0
2024-05-09 12:30:00	SPY	ETF	518.81	519.37	518.53	519.2199	1258463.0
2024-05-09 13:00:00	SPY	ETF	519.21	519.64	518.79	519.5	2016495.0
2024-05-09 13:30:00	SPY	ETF	519.5	519.58	519.15	519.2	1056275.0
2024-05-09 14:00:00	SPY	ETF	519.19	519.51	518.93	519.48	1162334.0
2024-05-09 14:30:00	SPY	ETF	519.49	520.06	519.3401	519.9	1623426.0
2024-05-09 15:00:00	SPY	ETF	519.9	520.045	519.58	519.67	2114306.0
2024-05-09 15:30:00	SPY	ETF	519.63	520.2074	519.57	520.13	7952054.0
2024-05-09 16:00:00	SPY	ETF	520.13	520.66	519.8	520.47	3636224.0
2024-05-09 16:30:00	SPY	ETF	520.48	520.54	520.17	520.25	225184.0
2024-05-09 17:00:00	SPY	ETF	520.35	520.38	520.2622	520.3	26623.0
2024-05-09 17:30:00	SPY	ETF	520.3	520.34	520.28	520.34	5737.0
2024-05-09 18:00:00	SPY	ETF	520.25	520.5	520.17	520.43	21343.0
2024-05-09 18:30:00	SPY	ETF	520.42	520.66	520.42	520.57	9558.0
2024-05-09 19:00:00	SPY	ETF	520.59	520.69	520.57	520.67	3754.0
2024-05-09 19:30:00	SPY	ETF	520.64	520.78	520.56	520.56	24118.0
2024-05-09 04:00:00	QQQ	ETF	438.91	439.25	438.79	439.11	5680.0
2024-05-09 04:30:00	QQQ	ETF	439.03	439.03	438.85	438.85	11296.0
2024-05-09 05:00:00	QQQ	ETF	438.94	438.94	438.4	438.75	3386.0
2024-05-09 05:30:00	QQQ	ETF	438.69	438.91	438.69	438.91	1150.0
2024-05-09 06:00:00	QQQ	ETF	439.01	439.55	439.01	439.47	8820.0
2024-05-09 06:30:00	QQQ	ETF	439.49	439.52	439.08	439.09	15987.0
2024-05-09 07:00:00	QQQ	ETF	439.15	439.49	438.92	439.15	24085.0
2024-05-09 07:30:00	QQQ	ETF	439.08	439.81	439.06	439.65	20403.0
2024-05-09 08:00:00	QQQ	ETF	439.02	439.8	438.71	439.63	68084.0
2024-05-09 08:30:00	QQQ	ETF	439.62	440.65	439.62	440.5	160788.0
2024-05-09 09:00:00	QQQ	ETF	440.37	440.9	440.2	440.3304	174718.0
2024-05-09 09:30:00	QQQ	ETF	440.33	440.76	438.46	439.64	3027797.0
2024-05-09 10:00:00	QQQ	ETF	439.67	440.37	438.98	439.51	2010960.0
2024-05-09 10:30:00	QQQ	ETF	439.51	441.19	439.5	440.945	1868628.0
2024-05-09 11:00:00	QQQ	ETF	440.93	441.42	440.91	441.38	1196714.0
2024-05-09 11:30:00	QQQ	ETF	441.39	441.555	439.97	440.16	992199.0
2024-05-09 12:00:00	QQQ	ETF	440.17	440.76	439.96	440.5829	850489.0
2024-05-09 12:30:00	QQQ	ETF	440.6	441.17	440.225	441.01	721432.0

> showing 50 of 31,050 rows — these rows as CSV

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