PREVIEW / stock_5min / 2000-06-21
file: by_date/stock_5min/2000/2000-06-21.parquet size: 1.1 MB rows: 86,736 symbols: 1,180
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 |
|---|---|---|---|---|---|---|---|
| 2000-06-21 08:15:00 | AAPL | Stock | 0.942 | 0.942 | 0.8895 | 0.8895 | 16800.0 |
| 2000-06-21 08:20:00 | AAPL | Stock | 0.8973 | 0.8973 | 0.8973 | 0.8973 | 5600.0 |
| 2000-06-21 08:55:00 | AAPL | Stock | 0.8962 | 0.8973 | 0.8962 | 0.8973 | 39200.0 |
| 2000-06-21 09:00:00 | AAPL | Stock | 0.8973 | 0.8973 | 0.8973 | 0.8973 | 5600.0 |
| 2000-06-21 09:05:00 | AAPL | Stock | 0.8973 | 0.9018 | 0.8973 | 0.9018 | 28000.0 |
| 2000-06-21 09:15:00 | AAPL | Stock | 0.8973 | 0.8973 | 0.8929 | 0.8951 | 100800.0 |
| 2000-06-21 09:20:00 | AAPL | Stock | 0.8951 | 0.8973 | 0.8929 | 0.8973 | 196000.0 |
| 2000-06-21 09:25:00 | AAPL | Stock | 0.8973 | 0.9107 | 0.8973 | 0.8996 | 7179200.0 |
| 2000-06-21 09:30:00 | AAPL | Stock | 0.9018 | 0.9085 | 0.8984 | 0.9063 | 9794400.0 |
| 2000-06-21 09:35:00 | AAPL | Stock | 0.9074 | 0.9263 | 0.904 | 0.9152 | 12168800.0 |
| 2000-06-21 09:40:00 | AAPL | Stock | 0.9152 | 0.9174 | 0.9063 | 0.9141 | 7487200.0 |
| 2000-06-21 09:45:00 | AAPL | Stock | 0.9129 | 0.9196 | 0.9096 | 0.9152 | 7319200.0 |
| 2000-06-21 09:50:00 | AAPL | Stock | 0.9152 | 0.9241 | 0.9107 | 0.9141 | 8394400.0 |
| 2000-06-21 09:55:00 | AAPL | Stock | 0.9129 | 0.9241 | 0.9129 | 0.9236 | 5124000.0 |
| 2000-06-21 10:00:00 | AAPL | Stock | 0.9241 | 0.9308 | 0.9219 | 0.9275 | 10169600.0 |
| 2000-06-21 10:05:00 | AAPL | Stock | 0.9263 | 0.9308 | 0.9196 | 0.923 | 9559200.0 |
| 2000-06-21 10:10:00 | AAPL | Stock | 0.9241 | 0.9275 | 0.9219 | 0.9263 | 5448800.0 |
| 2000-06-21 10:15:00 | AAPL | Stock | 0.9252 | 0.9308 | 0.9241 | 0.9308 | 7711200.0 |
| 2000-06-21 10:20:00 | AAPL | Stock | 0.9286 | 0.9431 | 0.9263 | 0.9425 | 18071200.0 |
| 2000-06-21 10:25:00 | AAPL | Stock | 0.942 | 0.9453 | 0.9375 | 0.9431 | 15316000.0 |
| 2000-06-21 10:30:00 | AAPL | Stock | 0.9442 | 0.952 | 0.9431 | 0.9509 | 15394400.0 |
| 2000-06-21 10:35:00 | AAPL | Stock | 0.9509 | 0.952 | 0.9397 | 0.9442 | 8528800.0 |
| 2000-06-21 10:40:00 | AAPL | Stock | 0.9442 | 0.9442 | 0.9397 | 0.9442 | 5213600.0 |
| 2000-06-21 10:45:00 | AAPL | Stock | 0.9442 | 0.9464 | 0.9408 | 0.942 | 3421600.0 |
| 2000-06-21 10:50:00 | AAPL | Stock | 0.9408 | 0.9453 | 0.9397 | 0.9442 | 3410400.0 |
| 2000-06-21 10:55:00 | AAPL | Stock | 0.9442 | 0.9453 | 0.9386 | 0.942 | 5353600.0 |
| 2000-06-21 11:00:00 | AAPL | Stock | 0.942 | 0.9431 | 0.9386 | 0.942 | 3147200.0 |
| 2000-06-21 11:05:00 | AAPL | Stock | 0.9408 | 0.9431 | 0.9397 | 0.942 | 2772000.0 |
| 2000-06-21 11:10:00 | AAPL | Stock | 0.942 | 0.9431 | 0.9397 | 0.9397 | 4827200.0 |
| 2000-06-21 11:15:00 | AAPL | Stock | 0.9397 | 0.942 | 0.9397 | 0.9397 | 2587200.0 |
| 2000-06-21 11:20:00 | AAPL | Stock | 0.9397 | 0.9408 | 0.9319 | 0.933 | 5992000.0 |
| 2000-06-21 11:25:00 | AAPL | Stock | 0.9319 | 0.933 | 0.9297 | 0.9302 | 4194400.0 |
| 2000-06-21 11:30:00 | AAPL | Stock | 0.9302 | 0.9353 | 0.9286 | 0.933 | 5152000.0 |
| 2000-06-21 11:35:00 | AAPL | Stock | 0.9342 | 0.9353 | 0.933 | 0.9347 | 1304800.0 |
| 2000-06-21 11:40:00 | AAPL | Stock | 0.9353 | 0.9375 | 0.9319 | 0.933 | 5751200.0 |
| 2000-06-21 11:45:00 | AAPL | Stock | 0.9319 | 0.9353 | 0.9308 | 0.9353 | 1926400.0 |
| 2000-06-21 11:50:00 | AAPL | Stock | 0.9336 | 0.9353 | 0.933 | 0.9353 | 2273600.0 |
| 2000-06-21 11:55:00 | AAPL | Stock | 0.9353 | 0.9353 | 0.9342 | 0.9353 | 2027200.0 |
| 2000-06-21 12:00:00 | AAPL | Stock | 0.9353 | 0.942 | 0.9342 | 0.942 | 4278400.0 |
| 2000-06-21 12:05:00 | AAPL | Stock | 0.942 | 0.942 | 0.9386 | 0.9397 | 3488800.0 |
| 2000-06-21 12:10:00 | AAPL | Stock | 0.9408 | 0.9408 | 0.9353 | 0.9375 | 1058400.0 |
| 2000-06-21 12:15:00 | AAPL | Stock | 0.9375 | 0.942 | 0.9364 | 0.9397 | 980000.0 |
| 2000-06-21 12:20:00 | AAPL | Stock | 0.9397 | 0.9408 | 0.9381 | 0.9397 | 812000.0 |
| 2000-06-21 12:25:00 | AAPL | Stock | 0.9397 | 0.9431 | 0.9397 | 0.9408 | 1120000.0 |
| 2000-06-21 12:30:00 | AAPL | Stock | 0.942 | 0.942 | 0.9364 | 0.9364 | 1405600.0 |
| 2000-06-21 12:35:00 | AAPL | Stock | 0.9375 | 0.9397 | 0.9369 | 0.9375 | 1685600.0 |
| 2000-06-21 12:40:00 | AAPL | Stock | 0.9375 | 0.9397 | 0.9375 | 0.9386 | 2464000.0 |
| 2000-06-21 12:45:00 | AAPL | Stock | 0.9375 | 0.9397 | 0.9375 | 0.9386 | 1887200.0 |
| 2000-06-21 12:50:00 | AAPL | Stock | 0.9397 | 0.9397 | 0.9375 | 0.9397 | 5264000.0 |
| 2000-06-21 12:55:00 | AAPL | Stock | 0.9397 | 0.9397 | 0.9375 | 0.9397 | 3953600.0 |
> showing 50 of 86,736 rows — these rows as CSV