PREVIEW / etf_30min / 2023-10-12

all etf 30-min files

  file:    by_date/etf_30min/2023/2023-10-12.parquet
  size:    718 KB
  rows:    28,214

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
2023-10-12 04:00:00	SPY	ETF	437.5	437.78	437.45	437.7	22973.0
2023-10-12 04:30:00	SPY	ETF	437.76	438.0	437.62	438.0	6372.0
2023-10-12 05:00:00	SPY	ETF	438.06	438.15	438.03	438.1	10206.0
2023-10-12 05:30:00	SPY	ETF	438.05	438.3	438.05	438.25	11363.0
2023-10-12 06:00:00	SPY	ETF	438.23	438.54	438.23	438.31	20284.0
2023-10-12 06:30:00	SPY	ETF	438.33	438.53	438.23	438.28	25601.0
2023-10-12 07:00:00	SPY	ETF	438.24	438.34	438.04	438.09	32845.0
2023-10-12 07:30:00	SPY	ETF	438.07	438.3	438.03	438.23	68416.0
2023-10-12 08:00:00	SPY	ETF	438.21	438.6	437.5496	438.4	325495.0
2023-10-12 08:30:00	SPY	ETF	438.2	438.4	436.42	437.06	1388963.0
2023-10-12 09:00:00	SPY	ETF	437.06	437.2	436.51	437.02	503225.0
2023-10-12 09:30:00	SPY	ETF	436.95	437.0	435.07	435.43	4862880.0
2023-10-12 10:00:00	SPY	ETF	435.44	436.7	434.98	435.915	4348570.0
2023-10-12 10:30:00	SPY	ETF	435.92	436.27	435.2	436.14	3755615.0
2023-10-12 11:00:00	SPY	ETF	436.13	436.9	435.62	436.17	3432519.0
2023-10-12 11:30:00	SPY	ETF	436.17	436.58	435.8243	436.5371	2136058.0
2023-10-12 12:00:00	SPY	ETF	436.565	437.335	436.255	437.21	3089833.0
2023-10-12 12:30:00	SPY	ETF	437.21	437.28	436.35	436.525	2336603.0
2023-10-12 13:00:00	SPY	ETF	436.535	436.545	433.35	433.4106	7124766.0
2023-10-12 13:30:00	SPY	ETF	433.415	433.72	432.35	432.4399	6081448.0
2023-10-12 14:00:00	SPY	ETF	432.44	432.72	431.23	432.59	8557671.0
2023-10-12 14:30:00	SPY	ETF	432.585	433.3725	432.34	432.97	4789010.0
2023-10-12 15:00:00	SPY	ETF	432.99	433.91	432.92	433.38	4711920.0
2023-10-12 15:30:00	SPY	ETF	433.385	434.29	433.38	433.7	8836237.0
2023-10-12 16:00:00	SPY	ETF	433.7	434.05	433.58	433.77	3210871.0
2023-10-12 16:30:00	SPY	ETF	433.82	433.9	433.62	433.74	92150.0
2023-10-12 17:00:00	SPY	ETF	433.75	433.81	433.7	433.8	35940.0
2023-10-12 17:30:00	SPY	ETF	433.8	433.83	433.73	433.78	12025.0
2023-10-12 18:00:00	SPY	ETF	433.79	433.89	433.51	433.79	37932.0
2023-10-12 18:30:00	SPY	ETF	433.69	433.85	433.69	433.81	37351.0
2023-10-12 19:00:00	SPY	ETF	433.76	433.91	433.71	433.9	6133.0
2023-10-12 19:30:00	SPY	ETF	433.92	434.06	433.8	433.97	33847.0
2023-10-12 04:00:00	QQQ	ETF	372.39	372.59	372.3	372.46	44836.0
2023-10-12 04:30:00	QQQ	ETF	372.5	372.79	372.35	372.79	5912.0
2023-10-12 05:00:00	QQQ	ETF	372.81	372.81	372.56	372.6	7110.0
2023-10-12 05:30:00	QQQ	ETF	372.68	372.91	372.66	372.79	5902.0
2023-10-12 06:00:00	QQQ	ETF	372.76	373.0	372.7	372.78	12342.0
2023-10-12 06:30:00	QQQ	ETF	372.82	373.0	372.75	372.77	23268.0
2023-10-12 07:00:00	QQQ	ETF	372.76	372.91	372.62	372.67	48284.0
2023-10-12 07:30:00	QQQ	ETF	372.64	372.83	372.47	372.74	75711.0
2023-10-12 08:00:00	QQQ	ETF	372.82	373.03	371.498	372.7702	191400.0
2023-10-12 08:30:00	QQQ	ETF	372.7	372.95	371.0	371.68	1434290.0
2023-10-12 09:00:00	QQQ	ETF	371.67	371.86	371.2	371.77	383325.0
2023-10-12 09:30:00	QQQ	ETF	371.73	372.31	371.09	371.57	4084027.0
2023-10-12 10:00:00	QQQ	ETF	371.58	373.39	371.32	372.34	3982692.0
2023-10-12 10:30:00	QQQ	ETF	372.34	372.84	371.85	372.6213	2449685.0
2023-10-12 11:00:00	QQQ	ETF	372.63	373.74	371.93	372.37	2175866.0
2023-10-12 11:30:00	QQQ	ETF	372.365	372.99	372.14	372.945	1759632.0
2023-10-12 12:00:00	QQQ	ETF	372.95	373.56	372.575	373.405	1616075.0
2023-10-12 12:30:00	QQQ	ETF	373.41	373.455	372.53	372.76	1198292.0

> showing 50 of 28,214 rows — these rows as CSV

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