PREVIEW / stock_30min / 2023-05-24

all stock 30-min files

  file:    by_date/stock_30min/2023/2023-05-24.parquet
  size:    2.1 MB
  rows:    102,090
  symbols: 1,641

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-24 04:00:00	AAPL	Stock	171.49	171.49	171.08	171.15	18913.0
2023-05-24 04:30:00	AAPL	Stock	171.2	171.39	171.2	171.32	4744.0
2023-05-24 05:00:00	AAPL	Stock	171.25	171.44	171.25	171.39	5234.0
2023-05-24 05:30:00	AAPL	Stock	171.37	171.38	171.32	171.34	840.0
2023-05-24 06:00:00	AAPL	Stock	171.21	171.33	170.87	170.87	15340.0
2023-05-24 06:30:00	AAPL	Stock	170.92	171.09	170.88	170.95	13300.0
2023-05-24 07:00:00	AAPL	Stock	170.98	171.15	170.57	170.65	36401.0
2023-05-24 07:30:00	AAPL	Stock	170.68	170.82	170.41	170.5	39086.0
2023-05-24 08:00:00	AAPL	Stock	171.0983	171.57	170.4	170.55	70341.0
2023-05-24 08:30:00	AAPL	Stock	170.57	170.57	170.2232	170.3	74291.0
2023-05-24 09:00:00	AAPL	Stock	170.27	171.25	170.07	171.09	236201.0
2023-05-24 09:30:00	AAPL	Stock	171.09	172.27	170.52	171.835	5464460.0
2023-05-24 10:00:00	AAPL	Stock	171.84	171.9199	171.11	171.16	2704694.0
2023-05-24 10:30:00	AAPL	Stock	171.16	171.6	170.97	171.26	2394423.0
2023-05-24 11:00:00	AAPL	Stock	171.255	171.68	170.94	171.37	2141485.0
2023-05-24 11:30:00	AAPL	Stock	171.37	171.43	170.765	171.0	1871664.0
2023-05-24 12:00:00	AAPL	Stock	171.005	171.32	170.59	170.635	1608063.0
2023-05-24 12:30:00	AAPL	Stock	170.635	171.1	170.535	171.1	1273640.0
2023-05-24 13:00:00	AAPL	Stock	171.1	171.38	170.85	171.175	1462508.0
2023-05-24 13:30:00	AAPL	Stock	171.18	171.78	171.1287	171.6227	1655571.0
2023-05-24 14:00:00	AAPL	Stock	171.63	171.8	171.1001	171.19	1520538.0
2023-05-24 14:30:00	AAPL	Stock	171.18	171.44	171.03	171.33	1483480.0
2023-05-24 15:00:00	AAPL	Stock	171.33	172.2	171.15	172.105	2376209.0
2023-05-24 15:30:00	AAPL	Stock	172.11	172.4183	171.65	171.85	4269765.0
2023-05-24 16:00:00	AAPL	Stock	171.84	172.44	171.4871	171.78	4157134.0
2023-05-24 16:30:00	AAPL	Stock	171.79	171.84	170.81	171.57	212118.0
2023-05-24 17:00:00	AAPL	Stock	171.55	171.7	171.25	171.42	113901.0
2023-05-24 17:30:00	AAPL	Stock	171.43	171.73	171.3245	171.61	42391.0
2023-05-24 18:00:00	AAPL	Stock	171.61	171.69	171.22	171.31	71238.0
2023-05-24 18:30:00	AAPL	Stock	171.38	171.4	171.0	171.04	50434.0
2023-05-24 19:00:00	AAPL	Stock	171.18	171.18	170.85	170.88	34025.0
2023-05-24 19:30:00	AAPL	Stock	170.88	171.15	170.84	171.0	37182.0
2023-05-24 04:00:00	MSFT	Stock	315.0	315.2	314.5	314.65	3274.0
2023-05-24 04:30:00	MSFT	Stock	314.61	315.2	314.61	315.2	3181.0
2023-05-24 05:00:00	MSFT	Stock	315.4	315.79	315.21	315.75	2943.0
2023-05-24 05:30:00	MSFT	Stock	315.62	315.7	315.31	315.42	816.0
2023-05-24 06:00:00	MSFT	Stock	315.5	315.82	314.83	315.0	3796.0
2023-05-24 06:30:00	MSFT	Stock	314.8	314.8	314.73	314.79	804.0
2023-05-24 07:00:00	MSFT	Stock	315.0	315.26	314.6	314.6	6007.0
2023-05-24 07:30:00	MSFT	Stock	314.8	314.8	314.35	314.51	12137.0
2023-05-24 08:00:00	MSFT	Stock	314.9	315.5	314.26	314.3	23493.0
2023-05-24 08:30:00	MSFT	Stock	314.24	314.49	313.47	313.47	37661.0
2023-05-24 09:00:00	MSFT	Stock	313.46	315.0	313.35	315.0	61247.0
2023-05-24 09:30:00	MSFT	Stock	314.79	316.5	313.76	315.69	2413744.0
2023-05-24 10:00:00	MSFT	Stock	315.65	315.7	313.73	313.73	1304017.0
2023-05-24 10:30:00	MSFT	Stock	313.73	314.2	312.65	313.13	1298273.0
2023-05-24 11:00:00	MSFT	Stock	313.145	313.88	312.66	313.54	982677.0
2023-05-24 11:30:00	MSFT	Stock	313.56	314.06	313.17	313.31	761601.0
2023-05-24 12:00:00	MSFT	Stock	313.32	313.81	312.67	312.8226	738287.0
2023-05-24 12:30:00	MSFT	Stock	312.83	313.53	312.61	313.35	506725.0

> showing 50 of 102,090 rows — these rows as CSV

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