PREVIEW / stock_5min / 2002-05-24
file: by_date/stock_5min/2002/2002-05-24.parquet size: 1.7 MB rows: 117,388 symbols: 1,413
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 |
|---|---|---|---|---|---|---|---|
| 2002-05-24 08:15:00 | AAPL | Stock | 0.4464 | 0.4464 | 0.4464 | 0.4464 | 5600.0 |
| 2002-05-24 08:30:00 | AAPL | Stock | 0.4457 | 0.4464 | 0.4457 | 0.4464 | 140000.0 |
| 2002-05-24 08:35:00 | AAPL | Stock | 0.4454 | 0.4454 | 0.4454 | 0.4454 | 28000.0 |
| 2002-05-24 08:45:00 | AAPL | Stock | 0.4464 | 0.4464 | 0.4464 | 0.4464 | 67200.0 |
| 2002-05-24 08:50:00 | AAPL | Stock | 0.4464 | 0.4464 | 0.4464 | 0.4464 | 61600.0 |
| 2002-05-24 08:55:00 | AAPL | Stock | 0.4495 | 0.4495 | 0.4464 | 0.4464 | 16800.0 |
| 2002-05-24 09:10:00 | AAPL | Stock | 0.4475 | 0.4475 | 0.4475 | 0.4475 | 16800.0 |
| 2002-05-24 09:15:00 | AAPL | Stock | 0.4473 | 0.4473 | 0.4464 | 0.4464 | 112000.0 |
| 2002-05-24 09:20:00 | AAPL | Stock | 0.4471 | 0.4471 | 0.4464 | 0.4464 | 123200.0 |
| 2002-05-24 09:25:00 | AAPL | Stock | 0.4466 | 0.4466 | 0.4459 | 0.4459 | 380800.0 |
| 2002-05-24 09:30:00 | AAPL | Stock | 0.4463 | 0.4463 | 0.4421 | 0.4432 | 8562400.0 |
| 2002-05-24 09:35:00 | AAPL | Stock | 0.4429 | 0.4452 | 0.4404 | 0.4407 | 8618400.0 |
| 2002-05-24 09:40:00 | AAPL | Stock | 0.4407 | 0.4417 | 0.4402 | 0.4402 | 3360000.0 |
| 2002-05-24 09:45:00 | AAPL | Stock | 0.44 | 0.4418 | 0.44 | 0.4409 | 834400.0 |
| 2002-05-24 09:50:00 | AAPL | Stock | 0.4407 | 0.4411 | 0.4386 | 0.4391 | 3438400.0 |
| 2002-05-24 09:55:00 | AAPL | Stock | 0.4391 | 0.442 | 0.4388 | 0.4413 | 2811200.0 |
| 2002-05-24 10:00:00 | AAPL | Stock | 0.4411 | 0.442 | 0.4389 | 0.4409 | 5779200.0 |
| 2002-05-24 10:05:00 | AAPL | Stock | 0.4414 | 0.4418 | 0.437 | 0.437 | 3656800.0 |
| 2002-05-24 10:10:00 | AAPL | Stock | 0.4371 | 0.4391 | 0.4357 | 0.4366 | 4900000.0 |
| 2002-05-24 10:15:00 | AAPL | Stock | 0.437 | 0.4384 | 0.4361 | 0.4375 | 1506400.0 |
| 2002-05-24 10:20:00 | AAPL | Stock | 0.4374 | 0.4375 | 0.4361 | 0.4371 | 1069600.0 |
| 2002-05-24 10:25:00 | AAPL | Stock | 0.4373 | 0.4391 | 0.4366 | 0.437 | 2430400.0 |
| 2002-05-24 10:30:00 | AAPL | Stock | 0.4366 | 0.437 | 0.4352 | 0.4364 | 2548000.0 |
| 2002-05-24 10:35:00 | AAPL | Stock | 0.4366 | 0.4381 | 0.4357 | 0.4368 | 1663200.0 |
| 2002-05-24 10:40:00 | AAPL | Stock | 0.4368 | 0.437 | 0.4339 | 0.4339 | 2732800.0 |
| 2002-05-24 10:45:00 | AAPL | Stock | 0.4339 | 0.4346 | 0.433 | 0.4343 | 5028800.0 |
| 2002-05-24 10:50:00 | AAPL | Stock | 0.4341 | 0.4357 | 0.4334 | 0.4348 | 3108000.0 |
| 2002-05-24 10:55:00 | AAPL | Stock | 0.4355 | 0.4361 | 0.4352 | 0.4361 | 1685600.0 |
| 2002-05-24 11:00:00 | AAPL | Stock | 0.4364 | 0.438 | 0.4355 | 0.438 | 3119200.0 |
| 2002-05-24 11:05:00 | AAPL | Stock | 0.4379 | 0.438 | 0.4363 | 0.4379 | 2161600.0 |
| 2002-05-24 11:10:00 | AAPL | Stock | 0.4373 | 0.4373 | 0.4368 | 0.4368 | 145600.0 |
| 2002-05-24 11:15:00 | AAPL | Stock | 0.437 | 0.437 | 0.4365 | 0.437 | 655200.0 |
| 2002-05-24 11:20:00 | AAPL | Stock | 0.4368 | 0.437 | 0.4366 | 0.4368 | 7358400.0 |
| 2002-05-24 11:25:00 | AAPL | Stock | 0.4366 | 0.4369 | 0.4357 | 0.4364 | 1097600.0 |
| 2002-05-24 11:30:00 | AAPL | Stock | 0.4361 | 0.4364 | 0.4345 | 0.4354 | 3074400.0 |
| 2002-05-24 11:35:00 | AAPL | Stock | 0.4352 | 0.4354 | 0.4339 | 0.4345 | 817600.0 |
| 2002-05-24 11:40:00 | AAPL | Stock | 0.4345 | 0.4345 | 0.4323 | 0.4329 | 1612800.0 |
| 2002-05-24 11:45:00 | AAPL | Stock | 0.4329 | 0.4341 | 0.4328 | 0.4336 | 532000.0 |
| 2002-05-24 11:50:00 | AAPL | Stock | 0.4336 | 0.4338 | 0.4316 | 0.433 | 2139200.0 |
| 2002-05-24 11:55:00 | AAPL | Stock | 0.433 | 0.433 | 0.4327 | 0.4329 | 408800.0 |
| 2002-05-24 12:00:00 | AAPL | Stock | 0.433 | 0.4332 | 0.4302 | 0.4314 | 3623200.0 |
| 2002-05-24 12:05:00 | AAPL | Stock | 0.4316 | 0.4327 | 0.4314 | 0.4327 | 1254400.0 |
| 2002-05-24 12:10:00 | AAPL | Stock | 0.4323 | 0.4329 | 0.4321 | 0.4329 | 257600.0 |
| 2002-05-24 12:15:00 | AAPL | Stock | 0.4323 | 0.4329 | 0.4321 | 0.4323 | 352800.0 |
| 2002-05-24 12:20:00 | AAPL | Stock | 0.4325 | 0.4329 | 0.4325 | 0.4327 | 179200.0 |
| 2002-05-24 12:25:00 | AAPL | Stock | 0.4321 | 0.4325 | 0.4316 | 0.4321 | 1176000.0 |
| 2002-05-24 12:30:00 | AAPL | Stock | 0.4321 | 0.4325 | 0.4318 | 0.4318 | 436800.0 |
| 2002-05-24 12:35:00 | AAPL | Stock | 0.4318 | 0.4325 | 0.43 | 0.4311 | 1142400.0 |
| 2002-05-24 12:40:00 | AAPL | Stock | 0.4311 | 0.4311 | 0.43 | 0.4309 | 856800.0 |
| 2002-05-24 12:45:00 | AAPL | Stock | 0.4309 | 0.4311 | 0.4304 | 0.4305 | 862400.0 |
> showing 50 of 117,388 rows — these rows as CSV