PREVIEW / stock_5min / 2009-07-27
file: by_date/stock_5min/2009/2009-07-27.parquet size: 4.5 MB rows: 314,719 symbols: 3,349
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 |
|---|---|---|---|---|---|---|---|
| 2009-07-27 07:00:00 | AAPL | Stock | 5.7511 | 5.7511 | 5.7511 | 5.7511 | 8400.0 |
| 2009-07-27 07:05:00 | AAPL | Stock | 5.7607 | 5.7607 | 5.7607 | 5.7607 | 11200.0 |
| 2009-07-27 07:10:00 | AAPL | Stock | 5.7629 | 5.7629 | 5.7629 | 5.7629 | 2800.0 |
| 2009-07-27 07:25:00 | AAPL | Stock | 5.7596 | 5.7596 | 5.7596 | 5.7596 | 28000.0 |
| 2009-07-27 07:30:00 | AAPL | Stock | 5.7514 | 5.7514 | 5.7464 | 5.7464 | 92960.0 |
| 2009-07-27 07:40:00 | AAPL | Stock | 5.7464 | 5.7675 | 5.7464 | 5.7504 | 47600.0 |
| 2009-07-27 07:50:00 | AAPL | Stock | 5.7486 | 5.7486 | 5.7486 | 5.7486 | 14000.0 |
| 2009-07-27 07:55:00 | AAPL | Stock | 5.7493 | 5.7493 | 5.7446 | 5.7464 | 28000.0 |
| 2009-07-27 08:00:00 | AAPL | Stock | 5.7493 | 5.7504 | 5.7382 | 5.7382 | 957572.0 |
| 2009-07-27 08:05:00 | AAPL | Stock | 5.7382 | 5.7389 | 5.7332 | 5.7357 | 144620.0 |
| 2009-07-27 08:10:00 | AAPL | Stock | 5.7375 | 5.7407 | 5.7357 | 5.7396 | 90972.0 |
| 2009-07-27 08:15:00 | AAPL | Stock | 5.7404 | 5.7429 | 5.7404 | 5.7418 | 103600.0 |
| 2009-07-27 08:20:00 | AAPL | Stock | 5.7429 | 5.7454 | 5.7411 | 5.7439 | 95760.0 |
| 2009-07-27 08:25:00 | AAPL | Stock | 5.7446 | 5.7446 | 5.7321 | 5.7375 | 251860.0 |
| 2009-07-27 08:30:00 | AAPL | Stock | 5.7386 | 5.7411 | 5.7375 | 5.7382 | 31640.0 |
| 2009-07-27 08:35:00 | AAPL | Stock | 5.7379 | 5.7379 | 5.7214 | 5.725 | 310912.0 |
| 2009-07-27 08:40:00 | AAPL | Stock | 5.725 | 5.7304 | 5.7204 | 5.7279 | 119784.0 |
| 2009-07-27 08:45:00 | AAPL | Stock | 5.7279 | 5.7321 | 5.7279 | 5.7311 | 23100.0 |
| 2009-07-27 08:50:00 | AAPL | Stock | 5.7311 | 5.7339 | 5.7286 | 5.7318 | 134400.0 |
| 2009-07-27 08:55:00 | AAPL | Stock | 5.7336 | 5.7339 | 5.73 | 5.7339 | 65660.0 |
| 2009-07-27 09:00:00 | AAPL | Stock | 5.7346 | 5.7357 | 5.7325 | 5.735 | 72800.0 |
| 2009-07-27 09:05:00 | AAPL | Stock | 5.735 | 5.735 | 5.7304 | 5.7304 | 92400.0 |
| 2009-07-27 09:10:00 | AAPL | Stock | 5.7321 | 5.735 | 5.7321 | 5.7332 | 90468.0 |
| 2009-07-27 09:15:00 | AAPL | Stock | 5.7321 | 5.7321 | 5.7143 | 5.7214 | 231980.0 |
| 2009-07-27 09:20:00 | AAPL | Stock | 5.7214 | 5.7429 | 5.7179 | 5.7382 | 525448.0 |
| 2009-07-27 09:25:00 | AAPL | Stock | 5.7382 | 5.7382 | 5.7146 | 5.7179 | 384160.0 |
| 2009-07-27 09:30:00 | AAPL | Stock | 5.7204 | 5.7379 | 5.7071 | 5.7175 | 22155196.0 |
| 2009-07-27 09:35:00 | AAPL | Stock | 5.7171 | 5.7261 | 5.6918 | 5.7039 | 13877332.0 |
| 2009-07-27 09:40:00 | AAPL | Stock | 5.7036 | 5.7457 | 5.7032 | 5.7386 | 13385148.0 |
| 2009-07-27 09:45:00 | AAPL | Stock | 5.7386 | 5.7429 | 5.7161 | 5.7264 | 9663948.0 |
| 2009-07-27 09:50:00 | AAPL | Stock | 5.7271 | 5.74 | 5.7114 | 5.7143 | 8889132.0 |
| 2009-07-27 09:55:00 | AAPL | Stock | 5.715 | 5.7154 | 5.6911 | 5.6971 | 10120768.0 |
| 2009-07-27 10:00:00 | AAPL | Stock | 5.6971 | 5.725 | 5.6964 | 5.6982 | 15061452.0 |
| 2009-07-27 10:05:00 | AAPL | Stock | 5.6982 | 5.7021 | 5.6757 | 5.6811 | 12480244.0 |
| 2009-07-27 10:10:00 | AAPL | Stock | 5.68 | 5.6889 | 5.6518 | 5.6518 | 12747448.0 |
| 2009-07-27 10:15:00 | AAPL | Stock | 5.6518 | 5.6668 | 5.6511 | 5.6579 | 8417444.0 |
| 2009-07-27 10:20:00 | AAPL | Stock | 5.6579 | 5.66 | 5.6468 | 5.6479 | 7791168.0 |
| 2009-07-27 10:25:00 | AAPL | Stock | 5.6475 | 5.6557 | 5.6429 | 5.65 | 8597148.0 |
| 2009-07-27 10:30:00 | AAPL | Stock | 5.6504 | 5.6532 | 5.6446 | 5.6479 | 5117140.0 |
| 2009-07-27 10:35:00 | AAPL | Stock | 5.6482 | 5.6493 | 5.6339 | 5.6389 | 6511652.0 |
| 2009-07-27 10:40:00 | AAPL | Stock | 5.6389 | 5.6389 | 5.6204 | 5.6239 | 9265284.0 |
| 2009-07-27 10:45:00 | AAPL | Stock | 5.6225 | 5.6339 | 5.6164 | 5.6325 | 8756692.0 |
| 2009-07-27 10:50:00 | AAPL | Stock | 5.6325 | 5.64 | 5.6304 | 5.64 | 4051684.0 |
| 2009-07-27 10:55:00 | AAPL | Stock | 5.64 | 5.6586 | 5.6321 | 5.6582 | 6223924.0 |
| 2009-07-27 11:00:00 | AAPL | Stock | 5.6582 | 5.6604 | 5.6536 | 5.6589 | 5410748.0 |
| 2009-07-27 11:05:00 | AAPL | Stock | 5.6589 | 5.6664 | 5.6554 | 5.6636 | 5945800.0 |
| 2009-07-27 11:10:00 | AAPL | Stock | 5.665 | 5.6743 | 5.6629 | 5.6732 | 6188980.0 |
| 2009-07-27 11:15:00 | AAPL | Stock | 5.6732 | 5.6814 | 5.6721 | 5.6784 | 7283836.0 |
| 2009-07-27 11:20:00 | AAPL | Stock | 5.6782 | 5.6871 | 5.6775 | 5.6793 | 6698440.0 |
| 2009-07-27 11:25:00 | AAPL | Stock | 5.6796 | 5.6914 | 5.6775 | 5.6818 | 6003760.0 |
> showing 50 of 314,719 rows — these rows as CSV