PREVIEW / stock_5min / 2008-02-01
file: by_date/stock_5min/2008/2008-02-01.parquet size: 4.5 MB rows: 324,934 symbols: 3,260
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-02-01 04:10:00 | AAPL | Stock | 4.8593 | 4.8593 | 4.8561 | 4.8593 | 9128.0 |
| 2008-02-01 04:15:00 | AAPL | Stock | 4.8432 | 4.8432 | 4.8282 | 4.8282 | 28420.0 |
| 2008-02-01 04:55:00 | AAPL | Stock | 4.8568 | 4.8568 | 4.8568 | 4.8568 | 5600.0 |
| 2008-02-01 05:05:00 | AAPL | Stock | 4.8568 | 4.8568 | 4.8568 | 4.8568 | 5180.0 |
| 2008-02-01 05:10:00 | AAPL | Stock | 4.8568 | 4.8593 | 4.8568 | 4.8593 | 33180.0 |
| 2008-02-01 05:15:00 | AAPL | Stock | 4.8593 | 4.8593 | 4.8593 | 4.8593 | 10052.0 |
| 2008-02-01 05:20:00 | AAPL | Stock | 4.8596 | 4.8596 | 4.8593 | 4.8593 | 15148.0 |
| 2008-02-01 05:35:00 | AAPL | Stock | 4.8604 | 4.8611 | 4.8604 | 4.8611 | 8400.0 |
| 2008-02-01 05:55:00 | AAPL | Stock | 4.8611 | 4.8611 | 4.8536 | 4.8536 | 16800.0 |
| 2008-02-01 06:00:00 | AAPL | Stock | 4.8543 | 4.8543 | 4.8536 | 4.8536 | 25200.0 |
| 2008-02-01 06:40:00 | AAPL | Stock | 4.8893 | 4.8932 | 4.8893 | 4.8932 | 51800.0 |
| 2008-02-01 06:50:00 | AAPL | Stock | 4.9089 | 4.9261 | 4.9089 | 4.9168 | 25200.0 |
| 2008-02-01 06:55:00 | AAPL | Stock | 4.9168 | 4.9168 | 4.9089 | 4.9143 | 79240.0 |
| 2008-02-01 07:00:00 | AAPL | Stock | 4.9075 | 4.9107 | 4.9018 | 4.9018 | 154000.0 |
| 2008-02-01 07:05:00 | AAPL | Stock | 4.9018 | 4.9018 | 4.8929 | 4.8964 | 172200.0 |
| 2008-02-01 07:10:00 | AAPL | Stock | 4.8929 | 4.8929 | 4.8843 | 4.8929 | 136920.0 |
| 2008-02-01 07:15:00 | AAPL | Stock | 4.8921 | 4.8921 | 4.8921 | 4.8921 | 56000.0 |
| 2008-02-01 07:20:00 | AAPL | Stock | 4.8893 | 4.8893 | 4.875 | 4.88 | 65800.0 |
| 2008-02-01 07:25:00 | AAPL | Stock | 4.8857 | 4.8857 | 4.8696 | 4.8821 | 140000.0 |
| 2008-02-01 07:30:00 | AAPL | Stock | 4.8804 | 4.8804 | 4.875 | 4.8761 | 28000.0 |
| 2008-02-01 07:35:00 | AAPL | Stock | 4.8889 | 4.8893 | 4.8889 | 4.8893 | 16800.0 |
| 2008-02-01 07:40:00 | AAPL | Stock | 4.8929 | 4.8929 | 4.8821 | 4.8929 | 385700.0 |
| 2008-02-01 07:45:00 | AAPL | Stock | 4.8961 | 4.8961 | 4.8929 | 4.8929 | 195496.0 |
| 2008-02-01 07:50:00 | AAPL | Stock | 4.8929 | 4.8964 | 4.8929 | 4.8946 | 92400.0 |
| 2008-02-01 07:55:00 | AAPL | Stock | 4.8929 | 4.8929 | 4.8929 | 4.8929 | 50400.0 |
| 2008-02-01 08:00:00 | AAPL | Stock | 4.8929 | 4.8968 | 4.8711 | 4.8821 | 656180.0 |
| 2008-02-01 08:05:00 | AAPL | Stock | 4.8804 | 4.8839 | 4.8679 | 4.8839 | 149856.0 |
| 2008-02-01 08:10:00 | AAPL | Stock | 4.8779 | 4.8946 | 4.8779 | 4.8857 | 948976.0 |
| 2008-02-01 08:15:00 | AAPL | Stock | 4.8861 | 4.8925 | 4.8768 | 4.8875 | 312256.0 |
| 2008-02-01 08:20:00 | AAPL | Stock | 4.8907 | 4.9107 | 4.8857 | 4.9018 | 593852.0 |
| 2008-02-01 08:25:00 | AAPL | Stock | 4.9046 | 4.9095 | 4.8343 | 4.9032 | 379708.0 |
| 2008-02-01 08:30:00 | AAPL | Stock | 4.9032 | 4.9036 | 4.8571 | 4.8696 | 2890860.0 |
| 2008-02-01 08:35:00 | AAPL | Stock | 4.8621 | 4.8836 | 4.8475 | 4.8789 | 1649900.0 |
| 2008-02-01 08:40:00 | AAPL | Stock | 4.8789 | 4.8832 | 4.8596 | 4.8596 | 1178380.0 |
| 2008-02-01 08:45:00 | AAPL | Stock | 4.8596 | 4.8721 | 4.8564 | 4.8643 | 794584.0 |
| 2008-02-01 08:50:00 | AAPL | Stock | 4.8693 | 4.8725 | 4.8343 | 4.8725 | 339360.0 |
| 2008-02-01 08:55:00 | AAPL | Stock | 4.8714 | 4.8714 | 4.8643 | 4.8661 | 130760.0 |
| 2008-02-01 09:00:00 | AAPL | Stock | 4.8643 | 4.8643 | 4.8393 | 4.8418 | 592480.0 |
| 2008-02-01 09:05:00 | AAPL | Stock | 4.8425 | 4.8446 | 4.8357 | 4.8386 | 860860.0 |
| 2008-02-01 09:10:00 | AAPL | Stock | 4.8389 | 4.8521 | 4.8379 | 4.8429 | 371280.0 |
| 2008-02-01 09:15:00 | AAPL | Stock | 4.8429 | 4.8529 | 4.8404 | 4.8454 | 213108.0 |
| 2008-02-01 09:20:00 | AAPL | Stock | 4.8457 | 4.8511 | 4.8429 | 4.8457 | 200312.0 |
| 2008-02-01 09:25:00 | AAPL | Stock | 4.8454 | 4.875 | 4.8429 | 4.8671 | 2276708.0 |
| 2008-02-01 09:30:00 | AAPL | Stock | 4.8671 | 4.8732 | 4.8177 | 4.8196 | 32211312.0 |
| 2008-02-01 09:35:00 | AAPL | Stock | 4.8193 | 4.8329 | 4.8 | 4.8257 | 22336916.0 |
| 2008-02-01 09:40:00 | AAPL | Stock | 4.8264 | 4.8393 | 4.8082 | 4.8282 | 20962060.0 |
| 2008-02-01 09:45:00 | AAPL | Stock | 4.8275 | 4.8306 | 4.8079 | 4.8134 | 19590900.0 |
| 2008-02-01 09:50:00 | AAPL | Stock | 4.8132 | 4.8279 | 4.7968 | 4.8018 | 20285720.0 |
| 2008-02-01 09:55:00 | AAPL | Stock | 4.8011 | 4.8304 | 4.8 | 4.8221 | 17982104.0 |
| 2008-02-01 10:00:00 | AAPL | Stock | 4.8214 | 4.8496 | 4.8136 | 4.8429 | 31164364.0 |
> showing 50 of 324,934 rows — these rows as CSV