PREVIEW / stock_5min / 2003-10-14
file: by_date/stock_5min/2003/2003-10-14.parquet size: 2.1 MB rows: 158,263 symbols: 1,649
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-10-14 08:00:00 | AAPL | Stock | 0.4348 | 0.4348 | 0.4348 | 0.4348 | 5600.0 |
| 2003-10-14 08:25:00 | AAPL | Stock | 0.4357 | 0.4357 | 0.4357 | 0.4357 | 28000.0 |
| 2003-10-14 08:30:00 | AAPL | Stock | 0.4357 | 0.4357 | 0.4357 | 0.4357 | 28000.0 |
| 2003-10-14 09:00:00 | AAPL | Stock | 0.4345 | 0.4345 | 0.4345 | 0.4345 | 89600.0 |
| 2003-10-14 09:20:00 | AAPL | Stock | 0.4348 | 0.4348 | 0.4348 | 0.4348 | 5600.0 |
| 2003-10-14 09:25:00 | AAPL | Stock | 0.4354 | 0.4354 | 0.4348 | 0.4348 | 140000.0 |
| 2003-10-14 09:30:00 | AAPL | Stock | 0.4343 | 0.4375 | 0.4339 | 0.4364 | 8349824.0 |
| 2003-10-14 09:35:00 | AAPL | Stock | 0.437 | 0.4375 | 0.4358 | 0.4364 | 5943560.0 |
| 2003-10-14 09:40:00 | AAPL | Stock | 0.4364 | 0.4364 | 0.4348 | 0.435 | 2734928.0 |
| 2003-10-14 09:45:00 | AAPL | Stock | 0.4348 | 0.4354 | 0.4345 | 0.4345 | 2471056.0 |
| 2003-10-14 09:50:00 | AAPL | Stock | 0.4345 | 0.4345 | 0.4332 | 0.4336 | 3248840.0 |
| 2003-10-14 09:55:00 | AAPL | Stock | 0.4338 | 0.4343 | 0.4323 | 0.4326 | 4266080.0 |
| 2003-10-14 10:00:00 | AAPL | Stock | 0.4327 | 0.4334 | 0.4323 | 0.4323 | 2373280.0 |
| 2003-10-14 10:05:00 | AAPL | Stock | 0.4325 | 0.4343 | 0.4325 | 0.4333 | 2805488.0 |
| 2003-10-14 10:10:00 | AAPL | Stock | 0.4333 | 0.4361 | 0.4333 | 0.4357 | 3508400.0 |
| 2003-10-14 10:15:00 | AAPL | Stock | 0.4354 | 0.4368 | 0.4354 | 0.4359 | 6096048.0 |
| 2003-10-14 10:20:00 | AAPL | Stock | 0.4359 | 0.4366 | 0.4354 | 0.4366 | 1411200.0 |
| 2003-10-14 10:25:00 | AAPL | Stock | 0.4363 | 0.4363 | 0.4355 | 0.4359 | 2772672.0 |
| 2003-10-14 10:30:00 | AAPL | Stock | 0.4355 | 0.4355 | 0.435 | 0.4354 | 1522472.0 |
| 2003-10-14 10:35:00 | AAPL | Stock | 0.4354 | 0.4355 | 0.4348 | 0.435 | 1487976.0 |
| 2003-10-14 10:40:00 | AAPL | Stock | 0.4348 | 0.435 | 0.4341 | 0.4341 | 1786400.0 |
| 2003-10-14 10:45:00 | AAPL | Stock | 0.4343 | 0.435 | 0.4341 | 0.4341 | 1070160.0 |
| 2003-10-14 10:50:00 | AAPL | Stock | 0.4341 | 0.4363 | 0.4341 | 0.4357 | 1458856.0 |
| 2003-10-14 10:55:00 | AAPL | Stock | 0.4354 | 0.4363 | 0.4352 | 0.4361 | 2777600.0 |
| 2003-10-14 11:00:00 | AAPL | Stock | 0.4361 | 0.4362 | 0.4348 | 0.435 | 3437784.0 |
| 2003-10-14 11:05:00 | AAPL | Stock | 0.435 | 0.4358 | 0.4349 | 0.4357 | 3464944.0 |
| 2003-10-14 11:10:00 | AAPL | Stock | 0.4355 | 0.4355 | 0.4343 | 0.4348 | 1391600.0 |
| 2003-10-14 11:15:00 | AAPL | Stock | 0.435 | 0.4352 | 0.434 | 0.4341 | 1333976.0 |
| 2003-10-14 11:20:00 | AAPL | Stock | 0.4341 | 0.4345 | 0.4339 | 0.4341 | 3022096.0 |
| 2003-10-14 11:25:00 | AAPL | Stock | 0.4341 | 0.4343 | 0.4339 | 0.4341 | 1282400.0 |
| 2003-10-14 11:30:00 | AAPL | Stock | 0.4341 | 0.4343 | 0.4332 | 0.4336 | 1309392.0 |
| 2003-10-14 11:35:00 | AAPL | Stock | 0.4339 | 0.4341 | 0.4336 | 0.4338 | 1120000.0 |
| 2003-10-14 11:40:00 | AAPL | Stock | 0.4339 | 0.4345 | 0.4336 | 0.4343 | 1668800.0 |
| 2003-10-14 11:45:00 | AAPL | Stock | 0.4339 | 0.4348 | 0.4336 | 0.4338 | 828800.0 |
| 2003-10-14 11:50:00 | AAPL | Stock | 0.4338 | 0.4339 | 0.4336 | 0.4338 | 991200.0 |
| 2003-10-14 11:55:00 | AAPL | Stock | 0.4336 | 0.4338 | 0.4332 | 0.4334 | 1652616.0 |
| 2003-10-14 12:00:00 | AAPL | Stock | 0.4334 | 0.4334 | 0.4332 | 0.4332 | 921200.0 |
| 2003-10-14 12:05:00 | AAPL | Stock | 0.4332 | 0.4334 | 0.4332 | 0.4332 | 1456000.0 |
| 2003-10-14 12:10:00 | AAPL | Stock | 0.4332 | 0.4341 | 0.4331 | 0.4341 | 4492544.0 |
| 2003-10-14 12:15:00 | AAPL | Stock | 0.4343 | 0.4355 | 0.4341 | 0.4348 | 2878400.0 |
| 2003-10-14 12:20:00 | AAPL | Stock | 0.4343 | 0.4348 | 0.4332 | 0.4334 | 1230376.0 |
| 2003-10-14 12:25:00 | AAPL | Stock | 0.4334 | 0.4345 | 0.4334 | 0.4345 | 1504944.0 |
| 2003-10-14 12:30:00 | AAPL | Stock | 0.4345 | 0.4357 | 0.4341 | 0.4346 | 1663200.0 |
| 2003-10-14 12:35:00 | AAPL | Stock | 0.4346 | 0.4348 | 0.4336 | 0.4339 | 421624.0 |
| 2003-10-14 12:40:00 | AAPL | Stock | 0.4336 | 0.4339 | 0.4336 | 0.4339 | 207200.0 |
| 2003-10-14 12:45:00 | AAPL | Stock | 0.4339 | 0.4339 | 0.4336 | 0.4336 | 276024.0 |
| 2003-10-14 12:50:00 | AAPL | Stock | 0.4336 | 0.4336 | 0.433 | 0.433 | 849576.0 |
| 2003-10-14 12:55:00 | AAPL | Stock | 0.4332 | 0.4332 | 0.4323 | 0.4323 | 330400.0 |
| 2003-10-14 13:00:00 | AAPL | Stock | 0.4323 | 0.4325 | 0.4321 | 0.4323 | 486696.0 |
| 2003-10-14 13:05:00 | AAPL | Stock | 0.4323 | 0.4325 | 0.4321 | 0.4323 | 851200.0 |
> showing 50 of 158,263 rows — these rows as CSV