PREVIEW / stock_30min / 2006-07-28
file: by_date/stock_30min/2006/2006-07-28.parquet size: 909 KB rows: 49,424 symbols: 2,303
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 |
|---|---|---|---|---|---|---|---|
| 2006-07-28 08:00:00 | AAPL | Stock | 2.2661 | 2.2679 | 2.2643 | 2.2643 | 65576.0 |
| 2006-07-28 08:30:00 | AAPL | Stock | 2.2693 | 2.2875 | 2.2643 | 2.2839 | 1281504.0 |
| 2006-07-28 09:00:00 | AAPL | Stock | 2.2857 | 2.2857 | 2.2732 | 2.2818 | 1155840.0 |
| 2006-07-28 09:30:00 | AAPL | Stock | 2.2836 | 2.2879 | 2.2679 | 2.2871 | 66751384.0 |
| 2006-07-28 10:00:00 | AAPL | Stock | 2.2871 | 2.2961 | 2.2796 | 2.2839 | 71068620.0 |
| 2006-07-28 10:30:00 | AAPL | Stock | 2.2843 | 2.2936 | 2.2818 | 2.2925 | 34146504.0 |
| 2006-07-28 11:00:00 | AAPL | Stock | 2.2921 | 2.3121 | 2.2921 | 2.3036 | 62777176.0 |
| 2006-07-28 11:30:00 | AAPL | Stock | 2.3036 | 2.3114 | 2.2893 | 2.3054 | 35137928.0 |
| 2006-07-28 12:00:00 | AAPL | Stock | 2.3043 | 2.3218 | 2.2946 | 2.3211 | 55424208.0 |
| 2006-07-28 12:30:00 | AAPL | Stock | 2.3214 | 2.3279 | 2.3161 | 2.3268 | 44529688.0 |
| 2006-07-28 13:00:00 | AAPL | Stock | 2.3268 | 2.33 | 2.3168 | 2.3204 | 36156288.0 |
| 2006-07-28 13:30:00 | AAPL | Stock | 2.32 | 2.3214 | 2.3082 | 2.3175 | 35530712.0 |
| 2006-07-28 14:00:00 | AAPL | Stock | 2.3175 | 2.3311 | 2.3171 | 2.3271 | 41514928.0 |
| 2006-07-28 14:30:00 | AAPL | Stock | 2.3275 | 2.3393 | 2.3239 | 2.3314 | 41941340.0 |
| 2006-07-28 15:00:00 | AAPL | Stock | 2.3314 | 2.3332 | 2.3268 | 2.3282 | 36462440.0 |
| 2006-07-28 15:30:00 | AAPL | Stock | 2.3282 | 2.3457 | 2.3279 | 2.3425 | 110417720.0 |
| 2006-07-28 16:00:00 | AAPL | Stock | 2.3425 | 2.3468 | 2.3222 | 2.3468 | 2084544.0 |
| 2006-07-28 16:30:00 | AAPL | Stock | 2.3446 | 2.3446 | 2.3429 | 2.3446 | 114800.0 |
| 2006-07-28 17:00:00 | AAPL | Stock | 2.3446 | 2.3471 | 2.3429 | 2.3471 | 346500.0 |
| 2006-07-28 17:30:00 | AAPL | Stock | 2.3471 | 2.3482 | 2.3432 | 2.3432 | 82068.0 |
| 2006-07-28 18:00:00 | AAPL | Stock | 2.345 | 2.35 | 2.3446 | 2.35 | 128408.0 |
| 2006-07-28 07:30:00 | MSFT | Stock | 23.85 | 23.85 | 23.85 | 23.85 | 1000.0 |
| 2006-07-28 08:00:00 | MSFT | Stock | 23.9 | 23.95 | 23.9 | 23.92 | 92772.0 |
| 2006-07-28 08:30:00 | MSFT | Stock | 23.92 | 24.04 | 23.92 | 24.04 | 8567.0 |
| 2006-07-28 09:00:00 | MSFT | Stock | 24.0 | 24.16 | 24.0 | 24.09 | 67446.0 |
| 2006-07-28 09:30:00 | MSFT | Stock | 24.08 | 24.24 | 24.06 | 24.22 | 5149319.0 |
| 2006-07-28 10:00:00 | MSFT | Stock | 24.22 | 24.24 | 24.07 | 24.08 | 4246816.0 |
| 2006-07-28 10:30:00 | MSFT | Stock | 24.08 | 24.22 | 24.06 | 24.12 | 5036056.0 |
| 2006-07-28 11:00:00 | MSFT | Stock | 24.12 | 24.2 | 24.1 | 24.181 | 5393275.0 |
| 2006-07-28 11:30:00 | MSFT | Stock | 24.19 | 24.23 | 24.13 | 24.14 | 2783205.0 |
| 2006-07-28 12:00:00 | MSFT | Stock | 24.14 | 24.18 | 24.11 | 24.15 | 1270216.0 |
| 2006-07-28 12:30:00 | MSFT | Stock | 24.14 | 24.22 | 24.12 | 24.18 | 3674688.0 |
| 2006-07-28 13:00:00 | MSFT | Stock | 24.18 | 24.23 | 24.16 | 24.17 | 2402487.0 |
| 2006-07-28 13:30:00 | MSFT | Stock | 24.17 | 24.22 | 24.1 | 24.162 | 1769335.0 |
| 2006-07-28 14:00:00 | MSFT | Stock | 24.17 | 24.21 | 24.16 | 24.2 | 3497057.0 |
| 2006-07-28 14:30:00 | MSFT | Stock | 24.2 | 24.25 | 24.17 | 24.23 | 3224517.0 |
| 2006-07-28 15:00:00 | MSFT | Stock | 24.23 | 24.25 | 24.18 | 24.25 | 3877166.0 |
| 2006-07-28 15:30:00 | MSFT | Stock | 24.25 | 24.28 | 24.1 | 24.22 | 6789826.0 |
| 2006-07-28 16:00:00 | MSFT | Stock | 24.2 | 24.28 | 24.2 | 24.28 | 494659.0 |
| 2006-07-28 16:30:00 | MSFT | Stock | 24.25 | 24.25 | 24.25 | 24.25 | 490.0 |
| 2006-07-28 17:00:00 | MSFT | Stock | 24.25 | 24.25 | 24.19 | 24.25 | 3300.0 |
| 2006-07-28 17:30:00 | MSFT | Stock | 24.25 | 24.26 | 24.13 | 24.25 | 3850.0 |
| 2006-07-28 18:00:00 | MSFT | Stock | 24.25 | 24.25 | 24.24 | 24.24 | 219.0 |
| 2006-07-28 08:00:00 | NVDA | Stock | 0.345 | 0.345 | 0.345 | 0.345 | 42000.0 |
| 2006-07-28 08:30:00 | NVDA | Stock | 0.3495 | 0.3495 | 0.3495 | 0.3495 | 12000.0 |
| 2006-07-28 09:00:00 | NVDA | Stock | 0.3483 | 0.3523 | 0.3453 | 0.3512 | 930480.0 |
| 2006-07-28 09:30:00 | NVDA | Stock | 0.3512 | 0.3598 | 0.3492 | 0.3553 | 94063260.0 |
| 2006-07-28 10:00:00 | NVDA | Stock | 0.3555 | 0.3567 | 0.3525 | 0.3535 | 39220080.0 |
| 2006-07-28 10:30:00 | NVDA | Stock | 0.3535 | 0.3555 | 0.3533 | 0.3555 | 26483520.0 |
| 2006-07-28 11:00:00 | NVDA | Stock | 0.3557 | 0.3595 | 0.3555 | 0.3593 | 49254960.0 |
> showing 50 of 49,424 rows — these rows as CSV