PREVIEW / etf_30min / 2024-02-16

all etf 30-min files

  file:    by_date/etf_30min/2024/2024-02-16.parquet
  size:    805 KB
  rows:    31,490

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-02-16 04:00:00	SPY	ETF	502.41	502.98	502.41	502.98	9002.0
2024-02-16 04:30:00	SPY	ETF	502.99	503.04	502.8	502.8	20808.0
2024-02-16 05:00:00	SPY	ETF	503.0	503.23	503.0	503.23	3231.0
2024-02-16 05:30:00	SPY	ETF	503.18	503.3	503.11	503.12	2085.0
2024-02-16 06:00:00	SPY	ETF	503.06	503.28	503.06	503.12	3181.0
2024-02-16 06:30:00	SPY	ETF	503.1	503.2	502.96	503.11	26148.0
2024-02-16 07:00:00	SPY	ETF	503.1	503.1	502.54	502.84	72140.0
2024-02-16 07:30:00	SPY	ETF	502.71	502.86	502.65	502.65	21825.0
2024-02-16 08:00:00	SPY	ETF	503.1016	503.2896	501.81	502.62	85000.0
2024-02-16 08:30:00	SPY	ETF	502.5	502.5	500.46	501.55	984212.0
2024-02-16 09:00:00	SPY	ETF	501.55	501.85	501.17	501.67	274803.0
2024-02-16 09:30:00	SPY	ETF	501.71	501.91	499.29	499.66	4816908.0
2024-02-16 10:00:00	SPY	ETF	499.65	500.5	498.75	500.24	4191473.0
2024-02-16 10:30:00	SPY	ETF	500.25	501.16	499.81	500.92	3358383.0
2024-02-16 11:00:00	SPY	ETF	500.93	502.045	500.905	501.89	3160872.0
2024-02-16 11:30:00	SPY	ETF	501.88	502.46	501.63	502.21	3060167.0
2024-02-16 12:00:00	SPY	ETF	502.215	502.36	501.7779	502.22	2564557.0
2024-02-16 12:30:00	SPY	ETF	502.215	502.3	501.66	501.83	1706820.0
2024-02-16 13:00:00	SPY	ETF	501.83	501.86	500.74	501.66	3320910.0
2024-02-16 13:30:00	SPY	ETF	501.67	502.37	501.6	502.3601	2039279.0
2024-02-16 14:00:00	SPY	ETF	502.37	502.87	502.37	502.6104	2970413.0
2024-02-16 14:30:00	SPY	ETF	502.6199	502.69	499.95	500.565	5016836.0
2024-02-16 15:00:00	SPY	ETF	500.57	500.75	500.02	500.5626	3533554.0
2024-02-16 15:30:00	SPY	ETF	500.58	500.66	498.98	499.49	7312644.0
2024-02-16 16:00:00	SPY	ETF	499.49	499.56	498.86	499.03	2568624.0
2024-02-16 16:30:00	SPY	ETF	499.04	499.04	498.76	498.95	225529.0
2024-02-16 17:00:00	SPY	ETF	498.95	499.35	498.84	498.86	31433.0
2024-02-16 17:30:00	SPY	ETF	498.86	499.52	498.5	498.5	258611.0
2024-02-16 18:00:00	SPY	ETF	498.51	498.7	498.51	498.6	10517.0
2024-02-16 18:30:00	SPY	ETF	498.7	498.85	498.7	498.74	10687.0
2024-02-16 19:00:00	SPY	ETF	498.72	498.79	498.7	498.7	6098.0
2024-02-16 19:30:00	SPY	ETF	498.71	498.75	498.29	498.35	36157.0
2024-02-16 04:00:00	QQQ	ETF	436.86	437.14	436.61	437.11	45021.0
2024-02-16 04:30:00	QQQ	ETF	437.11	437.14	436.78	436.9	23200.0
2024-02-16 05:00:00	QQQ	ETF	436.96	437.26	436.95	437.19	38610.0
2024-02-16 05:30:00	QQQ	ETF	437.17	437.33	437.05	437.12	9625.0
2024-02-16 06:00:00	QQQ	ETF	437.04	437.27	437.01	437.03	8176.0
2024-02-16 06:30:00	QQQ	ETF	437.04	437.22	436.94	437.03	13009.0
2024-02-16 07:00:00	QQQ	ETF	437.05	437.09	436.6	436.77	45880.0
2024-02-16 07:30:00	QQQ	ETF	436.749	436.85	436.55	436.57	61136.0
2024-02-16 08:00:00	QQQ	ETF	437.06	437.2504	434.458	436.54	195950.0
2024-02-16 08:30:00	QQQ	ETF	436.43	436.43	434.32	435.22	793527.0
2024-02-16 09:00:00	QQQ	ETF	435.23	435.49	434.8	434.9	159419.0
2024-02-16 09:30:00	QQQ	ETF	434.92	434.99	430.72	431.25	4643343.0
2024-02-16 10:00:00	QQQ	ETF	431.18	431.68	429.85	431.03	4090548.0
2024-02-16 10:30:00	QQQ	ETF	431.07	432.346	430.41	432.04	3000787.0
2024-02-16 11:00:00	QQQ	ETF	432.04	433.69	431.96	433.36	2350053.0
2024-02-16 11:30:00	QQQ	ETF	433.37	434.08	432.925	433.74	2032336.0
2024-02-16 12:00:00	QQQ	ETF	433.72	433.96	433.12	433.785	1485150.0
2024-02-16 12:30:00	QQQ	ETF	433.78	433.9	432.96	433.24	1312875.0

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

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