PREVIEW / stock_5min / 2008-02-04
file: by_date/stock_5min/2008/2008-02-04.parquet size: 4.4 MB rows: 320,008 symbols: 3,240
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-04 04:20:00 | AAPL | Stock | 4.7857 | 4.7857 | 4.7857 | 4.7857 | 7000.0 |
| 2008-02-04 06:15:00 | AAPL | Stock | 4.7825 | 4.7825 | 4.7825 | 4.7825 | 2800.0 |
| 2008-02-04 06:20:00 | AAPL | Stock | 4.7804 | 4.7804 | 4.7804 | 4.7804 | 14000.0 |
| 2008-02-04 06:35:00 | AAPL | Stock | 4.8032 | 4.8032 | 4.8032 | 4.8032 | 13636.0 |
| 2008-02-04 07:00:00 | AAPL | Stock | 4.7921 | 4.8182 | 4.7829 | 4.8182 | 71764.0 |
| 2008-02-04 07:05:00 | AAPL | Stock | 4.8089 | 4.8089 | 4.8089 | 4.8089 | 5600.0 |
| 2008-02-04 07:30:00 | AAPL | Stock | 4.7957 | 4.8089 | 4.7954 | 4.7954 | 39116.0 |
| 2008-02-04 07:45:00 | AAPL | Stock | 4.8036 | 4.8036 | 4.8007 | 4.8007 | 19600.0 |
| 2008-02-04 07:50:00 | AAPL | Stock | 4.8025 | 4.8036 | 4.8025 | 4.8036 | 16800.0 |
| 2008-02-04 07:55:00 | AAPL | Stock | 4.8 | 4.8 | 4.7982 | 4.8 | 28000.0 |
| 2008-02-04 08:00:00 | AAPL | Stock | 4.7961 | 4.8054 | 4.7861 | 4.7893 | 227248.0 |
| 2008-02-04 08:05:00 | AAPL | Stock | 4.7943 | 4.7982 | 4.7943 | 4.7982 | 58800.0 |
| 2008-02-04 08:10:00 | AAPL | Stock | 4.8011 | 4.8018 | 4.7893 | 4.7918 | 180600.0 |
| 2008-02-04 08:15:00 | AAPL | Stock | 4.7918 | 4.7921 | 4.7893 | 4.7893 | 102200.0 |
| 2008-02-04 08:20:00 | AAPL | Stock | 4.7911 | 4.7911 | 4.7786 | 4.7786 | 306348.0 |
| 2008-02-04 08:25:00 | AAPL | Stock | 4.7796 | 4.7832 | 4.7768 | 4.7768 | 106148.0 |
| 2008-02-04 08:30:00 | AAPL | Stock | 4.7771 | 4.7857 | 4.7768 | 4.7857 | 60004.0 |
| 2008-02-04 08:35:00 | AAPL | Stock | 4.7857 | 4.7857 | 4.7821 | 4.7825 | 22400.0 |
| 2008-02-04 08:40:00 | AAPL | Stock | 4.7861 | 4.7861 | 4.7771 | 4.7814 | 62552.0 |
| 2008-02-04 08:45:00 | AAPL | Stock | 4.7771 | 4.7904 | 4.7771 | 4.7857 | 165676.0 |
| 2008-02-04 08:50:00 | AAPL | Stock | 4.7807 | 4.7861 | 4.7789 | 4.7861 | 25200.0 |
| 2008-02-04 08:55:00 | AAPL | Stock | 4.7893 | 4.7893 | 4.7893 | 4.7893 | 2800.0 |
| 2008-02-04 09:00:00 | AAPL | Stock | 4.7857 | 4.7886 | 4.785 | 4.785 | 111720.0 |
| 2008-02-04 09:05:00 | AAPL | Stock | 4.785 | 4.785 | 4.7768 | 4.7825 | 51604.0 |
| 2008-02-04 09:10:00 | AAPL | Stock | 4.785 | 4.7979 | 4.7821 | 4.7979 | 96040.0 |
| 2008-02-04 09:15:00 | AAPL | Stock | 4.7968 | 4.7982 | 4.7889 | 4.7893 | 94640.0 |
| 2008-02-04 09:20:00 | AAPL | Stock | 4.7918 | 4.7918 | 4.7875 | 4.7875 | 47600.0 |
| 2008-02-04 09:25:00 | AAPL | Stock | 4.7875 | 4.7939 | 4.7782 | 4.7939 | 1085868.0 |
| 2008-02-04 09:30:00 | AAPL | Stock | 4.7939 | 4.815 | 4.7789 | 4.8146 | 24285716.0 |
| 2008-02-04 09:35:00 | AAPL | Stock | 4.815 | 4.835 | 4.8093 | 4.8171 | 19633684.0 |
| 2008-02-04 09:40:00 | AAPL | Stock | 4.8168 | 4.8393 | 4.7936 | 4.8289 | 25721668.0 |
| 2008-02-04 09:45:00 | AAPL | Stock | 4.8293 | 4.8411 | 4.8054 | 4.8132 | 21848736.0 |
| 2008-02-04 09:50:00 | AAPL | Stock | 4.8121 | 4.8532 | 4.8107 | 4.8496 | 20903904.0 |
| 2008-02-04 09:55:00 | AAPL | Stock | 4.85 | 4.8507 | 4.8339 | 4.8407 | 17566808.0 |
| 2008-02-04 10:00:00 | AAPL | Stock | 4.84 | 4.8536 | 4.8243 | 4.8332 | 16506616.0 |
| 2008-02-04 10:05:00 | AAPL | Stock | 4.8321 | 4.835 | 4.8143 | 4.8225 | 12737844.0 |
| 2008-02-04 10:10:00 | AAPL | Stock | 4.8228 | 4.8425 | 4.8211 | 4.8254 | 14218008.0 |
| 2008-02-04 10:15:00 | AAPL | Stock | 4.825 | 4.8421 | 4.8229 | 4.8332 | 11418036.0 |
| 2008-02-04 10:20:00 | AAPL | Stock | 4.8339 | 4.8404 | 4.8211 | 4.8296 | 13105456.0 |
| 2008-02-04 10:25:00 | AAPL | Stock | 4.8307 | 4.8339 | 4.8168 | 4.8222 | 11530008.0 |
| 2008-02-04 10:30:00 | AAPL | Stock | 4.8229 | 4.8268 | 4.81 | 4.8207 | 13752564.0 |
| 2008-02-04 10:35:00 | AAPL | Stock | 4.8196 | 4.8268 | 4.8082 | 4.8186 | 11792704.0 |
| 2008-02-04 10:40:00 | AAPL | Stock | 4.8176 | 4.8364 | 4.8146 | 4.8346 | 7805392.0 |
| 2008-02-04 10:45:00 | AAPL | Stock | 4.8339 | 4.8375 | 4.8261 | 4.8321 | 8944404.0 |
| 2008-02-04 10:50:00 | AAPL | Stock | 4.8324 | 4.8393 | 4.8257 | 4.8382 | 9647344.0 |
| 2008-02-04 10:55:00 | AAPL | Stock | 4.8379 | 4.8393 | 4.8293 | 4.8343 | 8735020.0 |
| 2008-02-04 11:00:00 | AAPL | Stock | 4.8343 | 4.8482 | 4.8304 | 4.8346 | 10747604.0 |
| 2008-02-04 11:05:00 | AAPL | Stock | 4.8346 | 4.8354 | 4.8225 | 4.8279 | 8628480.0 |
| 2008-02-04 11:10:00 | AAPL | Stock | 4.8286 | 4.8336 | 4.8221 | 4.8314 | 6400464.0 |
| 2008-02-04 11:15:00 | AAPL | Stock | 4.8325 | 4.8421 | 4.8311 | 4.8386 | 8179024.0 |
> showing 50 of 320,008 rows — these rows as CSV