PREVIEW / stock_30min / 2023-09-11

all stock 30-min files

  file:    by_date/stock_30min/2023/2023-09-11.parquet
  size:    2.0 MB
  rows:    98,470
  symbols: 1,419

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-09-11 04:00:00	AAPL	Stock	179.35	179.95	179.35	179.69	22719.0
2023-09-11 04:30:00	AAPL	Stock	179.68	179.69	179.4	179.43	6551.0
2023-09-11 05:00:00	AAPL	Stock	179.48	179.7	179.48	179.7	9833.0
2023-09-11 05:30:00	AAPL	Stock	179.7	179.7	179.52	179.56	10792.0
2023-09-11 06:00:00	AAPL	Stock	179.57	179.58	179.45	179.54	12677.0
2023-09-11 06:30:00	AAPL	Stock	179.6	179.74	179.58	179.65	13003.0
2023-09-11 07:00:00	AAPL	Stock	179.58	179.82	179.48	179.78	44559.0
2023-09-11 07:30:00	AAPL	Stock	179.83	180.11	179.25	180.04	137430.0
2023-09-11 08:00:00	AAPL	Stock	179.66	180.64	179.2	180.64	260615.0
2023-09-11 08:30:00	AAPL	Stock	180.62	180.8	180.5	180.68	152833.0
2023-09-11 09:00:00	AAPL	Stock	180.66	180.8	180.01	180.01	258794.0
2023-09-11 09:30:00	AAPL	Stock	180.08	180.3	177.48	178.01	8669641.0
2023-09-11 10:00:00	AAPL	Stock	178.01	178.33	177.4	177.89	4811071.0
2023-09-11 10:30:00	AAPL	Stock	177.9	178.22	177.34	177.8	3511641.0
2023-09-11 11:00:00	AAPL	Stock	177.79	178.95	177.755	178.75	3165521.0
2023-09-11 11:30:00	AAPL	Stock	178.75	178.805	178.2101	178.4201	2464089.0
2023-09-11 12:00:00	AAPL	Stock	178.42	178.86	178.25	178.685	2172124.0
2023-09-11 12:30:00	AAPL	Stock	178.6891	178.742	178.33	178.6646	2001034.0
2023-09-11 13:00:00	AAPL	Stock	178.67	179.3024	178.56	179.265	2045075.0
2023-09-11 13:30:00	AAPL	Stock	179.27	179.4274	179.01	179.245	1762042.0
2023-09-11 14:00:00	AAPL	Stock	179.25	179.55	179.04	179.515	2192741.0
2023-09-11 14:30:00	AAPL	Stock	179.515	179.675	179.36	179.6623	1571767.0
2023-09-11 15:00:00	AAPL	Stock	179.67	179.93	179.52	179.695	2733996.0
2023-09-11 15:30:00	AAPL	Stock	179.7	179.95	179.16	179.38	5196990.0
2023-09-11 16:00:00	AAPL	Stock	179.43	179.43	179.06	179.1	5466241.0
2023-09-11 16:30:00	AAPL	Stock	179.12	179.36	179.07	179.1	72296.0
2023-09-11 17:00:00	AAPL	Stock	179.1	179.22	179.05	179.1	22164.0
2023-09-11 17:30:00	AAPL	Stock	179.1109	179.1619	179.0	179.1	22539.0
2023-09-11 18:00:00	AAPL	Stock	179.1	179.34	179.0754	179.2022	16595.0
2023-09-11 18:30:00	AAPL	Stock	179.24	179.2807	179.2052	179.25	7261.0
2023-09-11 19:00:00	AAPL	Stock	179.29	179.44	179.29	179.4	18641.0
2023-09-11 19:30:00	AAPL	Stock	179.43	179.55	179.3	179.55	31761.0
2023-09-11 04:00:00	MSFT	Stock	335.53	335.65	335.05	335.2	2316.0
2023-09-11 04:30:00	MSFT	Stock	335.03	335.23	334.79	334.79	1290.0
2023-09-11 05:30:00	MSFT	Stock	335.42	335.42	335.42	335.42	313.0
2023-09-11 06:00:00	MSFT	Stock	335.16	335.29	334.47	334.49	3273.0
2023-09-11 06:30:00	MSFT	Stock	334.95	337.48	334.95	337.15	16047.0
2023-09-11 07:00:00	MSFT	Stock	337.0	337.43	336.8	336.9	9367.0
2023-09-11 07:30:00	MSFT	Stock	336.85	337.26	336.69	336.78	12554.0
2023-09-11 08:00:00	MSFT	Stock	337.0	337.32	333.435	337.03	22242.0
2023-09-11 08:30:00	MSFT	Stock	336.91	337.32	336.68	336.8301	12790.0
2023-09-11 09:00:00	MSFT	Stock	336.9	337.78	336.8	337.32	23575.0
2023-09-11 09:30:00	MSFT	Stock	337.41	338.07	335.89	336.59	1801695.0
2023-09-11 10:00:00	MSFT	Stock	336.62	337.23	335.43	336.575	935064.0
2023-09-11 10:30:00	MSFT	Stock	336.63	336.78	335.5	336.14	578897.0
2023-09-11 11:00:00	MSFT	Stock	336.14	337.38	335.9	337.19	460735.0
2023-09-11 11:30:00	MSFT	Stock	337.2	337.5	336.41	336.49	358592.0
2023-09-11 12:00:00	MSFT	Stock	336.48	337.12	336.33	336.99	430013.0
2023-09-11 12:30:00	MSFT	Stock	337.01	337.09	335.91	336.465	347609.0
2023-09-11 13:00:00	MSFT	Stock	336.47	337.05	336.3	337.03	298169.0

> showing 50 of 98,470 rows — these rows as CSV

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