PREVIEW / stock_30min / 2009-10-19
file: by_date/stock_30min/2009/2009-10-19.parquet size: 1.3 MB rows: 71,899 symbols: 3,406
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-10-19 04:00:00 | AAPL | Stock | 6.7429 | 6.7607 | 6.7254 | 6.7282 | 104972.0 |
| 2009-10-19 05:00:00 | AAPL | Stock | 6.7496 | 6.7496 | 6.7379 | 6.7379 | 25200.0 |
| 2009-10-19 05:30:00 | AAPL | Stock | 6.7286 | 6.7286 | 6.7286 | 6.7286 | 5600.0 |
| 2009-10-19 06:00:00 | AAPL | Stock | 6.7279 | 6.7429 | 6.725 | 6.7429 | 139664.0 |
| 2009-10-19 06:30:00 | AAPL | Stock | 6.7357 | 6.7411 | 6.7321 | 6.7321 | 44800.0 |
| 2009-10-19 07:00:00 | AAPL | Stock | 6.7329 | 6.75 | 6.7321 | 6.7321 | 545328.0 |
| 2009-10-19 07:30:00 | AAPL | Stock | 6.7411 | 6.7411 | 6.7179 | 6.7179 | 364616.0 |
| 2009-10-19 08:00:00 | AAPL | Stock | 6.7286 | 6.7321 | 6.6821 | 6.7125 | 2802380.0 |
| 2009-10-19 08:30:00 | AAPL | Stock | 6.7161 | 6.7218 | 6.705 | 6.7143 | 1181852.0 |
| 2009-10-19 09:00:00 | AAPL | Stock | 6.7143 | 6.7143 | 6.7 | 6.7089 | 1303736.0 |
| 2009-10-19 09:30:00 | AAPL | Stock | 6.7089 | 6.71 | 6.6268 | 6.6604 | 99553552.0 |
| 2009-10-19 10:00:00 | AAPL | Stock | 6.6596 | 6.6821 | 6.645 | 6.6596 | 47346572.0 |
| 2009-10-19 10:30:00 | AAPL | Stock | 6.6582 | 6.7014 | 6.6571 | 6.6918 | 36496712.0 |
| 2009-10-19 11:00:00 | AAPL | Stock | 6.6918 | 6.7218 | 6.6896 | 6.7018 | 46342660.0 |
| 2009-10-19 11:30:00 | AAPL | Stock | 6.7018 | 6.7411 | 6.6379 | 6.7257 | 42304808.0 |
| 2009-10-19 12:00:00 | AAPL | Stock | 6.7264 | 6.7518 | 6.7204 | 6.7375 | 29045016.0 |
| 2009-10-19 12:30:00 | AAPL | Stock | 6.7386 | 6.7496 | 6.7357 | 6.7471 | 15844388.0 |
| 2009-10-19 13:00:00 | AAPL | Stock | 6.7471 | 6.7604 | 6.7393 | 6.7468 | 34317612.0 |
| 2009-10-19 13:30:00 | AAPL | Stock | 6.7471 | 6.7618 | 6.7254 | 6.7321 | 28160552.0 |
| 2009-10-19 14:00:00 | AAPL | Stock | 6.7321 | 6.735 | 6.6914 | 6.6983 | 48937812.0 |
| 2009-10-19 14:30:00 | AAPL | Stock | 6.6975 | 6.7032 | 6.6714 | 6.6854 | 42197876.0 |
| 2009-10-19 15:00:00 | AAPL | Stock | 6.6847 | 6.7261 | 6.6832 | 6.7136 | 60110232.0 |
| 2009-10-19 15:30:00 | AAPL | Stock | 6.7142 | 6.7857 | 6.7114 | 6.7843 | 130509736.0 |
| 2009-10-19 16:00:00 | AAPL | Stock | 6.7839 | 6.7975 | 6.7115 | 6.75 | 12973660.0 |
| 2009-10-19 16:30:00 | AAPL | Stock | 6.7475 | 7.3161 | 6.6929 | 7.255 | 168793828.0 |
| 2009-10-19 17:00:00 | AAPL | Stock | 7.255 | 7.255 | 6.7312 | 7.1893 | 43457148.0 |
| 2009-10-19 17:30:00 | AAPL | Stock | 7.1893 | 7.2271 | 7.1793 | 7.1889 | 17293080.0 |
| 2009-10-19 18:00:00 | AAPL | Stock | 7.1875 | 7.1986 | 6.7807 | 7.1571 | 10071376.0 |
| 2009-10-19 18:30:00 | AAPL | Stock | 7.1571 | 7.2089 | 7.1557 | 7.2036 | 5982732.0 |
| 2009-10-19 19:00:00 | AAPL | Stock | 7.2043 | 7.2196 | 7.2032 | 7.2096 | 3485244.0 |
| 2009-10-19 19:30:00 | AAPL | Stock | 7.2096 | 7.2318 | 7.2071 | 7.2286 | 3444224.0 |
| 2009-10-19 06:00:00 | MSFT | Stock | 26.75 | 26.75 | 26.75 | 26.75 | 100.0 |
| 2009-10-19 06:30:00 | MSFT | Stock | 26.75 | 26.75 | 26.75 | 26.75 | 200.0 |
| 2009-10-19 07:00:00 | MSFT | Stock | 26.73 | 26.73 | 26.7 | 26.71 | 2100.0 |
| 2009-10-19 08:00:00 | MSFT | Stock | 26.59 | 26.7 | 26.35 | 26.5 | 18981.0 |
| 2009-10-19 08:30:00 | MSFT | Stock | 26.54 | 26.54 | 26.36 | 26.52 | 31284.0 |
| 2009-10-19 09:00:00 | MSFT | Stock | 26.51 | 26.57 | 26.36 | 26.51 | 29309.0 |
| 2009-10-19 09:30:00 | MSFT | Stock | 26.51 | 26.58 | 26.25 | 26.27 | 4548877.0 |
| 2009-10-19 10:00:00 | MSFT | Stock | 26.27 | 26.44 | 26.25 | 26.435 | 3195848.0 |
| 2009-10-19 10:30:00 | MSFT | Stock | 26.44 | 26.51 | 26.41 | 26.43 | 2887072.0 |
| 2009-10-19 11:00:00 | MSFT | Stock | 26.43 | 26.48 | 26.37 | 26.473 | 2332368.0 |
| 2009-10-19 11:30:00 | MSFT | Stock | 26.47 | 26.55 | 26.47 | 26.52 | 2357356.0 |
| 2009-10-19 12:00:00 | MSFT | Stock | 26.52 | 26.52 | 26.43 | 26.432 | 1883342.0 |
| 2009-10-19 12:30:00 | MSFT | Stock | 26.43 | 26.45 | 26.36 | 26.365 | 3104030.0 |
| 2009-10-19 13:00:00 | MSFT | Stock | 26.36 | 26.39 | 26.27 | 26.33 | 4179985.0 |
| 2009-10-19 13:30:00 | MSFT | Stock | 26.32 | 26.37 | 26.26 | 26.29 | 3293236.0 |
| 2009-10-19 14:00:00 | MSFT | Stock | 26.29 | 26.33 | 26.28 | 26.3 | 1793117.0 |
| 2009-10-19 14:30:00 | MSFT | Stock | 26.31 | 26.32 | 26.28 | 26.31 | 2282962.0 |
| 2009-10-19 15:00:00 | MSFT | Stock | 26.3 | 26.32 | 26.26 | 26.31 | 3864958.0 |
| 2009-10-19 15:30:00 | MSFT | Stock | 26.3 | 26.38 | 26.29 | 26.35 | 6605126.0 |
> showing 50 of 71,899 rows — these rows as CSV