PREVIEW / stock_5min / 2009-01-09
file: by_date/stock_5min/2009/2009-01-09.parquet size: 4.3 MB rows: 305,039 symbols: 3,307
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-01-09 08:00:00 | AAPL | Stock | 3.2982 | 3.3193 | 3.2982 | 3.3193 | 83160.0 |
| 2009-01-09 08:05:00 | AAPL | Stock | 3.3071 | 3.3071 | 3.3071 | 3.3071 | 8400.0 |
| 2009-01-09 08:10:00 | AAPL | Stock | 3.3071 | 3.3075 | 3.3071 | 3.3071 | 49000.0 |
| 2009-01-09 08:15:00 | AAPL | Stock | 3.3179 | 3.3214 | 3.3125 | 3.3125 | 52500.0 |
| 2009-01-09 08:20:00 | AAPL | Stock | 3.3161 | 3.3268 | 3.3161 | 3.325 | 52808.0 |
| 2009-01-09 08:25:00 | AAPL | Stock | 3.3246 | 3.325 | 3.3132 | 3.3132 | 48104.0 |
| 2009-01-09 08:30:00 | AAPL | Stock | 3.3196 | 3.3514 | 3.3196 | 3.3464 | 760116.0 |
| 2009-01-09 08:35:00 | AAPL | Stock | 3.3464 | 3.3536 | 3.3304 | 3.3304 | 536760.0 |
| 2009-01-09 08:40:00 | AAPL | Stock | 3.3311 | 3.3389 | 3.3229 | 3.325 | 345800.0 |
| 2009-01-09 08:45:00 | AAPL | Stock | 3.3221 | 3.3329 | 3.3221 | 3.3304 | 57400.0 |
| 2009-01-09 08:50:00 | AAPL | Stock | 3.3321 | 3.3382 | 3.3304 | 3.3307 | 102200.0 |
| 2009-01-09 08:55:00 | AAPL | Stock | 3.3314 | 3.3346 | 3.3314 | 3.3343 | 28000.0 |
| 2009-01-09 09:00:00 | AAPL | Stock | 3.3343 | 3.3343 | 3.3304 | 3.3304 | 56000.0 |
| 2009-01-09 09:05:00 | AAPL | Stock | 3.3304 | 3.3336 | 3.3286 | 3.3304 | 93408.0 |
| 2009-01-09 09:10:00 | AAPL | Stock | 3.3304 | 3.3321 | 3.3293 | 3.3321 | 70252.0 |
| 2009-01-09 09:15:00 | AAPL | Stock | 3.3339 | 3.3354 | 3.3314 | 3.3325 | 43400.0 |
| 2009-01-09 09:20:00 | AAPL | Stock | 3.3307 | 3.3339 | 3.3286 | 3.3307 | 114744.0 |
| 2009-01-09 09:25:00 | AAPL | Stock | 3.3286 | 3.3325 | 3.3286 | 3.3321 | 260400.0 |
| 2009-01-09 09:30:00 | AAPL | Stock | 3.3321 | 3.335 | 3.2861 | 3.2953 | 17885784.0 |
| 2009-01-09 09:35:00 | AAPL | Stock | 3.2943 | 3.3 | 3.2786 | 3.2889 | 14291116.0 |
| 2009-01-09 09:40:00 | AAPL | Stock | 3.2893 | 3.2914 | 3.2657 | 3.2704 | 14517776.0 |
| 2009-01-09 09:45:00 | AAPL | Stock | 3.2689 | 3.2796 | 3.2604 | 3.2604 | 11555824.0 |
| 2009-01-09 09:50:00 | AAPL | Stock | 3.2607 | 3.2704 | 3.2532 | 3.2571 | 11814264.0 |
| 2009-01-09 09:55:00 | AAPL | Stock | 3.2568 | 3.2604 | 3.2464 | 3.2479 | 14546504.0 |
| 2009-01-09 10:00:00 | AAPL | Stock | 3.2482 | 3.2632 | 3.2418 | 3.2575 | 10236716.0 |
| 2009-01-09 10:05:00 | AAPL | Stock | 3.2571 | 3.2618 | 3.2418 | 3.2536 | 9144184.0 |
| 2009-01-09 10:10:00 | AAPL | Stock | 3.2536 | 3.2543 | 3.2396 | 3.25 | 11143412.0 |
| 2009-01-09 10:15:00 | AAPL | Stock | 3.2492 | 3.2507 | 3.2282 | 3.2321 | 11606084.0 |
| 2009-01-09 10:20:00 | AAPL | Stock | 3.2325 | 3.2493 | 3.2304 | 3.2407 | 7233968.0 |
| 2009-01-09 10:25:00 | AAPL | Stock | 3.2407 | 3.2421 | 3.2314 | 3.2346 | 7153552.0 |
| 2009-01-09 10:30:00 | AAPL | Stock | 3.2346 | 3.235 | 3.2193 | 3.2314 | 10818976.0 |
| 2009-01-09 10:35:00 | AAPL | Stock | 3.2314 | 3.245 | 3.2257 | 3.2443 | 9633792.0 |
| 2009-01-09 10:40:00 | AAPL | Stock | 3.2443 | 3.2461 | 3.2368 | 3.2389 | 5465796.0 |
| 2009-01-09 10:45:00 | AAPL | Stock | 3.2389 | 3.2464 | 3.2343 | 3.2454 | 5565868.0 |
| 2009-01-09 10:50:00 | AAPL | Stock | 3.2457 | 3.2496 | 3.2393 | 3.2475 | 5481672.0 |
| 2009-01-09 10:55:00 | AAPL | Stock | 3.2479 | 3.2482 | 3.2321 | 3.2339 | 6115256.0 |
| 2009-01-09 11:00:00 | AAPL | Stock | 3.2336 | 3.2429 | 3.2321 | 3.239 | 4351872.0 |
| 2009-01-09 11:05:00 | AAPL | Stock | 3.2393 | 3.2532 | 3.2393 | 3.2418 | 8352456.0 |
| 2009-01-09 11:10:00 | AAPL | Stock | 3.2418 | 3.2421 | 3.2346 | 3.2389 | 5220936.0 |
| 2009-01-09 11:15:00 | AAPL | Stock | 3.2389 | 3.2389 | 3.2293 | 3.2354 | 5807396.0 |
| 2009-01-09 11:20:00 | AAPL | Stock | 3.2361 | 3.2464 | 3.2339 | 3.2446 | 6687016.0 |
| 2009-01-09 11:25:00 | AAPL | Stock | 3.2457 | 3.2489 | 3.24 | 3.2404 | 4532108.0 |
| 2009-01-09 11:30:00 | AAPL | Stock | 3.2404 | 3.2421 | 3.2389 | 3.24 | 1945384.0 |
| 2009-01-09 11:35:00 | AAPL | Stock | 3.2399 | 3.2464 | 3.2399 | 3.2437 | 4571000.0 |
| 2009-01-09 11:40:00 | AAPL | Stock | 3.2443 | 3.2446 | 3.2279 | 3.2296 | 6399960.0 |
| 2009-01-09 11:45:00 | AAPL | Stock | 3.23 | 3.2346 | 3.2268 | 3.2307 | 5203716.0 |
| 2009-01-09 11:50:00 | AAPL | Stock | 3.2304 | 3.2336 | 3.2232 | 3.2311 | 6499640.0 |
| 2009-01-09 11:55:00 | AAPL | Stock | 3.2314 | 3.2364 | 3.2289 | 3.2336 | 2958844.0 |
| 2009-01-09 12:00:00 | AAPL | Stock | 3.2335 | 3.2361 | 3.2293 | 3.2325 | 2820412.0 |
| 2009-01-09 12:05:00 | AAPL | Stock | 3.2324 | 3.2482 | 3.2324 | 3.2453 | 7931532.0 |
> showing 50 of 305,039 rows — these rows as CSV