PREVIEW / stock_30min / 2022-10-12
file: by_date/stock_30min/2022/2022-10-12.parquet size: 2.0 MB rows: 99,623 symbols: 2,155
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-10-12 04:00:00 | AAPL | Stock | 140.22 | 140.24 | 139.9 | 140.13 | 29887.0 |
| 2022-10-12 04:30:00 | AAPL | Stock | 140.1 | 140.13 | 139.75 | 139.95 | 8706.0 |
| 2022-10-12 05:00:00 | AAPL | Stock | 139.83 | 140.55 | 139.81 | 140.55 | 13200.0 |
| 2022-10-12 05:30:00 | AAPL | Stock | 140.59 | 140.59 | 140.11 | 140.23 | 9614.0 |
| 2022-10-12 06:00:00 | AAPL | Stock | 140.24 | 140.4 | 140.06 | 140.13 | 6372.0 |
| 2022-10-12 06:30:00 | AAPL | Stock | 140.15 | 140.18 | 140.0 | 140.12 | 12588.0 |
| 2022-10-12 07:00:00 | AAPL | Stock | 140.09 | 140.38 | 139.95 | 140.36 | 37527.0 |
| 2022-10-12 07:30:00 | AAPL | Stock | 140.35 | 140.44 | 140.21 | 140.32 | 27556.0 |
| 2022-10-12 08:00:00 | AAPL | Stock | 140.15 | 140.45 | 140.03 | 140.15 | 89794.0 |
| 2022-10-12 08:30:00 | AAPL | Stock | 140.15 | 140.1999 | 139.14 | 139.55 | 271522.0 |
| 2022-10-12 09:00:00 | AAPL | Stock | 139.5 | 139.52 | 139.01 | 139.13 | 207568.0 |
| 2022-10-12 09:30:00 | AAPL | Stock | 139.12 | 140.36 | 138.6507 | 139.8937 | 8459116.0 |
| 2022-10-12 10:00:00 | AAPL | Stock | 139.9 | 140.2 | 138.855 | 139.675 | 5408157.0 |
| 2022-10-12 10:30:00 | AAPL | Stock | 139.67 | 139.96 | 138.831 | 139.43 | 4079588.0 |
| 2022-10-12 11:00:00 | AAPL | Stock | 139.44 | 139.87 | 139.05 | 139.68 | 4080547.0 |
| 2022-10-12 11:30:00 | AAPL | Stock | 139.7 | 140.14 | 139.4717 | 139.99 | 3250857.0 |
| 2022-10-12 12:00:00 | AAPL | Stock | 140.0 | 140.09 | 139.11 | 139.16 | 2881753.0 |
| 2022-10-12 12:30:00 | AAPL | Stock | 139.1518 | 139.5535 | 138.94 | 139.4633 | 2350626.0 |
| 2022-10-12 13:00:00 | AAPL | Stock | 139.4699 | 139.6 | 138.98 | 139.105 | 2274352.0 |
| 2022-10-12 13:30:00 | AAPL | Stock | 139.105 | 139.1461 | 138.37 | 138.5301 | 3013692.0 |
| 2022-10-12 14:00:00 | AAPL | Stock | 138.525 | 139.33 | 138.25 | 139.22 | 5836559.0 |
| 2022-10-12 14:30:00 | AAPL | Stock | 139.22 | 139.36 | 138.3978 | 138.51 | 2840604.0 |
| 2022-10-12 15:00:00 | AAPL | Stock | 138.5 | 138.67 | 138.16 | 138.491 | 3685550.0 |
| 2022-10-12 15:30:00 | AAPL | Stock | 138.5 | 138.8 | 138.25 | 138.295 | 5999817.0 |
| 2022-10-12 16:00:00 | AAPL | Stock | 138.29 | 138.55 | 138.29 | 138.45 | 6139011.0 |
| 2022-10-12 16:30:00 | AAPL | Stock | 138.44 | 138.52 | 138.34 | 138.47 | 24854.0 |
| 2022-10-12 17:00:00 | AAPL | Stock | 138.46 | 138.48 | 138.34 | 138.47 | 21669.0 |
| 2022-10-12 17:30:00 | AAPL | Stock | 138.45 | 138.48 | 138.45 | 138.4504 | 5128.0 |
| 2022-10-12 18:00:00 | AAPL | Stock | 138.48 | 138.55 | 138.46 | 138.53 | 22930.0 |
| 2022-10-12 18:30:00 | AAPL | Stock | 138.55 | 138.56 | 138.5 | 138.54 | 5032.0 |
| 2022-10-12 19:00:00 | AAPL | Stock | 138.52 | 138.65 | 138.48 | 138.61 | 11040.0 |
| 2022-10-12 19:30:00 | AAPL | Stock | 138.56 | 138.77 | 138.54 | 138.61 | 23424.0 |
| 2022-10-12 04:00:00 | MSFT | Stock | 226.4 | 227.0 | 226.4 | 227.0 | 1218.0 |
| 2022-10-12 04:30:00 | MSFT | Stock | 226.94 | 226.94 | 226.6 | 226.6 | 723.0 |
| 2022-10-12 05:00:00 | MSFT | Stock | 226.6 | 227.77 | 226.6 | 227.77 | 4376.0 |
| 2022-10-12 05:30:00 | MSFT | Stock | 227.49 | 227.76 | 227.36 | 227.36 | 1050.0 |
| 2022-10-12 06:00:00 | MSFT | Stock | 227.49 | 227.69 | 227.15 | 227.15 | 2378.0 |
| 2022-10-12 06:30:00 | MSFT | Stock | 226.52 | 226.98 | 226.52 | 226.98 | 694.0 |
| 2022-10-12 07:00:00 | MSFT | Stock | 226.72 | 227.35 | 226.71 | 227.29 | 13712.0 |
| 2022-10-12 07:30:00 | MSFT | Stock | 227.25 | 227.33 | 226.96 | 227.01 | 4186.0 |
| 2022-10-12 08:00:00 | MSFT | Stock | 227.3 | 227.47 | 224.847 | 227.12 | 21872.0 |
| 2022-10-12 08:30:00 | MSFT | Stock | 227.0 | 227.0 | 224.64 | 225.717 | 75564.0 |
| 2022-10-12 09:00:00 | MSFT | Stock | 225.6 | 225.6 | 224.25 | 225.35 | 27536.0 |
| 2022-10-12 09:30:00 | MSFT | Stock | 225.24 | 226.87 | 224.28 | 226.35 | 1916075.0 |
| 2022-10-12 10:00:00 | MSFT | Stock | 226.43 | 226.6 | 224.44 | 225.48 | 1228914.0 |
| 2022-10-12 10:30:00 | MSFT | Stock | 225.47 | 225.84 | 223.96 | 224.35 | 859849.0 |
| 2022-10-12 11:00:00 | MSFT | Stock | 224.34 | 225.44 | 224.3 | 225.36 | 870230.0 |
| 2022-10-12 11:30:00 | MSFT | Stock | 225.38 | 226.18 | 224.98 | 225.85 | 881743.0 |
| 2022-10-12 12:00:00 | MSFT | Stock | 225.87 | 226.41 | 224.86 | 224.975 | 807113.0 |
| 2022-10-12 12:30:00 | MSFT | Stock | 224.97 | 225.57 | 224.56 | 225.5248 | 589866.0 |
> showing 50 of 99,623 rows — these rows as CSV