PREVIEW / stock_5min / 2005-08-26
file: by_date/stock_5min/2005/2005-08-26.parquet size: 2.6 MB rows: 194,975 symbols: 2,057
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 |
|---|---|---|---|---|---|---|---|
| 2005-08-26 08:40:00 | AAPL | Stock | 1.6493 | 1.6518 | 1.6493 | 1.6518 | 117124.0 |
| 2005-08-26 08:45:00 | AAPL | Stock | 1.6536 | 1.6539 | 1.6521 | 1.6525 | 36400.0 |
| 2005-08-26 08:50:00 | AAPL | Stock | 1.6532 | 1.6532 | 1.6518 | 1.6518 | 184800.0 |
| 2005-08-26 08:55:00 | AAPL | Stock | 1.6518 | 1.6518 | 1.6518 | 1.6518 | 543200.0 |
| 2005-08-26 09:05:00 | AAPL | Stock | 1.6514 | 1.6521 | 1.6514 | 1.6518 | 89600.0 |
| 2005-08-26 09:10:00 | AAPL | Stock | 1.6532 | 1.6536 | 1.6521 | 1.6536 | 53200.0 |
| 2005-08-26 09:15:00 | AAPL | Stock | 1.6521 | 1.6521 | 1.6521 | 1.6521 | 2800.0 |
| 2005-08-26 09:20:00 | AAPL | Stock | 1.6511 | 1.6514 | 1.6511 | 1.6514 | 28000.0 |
| 2005-08-26 09:25:00 | AAPL | Stock | 1.65 | 1.6568 | 1.6446 | 1.6446 | 1668800.0 |
| 2005-08-26 09:30:00 | AAPL | Stock | 1.6471 | 1.655 | 1.6464 | 1.6482 | 9629004.0 |
| 2005-08-26 09:35:00 | AAPL | Stock | 1.6479 | 1.65 | 1.6436 | 1.6439 | 5275172.0 |
| 2005-08-26 09:40:00 | AAPL | Stock | 1.6439 | 1.645 | 1.6379 | 1.64 | 7302932.0 |
| 2005-08-26 09:45:00 | AAPL | Stock | 1.6404 | 1.6404 | 1.6261 | 1.6261 | 10691800.0 |
| 2005-08-26 09:50:00 | AAPL | Stock | 1.6261 | 1.6346 | 1.6261 | 1.6275 | 8777664.0 |
| 2005-08-26 09:55:00 | AAPL | Stock | 1.6282 | 1.6343 | 1.6264 | 1.6332 | 10285968.0 |
| 2005-08-26 10:00:00 | AAPL | Stock | 1.6332 | 1.6332 | 1.62 | 1.6204 | 11833892.0 |
| 2005-08-26 10:05:00 | AAPL | Stock | 1.6204 | 1.6279 | 1.6204 | 1.6268 | 8830080.0 |
| 2005-08-26 10:10:00 | AAPL | Stock | 1.6268 | 1.6304 | 1.6268 | 1.6279 | 5660816.0 |
| 2005-08-26 10:15:00 | AAPL | Stock | 1.6275 | 1.6304 | 1.6268 | 1.6275 | 5401788.0 |
| 2005-08-26 10:20:00 | AAPL | Stock | 1.6275 | 1.6311 | 1.6271 | 1.6279 | 3699192.0 |
| 2005-08-26 10:25:00 | AAPL | Stock | 1.6282 | 1.6311 | 1.6279 | 1.6307 | 2091852.0 |
| 2005-08-26 10:30:00 | AAPL | Stock | 1.6304 | 1.6339 | 1.6296 | 1.6336 | 3419780.0 |
| 2005-08-26 10:35:00 | AAPL | Stock | 1.6339 | 1.6346 | 1.6311 | 1.6311 | 5771976.0 |
| 2005-08-26 10:40:00 | AAPL | Stock | 1.6307 | 1.6314 | 1.6282 | 1.6293 | 4728164.0 |
| 2005-08-26 10:45:00 | AAPL | Stock | 1.6293 | 1.6325 | 1.6286 | 1.6318 | 3470096.0 |
| 2005-08-26 10:50:00 | AAPL | Stock | 1.6318 | 1.6321 | 1.6286 | 1.6293 | 2815288.0 |
| 2005-08-26 10:55:00 | AAPL | Stock | 1.6289 | 1.6318 | 1.6282 | 1.6318 | 3506412.0 |
| 2005-08-26 11:00:00 | AAPL | Stock | 1.6318 | 1.6318 | 1.6293 | 1.6311 | 2430232.0 |
| 2005-08-26 11:05:00 | AAPL | Stock | 1.6307 | 1.6307 | 1.6293 | 1.6304 | 1717520.0 |
| 2005-08-26 11:10:00 | AAPL | Stock | 1.6304 | 1.6314 | 1.63 | 1.6314 | 792316.0 |
| 2005-08-26 11:15:00 | AAPL | Stock | 1.6311 | 1.6314 | 1.6293 | 1.6296 | 1861020.0 |
| 2005-08-26 11:20:00 | AAPL | Stock | 1.6293 | 1.63 | 1.6289 | 1.63 | 2121952.0 |
| 2005-08-26 11:25:00 | AAPL | Stock | 1.6296 | 1.6296 | 1.6268 | 1.6279 | 2767184.0 |
| 2005-08-26 11:30:00 | AAPL | Stock | 1.6279 | 1.63 | 1.6278 | 1.6293 | 1756244.0 |
| 2005-08-26 11:35:00 | AAPL | Stock | 1.6293 | 1.63 | 1.6275 | 1.6296 | 1731660.0 |
| 2005-08-26 11:40:00 | AAPL | Stock | 1.6293 | 1.6318 | 1.6293 | 1.6311 | 2024680.0 |
| 2005-08-26 11:45:00 | AAPL | Stock | 1.6311 | 1.6311 | 1.6289 | 1.6296 | 1456588.0 |
| 2005-08-26 11:50:00 | AAPL | Stock | 1.6296 | 1.6311 | 1.6289 | 1.6293 | 1262800.0 |
| 2005-08-26 11:55:00 | AAPL | Stock | 1.6293 | 1.6307 | 1.6293 | 1.6304 | 910532.0 |
| 2005-08-26 12:00:00 | AAPL | Stock | 1.6307 | 1.6339 | 1.6307 | 1.6336 | 3198608.0 |
| 2005-08-26 12:05:00 | AAPL | Stock | 1.6332 | 1.6332 | 1.6314 | 1.6318 | 1977220.0 |
| 2005-08-26 12:10:00 | AAPL | Stock | 1.6321 | 1.6368 | 1.6318 | 1.6357 | 2955568.0 |
| 2005-08-26 12:15:00 | AAPL | Stock | 1.6357 | 1.64 | 1.6357 | 1.6396 | 5998944.0 |
| 2005-08-26 12:20:00 | AAPL | Stock | 1.6396 | 1.64 | 1.6386 | 1.6386 | 4615352.0 |
| 2005-08-26 12:25:00 | AAPL | Stock | 1.6393 | 1.6396 | 1.6386 | 1.6396 | 2724764.0 |
| 2005-08-26 12:30:00 | AAPL | Stock | 1.6396 | 1.6396 | 1.6386 | 1.6386 | 752136.0 |
| 2005-08-26 12:35:00 | AAPL | Stock | 1.6386 | 1.6386 | 1.6382 | 1.6386 | 1151108.0 |
| 2005-08-26 12:40:00 | AAPL | Stock | 1.6382 | 1.6386 | 1.6382 | 1.6386 | 991956.0 |
| 2005-08-26 12:45:00 | AAPL | Stock | 1.6386 | 1.6389 | 1.6382 | 1.6386 | 3301648.0 |
| 2005-08-26 12:50:00 | AAPL | Stock | 1.6386 | 1.6386 | 1.6368 | 1.6371 | 1556016.0 |
> showing 50 of 194,975 rows — these rows as CSV