PREVIEW / stock_30min / 2023-01-05

all stock 30-min files

  file:    by_date/stock_30min/2023/2023-01-05.parquet
  size:    2.1 MB
  rows:    102,028
  symbols: 1,962

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-01-05 04:00:00	AAPL	Stock	127.0	127.0	125.95	126.34	81396.0
2023-01-05 04:30:00	AAPL	Stock	126.4	126.5	126.12	126.4	32481.0
2023-01-05 05:00:00	AAPL	Stock	126.4	126.9	126.39	126.9	10364.0
2023-01-05 05:30:00	AAPL	Stock	126.72	126.72	125.79	125.92	79217.0
2023-01-05 06:00:00	AAPL	Stock	125.96	126.64	125.96	126.48	51429.0
2023-01-05 06:30:00	AAPL	Stock	126.46	127.09	126.46	126.99	34685.0
2023-01-05 07:00:00	AAPL	Stock	126.93	127.44	126.87	127.15	45720.0
2023-01-05 07:30:00	AAPL	Stock	127.25	127.88	127.25	127.6	80724.0
2023-01-05 08:00:00	AAPL	Stock	127.05	127.87	126.25	127.27	341013.0
2023-01-05 08:30:00	AAPL	Stock	127.25	127.25	126.63	126.92	242651.0
2023-01-05 09:00:00	AAPL	Stock	126.9115	127.32	126.6	127.15	257468.0
2023-01-05 09:30:00	AAPL	Stock	127.13	127.4891	125.32	127.38	10608538.0
2023-01-05 10:00:00	AAPL	Stock	127.3699	127.77	126.64	126.76	6350297.0
2023-01-05 10:30:00	AAPL	Stock	126.77	127.03	126.16	126.42	5051943.0
2023-01-05 11:00:00	AAPL	Stock	126.42	127.0	126.15	126.5599	3812413.0
2023-01-05 11:30:00	AAPL	Stock	126.55	127.08	126.43	126.68	3781526.0
2023-01-05 12:00:00	AAPL	Stock	126.68	126.955	126.2	126.5032	2644718.0
2023-01-05 12:30:00	AAPL	Stock	126.5	126.8	126.18	126.2474	2021224.0
2023-01-05 13:00:00	AAPL	Stock	126.245	126.87	125.8001	126.48	3880271.0
2023-01-05 13:30:00	AAPL	Stock	126.49	127.04	126.18	126.27	3076459.0
2023-01-05 14:00:00	AAPL	Stock	126.28	126.47	125.81	125.8887	2492142.0
2023-01-05 14:30:00	AAPL	Stock	125.89	126.38	125.475	125.48	4090397.0
2023-01-05 15:00:00	AAPL	Stock	125.485	125.53	125.03	125.16	4467203.0
2023-01-05 15:30:00	AAPL	Stock	125.17	125.3	124.76	125.03	8084488.0
2023-01-05 16:00:00	AAPL	Stock	125.02	125.3	124.99	125.19	7877736.0
2023-01-05 16:30:00	AAPL	Stock	125.19	125.34	125.02	125.16	92222.0
2023-01-05 17:00:00	AAPL	Stock	125.15	125.15	125.05	125.13	37430.0
2023-01-05 17:30:00	AAPL	Stock	125.13	125.15	125.06	125.1	24945.0
2023-01-05 18:00:00	AAPL	Stock	125.13	125.23	125.1	125.13	10566.0
2023-01-05 18:30:00	AAPL	Stock	125.14	125.18	124.8	125.17	61411.0
2023-01-05 19:00:00	AAPL	Stock	125.17	125.23	125.12	125.14	13848.0
2023-01-05 19:30:00	AAPL	Stock	125.18	125.25	125.15	125.25	20828.0
2023-01-05 04:00:00	MSFT	Stock	227.8	228.2	227.65	228.2	3280.0
2023-01-05 04:30:00	MSFT	Stock	228.01	228.34	227.73	228.34	5396.0
2023-01-05 05:00:00	MSFT	Stock	228.33	228.87	228.19	228.6	8412.0
2023-01-05 05:30:00	MSFT	Stock	228.65	229.2	228.65	229.1	5577.0
2023-01-05 06:00:00	MSFT	Stock	229.3	229.71	229.15	229.4	20092.0
2023-01-05 06:30:00	MSFT	Stock	229.39	229.88	229.39	229.88	4911.0
2023-01-05 07:00:00	MSFT	Stock	229.57	229.84	229.42	229.66	11549.0
2023-01-05 07:30:00	MSFT	Stock	229.56	229.89	228.81	229.1	11188.0
2023-01-05 08:00:00	MSFT	Stock	229.53	229.8	226.67	228.01	47709.0
2023-01-05 08:30:00	MSFT	Stock	228.01	228.02	227.0	227.3	41888.0
2023-01-05 09:00:00	MSFT	Stock	227.2	227.95	226.52	227.4	47114.0
2023-01-05 09:30:00	MSFT	Stock	227.2	227.55	223.67	225.11	4304264.0
2023-01-05 10:00:00	MSFT	Stock	225.12	226.22	224.43	225.11	2463698.0
2023-01-05 10:30:00	MSFT	Stock	225.146	225.2334	223.84	224.2	1774199.0
2023-01-05 11:00:00	MSFT	Stock	224.19	224.78	223.65	223.915	1382040.0
2023-01-05 11:30:00	MSFT	Stock	223.9	223.98	223.08	223.105	1792558.0
2023-01-05 12:00:00	MSFT	Stock	223.11	223.65	222.6	223.119	1645049.0
2023-01-05 12:30:00	MSFT	Stock	223.1	223.67	222.24	222.24	1406781.0

> showing 50 of 102,028 rows — these rows as CSV

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