PREVIEW / stock_5min / 2011-07-11
file: by_date/stock_5min/2011/2011-07-11.parquet size: 4.8 MB rows: 331,070 symbols: 3,545
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 |
|---|---|---|---|---|---|---|---|
| 2011-07-11 04:25:00 | AAPL | Stock | 12.7179 | 12.7179 | 12.7179 | 12.7179 | 16800.0 |
| 2011-07-11 04:30:00 | AAPL | Stock | 12.7225 | 12.7411 | 12.7225 | 12.7411 | 6300.0 |
| 2011-07-11 04:40:00 | AAPL | Stock | 12.7271 | 12.7271 | 12.7271 | 12.7271 | 2800.0 |
| 2011-07-11 04:55:00 | AAPL | Stock | 12.72 | 12.7204 | 12.72 | 12.7204 | 5600.0 |
| 2011-07-11 05:00:00 | AAPL | Stock | 12.7161 | 12.7161 | 12.7161 | 12.7161 | 2800.0 |
| 2011-07-11 05:30:00 | AAPL | Stock | 12.7179 | 12.7179 | 12.7179 | 12.7179 | 2800.0 |
| 2011-07-11 05:40:00 | AAPL | Stock | 12.6964 | 12.6964 | 12.6929 | 12.6929 | 19600.0 |
| 2011-07-11 05:45:00 | AAPL | Stock | 12.6911 | 12.6911 | 12.6911 | 12.6911 | 14000.0 |
| 2011-07-11 05:55:00 | AAPL | Stock | 12.6929 | 12.6929 | 12.6929 | 12.6929 | 5600.0 |
| 2011-07-11 06:00:00 | AAPL | Stock | 12.7061 | 12.7125 | 12.7061 | 12.7125 | 30800.0 |
| 2011-07-11 06:05:00 | AAPL | Stock | 12.7125 | 12.7129 | 12.7125 | 12.7125 | 19600.0 |
| 2011-07-11 06:10:00 | AAPL | Stock | 12.7107 | 12.7107 | 12.7107 | 12.7107 | 5600.0 |
| 2011-07-11 06:15:00 | AAPL | Stock | 12.7182 | 12.7182 | 12.7182 | 12.7182 | 5600.0 |
| 2011-07-11 06:35:00 | AAPL | Stock | 12.7382 | 12.7382 | 12.7382 | 12.7382 | 5600.0 |
| 2011-07-11 06:45:00 | AAPL | Stock | 12.7321 | 12.7321 | 12.7321 | 12.7321 | 8400.0 |
| 2011-07-11 06:55:00 | AAPL | Stock | 12.7429 | 12.7429 | 12.7429 | 12.7429 | 2800.0 |
| 2011-07-11 07:00:00 | AAPL | Stock | 12.7418 | 12.7607 | 12.7418 | 12.7607 | 25200.0 |
| 2011-07-11 07:05:00 | AAPL | Stock | 12.7554 | 12.7739 | 12.7554 | 12.7607 | 50120.0 |
| 2011-07-11 07:10:00 | AAPL | Stock | 12.75 | 12.75 | 12.7411 | 12.7436 | 11200.0 |
| 2011-07-11 07:15:00 | AAPL | Stock | 12.7421 | 12.7529 | 12.7396 | 12.7496 | 51044.0 |
| 2011-07-11 07:20:00 | AAPL | Stock | 12.7396 | 12.7479 | 12.7393 | 12.7479 | 85512.0 |
| 2011-07-11 07:25:00 | AAPL | Stock | 12.7464 | 12.7539 | 12.7464 | 12.75 | 38696.0 |
| 2011-07-11 07:30:00 | AAPL | Stock | 12.75 | 12.7639 | 12.75 | 12.75 | 128884.0 |
| 2011-07-11 07:35:00 | AAPL | Stock | 12.7507 | 12.7507 | 12.75 | 12.75 | 18368.0 |
| 2011-07-11 07:40:00 | AAPL | Stock | 12.7446 | 12.75 | 12.7446 | 12.7446 | 19432.0 |
| 2011-07-11 07:45:00 | AAPL | Stock | 12.7446 | 12.75 | 12.7236 | 12.7236 | 125048.0 |
| 2011-07-11 07:50:00 | AAPL | Stock | 12.725 | 12.7414 | 12.7239 | 12.7379 | 90160.0 |
| 2011-07-11 07:55:00 | AAPL | Stock | 12.7339 | 12.7425 | 12.7229 | 12.7357 | 224280.0 |
| 2011-07-11 08:00:00 | AAPL | Stock | 12.7396 | 12.7661 | 12.7321 | 12.7661 | 300440.0 |
| 2011-07-11 08:05:00 | AAPL | Stock | 12.7679 | 12.7679 | 12.7496 | 12.75 | 288736.0 |
| 2011-07-11 08:10:00 | AAPL | Stock | 12.75 | 12.75 | 12.7321 | 12.7339 | 542612.0 |
| 2011-07-11 08:15:00 | AAPL | Stock | 12.7357 | 12.7393 | 12.7143 | 12.7357 | 288288.0 |
| 2011-07-11 08:20:00 | AAPL | Stock | 12.7379 | 12.7411 | 12.7282 | 12.7393 | 67760.0 |
| 2011-07-11 08:25:00 | AAPL | Stock | 12.7411 | 12.7411 | 12.7325 | 12.7357 | 42000.0 |
| 2011-07-11 08:30:00 | AAPL | Stock | 12.7321 | 12.7475 | 12.7282 | 12.7464 | 128100.0 |
| 2011-07-11 08:35:00 | AAPL | Stock | 12.7464 | 12.7475 | 12.7286 | 12.7286 | 237860.0 |
| 2011-07-11 08:40:00 | AAPL | Stock | 12.735 | 12.7482 | 12.7311 | 12.7361 | 69692.0 |
| 2011-07-11 08:45:00 | AAPL | Stock | 12.74 | 12.7418 | 12.73 | 12.7375 | 89740.0 |
| 2011-07-11 08:50:00 | AAPL | Stock | 12.7393 | 12.75 | 12.7375 | 12.7493 | 118244.0 |
| 2011-07-11 08:55:00 | AAPL | Stock | 12.7518 | 12.7536 | 12.7464 | 12.75 | 65828.0 |
| 2011-07-11 09:00:00 | AAPL | Stock | 12.7471 | 12.7536 | 12.74 | 12.7464 | 181216.0 |
| 2011-07-11 09:05:00 | AAPL | Stock | 12.7464 | 12.7529 | 12.7321 | 12.7518 | 160608.0 |
| 2011-07-11 09:10:00 | AAPL | Stock | 12.7507 | 12.7536 | 12.7482 | 12.75 | 220416.0 |
| 2011-07-11 09:15:00 | AAPL | Stock | 12.7464 | 12.7536 | 12.7336 | 12.7336 | 441448.0 |
| 2011-07-11 09:20:00 | AAPL | Stock | 12.7357 | 12.7464 | 12.7336 | 12.7457 | 95200.0 |
| 2011-07-11 09:25:00 | AAPL | Stock | 12.7457 | 12.7464 | 12.7261 | 12.7304 | 327152.0 |
| 2011-07-11 09:30:00 | AAPL | Stock | 12.7264 | 12.8061 | 12.7182 | 12.7968 | 20180384.0 |
| 2011-07-11 09:35:00 | AAPL | Stock | 12.7968 | 12.8036 | 12.7621 | 12.7826 | 11615016.0 |
| 2011-07-11 09:40:00 | AAPL | Stock | 12.7828 | 12.8389 | 12.7736 | 12.8339 | 13637792.0 |
| 2011-07-11 09:45:00 | AAPL | Stock | 12.8336 | 12.8407 | 12.8068 | 12.8159 | 11994864.0 |
> showing 50 of 331,070 rows — these rows as CSV