PREVIEW / stock_5min / 2008-08-19
file: by_date/stock_5min/2008/2008-08-19.parquet size: 4.3 MB rows: 308,394 symbols: 3,306
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-08-19 05:30:00 | AAPL | Stock | 6.2414 | 6.2414 | 6.2414 | 6.2414 | 2800.0 |
| 2008-08-19 05:40:00 | AAPL | Stock | 6.2286 | 6.2286 | 6.2286 | 6.2286 | 9800.0 |
| 2008-08-19 05:45:00 | AAPL | Stock | 6.2275 | 6.2275 | 6.2275 | 6.2275 | 2800.0 |
| 2008-08-19 06:00:00 | AAPL | Stock | 6.2275 | 6.2275 | 6.2275 | 6.2275 | 14000.0 |
| 2008-08-19 06:30:00 | AAPL | Stock | 6.2275 | 6.2275 | 6.2275 | 6.2275 | 13496.0 |
| 2008-08-19 07:00:00 | AAPL | Stock | 6.2857 | 6.2857 | 6.2857 | 6.2857 | 2800.0 |
| 2008-08-19 07:25:00 | AAPL | Stock | 6.25 | 6.2679 | 6.25 | 6.2679 | 10192.0 |
| 2008-08-19 07:40:00 | AAPL | Stock | 6.25 | 6.25 | 6.25 | 6.25 | 42000.0 |
| 2008-08-19 07:45:00 | AAPL | Stock | 6.25 | 6.25 | 6.25 | 6.25 | 2800.0 |
| 2008-08-19 07:50:00 | AAPL | Stock | 6.2375 | 6.2375 | 6.2325 | 6.2325 | 11200.0 |
| 2008-08-19 07:55:00 | AAPL | Stock | 6.2325 | 6.2325 | 6.2321 | 6.2321 | 8400.0 |
| 2008-08-19 08:00:00 | AAPL | Stock | 6.2375 | 6.2375 | 6.2282 | 6.2357 | 86072.0 |
| 2008-08-19 08:05:00 | AAPL | Stock | 6.2332 | 6.2364 | 6.2329 | 6.2364 | 46200.0 |
| 2008-08-19 08:10:00 | AAPL | Stock | 6.2364 | 6.2418 | 6.2364 | 6.2414 | 45640.0 |
| 2008-08-19 08:15:00 | AAPL | Stock | 6.2443 | 6.2504 | 6.2411 | 6.2432 | 116200.0 |
| 2008-08-19 08:20:00 | AAPL | Stock | 6.2439 | 6.2446 | 6.2411 | 6.2411 | 104916.0 |
| 2008-08-19 08:25:00 | AAPL | Stock | 6.2411 | 6.2511 | 6.2411 | 6.2504 | 44156.0 |
| 2008-08-19 08:30:00 | AAPL | Stock | 6.2504 | 6.2504 | 6.21 | 6.2143 | 2026752.0 |
| 2008-08-19 08:35:00 | AAPL | Stock | 6.215 | 6.2214 | 6.2107 | 6.2214 | 408632.0 |
| 2008-08-19 08:40:00 | AAPL | Stock | 6.2243 | 6.2336 | 6.2214 | 6.2307 | 252000.0 |
| 2008-08-19 08:45:00 | AAPL | Stock | 6.2261 | 6.2286 | 6.2229 | 6.2239 | 189280.0 |
| 2008-08-19 08:50:00 | AAPL | Stock | 6.2239 | 6.2239 | 6.2179 | 6.2221 | 495096.0 |
| 2008-08-19 08:55:00 | AAPL | Stock | 6.225 | 6.2254 | 6.2225 | 6.2246 | 56112.0 |
| 2008-08-19 09:00:00 | AAPL | Stock | 6.2279 | 6.2279 | 6.2143 | 6.2179 | 299852.0 |
| 2008-08-19 09:05:00 | AAPL | Stock | 6.2164 | 6.2232 | 6.2143 | 6.22 | 174440.0 |
| 2008-08-19 09:10:00 | AAPL | Stock | 6.225 | 6.2282 | 6.2236 | 6.2279 | 139860.0 |
| 2008-08-19 09:15:00 | AAPL | Stock | 6.2279 | 6.2279 | 6.2107 | 6.2107 | 292880.0 |
| 2008-08-19 09:20:00 | AAPL | Stock | 6.2107 | 6.2246 | 6.2107 | 6.2246 | 60200.0 |
| 2008-08-19 09:25:00 | AAPL | Stock | 6.2264 | 6.2389 | 6.2225 | 6.2364 | 354284.0 |
| 2008-08-19 09:30:00 | AAPL | Stock | 6.2336 | 6.2729 | 6.225 | 6.2621 | 23256016.0 |
| 2008-08-19 09:35:00 | AAPL | Stock | 6.2629 | 6.3107 | 6.2618 | 6.3046 | 22773828.0 |
| 2008-08-19 09:40:00 | AAPL | Stock | 6.3046 | 6.3214 | 6.2946 | 6.3175 | 17826228.0 |
| 2008-08-19 09:45:00 | AAPL | Stock | 6.3171 | 6.3239 | 6.2857 | 6.29 | 14225260.0 |
| 2008-08-19 09:50:00 | AAPL | Stock | 6.2889 | 6.3029 | 6.2814 | 6.3021 | 14435960.0 |
| 2008-08-19 09:55:00 | AAPL | Stock | 6.3021 | 6.3082 | 6.2907 | 6.3025 | 8417752.0 |
| 2008-08-19 10:00:00 | AAPL | Stock | 6.3018 | 6.3025 | 6.2804 | 6.2861 | 8173816.0 |
| 2008-08-19 10:05:00 | AAPL | Stock | 6.2857 | 6.2875 | 6.2602 | 6.2618 | 10274768.0 |
| 2008-08-19 10:10:00 | AAPL | Stock | 6.2604 | 6.2796 | 6.26 | 6.2704 | 7249816.0 |
| 2008-08-19 10:15:00 | AAPL | Stock | 6.2682 | 6.2857 | 6.2639 | 6.2743 | 6438740.0 |
| 2008-08-19 10:20:00 | AAPL | Stock | 6.2757 | 6.2836 | 6.2679 | 6.2782 | 6464192.0 |
| 2008-08-19 10:25:00 | AAPL | Stock | 6.2775 | 6.2857 | 6.2732 | 6.2775 | 6233668.0 |
| 2008-08-19 10:30:00 | AAPL | Stock | 6.2779 | 6.3018 | 6.2775 | 6.2904 | 10168648.0 |
| 2008-08-19 10:35:00 | AAPL | Stock | 6.29 | 6.2979 | 6.2868 | 6.2939 | 4978624.0 |
| 2008-08-19 10:40:00 | AAPL | Stock | 6.2937 | 6.3061 | 6.2921 | 6.3018 | 7630336.0 |
| 2008-08-19 10:45:00 | AAPL | Stock | 6.3021 | 6.3068 | 6.2932 | 6.2971 | 5216148.0 |
| 2008-08-19 10:50:00 | AAPL | Stock | 6.2968 | 6.2968 | 6.2804 | 6.283 | 6567904.0 |
| 2008-08-19 10:55:00 | AAPL | Stock | 6.2868 | 6.2954 | 6.2861 | 6.2886 | 3131436.0 |
| 2008-08-19 11:00:00 | AAPL | Stock | 6.2886 | 6.2907 | 6.2757 | 6.2757 | 3267628.0 |
| 2008-08-19 11:05:00 | AAPL | Stock | 6.2757 | 6.2885 | 6.2755 | 6.2818 | 4310404.0 |
| 2008-08-19 11:10:00 | AAPL | Stock | 6.2836 | 6.2911 | 6.2786 | 6.2817 | 3767400.0 |
> showing 50 of 308,394 rows — these rows as CSV