PREVIEW / stock_30min / 2023-09-29

all stock 30-min files

  file:    by_date/stock_30min/2023/2023-09-29.parquet
  size:    2.0 MB
  rows:    97,290
  symbols: 1,385

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-29 04:00:00	AAPL	Stock	171.28	172.1	171.28	172.05	9747.0
2023-09-29 04:30:00	AAPL	Stock	172.13	172.34	172.0	172.0	14932.0
2023-09-29 05:00:00	AAPL	Stock	172.25	172.3	172.16	172.2	1400.0
2023-09-29 05:30:00	AAPL	Stock	172.06	172.2	172.01	172.2	2440.0
2023-09-29 06:00:00	AAPL	Stock	172.26	172.26	172.1	172.21	5499.0
2023-09-29 06:30:00	AAPL	Stock	172.18	172.2	171.89	171.95	6491.0
2023-09-29 07:00:00	AAPL	Stock	171.87	172.05	171.63	171.63	16113.0
2023-09-29 07:30:00	AAPL	Stock	171.7	171.94	171.32	171.75	15142.0
2023-09-29 08:00:00	AAPL	Stock	172.05	172.22	171.2	171.95	95708.0
2023-09-29 08:30:00	AAPL	Stock	171.94	172.74	171.9	172.64	148217.0
2023-09-29 09:00:00	AAPL	Stock	172.65	172.67	170.69	171.95	305996.0
2023-09-29 09:30:00	AAPL	Stock	172.02	172.8001	171.77	172.6977	5328956.0
2023-09-29 10:00:00	AAPL	Stock	172.7	173.07	172.04	172.25	3442461.0
2023-09-29 10:30:00	AAPL	Stock	172.27	172.79	172.21	172.435	2363440.0
2023-09-29 11:00:00	AAPL	Stock	172.44	172.76	172.02	172.06	2293724.0
2023-09-29 11:30:00	AAPL	Stock	172.06	172.09	171.58	171.9301	1906346.0
2023-09-29 12:00:00	AAPL	Stock	171.94	172.09	171.5301	171.835	1350745.0
2023-09-29 12:30:00	AAPL	Stock	171.84	171.93	171.17	171.325	1300132.0
2023-09-29 13:00:00	AAPL	Stock	171.33	171.33	170.73	171.23	1683096.0
2023-09-29 13:30:00	AAPL	Stock	171.23	171.3	170.62	170.63	1398550.0
2023-09-29 14:00:00	AAPL	Stock	170.62	171.0	170.38	170.54	1970973.0
2023-09-29 14:30:00	AAPL	Stock	170.545	171.565	170.341	171.5401	2344327.0
2023-09-29 15:00:00	AAPL	Stock	171.55	171.71	171.04	171.2899	2228448.0
2023-09-29 15:30:00	AAPL	Stock	171.28	171.92	170.76	171.22	5447973.0
2023-09-29 16:00:00	AAPL	Stock	171.21	171.73	171.09	171.65	9697838.0
2023-09-29 16:30:00	AAPL	Stock	171.65	171.65	171.21	171.59	38835.0
2023-09-29 17:00:00	AAPL	Stock	171.56	171.6	171.21	171.6	54448.0
2023-09-29 17:30:00	AAPL	Stock	171.5601	171.6	171.47	171.47	6631.0
2023-09-29 18:00:00	AAPL	Stock	171.45	171.4999	171.45	171.48	3882.0
2023-09-29 18:30:00	AAPL	Stock	171.45	171.55	171.23	171.24	12722.0
2023-09-29 19:00:00	AAPL	Stock	171.3	171.35	171.23	171.34	3502.0
2023-09-29 19:30:00	AAPL	Stock	171.3	171.32	171.2	171.23	17808.0
2023-09-29 04:00:00	MSFT	Stock	314.99	316.0	314.99	316.0	1507.0
2023-09-29 04:30:00	MSFT	Stock	315.97	315.97	315.72	315.84	1312.0
2023-09-29 05:00:00	MSFT	Stock	316.0	316.0	316.0	316.0	1379.0
2023-09-29 05:30:00	MSFT	Stock	316.16	316.16	316.16	316.16	735.0
2023-09-29 06:00:00	MSFT	Stock	316.26	316.55	316.21	316.55	1084.0
2023-09-29 06:30:00	MSFT	Stock	316.69	316.69	316.1	316.1	1928.0
2023-09-29 07:00:00	MSFT	Stock	316.1	316.3	316.1	316.11	5034.0
2023-09-29 07:30:00	MSFT	Stock	316.1	316.1	315.55	315.65	5408.0
2023-09-29 08:00:00	MSFT	Stock	316.1025	316.3798	314.5	315.7	17753.0
2023-09-29 08:30:00	MSFT	Stock	315.85	316.95	315.85	316.8	41316.0
2023-09-29 09:00:00	MSFT	Stock	316.8	318.43	316.42	317.93	90275.0
2023-09-29 09:30:00	MSFT	Stock	317.9	319.45	316.73	318.56	2022281.0
2023-09-29 10:00:00	MSFT	Stock	318.58	319.47	317.3401	317.79	1093451.0
2023-09-29 10:30:00	MSFT	Stock	317.82	318.44	317.36	317.4902	627278.0
2023-09-29 11:00:00	MSFT	Stock	317.53	318.89	317.25	317.2685	776211.0
2023-09-29 11:30:00	MSFT	Stock	317.29	318.0	317.085	317.58	578465.0
2023-09-29 12:00:00	MSFT	Stock	317.535	318.33	317.2364	317.89	484753.0
2023-09-29 12:30:00	MSFT	Stock	317.92	318.22	316.76	316.99	447921.0

> showing 50 of 97,290 rows — these rows as CSV

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