PREVIEW / stock_30min / 2023-10-04

all stock 30-min files

  file:    by_date/stock_30min/2023/2023-10-04.parquet
  size:    2.0 MB
  rows:    96,972
  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-10-04 04:00:00	AAPL	Stock	170.48	170.48	169.26	170.22	41175.0
2023-10-04 04:30:00	AAPL	Stock	170.22	170.35	169.8	170.35	41890.0
2023-10-04 05:00:00	AAPL	Stock	170.23	170.47	170.0	170.47	13920.0
2023-10-04 05:30:00	AAPL	Stock	170.46	170.69	170.36	170.57	13003.0
2023-10-04 06:00:00	AAPL	Stock	170.6	170.9	170.45	170.85	10886.0
2023-10-04 06:30:00	AAPL	Stock	170.6	170.72	170.35	170.72	8252.0
2023-10-04 07:00:00	AAPL	Stock	170.71	171.25	170.68	170.77	69944.0
2023-10-04 07:30:00	AAPL	Stock	170.76	171.0	170.66	170.9	34073.0
2023-10-04 08:00:00	AAPL	Stock	170.72	171.69	169.57	171.1925	225265.0
2023-10-04 08:30:00	AAPL	Stock	171.33	171.78	171.29	171.6	101548.0
2023-10-04 09:00:00	AAPL	Stock	171.61	171.61	170.86	171.12	173164.0
2023-10-04 09:30:00	AAPL	Stock	171.11	172.69	170.97	172.49	5863225.0
2023-10-04 10:00:00	AAPL	Stock	172.48	172.74	171.87	172.395	4401584.0
2023-10-04 10:30:00	AAPL	Stock	172.4	173.49	172.3	172.45	4409311.0
2023-10-04 11:00:00	AAPL	Stock	172.44	173.135	172.13	172.86	2954172.0
2023-10-04 11:30:00	AAPL	Stock	172.86	173.15	172.41	173.14	2073041.0
2023-10-04 12:00:00	AAPL	Stock	173.14	173.29	172.81	173.17	1846938.0
2023-10-04 12:30:00	AAPL	Stock	173.17	173.26	172.97	173.11	1326214.0
2023-10-04 13:00:00	AAPL	Stock	173.1	173.13	172.645	172.68	1399721.0
2023-10-04 13:30:00	AAPL	Stock	172.68	172.92	172.46	172.52	1642465.0
2023-10-04 14:00:00	AAPL	Stock	172.515	172.8245	172.35	172.74	1731777.0
2023-10-04 14:30:00	AAPL	Stock	172.74	173.1399	172.61	173.0792	1357412.0
2023-10-04 15:00:00	AAPL	Stock	173.09	173.815	173.03	173.7699	2640488.0
2023-10-04 15:30:00	AAPL	Stock	173.77	174.21	173.37	173.66	5988197.0
2023-10-04 16:00:00	AAPL	Stock	173.66	173.66	173.11	173.54	5803767.0
2023-10-04 16:30:00	AAPL	Stock	173.52	173.66	173.5	173.5001	69884.0
2023-10-04 17:00:00	AAPL	Stock	173.52	173.66	173.22	173.3767	27664.0
2023-10-04 17:30:00	AAPL	Stock	173.38	173.43	173.25	173.31	16292.0
2023-10-04 18:00:00	AAPL	Stock	173.3	173.43	173.25	173.27	16931.0
2023-10-04 18:30:00	AAPL	Stock	173.27	173.45	173.27	173.33	14025.0
2023-10-04 19:00:00	AAPL	Stock	173.31	173.43	173.31	173.43	4506.0
2023-10-04 19:30:00	AAPL	Stock	173.4	173.43	173.26	173.27	14991.0
2023-10-04 04:00:00	MSFT	Stock	311.68	311.68	310.99	311.55	35282.0
2023-10-04 04:30:00	MSFT	Stock	312.0	312.17	311.93	312.1	3427.0
2023-10-04 05:00:00	MSFT	Stock	311.95	312.4	311.95	312.39	1301.0
2023-10-04 05:30:00	MSFT	Stock	312.4	312.8	312.4	312.79	1857.0
2023-10-04 06:00:00	MSFT	Stock	312.77	312.8	312.77	312.8	1781.0
2023-10-04 06:30:00	MSFT	Stock	312.0	312.49	312.0	312.49	302.0
2023-10-04 07:00:00	MSFT	Stock	312.61	313.86	312.61	313.8	2991.0
2023-10-04 07:30:00	MSFT	Stock	313.62	314.7	313.6	314.3	6921.0
2023-10-04 08:00:00	MSFT	Stock	312.79	315.5	311.0	314.82	38670.0
2023-10-04 08:30:00	MSFT	Stock	314.8	315.79	314.5	315.0907	16497.0
2023-10-04 09:00:00	MSFT	Stock	315.0	315.3	314.0	314.04	19233.0
2023-10-04 09:30:00	MSFT	Stock	314.17	317.88	314.0	316.755	1814529.0
2023-10-04 10:00:00	MSFT	Stock	316.765	317.15	315.12	315.83	1062264.0
2023-10-04 10:30:00	MSFT	Stock	315.87	318.32	315.87	316.89	1033426.0
2023-10-04 11:00:00	MSFT	Stock	316.88	319.04	316.66	318.115	904379.0
2023-10-04 11:30:00	MSFT	Stock	318.14	319.25	317.94	319.07	549188.0
2023-10-04 12:00:00	MSFT	Stock	319.04	319.175	317.79	318.21	547995.0
2023-10-04 12:30:00	MSFT	Stock	318.34	318.5	317.92	318.15	502234.0

> showing 50 of 96,972 rows — these rows as CSV

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