PREVIEW / stock_30min / 2023-11-02

all stock 30-min files

  file:    by_date/stock_30min/2023/2023-11-02.parquet
  size:    2.0 MB
  rows:    99,686
  symbols: 1,346

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-11-02 04:00:00	AAPL	Stock	174.99	175.23	174.7	175.15	14244.0
2023-11-02 04:30:00	AAPL	Stock	175.15	175.2	175.02	175.2	11616.0
2023-11-02 05:00:00	AAPL	Stock	175.21	175.49	175.18	175.49	20170.0
2023-11-02 05:30:00	AAPL	Stock	175.5	175.63	175.44	175.6	8504.0
2023-11-02 06:00:00	AAPL	Stock	175.48	175.66	175.41	175.47	11556.0
2023-11-02 06:30:00	AAPL	Stock	175.45	175.67	175.33	175.64	5498.0
2023-11-02 07:00:00	AAPL	Stock	175.66	175.93	175.56	175.63	41722.0
2023-11-02 07:30:00	AAPL	Stock	175.64	175.88	175.51	175.63	35409.0
2023-11-02 08:00:00	AAPL	Stock	175.6026	175.95	174.755	175.8	144839.0
2023-11-02 08:30:00	AAPL	Stock	175.8	176.8	175.8	176.48	144925.0
2023-11-02 09:00:00	AAPL	Stock	176.4	176.6	175.25	175.5	203107.0
2023-11-02 09:30:00	AAPL	Stock	175.52	176.79	175.46	176.36	6032500.0
2023-11-02 10:00:00	AAPL	Stock	176.35	177.09	176.11	176.87	3835956.0
2023-11-02 10:30:00	AAPL	Stock	176.88	177.54	176.62	177.44	4133142.0
2023-11-02 11:00:00	AAPL	Stock	177.44	177.66	176.62	176.774	3784003.0
2023-11-02 11:30:00	AAPL	Stock	176.77	177.1	176.4388	176.7986	2277548.0
2023-11-02 12:00:00	AAPL	Stock	176.8	177.09	176.41	176.98	2630769.0
2023-11-02 12:30:00	AAPL	Stock	176.98	177.315	176.85	176.975	2390714.0
2023-11-02 13:00:00	AAPL	Stock	176.97	177.2747	176.78	177.088	2055448.0
2023-11-02 13:30:00	AAPL	Stock	177.08	177.61	177.08	177.31	2131200.0
2023-11-02 14:00:00	AAPL	Stock	177.3	177.48	177.09	177.3021	2340479.0
2023-11-02 14:30:00	AAPL	Stock	177.31	177.5	177.19	177.455	2116821.0
2023-11-02 15:00:00	AAPL	Stock	177.45	177.72	177.22	177.23	4067020.0
2023-11-02 15:30:00	AAPL	Stock	177.235	177.78	177.17	177.78	7881937.0
2023-11-02 16:00:00	AAPL	Stock	177.57	178.15	177.35	178.03	8418358.0
2023-11-02 16:30:00	AAPL	Stock	177.93	181.9	173.45	175.9	3772040.0
2023-11-02 17:00:00	AAPL	Stock	175.9	176.5	169.33	171.5	2431477.0
2023-11-02 17:30:00	AAPL	Stock	171.5	177.57	170.51	171.53	1197091.0
2023-11-02 18:00:00	AAPL	Stock	171.56	172.88	171.11	172.7899	534910.0
2023-11-02 18:30:00	AAPL	Stock	172.7604	173.11	172.11	172.28	297517.0
2023-11-02 19:00:00	AAPL	Stock	172.16	172.38	171.3	171.58	262053.0
2023-11-02 19:30:00	AAPL	Stock	171.56	171.7	171.2	171.57	236976.0
2023-11-02 04:00:00	MSFT	Stock	347.1	349.0	346.94	349.0	12394.0
2023-11-02 04:30:00	MSFT	Stock	349.01	349.4	348.9	349.4	6040.0
2023-11-02 05:00:00	MSFT	Stock	349.14	349.15	349.14	349.15	296.0
2023-11-02 05:30:00	MSFT	Stock	349.11	349.12	348.52	348.55	3959.0
2023-11-02 06:00:00	MSFT	Stock	348.59	348.76	348.2	348.27	6013.0
2023-11-02 06:30:00	MSFT	Stock	348.2	348.74	348.03	348.65	3110.0
2023-11-02 07:00:00	MSFT	Stock	348.62	349.05	348.5	348.81	27285.0
2023-11-02 07:30:00	MSFT	Stock	348.97	349.35	348.65	348.65	21816.0
2023-11-02 08:00:00	MSFT	Stock	348.99	349.4726	346.08	348.81	56891.0
2023-11-02 08:30:00	MSFT	Stock	349.0	349.6	348.8	349.5	40717.0
2023-11-02 09:00:00	MSFT	Stock	349.4	349.57	346.66	346.9	103260.0
2023-11-02 09:30:00	MSFT	Stock	347.13	347.73	344.77	346.43	3417642.0
2023-11-02 10:00:00	MSFT	Stock	346.43	347.6	345.3	347.33	1372611.0
2023-11-02 10:30:00	MSFT	Stock	347.365	348.77	346.39	348.54	1304388.0
2023-11-02 11:00:00	MSFT	Stock	348.55	348.8	347.34	347.44	942761.0
2023-11-02 11:30:00	MSFT	Stock	347.48	348.4	346.64	347.32	775575.0
2023-11-02 12:00:00	MSFT	Stock	347.37	347.53	346.48	347.41	518209.0
2023-11-02 12:30:00	MSFT	Stock	347.44	348.28	347.1801	347.7399	588077.0

> showing 50 of 99,686 rows — these rows as CSV

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