PREVIEW / stock_30min / 2023-05-16

all stock 30-min files

  file:    by_date/stock_30min/2023/2023-05-16.parquet
  size:    2.1 MB
  rows:    100,714
  symbols: 1,685

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-05-16 04:00:00	AAPL	Stock	172.59	172.67	172.2	172.25	5642.0
2023-05-16 04:30:00	AAPL	Stock	172.24	172.24	172.14	172.19	1128.0
2023-05-16 05:00:00	AAPL	Stock	172.25	172.25	172.25	172.25	199.0
2023-05-16 05:30:00	AAPL	Stock	172.1	172.1	172.02	172.07	2083.0
2023-05-16 06:00:00	AAPL	Stock	172.03	172.09	171.99	172.09	6267.0
2023-05-16 06:30:00	AAPL	Stock	172.09	172.1	172.02	172.07	5657.0
2023-05-16 07:00:00	AAPL	Stock	172.1	172.1	171.92	171.92	6277.0
2023-05-16 07:30:00	AAPL	Stock	171.91	172.02	171.91	172.01	4477.0
2023-05-16 08:00:00	AAPL	Stock	172.15	172.18	171.63	172.0	31145.0
2023-05-16 08:30:00	AAPL	Stock	172.0	172.1	171.63	171.71	60580.0
2023-05-16 09:00:00	AAPL	Stock	171.67	172.0	171.33	171.99	77721.0
2023-05-16 09:30:00	AAPL	Stock	171.99	173.1383	171.98	172.62	6438680.0
2023-05-16 10:00:00	AAPL	Stock	172.62	172.7	172.1	172.41	3052047.0
2023-05-16 10:30:00	AAPL	Stock	172.41	172.57	171.88	172.28	2734283.0
2023-05-16 11:00:00	AAPL	Stock	172.29	172.35	171.92	172.31	2140388.0
2023-05-16 11:30:00	AAPL	Stock	172.31	172.3301	171.83	172.22	1991864.0
2023-05-16 12:00:00	AAPL	Stock	172.225	172.51	172.13	172.25	1489872.0
2023-05-16 12:30:00	AAPL	Stock	172.249	172.355	171.97	172.18	1327194.0
2023-05-16 13:00:00	AAPL	Stock	172.181	172.32	172.04	172.1611	1082105.0
2023-05-16 13:30:00	AAPL	Stock	172.16	172.34	172.08	172.3078	1087536.0
2023-05-16 14:00:00	AAPL	Stock	172.31	172.35	171.7991	171.9	1447461.0
2023-05-16 14:30:00	AAPL	Stock	171.9	172.47	171.8678	172.39	1775419.0
2023-05-16 15:00:00	AAPL	Stock	172.395	172.725	172.33	172.665	1860239.0
2023-05-16 15:30:00	AAPL	Stock	172.66	172.697	172.03	172.08	3817836.0
2023-05-16 16:00:00	AAPL	Stock	172.075	172.19	172.0106	172.15	3146634.0
2023-05-16 16:30:00	AAPL	Stock	172.14	172.3	172.07	172.26	32518.0
2023-05-16 17:00:00	AAPL	Stock	172.25	172.3	172.25	172.2841	7902.0
2023-05-16 17:30:00	AAPL	Stock	172.2501	172.27	172.17	172.17	12171.0
2023-05-16 18:00:00	AAPL	Stock	172.15	172.26	172.12	172.14	8405.0
2023-05-16 18:30:00	AAPL	Stock	172.14	172.1833	172.11	172.18	6663.0
2023-05-16 19:00:00	AAPL	Stock	172.21	172.24	172.17	172.2	5814.0
2023-05-16 19:30:00	AAPL	Stock	172.17	172.23	172.15	172.23	12065.0
2023-05-16 04:00:00	MSFT	Stock	309.65	309.95	309.61	309.9	1070.0
2023-05-16 04:30:00	MSFT	Stock	309.7	309.7	309.5	309.5	1529.0
2023-05-16 05:00:00	MSFT	Stock	309.85	309.85	309.42	309.53	3171.0
2023-05-16 05:30:00	MSFT	Stock	309.5	309.5	309.44	309.44	1189.0
2023-05-16 06:00:00	MSFT	Stock	309.42	309.82	309.35	309.77	990.0
2023-05-16 06:30:00	MSFT	Stock	309.69	309.82	309.69	309.82	246.0
2023-05-16 07:00:00	MSFT	Stock	309.8	309.9	309.42	309.42	3860.0
2023-05-16 07:30:00	MSFT	Stock	309.41	309.57	309.41	309.57	1107.0
2023-05-16 08:00:00	MSFT	Stock	309.85	309.89	308.94	309.75	10948.0
2023-05-16 08:30:00	MSFT	Stock	309.75	310.0	309.06	309.26	15615.0
2023-05-16 09:00:00	MSFT	Stock	309.26	310.46	308.98	310.11	17346.0
2023-05-16 09:30:00	MSFT	Stock	309.83	313.71	309.83	312.15	3621201.0
2023-05-16 10:00:00	MSFT	Stock	312.18	312.64	311.1	312.26	1528550.0
2023-05-16 10:30:00	MSFT	Stock	312.28	313.24	311.69	312.8	984258.0
2023-05-16 11:00:00	MSFT	Stock	312.7806	313.57	312.22	313.45	1270218.0
2023-05-16 11:30:00	MSFT	Stock	313.47	313.68	312.46	313.54	901193.0
2023-05-16 12:00:00	MSFT	Stock	313.54	313.6	312.97	313.16	839417.0
2023-05-16 12:30:00	MSFT	Stock	313.155	313.46	312.66	312.9	585839.0

> showing 50 of 100,714 rows — these rows as CSV

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