PREVIEW / stock_5min / 2000-01-18
file: by_date/stock_5min/2000/2000-01-18.parquet size: 1.1 MB rows: 89,188 symbols: 1,130
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-01-18 09:30:00 | AAPL | Stock | 0.9018 | 0.9046 | 0.8984 | 0.9026 | 15276800.0 |
| 2000-01-18 09:35:00 | AAPL | Stock | 0.9046 | 0.9096 | 0.899 | 0.9057 | 7627200.0 |
| 2000-01-18 09:40:00 | AAPL | Stock | 0.9102 | 0.9129 | 0.9018 | 0.9035 | 13507200.0 |
| 2000-01-18 09:45:00 | AAPL | Stock | 0.9035 | 0.9046 | 0.8996 | 0.9046 | 8444800.0 |
| 2000-01-18 09:50:00 | AAPL | Stock | 0.9046 | 0.9085 | 0.8996 | 0.904 | 7190400.0 |
| 2000-01-18 09:55:00 | AAPL | Stock | 0.904 | 0.9074 | 0.8996 | 0.904 | 5656000.0 |
| 2000-01-18 10:00:00 | AAPL | Stock | 0.9035 | 0.9035 | 0.9007 | 0.9012 | 3662400.0 |
| 2000-01-18 10:05:00 | AAPL | Stock | 0.9012 | 0.9012 | 0.9001 | 0.9001 | 3875200.0 |
| 2000-01-18 10:10:00 | AAPL | Stock | 0.9007 | 0.9035 | 0.9001 | 0.9007 | 5622400.0 |
| 2000-01-18 10:15:00 | AAPL | Stock | 0.9007 | 0.9012 | 0.8968 | 0.8984 | 8052800.0 |
| 2000-01-18 10:20:00 | AAPL | Stock | 0.8984 | 0.8996 | 0.8968 | 0.8973 | 2161600.0 |
| 2000-01-18 10:25:00 | AAPL | Stock | 0.8968 | 0.9007 | 0.8968 | 0.899 | 1948800.0 |
| 2000-01-18 10:30:00 | AAPL | Stock | 0.9001 | 0.904 | 0.8968 | 0.9029 | 4188800.0 |
| 2000-01-18 10:35:00 | AAPL | Stock | 0.904 | 0.9051 | 0.8996 | 0.904 | 2531200.0 |
| 2000-01-18 10:40:00 | AAPL | Stock | 0.9046 | 0.9079 | 0.9035 | 0.9035 | 3192000.0 |
| 2000-01-18 10:45:00 | AAPL | Stock | 0.904 | 0.904 | 0.9018 | 0.9018 | 3707200.0 |
| 2000-01-18 10:50:00 | AAPL | Stock | 0.9012 | 0.904 | 0.8973 | 0.9007 | 4580800.0 |
| 2000-01-18 10:55:00 | AAPL | Stock | 0.9007 | 0.9035 | 0.8973 | 0.8987 | 3931200.0 |
| 2000-01-18 11:00:00 | AAPL | Stock | 0.8984 | 0.9007 | 0.8973 | 0.8984 | 3460800.0 |
| 2000-01-18 11:05:00 | AAPL | Stock | 0.8996 | 0.9035 | 0.8973 | 0.9007 | 2161600.0 |
| 2000-01-18 11:10:00 | AAPL | Stock | 0.9015 | 0.9018 | 0.8968 | 0.899 | 3651200.0 |
| 2000-01-18 11:15:00 | AAPL | Stock | 0.899 | 0.9018 | 0.8984 | 0.9007 | 8388800.0 |
| 2000-01-18 11:20:00 | AAPL | Stock | 0.9007 | 0.9018 | 0.8996 | 0.9007 | 3102400.0 |
| 2000-01-18 11:25:00 | AAPL | Stock | 0.9012 | 0.9029 | 0.9007 | 0.9026 | 7716800.0 |
| 2000-01-18 11:30:00 | AAPL | Stock | 0.9023 | 0.9051 | 0.9018 | 0.9018 | 2262400.0 |
| 2000-01-18 11:35:00 | AAPL | Stock | 0.9018 | 0.9063 | 0.9012 | 0.9063 | 6596800.0 |
| 2000-01-18 11:40:00 | AAPL | Stock | 0.9046 | 0.9096 | 0.904 | 0.9096 | 1792000.0 |
| 2000-01-18 11:45:00 | AAPL | Stock | 0.9096 | 0.9235 | 0.9063 | 0.9169 | 14750400.0 |
| 2000-01-18 11:50:00 | AAPL | Stock | 0.9174 | 0.9196 | 0.9135 | 0.9174 | 5857600.0 |
| 2000-01-18 11:55:00 | AAPL | Stock | 0.9169 | 0.918 | 0.9163 | 0.9174 | 3550400.0 |
| 2000-01-18 12:00:00 | AAPL | Stock | 0.9185 | 0.923 | 0.9174 | 0.9219 | 5420800.0 |
| 2000-01-18 12:05:00 | AAPL | Stock | 0.9216 | 0.9216 | 0.9163 | 0.9169 | 2172800.0 |
| 2000-01-18 12:10:00 | AAPL | Stock | 0.9174 | 0.9185 | 0.9107 | 0.9135 | 6148800.0 |
| 2000-01-18 12:15:00 | AAPL | Stock | 0.9132 | 0.9219 | 0.9129 | 0.9213 | 4043200.0 |
| 2000-01-18 12:20:00 | AAPL | Stock | 0.921 | 0.9286 | 0.9191 | 0.9286 | 5857600.0 |
| 2000-01-18 12:25:00 | AAPL | Stock | 0.923 | 0.9369 | 0.923 | 0.9353 | 13048000.0 |
| 2000-01-18 12:30:00 | AAPL | Stock | 0.9353 | 0.9375 | 0.9308 | 0.933 | 9116800.0 |
| 2000-01-18 12:35:00 | AAPL | Stock | 0.933 | 0.9336 | 0.9297 | 0.9297 | 2284800.0 |
| 2000-01-18 12:40:00 | AAPL | Stock | 0.9302 | 0.9319 | 0.9263 | 0.9263 | 3012800.0 |
| 2000-01-18 12:45:00 | AAPL | Stock | 0.9263 | 0.9325 | 0.9247 | 0.9319 | 2464000.0 |
| 2000-01-18 12:50:00 | AAPL | Stock | 0.9322 | 0.933 | 0.9297 | 0.933 | 2576000.0 |
| 2000-01-18 12:55:00 | AAPL | Stock | 0.9314 | 0.9364 | 0.9308 | 0.9353 | 4110400.0 |
| 2000-01-18 13:00:00 | AAPL | Stock | 0.9353 | 0.9358 | 0.9286 | 0.9286 | 5297600.0 |
| 2000-01-18 13:05:00 | AAPL | Stock | 0.9286 | 0.9325 | 0.9252 | 0.9314 | 2878400.0 |
| 2000-01-18 13:10:00 | AAPL | Stock | 0.9297 | 0.9375 | 0.9297 | 0.9369 | 10169600.0 |
| 2000-01-18 13:15:00 | AAPL | Stock | 0.9369 | 0.9375 | 0.933 | 0.9375 | 5678400.0 |
| 2000-01-18 13:20:00 | AAPL | Stock | 0.9375 | 0.9375 | 0.9353 | 0.9358 | 5152000.0 |
| 2000-01-18 13:25:00 | AAPL | Stock | 0.9358 | 0.9375 | 0.9353 | 0.9364 | 2004800.0 |
| 2000-01-18 13:30:00 | AAPL | Stock | 0.9364 | 0.9369 | 0.9353 | 0.9353 | 1086400.0 |
| 2000-01-18 13:35:00 | AAPL | Stock | 0.9364 | 0.9369 | 0.9314 | 0.9319 | 5555200.0 |
> showing 50 of 89,188 rows — these rows as CSV