PREVIEW / stock_30min / 2021-12-27
file: by_date/stock_30min/2021/2021-12-27.parquet size: 2.2 MB rows: 110,229 symbols: 2,630
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 |
|---|---|---|---|---|---|---|---|
| 2021-12-27 04:00:00 | AAPL | Stock | 176.4 | 176.41 | 175.9 | 175.9 | 17145.0 |
| 2021-12-27 04:30:00 | AAPL | Stock | 175.94 | 176.25 | 175.88 | 176.0 | 9836.0 |
| 2021-12-27 05:00:00 | AAPL | Stock | 176.0 | 176.4 | 176.0 | 176.4 | 11383.0 |
| 2021-12-27 05:30:00 | AAPL | Stock | 176.37 | 176.64 | 176.29 | 176.4 | 4710.0 |
| 2021-12-27 06:00:00 | AAPL | Stock | 176.46 | 176.46 | 176.4 | 176.4 | 418.0 |
| 2021-12-27 06:30:00 | AAPL | Stock | 176.41 | 176.44 | 176.38 | 176.44 | 2446.0 |
| 2021-12-27 07:00:00 | AAPL | Stock | 176.43 | 176.75 | 176.39 | 176.75 | 27834.0 |
| 2021-12-27 07:30:00 | AAPL | Stock | 176.8 | 177.07 | 176.8 | 176.95 | 36598.0 |
| 2021-12-27 08:00:00 | AAPL | Stock | 176.47 | 177.08 | 176.365 | 177.06 | 231868.0 |
| 2021-12-27 08:30:00 | AAPL | Stock | 177.07 | 177.31 | 177.0601 | 177.07 | 134758.0 |
| 2021-12-27 09:00:00 | AAPL | Stock | 177.09 | 177.16 | 176.9 | 177.1 | 104077.0 |
| 2021-12-27 09:30:00 | AAPL | Stock | 177.09 | 178.47 | 177.07 | 177.2889 | 9197915.0 |
| 2021-12-27 10:00:00 | AAPL | Stock | 177.3 | 177.92 | 177.13 | 177.615 | 5304165.0 |
| 2021-12-27 10:30:00 | AAPL | Stock | 177.62 | 178.47 | 177.492 | 178.4599 | 4408335.0 |
| 2021-12-27 11:00:00 | AAPL | Stock | 178.455 | 178.87 | 178.17 | 178.725 | 4164293.0 |
| 2021-12-27 11:30:00 | AAPL | Stock | 178.73 | 178.87 | 178.43 | 178.836 | 2826144.0 |
| 2021-12-27 12:00:00 | AAPL | Stock | 178.84 | 179.33 | 178.78 | 179.3222 | 3932248.0 |
| 2021-12-27 12:30:00 | AAPL | Stock | 179.3201 | 179.3699 | 178.93 | 179.25 | 3197625.0 |
| 2021-12-27 13:00:00 | AAPL | Stock | 179.25 | 179.665 | 179.07 | 179.6001 | 2974982.0 |
| 2021-12-27 13:30:00 | AAPL | Stock | 179.6058 | 179.97 | 179.59 | 179.895 | 3554211.0 |
| 2021-12-27 14:00:00 | AAPL | Stock | 179.89 | 180.23 | 179.8 | 180.125 | 3922687.0 |
| 2021-12-27 14:30:00 | AAPL | Stock | 180.1249 | 180.135 | 179.535 | 179.91 | 3536623.0 |
| 2021-12-27 15:00:00 | AAPL | Stock | 179.91 | 180.0 | 179.56 | 179.91 | 3525212.0 |
| 2021-12-27 15:30:00 | AAPL | Stock | 179.91 | 180.42 | 179.78 | 180.33 | 7244028.0 |
| 2021-12-27 16:00:00 | AAPL | Stock | 180.33 | 180.55 | 180.14 | 180.26 | 6508797.0 |
| 2021-12-27 16:30:00 | AAPL | Stock | 180.25 | 180.42 | 180.19 | 180.2594 | 76112.0 |
| 2021-12-27 17:00:00 | AAPL | Stock | 180.25 | 180.34 | 180.25 | 180.32 | 27295.0 |
| 2021-12-27 17:30:00 | AAPL | Stock | 180.33 | 180.5 | 180.3 | 180.3 | 33730.0 |
| 2021-12-27 18:00:00 | AAPL | Stock | 180.3 | 180.34 | 180.19 | 180.2 | 26833.0 |
| 2021-12-27 18:30:00 | AAPL | Stock | 180.19 | 180.22 | 180.1 | 180.11 | 19231.0 |
| 2021-12-27 19:00:00 | AAPL | Stock | 180.1 | 180.11 | 179.89 | 180.02 | 24354.0 |
| 2021-12-27 19:30:00 | AAPL | Stock | 180.02 | 180.02 | 179.8 | 179.8 | 44111.0 |
| 2021-12-27 04:00:00 | MSFT | Stock | 335.55 | 335.63 | 335.13 | 335.13 | 1069.0 |
| 2021-12-27 04:30:00 | MSFT | Stock | 335.19 | 335.2 | 335.19 | 335.2 | 881.0 |
| 2021-12-27 05:00:00 | MSFT | Stock | 336.21 | 336.34 | 336.15 | 336.15 | 300.0 |
| 2021-12-27 05:30:00 | MSFT | Stock | 336.15 | 336.34 | 336.15 | 336.33 | 1131.0 |
| 2021-12-27 06:00:00 | MSFT | Stock | 336.13 | 336.13 | 335.9 | 335.97 | 565.0 |
| 2021-12-27 06:30:00 | MSFT | Stock | 335.9 | 335.9 | 335.43 | 335.5 | 771.0 |
| 2021-12-27 07:00:00 | MSFT | Stock | 335.51 | 336.0 | 335.41 | 336.0 | 3957.0 |
| 2021-12-27 07:30:00 | MSFT | Stock | 336.0 | 336.44 | 336.0 | 336.3 | 1328.0 |
| 2021-12-27 08:00:00 | MSFT | Stock | 335.65 | 336.5 | 335.41 | 336.49 | 10807.0 |
| 2021-12-27 08:30:00 | MSFT | Stock | 336.5 | 336.88 | 336.5 | 336.61 | 5090.0 |
| 2021-12-27 09:00:00 | MSFT | Stock | 336.7 | 336.75 | 335.6 | 335.6 | 17083.0 |
| 2021-12-27 09:30:00 | MSFT | Stock | 335.58 | 339.305 | 335.43 | 339.19 | 1988613.0 |
| 2021-12-27 10:00:00 | MSFT | Stock | 339.21 | 340.255 | 339.21 | 340.22 | 1137859.0 |
| 2021-12-27 10:30:00 | MSFT | Stock | 340.22 | 340.69 | 339.87 | 340.3 | 842485.0 |
| 2021-12-27 11:00:00 | MSFT | Stock | 340.34 | 340.69 | 339.68 | 340.115 | 688276.0 |
| 2021-12-27 11:30:00 | MSFT | Stock | 340.13 | 340.285 | 339.63 | 339.9 | 571327.0 |
| 2021-12-27 12:00:00 | MSFT | Stock | 339.9 | 340.72 | 339.87 | 340.61 | 633006.0 |
| 2021-12-27 12:30:00 | MSFT | Stock | 340.6 | 340.98 | 340.4501 | 340.62 | 779675.0 |
> showing 50 of 110,229 rows — these rows as CSV