PREVIEW / stock_30min / 2007-02-15
file: by_date/stock_30min/2007/2007-02-15.parquet size: 1005 KB rows: 54,386 symbols: 2,518
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 |
|---|---|---|---|---|---|---|---|
| 2007-02-15 07:00:00 | AAPL | Stock | 3.0368 | 3.0368 | 3.0368 | 3.0368 | 30800.0 |
| 2007-02-15 07:30:00 | AAPL | Stock | 3.0414 | 3.0414 | 3.0414 | 3.0414 | 5600.0 |
| 2007-02-15 08:00:00 | AAPL | Stock | 3.0461 | 3.0475 | 3.0371 | 3.0446 | 389900.0 |
| 2007-02-15 08:30:00 | AAPL | Stock | 3.0432 | 3.0446 | 3.0368 | 3.0418 | 749140.0 |
| 2007-02-15 09:00:00 | AAPL | Stock | 3.0414 | 3.05 | 3.0414 | 3.05 | 390152.0 |
| 2007-02-15 09:30:00 | AAPL | Stock | 3.0514 | 3.0579 | 3.0279 | 3.0425 | 56770644.0 |
| 2007-02-15 10:00:00 | AAPL | Stock | 3.0429 | 3.0514 | 3.0357 | 3.0421 | 46401964.0 |
| 2007-02-15 10:30:00 | AAPL | Stock | 3.0425 | 3.0457 | 3.0318 | 3.0335 | 34437760.0 |
| 2007-02-15 11:00:00 | AAPL | Stock | 3.0336 | 3.0407 | 3.0311 | 3.04 | 24833172.0 |
| 2007-02-15 11:30:00 | AAPL | Stock | 3.04 | 3.0454 | 3.0364 | 3.0436 | 23742544.0 |
| 2007-02-15 12:00:00 | AAPL | Stock | 3.0439 | 3.0457 | 3.0361 | 3.0371 | 21800576.0 |
| 2007-02-15 12:30:00 | AAPL | Stock | 3.0371 | 3.04 | 3.0339 | 3.0393 | 13725712.0 |
| 2007-02-15 13:00:00 | AAPL | Stock | 3.0393 | 3.0432 | 3.0371 | 3.0429 | 11507076.0 |
| 2007-02-15 13:30:00 | AAPL | Stock | 3.0432 | 3.0443 | 3.0396 | 3.0414 | 17382456.0 |
| 2007-02-15 14:00:00 | AAPL | Stock | 3.0418 | 3.0461 | 3.0361 | 3.0425 | 20326768.0 |
| 2007-02-15 14:30:00 | AAPL | Stock | 3.0425 | 3.0461 | 3.0375 | 3.0446 | 18556076.0 |
| 2007-02-15 15:00:00 | AAPL | Stock | 3.045 | 3.0457 | 3.0414 | 3.0432 | 20484324.0 |
| 2007-02-15 15:30:00 | AAPL | Stock | 3.0432 | 3.0457 | 3.0396 | 3.0443 | 40524120.0 |
| 2007-02-15 16:00:00 | AAPL | Stock | 3.0425 | 3.0464 | 3.0407 | 3.0425 | 1148644.0 |
| 2007-02-15 16:30:00 | AAPL | Stock | 3.0421 | 3.0429 | 3.0407 | 3.0407 | 56420.0 |
| 2007-02-15 17:00:00 | AAPL | Stock | 3.0421 | 3.0432 | 3.04 | 3.0411 | 110096.0 |
| 2007-02-15 17:30:00 | AAPL | Stock | 3.0429 | 3.0429 | 3.0429 | 3.0429 | 27720.0 |
| 2007-02-15 18:30:00 | AAPL | Stock | 3.0432 | 3.0432 | 3.0411 | 3.0411 | 87948.0 |
| 2007-02-15 19:00:00 | AAPL | Stock | 3.0407 | 3.0407 | 3.0407 | 3.0407 | 5600.0 |
| 2007-02-15 19:30:00 | AAPL | Stock | 3.0407 | 3.0432 | 3.0379 | 3.0379 | 160384.0 |
| 2007-02-15 08:00:00 | MSFT | Stock | 29.41 | 29.47 | 29.41 | 29.47 | 124055.0 |
| 2007-02-15 08:30:00 | MSFT | Stock | 29.45 | 29.46 | 29.45 | 29.45 | 7700.0 |
| 2007-02-15 09:00:00 | MSFT | Stock | 29.45 | 29.58 | 29.4 | 29.58 | 65985.0 |
| 2007-02-15 09:30:00 | MSFT | Stock | 29.58 | 29.64 | 29.4 | 29.46 | 5680828.0 |
| 2007-02-15 10:00:00 | MSFT | Stock | 29.44 | 29.61 | 29.44 | 29.45 | 3793362.0 |
| 2007-02-15 10:30:00 | MSFT | Stock | 29.45 | 29.57 | 29.36 | 29.38 | 4165703.0 |
| 2007-02-15 11:00:00 | MSFT | Stock | 29.39 | 29.64 | 29.39 | 29.63 | 2986199.0 |
| 2007-02-15 11:30:00 | MSFT | Stock | 29.64 | 29.64 | 29.514 | 29.625 | 3577165.0 |
| 2007-02-15 12:00:00 | MSFT | Stock | 29.62 | 29.65 | 29.22 | 29.48 | 10721153.0 |
| 2007-02-15 12:30:00 | MSFT | Stock | 29.49 | 29.5 | 29.44 | 29.47 | 1369199.0 |
| 2007-02-15 13:00:00 | MSFT | Stock | 29.47 | 29.55 | 29.46 | 29.518 | 1410181.0 |
| 2007-02-15 13:30:00 | MSFT | Stock | 29.51 | 29.55 | 29.49 | 29.492 | 2467711.0 |
| 2007-02-15 14:00:00 | MSFT | Stock | 29.5 | 29.5 | 29.36 | 29.379 | 5092713.0 |
| 2007-02-15 14:30:00 | MSFT | Stock | 29.37 | 29.431 | 29.35 | 29.37 | 2213704.0 |
| 2007-02-15 15:00:00 | MSFT | Stock | 29.369 | 29.43 | 29.36 | 29.42 | 2183612.0 |
| 2007-02-15 15:30:00 | MSFT | Stock | 29.43 | 29.54 | 29.42 | 29.54 | 4696666.0 |
| 2007-02-15 16:00:00 | MSFT | Stock | 29.53 | 29.8 | 29.25 | 29.34 | 1607616.0 |
| 2007-02-15 16:30:00 | MSFT | Stock | 29.27 | 29.36 | 29.19 | 29.23 | 7375320.0 |
| 2007-02-15 17:00:00 | MSFT | Stock | 29.23 | 29.25 | 29.12 | 29.14 | 2574651.0 |
| 2007-02-15 17:30:00 | MSFT | Stock | 29.15 | 29.16 | 29.11 | 29.14 | 301900.0 |
| 2007-02-15 18:00:00 | MSFT | Stock | 29.13 | 29.15 | 29.12 | 29.15 | 7143.0 |
| 2007-02-15 18:30:00 | MSFT | Stock | 29.53 | 29.53 | 29.08 | 29.1 | 27180.0 |
| 2007-02-15 19:00:00 | MSFT | Stock | 29.1 | 29.1 | 28.98 | 28.98 | 33550.0 |
| 2007-02-15 19:30:00 | MSFT | Stock | 28.96 | 28.98 | 28.84 | 28.95 | 27848.0 |
| 2007-02-15 09:00:00 | NVDA | Stock | 0.5582 | 0.5607 | 0.5582 | 0.5607 | 438000.0 |
> showing 50 of 54,386 rows — these rows as CSV