PREVIEW / stock_30min / 2024-03-22

all stock 30-min files

  file:    by_date/stock_30min/2024/2024-03-22.parquet
  size:    2.1 MB
  rows:    98,843
  symbols: 1,052

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-03-22 04:00:00	AAPL	Stock	171.68	171.7	171.15	171.53	14837.0
2024-03-22 04:30:00	AAPL	Stock	171.7	171.74	171.4	171.63	4544.0
2024-03-22 05:00:00	AAPL	Stock	171.63	171.8	171.63	171.73	9036.0
2024-03-22 05:30:00	AAPL	Stock	171.78	171.8	171.7	171.74	9308.0
2024-03-22 06:00:00	AAPL	Stock	171.82	171.84	171.69	171.72	9180.0
2024-03-22 06:30:00	AAPL	Stock	171.73	171.74	171.4	171.45	4553.0
2024-03-22 07:00:00	AAPL	Stock	171.5	171.75	171.42	171.46	17438.0
2024-03-22 07:30:00	AAPL	Stock	171.42	171.59	171.02	171.05	35968.0
2024-03-22 08:00:00	AAPL	Stock	171.66	171.75	170.96	171.5	227465.0
2024-03-22 08:30:00	AAPL	Stock	171.5	172.11	171.4	172.05	152262.0
2024-03-22 09:00:00	AAPL	Stock	172.0498	172.55	171.44	171.65	388857.0
2024-03-22 09:30:00	AAPL	Stock	171.69	172.33	170.06	171.03	9699511.0
2024-03-22 10:00:00	AAPL	Stock	171.04	171.9	170.87	171.799	5320246.0
2024-03-22 10:30:00	AAPL	Stock	171.795	172.56	171.59	171.89	4539399.0
2024-03-22 11:00:00	AAPL	Stock	171.885	172.55	171.81	172.26	2867495.0
2024-03-22 11:30:00	AAPL	Stock	172.27	172.88	172.07	172.59	2602574.0
2024-03-22 12:00:00	AAPL	Stock	172.5904	172.9	172.15	172.365	2146037.0
2024-03-22 12:30:00	AAPL	Stock	172.365	172.665	172.08	172.65	2110481.0
2024-03-22 13:00:00	AAPL	Stock	172.64	172.94	172.52	172.614	2045823.0
2024-03-22 13:30:00	AAPL	Stock	172.62	172.68	172.36	172.665	1610628.0
2024-03-22 14:00:00	AAPL	Stock	172.66	172.685	172.37	172.62	1788533.0
2024-03-22 14:30:00	AAPL	Stock	172.6276	172.935	172.62	172.7499	2300002.0
2024-03-22 15:00:00	AAPL	Stock	172.7498	172.99	172.67	172.9869	2447831.0
2024-03-22 15:30:00	AAPL	Stock	172.9816	173.05	172.23	172.25	5599722.0
2024-03-22 16:00:00	AAPL	Stock	172.37	172.46	172.25	172.26	9942456.0
2024-03-22 16:30:00	AAPL	Stock	172.27	172.4447	172.27	172.42	120309.0
2024-03-22 17:00:00	AAPL	Stock	172.42	172.44	172.16	172.27	46790.0
2024-03-22 17:30:00	AAPL	Stock	172.16	172.28	172.16	172.2054	14332.0
2024-03-22 18:00:00	AAPL	Stock	172.24	172.27	172.2	172.2	7893.0
2024-03-22 18:30:00	AAPL	Stock	172.17	172.24	172.12	172.18	8624.0
2024-03-22 19:00:00	AAPL	Stock	172.12	172.16	172.08	172.081	7153.0
2024-03-22 19:30:00	AAPL	Stock	172.08	172.3	172.08	172.29	16433.0
2024-03-22 04:00:00	MSFT	Stock	430.06	430.1	429.8	429.88	1160.0
2024-03-22 04:30:00	MSFT	Stock	429.88	429.97	429.79	429.97	872.0
2024-03-22 05:00:00	MSFT	Stock	430.34	430.43	430.34	430.43	944.0
2024-03-22 06:00:00	MSFT	Stock	430.8	431.61	430.8	431.09	2143.0
2024-03-22 06:30:00	MSFT	Stock	431.1	431.1	430.8	430.8	2007.0
2024-03-22 07:00:00	MSFT	Stock	430.81	430.83	429.93	429.93	4805.0
2024-03-22 07:30:00	MSFT	Stock	430.0	430.0	428.1	428.33	6986.0
2024-03-22 08:00:00	MSFT	Stock	430.73	430.7816	428.0	428.2584	17858.0
2024-03-22 08:30:00	MSFT	Stock	428.16	428.6	428.15	428.42	2348.0
2024-03-22 09:00:00	MSFT	Stock	428.52	429.76	428.48	429.76	7116.0
2024-03-22 09:30:00	MSFT	Stock	429.7	429.7	427.18	427.95	889913.0
2024-03-22 10:00:00	MSFT	Stock	427.96	429.1	427.18	427.9	616150.0
2024-03-22 10:30:00	MSFT	Stock	427.91	428.31	426.71	427.08	588552.0
2024-03-22 11:00:00	MSFT	Stock	427.085	427.66	426.4025	426.49	480311.0
2024-03-22 11:30:00	MSFT	Stock	426.5	427.27	426.11	427.11	487969.0
2024-03-22 12:00:00	MSFT	Stock	427.14	427.43	426.07	427.06	373178.0
2024-03-22 12:30:00	MSFT	Stock	427.07	428.36	426.57	428.3599	426427.0
2024-03-22 13:00:00	MSFT	Stock	428.34	429.1	428.25	428.5	379142.0

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

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