PREVIEW / stock_30min / 2005-10-11
file: by_date/stock_30min/2005/2005-10-11.parquet size: 851 KB rows: 45,924 symbols: 2,089
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 |
|---|---|---|---|---|---|---|---|
| 2005-10-11 07:30:00 | AAPL | Stock | 1.8093 | 1.8179 | 1.8093 | 1.8179 | 16800.0 |
| 2005-10-11 08:00:00 | AAPL | Stock | 1.8214 | 1.8246 | 1.8111 | 1.8211 | 2132032.0 |
| 2005-10-11 08:30:00 | AAPL | Stock | 1.8214 | 1.825 | 1.8207 | 1.8243 | 1377376.0 |
| 2005-10-11 09:00:00 | AAPL | Stock | 1.825 | 1.8346 | 1.8221 | 1.8293 | 5324256.0 |
| 2005-10-11 09:30:00 | AAPL | Stock | 1.8296 | 1.8321 | 1.8 | 1.8096 | 121071468.0 |
| 2005-10-11 10:00:00 | AAPL | Stock | 1.8082 | 1.8286 | 1.8018 | 1.8279 | 75363820.0 |
| 2005-10-11 10:30:00 | AAPL | Stock | 1.8271 | 1.8436 | 1.8225 | 1.8404 | 91720076.0 |
| 2005-10-11 11:00:00 | AAPL | Stock | 1.8404 | 1.8482 | 1.8343 | 1.8461 | 58955204.0 |
| 2005-10-11 11:30:00 | AAPL | Stock | 1.8454 | 1.8525 | 1.8393 | 1.8411 | 63330736.0 |
| 2005-10-11 12:00:00 | AAPL | Stock | 1.8407 | 1.8418 | 1.825 | 1.8275 | 64582644.0 |
| 2005-10-11 12:30:00 | AAPL | Stock | 1.8275 | 1.8332 | 1.8236 | 1.8243 | 42970480.0 |
| 2005-10-11 13:00:00 | AAPL | Stock | 1.8242 | 1.8296 | 1.8125 | 1.8207 | 53147528.0 |
| 2005-10-11 13:30:00 | AAPL | Stock | 1.8207 | 1.8304 | 1.8207 | 1.8275 | 47876220.0 |
| 2005-10-11 14:00:00 | AAPL | Stock | 1.8271 | 1.8407 | 1.8214 | 1.8346 | 66694348.0 |
| 2005-10-11 14:30:00 | AAPL | Stock | 1.8346 | 1.8386 | 1.8254 | 1.8289 | 53914140.0 |
| 2005-10-11 15:00:00 | AAPL | Stock | 1.8286 | 1.8321 | 1.8207 | 1.8221 | 58598624.0 |
| 2005-10-11 15:30:00 | AAPL | Stock | 1.8218 | 1.8436 | 1.8211 | 1.8429 | 97032908.0 |
| 2005-10-11 16:00:00 | AAPL | Stock | 1.8418 | 1.8529 | 1.7143 | 1.7207 | 19920292.0 |
| 2005-10-11 16:30:00 | AAPL | Stock | 1.7207 | 1.7321 | 1.6357 | 1.6411 | 216267044.0 |
| 2005-10-11 17:00:00 | AAPL | Stock | 1.6393 | 1.6536 | 1.625 | 1.6411 | 60020548.0 |
| 2005-10-11 17:30:00 | AAPL | Stock | 1.6411 | 1.6536 | 1.6339 | 1.6511 | 27626088.0 |
| 2005-10-11 18:00:00 | AAPL | Stock | 1.6511 | 1.6536 | 1.645 | 1.6493 | 18194708.0 |
| 2005-10-11 07:00:00 | MSFT | Stock | 24.59 | 24.59 | 24.59 | 24.59 | 1000.0 |
| 2005-10-11 07:30:00 | MSFT | Stock | 24.59 | 24.59 | 24.59 | 24.59 | 1000.0 |
| 2005-10-11 08:00:00 | MSFT | Stock | 24.59 | 24.59 | 24.48 | 24.55 | 12554.0 |
| 2005-10-11 08:30:00 | MSFT | Stock | 24.55 | 24.55 | 24.51 | 24.54 | 9300.0 |
| 2005-10-11 09:00:00 | MSFT | Stock | 24.53 | 24.55 | 24.5 | 24.51 | 68645.0 |
| 2005-10-11 09:30:00 | MSFT | Stock | 24.51 | 24.55 | 24.369 | 24.44 | 8456739.0 |
| 2005-10-11 10:00:00 | MSFT | Stock | 24.44 | 24.47 | 24.38 | 24.4 | 4308753.0 |
| 2005-10-11 10:30:00 | MSFT | Stock | 24.4 | 24.42 | 24.28 | 24.35 | 4346587.0 |
| 2005-10-11 11:00:00 | MSFT | Stock | 24.36 | 24.37 | 24.29 | 24.31 | 5747831.0 |
| 2005-10-11 11:30:00 | MSFT | Stock | 24.31 | 24.36 | 24.29 | 24.32 | 4234401.0 |
| 2005-10-11 12:00:00 | MSFT | Stock | 24.33 | 24.35 | 24.25 | 24.28 | 5321983.0 |
| 2005-10-11 12:30:00 | MSFT | Stock | 24.281 | 24.37 | 24.28 | 24.321 | 3963350.0 |
| 2005-10-11 13:00:00 | MSFT | Stock | 24.33 | 24.35 | 24.27 | 24.31 | 3750212.0 |
| 2005-10-11 13:30:00 | MSFT | Stock | 24.31 | 24.32 | 24.25 | 24.29 | 3843078.0 |
| 2005-10-11 14:00:00 | MSFT | Stock | 24.29 | 24.5 | 24.25 | 24.36 | 7157600.0 |
| 2005-10-11 14:30:00 | MSFT | Stock | 24.36 | 24.4 | 24.34 | 24.37 | 6896430.0 |
| 2005-10-11 15:00:00 | MSFT | Stock | 24.35 | 24.43 | 24.35 | 24.39 | 7100601.0 |
| 2005-10-11 15:30:00 | MSFT | Stock | 24.4 | 24.41 | 24.34 | 24.41 | 7820716.0 |
| 2005-10-11 16:00:00 | MSFT | Stock | 24.41 | 24.42 | 24.309 | 24.38 | 155221.0 |
| 2005-10-11 16:30:00 | MSFT | Stock | 24.38 | 24.38 | 24.33 | 24.37 | 18785.0 |
| 2005-10-11 17:00:00 | MSFT | Stock | 24.34 | 24.359 | 24.31 | 24.32 | 444935.0 |
| 2005-10-11 17:30:00 | MSFT | Stock | 24.34 | 24.41 | 24.31 | 24.31 | 15745.0 |
| 2005-10-11 18:00:00 | MSFT | Stock | 24.474 | 24.474 | 24.31 | 24.31 | 20305.0 |
| 2005-10-11 09:00:00 | NVDA | Stock | 0.2708 | 0.2708 | 0.2692 | 0.2692 | 414000.0 |
| 2005-10-11 09:30:00 | NVDA | Stock | 0.2695 | 0.2718 | 0.266 | 0.2662 | 65533200.0 |
| 2005-10-11 10:00:00 | NVDA | Stock | 0.2662 | 0.2667 | 0.2636 | 0.266 | 68692800.0 |
| 2005-10-11 10:30:00 | NVDA | Stock | 0.2661 | 0.2671 | 0.2652 | 0.2656 | 41049840.0 |
| 2005-10-11 11:00:00 | NVDA | Stock | 0.2656 | 0.2662 | 0.2646 | 0.2651 | 21735600.0 |
> showing 50 of 45,924 rows — these rows as CSV