PREVIEW / etf_30min / 2023-07-12

all etf 30-min files

  file:    by_date/etf_30min/2023/2023-07-12.parquet
  size:    724 KB
  rows:    29,038

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-07-12 04:00:00	SPY	ETF	443.12	443.34	443.0	443.21	18304.0
2023-07-12 04:30:00	SPY	ETF	443.26	443.29	443.21	443.29	2451.0
2023-07-12 05:00:00	SPY	ETF	443.32	443.55	443.32	443.45	4706.0
2023-07-12 05:30:00	SPY	ETF	443.47	443.57	443.4	443.46	8601.0
2023-07-12 06:00:00	SPY	ETF	443.45	443.45	443.24	443.33	10239.0
2023-07-12 06:30:00	SPY	ETF	443.32	443.4	443.25	443.3	4659.0
2023-07-12 07:00:00	SPY	ETF	443.22	443.71	443.21	443.71	71587.0
2023-07-12 07:30:00	SPY	ETF	443.67	443.83	443.67	443.69	43050.0
2023-07-12 08:00:00	SPY	ETF	443.2501	444.0	442.78	443.64	350250.0
2023-07-12 08:30:00	SPY	ETF	443.44	446.22	443.44	445.66	1931357.0
2023-07-12 09:00:00	SPY	ETF	445.66	446.68	442.4	446.39	728298.0
2023-07-12 09:30:00	SPY	ETF	446.39	447.07	445.8318	446.93	8268653.0
2023-07-12 10:00:00	SPY	ETF	446.9401	447.34	446.52	447.2199	5282566.0
2023-07-12 10:30:00	SPY	ETF	447.22	447.4799	446.775	446.9894	3782996.0
2023-07-12 11:00:00	SPY	ETF	446.98	447.12	446.55	446.62	2661196.0
2023-07-12 11:30:00	SPY	ETF	446.62	446.72	444.98	445.175	6911101.0
2023-07-12 12:00:00	SPY	ETF	445.17	445.755	444.91	445.35	4261135.0
2023-07-12 12:30:00	SPY	ETF	445.35	446.2	445.25	445.835	3042043.0
2023-07-12 13:00:00	SPY	ETF	445.835	446.24	445.65	446.1401	2015477.0
2023-07-12 13:30:00	SPY	ETF	446.16	446.46	446.075	446.34	1941851.0
2023-07-12 14:00:00	SPY	ETF	446.34	446.7403	446.0	446.68	2687386.0
2023-07-12 14:30:00	SPY	ETF	446.68	446.75	446.039	446.27	2391383.0
2023-07-12 15:00:00	SPY	ETF	446.27	446.385	445.15	445.64	3991267.0
2023-07-12 15:30:00	SPY	ETF	445.65	446.2	445.57	446.01	11441642.0
2023-07-12 16:00:00	SPY	ETF	446.01	446.31	445.7982	446.21	3581237.0
2023-07-12 16:30:00	SPY	ETF	446.2	446.27	446.09	446.09	71466.0
2023-07-12 17:00:00	SPY	ETF	446.12	446.25	446.02	446.06	27801.0
2023-07-12 17:30:00	SPY	ETF	446.06	446.12	446.03	446.11	212359.0
2023-07-12 18:00:00	SPY	ETF	446.11	446.5301	446.06	446.49	49301.0
2023-07-12 18:30:00	SPY	ETF	446.48	446.64	446.39	446.45	67823.0
2023-07-12 19:00:00	SPY	ETF	446.42	446.44	446.36	446.36	11904.0
2023-07-12 19:30:00	SPY	ETF	446.36	446.5	446.35	446.4	18982.0
2023-07-12 04:00:00	QQQ	ETF	369.0	369.16	368.88	369.04	20002.0
2023-07-12 04:30:00	QQQ	ETF	368.99	369.06	368.92	368.96	6431.0
2023-07-12 05:00:00	QQQ	ETF	369.0	369.3	368.95	369.26	8032.0
2023-07-12 05:30:00	QQQ	ETF	369.3	369.32	369.14	369.17	23608.0
2023-07-12 06:00:00	QQQ	ETF	369.11	369.15	368.95	368.98	21023.0
2023-07-12 06:30:00	QQQ	ETF	368.98	369.12	368.89	368.93	7941.0
2023-07-12 07:00:00	QQQ	ETF	368.94	369.42	368.89	369.37	58521.0
2023-07-12 07:30:00	QQQ	ETF	369.39	369.62	369.39	369.51	79776.0
2023-07-12 08:00:00	QQQ	ETF	368.96	369.68	368.3	369.65	280786.0
2023-07-12 08:30:00	QQQ	ETF	369.69	372.2	369.55	371.67	1545823.0
2023-07-12 09:00:00	QQQ	ETF	371.67	372.48	371.55	372.33	640985.0
2023-07-12 09:30:00	QQQ	ETF	372.34	373.29	371.81	373.11	7715579.0
2023-07-12 10:00:00	QQQ	ETF	373.11	374.19	372.91	373.73	4491191.0
2023-07-12 10:30:00	QQQ	ETF	373.74	374.09	372.76	373.05	2846040.0
2023-07-12 11:00:00	QQQ	ETF	373.05	373.46	372.62	372.81	2942070.0
2023-07-12 11:30:00	QQQ	ETF	372.81	373.01	370.3	370.705	4858911.0
2023-07-12 12:00:00	QQQ	ETF	370.7	371.52	370.43	371.39	3191389.0
2023-07-12 12:30:00	QQQ	ETF	371.37	372.45	371.255	371.9575	2607204.0

> showing 50 of 29,038 rows — these rows as CSV

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