PREVIEW / stock_5min / 2008-01-22
file: by_date/stock_5min/2008/2008-01-22.parquet size: 4.7 MB rows: 339,568 symbols: 3,289
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 |
|---|---|---|---|---|---|---|---|
| 2008-01-22 04:05:00 | AAPL | Stock | 5.1289 | 5.1321 | 5.1289 | 5.1321 | 5600.0 |
| 2008-01-22 04:10:00 | AAPL | Stock | 5.0893 | 5.0893 | 5.0893 | 5.0893 | 14000.0 |
| 2008-01-22 04:15:00 | AAPL | Stock | 5.1514 | 5.5 | 5.1396 | 5.1396 | 30856.0 |
| 2008-01-22 04:20:00 | AAPL | Stock | 5.1132 | 5.1136 | 5.1068 | 5.1068 | 18200.0 |
| 2008-01-22 04:30:00 | AAPL | Stock | 5.0982 | 5.0982 | 5.0982 | 5.0982 | 42000.0 |
| 2008-01-22 04:35:00 | AAPL | Stock | 5.125 | 5.1289 | 5.1246 | 5.1246 | 36400.0 |
| 2008-01-22 04:40:00 | AAPL | Stock | 5.1282 | 5.1504 | 5.1282 | 5.1504 | 19600.0 |
| 2008-01-22 04:45:00 | AAPL | Stock | 5.1675 | 5.1929 | 5.1643 | 5.1929 | 30800.0 |
| 2008-01-22 04:50:00 | AAPL | Stock | 5.1929 | 5.1929 | 5.1929 | 5.1929 | 2800.0 |
| 2008-01-22 04:55:00 | AAPL | Stock | 5.1786 | 5.2057 | 5.1786 | 5.1964 | 72800.0 |
| 2008-01-22 05:00:00 | AAPL | Stock | 5.2232 | 5.2232 | 5.2232 | 5.2232 | 2800.0 |
| 2008-01-22 05:05:00 | AAPL | Stock | 5.2214 | 5.2214 | 5.2054 | 5.2054 | 11200.0 |
| 2008-01-22 05:15:00 | AAPL | Stock | 5.2143 | 5.2411 | 5.2143 | 5.2411 | 15148.0 |
| 2008-01-22 05:20:00 | AAPL | Stock | 5.2411 | 5.245 | 5.2411 | 5.245 | 19600.0 |
| 2008-01-22 05:25:00 | AAPL | Stock | 5.25 | 5.25 | 5.25 | 5.25 | 16800.0 |
| 2008-01-22 05:35:00 | AAPL | Stock | 5.2836 | 5.2836 | 5.2736 | 5.2782 | 51380.0 |
| 2008-01-22 05:40:00 | AAPL | Stock | 5.2679 | 5.2679 | 5.2536 | 5.2536 | 22400.0 |
| 2008-01-22 05:45:00 | AAPL | Stock | 5.2679 | 5.2679 | 5.25 | 5.25 | 19600.0 |
| 2008-01-22 05:50:00 | AAPL | Stock | 5.2679 | 5.3211 | 5.2679 | 5.2804 | 36428.0 |
| 2008-01-22 05:55:00 | AAPL | Stock | 5.2836 | 5.2836 | 5.2836 | 5.2836 | 14000.0 |
| 2008-01-22 06:00:00 | AAPL | Stock | 5.2821 | 5.2821 | 5.2821 | 5.2821 | 8400.0 |
| 2008-01-22 06:05:00 | AAPL | Stock | 5.3211 | 5.3321 | 5.2821 | 5.3321 | 87948.0 |
| 2008-01-22 06:10:00 | AAPL | Stock | 5.3211 | 5.3214 | 5.2929 | 5.3157 | 142380.0 |
| 2008-01-22 06:15:00 | AAPL | Stock | 5.3286 | 5.3571 | 5.3286 | 5.3571 | 102088.0 |
| 2008-01-22 06:20:00 | AAPL | Stock | 5.3707 | 5.3707 | 5.3707 | 5.3707 | 2800.0 |
| 2008-01-22 06:25:00 | AAPL | Stock | 5.3696 | 5.3696 | 5.3696 | 5.3696 | 2800.0 |
| 2008-01-22 06:30:00 | AAPL | Stock | 5.3571 | 5.3696 | 5.3571 | 5.3696 | 30800.0 |
| 2008-01-22 06:35:00 | AAPL | Stock | 5.3571 | 5.3571 | 5.3571 | 5.3571 | 36400.0 |
| 2008-01-22 06:40:00 | AAPL | Stock | 5.3696 | 5.3707 | 5.3696 | 5.3707 | 28700.0 |
| 2008-01-22 06:45:00 | AAPL | Stock | 5.375 | 5.375 | 5.3571 | 5.3571 | 30800.0 |
| 2008-01-22 06:50:00 | AAPL | Stock | 5.3671 | 5.3707 | 5.3332 | 5.3332 | 70924.0 |
| 2008-01-22 06:55:00 | AAPL | Stock | 5.34 | 5.3704 | 5.2857 | 5.2857 | 178276.0 |
| 2008-01-22 07:00:00 | AAPL | Stock | 5.3482 | 5.3929 | 5.2818 | 5.3661 | 758352.0 |
| 2008-01-22 07:05:00 | AAPL | Stock | 5.3611 | 5.4211 | 5.3611 | 5.3929 | 518644.0 |
| 2008-01-22 07:10:00 | AAPL | Stock | 5.3811 | 5.3932 | 5.3571 | 5.3571 | 368144.0 |
| 2008-01-22 07:15:00 | AAPL | Stock | 5.3571 | 5.3964 | 5.3454 | 5.3964 | 503804.0 |
| 2008-01-22 07:20:00 | AAPL | Stock | 5.3946 | 5.4407 | 5.3714 | 5.4307 | 547932.0 |
| 2008-01-22 07:25:00 | AAPL | Stock | 5.4286 | 5.4839 | 5.4179 | 5.4179 | 565908.0 |
| 2008-01-22 07:30:00 | AAPL | Stock | 5.4239 | 5.4286 | 5.4071 | 5.4286 | 863072.0 |
| 2008-01-22 07:35:00 | AAPL | Stock | 5.4282 | 5.475 | 5.4282 | 5.4446 | 486388.0 |
| 2008-01-22 07:40:00 | AAPL | Stock | 5.4464 | 5.4657 | 5.4286 | 5.4357 | 275100.0 |
| 2008-01-22 07:45:00 | AAPL | Stock | 5.4464 | 5.4643 | 5.4286 | 5.4589 | 645848.0 |
| 2008-01-22 07:50:00 | AAPL | Stock | 5.4568 | 5.4636 | 5.4429 | 5.4636 | 105000.0 |
| 2008-01-22 07:55:00 | AAPL | Stock | 5.4475 | 5.4482 | 5.4289 | 5.4289 | 291060.0 |
| 2008-01-22 08:00:00 | AAPL | Stock | 5.3571 | 5.4604 | 5.2857 | 5.2946 | 4970224.0 |
| 2008-01-22 08:05:00 | AAPL | Stock | 5.3036 | 5.3393 | 5.2857 | 5.2964 | 2052232.0 |
| 2008-01-22 08:10:00 | AAPL | Stock | 5.3036 | 5.3564 | 5.2918 | 5.315 | 2637376.0 |
| 2008-01-22 08:15:00 | AAPL | Stock | 5.3146 | 5.3214 | 5.305 | 5.3139 | 1231552.0 |
| 2008-01-22 08:20:00 | AAPL | Stock | 5.3186 | 5.7393 | 5.315 | 5.5268 | 22740424.0 |
| 2008-01-22 08:25:00 | AAPL | Stock | 5.5393 | 5.605 | 5.4954 | 5.535 | 9879016.0 |
> showing 50 of 339,568 rows — these rows as CSV