PREVIEW / etf_30min / 2024-02-01

all etf 30-min files

  file:    by_date/etf_30min/2024/2024-02-01.parquet
  size:    821 KB
  rows:    32,298

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-01 04:00:00	SPY	ETF	484.71	484.9	484.49	484.75	31055.0
2024-02-01 04:30:00	SPY	ETF	484.88	484.9	484.6	484.79	10046.0
2024-02-01 05:00:00	SPY	ETF	484.81	485.08	484.77	485.01	12607.0
2024-02-01 05:30:00	SPY	ETF	484.97	485.15	484.97	485.15	14782.0
2024-02-01 06:00:00	SPY	ETF	485.15	485.21	484.93	484.97	64199.0
2024-02-01 06:30:00	SPY	ETF	484.98	485.2	484.92	485.2	19071.0
2024-02-01 07:00:00	SPY	ETF	485.17	485.48	484.9	485.47	96946.0
2024-02-01 07:30:00	SPY	ETF	485.42	485.82	485.41	485.59	129788.0
2024-02-01 08:00:00	SPY	ETF	485.6	485.79	483.7	484.86	275263.0
2024-02-01 08:30:00	SPY	ETF	484.99	485.45	484.6	485.27	256777.0
2024-02-01 09:00:00	SPY	ETF	485.2	485.47	484.4	484.62	207859.0
2024-02-01 09:30:00	SPY	ETF	484.63	485.75	484.56	485.08	7449962.0
2024-02-01 10:00:00	SPY	ETF	485.01	486.205	484.26	486.18	6887313.0
2024-02-01 10:30:00	SPY	ETF	486.18	486.21	484.08	484.09	4951538.0
2024-02-01 11:00:00	SPY	ETF	484.08	484.71	483.8	484.57	4571164.0
2024-02-01 11:30:00	SPY	ETF	484.55	485.81	484.55	485.67	3545830.0
2024-02-01 12:00:00	SPY	ETF	485.715	487.27	485.67	486.4799	5079648.0
2024-02-01 12:30:00	SPY	ETF	486.46	488.24	486.37	487.4	4489407.0
2024-02-01 13:00:00	SPY	ETF	487.39	487.5	486.21	487.02	3360587.0
2024-02-01 13:30:00	SPY	ETF	487.04	487.6	486.38	487.23	3165296.0
2024-02-01 14:00:00	SPY	ETF	487.25	487.95	487.18	487.44	2937934.0
2024-02-01 14:30:00	SPY	ETF	487.44	488.5657	487.08	488.53	3918432.0
2024-02-01 15:00:00	SPY	ETF	488.54	488.99	488.22	488.69	4075638.0
2024-02-01 15:30:00	SPY	ETF	488.6901	489.23	488.1	489.23	8854587.0
2024-02-01 16:00:00	SPY	ETF	489.22	491.21	484.4437	491.16	4267477.0
2024-02-01 16:30:00	SPY	ETF	491.21	492.61	490.75	492.16	816786.0
2024-02-01 17:00:00	SPY	ETF	492.18	492.46	492.0	492.01	120308.0
2024-02-01 17:30:00	SPY	ETF	491.97	491.97	491.44	491.44	255446.0
2024-02-01 18:00:00	SPY	ETF	491.53	491.79	491.39	491.58	137656.0
2024-02-01 18:30:00	SPY	ETF	491.59	491.79	491.5	491.64	31010.0
2024-02-01 19:00:00	SPY	ETF	491.67	491.67	491.3	491.49	17055.0
2024-02-01 19:30:00	SPY	ETF	491.46	491.76	491.44	491.74	55355.0
2024-02-01 04:00:00	QQQ	ETF	419.12	419.98	419.12	419.5	60659.0
2024-02-01 04:30:00	QQQ	ETF	419.65	419.65	419.18	419.38	19985.0
2024-02-01 05:00:00	QQQ	ETF	419.41	419.82	419.33	419.74	21272.0
2024-02-01 05:30:00	QQQ	ETF	419.81	419.96	419.68	419.96	19814.0
2024-02-01 06:00:00	QQQ	ETF	419.84	420.0	419.48	419.52	32795.0
2024-02-01 06:30:00	QQQ	ETF	419.5	419.67	419.33	419.57	34012.0
2024-02-01 07:00:00	QQQ	ETF	419.61	419.94	419.38	419.76	112679.0
2024-02-01 07:30:00	QQQ	ETF	419.745	420.15	419.72	419.76	76952.0
2024-02-01 08:00:00	QQQ	ETF	419.6	420.18	417.93	419.35	272961.0
2024-02-01 08:30:00	QQQ	ETF	419.45	420.01	419.16	419.53	432897.0
2024-02-01 09:00:00	QQQ	ETF	419.56	419.86	418.66	418.81	222352.0
2024-02-01 09:30:00	QQQ	ETF	418.79	419.5699	418.3399	418.82	4242190.0
2024-02-01 10:00:00	QQQ	ETF	418.73	420.335	417.84	420.31	3352544.0
2024-02-01 10:30:00	QQQ	ETF	420.32	420.39	418.0282	418.05	2636115.0
2024-02-01 11:00:00	QQQ	ETF	418.035	418.65	417.81	418.2	2325580.0
2024-02-01 11:30:00	QQQ	ETF	418.185	419.49	418.185	419.24	1598301.0
2024-02-01 12:00:00	QQQ	ETF	419.25	420.86	419.205	419.73	2419887.0
2024-02-01 12:30:00	QQQ	ETF	419.7201	421.3875	419.5	420.69	2107612.0

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

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