PREVIEW / stock_5min / 2007-02-07
file: by_date/stock_5min/2007/2007-02-07.parquet size: 3.4 MB rows: 245,605 symbols: 2,517
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-02-07 07:45:00 | AAPL | Stock | 3.0143 | 3.0143 | 3.0143 | 3.0143 | 2800.0 |
| 2007-02-07 07:55:00 | AAPL | Stock | 3.0121 | 3.0121 | 3.0107 | 3.0107 | 5600.0 |
| 2007-02-07 08:00:00 | AAPL | Stock | 3.0129 | 3.0161 | 3.0107 | 3.0143 | 322812.0 |
| 2007-02-07 08:05:00 | AAPL | Stock | 3.0143 | 3.0168 | 3.0139 | 3.0168 | 359268.0 |
| 2007-02-07 08:10:00 | AAPL | Stock | 3.0168 | 3.0179 | 3.0143 | 3.0171 | 276164.0 |
| 2007-02-07 08:15:00 | AAPL | Stock | 3.0179 | 3.0179 | 3.0146 | 3.0154 | 70504.0 |
| 2007-02-07 08:20:00 | AAPL | Stock | 3.0154 | 3.0154 | 3.0125 | 3.0125 | 171500.0 |
| 2007-02-07 08:25:00 | AAPL | Stock | 3.0125 | 3.0143 | 3.0118 | 3.0125 | 207200.0 |
| 2007-02-07 08:30:00 | AAPL | Stock | 3.0125 | 3.0143 | 3.0096 | 3.0125 | 121800.0 |
| 2007-02-07 08:35:00 | AAPL | Stock | 3.0125 | 3.0125 | 3.0107 | 3.0125 | 71428.0 |
| 2007-02-07 08:40:00 | AAPL | Stock | 3.0114 | 3.0125 | 3.0114 | 3.0118 | 134372.0 |
| 2007-02-07 08:45:00 | AAPL | Stock | 3.0118 | 3.0118 | 3.0054 | 3.0057 | 323372.0 |
| 2007-02-07 08:50:00 | AAPL | Stock | 3.0054 | 3.0071 | 3.0046 | 3.0054 | 235060.0 |
| 2007-02-07 08:55:00 | AAPL | Stock | 3.0054 | 3.0071 | 3.0054 | 3.0061 | 181160.0 |
| 2007-02-07 09:00:00 | AAPL | Stock | 3.0071 | 3.0089 | 3.0061 | 3.0075 | 392840.0 |
| 2007-02-07 09:05:00 | AAPL | Stock | 3.0089 | 3.0089 | 3.0071 | 3.0089 | 182784.0 |
| 2007-02-07 09:10:00 | AAPL | Stock | 3.0096 | 3.0125 | 3.0096 | 3.0118 | 491568.0 |
| 2007-02-07 09:15:00 | AAPL | Stock | 3.0107 | 3.0125 | 3.0107 | 3.0125 | 143500.0 |
| 2007-02-07 09:20:00 | AAPL | Stock | 3.0107 | 3.0107 | 3.0107 | 3.0107 | 58800.0 |
| 2007-02-07 09:25:00 | AAPL | Stock | 3.0107 | 3.0179 | 3.0089 | 3.0179 | 1847720.0 |
| 2007-02-07 09:30:00 | AAPL | Stock | 3.0171 | 3.0214 | 3.0054 | 3.01 | 27383160.0 |
| 2007-02-07 09:35:00 | AAPL | Stock | 3.01 | 3.0107 | 2.9979 | 3.004 | 15651580.0 |
| 2007-02-07 09:40:00 | AAPL | Stock | 3.0036 | 3.005 | 2.9996 | 3.0014 | 11556692.0 |
| 2007-02-07 09:45:00 | AAPL | Stock | 3.0018 | 3.0021 | 2.9882 | 2.9904 | 13630568.0 |
| 2007-02-07 09:50:00 | AAPL | Stock | 2.9904 | 2.9979 | 2.9889 | 2.9964 | 8488760.0 |
| 2007-02-07 09:55:00 | AAPL | Stock | 2.9971 | 2.9979 | 2.9839 | 2.9943 | 12365080.0 |
| 2007-02-07 10:00:00 | AAPL | Stock | 2.9936 | 2.9936 | 2.9864 | 2.9918 | 7969276.0 |
| 2007-02-07 10:05:00 | AAPL | Stock | 2.9918 | 2.9946 | 2.9875 | 2.9896 | 9752204.0 |
| 2007-02-07 10:10:00 | AAPL | Stock | 2.9893 | 3.0068 | 2.9875 | 3.0064 | 13988744.0 |
| 2007-02-07 10:15:00 | AAPL | Stock | 3.0064 | 3.0179 | 3.0014 | 3.0118 | 21293300.0 |
| 2007-02-07 10:20:00 | AAPL | Stock | 3.0121 | 3.0182 | 3.01 | 3.0157 | 17670828.0 |
| 2007-02-07 10:25:00 | AAPL | Stock | 3.0157 | 3.0189 | 3.0111 | 3.0127 | 14633892.0 |
| 2007-02-07 10:30:00 | AAPL | Stock | 3.0132 | 3.0157 | 3.01 | 3.0121 | 10873184.0 |
| 2007-02-07 10:35:00 | AAPL | Stock | 3.0125 | 3.0168 | 3.0086 | 3.0157 | 12116720.0 |
| 2007-02-07 10:40:00 | AAPL | Stock | 3.0154 | 3.0286 | 3.0146 | 3.0257 | 23817696.0 |
| 2007-02-07 10:45:00 | AAPL | Stock | 3.0257 | 3.0282 | 3.0193 | 3.0239 | 14715456.0 |
| 2007-02-07 10:50:00 | AAPL | Stock | 3.0243 | 3.0261 | 3.0189 | 3.0225 | 8409268.0 |
| 2007-02-07 10:55:00 | AAPL | Stock | 3.0225 | 3.025 | 3.0179 | 3.0193 | 9112488.0 |
| 2007-02-07 11:00:00 | AAPL | Stock | 3.0193 | 3.0225 | 3.0189 | 3.0214 | 8131172.0 |
| 2007-02-07 11:05:00 | AAPL | Stock | 3.0214 | 3.0264 | 3.0189 | 3.0221 | 13108508.0 |
| 2007-02-07 11:10:00 | AAPL | Stock | 3.0221 | 3.0246 | 3.0186 | 3.0204 | 9635556.0 |
| 2007-02-07 11:15:00 | AAPL | Stock | 3.0204 | 3.0229 | 3.015 | 3.015 | 7780220.0 |
| 2007-02-07 11:20:00 | AAPL | Stock | 3.015 | 3.0179 | 3.0146 | 3.0164 | 8307152.0 |
| 2007-02-07 11:25:00 | AAPL | Stock | 3.0164 | 3.0221 | 3.0157 | 3.0171 | 8402632.0 |
| 2007-02-07 11:30:00 | AAPL | Stock | 3.0171 | 3.02 | 3.0146 | 3.0182 | 4789848.0 |
| 2007-02-07 11:35:00 | AAPL | Stock | 3.0182 | 3.0236 | 3.0182 | 3.0218 | 6657672.0 |
| 2007-02-07 11:40:00 | AAPL | Stock | 3.0214 | 3.0246 | 3.0211 | 3.0243 | 5960248.0 |
| 2007-02-07 11:45:00 | AAPL | Stock | 3.0242 | 3.0279 | 3.0221 | 3.0225 | 11491340.0 |
| 2007-02-07 11:50:00 | AAPL | Stock | 3.0229 | 3.03 | 3.0204 | 3.0281 | 10850784.0 |
| 2007-02-07 11:55:00 | AAPL | Stock | 3.0282 | 3.0339 | 3.0279 | 3.0329 | 15202852.0 |
> showing 50 of 245,605 rows — these rows as CSV