PREVIEW / stock_5min / 2003-04-16
file: by_date/stock_5min/2003/2003-04-16.parquet size: 1.9 MB rows: 137,138 symbols: 1,556
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 |
|---|---|---|---|---|---|---|---|
| 2003-04-16 08:00:00 | AAPL | Stock | 0.2241 | 0.2341 | 0.2218 | 0.2286 | 15926960.0 |
| 2003-04-16 08:05:00 | AAPL | Stock | 0.2309 | 0.2322 | 0.2304 | 0.2321 | 1003800.0 |
| 2003-04-16 08:10:00 | AAPL | Stock | 0.2321 | 0.2322 | 0.2321 | 0.2321 | 1708000.0 |
| 2003-04-16 08:15:00 | AAPL | Stock | 0.2321 | 0.2334 | 0.2321 | 0.2321 | 873600.0 |
| 2003-04-16 08:20:00 | AAPL | Stock | 0.2327 | 0.2327 | 0.2313 | 0.2321 | 4436600.0 |
| 2003-04-16 08:25:00 | AAPL | Stock | 0.2321 | 0.2321 | 0.2318 | 0.2321 | 218400.0 |
| 2003-04-16 08:30:00 | AAPL | Stock | 0.2321 | 0.2339 | 0.2321 | 0.233 | 336000.0 |
| 2003-04-16 08:35:00 | AAPL | Stock | 0.2321 | 0.2323 | 0.2316 | 0.2321 | 795200.0 |
| 2003-04-16 08:40:00 | AAPL | Stock | 0.233 | 0.2388 | 0.2321 | 0.2388 | 212800.0 |
| 2003-04-16 08:45:00 | AAPL | Stock | 0.2321 | 0.2323 | 0.2321 | 0.2321 | 610400.0 |
| 2003-04-16 08:50:00 | AAPL | Stock | 0.2321 | 0.2325 | 0.2318 | 0.232 | 358400.0 |
| 2003-04-16 08:55:00 | AAPL | Stock | 0.2393 | 0.2393 | 0.2321 | 0.2321 | 1075200.0 |
| 2003-04-16 09:00:00 | AAPL | Stock | 0.2321 | 0.2322 | 0.2318 | 0.2318 | 6692000.0 |
| 2003-04-16 09:05:00 | AAPL | Stock | 0.2321 | 0.2321 | 0.2304 | 0.2318 | 868000.0 |
| 2003-04-16 09:10:00 | AAPL | Stock | 0.2266 | 0.2313 | 0.2266 | 0.2302 | 3427200.0 |
| 2003-04-16 09:15:00 | AAPL | Stock | 0.2298 | 0.2311 | 0.2296 | 0.2304 | 3231200.0 |
| 2003-04-16 09:20:00 | AAPL | Stock | 0.2295 | 0.2321 | 0.2295 | 0.2311 | 3441200.0 |
| 2003-04-16 09:25:00 | AAPL | Stock | 0.2311 | 0.2343 | 0.2307 | 0.2318 | 22129968.0 |
| 2003-04-16 09:30:00 | AAPL | Stock | 0.232 | 0.233 | 0.2309 | 0.2329 | 21615664.0 |
| 2003-04-16 09:35:00 | AAPL | Stock | 0.2329 | 0.2336 | 0.2318 | 0.2336 | 18695936.0 |
| 2003-04-16 09:40:00 | AAPL | Stock | 0.2334 | 0.2341 | 0.2327 | 0.2334 | 14558936.0 |
| 2003-04-16 09:45:00 | AAPL | Stock | 0.233 | 0.2334 | 0.2327 | 0.2329 | 11272800.0 |
| 2003-04-16 09:50:00 | AAPL | Stock | 0.2327 | 0.233 | 0.2307 | 0.2316 | 40139848.0 |
| 2003-04-16 09:55:00 | AAPL | Stock | 0.2318 | 0.2325 | 0.2314 | 0.232 | 8518888.0 |
| 2003-04-16 10:00:00 | AAPL | Stock | 0.2321 | 0.2325 | 0.2318 | 0.2321 | 7602560.0 |
| 2003-04-16 10:05:00 | AAPL | Stock | 0.2321 | 0.2321 | 0.2313 | 0.2314 | 16569840.0 |
| 2003-04-16 10:10:00 | AAPL | Stock | 0.2314 | 0.2325 | 0.2314 | 0.2325 | 35770056.0 |
| 2003-04-16 10:15:00 | AAPL | Stock | 0.2325 | 0.2332 | 0.2323 | 0.2329 | 12815320.0 |
| 2003-04-16 10:20:00 | AAPL | Stock | 0.233 | 0.2348 | 0.233 | 0.2343 | 12177368.0 |
| 2003-04-16 10:25:00 | AAPL | Stock | 0.2346 | 0.2357 | 0.2339 | 0.234 | 16772168.0 |
| 2003-04-16 10:30:00 | AAPL | Stock | 0.2341 | 0.235 | 0.2338 | 0.2348 | 6094928.0 |
| 2003-04-16 10:35:00 | AAPL | Stock | 0.2348 | 0.2352 | 0.2334 | 0.2338 | 23100224.0 |
| 2003-04-16 10:40:00 | AAPL | Stock | 0.2338 | 0.2339 | 0.2321 | 0.2327 | 9410856.0 |
| 2003-04-16 10:45:00 | AAPL | Stock | 0.2329 | 0.2332 | 0.2323 | 0.233 | 11543616.0 |
| 2003-04-16 10:50:00 | AAPL | Stock | 0.2329 | 0.233 | 0.2321 | 0.233 | 9633512.0 |
| 2003-04-16 10:55:00 | AAPL | Stock | 0.233 | 0.2334 | 0.2325 | 0.2327 | 8620920.0 |
| 2003-04-16 11:00:00 | AAPL | Stock | 0.2327 | 0.2339 | 0.232 | 0.233 | 12652920.0 |
| 2003-04-16 11:05:00 | AAPL | Stock | 0.233 | 0.2341 | 0.233 | 0.2338 | 10365880.0 |
| 2003-04-16 11:10:00 | AAPL | Stock | 0.2336 | 0.2341 | 0.2323 | 0.2325 | 6437760.0 |
| 2003-04-16 11:15:00 | AAPL | Stock | 0.2325 | 0.2338 | 0.2325 | 0.2334 | 2831528.0 |
| 2003-04-16 11:20:00 | AAPL | Stock | 0.2331 | 0.2339 | 0.233 | 0.2336 | 3332560.0 |
| 2003-04-16 11:25:00 | AAPL | Stock | 0.2338 | 0.2338 | 0.2329 | 0.2334 | 1215032.0 |
| 2003-04-16 11:30:00 | AAPL | Stock | 0.233 | 0.2338 | 0.2329 | 0.2334 | 7178416.0 |
| 2003-04-16 11:35:00 | AAPL | Stock | 0.2338 | 0.2338 | 0.233 | 0.233 | 3425744.0 |
| 2003-04-16 11:40:00 | AAPL | Stock | 0.2332 | 0.2336 | 0.2329 | 0.2332 | 21723352.0 |
| 2003-04-16 11:45:00 | AAPL | Stock | 0.2329 | 0.2334 | 0.232 | 0.2325 | 11735416.0 |
| 2003-04-16 11:50:00 | AAPL | Stock | 0.2323 | 0.2339 | 0.2314 | 0.2325 | 11465216.0 |
| 2003-04-16 11:55:00 | AAPL | Stock | 0.2327 | 0.233 | 0.2323 | 0.2327 | 4681040.0 |
| 2003-04-16 12:00:00 | AAPL | Stock | 0.2329 | 0.233 | 0.2321 | 0.2325 | 5024936.0 |
| 2003-04-16 12:05:00 | AAPL | Stock | 0.2323 | 0.2339 | 0.2323 | 0.2332 | 2970688.0 |
> showing 50 of 137,138 rows — these rows as CSV