PREVIEW / stock_30min / 2023-07-31

all stock 30-min files

  file:    by_date/stock_30min/2023/2023-07-31.parquet
  size:    2.1 MB
  rows:    104,167
  symbols: 1,567

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-07-31 04:00:00	AAPL	Stock	195.89	195.9	195.39	195.69	5745.0
2023-07-31 04:30:00	AAPL	Stock	195.74	195.81	195.62	195.81	5883.0
2023-07-31 05:00:00	AAPL	Stock	195.78	195.95	195.75	195.8	3561.0
2023-07-31 05:30:00	AAPL	Stock	195.75	195.84	195.57	195.7	4111.0
2023-07-31 06:00:00	AAPL	Stock	195.7	195.89	195.7	195.89	945.0
2023-07-31 06:30:00	AAPL	Stock	195.89	195.89	195.74	195.8	5088.0
2023-07-31 07:00:00	AAPL	Stock	195.83	196.22	195.78	196.15	40467.0
2023-07-31 07:30:00	AAPL	Stock	196.18	196.25	196.02	196.25	24744.0
2023-07-31 08:00:00	AAPL	Stock	196.0	196.54	195.51	196.42	121149.0
2023-07-31 08:30:00	AAPL	Stock	196.44	196.71	196.3	196.59	71129.0
2023-07-31 09:00:00	AAPL	Stock	196.6	196.64	196.02	196.02	140325.0
2023-07-31 09:30:00	AAPL	Stock	196.09	196.38	195.39	195.6	4442582.0
2023-07-31 10:00:00	AAPL	Stock	195.595	196.2899	195.26	196.24	2447720.0
2023-07-31 10:30:00	AAPL	Stock	196.25	196.435	195.881	196.26	2015755.0
2023-07-31 11:00:00	AAPL	Stock	196.27	196.49	196.055	196.175	1487843.0
2023-07-31 11:30:00	AAPL	Stock	196.19	196.37	195.95	196.1398	1426876.0
2023-07-31 12:00:00	AAPL	Stock	196.14	196.2833	195.77	196.1545	1427398.0
2023-07-31 12:30:00	AAPL	Stock	196.15	196.1789	195.89	195.91	826698.0
2023-07-31 13:00:00	AAPL	Stock	195.901	196.25	195.78	196.1299	1294705.0
2023-07-31 13:30:00	AAPL	Stock	196.125	196.39	196.07	196.2399	1005948.0
2023-07-31 14:00:00	AAPL	Stock	196.235	196.37	196.11	196.16	1073806.0
2023-07-31 14:30:00	AAPL	Stock	196.175	196.35	195.935	196.2974	1294116.0
2023-07-31 15:00:00	AAPL	Stock	196.3	196.31	195.955	196.0876	1223765.0
2023-07-31 15:30:00	AAPL	Stock	196.08	196.49	195.79	196.48	4420127.0
2023-07-31 16:00:00	AAPL	Stock	196.48	196.5	196.34	196.45	6647044.0
2023-07-31 16:30:00	AAPL	Stock	196.39	196.45	196.37	196.4	16833.0
2023-07-31 17:00:00	AAPL	Stock	196.38	196.4	196.35	196.35	11040.0
2023-07-31 17:30:00	AAPL	Stock	196.34	196.45	196.34	196.394	15845.0
2023-07-31 18:00:00	AAPL	Stock	196.39	196.41	196.3	196.33	15122.0
2023-07-31 18:30:00	AAPL	Stock	196.31	196.36	196.26	196.3	4779.0
2023-07-31 19:00:00	AAPL	Stock	196.32	196.35	196.24	196.32	7040.0
2023-07-31 19:30:00	AAPL	Stock	196.34	196.36	196.11	196.32	12999.0
2023-07-31 04:00:00	MSFT	Stock	338.0	338.0	337.5	337.5	2027.0
2023-07-31 04:30:00	MSFT	Stock	337.2	337.55	337.2	337.55	2746.0
2023-07-31 05:00:00	MSFT	Stock	337.45	337.65	337.45	337.5	1968.0
2023-07-31 05:30:00	MSFT	Stock	337.28	337.9	337.24	337.37	5228.0
2023-07-31 06:00:00	MSFT	Stock	337.3	337.36	337.3	337.36	610.0
2023-07-31 06:30:00	MSFT	Stock	337.26	337.32	336.82	337.17	2627.0
2023-07-31 07:00:00	MSFT	Stock	337.37	337.5	336.91	337.33	14502.0
2023-07-31 07:30:00	MSFT	Stock	337.33	338.05	337.25	338.05	9496.0
2023-07-31 08:00:00	MSFT	Stock	337.2	338.3	337.03	337.6	30637.0
2023-07-31 08:30:00	MSFT	Stock	337.65	338.15	337.65	337.9494	12857.0
2023-07-31 09:00:00	MSFT	Stock	337.75	337.8	335.88	336.78	34731.0
2023-07-31 09:30:00	MSFT	Stock	336.92	337.695	333.78	334.375	2568629.0
2023-07-31 10:00:00	MSFT	Stock	334.385	335.25	333.36	334.84	1675567.0
2023-07-31 10:30:00	MSFT	Stock	334.86	335.79	333.9	335.45	1130203.0
2023-07-31 11:00:00	MSFT	Stock	335.44	336.3436	334.52	334.57	1005849.0
2023-07-31 11:30:00	MSFT	Stock	334.59	334.7999	333.64	334.3384	1097156.0
2023-07-31 12:00:00	MSFT	Stock	334.34	334.835	334.27	334.69	584388.0
2023-07-31 12:30:00	MSFT	Stock	334.67	334.77	334.1	334.52	556075.0

> showing 50 of 104,167 rows — these rows as CSV

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