PREVIEW / etf_30min / 2022-11-23

all etf 30-min files

  file:    by_date/etf_30min/2022/2022-11-23.parquet
  size:    682 KB
  rows:    26,870

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
2022-11-23 04:00:00	SPY	ETF	400.07	400.49	399.87	400.32	14703.0
2022-11-23 04:30:00	SPY	ETF	400.37	401.09	400.37	400.9	30473.0
2022-11-23 05:00:00	SPY	ETF	400.82	400.82	400.42	400.46	25126.0
2022-11-23 05:30:00	SPY	ETF	400.5	400.53	400.22	400.41	8747.0
2022-11-23 06:00:00	SPY	ETF	400.45	400.52	400.09	400.38	30107.0
2022-11-23 06:30:00	SPY	ETF	400.46	400.56	400.3	400.56	11604.0
2022-11-23 07:00:00	SPY	ETF	400.66	400.66	400.27	400.46	50651.0
2022-11-23 07:30:00	SPY	ETF	400.45	400.81	400.39	400.6	59006.0
2022-11-23 08:00:00	SPY	ETF	400.61	400.78	399.83	399.97	207257.0
2022-11-23 08:30:00	SPY	ETF	399.97	400.35	399.2	399.71	168821.0
2022-11-23 09:00:00	SPY	ETF	399.74	399.92	399.45	399.51	158447.0
2022-11-23 09:30:00	SPY	ETF	399.55	401.85	399.49	401.38	5400571.0
2022-11-23 10:00:00	SPY	ETF	401.41	402.07	400.69	401.925	3830280.0
2022-11-23 10:30:00	SPY	ETF	401.92	402.74	401.78	402.09	3226993.0
2022-11-23 11:00:00	SPY	ETF	402.11	402.5	401.84	402.11	2251654.0
2022-11-23 11:30:00	SPY	ETF	402.125	402.125	399.77	400.34	3568422.0
2022-11-23 12:00:00	SPY	ETF	400.34	401.02	400.24	400.77	2170881.0
2022-11-23 12:30:00	SPY	ETF	400.78	400.94	399.31	399.79	2385215.0
2022-11-23 13:00:00	SPY	ETF	399.795	400.65	399.55	400.65	1670634.0
2022-11-23 13:30:00	SPY	ETF	400.66	401.21	400.66	400.9699	1920218.0
2022-11-23 14:00:00	SPY	ETF	400.9886	402.88	400.21	402.3525	6120981.0
2022-11-23 14:30:00	SPY	ETF	402.351	402.7025	401.26	402.2	4017814.0
2022-11-23 15:00:00	SPY	ETF	402.21	402.93	401.78	402.4	3161545.0
2022-11-23 15:30:00	SPY	ETF	402.4	402.43	401.69	402.39	7143029.0
2022-11-23 16:00:00	SPY	ETF	402.39	402.84	402.22	402.8	2269300.0
2022-11-23 16:30:00	SPY	ETF	402.8	402.88	402.42	402.86	1286057.0
2022-11-23 17:00:00	SPY	ETF	402.84	402.88	402.73	402.86	33653.0
2022-11-23 17:30:00	SPY	ETF	402.86	402.98	402.86	402.9	24554.0
2022-11-23 18:00:00	SPY	ETF	402.89	403.0	402.82	402.86	32083.0
2022-11-23 18:30:00	SPY	ETF	402.86	403.08	402.74	403.05	21154.0
2022-11-23 19:00:00	SPY	ETF	403.05	403.25	403.04	403.12	15740.0
2022-11-23 19:30:00	SPY	ETF	403.14	403.19	402.9	403.07	40459.0
2022-11-23 04:00:00	QQQ	ETF	285.6	286.33	285.6	286.17	11427.0
2022-11-23 04:30:00	QQQ	ETF	286.16	286.68	286.15	286.56	15133.0
2022-11-23 05:00:00	QQQ	ETF	286.43	286.43	286.11	286.11	14133.0
2022-11-23 05:30:00	QQQ	ETF	286.23	286.33	285.95	286.2	16159.0
2022-11-23 06:00:00	QQQ	ETF	286.23	286.28	285.92	286.21	14034.0
2022-11-23 06:30:00	QQQ	ETF	286.4	286.6	286.3	286.6	23591.0
2022-11-23 07:00:00	QQQ	ETF	286.61	286.76	286.26	286.62	33633.0
2022-11-23 07:30:00	QQQ	ETF	286.58	287.01	286.58	286.8	61030.0
2022-11-23 08:00:00	QQQ	ETF	286.53	287.0	285.63	286.16	236985.0
2022-11-23 08:30:00	QQQ	ETF	286.16	286.63	285.71	286.17	304726.0
2022-11-23 09:00:00	QQQ	ETF	286.2101	286.38	285.91	285.98	313834.0
2022-11-23 09:30:00	QQQ	ETF	285.98	288.45	285.89	287.9401	4199467.0
2022-11-23 10:00:00	QQQ	ETF	287.99	288.8388	287.27	288.6381	2943816.0
2022-11-23 10:30:00	QQQ	ETF	288.64	289.37	288.575	289.06	1736482.0
2022-11-23 11:00:00	QQQ	ETF	289.0452	289.28	288.46	288.71	1346309.0
2022-11-23 11:30:00	QQQ	ETF	288.73	288.73	286.39	286.87	2338113.0
2022-11-23 12:00:00	QQQ	ETF	286.85	287.61	286.8	287.295	1503330.0
2022-11-23 12:30:00	QQQ	ETF	287.31	287.48	285.79	286.25	1760513.0

> showing 50 of 26,870 rows — these rows as CSV

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