PREVIEW / etf_30min / 2023-08-14

all etf 30-min files

  file:    by_date/etf_30min/2023/2023-08-14.parquet
  size:    694 KB
  rows:    27,874

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-14 04:00:00	SPY	ETF	447.06	447.36	446.0	446.6	20936.0
2023-08-14 04:30:00	SPY	ETF	446.5	446.67	446.34	446.47	10530.0
2023-08-14 05:00:00	SPY	ETF	446.37	446.7	446.14	446.43	8611.0
2023-08-14 05:30:00	SPY	ETF	446.55	446.68	446.3	446.3	6560.0
2023-08-14 06:00:00	SPY	ETF	446.44	446.76	446.26	446.36	13149.0
2023-08-14 06:30:00	SPY	ETF	446.35	446.92	446.35	446.87	19201.0
2023-08-14 07:00:00	SPY	ETF	446.63	446.8	446.31	446.48	48322.0
2023-08-14 07:30:00	SPY	ETF	446.49	446.5	445.97	446.27	58151.0
2023-08-14 08:00:00	SPY	ETF	446.6514	447.0196	445.18	445.2	129600.0
2023-08-14 08:30:00	SPY	ETF	445.26	445.26	444.42	445.05	232077.0
2023-08-14 09:00:00	SPY	ETF	445.0	445.01	444.45	444.65	176089.0
2023-08-14 09:30:00	SPY	ETF	444.7	445.2962	444.38	445.19	4663635.0
2023-08-14 10:00:00	SPY	ETF	445.19	446.38	444.9306	445.89	3628541.0
2023-08-14 10:30:00	SPY	ETF	445.9099	447.6	445.8318	447.23	4384261.0
2023-08-14 11:00:00	SPY	ETF	447.23	447.3	446.57	447.15	2240366.0
2023-08-14 11:30:00	SPY	ETF	447.16	447.76	446.77	447.13	2331348.0
2023-08-14 12:00:00	SPY	ETF	447.14	447.46	446.37	446.67	1673700.0
2023-08-14 12:30:00	SPY	ETF	446.69	447.3	446.42	447.2199	1544535.0
2023-08-14 13:00:00	SPY	ETF	447.235	447.65	447.14	447.33	1613507.0
2023-08-14 13:30:00	SPY	ETF	447.34	447.505	446.74	447.111	1499446.0
2023-08-14 14:00:00	SPY	ETF	447.12	447.195	446.4919	446.81	1961793.0
2023-08-14 14:30:00	SPY	ETF	446.82	447.0	446.3	446.76	1993489.0
2023-08-14 15:00:00	SPY	ETF	446.77	447.17	446.49	446.855	1892700.0
2023-08-14 15:30:00	SPY	ETF	446.85	448.11	446.71	448.09	6750150.0
2023-08-14 16:00:00	SPY	ETF	448.09	448.18	447.99	448.14	2504188.0
2023-08-14 16:30:00	SPY	ETF	448.12	448.13	448.0406	448.08	129928.0
2023-08-14 17:00:00	SPY	ETF	448.08	448.19	447.95	448.08	128482.0
2023-08-14 17:30:00	SPY	ETF	448.06	448.09	448.03	448.08	32296.0
2023-08-14 18:00:00	SPY	ETF	448.06	448.5	447.95	448.49	41162.0
2023-08-14 18:30:00	SPY	ETF	448.55	448.83	448.49	448.76	17356.0
2023-08-14 19:00:00	SPY	ETF	448.78	448.78	448.41	448.47	7733.0
2023-08-14 19:30:00	SPY	ETF	448.51	448.62	448.46	448.56	20773.0
2023-08-14 04:00:00	QQQ	ETF	368.62	368.75	367.2	367.76	61710.0
2023-08-14 04:30:00	QQQ	ETF	367.45	367.8	367.43	367.5	27102.0
2023-08-14 05:00:00	QQQ	ETF	367.4	367.61	367.2	367.33	71229.0
2023-08-14 05:30:00	QQQ	ETF	367.41	367.61	367.08	367.22	8496.0
2023-08-14 06:00:00	QQQ	ETF	367.34	367.76	367.26	367.43	24812.0
2023-08-14 06:30:00	QQQ	ETF	367.49	367.86	367.49	367.58	9159.0
2023-08-14 07:00:00	QQQ	ETF	367.54	367.59	367.13	367.28	60929.0
2023-08-14 07:30:00	QQQ	ETF	367.3	367.37	366.7	367.0	106103.0
2023-08-14 08:00:00	QQQ	ETF	367.5409	367.57	365.1	365.98	141388.0
2023-08-14 08:30:00	QQQ	ETF	366.02	366.08	365.22	365.85	244021.0
2023-08-14 09:00:00	QQQ	ETF	365.84	365.87	365.09	365.43	171566.0
2023-08-14 09:30:00	QQQ	ETF	365.44	366.88	364.7	366.64	4834265.0
2023-08-14 10:00:00	QQQ	ETF	366.65	368.01	366.285	367.37	3178493.0
2023-08-14 10:30:00	QQQ	ETF	367.38	369.83	367.312	369.365	3491523.0
2023-08-14 11:00:00	QQQ	ETF	369.39	369.46	368.55	369.1801	2272125.0
2023-08-14 11:30:00	QQQ	ETF	369.18	369.785	368.67	368.97	1802017.0
2023-08-14 12:00:00	QQQ	ETF	368.975	369.37	368.0	368.42	1864417.0
2023-08-14 12:30:00	QQQ	ETF	368.45	369.07	368.17	369.035	1370734.0

> showing 50 of 27,874 rows — these rows as CSV

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