PREVIEW / stock_5min / 2010-02-01
file: by_date/stock_5min/2010/2010-02-01.parquet size: 4.7 MB rows: 325,544 symbols: 3,445
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 |
|---|---|---|---|---|---|---|---|
| 2010-02-01 04:15:00 | AAPL | Stock | 6.8718 | 6.8921 | 6.8718 | 6.8918 | 8400.0 |
| 2010-02-01 04:20:00 | AAPL | Stock | 6.9004 | 6.9004 | 6.9004 | 6.9004 | 5600.0 |
| 2010-02-01 04:25:00 | AAPL | Stock | 6.9007 | 6.9007 | 6.9007 | 6.9007 | 2800.0 |
| 2010-02-01 04:50:00 | AAPL | Stock | 6.8932 | 6.8932 | 6.8932 | 6.8932 | 2800.0 |
| 2010-02-01 05:35:00 | AAPL | Stock | 6.9004 | 6.9004 | 6.9004 | 6.9004 | 2800.0 |
| 2010-02-01 05:40:00 | AAPL | Stock | 6.8939 | 6.8939 | 6.8939 | 6.8939 | 2800.0 |
| 2010-02-01 05:45:00 | AAPL | Stock | 6.8986 | 6.8986 | 6.8986 | 6.8986 | 28000.0 |
| 2010-02-01 05:55:00 | AAPL | Stock | 6.9082 | 6.9082 | 6.9082 | 6.9082 | 2800.0 |
| 2010-02-01 06:00:00 | AAPL | Stock | 6.9107 | 6.9107 | 6.9107 | 6.9107 | 16800.0 |
| 2010-02-01 06:10:00 | AAPL | Stock | 6.9007 | 6.9007 | 6.9007 | 6.9007 | 5600.0 |
| 2010-02-01 06:15:00 | AAPL | Stock | 6.9107 | 6.9107 | 6.9107 | 6.9107 | 2800.0 |
| 2010-02-01 06:20:00 | AAPL | Stock | 6.9107 | 6.9107 | 6.9107 | 6.9107 | 2800.0 |
| 2010-02-01 06:25:00 | AAPL | Stock | 6.9036 | 6.9036 | 6.9036 | 6.9036 | 5040.0 |
| 2010-02-01 06:30:00 | AAPL | Stock | 6.9096 | 6.9096 | 6.9096 | 6.9096 | 5600.0 |
| 2010-02-01 06:55:00 | AAPL | Stock | 6.9096 | 6.9096 | 6.9096 | 6.9096 | 2800.0 |
| 2010-02-01 07:00:00 | AAPL | Stock | 6.9054 | 6.9054 | 6.9054 | 6.9054 | 6300.0 |
| 2010-02-01 07:05:00 | AAPL | Stock | 6.8929 | 6.8932 | 6.8843 | 6.8843 | 129416.0 |
| 2010-02-01 07:10:00 | AAPL | Stock | 6.9082 | 6.9082 | 6.8929 | 6.8982 | 25900.0 |
| 2010-02-01 07:20:00 | AAPL | Stock | 6.8964 | 6.8964 | 6.8964 | 6.8964 | 2800.0 |
| 2010-02-01 07:25:00 | AAPL | Stock | 6.8964 | 6.8964 | 6.8839 | 6.8839 | 12040.0 |
| 2010-02-01 07:30:00 | AAPL | Stock | 6.8861 | 6.8925 | 6.8782 | 6.8925 | 51296.0 |
| 2010-02-01 07:35:00 | AAPL | Stock | 6.8979 | 6.8979 | 6.8825 | 6.8825 | 17248.0 |
| 2010-02-01 07:40:00 | AAPL | Stock | 6.8825 | 6.8825 | 6.875 | 6.8789 | 88900.0 |
| 2010-02-01 07:45:00 | AAPL | Stock | 6.8804 | 6.8804 | 6.8664 | 6.8664 | 59248.0 |
| 2010-02-01 07:50:00 | AAPL | Stock | 6.8675 | 6.8714 | 6.8675 | 6.8714 | 8400.0 |
| 2010-02-01 07:55:00 | AAPL | Stock | 6.8821 | 6.8929 | 6.8821 | 6.8918 | 283528.0 |
| 2010-02-01 08:00:00 | AAPL | Stock | 6.8761 | 6.8886 | 6.8714 | 6.8832 | 615384.0 |
| 2010-02-01 08:05:00 | AAPL | Stock | 6.8857 | 6.8868 | 6.8782 | 6.8839 | 230860.0 |
| 2010-02-01 08:10:00 | AAPL | Stock | 6.8857 | 6.8886 | 6.8768 | 6.8768 | 354004.0 |
| 2010-02-01 08:15:00 | AAPL | Stock | 6.8786 | 6.8807 | 6.8464 | 6.8489 | 609392.0 |
| 2010-02-01 08:20:00 | AAPL | Stock | 6.8568 | 6.8571 | 6.8407 | 6.8475 | 300860.0 |
| 2010-02-01 08:25:00 | AAPL | Stock | 6.8475 | 6.8486 | 6.8361 | 6.8454 | 592424.0 |
| 2010-02-01 08:30:00 | AAPL | Stock | 6.8457 | 6.8661 | 6.8454 | 6.8629 | 362880.0 |
| 2010-02-01 08:35:00 | AAPL | Stock | 6.8643 | 6.8675 | 6.8586 | 6.8589 | 442876.0 |
| 2010-02-01 08:40:00 | AAPL | Stock | 6.8621 | 6.8621 | 6.8571 | 6.8571 | 423948.0 |
| 2010-02-01 08:45:00 | AAPL | Stock | 6.8571 | 6.8643 | 6.8568 | 6.8571 | 176288.0 |
| 2010-02-01 08:50:00 | AAPL | Stock | 6.8571 | 6.8575 | 6.8425 | 6.8446 | 409248.0 |
| 2010-02-01 08:55:00 | AAPL | Stock | 6.8429 | 6.8464 | 6.8393 | 6.8396 | 281848.0 |
| 2010-02-01 09:00:00 | AAPL | Stock | 6.8404 | 6.8504 | 6.8404 | 6.8504 | 155372.0 |
| 2010-02-01 09:05:00 | AAPL | Stock | 6.8486 | 6.8489 | 6.8386 | 6.8411 | 180600.0 |
| 2010-02-01 09:10:00 | AAPL | Stock | 6.8446 | 6.8461 | 6.8357 | 6.8393 | 186760.0 |
| 2010-02-01 09:15:00 | AAPL | Stock | 6.8418 | 6.8532 | 6.8418 | 6.85 | 190232.0 |
| 2010-02-01 09:20:00 | AAPL | Stock | 6.8475 | 6.8657 | 6.8464 | 6.8625 | 721700.0 |
| 2010-02-01 09:25:00 | AAPL | Stock | 6.8625 | 6.8768 | 6.8568 | 6.8732 | 887572.0 |
| 2010-02-01 09:30:00 | AAPL | Stock | 6.8707 | 6.8929 | 6.8321 | 6.8686 | 28392420.0 |
| 2010-02-01 09:35:00 | AAPL | Stock | 6.8682 | 6.9336 | 6.8654 | 6.9268 | 24671388.0 |
| 2010-02-01 09:40:00 | AAPL | Stock | 6.9268 | 6.955 | 6.9129 | 6.9343 | 24193092.0 |
| 2010-02-01 09:45:00 | AAPL | Stock | 6.9343 | 6.9846 | 6.9239 | 6.9763 | 22467872.0 |
| 2010-02-01 09:50:00 | AAPL | Stock | 6.9761 | 7.0 | 6.9475 | 6.9534 | 26865524.0 |
| 2010-02-01 09:55:00 | AAPL | Stock | 6.9534 | 6.9629 | 6.9314 | 6.9354 | 16083928.0 |
> showing 50 of 325,544 rows — these rows as CSV