PREVIEW / stock_1min / 2009-04-17
file: by_date/stock_1min/2009/2009-04-17.parquet size: 12.4 MB rows: 954,245 symbols: 2,702
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-04-17 07:04:00 | AAPL | Stock | 4.3182 | 4.3182 | 4.3182 | 4.3182 | 16800.0 |
| 2009-04-17 07:26:00 | AAPL | Stock | 4.3193 | 4.3193 | 4.3193 | 4.3193 | 2800.0 |
| 2009-04-17 07:56:00 | AAPL | Stock | 4.3375 | 4.3375 | 4.3375 | 4.3375 | 11480.0 |
| 2009-04-17 08:00:00 | AAPL | Stock | 4.3339 | 4.3371 | 4.3339 | 4.3371 | 5600.0 |
| 2009-04-17 08:02:00 | AAPL | Stock | 4.3375 | 4.35 | 4.3375 | 4.35 | 51520.0 |
| 2009-04-17 08:04:00 | AAPL | Stock | 4.35 | 4.35 | 4.3496 | 4.3496 | 44800.0 |
| 2009-04-17 08:05:00 | AAPL | Stock | 4.3396 | 4.3396 | 4.3379 | 4.3379 | 9800.0 |
| 2009-04-17 08:06:00 | AAPL | Stock | 4.3489 | 4.3489 | 4.3486 | 4.3489 | 42000.0 |
| 2009-04-17 08:07:00 | AAPL | Stock | 4.3493 | 4.3511 | 4.3482 | 4.3482 | 61432.0 |
| 2009-04-17 08:08:00 | AAPL | Stock | 4.3479 | 4.3479 | 4.3464 | 4.3464 | 15232.0 |
| 2009-04-17 08:09:00 | AAPL | Stock | 4.3479 | 4.3479 | 4.3393 | 4.3393 | 8400.0 |
| 2009-04-17 08:10:00 | AAPL | Stock | 4.3393 | 4.3464 | 4.3339 | 4.3339 | 33992.0 |
| 2009-04-17 08:12:00 | AAPL | Stock | 4.3304 | 4.3339 | 4.3254 | 4.3332 | 53200.0 |
| 2009-04-17 08:18:00 | AAPL | Stock | 4.3332 | 4.3332 | 4.3304 | 4.3304 | 44912.0 |
| 2009-04-17 08:19:00 | AAPL | Stock | 4.325 | 4.3268 | 4.325 | 4.3268 | 10780.0 |
| 2009-04-17 08:20:00 | AAPL | Stock | 4.325 | 4.325 | 4.3214 | 4.325 | 14000.0 |
| 2009-04-17 08:21:00 | AAPL | Stock | 4.3214 | 4.3214 | 4.3214 | 4.3214 | 11200.0 |
| 2009-04-17 08:25:00 | AAPL | Stock | 4.32 | 4.32 | 4.32 | 4.32 | 5600.0 |
| 2009-04-17 08:27:00 | AAPL | Stock | 4.3214 | 4.3214 | 4.3196 | 4.3196 | 44800.0 |
| 2009-04-17 08:30:00 | AAPL | Stock | 4.3182 | 4.3182 | 4.3179 | 4.3179 | 60480.0 |
| 2009-04-17 08:33:00 | AAPL | Stock | 4.32 | 4.32 | 4.3196 | 4.3196 | 30800.0 |
| 2009-04-17 08:34:00 | AAPL | Stock | 4.3196 | 4.32 | 4.3196 | 4.32 | 53200.0 |
| 2009-04-17 08:37:00 | AAPL | Stock | 4.3196 | 4.3211 | 4.3196 | 4.3211 | 5600.0 |
| 2009-04-17 08:38:00 | AAPL | Stock | 4.3214 | 4.3214 | 4.3214 | 4.3214 | 12040.0 |
| 2009-04-17 08:43:00 | AAPL | Stock | 4.3236 | 4.3236 | 4.3236 | 4.3236 | 2800.0 |
| 2009-04-17 08:44:00 | AAPL | Stock | 4.325 | 4.325 | 4.3214 | 4.3243 | 44800.0 |
| 2009-04-17 08:45:00 | AAPL | Stock | 4.3239 | 4.3239 | 4.3239 | 4.3239 | 2800.0 |
| 2009-04-17 08:46:00 | AAPL | Stock | 4.3232 | 4.3232 | 4.3232 | 4.3232 | 9408.0 |
| 2009-04-17 08:49:00 | AAPL | Stock | 4.3179 | 4.3179 | 4.3179 | 4.3179 | 2800.0 |
| 2009-04-17 08:50:00 | AAPL | Stock | 4.3179 | 4.3179 | 4.3143 | 4.3143 | 23800.0 |
| 2009-04-17 08:51:00 | AAPL | Stock | 4.3143 | 4.3143 | 4.3114 | 4.3114 | 30800.0 |
| 2009-04-17 08:53:00 | AAPL | Stock | 4.3125 | 4.3125 | 4.3125 | 4.3125 | 5600.0 |
| 2009-04-17 08:54:00 | AAPL | Stock | 4.3107 | 4.3107 | 4.3107 | 4.3107 | 8400.0 |
| 2009-04-17 08:55:00 | AAPL | Stock | 4.3104 | 4.3104 | 4.3086 | 4.3086 | 19600.0 |
| 2009-04-17 08:56:00 | AAPL | Stock | 4.3093 | 4.3093 | 4.3089 | 4.3089 | 17920.0 |
| 2009-04-17 08:57:00 | AAPL | Stock | 4.3086 | 4.3086 | 4.3086 | 4.3086 | 2800.0 |
| 2009-04-17 08:58:00 | AAPL | Stock | 4.3089 | 4.3089 | 4.2968 | 4.2968 | 118300.0 |
| 2009-04-17 08:59:00 | AAPL | Stock | 4.3025 | 4.3025 | 4.3025 | 4.3025 | 7000.0 |
| 2009-04-17 09:00:00 | AAPL | Stock | 4.3025 | 4.3025 | 4.3 | 4.3 | 26040.0 |
| 2009-04-17 09:01:00 | AAPL | Stock | 4.3 | 4.3 | 4.2975 | 4.2975 | 12600.0 |
| 2009-04-17 09:02:00 | AAPL | Stock | 4.2975 | 4.3 | 4.2975 | 4.3 | 11200.0 |
| 2009-04-17 09:03:00 | AAPL | Stock | 4.3 | 4.3 | 4.2982 | 4.3 | 44800.0 |
| 2009-04-17 09:04:00 | AAPL | Stock | 4.2982 | 4.2982 | 4.2982 | 4.2982 | 7224.0 |
| 2009-04-17 09:05:00 | AAPL | Stock | 4.3 | 4.3 | 4.2989 | 4.2989 | 35476.0 |
| 2009-04-17 09:06:00 | AAPL | Stock | 4.2986 | 4.3 | 4.2986 | 4.2986 | 11200.0 |
| 2009-04-17 09:07:00 | AAPL | Stock | 4.3 | 4.3 | 4.3 | 4.3 | 3276.0 |
| 2009-04-17 09:10:00 | AAPL | Stock | 4.3007 | 4.3007 | 4.2964 | 4.2964 | 95900.0 |
| 2009-04-17 09:11:00 | AAPL | Stock | 4.2946 | 4.2946 | 4.2946 | 4.2946 | 8400.0 |
| 2009-04-17 09:12:00 | AAPL | Stock | 4.2946 | 4.2946 | 4.2929 | 4.2946 | 8400.0 |
| 2009-04-17 09:13:00 | AAPL | Stock | 4.2929 | 4.2929 | 4.2929 | 4.2929 | 8400.0 |
> showing 50 of 954,245 rows — these rows as CSV