PREVIEW / stock_5min / 2009-03-23
file: by_date/stock_5min/2009/2009-03-23.parquet size: 4.6 MB rows: 315,649 symbols: 3,335
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-03-23 04:15:00 | AAPL | Stock | 3.7018 | 3.7018 | 3.7018 | 3.7018 | 5600.0 |
| 2009-03-23 06:55:00 | AAPL | Stock | 3.6989 | 3.6989 | 3.6986 | 3.6986 | 5600.0 |
| 2009-03-23 07:00:00 | AAPL | Stock | 3.7179 | 3.7179 | 3.7179 | 3.7179 | 5600.0 |
| 2009-03-23 07:05:00 | AAPL | Stock | 3.6989 | 3.6989 | 3.6989 | 3.6989 | 2800.0 |
| 2009-03-23 07:15:00 | AAPL | Stock | 3.6768 | 3.6786 | 3.6768 | 3.6786 | 56000.0 |
| 2009-03-23 07:20:00 | AAPL | Stock | 3.6786 | 3.6875 | 3.6786 | 3.6786 | 109200.0 |
| 2009-03-23 07:25:00 | AAPL | Stock | 3.6786 | 3.6875 | 3.675 | 3.6875 | 29400.0 |
| 2009-03-23 07:45:00 | AAPL | Stock | 3.6875 | 3.6875 | 3.6821 | 3.6821 | 67116.0 |
| 2009-03-23 07:50:00 | AAPL | Stock | 3.6786 | 3.6854 | 3.6786 | 3.6854 | 13916.0 |
| 2009-03-23 07:55:00 | AAPL | Stock | 3.6854 | 3.6857 | 3.6854 | 3.6857 | 22372.0 |
| 2009-03-23 08:00:00 | AAPL | Stock | 3.6857 | 3.6964 | 3.6839 | 3.6875 | 328384.0 |
| 2009-03-23 08:05:00 | AAPL | Stock | 3.6879 | 3.6939 | 3.6857 | 3.6875 | 71120.0 |
| 2009-03-23 08:10:00 | AAPL | Stock | 3.6875 | 3.6875 | 3.6786 | 3.6825 | 323988.0 |
| 2009-03-23 08:15:00 | AAPL | Stock | 3.6821 | 3.6854 | 3.6796 | 3.6821 | 169540.0 |
| 2009-03-23 08:20:00 | AAPL | Stock | 3.6857 | 3.6918 | 3.6786 | 3.6786 | 122388.0 |
| 2009-03-23 08:25:00 | AAPL | Stock | 3.6864 | 3.6864 | 3.6754 | 3.6754 | 149464.0 |
| 2009-03-23 08:30:00 | AAPL | Stock | 3.675 | 3.6786 | 3.6732 | 3.6786 | 225064.0 |
| 2009-03-23 08:35:00 | AAPL | Stock | 3.6786 | 3.6786 | 3.6768 | 3.6768 | 28000.0 |
| 2009-03-23 08:40:00 | AAPL | Stock | 3.675 | 3.6854 | 3.6739 | 3.6789 | 298844.0 |
| 2009-03-23 08:45:00 | AAPL | Stock | 3.6854 | 3.6904 | 3.6814 | 3.6818 | 147280.0 |
| 2009-03-23 08:50:00 | AAPL | Stock | 3.6854 | 3.6857 | 3.6811 | 3.6839 | 109004.0 |
| 2009-03-23 08:55:00 | AAPL | Stock | 3.6836 | 3.6836 | 3.6821 | 3.6821 | 19600.0 |
| 2009-03-23 09:00:00 | AAPL | Stock | 3.6832 | 3.6914 | 3.6832 | 3.6914 | 274400.0 |
| 2009-03-23 09:05:00 | AAPL | Stock | 3.6921 | 3.6921 | 3.6871 | 3.6907 | 78400.0 |
| 2009-03-23 09:10:00 | AAPL | Stock | 3.6875 | 3.6875 | 3.6786 | 3.68 | 245336.0 |
| 2009-03-23 09:15:00 | AAPL | Stock | 3.6714 | 3.6754 | 3.6611 | 3.675 | 351484.0 |
| 2009-03-23 09:20:00 | AAPL | Stock | 3.6761 | 3.6761 | 3.6714 | 3.6714 | 75936.0 |
| 2009-03-23 09:25:00 | AAPL | Stock | 3.6714 | 3.6714 | 3.6661 | 3.6675 | 176400.0 |
| 2009-03-23 09:30:00 | AAPL | Stock | 3.6696 | 3.6893 | 3.6339 | 3.655 | 20142052.0 |
| 2009-03-23 09:35:00 | AAPL | Stock | 3.6536 | 3.6939 | 3.6464 | 3.6782 | 15617840.0 |
| 2009-03-23 09:40:00 | AAPL | Stock | 3.6771 | 3.6839 | 3.665 | 3.67 | 11957120.0 |
| 2009-03-23 09:45:00 | AAPL | Stock | 3.6704 | 3.6768 | 3.6589 | 3.6721 | 9451904.0 |
| 2009-03-23 09:50:00 | AAPL | Stock | 3.6724 | 3.6724 | 3.6475 | 3.6632 | 13003564.0 |
| 2009-03-23 09:55:00 | AAPL | Stock | 3.6636 | 3.7 | 3.6636 | 3.6925 | 17521896.0 |
| 2009-03-23 10:00:00 | AAPL | Stock | 3.6929 | 3.7179 | 3.6925 | 3.7132 | 17102316.0 |
| 2009-03-23 10:05:00 | AAPL | Stock | 3.7132 | 3.7282 | 3.705 | 3.7275 | 13406820.0 |
| 2009-03-23 10:10:00 | AAPL | Stock | 3.7275 | 3.7354 | 3.714 | 3.7157 | 12590704.0 |
| 2009-03-23 10:15:00 | AAPL | Stock | 3.7157 | 3.7289 | 3.7154 | 3.7218 | 11152260.0 |
| 2009-03-23 10:20:00 | AAPL | Stock | 3.7207 | 3.7307 | 3.7207 | 3.7221 | 6907544.0 |
| 2009-03-23 10:25:00 | AAPL | Stock | 3.7221 | 3.7311 | 3.72 | 3.7225 | 6716948.0 |
| 2009-03-23 10:30:00 | AAPL | Stock | 3.7232 | 3.7411 | 3.7204 | 3.7368 | 8851332.0 |
| 2009-03-23 10:35:00 | AAPL | Stock | 3.7368 | 3.7461 | 3.7321 | 3.7338 | 8519448.0 |
| 2009-03-23 10:40:00 | AAPL | Stock | 3.7332 | 3.7414 | 3.7297 | 3.7368 | 6782356.0 |
| 2009-03-23 10:45:00 | AAPL | Stock | 3.7371 | 3.7407 | 3.7261 | 3.7339 | 6368488.0 |
| 2009-03-23 10:50:00 | AAPL | Stock | 3.7343 | 3.7382 | 3.7311 | 3.7361 | 4479832.0 |
| 2009-03-23 10:55:00 | AAPL | Stock | 3.7361 | 3.7468 | 3.7357 | 3.7418 | 5908224.0 |
| 2009-03-23 11:00:00 | AAPL | Stock | 3.7414 | 3.7486 | 3.7407 | 3.7461 | 5546716.0 |
| 2009-03-23 11:05:00 | AAPL | Stock | 3.7461 | 3.7496 | 3.746 | 3.7489 | 6674024.0 |
| 2009-03-23 11:10:00 | AAPL | Stock | 3.7492 | 3.7493 | 3.7436 | 3.7471 | 4462192.0 |
| 2009-03-23 11:15:00 | AAPL | Stock | 3.7471 | 3.7493 | 3.7439 | 3.745 | 4857720.0 |
> showing 50 of 315,649 rows — these rows as CSV