PREVIEW / stock_5min / 2013-08-27
file: by_date/stock_5min/2013/2013-08-27.parquet size: 5.3 MB rows: 352,395 symbols: 3,522
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 |
|---|---|---|---|---|---|---|---|
| 2013-08-27 04:00:00 | AAPL | Stock | 17.9632 | 17.9632 | 17.9561 | 17.9561 | 39200.0 |
| 2013-08-27 04:10:00 | AAPL | Stock | 17.9643 | 17.9643 | 17.9643 | 17.9643 | 19320.0 |
| 2013-08-27 04:15:00 | AAPL | Stock | 17.9107 | 17.9107 | 17.9107 | 17.9107 | 2800.0 |
| 2013-08-27 04:30:00 | AAPL | Stock | 17.8743 | 17.8743 | 17.8743 | 17.8743 | 11200.0 |
| 2013-08-27 04:50:00 | AAPL | Stock | 17.8518 | 17.8518 | 17.8518 | 17.8518 | 11704.0 |
| 2013-08-27 04:55:00 | AAPL | Stock | 17.8518 | 17.8525 | 17.8511 | 17.8511 | 27832.0 |
| 2013-08-27 05:00:00 | AAPL | Stock | 17.85 | 17.85 | 17.85 | 17.85 | 5516.0 |
| 2013-08-27 05:40:00 | AAPL | Stock | 17.8568 | 17.8568 | 17.8411 | 17.8411 | 5600.0 |
| 2013-08-27 05:50:00 | AAPL | Stock | 17.8214 | 17.8214 | 17.8214 | 17.8214 | 2856.0 |
| 2013-08-27 06:10:00 | AAPL | Stock | 17.8229 | 17.8229 | 17.8229 | 17.8229 | 2800.0 |
| 2013-08-27 06:30:00 | AAPL | Stock | 17.8064 | 17.8064 | 17.8036 | 17.8036 | 28000.0 |
| 2013-08-27 06:35:00 | AAPL | Stock | 17.8036 | 17.8036 | 17.8032 | 17.8032 | 5600.0 |
| 2013-08-27 06:40:00 | AAPL | Stock | 17.7604 | 17.7604 | 17.7143 | 17.7143 | 25340.0 |
| 2013-08-27 06:45:00 | AAPL | Stock | 17.7425 | 17.7425 | 17.6811 | 17.7321 | 53200.0 |
| 2013-08-27 06:50:00 | AAPL | Stock | 17.7143 | 17.725 | 17.7089 | 17.7143 | 56000.0 |
| 2013-08-27 06:55:00 | AAPL | Stock | 17.7321 | 17.7464 | 17.7214 | 17.7464 | 49980.0 |
| 2013-08-27 07:00:00 | AAPL | Stock | 17.7411 | 17.7464 | 17.7411 | 17.7429 | 21000.0 |
| 2013-08-27 07:05:00 | AAPL | Stock | 17.7596 | 17.7646 | 17.7482 | 17.75 | 213808.0 |
| 2013-08-27 07:10:00 | AAPL | Stock | 17.7464 | 17.8021 | 17.7464 | 17.8021 | 84140.0 |
| 2013-08-27 07:15:00 | AAPL | Stock | 17.8 | 17.8125 | 17.7861 | 17.8036 | 84084.0 |
| 2013-08-27 07:20:00 | AAPL | Stock | 17.8089 | 17.8214 | 17.8089 | 17.8204 | 76160.0 |
| 2013-08-27 07:25:00 | AAPL | Stock | 17.8218 | 17.8218 | 17.7857 | 17.7868 | 323988.0 |
| 2013-08-27 07:30:00 | AAPL | Stock | 17.7875 | 17.8036 | 17.7707 | 17.7707 | 91280.0 |
| 2013-08-27 07:35:00 | AAPL | Stock | 17.7857 | 17.7857 | 17.7775 | 17.7775 | 20160.0 |
| 2013-08-27 07:40:00 | AAPL | Stock | 17.775 | 17.775 | 17.75 | 17.7546 | 93912.0 |
| 2013-08-27 07:45:00 | AAPL | Stock | 17.7636 | 17.7857 | 17.7636 | 17.785 | 57988.0 |
| 2013-08-27 07:50:00 | AAPL | Stock | 17.7814 | 17.8029 | 17.7786 | 17.8029 | 33600.0 |
| 2013-08-27 07:55:00 | AAPL | Stock | 17.8014 | 17.8018 | 17.7946 | 17.7946 | 44212.0 |
| 2013-08-27 08:00:00 | AAPL | Stock | 17.8 | 17.8343 | 17.7411 | 17.8343 | 387156.0 |
| 2013-08-27 08:05:00 | AAPL | Stock | 17.8221 | 17.8571 | 17.8125 | 17.8325 | 310268.0 |
| 2013-08-27 08:10:00 | AAPL | Stock | 17.835 | 17.8482 | 17.8304 | 17.8304 | 90384.0 |
| 2013-08-27 08:15:00 | AAPL | Stock | 17.8318 | 17.8393 | 17.8179 | 17.8232 | 284900.0 |
| 2013-08-27 08:20:00 | AAPL | Stock | 17.8232 | 17.8371 | 17.8214 | 17.8304 | 92820.0 |
| 2013-08-27 08:25:00 | AAPL | Stock | 17.8311 | 17.8311 | 17.8018 | 17.8071 | 216860.0 |
| 2013-08-27 08:30:00 | AAPL | Stock | 17.8096 | 17.8096 | 17.7868 | 17.7918 | 139804.0 |
| 2013-08-27 08:35:00 | AAPL | Stock | 17.7982 | 17.8214 | 17.7946 | 17.8189 | 125384.0 |
| 2013-08-27 08:40:00 | AAPL | Stock | 17.8189 | 17.8257 | 17.8039 | 17.8118 | 194880.0 |
| 2013-08-27 08:45:00 | AAPL | Stock | 17.8107 | 17.8193 | 17.7893 | 17.7975 | 236964.0 |
| 2013-08-27 08:50:00 | AAPL | Stock | 17.7929 | 17.8036 | 17.7896 | 17.7907 | 220920.0 |
| 2013-08-27 08:55:00 | AAPL | Stock | 17.7929 | 17.8143 | 17.7929 | 17.8071 | 442568.0 |
| 2013-08-27 09:00:00 | AAPL | Stock | 17.81 | 17.8132 | 17.7989 | 17.8132 | 71568.0 |
| 2013-08-27 09:05:00 | AAPL | Stock | 17.8071 | 17.8143 | 17.7914 | 17.7929 | 124488.0 |
| 2013-08-27 09:10:00 | AAPL | Stock | 17.7911 | 17.8071 | 17.7879 | 17.8046 | 206080.0 |
| 2013-08-27 09:15:00 | AAPL | Stock | 17.8111 | 17.8121 | 17.7882 | 17.7929 | 134568.0 |
| 2013-08-27 09:20:00 | AAPL | Stock | 17.79 | 17.8018 | 17.7804 | 17.7918 | 293356.0 |
| 2013-08-27 09:25:00 | AAPL | Stock | 17.7893 | 17.7964 | 17.7704 | 17.7843 | 286748.0 |
| 2013-08-27 09:30:00 | AAPL | Stock | 17.7711 | 17.9004 | 17.7582 | 17.8857 | 17215940.0 |
| 2013-08-27 09:35:00 | AAPL | Stock | 17.8832 | 17.9264 | 17.8636 | 17.8979 | 10397828.0 |
| 2013-08-27 09:40:00 | AAPL | Stock | 17.895 | 17.9004 | 17.8364 | 17.8682 | 10193988.0 |
| 2013-08-27 09:45:00 | AAPL | Stock | 17.8675 | 17.8993 | 17.8393 | 17.8404 | 8815464.0 |
> showing 50 of 352,395 rows — these rows as CSV