PREVIEW / stock_30min / 2022-02-23

all stock 30-min files

  file:    by_date/stock_30min/2022/2022-02-23.parquet
  size:    2.2 MB
  rows:    108,185
  symbols: 2,551

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
2022-02-23 04:00:00	AAPL	Stock	166.0	166.24	165.8	166.05	23379.0
2022-02-23 04:30:00	AAPL	Stock	166.02	166.2	165.9	165.98	3219.0
2022-02-23 05:00:00	AAPL	Stock	166.0	166.0	165.7	165.85	5293.0
2022-02-23 05:30:00	AAPL	Stock	165.83	165.98	165.42	165.62	6206.0
2022-02-23 06:00:00	AAPL	Stock	165.52	165.52	165.08	165.45	3139.0
2022-02-23 06:30:00	AAPL	Stock	165.51	165.56	165.11	165.27	6430.0
2022-02-23 07:00:00	AAPL	Stock	165.28	165.81	165.22	165.78	43512.0
2022-02-23 07:30:00	AAPL	Stock	165.77	166.02	165.77	165.94	24327.0
2022-02-23 08:00:00	AAPL	Stock	165.4899	166.49	165.38	165.73	194996.0
2022-02-23 08:30:00	AAPL	Stock	165.74	165.94	165.58	165.87	77428.0
2022-02-23 09:00:00	AAPL	Stock	165.84	166.1	165.33	165.58	209286.0
2022-02-23 09:30:00	AAPL	Stock	165.58	166.15	164.39	164.525	8020246.0
2022-02-23 10:00:00	AAPL	Stock	164.52	164.66	163.72	163.89	4685503.0
2022-02-23 10:30:00	AAPL	Stock	163.88	164.22	163.31	163.4585	3344086.0
2022-02-23 11:00:00	AAPL	Stock	163.45	163.6	162.81	162.935	3644183.0
2022-02-23 11:30:00	AAPL	Stock	162.925	163.99	162.77	163.84	3439645.0
2022-02-23 12:00:00	AAPL	Stock	163.84	164.47	163.57	164.3049	2761819.0
2022-02-23 12:30:00	AAPL	Stock	164.33	164.38	163.19	163.3	2522122.0
2022-02-23 13:00:00	AAPL	Stock	163.3	163.3	162.07	162.16	3271104.0
2022-02-23 13:30:00	AAPL	Stock	162.1601	162.65	161.82	162.205	3472677.0
2022-02-23 14:00:00	AAPL	Stock	162.2	162.435	161.31	161.43	4177664.0
2022-02-23 14:30:00	AAPL	Stock	161.44	161.59	160.685	160.96	3883924.0
2022-02-23 15:00:00	AAPL	Stock	160.955	161.07	160.302	160.8	6283981.0
2022-02-23 15:30:00	AAPL	Stock	160.8	160.985	159.75	160.17	12971679.0
2022-02-23 16:00:00	AAPL	Stock	160.08	160.83	160.07	160.49	9841022.0
2022-02-23 16:30:00	AAPL	Stock	160.41	160.48	159.91	160.0	166790.0
2022-02-23 17:00:00	AAPL	Stock	159.93	160.07	159.7	159.7	93798.0
2022-02-23 17:30:00	AAPL	Stock	159.71	159.99	159.57	159.81	34140.0
2022-02-23 18:00:00	AAPL	Stock	159.93	160.43	159.7	160.0	100987.0
2022-02-23 18:30:00	AAPL	Stock	159.92	160.56	159.92	160.32	55945.0
2022-02-23 19:00:00	AAPL	Stock	160.33	160.49	159.55	159.55	95128.0
2022-02-23 19:30:00	AAPL	Stock	159.78	159.8	159.1	159.21	76697.0
2022-02-23 04:00:00	MSFT	Stock	289.91	291.48	289.91	291.3	10616.0
2022-02-23 04:30:00	MSFT	Stock	291.49	291.83	291.03	291.03	1405.0
2022-02-23 05:00:00	MSFT	Stock	291.2	291.2	290.25	290.25	972.0
2022-02-23 05:30:00	MSFT	Stock	290.75	291.0	290.2	290.2	2014.0
2022-02-23 06:00:00	MSFT	Stock	290.54	290.54	290.07	290.07	522.0
2022-02-23 06:30:00	MSFT	Stock	290.3	290.3	289.61	289.61	696.0
2022-02-23 07:00:00	MSFT	Stock	289.89	290.6	289.5	290.6	4685.0
2022-02-23 07:30:00	MSFT	Stock	290.85	291.03	290.72	291.0	1624.0
2022-02-23 08:00:00	MSFT	Stock	290.972	291.43	289.89	290.59	10424.0
2022-02-23 08:30:00	MSFT	Stock	290.78	290.8	287.72	290.65	105270.0
2022-02-23 09:00:00	MSFT	Stock	290.65	291.21	290.04	290.21	18183.0
2022-02-23 09:30:00	MSFT	Stock	290.18	291.7	288.73	289.15	2629432.0
2022-02-23 10:00:00	MSFT	Stock	289.19	289.97	287.87	287.99	1200202.0
2022-02-23 10:30:00	MSFT	Stock	287.95	288.5	286.75	287.17	1128665.0
2022-02-23 11:00:00	MSFT	Stock	287.14	287.58	286.0	286.62	923838.0
2022-02-23 11:30:00	MSFT	Stock	286.62	288.46	286.34	287.5577	1020172.0
2022-02-23 12:00:00	MSFT	Stock	287.57	288.37	287.05	287.94	771683.0
2022-02-23 12:30:00	MSFT	Stock	287.95	288.14	285.98	286.29	670009.0

> showing 50 of 108,185 rows — these rows as CSV

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