PREVIEW / stock_1min / 2009-12-24
file: by_date/stock_1min/2009/2009-12-24.parquet size: 6.2 MB rows: 447,355 symbols: 2,744
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-12-24 07:03:00 | AAPL | Stock | 7.25 | 7.25 | 7.25 | 7.25 | 2800.0 |
| 2009-12-24 07:09:00 | AAPL | Stock | 7.2361 | 7.2361 | 7.2361 | 7.2361 | 5320.0 |
| 2009-12-24 07:23:00 | AAPL | Stock | 7.25 | 7.25 | 7.25 | 7.25 | 16800.0 |
| 2009-12-24 07:24:00 | AAPL | Stock | 7.25 | 7.25 | 7.25 | 7.25 | 2800.0 |
| 2009-12-24 07:27:00 | AAPL | Stock | 7.2436 | 7.2436 | 7.2436 | 7.2436 | 7420.0 |
| 2009-12-24 07:28:00 | AAPL | Stock | 7.25 | 7.25 | 7.25 | 7.25 | 14000.0 |
| 2009-12-24 07:37:00 | AAPL | Stock | 7.2536 | 7.2536 | 7.2536 | 7.2536 | 13580.0 |
| 2009-12-24 07:38:00 | AAPL | Stock | 7.2536 | 7.2536 | 7.2536 | 7.2536 | 14000.0 |
| 2009-12-24 07:42:00 | AAPL | Stock | 7.2568 | 7.2589 | 7.2568 | 7.2589 | 11760.0 |
| 2009-12-24 07:43:00 | AAPL | Stock | 7.2589 | 7.2589 | 7.2568 | 7.2568 | 142240.0 |
| 2009-12-24 07:44:00 | AAPL | Stock | 7.25 | 7.25 | 7.25 | 7.25 | 14000.0 |
| 2009-12-24 07:46:00 | AAPL | Stock | 7.25 | 7.25 | 7.25 | 7.25 | 30800.0 |
| 2009-12-24 07:47:00 | AAPL | Stock | 7.25 | 7.25 | 7.25 | 7.25 | 5600.0 |
| 2009-12-24 07:48:00 | AAPL | Stock | 7.2496 | 7.25 | 7.2496 | 7.25 | 16800.0 |
| 2009-12-24 07:50:00 | AAPL | Stock | 7.2496 | 7.25 | 7.2496 | 7.25 | 140000.0 |
| 2009-12-24 07:56:00 | AAPL | Stock | 7.2496 | 7.25 | 7.2496 | 7.25 | 75600.0 |
| 2009-12-24 07:59:00 | AAPL | Stock | 7.25 | 7.25 | 7.25 | 7.25 | 8400.0 |
| 2009-12-24 08:00:00 | AAPL | Stock | 7.25 | 7.25 | 7.2448 | 7.2448 | 272300.0 |
| 2009-12-24 08:01:00 | AAPL | Stock | 7.2464 | 7.2482 | 7.2464 | 7.2464 | 42140.0 |
| 2009-12-24 08:02:00 | AAPL | Stock | 7.2468 | 7.2468 | 7.2429 | 7.2429 | 14000.0 |
| 2009-12-24 08:04:00 | AAPL | Stock | 7.2454 | 7.2496 | 7.2454 | 7.2496 | 43540.0 |
| 2009-12-24 08:05:00 | AAPL | Stock | 7.25 | 7.25 | 7.245 | 7.245 | 69440.0 |
| 2009-12-24 08:06:00 | AAPL | Stock | 7.2466 | 7.25 | 7.2464 | 7.2464 | 16800.0 |
| 2009-12-24 08:07:00 | AAPL | Stock | 7.25 | 7.25 | 7.2464 | 7.2482 | 86800.0 |
| 2009-12-24 08:08:00 | AAPL | Stock | 7.2482 | 7.25 | 7.2482 | 7.25 | 11200.0 |
| 2009-12-24 08:09:00 | AAPL | Stock | 7.2496 | 7.25 | 7.2486 | 7.25 | 71596.0 |
| 2009-12-24 08:10:00 | AAPL | Stock | 7.2518 | 7.2518 | 7.2504 | 7.2504 | 8400.0 |
| 2009-12-24 08:12:00 | AAPL | Stock | 7.2571 | 7.2589 | 7.2571 | 7.2582 | 137900.0 |
| 2009-12-24 08:13:00 | AAPL | Stock | 7.2564 | 7.2589 | 7.2564 | 7.2587 | 16800.0 |
| 2009-12-24 08:14:00 | AAPL | Stock | 7.2557 | 7.2589 | 7.2557 | 7.2571 | 39200.0 |
| 2009-12-24 08:15:00 | AAPL | Stock | 7.2586 | 7.2586 | 7.2539 | 7.2539 | 33600.0 |
| 2009-12-24 08:17:00 | AAPL | Stock | 7.2582 | 7.2589 | 7.2571 | 7.2571 | 36400.0 |
| 2009-12-24 08:18:00 | AAPL | Stock | 7.2571 | 7.2589 | 7.2571 | 7.2589 | 18200.0 |
| 2009-12-24 08:19:00 | AAPL | Stock | 7.2589 | 7.2607 | 7.2589 | 7.2607 | 25900.0 |
| 2009-12-24 08:20:00 | AAPL | Stock | 7.2607 | 7.2625 | 7.2607 | 7.2625 | 28000.0 |
| 2009-12-24 08:21:00 | AAPL | Stock | 7.2636 | 7.2643 | 7.2636 | 7.2643 | 48300.0 |
| 2009-12-24 08:22:00 | AAPL | Stock | 7.2643 | 7.2643 | 7.2643 | 7.2643 | 35000.0 |
| 2009-12-24 08:23:00 | AAPL | Stock | 7.2643 | 7.2661 | 7.2643 | 7.2661 | 30800.0 |
| 2009-12-24 08:24:00 | AAPL | Stock | 7.265 | 7.265 | 7.2643 | 7.2643 | 78680.0 |
| 2009-12-24 08:25:00 | AAPL | Stock | 7.262 | 7.262 | 7.2604 | 7.2604 | 146048.0 |
| 2009-12-24 08:26:00 | AAPL | Stock | 7.2604 | 7.2607 | 7.26 | 7.2604 | 55720.0 |
| 2009-12-24 08:27:00 | AAPL | Stock | 7.2575 | 7.2575 | 7.2571 | 7.2571 | 37800.0 |
| 2009-12-24 08:28:00 | AAPL | Stock | 7.2571 | 7.2596 | 7.2561 | 7.2561 | 61600.0 |
| 2009-12-24 08:29:00 | AAPL | Stock | 7.2571 | 7.2571 | 7.2571 | 7.2571 | 14476.0 |
| 2009-12-24 08:30:00 | AAPL | Stock | 7.2568 | 7.2661 | 7.2568 | 7.2661 | 215012.0 |
| 2009-12-24 08:31:00 | AAPL | Stock | 7.2639 | 7.2643 | 7.2607 | 7.2611 | 28140.0 |
| 2009-12-24 08:32:00 | AAPL | Stock | 7.26 | 7.2629 | 7.2579 | 7.2607 | 35000.0 |
| 2009-12-24 08:33:00 | AAPL | Stock | 7.2607 | 7.2607 | 7.2607 | 7.2607 | 20300.0 |
| 2009-12-24 08:34:00 | AAPL | Stock | 7.2625 | 7.2625 | 7.2607 | 7.2607 | 22400.0 |
| 2009-12-24 08:35:00 | AAPL | Stock | 7.2625 | 7.2625 | 7.2607 | 7.2611 | 36400.0 |
> showing 50 of 447,355 rows — these rows as CSV