PREVIEW / stock_1min / 2002-09-03
file: by_date/stock_1min/2002/2002-09-03.parquet size: 4.3 MB rows: 340,119 symbols: 1,209
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 |
|---|---|---|---|---|---|---|---|
| 2002-09-03 08:02:00 | AAPL | Stock | 0.2633 | 0.2633 | 0.2633 | 0.2633 | 56000.0 |
| 2002-09-03 08:15:00 | AAPL | Stock | 0.2616 | 0.2616 | 0.2616 | 0.2616 | 67200.0 |
| 2002-09-03 08:42:00 | AAPL | Stock | 0.2634 | 0.2634 | 0.2634 | 0.2634 | 1741600.0 |
| 2002-09-03 09:01:00 | AAPL | Stock | 0.2605 | 0.2607 | 0.2605 | 0.2607 | 28000.0 |
| 2002-09-03 09:04:00 | AAPL | Stock | 0.2607 | 0.2607 | 0.2607 | 0.2607 | 179200.0 |
| 2002-09-03 09:17:00 | AAPL | Stock | 0.2604 | 0.2604 | 0.2604 | 0.2604 | 89600.0 |
| 2002-09-03 09:18:00 | AAPL | Stock | 0.2634 | 0.2634 | 0.2634 | 0.2634 | 1220800.0 |
| 2002-09-03 09:23:00 | AAPL | Stock | 0.2607 | 0.2607 | 0.2605 | 0.2605 | 84000.0 |
| 2002-09-03 09:26:00 | AAPL | Stock | 0.2591 | 0.26 | 0.2589 | 0.2593 | 123200.0 |
| 2002-09-03 09:27:00 | AAPL | Stock | 0.2589 | 0.2589 | 0.2589 | 0.2589 | 56000.0 |
| 2002-09-03 09:28:00 | AAPL | Stock | 0.2589 | 0.2589 | 0.258 | 0.2588 | 285600.0 |
| 2002-09-03 09:29:00 | AAPL | Stock | 0.258 | 0.2586 | 0.258 | 0.2586 | 733600.0 |
| 2002-09-03 09:30:00 | AAPL | Stock | 0.2588 | 0.2588 | 0.2571 | 0.2579 | 1039640.0 |
| 2002-09-03 09:31:00 | AAPL | Stock | 0.2575 | 0.2598 | 0.2571 | 0.258 | 1461600.0 |
| 2002-09-03 09:32:00 | AAPL | Stock | 0.258 | 0.2591 | 0.258 | 0.2591 | 740656.0 |
| 2002-09-03 09:33:00 | AAPL | Stock | 0.259 | 0.2596 | 0.2589 | 0.2591 | 1120000.0 |
| 2002-09-03 09:34:00 | AAPL | Stock | 0.2588 | 0.2593 | 0.2588 | 0.2593 | 834400.0 |
| 2002-09-03 09:35:00 | AAPL | Stock | 0.2593 | 0.2598 | 0.2589 | 0.2593 | 1699824.0 |
| 2002-09-03 09:36:00 | AAPL | Stock | 0.2591 | 0.2591 | 0.2586 | 0.2586 | 836640.0 |
| 2002-09-03 09:37:00 | AAPL | Stock | 0.2588 | 0.2589 | 0.2575 | 0.2575 | 7134400.0 |
| 2002-09-03 09:38:00 | AAPL | Stock | 0.2573 | 0.2575 | 0.257 | 0.2571 | 2542400.0 |
| 2002-09-03 09:39:00 | AAPL | Stock | 0.2573 | 0.2584 | 0.2573 | 0.2584 | 728000.0 |
| 2002-09-03 09:40:00 | AAPL | Stock | 0.2588 | 0.2595 | 0.258 | 0.2593 | 1534400.0 |
| 2002-09-03 09:41:00 | AAPL | Stock | 0.2593 | 0.2598 | 0.258 | 0.2595 | 2738400.0 |
| 2002-09-03 09:42:00 | AAPL | Stock | 0.2595 | 0.2598 | 0.2591 | 0.2591 | 1198400.0 |
| 2002-09-03 09:43:00 | AAPL | Stock | 0.2591 | 0.2591 | 0.2589 | 0.2589 | 1377600.0 |
| 2002-09-03 09:44:00 | AAPL | Stock | 0.2589 | 0.2591 | 0.2588 | 0.2591 | 373240.0 |
| 2002-09-03 09:45:00 | AAPL | Stock | 0.2589 | 0.2591 | 0.2588 | 0.2591 | 263200.0 |
| 2002-09-03 09:46:00 | AAPL | Stock | 0.2588 | 0.2588 | 0.2579 | 0.2579 | 554400.0 |
| 2002-09-03 09:47:00 | AAPL | Stock | 0.2577 | 0.2577 | 0.2573 | 0.2577 | 224000.0 |
| 2002-09-03 09:48:00 | AAPL | Stock | 0.2579 | 0.2579 | 0.2571 | 0.2571 | 1335600.0 |
| 2002-09-03 09:49:00 | AAPL | Stock | 0.2571 | 0.2573 | 0.257 | 0.257 | 963200.0 |
| 2002-09-03 09:50:00 | AAPL | Stock | 0.257 | 0.2571 | 0.257 | 0.257 | 1260000.0 |
| 2002-09-03 09:51:00 | AAPL | Stock | 0.257 | 0.2571 | 0.257 | 0.257 | 470400.0 |
| 2002-09-03 09:52:00 | AAPL | Stock | 0.257 | 0.2571 | 0.257 | 0.257 | 733600.0 |
| 2002-09-03 09:53:00 | AAPL | Stock | 0.2571 | 0.2577 | 0.2571 | 0.2573 | 1148000.0 |
| 2002-09-03 09:54:00 | AAPL | Stock | 0.2573 | 0.2577 | 0.2571 | 0.2573 | 313600.0 |
| 2002-09-03 09:55:00 | AAPL | Stock | 0.2577 | 0.2577 | 0.2573 | 0.2573 | 274400.0 |
| 2002-09-03 09:56:00 | AAPL | Stock | 0.2575 | 0.2577 | 0.2575 | 0.2577 | 301672.0 |
| 2002-09-03 09:57:00 | AAPL | Stock | 0.2573 | 0.2577 | 0.2573 | 0.2577 | 464800.0 |
| 2002-09-03 09:58:00 | AAPL | Stock | 0.2577 | 0.2577 | 0.2575 | 0.2575 | 240800.0 |
| 2002-09-03 09:59:00 | AAPL | Stock | 0.2579 | 0.258 | 0.257 | 0.2571 | 464800.0 |
| 2002-09-03 10:00:00 | AAPL | Stock | 0.257 | 0.2573 | 0.257 | 0.2573 | 16800.0 |
| 2002-09-03 10:01:00 | AAPL | Stock | 0.2575 | 0.2575 | 0.2563 | 0.2564 | 1601600.0 |
| 2002-09-03 10:02:00 | AAPL | Stock | 0.2564 | 0.2575 | 0.2563 | 0.2564 | 1702400.0 |
| 2002-09-03 10:03:00 | AAPL | Stock | 0.2563 | 0.2568 | 0.2563 | 0.2564 | 1954400.0 |
| 2002-09-03 10:04:00 | AAPL | Stock | 0.2563 | 0.257 | 0.2563 | 0.2566 | 386400.0 |
| 2002-09-03 10:05:00 | AAPL | Stock | 0.2566 | 0.2566 | 0.2563 | 0.2563 | 2794008.0 |
| 2002-09-03 10:06:00 | AAPL | Stock | 0.2563 | 0.2566 | 0.2563 | 0.2564 | 457800.0 |
| 2002-09-03 10:07:00 | AAPL | Stock | 0.2564 | 0.2566 | 0.2555 | 0.2563 | 2766400.0 |
> showing 50 of 340,119 rows — these rows as CSV