PREVIEW / stock_30min / 2009-09-15
file: by_date/stock_30min/2009/2009-09-15.parquet size: 1.4 MB rows: 74,854 symbols: 3,379
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 |
|---|---|---|---|---|---|---|---|
| 2009-09-15 07:00:00 | AAPL | Stock | 6.2071 | 6.2071 | 6.1879 | 6.1911 | 30800.0 |
| 2009-09-15 07:30:00 | AAPL | Stock | 6.2032 | 6.2039 | 6.2018 | 6.2018 | 16800.0 |
| 2009-09-15 08:00:00 | AAPL | Stock | 6.2043 | 6.2232 | 6.2036 | 6.2143 | 3368876.0 |
| 2009-09-15 08:30:00 | AAPL | Stock | 6.2143 | 6.2289 | 6.2143 | 6.225 | 1224160.0 |
| 2009-09-15 09:00:00 | AAPL | Stock | 6.2275 | 6.2286 | 6.2157 | 6.2171 | 900872.0 |
| 2009-09-15 09:30:00 | AAPL | Stock | 6.2157 | 6.2486 | 6.1996 | 6.2286 | 63711032.0 |
| 2009-09-15 10:00:00 | AAPL | Stock | 6.2275 | 6.2368 | 6.2107 | 6.2314 | 37695896.0 |
| 2009-09-15 10:30:00 | AAPL | Stock | 6.2318 | 6.25 | 6.2286 | 6.2457 | 31945452.0 |
| 2009-09-15 11:00:00 | AAPL | Stock | 6.2454 | 6.2575 | 6.2332 | 6.2564 | 32538520.0 |
| 2009-09-15 11:30:00 | AAPL | Stock | 6.2557 | 6.2689 | 6.2507 | 6.2671 | 26106304.0 |
| 2009-09-15 12:00:00 | AAPL | Stock | 6.2671 | 6.27 | 6.2582 | 6.2668 | 14738668.0 |
| 2009-09-15 12:30:00 | AAPL | Stock | 6.2675 | 6.2732 | 6.2639 | 6.2661 | 12808124.0 |
| 2009-09-15 13:00:00 | AAPL | Stock | 6.2661 | 6.2686 | 6.2571 | 6.2636 | 20692280.0 |
| 2009-09-15 13:30:00 | AAPL | Stock | 6.2639 | 6.2679 | 6.2593 | 6.2596 | 14713356.0 |
| 2009-09-15 14:00:00 | AAPL | Stock | 6.2596 | 6.2632 | 6.25 | 6.2603 | 16937844.0 |
| 2009-09-15 14:30:00 | AAPL | Stock | 6.2607 | 6.2614 | 6.2436 | 6.2564 | 19945100.0 |
| 2009-09-15 15:00:00 | AAPL | Stock | 6.2568 | 6.2679 | 6.2536 | 6.2654 | 21491848.0 |
| 2009-09-15 15:30:00 | AAPL | Stock | 6.265 | 6.2661 | 6.2482 | 6.2557 | 41149752.0 |
| 2009-09-15 16:00:00 | AAPL | Stock | 6.2557 | 6.2571 | 6.2469 | 6.2532 | 26498920.0 |
| 2009-09-15 16:30:00 | AAPL | Stock | 6.2536 | 6.2601 | 6.25 | 6.25 | 545132.0 |
| 2009-09-15 17:00:00 | AAPL | Stock | 6.2557 | 6.2557 | 6.2518 | 6.2518 | 337540.0 |
| 2009-09-15 17:30:00 | AAPL | Stock | 6.2543 | 6.2543 | 6.2496 | 6.2496 | 103320.0 |
| 2009-09-15 18:00:00 | AAPL | Stock | 6.2493 | 6.3429 | 6.2493 | 6.3371 | 8149960.0 |
| 2009-09-15 18:30:00 | AAPL | Stock | 6.3371 | 6.3393 | 6.3257 | 6.3304 | 1442616.0 |
| 2009-09-15 19:00:00 | AAPL | Stock | 6.3293 | 6.3432 | 6.3293 | 6.3432 | 1304072.0 |
| 2009-09-15 19:30:00 | AAPL | Stock | 6.3425 | 6.3429 | 6.3357 | 6.3393 | 559972.0 |
| 2009-09-15 08:00:00 | MSFT | Stock | 24.95 | 25.0 | 24.91 | 24.91 | 238748.0 |
| 2009-09-15 08:30:00 | MSFT | Stock | 24.95 | 25.0 | 24.95 | 25.0 | 6264.0 |
| 2009-09-15 09:00:00 | MSFT | Stock | 25.0 | 25.02 | 24.93 | 24.96 | 45996.0 |
| 2009-09-15 09:30:00 | MSFT | Stock | 24.97 | 25.15 | 24.86 | 25.05 | 4235174.0 |
| 2009-09-15 10:00:00 | MSFT | Stock | 25.06 | 25.08 | 24.97 | 25.07 | 3310588.0 |
| 2009-09-15 10:30:00 | MSFT | Stock | 25.08 | 25.15 | 25.06 | 25.095 | 3323311.0 |
| 2009-09-15 11:00:00 | MSFT | Stock | 25.09 | 25.1 | 25.02 | 25.05 | 2051443.0 |
| 2009-09-15 11:30:00 | MSFT | Stock | 25.05 | 25.15 | 25.02 | 25.12 | 3185450.0 |
| 2009-09-15 12:00:00 | MSFT | Stock | 25.11 | 25.14 | 25.07 | 25.07 | 2505860.0 |
| 2009-09-15 12:30:00 | MSFT | Stock | 25.075 | 25.1 | 25.06 | 25.1 | 1330487.0 |
| 2009-09-15 13:00:00 | MSFT | Stock | 25.09 | 25.13 | 25.06 | 25.11 | 1906182.0 |
| 2009-09-15 13:30:00 | MSFT | Stock | 25.12 | 25.13 | 25.1 | 25.11 | 1336880.0 |
| 2009-09-15 14:00:00 | MSFT | Stock | 25.112 | 25.17 | 25.07 | 25.16 | 2834732.0 |
| 2009-09-15 14:30:00 | MSFT | Stock | 25.165 | 25.19 | 25.13 | 25.19 | 3567992.0 |
| 2009-09-15 15:00:00 | MSFT | Stock | 25.19 | 25.25 | 25.152 | 25.24 | 2859879.0 |
| 2009-09-15 15:30:00 | MSFT | Stock | 25.25 | 25.27 | 25.16 | 25.2 | 6394393.0 |
| 2009-09-15 16:00:00 | MSFT | Stock | 25.2 | 25.27 | 25.02 | 25.18 | 3084198.0 |
| 2009-09-15 16:30:00 | MSFT | Stock | 25.21 | 25.21 | 25.14 | 25.21 | 123469.0 |
| 2009-09-15 17:00:00 | MSFT | Stock | 25.0 | 25.21 | 25.0 | 25.14 | 104348.0 |
| 2009-09-15 17:30:00 | MSFT | Stock | 25.13 | 25.13 | 25.13 | 25.13 | 2000.0 |
| 2009-09-15 18:00:00 | MSFT | Stock | 25.12 | 25.2 | 25.12 | 25.2 | 1325.0 |
| 2009-09-15 18:30:00 | MSFT | Stock | 25.2 | 25.2 | 25.15 | 25.15 | 1000.0 |
| 2009-09-15 19:00:00 | MSFT | Stock | 25.15 | 25.15 | 25.15 | 25.15 | 100.0 |
| 2009-09-15 19:30:00 | MSFT | Stock | 25.15 | 25.15 | 25.15 | 25.15 | 750.0 |
> showing 50 of 74,854 rows — these rows as CSV