PREVIEW / stock_5min / 2010-05-24
file: by_date/stock_5min/2010/2010-05-24.parquet size: 4.8 MB rows: 333,013 symbols: 3,444
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-05-24 04:15:00 | AAPL | Stock | 8.6889 | 8.6896 | 8.6889 | 8.6896 | 30800.0 |
| 2010-05-24 05:15:00 | AAPL | Stock | 8.6786 | 8.6786 | 8.6786 | 8.6786 | 2800.0 |
| 2010-05-24 05:25:00 | AAPL | Stock | 8.6429 | 8.6429 | 8.6429 | 8.6429 | 42000.0 |
| 2010-05-24 05:50:00 | AAPL | Stock | 8.6429 | 8.6429 | 8.6429 | 8.6429 | 3612.0 |
| 2010-05-24 06:00:00 | AAPL | Stock | 8.6429 | 8.6429 | 8.6429 | 8.6429 | 30800.0 |
| 2010-05-24 06:15:00 | AAPL | Stock | 8.6164 | 8.6164 | 8.6164 | 8.6164 | 2800.0 |
| 2010-05-24 06:25:00 | AAPL | Stock | 8.6164 | 8.6164 | 8.6164 | 8.6164 | 5600.0 |
| 2010-05-24 06:30:00 | AAPL | Stock | 8.6104 | 8.6107 | 8.6104 | 8.6107 | 8400.0 |
| 2010-05-24 06:35:00 | AAPL | Stock | 8.6107 | 8.6107 | 8.6107 | 8.6107 | 36792.0 |
| 2010-05-24 06:40:00 | AAPL | Stock | 8.6304 | 8.6304 | 8.6004 | 8.6057 | 67144.0 |
| 2010-05-24 06:45:00 | AAPL | Stock | 8.5986 | 8.5986 | 8.5986 | 8.5986 | 5600.0 |
| 2010-05-24 06:50:00 | AAPL | Stock | 8.5986 | 8.5986 | 8.5986 | 8.5986 | 8400.0 |
| 2010-05-24 07:00:00 | AAPL | Stock | 8.5807 | 8.595 | 8.5807 | 8.5907 | 46900.0 |
| 2010-05-24 07:05:00 | AAPL | Stock | 8.5911 | 8.5989 | 8.5821 | 8.5986 | 125020.0 |
| 2010-05-24 07:10:00 | AAPL | Stock | 8.6 | 8.6154 | 8.5982 | 8.6107 | 141820.0 |
| 2010-05-24 07:15:00 | AAPL | Stock | 8.6132 | 8.6146 | 8.6064 | 8.6068 | 139300.0 |
| 2010-05-24 07:25:00 | AAPL | Stock | 8.6211 | 8.6429 | 8.6096 | 8.64 | 180656.0 |
| 2010-05-24 07:30:00 | AAPL | Stock | 8.64 | 8.6536 | 8.64 | 8.6464 | 41300.0 |
| 2010-05-24 07:35:00 | AAPL | Stock | 8.6464 | 8.6786 | 8.6429 | 8.6675 | 276808.0 |
| 2010-05-24 07:40:00 | AAPL | Stock | 8.6743 | 8.7043 | 8.6675 | 8.7043 | 322476.0 |
| 2010-05-24 07:45:00 | AAPL | Stock | 8.7036 | 8.7036 | 8.6857 | 8.6861 | 89572.0 |
| 2010-05-24 07:50:00 | AAPL | Stock | 8.6857 | 8.6971 | 8.6786 | 8.6971 | 126672.0 |
| 2010-05-24 07:55:00 | AAPL | Stock | 8.6964 | 8.7043 | 8.6914 | 8.6914 | 124152.0 |
| 2010-05-24 08:00:00 | AAPL | Stock | 8.6843 | 8.6889 | 8.6632 | 8.6711 | 541380.0 |
| 2010-05-24 08:05:00 | AAPL | Stock | 8.6711 | 8.7054 | 8.6682 | 8.7032 | 843192.0 |
| 2010-05-24 08:10:00 | AAPL | Stock | 8.7032 | 8.7239 | 8.7032 | 8.7143 | 652260.0 |
| 2010-05-24 08:15:00 | AAPL | Stock | 8.7127 | 8.7127 | 8.6786 | 8.6871 | 418012.0 |
| 2010-05-24 08:20:00 | AAPL | Stock | 8.6907 | 8.7025 | 8.6907 | 8.6964 | 232260.0 |
| 2010-05-24 08:25:00 | AAPL | Stock | 8.6943 | 8.6968 | 8.6839 | 8.6925 | 297276.0 |
| 2010-05-24 08:30:00 | AAPL | Stock | 8.69 | 8.7214 | 8.6868 | 8.7143 | 628740.0 |
| 2010-05-24 08:35:00 | AAPL | Stock | 8.7107 | 8.7179 | 8.7054 | 8.7143 | 274400.0 |
| 2010-05-24 08:40:00 | AAPL | Stock | 8.7104 | 8.7425 | 8.7071 | 8.7425 | 938532.0 |
| 2010-05-24 08:45:00 | AAPL | Stock | 8.7411 | 8.7961 | 8.74 | 8.7943 | 1538964.0 |
| 2010-05-24 08:50:00 | AAPL | Stock | 8.7946 | 8.8018 | 8.7804 | 8.7971 | 852180.0 |
| 2010-05-24 08:55:00 | AAPL | Stock | 8.7982 | 8.8264 | 8.7929 | 8.8071 | 1362844.0 |
| 2010-05-24 09:00:00 | AAPL | Stock | 8.8093 | 8.8368 | 8.8036 | 8.8364 | 720356.0 |
| 2010-05-24 09:05:00 | AAPL | Stock | 8.8343 | 8.8654 | 8.8311 | 8.8436 | 2221660.0 |
| 2010-05-24 09:10:00 | AAPL | Stock | 8.8473 | 8.8568 | 8.8307 | 8.8357 | 1459164.0 |
| 2010-05-24 09:15:00 | AAPL | Stock | 8.8354 | 8.8386 | 8.8146 | 8.8179 | 591584.0 |
| 2010-05-24 09:20:00 | AAPL | Stock | 8.8179 | 8.8279 | 8.8146 | 8.8211 | 458556.0 |
| 2010-05-24 09:25:00 | AAPL | Stock | 8.8207 | 8.8325 | 8.8179 | 8.8304 | 779940.0 |
| 2010-05-24 09:30:00 | AAPL | Stock | 8.8275 | 8.9107 | 8.8189 | 8.8779 | 34624912.0 |
| 2010-05-24 09:35:00 | AAPL | Stock | 8.8789 | 8.9035 | 8.8593 | 8.863 | 20554072.0 |
| 2010-05-24 09:40:00 | AAPL | Stock | 8.863 | 8.8736 | 8.8014 | 8.8061 | 29679104.0 |
| 2010-05-24 09:45:00 | AAPL | Stock | 8.8091 | 8.8446 | 8.795 | 8.8354 | 21588448.0 |
| 2010-05-24 09:50:00 | AAPL | Stock | 8.8364 | 8.8685 | 8.8271 | 8.8554 | 16407748.0 |
| 2010-05-24 09:55:00 | AAPL | Stock | 8.8554 | 8.8743 | 8.8414 | 8.865 | 14516180.0 |
| 2010-05-24 10:00:00 | AAPL | Stock | 8.8671 | 8.8855 | 8.8393 | 8.8404 | 20830880.0 |
| 2010-05-24 10:05:00 | AAPL | Stock | 8.8425 | 8.8982 | 8.84 | 8.8875 | 15252692.0 |
| 2010-05-24 10:10:00 | AAPL | Stock | 8.8868 | 8.9032 | 8.8768 | 8.9032 | 12328736.0 |
> showing 50 of 333,013 rows — these rows as CSV