PREVIEW / stock_5min / 2007-12-14
file: by_date/stock_5min/2007/2007-12-14.parquet size: 4.3 MB rows: 315,075 symbols: 3,230
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 |
|---|---|---|---|---|---|---|---|
| 2007-12-14 06:10:00 | AAPL | Stock | 6.8643 | 6.8643 | 6.8643 | 6.8643 | 2800.0 |
| 2007-12-14 06:15:00 | AAPL | Stock | 6.8361 | 6.8361 | 6.8361 | 6.8361 | 5600.0 |
| 2007-12-14 06:40:00 | AAPL | Stock | 6.8371 | 6.8371 | 6.8371 | 6.8371 | 14000.0 |
| 2007-12-14 06:45:00 | AAPL | Stock | 6.8368 | 6.8368 | 6.8368 | 6.8368 | 8400.0 |
| 2007-12-14 06:50:00 | AAPL | Stock | 6.8368 | 6.8368 | 6.8368 | 6.8368 | 8400.0 |
| 2007-12-14 06:55:00 | AAPL | Stock | 6.8368 | 6.8475 | 6.8368 | 6.8368 | 28000.0 |
| 2007-12-14 07:00:00 | AAPL | Stock | 6.8368 | 6.8368 | 6.8368 | 6.8368 | 8400.0 |
| 2007-12-14 07:15:00 | AAPL | Stock | 6.8214 | 6.8214 | 6.8214 | 6.8214 | 8400.0 |
| 2007-12-14 07:25:00 | AAPL | Stock | 6.8304 | 6.8304 | 6.8229 | 6.8229 | 8400.0 |
| 2007-12-14 07:35:00 | AAPL | Stock | 6.8304 | 6.8304 | 6.8304 | 6.8304 | 2800.0 |
| 2007-12-14 07:40:00 | AAPL | Stock | 6.8364 | 6.8482 | 6.8364 | 6.8482 | 30800.0 |
| 2007-12-14 07:45:00 | AAPL | Stock | 6.8371 | 6.8464 | 6.8371 | 6.8464 | 16800.0 |
| 2007-12-14 07:55:00 | AAPL | Stock | 6.8321 | 6.8389 | 6.8321 | 6.8371 | 61600.0 |
| 2007-12-14 08:00:00 | AAPL | Stock | 6.8446 | 6.8554 | 6.8311 | 6.8318 | 282072.0 |
| 2007-12-14 08:05:00 | AAPL | Stock | 6.8318 | 6.8321 | 6.8232 | 6.8275 | 266000.0 |
| 2007-12-14 08:10:00 | AAPL | Stock | 6.8275 | 6.8343 | 6.8254 | 6.8336 | 98896.0 |
| 2007-12-14 08:15:00 | AAPL | Stock | 6.8357 | 6.8357 | 6.8304 | 6.8304 | 32144.0 |
| 2007-12-14 08:20:00 | AAPL | Stock | 6.8318 | 6.85 | 6.8318 | 6.8486 | 193200.0 |
| 2007-12-14 08:25:00 | AAPL | Stock | 6.8457 | 6.8482 | 6.8268 | 6.8318 | 372904.0 |
| 2007-12-14 08:30:00 | AAPL | Stock | 6.8296 | 6.8296 | 6.7946 | 6.8157 | 1044288.0 |
| 2007-12-14 08:35:00 | AAPL | Stock | 6.8161 | 6.8264 | 6.8036 | 6.8036 | 497504.0 |
| 2007-12-14 08:40:00 | AAPL | Stock | 6.8036 | 6.8182 | 6.8018 | 6.8179 | 177688.0 |
| 2007-12-14 08:45:00 | AAPL | Stock | 6.8107 | 6.8125 | 6.8036 | 6.8096 | 175728.0 |
| 2007-12-14 08:50:00 | AAPL | Stock | 6.8118 | 6.8125 | 6.8089 | 6.8107 | 107800.0 |
| 2007-12-14 08:55:00 | AAPL | Stock | 6.8107 | 6.8107 | 6.8086 | 6.8089 | 101220.0 |
| 2007-12-14 09:00:00 | AAPL | Stock | 6.8089 | 6.8089 | 6.8036 | 6.8036 | 143192.0 |
| 2007-12-14 09:05:00 | AAPL | Stock | 6.8036 | 6.8039 | 6.7968 | 6.7989 | 353556.0 |
| 2007-12-14 09:10:00 | AAPL | Stock | 6.7996 | 6.7996 | 6.7929 | 6.7943 | 211036.0 |
| 2007-12-14 09:15:00 | AAPL | Stock | 6.7964 | 6.8014 | 6.7893 | 6.8014 | 283836.0 |
| 2007-12-14 09:20:00 | AAPL | Stock | 6.8014 | 6.8018 | 6.7911 | 6.7929 | 394996.0 |
| 2007-12-14 09:25:00 | AAPL | Stock | 6.7904 | 6.8043 | 6.7904 | 6.7986 | 659092.0 |
| 2007-12-14 09:30:00 | AAPL | Stock | 6.7975 | 6.8154 | 6.7775 | 6.8111 | 22526112.0 |
| 2007-12-14 09:35:00 | AAPL | Stock | 6.8107 | 6.8139 | 6.7693 | 6.7793 | 19268452.0 |
| 2007-12-14 09:40:00 | AAPL | Stock | 6.7789 | 6.7943 | 6.775 | 6.7904 | 12984412.0 |
| 2007-12-14 09:45:00 | AAPL | Stock | 6.7907 | 6.8407 | 6.7864 | 6.8329 | 20838748.0 |
| 2007-12-14 09:50:00 | AAPL | Stock | 6.8321 | 6.8357 | 6.8 | 6.8 | 15309504.0 |
| 2007-12-14 09:55:00 | AAPL | Stock | 6.8 | 6.8282 | 6.795 | 6.8164 | 10559808.0 |
| 2007-12-14 10:00:00 | AAPL | Stock | 6.8161 | 6.8318 | 6.8089 | 6.8161 | 9538704.0 |
| 2007-12-14 10:05:00 | AAPL | Stock | 6.8164 | 6.825 | 6.8 | 6.8071 | 9945656.0 |
| 2007-12-14 10:10:00 | AAPL | Stock | 6.8068 | 6.8171 | 6.7971 | 6.8007 | 10232824.0 |
| 2007-12-14 10:15:00 | AAPL | Stock | 6.8007 | 6.8275 | 6.7968 | 6.8236 | 12584936.0 |
| 2007-12-14 10:20:00 | AAPL | Stock | 6.8232 | 6.8264 | 6.8143 | 6.8189 | 8489880.0 |
| 2007-12-14 10:25:00 | AAPL | Stock | 6.8182 | 6.8346 | 6.8139 | 6.8232 | 9830968.0 |
| 2007-12-14 10:30:00 | AAPL | Stock | 6.8236 | 6.8243 | 6.8057 | 6.8211 | 8438024.0 |
| 2007-12-14 10:35:00 | AAPL | Stock | 6.8207 | 6.8411 | 6.8164 | 6.8407 | 9972424.0 |
| 2007-12-14 10:40:00 | AAPL | Stock | 6.8411 | 6.8746 | 6.84 | 6.8639 | 21522340.0 |
| 2007-12-14 10:45:00 | AAPL | Stock | 6.8629 | 6.8911 | 6.8518 | 6.8907 | 14637980.0 |
| 2007-12-14 10:50:00 | AAPL | Stock | 6.8904 | 6.9 | 6.8886 | 6.89 | 16732660.0 |
| 2007-12-14 10:55:00 | AAPL | Stock | 6.89 | 6.8982 | 6.8779 | 6.8964 | 9654876.0 |
| 2007-12-14 11:00:00 | AAPL | Stock | 6.8964 | 6.8971 | 6.8825 | 6.8893 | 9978500.0 |
> showing 50 of 315,075 rows — these rows as CSV