PREVIEW / stock_30min / 2007-04-10
file: by_date/stock_30min/2007/2007-04-10.parquet size: 1010 KB rows: 54,399 symbols: 2,579
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-04-10 08:00:00 | AAPL | Stock | 3.3471 | 3.3479 | 3.3411 | 3.3446 | 325108.0 |
| 2007-04-10 08:30:00 | AAPL | Stock | 3.3454 | 3.3479 | 3.3454 | 3.3479 | 114800.0 |
| 2007-04-10 09:00:00 | AAPL | Stock | 3.3461 | 3.3518 | 3.3446 | 3.345 | 639828.0 |
| 2007-04-10 09:30:00 | AAPL | Stock | 3.3454 | 3.36 | 3.3407 | 3.3514 | 47014184.0 |
| 2007-04-10 10:00:00 | AAPL | Stock | 3.3511 | 3.3557 | 3.3446 | 3.3493 | 26889100.0 |
| 2007-04-10 10:30:00 | AAPL | Stock | 3.3493 | 3.3532 | 3.3432 | 3.3464 | 25833724.0 |
| 2007-04-10 11:00:00 | AAPL | Stock | 3.3468 | 3.3486 | 3.34 | 3.3454 | 27051388.0 |
| 2007-04-10 11:30:00 | AAPL | Stock | 3.3454 | 3.3475 | 3.3393 | 3.3421 | 21692272.0 |
| 2007-04-10 12:00:00 | AAPL | Stock | 3.3418 | 3.3475 | 3.3407 | 3.3454 | 18972380.0 |
| 2007-04-10 12:30:00 | AAPL | Stock | 3.3457 | 3.3461 | 3.3396 | 3.3396 | 18293380.0 |
| 2007-04-10 13:00:00 | AAPL | Stock | 3.3393 | 3.3464 | 3.3361 | 3.3457 | 25974536.0 |
| 2007-04-10 13:30:00 | AAPL | Stock | 3.3461 | 3.3475 | 3.3411 | 3.3443 | 16832452.0 |
| 2007-04-10 14:00:00 | AAPL | Stock | 3.3439 | 3.3482 | 3.3429 | 3.3435 | 17971968.0 |
| 2007-04-10 14:30:00 | AAPL | Stock | 3.3436 | 3.347 | 3.3432 | 3.3446 | 15013824.0 |
| 2007-04-10 15:00:00 | AAPL | Stock | 3.345 | 3.355 | 3.3411 | 3.3525 | 28000000.0 |
| 2007-04-10 15:30:00 | AAPL | Stock | 3.3521 | 3.3664 | 3.3521 | 3.3657 | 53262944.0 |
| 2007-04-10 16:00:00 | AAPL | Stock | 3.3661 | 3.3664 | 3.3475 | 3.3639 | 4879364.0 |
| 2007-04-10 16:30:00 | AAPL | Stock | 3.3643 | 3.3661 | 3.3636 | 3.365 | 276052.0 |
| 2007-04-10 17:00:00 | AAPL | Stock | 3.365 | 3.3654 | 3.365 | 3.3654 | 31360.0 |
| 2007-04-10 17:30:00 | AAPL | Stock | 3.365 | 3.3654 | 3.3643 | 3.3654 | 111916.0 |
| 2007-04-10 18:00:00 | AAPL | Stock | 3.3654 | 3.3661 | 3.3654 | 3.3654 | 68880.0 |
| 2007-04-10 18:30:00 | AAPL | Stock | 3.3654 | 3.3679 | 3.3654 | 3.3679 | 47544.0 |
| 2007-04-10 19:00:00 | AAPL | Stock | 3.3671 | 3.3671 | 3.3639 | 3.3639 | 8400.0 |
| 2007-04-10 19:30:00 | AAPL | Stock | 3.3664 | 3.3664 | 3.3643 | 3.3643 | 50400.0 |
| 2007-04-10 06:30:00 | MSFT | Stock | 28.57 | 28.57 | 28.57 | 28.57 | 500.0 |
| 2007-04-10 07:00:00 | MSFT | Stock | 28.57 | 28.57 | 28.52 | 28.52 | 5500.0 |
| 2007-04-10 07:30:00 | MSFT | Stock | 28.47 | 28.47 | 28.47 | 28.47 | 1000.0 |
| 2007-04-10 08:00:00 | MSFT | Stock | 28.47 | 28.57 | 28.47 | 28.57 | 5460.0 |
| 2007-04-10 08:30:00 | MSFT | Stock | 28.57 | 28.6 | 28.52 | 28.52 | 3435.0 |
| 2007-04-10 09:00:00 | MSFT | Stock | 28.51 | 28.54 | 28.49 | 28.5 | 46103.0 |
| 2007-04-10 09:30:00 | MSFT | Stock | 28.5 | 28.58 | 28.44 | 28.53 | 5784980.0 |
| 2007-04-10 10:00:00 | MSFT | Stock | 28.532 | 28.64 | 28.52 | 28.58 | 2630034.0 |
| 2007-04-10 10:30:00 | MSFT | Stock | 28.59 | 28.62 | 28.54 | 28.54 | 1780840.0 |
| 2007-04-10 11:00:00 | MSFT | Stock | 28.54 | 28.599 | 28.4 | 28.42 | 2489878.0 |
| 2007-04-10 11:30:00 | MSFT | Stock | 28.42 | 28.52 | 28.39 | 28.49 | 3105215.0 |
| 2007-04-10 12:00:00 | MSFT | Stock | 28.49 | 28.5 | 28.42 | 28.49 | 1165441.0 |
| 2007-04-10 12:30:00 | MSFT | Stock | 28.5 | 28.5 | 28.39 | 28.39 | 1624562.0 |
| 2007-04-10 13:00:00 | MSFT | Stock | 28.39 | 28.44 | 28.34 | 28.44 | 2141537.0 |
| 2007-04-10 13:30:00 | MSFT | Stock | 28.44 | 28.44 | 28.28 | 28.3 | 2247061.0 |
| 2007-04-10 14:00:00 | MSFT | Stock | 28.298 | 28.4 | 28.24 | 28.28 | 2715486.0 |
| 2007-04-10 14:30:00 | MSFT | Stock | 28.27 | 28.28 | 28.22 | 28.25 | 2826022.0 |
| 2007-04-10 15:00:00 | MSFT | Stock | 28.24 | 28.38 | 28.24 | 28.36 | 2760479.0 |
| 2007-04-10 15:30:00 | MSFT | Stock | 28.35 | 28.43 | 28.35 | 28.39 | 4119112.0 |
| 2007-04-10 16:00:00 | MSFT | Stock | 28.39 | 28.41 | 28.38 | 28.39 | 243758.0 |
| 2007-04-10 16:30:00 | MSFT | Stock | 28.39 | 28.39 | 28.37 | 28.39 | 2250.0 |
| 2007-04-10 17:00:00 | MSFT | Stock | 28.42 | 28.42 | 28.4 | 28.4 | 2201370.0 |
| 2007-04-10 18:00:00 | MSFT | Stock | 28.42 | 28.42 | 28.38 | 28.38 | 365.0 |
| 2007-04-10 18:30:00 | MSFT | Stock | 28.39 | 28.4 | 28.39 | 28.4 | 500.0 |
| 2007-04-10 19:30:00 | MSFT | Stock | 28.38 | 28.38 | 28.38 | 28.38 | 1000.0 |
| 2007-04-10 08:00:00 | NVDA | Stock | 0.506 | 0.506 | 0.505 | 0.506 | 156000.0 |
> showing 50 of 54,399 rows — these rows as CSV