PREVIEW / etf_30min / 2023-08-08

all etf 30-min files

  file:    by_date/etf_30min/2023/2023-08-08.parquet
  size:    712 KB
  rows:    28,361

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-08-08 04:00:00	SPY	ETF	449.85	449.96	449.08	449.08	22570.0
2023-08-08 04:30:00	SPY	ETF	449.05	449.47	449.0	449.39	18557.0
2023-08-08 05:00:00	SPY	ETF	449.39	449.39	448.64	448.64	20947.0
2023-08-08 05:30:00	SPY	ETF	448.78	448.84	448.42	448.84	16553.0
2023-08-08 06:00:00	SPY	ETF	448.9	449.01	448.39	448.43	16258.0
2023-08-08 06:30:00	SPY	ETF	448.39	448.46	448.15	448.28	34523.0
2023-08-08 07:00:00	SPY	ETF	448.34	448.38	447.55	447.6	314546.0
2023-08-08 07:30:00	SPY	ETF	447.6	447.71	447.2	447.67	94503.0
2023-08-08 08:00:00	SPY	ETF	448.3386	449.82	446.61	447.54	380912.0
2023-08-08 08:30:00	SPY	ETF	447.53	447.98	447.28	447.72	182690.0
2023-08-08 09:00:00	SPY	ETF	447.7	448.06	447.28	448.06	178925.0
2023-08-08 09:30:00	SPY	ETF	448.08	448.15	446.085	446.585	7603400.0
2023-08-08 10:00:00	SPY	ETF	446.585	446.875	445.4	446.19	6077335.0
2023-08-08 10:30:00	SPY	ETF	446.1801	446.39	445.51	445.5399	3872817.0
2023-08-08 11:00:00	SPY	ETF	445.54	446.28	445.2705	446.19	3690793.0
2023-08-08 11:30:00	SPY	ETF	446.185	446.29	445.52	445.69	2422429.0
2023-08-08 12:00:00	SPY	ETF	445.69	446.63	445.63	446.46	2664324.0
2023-08-08 12:30:00	SPY	ETF	446.47	446.955	446.23	446.59	2437708.0
2023-08-08 13:00:00	SPY	ETF	446.6	447.4081	446.54	446.935	2943181.0
2023-08-08 13:30:00	SPY	ETF	446.93	447.37	446.55	447.2449	2353087.0
2023-08-08 14:00:00	SPY	ETF	447.25	447.965	446.94	447.666	2814358.0
2023-08-08 14:30:00	SPY	ETF	447.68	448.57	447.435	448.33	2763979.0
2023-08-08 15:00:00	SPY	ETF	448.34	448.79	448.15	448.5706	3006857.0
2023-08-08 15:30:00	SPY	ETF	448.575	449.23	448.19	448.75	7847671.0
2023-08-08 16:00:00	SPY	ETF	448.76	448.9	448.56	448.62	1973671.0
2023-08-08 16:30:00	SPY	ETF	448.65	448.74	448.63	448.7	141240.0
2023-08-08 17:00:00	SPY	ETF	448.73	448.76	448.6	448.64	14826.0
2023-08-08 17:30:00	SPY	ETF	448.62	448.74	448.62	448.68	16930.0
2023-08-08 18:00:00	SPY	ETF	448.71	448.79	448.64	448.67	20929.0
2023-08-08 18:30:00	SPY	ETF	448.67	448.68	448.56	448.6	14838.0
2023-08-08 19:00:00	SPY	ETF	448.75	448.75	448.57	448.63	11939.0
2023-08-08 19:30:00	SPY	ETF	448.64	448.71	448.54	448.62	19040.0
2023-08-08 04:00:00	QQQ	ETF	374.13	374.69	373.44	373.52	23297.0
2023-08-08 04:30:00	QQQ	ETF	373.43	373.93	373.43	373.93	25092.0
2023-08-08 05:00:00	QQQ	ETF	373.95	373.95	373.2	373.32	14411.0
2023-08-08 05:30:00	QQQ	ETF	373.36	373.64	373.23	373.64	9109.0
2023-08-08 06:00:00	QQQ	ETF	373.71	373.8	373.29	373.36	16424.0
2023-08-08 06:30:00	QQQ	ETF	373.25	373.46	373.07	373.25	33292.0
2023-08-08 07:00:00	QQQ	ETF	373.34	373.42	372.32	372.35	165764.0
2023-08-08 07:30:00	QQQ	ETF	372.36	373.01	371.97	372.45	215485.0
2023-08-08 08:00:00	QQQ	ETF	373.3394	375.471	371.2	372.33	318093.0
2023-08-08 08:30:00	QQQ	ETF	372.29	372.99	372.14	372.58	257600.0
2023-08-08 09:00:00	QQQ	ETF	372.55	372.85	372.19	372.62	180909.0
2023-08-08 09:30:00	QQQ	ETF	372.65	372.66	370.12	370.6099	5204949.0
2023-08-08 10:00:00	QQQ	ETF	370.59	370.93	369.43	370.425	4405508.0
2023-08-08 10:30:00	QQQ	ETF	370.43	370.66	369.07	369.11	3242252.0
2023-08-08 11:00:00	QQQ	ETF	369.12	369.91	368.86	369.8	2626042.0
2023-08-08 11:30:00	QQQ	ETF	369.815	370.05	368.82	369.18	2479664.0
2023-08-08 12:00:00	QQQ	ETF	369.185	370.27	369.05	369.98	1834348.0
2023-08-08 12:30:00	QQQ	ETF	369.98	370.58	369.64	370.11	1528769.0

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

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