PREVIEW / stock_30min / 2022-08-24

all stock 30-min files

  file:    by_date/stock_30min/2022/2022-08-24.parquet
  size:    2.1 MB
  rows:    103,365
  symbols: 2,267

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-08-24 04:00:00	AAPL	Stock	167.38	167.38	166.95	167.1	8372.0
2022-08-24 04:30:00	AAPL	Stock	167.2	167.5	167.16	167.28	6938.0
2022-08-24 05:00:00	AAPL	Stock	167.34	167.41	167.3	167.39	6603.0
2022-08-24 05:30:00	AAPL	Stock	167.35	167.35	167.14	167.2	9329.0
2022-08-24 06:00:00	AAPL	Stock	167.28	167.44	167.28	167.35	8380.0
2022-08-24 06:30:00	AAPL	Stock	167.44	167.5	167.25	167.47	63500.0
2022-08-24 07:00:00	AAPL	Stock	167.48	167.99	167.38	167.99	60987.0
2022-08-24 07:30:00	AAPL	Stock	167.99	168.4	167.86	168.11	58783.0
2022-08-24 08:00:00	AAPL	Stock	167.6164	168.41	166.53	168.15	173864.0
2022-08-24 08:30:00	AAPL	Stock	168.12	168.15	167.6	168.09	93634.0
2022-08-24 09:00:00	AAPL	Stock	168.05	168.0599	167.07	167.2	206963.0
2022-08-24 09:30:00	AAPL	Stock	167.41	167.59	166.42	166.73	6721061.0
2022-08-24 10:00:00	AAPL	Stock	166.74	167.2701	166.36	167.17	4871539.0
2022-08-24 10:30:00	AAPL	Stock	167.17	167.22	166.345	166.65	3087703.0
2022-08-24 11:00:00	AAPL	Stock	166.66	167.355	166.245	167.2728	3542214.0
2022-08-24 11:30:00	AAPL	Stock	167.28	167.78	167.07	167.54	2847398.0
2022-08-24 12:00:00	AAPL	Stock	167.54	167.98	167.495	167.615	2864995.0
2022-08-24 12:30:00	AAPL	Stock	167.627	167.78	167.16	167.3716	2238951.0
2022-08-24 13:00:00	AAPL	Stock	167.38	167.57	167.07	167.18	1561300.0
2022-08-24 13:30:00	AAPL	Stock	167.17	167.7	167.15	167.5701	1676189.0
2022-08-24 14:00:00	AAPL	Stock	167.58	167.72	167.41	167.5767	1518300.0
2022-08-24 14:30:00	AAPL	Stock	167.57	167.84	167.32	167.769	2054447.0
2022-08-24 15:00:00	AAPL	Stock	167.765	167.99	167.7	167.835	2199672.0
2022-08-24 15:30:00	AAPL	Stock	167.835	168.11	167.32	167.63	5001259.0
2022-08-24 16:00:00	AAPL	Stock	167.65	167.7	167.24	167.6	4962662.0
2022-08-24 16:30:00	AAPL	Stock	167.56	168.0	167.4503	167.88	69946.0
2022-08-24 17:00:00	AAPL	Stock	167.86	167.89	167.68	167.79	35724.0
2022-08-24 17:30:00	AAPL	Stock	167.82	167.83	167.75	167.82	8142.0
2022-08-24 18:00:00	AAPL	Stock	167.8	168.15	167.76	167.9	27853.0
2022-08-24 18:30:00	AAPL	Stock	167.94	168.04	167.86	167.89	6173.0
2022-08-24 19:00:00	AAPL	Stock	167.94	168.0	167.83	167.83	14755.0
2022-08-24 19:30:00	AAPL	Stock	167.85	167.93	167.7	167.84	23231.0
2022-08-24 04:00:00	MSFT	Stock	276.0	276.0	276.0	276.0	200.0
2022-08-24 04:30:00	MSFT	Stock	276.52	276.52	276.52	276.52	100.0
2022-08-24 05:00:00	MSFT	Stock	276.55	276.62	276.36	276.36	797.0
2022-08-24 05:30:00	MSFT	Stock	276.32	276.54	276.3	276.3	565.0
2022-08-24 06:30:00	MSFT	Stock	276.29	276.3	275.71	275.71	991.0
2022-08-24 07:00:00	MSFT	Stock	276.05	276.17	275.77	276.1	1888.0
2022-08-24 07:30:00	MSFT	Stock	276.3	276.9	276.3	276.5	11479.0
2022-08-24 08:00:00	MSFT	Stock	276.2912	277.18	274.42	276.65	19350.0
2022-08-24 08:30:00	MSFT	Stock	276.55	276.55	276.02	276.09	10444.0
2022-08-24 09:00:00	MSFT	Stock	276.28	276.3653	274.76	275.79	28051.0
2022-08-24 09:30:00	MSFT	Stock	275.78	276.49	275.29	275.91	1603214.0
2022-08-24 10:00:00	MSFT	Stock	275.94	276.5	275.27	275.96	920493.0
2022-08-24 10:30:00	MSFT	Stock	275.99	276.185	275.11	275.57	688896.0
2022-08-24 11:00:00	MSFT	Stock	275.5945	276.9	275.26	276.73	811206.0
2022-08-24 11:30:00	MSFT	Stock	276.76	277.205	276.32	276.97	576175.0
2022-08-24 12:00:00	MSFT	Stock	277.0	277.23	276.15	276.19	502487.0
2022-08-24 12:30:00	MSFT	Stock	276.1933	276.2839	275.45	275.98	545951.0
2022-08-24 13:00:00	MSFT	Stock	275.97	276.29	275.5	275.54	349959.0

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

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