PREVIEW / stock_30min / 2009-03-23
file: by_date/stock_30min/2009/2009-03-23.parquet size: 1.3 MB rows: 71,991 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:00:00 | AAPL | Stock | 3.7018 | 3.7018 | 3.7018 | 3.7018 | 5600.0 |
| 2009-03-23 06:30: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.675 | 3.6875 | 203000.0 |
| 2009-03-23 07:30:00 | AAPL | Stock | 3.6875 | 3.6875 | 3.6786 | 3.6857 | 103404.0 |
| 2009-03-23 08:00:00 | AAPL | Stock | 3.6857 | 3.6964 | 3.6754 | 3.6754 | 1164884.0 |
| 2009-03-23 08:30:00 | AAPL | Stock | 3.675 | 3.6904 | 3.6732 | 3.6821 | 827792.0 |
| 2009-03-23 09:00:00 | AAPL | Stock | 3.6832 | 3.6921 | 3.6611 | 3.6675 | 1201956.0 |
| 2009-03-23 09:30:00 | AAPL | Stock | 3.6696 | 3.7 | 3.6339 | 3.6925 | 87694376.0 |
| 2009-03-23 10:00:00 | AAPL | Stock | 3.6929 | 3.7354 | 3.6925 | 3.7225 | 67876592.0 |
| 2009-03-23 10:30:00 | AAPL | Stock | 3.7232 | 3.7468 | 3.7204 | 3.7418 | 40909680.0 |
| 2009-03-23 11:00:00 | AAPL | Stock | 3.7414 | 3.7496 | 3.7407 | 3.7464 | 30633764.0 |
| 2009-03-23 11:30:00 | AAPL | Stock | 3.7464 | 3.7654 | 3.7429 | 3.7625 | 50344252.0 |
| 2009-03-23 12:00:00 | AAPL | Stock | 3.7626 | 3.7743 | 3.7504 | 3.7586 | 32268124.0 |
| 2009-03-23 12:30:00 | AAPL | Stock | 3.7586 | 3.7611 | 3.7418 | 3.7454 | 21898128.0 |
| 2009-03-23 13:00:00 | AAPL | Stock | 3.7454 | 3.7664 | 3.7389 | 3.7396 | 27557180.0 |
| 2009-03-23 13:30:00 | AAPL | Stock | 3.7396 | 3.7461 | 3.7289 | 3.7452 | 27868512.0 |
| 2009-03-23 14:00:00 | AAPL | Stock | 3.7439 | 3.7579 | 3.7339 | 3.7537 | 26020428.0 |
| 2009-03-23 14:30:00 | AAPL | Stock | 3.7536 | 3.7814 | 3.75 | 3.7786 | 39731580.0 |
| 2009-03-23 15:00:00 | AAPL | Stock | 3.7786 | 3.7932 | 3.7707 | 3.7864 | 57764056.0 |
| 2009-03-23 15:30:00 | AAPL | Stock | 3.7864 | 3.8629 | 3.7754 | 3.8432 | 101587640.0 |
| 2009-03-23 16:00:00 | AAPL | Stock | 3.8429 | 3.8454 | 3.748 | 3.8339 | 30757972.0 |
| 2009-03-23 16:30:00 | AAPL | Stock | 3.8343 | 3.8521 | 3.8325 | 3.8454 | 5071640.0 |
| 2009-03-23 17:00:00 | AAPL | Stock | 3.8429 | 3.8429 | 3.8275 | 3.8311 | 225204.0 |
| 2009-03-23 17:30:00 | AAPL | Stock | 3.8343 | 3.8393 | 3.8293 | 3.83 | 97720.0 |
| 2009-03-23 18:00:00 | AAPL | Stock | 3.845 | 3.8464 | 3.8339 | 3.8396 | 8012732.0 |
| 2009-03-23 18:30:00 | AAPL | Stock | 3.8464 | 3.8464 | 3.8396 | 3.8429 | 26432.0 |
| 2009-03-23 19:00:00 | AAPL | Stock | 3.8489 | 3.8496 | 3.8396 | 3.8429 | 53004.0 |
| 2009-03-23 19:30:00 | AAPL | Stock | 3.8429 | 3.8429 | 3.8354 | 3.8357 | 88480.0 |
| 2009-03-23 05:00:00 | MSFT | Stock | 17.3 | 17.3 | 17.3 | 17.3 | 500.0 |
| 2009-03-23 07:00:00 | MSFT | Stock | 17.31 | 17.31 | 17.28 | 17.28 | 1200.0 |
| 2009-03-23 07:30:00 | MSFT | Stock | 17.51 | 17.51 | 17.3 | 17.4 | 1300.0 |
| 2009-03-23 08:00:00 | MSFT | Stock | 17.35 | 17.43 | 17.32 | 17.38 | 12995.0 |
| 2009-03-23 08:30:00 | MSFT | Stock | 17.38 | 17.4 | 17.35 | 17.35 | 39400.0 |
| 2009-03-23 09:00:00 | MSFT | Stock | 17.4 | 17.44 | 17.38 | 17.43 | 22447.0 |
| 2009-03-23 09:30:00 | MSFT | Stock | 17.42 | 17.49 | 17.31 | 17.47 | 6830955.0 |
| 2009-03-23 10:00:00 | MSFT | Stock | 17.47 | 17.71 | 17.47 | 17.64 | 6004587.0 |
| 2009-03-23 10:30:00 | MSFT | Stock | 17.64 | 17.75 | 17.61 | 17.683 | 4289945.0 |
| 2009-03-23 11:00:00 | MSFT | Stock | 17.69 | 17.73 | 17.64 | 17.658 | 2257078.0 |
| 2009-03-23 11:30:00 | MSFT | Stock | 17.66 | 17.83 | 17.651 | 17.8 | 2952766.0 |
| 2009-03-23 12:00:00 | MSFT | Stock | 17.82 | 17.83 | 17.69 | 17.81 | 3084810.0 |
| 2009-03-23 12:30:00 | MSFT | Stock | 17.81 | 17.85 | 17.76 | 17.78 | 2610180.0 |
| 2009-03-23 13:00:00 | MSFT | Stock | 17.78 | 17.88 | 17.68 | 17.7 | 2797365.0 |
| 2009-03-23 13:30:00 | MSFT | Stock | 17.7 | 17.74 | 17.61 | 17.72 | 2252351.0 |
| 2009-03-23 14:00:00 | MSFT | Stock | 17.72 | 17.75 | 17.64 | 17.744 | 2057388.0 |
| 2009-03-23 14:30:00 | MSFT | Stock | 17.74 | 17.94 | 17.73 | 17.92 | 4061830.0 |
| 2009-03-23 15:00:00 | MSFT | Stock | 17.91 | 18.0 | 17.85 | 17.99 | 6516317.0 |
| 2009-03-23 15:30:00 | MSFT | Stock | 17.98 | 18.35 | 17.98 | 18.34 | 14531838.0 |
| 2009-03-23 16:00:00 | MSFT | Stock | 18.35 | 18.59 | 17.785 | 18.23 | 9371002.0 |
| 2009-03-23 16:30:00 | MSFT | Stock | 18.24 | 18.33 | 18.2 | 18.26 | 752416.0 |
| 2009-03-23 17:00:00 | MSFT | Stock | 18.26 | 18.27 | 17.995 | 18.25 | 25900.0 |
> showing 50 of 71,991 rows — these rows as CSV