PREVIEW / stock_5min / 2006-04-05
file: by_date/stock_5min/2006/2006-04-05.parquet size: 3.0 MB rows: 221,050 symbols: 2,219
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-04-05 05:30:00 | AAPL | Stock | 2.1736 | 2.1736 | 2.1736 | 2.1736 | 2800.0 |
| 2006-04-05 05:55:00 | AAPL | Stock | 2.1732 | 2.1732 | 2.1732 | 2.1732 | 2800.0 |
| 2006-04-05 06:20:00 | AAPL | Stock | 2.1786 | 2.1786 | 2.1732 | 2.1786 | 140000.0 |
| 2006-04-05 06:25:00 | AAPL | Stock | 2.1786 | 2.1786 | 2.1786 | 2.1786 | 28000.0 |
| 2006-04-05 07:50:00 | AAPL | Stock | 2.1789 | 2.1789 | 2.175 | 2.175 | 8400.0 |
| 2006-04-05 07:55:00 | AAPL | Stock | 2.1786 | 2.1786 | 2.1786 | 2.1786 | 5600.0 |
| 2006-04-05 08:00:00 | AAPL | Stock | 2.175 | 2.1836 | 2.175 | 2.18 | 392560.0 |
| 2006-04-05 08:05:00 | AAPL | Stock | 2.1789 | 2.1789 | 2.1739 | 2.1739 | 196000.0 |
| 2006-04-05 08:10:00 | AAPL | Stock | 2.1754 | 2.1754 | 2.1739 | 2.1739 | 11200.0 |
| 2006-04-05 08:15:00 | AAPL | Stock | 2.1729 | 2.1729 | 2.1711 | 2.1711 | 243600.0 |
| 2006-04-05 08:20:00 | AAPL | Stock | 2.1707 | 2.1711 | 2.1679 | 2.1679 | 146664.0 |
| 2006-04-05 08:25:00 | AAPL | Stock | 2.1679 | 2.1714 | 2.1679 | 2.1714 | 192136.0 |
| 2006-04-05 08:30:00 | AAPL | Stock | 2.1714 | 2.1804 | 2.1682 | 2.1804 | 1196860.0 |
| 2006-04-05 08:35:00 | AAPL | Stock | 2.18 | 2.2361 | 2.1796 | 2.2279 | 4741436.0 |
| 2006-04-05 08:40:00 | AAPL | Stock | 2.2271 | 2.2461 | 2.2271 | 2.2389 | 8278228.0 |
| 2006-04-05 08:45:00 | AAPL | Stock | 2.2386 | 2.2482 | 2.2386 | 2.2432 | 7659148.0 |
| 2006-04-05 08:50:00 | AAPL | Stock | 2.2439 | 2.2764 | 2.2429 | 2.2746 | 15515976.0 |
| 2006-04-05 08:55:00 | AAPL | Stock | 2.2757 | 2.2839 | 2.2661 | 2.2707 | 10932936.0 |
| 2006-04-05 09:00:00 | AAPL | Stock | 2.2714 | 2.2886 | 2.2696 | 2.2786 | 10354820.0 |
| 2006-04-05 09:05:00 | AAPL | Stock | 2.2782 | 2.2989 | 2.2771 | 2.2989 | 11767056.0 |
| 2006-04-05 09:10:00 | AAPL | Stock | 2.2979 | 2.3125 | 2.2839 | 2.3071 | 16912784.0 |
| 2006-04-05 09:15:00 | AAPL | Stock | 2.3071 | 2.3207 | 2.2768 | 2.3111 | 19260500.0 |
| 2006-04-05 09:20:00 | AAPL | Stock | 2.3121 | 2.3329 | 2.3107 | 2.3218 | 20095040.0 |
| 2006-04-05 09:25:00 | AAPL | Stock | 2.3218 | 2.3386 | 2.3071 | 2.3129 | 30237004.0 |
| 2006-04-05 09:30:00 | AAPL | Stock | 2.3111 | 2.3232 | 2.2964 | 2.3111 | 105584752.0 |
| 2006-04-05 09:35:00 | AAPL | Stock | 2.3111 | 2.3429 | 2.3107 | 2.33 | 89388516.0 |
| 2006-04-05 09:40:00 | AAPL | Stock | 2.33 | 2.3368 | 2.3264 | 2.3304 | 78432060.0 |
| 2006-04-05 09:45:00 | AAPL | Stock | 2.3304 | 2.3311 | 2.3089 | 2.3186 | 60071088.0 |
| 2006-04-05 09:50:00 | AAPL | Stock | 2.3186 | 2.3214 | 2.2911 | 2.2968 | 64306844.0 |
| 2006-04-05 09:55:00 | AAPL | Stock | 2.2968 | 2.3104 | 2.2968 | 2.3104 | 32408320.0 |
| 2006-04-05 10:00:00 | AAPL | Stock | 2.3104 | 2.3143 | 2.3011 | 2.3036 | 32875696.0 |
| 2006-04-05 10:05:00 | AAPL | Stock | 2.3036 | 2.3079 | 2.2961 | 2.3025 | 30486204.0 |
| 2006-04-05 10:10:00 | AAPL | Stock | 2.3021 | 2.3118 | 2.2939 | 2.3 | 31478104.0 |
| 2006-04-05 10:15:00 | AAPL | Stock | 2.3 | 2.3161 | 2.2993 | 2.3118 | 32703664.0 |
| 2006-04-05 10:20:00 | AAPL | Stock | 2.3121 | 2.3207 | 2.3054 | 2.319 | 31598280.0 |
| 2006-04-05 10:25:00 | AAPL | Stock | 2.3193 | 2.3296 | 2.3179 | 2.3268 | 40069736.0 |
| 2006-04-05 10:30:00 | AAPL | Stock | 2.3264 | 2.3271 | 2.3089 | 2.3139 | 34040020.0 |
| 2006-04-05 10:35:00 | AAPL | Stock | 2.3143 | 2.3239 | 2.3114 | 2.3232 | 20140988.0 |
| 2006-04-05 10:40:00 | AAPL | Stock | 2.3236 | 2.3236 | 2.3139 | 2.3211 | 24400852.0 |
| 2006-04-05 10:45:00 | AAPL | Stock | 2.3207 | 2.3393 | 2.3207 | 2.3386 | 44985696.0 |
| 2006-04-05 10:50:00 | AAPL | Stock | 2.3386 | 2.3393 | 2.3307 | 2.3375 | 31495520.0 |
| 2006-04-05 10:55:00 | AAPL | Stock | 2.3375 | 2.3521 | 2.3368 | 2.3511 | 56905072.0 |
| 2006-04-05 11:00:00 | AAPL | Stock | 2.3511 | 2.3518 | 2.3414 | 2.3414 | 36278060.0 |
| 2006-04-05 11:05:00 | AAPL | Stock | 2.3414 | 2.3475 | 2.3382 | 2.3439 | 29232560.0 |
| 2006-04-05 11:10:00 | AAPL | Stock | 2.3443 | 2.3496 | 2.3321 | 2.335 | 31774064.0 |
| 2006-04-05 11:15:00 | AAPL | Stock | 2.335 | 2.3439 | 2.3329 | 2.3375 | 18153856.0 |
| 2006-04-05 11:20:00 | AAPL | Stock | 2.3364 | 2.3482 | 2.3318 | 2.3418 | 25614400.0 |
| 2006-04-05 11:25:00 | AAPL | Stock | 2.3421 | 2.3464 | 2.3407 | 2.345 | 10300864.0 |
| 2006-04-05 11:30:00 | AAPL | Stock | 2.3454 | 2.3482 | 2.3414 | 2.3432 | 14744212.0 |
| 2006-04-05 11:35:00 | AAPL | Stock | 2.3432 | 2.3443 | 2.3339 | 2.3418 | 22618008.0 |
> showing 50 of 221,050 rows — these rows as CSV