PREVIEW / stock_30min / 2023-08-01

all stock 30-min files

  file:    by_date/stock_30min/2023/2023-08-01.parquet
  size:    2.1 MB
  rows:    103,180
  symbols: 1,534

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-01 04:00:00	AAPL	Stock	196.35	196.35	196.05	196.05	4101.0
2023-08-01 04:30:00	AAPL	Stock	196.0	196.0	195.89	195.95	6385.0
2023-08-01 05:00:00	AAPL	Stock	195.98	196.02	195.92	195.92	955.0
2023-08-01 05:30:00	AAPL	Stock	195.86	195.87	195.8	195.87	4672.0
2023-08-01 06:00:00	AAPL	Stock	195.9	196.0	195.88	196.0	1636.0
2023-08-01 06:30:00	AAPL	Stock	196.03	196.15	195.99	196.15	701.0
2023-08-01 07:00:00	AAPL	Stock	196.17	196.21	195.95	195.95	22003.0
2023-08-01 07:30:00	AAPL	Stock	195.95	196.09	195.8	195.9	32946.0
2023-08-01 08:00:00	AAPL	Stock	196.18	196.99	195.8	195.82	58726.0
2023-08-01 08:30:00	AAPL	Stock	195.83	196.05	195.79	195.88	54045.0
2023-08-01 09:00:00	AAPL	Stock	195.9	196.3	195.88	196.24	85376.0
2023-08-01 09:30:00	AAPL	Stock	196.23	196.73	195.8	196.455	3787848.0
2023-08-01 10:00:00	AAPL	Stock	196.46	196.68	195.28	195.475	3871626.0
2023-08-01 10:30:00	AAPL	Stock	195.48	195.96	195.33	195.8	2119464.0
2023-08-01 11:00:00	AAPL	Stock	195.81	196.18	195.6	196.115	1467127.0
2023-08-01 11:30:00	AAPL	Stock	196.11	196.145	195.77	195.915	1192401.0
2023-08-01 12:00:00	AAPL	Stock	195.91	195.92	195.41	195.4973	1233275.0
2023-08-01 12:30:00	AAPL	Stock	195.48	195.82	195.35	195.78	935306.0
2023-08-01 13:00:00	AAPL	Stock	195.78	196.04	195.55	195.7295	1024773.0
2023-08-01 13:30:00	AAPL	Stock	195.735	196.13	195.53	196.07	1134829.0
2023-08-01 14:00:00	AAPL	Stock	196.0675	196.2701	195.98	196.0533	1199612.0
2023-08-01 14:30:00	AAPL	Stock	196.055	196.12	195.68	195.88	1057988.0
2023-08-01 15:00:00	AAPL	Stock	195.88	196.1	195.7429	195.81	1200129.0
2023-08-01 15:30:00	AAPL	Stock	195.815	195.99	195.5	195.6	2842642.0
2023-08-01 16:00:00	AAPL	Stock	195.58	195.98	195.45	195.8	4493003.0
2023-08-01 16:30:00	AAPL	Stock	195.7899	195.93	195.6	195.72	34736.0
2023-08-01 17:00:00	AAPL	Stock	195.77	195.81	195.31	195.48	37589.0
2023-08-01 17:30:00	AAPL	Stock	195.45	195.6	195.05	195.2	77480.0
2023-08-01 18:00:00	AAPL	Stock	195.15	195.33	194.09	195.16	87823.0
2023-08-01 18:30:00	AAPL	Stock	195.23	195.33	195.09	195.33	30241.0
2023-08-01 19:00:00	AAPL	Stock	195.28	195.33	195.13	195.15	7147.0
2023-08-01 19:30:00	AAPL	Stock	195.14	195.3	195.02	195.3	18903.0
2023-08-01 04:00:00	MSFT	Stock	335.53	335.58	335.0	335.0	1608.0
2023-08-01 04:30:00	MSFT	Stock	334.71	334.71	334.71	334.71	200.0
2023-08-01 05:00:00	MSFT	Stock	334.75	334.85	334.75	334.75	2283.0
2023-08-01 05:30:00	MSFT	Stock	334.72	334.72	334.72	334.72	113.0
2023-08-01 06:00:00	MSFT	Stock	334.85	335.0	334.85	335.0	971.0
2023-08-01 06:30:00	MSFT	Stock	335.06	335.06	334.99	335.0	1127.0
2023-08-01 07:00:00	MSFT	Stock	335.3	335.46	334.76	334.76	2312.0
2023-08-01 07:30:00	MSFT	Stock	334.7	334.7	333.63	333.68	6517.0
2023-08-01 08:00:00	MSFT	Stock	335.5	337.35	333.6568	333.8	23214.0
2023-08-01 08:30:00	MSFT	Stock	333.76	333.93	333.58	333.82	8984.0
2023-08-01 09:00:00	MSFT	Stock	333.9	335.3	333.82	335.15	28517.0
2023-08-01 09:30:00	MSFT	Stock	335.09	335.65	333.7	334.3	1888271.0
2023-08-01 10:00:00	MSFT	Stock	334.27	335.82	333.8	335.72	1469162.0
2023-08-01 10:30:00	MSFT	Stock	335.758	337.83	335.62	337.02	1570029.0
2023-08-01 11:00:00	MSFT	Stock	337.01	337.9	336.51	337.7	748545.0
2023-08-01 11:30:00	MSFT	Stock	337.69	338.325	337.098	337.95	651827.0
2023-08-01 12:00:00	MSFT	Stock	337.95	338.0	337.0	337.235	510866.0
2023-08-01 12:30:00	MSFT	Stock	337.22	337.84	336.71	337.7764	412593.0

> showing 50 of 103,180 rows — these rows as CSV

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