PREVIEW / stock_30min / 2023-02-09

all stock 30-min files

  file:    by_date/stock_30min/2023/2023-02-09.parquet
  size:    2.1 MB
  rows:    103,638
  symbols: 1,856

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-02-09 04:00:00	AAPL	Stock	152.98	153.31	152.93	153.12	29637.0
2023-02-09 04:30:00	AAPL	Stock	153.14	153.69	153.14	153.69	22457.0
2023-02-09 05:00:00	AAPL	Stock	153.68	153.72	153.53	153.58	12262.0
2023-02-09 05:30:00	AAPL	Stock	153.59	153.78	153.54	153.76	8959.0
2023-02-09 06:00:00	AAPL	Stock	153.76	153.79	153.57	153.6	11486.0
2023-02-09 06:30:00	AAPL	Stock	153.63	153.71	153.5	153.6	18037.0
2023-02-09 07:00:00	AAPL	Stock	153.63	153.7	153.5	153.64	48991.0
2023-02-09 07:30:00	AAPL	Stock	153.62	153.74	153.35	153.37	24763.0
2023-02-09 08:00:00	AAPL	Stock	153.5	153.7515	151.541	153.54	157427.0
2023-02-09 08:30:00	AAPL	Stock	153.56	153.9466	153.56	153.88	133092.0
2023-02-09 09:00:00	AAPL	Stock	153.87	153.9	153.6	153.79	144317.0
2023-02-09 09:30:00	AAPL	Stock	153.775	154.33	152.8	153.27	6103856.0
2023-02-09 10:00:00	AAPL	Stock	153.27	153.76	152.65	152.82	3722384.0
2023-02-09 10:30:00	AAPL	Stock	152.8201	153.33	152.6	153.315	2788083.0
2023-02-09 11:00:00	AAPL	Stock	153.31	153.49	152.62	152.87	3181052.0
2023-02-09 11:30:00	AAPL	Stock	152.8899	153.251	152.73	153.2399	2311380.0
2023-02-09 12:00:00	AAPL	Stock	153.24	153.61	153.1	153.1126	2211089.0
2023-02-09 12:30:00	AAPL	Stock	153.11	153.18	152.23	152.734	2496987.0
2023-02-09 13:00:00	AAPL	Stock	152.73	152.73	152.1	152.44	1935145.0
2023-02-09 13:30:00	AAPL	Stock	152.464	152.76	151.94	152.1	1701212.0
2023-02-09 14:00:00	AAPL	Stock	152.11	152.32	151.86	151.96	1837887.0
2023-02-09 14:30:00	AAPL	Stock	151.95	152.19	151.73	151.7699	1897235.0
2023-02-09 15:00:00	AAPL	Stock	151.77	151.79	150.89	150.97	2463523.0
2023-02-09 15:30:00	AAPL	Stock	150.96	151.48	150.42	150.88	6077231.0
2023-02-09 16:00:00	AAPL	Stock	150.88	150.97	150.7	150.96	7121947.0
2023-02-09 16:30:00	AAPL	Stock	150.97	151.55	150.87	151.29	124187.0
2023-02-09 17:00:00	AAPL	Stock	151.3	151.3	151.03	151.04	17678.0
2023-02-09 17:30:00	AAPL	Stock	151.06	151.13	151.0	151.03	15411.0
2023-02-09 18:00:00	AAPL	Stock	151.03	151.21	150.9	151.19	20645.0
2023-02-09 18:30:00	AAPL	Stock	151.1	151.1	150.95	151.01	12843.0
2023-02-09 19:00:00	AAPL	Stock	151.0	151.0	150.6	150.6	15407.0
2023-02-09 19:30:00	AAPL	Stock	150.6	150.83	150.55	150.75	24665.0
2023-02-09 04:00:00	MSFT	Stock	269.99	270.7	269.81	270.36	19663.0
2023-02-09 04:30:00	MSFT	Stock	270.41	271.82	270.4	271.82	13004.0
2023-02-09 05:00:00	MSFT	Stock	271.69	271.78	271.46	271.52	4711.0
2023-02-09 05:30:00	MSFT	Stock	271.5	272.14	271.28	272.1	5522.0
2023-02-09 06:00:00	MSFT	Stock	272.05	272.1	271.5	271.51	7850.0
2023-02-09 06:30:00	MSFT	Stock	271.8	271.8	271.2	271.54	4464.0
2023-02-09 07:00:00	MSFT	Stock	271.79	271.8	271.12	271.5	34377.0
2023-02-09 07:30:00	MSFT	Stock	271.47	271.66	271.0	271.11	45425.0
2023-02-09 08:00:00	MSFT	Stock	271.54	272.1785	266.064	271.4906	98115.0
2023-02-09 08:30:00	MSFT	Stock	271.43	272.83	271.43	272.48	85489.0
2023-02-09 09:00:00	MSFT	Stock	272.44	274.26	271.6	273.86	218894.0
2023-02-09 09:30:00	MSFT	Stock	273.8	273.98	269.66	271.5	5074968.0
2023-02-09 10:00:00	MSFT	Stock	271.495	272.7	269.92	270.25	2520522.0
2023-02-09 10:30:00	MSFT	Stock	270.22	271.19	269.51	270.86	1623130.0
2023-02-09 11:00:00	MSFT	Stock	270.855	270.855	268.495	268.94	1417785.0
2023-02-09 11:30:00	MSFT	Stock	268.97	269.94	268.47	268.83	1313313.0
2023-02-09 12:00:00	MSFT	Stock	268.81	269.88	268.53	268.705	1037202.0
2023-02-09 12:30:00	MSFT	Stock	268.71	268.83	266.99	267.73	1333525.0

> showing 50 of 103,638 rows — these rows as CSV

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