PREVIEW / stock_5min / 2009-03-27
file: by_date/stock_5min/2009/2009-03-27.parquet size: 4.4 MB rows: 304,574 symbols: 3,310
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-03-27 07:20:00 | AAPL | Stock | 3.8714 | 3.8714 | 3.8714 | 3.8714 | 12068.0 |
| 2009-03-27 07:30:00 | AAPL | Stock | 3.8714 | 3.8714 | 3.8714 | 3.8714 | 5600.0 |
| 2009-03-27 07:35:00 | AAPL | Stock | 3.8786 | 3.8786 | 3.8786 | 3.8786 | 14000.0 |
| 2009-03-27 07:40:00 | AAPL | Stock | 3.8889 | 3.8889 | 3.8889 | 3.8889 | 2800.0 |
| 2009-03-27 07:45:00 | AAPL | Stock | 3.8839 | 3.8875 | 3.8839 | 3.8839 | 32760.0 |
| 2009-03-27 07:50:00 | AAPL | Stock | 3.8839 | 3.8839 | 3.8839 | 3.8839 | 11200.0 |
| 2009-03-27 07:55:00 | AAPL | Stock | 3.8761 | 3.8761 | 3.8754 | 3.8754 | 5600.0 |
| 2009-03-27 08:00:00 | AAPL | Stock | 3.8811 | 3.8893 | 3.8793 | 3.8793 | 56420.0 |
| 2009-03-27 08:05:00 | AAPL | Stock | 3.8911 | 3.8911 | 3.8821 | 3.8821 | 74200.0 |
| 2009-03-27 08:10:00 | AAPL | Stock | 3.8821 | 3.8825 | 3.875 | 3.875 | 163464.0 |
| 2009-03-27 08:15:00 | AAPL | Stock | 3.8761 | 3.8786 | 3.8689 | 3.875 | 35056.0 |
| 2009-03-27 08:20:00 | AAPL | Stock | 3.8693 | 3.87 | 3.8689 | 3.8689 | 18200.0 |
| 2009-03-27 08:25:00 | AAPL | Stock | 3.8711 | 3.8789 | 3.8704 | 3.8789 | 46200.0 |
| 2009-03-27 08:30:00 | AAPL | Stock | 3.8882 | 3.8893 | 3.885 | 3.885 | 18200.0 |
| 2009-03-27 08:35:00 | AAPL | Stock | 3.8807 | 3.8811 | 3.8721 | 3.875 | 123676.0 |
| 2009-03-27 08:40:00 | AAPL | Stock | 3.8789 | 3.8789 | 3.8696 | 3.8714 | 179536.0 |
| 2009-03-27 08:45:00 | AAPL | Stock | 3.8729 | 3.8732 | 3.8696 | 3.8696 | 171920.0 |
| 2009-03-27 08:50:00 | AAPL | Stock | 3.8696 | 3.875 | 3.8689 | 3.875 | 169568.0 |
| 2009-03-27 08:55:00 | AAPL | Stock | 3.875 | 3.8804 | 3.875 | 3.8804 | 7000.0 |
| 2009-03-27 09:00:00 | AAPL | Stock | 3.8775 | 3.8943 | 3.8711 | 3.8943 | 207844.0 |
| 2009-03-27 09:05:00 | AAPL | Stock | 3.8929 | 3.8929 | 3.8814 | 3.8832 | 123844.0 |
| 2009-03-27 09:10:00 | AAPL | Stock | 3.8793 | 3.8793 | 3.8736 | 3.8736 | 82964.0 |
| 2009-03-27 09:15:00 | AAPL | Stock | 3.8736 | 3.875 | 3.8718 | 3.875 | 153720.0 |
| 2009-03-27 09:20:00 | AAPL | Stock | 3.875 | 3.8779 | 3.875 | 3.8779 | 61880.0 |
| 2009-03-27 09:25:00 | AAPL | Stock | 3.8786 | 3.8786 | 3.8618 | 3.8654 | 559916.0 |
| 2009-03-27 09:30:00 | AAPL | Stock | 3.8675 | 3.8761 | 3.8589 | 3.8736 | 18631900.0 |
| 2009-03-27 09:35:00 | AAPL | Stock | 3.8736 | 3.875 | 3.8289 | 3.8571 | 16696428.0 |
| 2009-03-27 09:40:00 | AAPL | Stock | 3.8572 | 3.8661 | 3.8543 | 3.8657 | 11902408.0 |
| 2009-03-27 09:45:00 | AAPL | Stock | 3.8657 | 3.8711 | 3.8564 | 3.8571 | 7792232.0 |
| 2009-03-27 09:50:00 | AAPL | Stock | 3.8571 | 3.8582 | 3.8461 | 3.855 | 9908556.0 |
| 2009-03-27 09:55:00 | AAPL | Stock | 3.8554 | 3.8575 | 3.8361 | 3.8414 | 9396492.0 |
| 2009-03-27 10:00:00 | AAPL | Stock | 3.8421 | 3.8482 | 3.8361 | 3.8375 | 7924644.0 |
| 2009-03-27 10:05:00 | AAPL | Stock | 3.8379 | 3.8382 | 3.8193 | 3.8229 | 12881344.0 |
| 2009-03-27 10:10:00 | AAPL | Stock | 3.8229 | 3.8321 | 3.82 | 3.8275 | 7811300.0 |
| 2009-03-27 10:15:00 | AAPL | Stock | 3.8282 | 3.8318 | 3.8171 | 3.8257 | 7920052.0 |
| 2009-03-27 10:20:00 | AAPL | Stock | 3.8254 | 3.8429 | 3.8214 | 3.8411 | 9274944.0 |
| 2009-03-27 10:25:00 | AAPL | Stock | 3.8407 | 3.8432 | 3.8279 | 3.8307 | 6173832.0 |
| 2009-03-27 10:30:00 | AAPL | Stock | 3.8318 | 3.8382 | 3.8221 | 3.8382 | 6203680.0 |
| 2009-03-27 10:35:00 | AAPL | Stock | 3.8382 | 3.8454 | 3.8321 | 3.8368 | 7316260.0 |
| 2009-03-27 10:40:00 | AAPL | Stock | 3.8371 | 3.8421 | 3.8332 | 3.8404 | 4307660.0 |
| 2009-03-27 10:45:00 | AAPL | Stock | 3.8401 | 3.8461 | 3.8371 | 3.8375 | 5743836.0 |
| 2009-03-27 10:50:00 | AAPL | Stock | 3.8371 | 3.8443 | 3.8354 | 3.8406 | 5251708.0 |
| 2009-03-27 10:55:00 | AAPL | Stock | 3.8382 | 3.8421 | 3.8364 | 3.8375 | 4780552.0 |
| 2009-03-27 11:00:00 | AAPL | Stock | 3.8375 | 3.8382 | 3.8182 | 3.825 | 9535708.0 |
| 2009-03-27 11:05:00 | AAPL | Stock | 3.8254 | 3.8325 | 3.8254 | 3.8307 | 5513256.0 |
| 2009-03-27 11:10:00 | AAPL | Stock | 3.83 | 3.8411 | 3.8218 | 3.8393 | 6520668.0 |
| 2009-03-27 11:15:00 | AAPL | Stock | 3.8393 | 3.8446 | 3.8368 | 3.8396 | 5188484.0 |
| 2009-03-27 11:20:00 | AAPL | Stock | 3.8396 | 3.8532 | 3.8375 | 3.8525 | 6314392.0 |
| 2009-03-27 11:25:00 | AAPL | Stock | 3.8523 | 3.8621 | 3.8454 | 3.8479 | 10298736.0 |
| 2009-03-27 11:30:00 | AAPL | Stock | 3.8479 | 3.8494 | 3.8382 | 3.8429 | 4603760.0 |
> showing 50 of 304,574 rows — these rows as CSV