PREVIEW / stock_30min / 2022-08-02

all stock 30-min files

  file:    by_date/stock_30min/2022/2022-08-02.parquet
  size:    2.1 MB
  rows:    106,498
  symbols: 2,271

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-02 04:00:00	AAPL	Stock	161.28	161.28	160.04	160.26	30899.0
2022-08-02 04:30:00	AAPL	Stock	160.26	160.3	160.07	160.1	15218.0
2022-08-02 05:00:00	AAPL	Stock	160.14	160.23	160.1	160.11	6133.0
2022-08-02 05:30:00	AAPL	Stock	160.13	160.14	159.8	159.8	14465.0
2022-08-02 06:00:00	AAPL	Stock	159.8	159.96	159.61	159.67	15447.0
2022-08-02 06:30:00	AAPL	Stock	159.62	159.8	159.55	159.8	20559.0
2022-08-02 07:00:00	AAPL	Stock	159.85	160.36	159.74	160.22	54375.0
2022-08-02 07:30:00	AAPL	Stock	160.22	160.35	160.01	160.2	15518.0
2022-08-02 08:00:00	AAPL	Stock	160.05	161.107	159.9	160.12	163562.0
2022-08-02 08:30:00	AAPL	Stock	160.1	160.24	159.84	160.15	118594.0
2022-08-02 09:00:00	AAPL	Stock	160.16	160.47	160.01	160.11	187167.0
2022-08-02 09:30:00	AAPL	Stock	160.15	161.08	159.75	160.545	6304967.0
2022-08-02 10:00:00	AAPL	Stock	160.5508	160.58	159.63	160.58	4402954.0
2022-08-02 10:30:00	AAPL	Stock	160.58	161.725	160.32	161.25	4009855.0
2022-08-02 11:00:00	AAPL	Stock	161.25	161.38	160.79	161.09	2127201.0
2022-08-02 11:30:00	AAPL	Stock	161.0947	161.48	160.55	161.16	1904351.0
2022-08-02 12:00:00	AAPL	Stock	161.17	162.41	161.1	162.33	2638994.0
2022-08-02 12:30:00	AAPL	Stock	162.33	162.3988	162.08	162.205	1673057.0
2022-08-02 13:00:00	AAPL	Stock	162.205	162.28	161.08	161.15	2152789.0
2022-08-02 13:30:00	AAPL	Stock	161.15	161.15	160.075	160.4	3788156.0
2022-08-02 14:00:00	AAPL	Stock	160.4	161.07	160.245	160.9401	2952119.0
2022-08-02 14:30:00	AAPL	Stock	160.955	161.3	160.49	160.645	2531390.0
2022-08-02 15:00:00	AAPL	Stock	160.64	160.87	160.17	160.5272	2825659.0
2022-08-02 15:30:00	AAPL	Stock	160.52	160.8	159.93	159.99	5408720.0
2022-08-02 16:00:00	AAPL	Stock	159.99	160.16	159.8	159.9	4284634.0
2022-08-02 16:30:00	AAPL	Stock	159.95	160.15	159.95	160.08	756206.0
2022-08-02 17:00:00	AAPL	Stock	160.14	160.35	160.14	160.33	40053.0
2022-08-02 17:30:00	AAPL	Stock	160.27	160.29	160.1	160.17	7107.0
2022-08-02 18:00:00	AAPL	Stock	160.17	160.22	160.01	160.04	10870.0
2022-08-02 18:30:00	AAPL	Stock	160.0	160.17	159.93	159.93	20257.0
2022-08-02 19:00:00	AAPL	Stock	159.93	160.24	159.9	160.15	13362.0
2022-08-02 19:30:00	AAPL	Stock	160.13	160.15	159.92	160.0	18826.0
2022-08-02 04:00:00	MSFT	Stock	276.19	276.19	275.8	275.8	551.0
2022-08-02 04:30:00	MSFT	Stock	276.06	276.06	275.76	275.76	1553.0
2022-08-02 05:00:00	MSFT	Stock	276.08	276.08	276.08	276.08	326.0
2022-08-02 05:30:00	MSFT	Stock	276.0	276.0	275.0	275.2	2505.0
2022-08-02 06:00:00	MSFT	Stock	275.2	275.27	274.9	275.21	4552.0
2022-08-02 06:30:00	MSFT	Stock	275.18	275.61	275.18	275.61	1438.0
2022-08-02 07:00:00	MSFT	Stock	275.99	276.87	275.8	276.39	10037.0
2022-08-02 07:30:00	MSFT	Stock	276.44	276.45	276.0	276.0	1311.0
2022-08-02 08:00:00	MSFT	Stock	275.7	277.315	275.59	275.8	17689.0
2022-08-02 08:30:00	MSFT	Stock	276.0	276.0976	275.5	275.98	10213.0
2022-08-02 09:00:00	MSFT	Stock	276.07	276.7685	275.63	275.99	12758.0
2022-08-02 09:30:00	MSFT	Stock	275.99	276.355	272.96	273.855	2335731.0
2022-08-02 10:00:00	MSFT	Stock	273.855	274.1	272.38	273.47	1399769.0
2022-08-02 10:30:00	MSFT	Stock	273.5	275.76	273.26	274.95	1253550.0
2022-08-02 11:00:00	MSFT	Stock	274.93	275.25	274.3111	274.94	612535.0
2022-08-02 11:30:00	MSFT	Stock	274.96	275.57	274.17	274.84	735855.0
2022-08-02 12:00:00	MSFT	Stock	274.84	277.24	274.8096	277.09	736177.0
2022-08-02 12:30:00	MSFT	Stock	277.1	277.89	276.9462	277.26	653459.0

> showing 50 of 106,498 rows — these rows as CSV

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