PREVIEW / stock_30min / 2023-09-15

all stock 30-min files

  file:    by_date/stock_30min/2023/2023-09-15.parquet
  size:    2.0 MB
  rows:    99,722
  symbols: 1,426

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-09-15 04:00:00	AAPL	Stock	176.0	176.3	176.0	176.09	16304.0
2023-09-15 04:30:00	AAPL	Stock	176.09	176.28	175.92	175.96	14698.0
2023-09-15 05:00:00	AAPL	Stock	176.0	176.1	175.94	176.1	5931.0
2023-09-15 05:30:00	AAPL	Stock	176.11	176.18	176.05	176.17	6006.0
2023-09-15 06:00:00	AAPL	Stock	176.18	176.38	176.18	176.29	24453.0
2023-09-15 06:30:00	AAPL	Stock	176.29	176.49	176.28	176.39	7303.0
2023-09-15 07:00:00	AAPL	Stock	176.31	176.47	175.81	175.97	51479.0
2023-09-15 07:30:00	AAPL	Stock	176.06	176.33	176.04	176.05	14369.0
2023-09-15 08:00:00	AAPL	Stock	176.4	176.88	175.52	176.02	170657.0
2023-09-15 08:30:00	AAPL	Stock	176.0	177.4895	175.75	177.1	392745.0
2023-09-15 09:00:00	AAPL	Stock	177.19	177.43	175.55	176.45	958727.0
2023-09-15 09:30:00	AAPL	Stock	176.41	176.495	174.69	174.985	18792283.0
2023-09-15 10:00:00	AAPL	Stock	175.0	175.36	174.55	175.16	5315629.0
2023-09-15 10:30:00	AAPL	Stock	175.15	175.38	174.56	174.57	3955373.0
2023-09-15 11:00:00	AAPL	Stock	174.57	175.16	174.525	174.8657	3103910.0
2023-09-15 11:30:00	AAPL	Stock	174.86	175.0	174.59	174.952	2499508.0
2023-09-15 12:00:00	AAPL	Stock	174.96	175.15	174.71	174.74	2013276.0
2023-09-15 12:30:00	AAPL	Stock	174.73	175.015	174.675	174.99	1710343.0
2023-09-15 13:00:00	AAPL	Stock	174.99	175.04	174.01	174.08	2644239.0
2023-09-15 13:30:00	AAPL	Stock	174.07	174.29	173.82	174.26	2597566.0
2023-09-15 14:00:00	AAPL	Stock	174.26	174.63	174.16	174.245	2793421.0
2023-09-15 14:30:00	AAPL	Stock	174.24	174.56	174.155	174.3701	2382993.0
2023-09-15 15:00:00	AAPL	Stock	174.3799	174.8	174.1387	174.77	2955810.0
2023-09-15 15:30:00	AAPL	Stock	174.77	175.12	174.63	174.96	7042774.0
2023-09-15 16:00:00	AAPL	Stock	175.01	175.05	174.93	174.97	29894214.0
2023-09-15 16:30:00	AAPL	Stock	174.97	175.2	174.96	175.01	284846.0
2023-09-15 17:00:00	AAPL	Stock	175.01	175.02	174.92	174.98	107132.0
2023-09-15 17:30:00	AAPL	Stock	174.95	174.99	174.92	174.92	20715.0
2023-09-15 18:00:00	AAPL	Stock	174.9399	174.98	174.91	174.98	8091.0
2023-09-15 18:30:00	AAPL	Stock	174.95	174.9799	174.91	174.93	8869.0
2023-09-15 19:00:00	AAPL	Stock	174.92	174.92	174.7	174.74	13193.0
2023-09-15 19:30:00	AAPL	Stock	174.7301	174.89	174.72	174.83	9201.0
2023-09-15 04:00:00	MSFT	Stock	339.67	339.67	339.15	339.16	3006.0
2023-09-15 04:30:00	MSFT	Stock	339.07	339.17	339.07	339.15	659.0
2023-09-15 05:00:00	MSFT	Stock	339.03	339.09	338.49	338.49	1074.0
2023-09-15 05:30:00	MSFT	Stock	338.71	338.71	338.71	338.71	325.0
2023-09-15 06:30:00	MSFT	Stock	338.71	338.71	338.64	338.64	466.0
2023-09-15 07:00:00	MSFT	Stock	338.99	339.0	338.72	338.72	1725.0
2023-09-15 07:30:00	MSFT	Stock	338.78	338.92	338.78	338.8	1256.0
2023-09-15 08:00:00	MSFT	Stock	338.88	339.99	338.59	338.7	24942.0
2023-09-15 08:30:00	MSFT	Stock	338.55	338.72	337.7836	338.0	6648.0
2023-09-15 09:00:00	MSFT	Stock	337.9	338.64	336.42	336.97	134253.0
2023-09-15 09:30:00	MSFT	Stock	336.92	337.3975	332.35	333.2	7596478.0
2023-09-15 10:00:00	MSFT	Stock	333.24	333.8	332.03	333.5701	1282434.0
2023-09-15 10:30:00	MSFT	Stock	333.5516	333.98	332.6	332.62	705562.0
2023-09-15 11:00:00	MSFT	Stock	332.61	332.91	331.68	332.42	874333.0
2023-09-15 11:30:00	MSFT	Stock	332.44	332.52	331.58	332.2368	702870.0
2023-09-15 12:00:00	MSFT	Stock	332.28	332.81	332.11	332.47	572998.0
2023-09-15 12:30:00	MSFT	Stock	332.43	333.42	332.32	333.15	413182.0
2023-09-15 13:00:00	MSFT	Stock	333.1885	333.2	331.05	331.15	519063.0

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

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