PREVIEW / stock_30min / 2024-07-18

all stock 30-min files

  file:    by_date/stock_30min/2024/2024-07-18.parquet
  size:    2.0 MB
  rows:    98,115
  symbols: 912

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
2024-07-18 04:00:00	AAPL	Stock	229.34	230.61	229.34	230.54	20731.0
2024-07-18 04:30:00	AAPL	Stock	230.54	231.17	230.4	231.04	9831.0
2024-07-18 05:00:00	AAPL	Stock	231.1	231.14	230.83	230.86	8871.0
2024-07-18 05:30:00	AAPL	Stock	230.8	230.8	229.71	230.48	11906.0
2024-07-18 06:00:00	AAPL	Stock	230.34	230.34	229.76	229.81	11190.0
2024-07-18 06:30:00	AAPL	Stock	230.1	230.45	230.07	230.07	6399.0
2024-07-18 07:00:00	AAPL	Stock	230.09	230.2	229.8	230.04	20893.0
2024-07-18 07:30:00	AAPL	Stock	229.95	230.25	229.88	230.0	12747.0
2024-07-18 08:00:00	AAPL	Stock	229.85	231.8	228.92	230.49	117007.0
2024-07-18 08:30:00	AAPL	Stock	230.49	230.97	230.34	230.94	82718.0
2024-07-18 09:00:00	AAPL	Stock	230.912	231.23	230.05	230.11	157878.0
2024-07-18 09:30:00	AAPL	Stock	230.14	230.44	226.59	227.03	5571649.0
2024-07-18 10:00:00	AAPL	Stock	227.005	228.67	226.75	227.89	3260879.0
2024-07-18 10:30:00	AAPL	Stock	227.88	228.01	225.13	226.59	4133575.0
2024-07-18 11:00:00	AAPL	Stock	226.59	226.69	222.78	222.99	5136076.0
2024-07-18 11:30:00	AAPL	Stock	222.98	224.03	222.27	223.49	3896958.0
2024-07-18 12:00:00	AAPL	Stock	223.49	223.6494	222.8	223.35	2468265.0
2024-07-18 12:30:00	AAPL	Stock	223.35	224.23	222.4	224.21	3113282.0
2024-07-18 13:00:00	AAPL	Stock	224.2	225.065	223.47	224.56	2344671.0
2024-07-18 13:30:00	AAPL	Stock	224.55	225.2	224.43	224.7	1599527.0
2024-07-18 14:00:00	AAPL	Stock	224.71	225.03	224.41	224.6001	1237017.0
2024-07-18 14:30:00	AAPL	Stock	224.59	224.83	224.15	224.785	1552817.0
2024-07-18 15:00:00	AAPL	Stock	224.78	225.07	223.4509	224.13	2182252.0
2024-07-18 15:30:00	AAPL	Stock	224.12	225.15	223.825	224.19	4063483.0
2024-07-18 16:00:00	AAPL	Stock	224.17	224.47	223.98	224.36	8995122.0
2024-07-18 16:30:00	AAPL	Stock	224.38	224.84	224.18	224.74	80421.0
2024-07-18 17:00:00	AAPL	Stock	224.73	225.1692	224.18	225.1592	43225.0
2024-07-18 17:30:00	AAPL	Stock	225.16	225.185	225.0	225.17	12837.0
2024-07-18 18:00:00	AAPL	Stock	225.17	225.24	224.85	224.85	25201.0
2024-07-18 18:30:00	AAPL	Stock	224.85	225.31	224.85	225.26	11810.0
2024-07-18 19:00:00	AAPL	Stock	225.25	225.3	225.09	225.28	3970.0
2024-07-18 19:30:00	AAPL	Stock	225.34	225.39	224.7	224.9887	9136.0
2024-07-18 04:00:00	MSFT	Stock	445.0	445.0	443.87	444.0	1288.0
2024-07-18 04:30:00	MSFT	Stock	444.23	445.57	444.23	445.57	2052.0
2024-07-18 05:00:00	MSFT	Stock	445.3	445.3	445.24	445.29	518.0
2024-07-18 05:30:00	MSFT	Stock	445.01	445.13	444.5	444.88	1322.0
2024-07-18 06:00:00	MSFT	Stock	444.8	444.8	444.1	444.1	1594.0
2024-07-18 06:30:00	MSFT	Stock	444.58	444.81	444.58	444.81	366.0
2024-07-18 07:00:00	MSFT	Stock	445.36	445.41	444.8	444.8	4644.0
2024-07-18 07:30:00	MSFT	Stock	444.9	445.57	444.9	445.33	2791.0
2024-07-18 08:00:00	MSFT	Stock	445.4935	446.23	444.31	445.738	8429.0
2024-07-18 08:30:00	MSFT	Stock	445.75	446.43	445.75	446.2	18871.0
2024-07-18 09:00:00	MSFT	Stock	446.14	447.0	443.34	444.39	61516.0
2024-07-18 09:30:00	MSFT	Stock	444.39	444.65	439.22	439.44	1809474.0
2024-07-18 10:00:00	MSFT	Stock	439.42	440.65	438.55	439.7889	985727.0
2024-07-18 10:30:00	MSFT	Stock	439.76	439.76	436.46	438.91	1000838.0
2024-07-18 11:00:00	MSFT	Stock	438.95	439.345	435.92	436.15	840778.0
2024-07-18 11:30:00	MSFT	Stock	436.17	437.05	434.72	434.9	919833.0
2024-07-18 12:00:00	MSFT	Stock	434.91	435.9592	434.4	435.765	577815.0
2024-07-18 12:30:00	MSFT	Stock	435.73	436.94	435.25	436.59	552504.0

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

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