PREVIEW / stock_30min / 2009-01-05
file: by_date/stock_30min/2009/2009-01-05.parquet size: 1.3 MB rows: 70,033 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-01-05 07:00:00 | AAPL | Stock | 3.2486 | 3.2486 | 3.2486 | 3.2486 | 11200.0 |
| 2009-01-05 07:30:00 | AAPL | Stock | 3.2568 | 3.2568 | 3.2261 | 3.2261 | 148540.0 |
| 2009-01-05 08:00:00 | AAPL | Stock | 3.2332 | 3.2411 | 3.2107 | 3.2211 | 700000.0 |
| 2009-01-05 08:30:00 | AAPL | Stock | 3.2211 | 3.3554 | 3.2211 | 3.3471 | 29797600.0 |
| 2009-01-05 09:00:00 | AAPL | Stock | 3.3464 | 3.3607 | 3.3232 | 3.3279 | 12779368.0 |
| 2009-01-05 09:30:00 | AAPL | Stock | 3.3286 | 3.3771 | 3.3111 | 3.3375 | 205274748.0 |
| 2009-01-05 10:00:00 | AAPL | Stock | 3.3375 | 3.3636 | 3.3218 | 3.3607 | 106818684.0 |
| 2009-01-05 10:30:00 | AAPL | Stock | 3.3611 | 3.3896 | 3.355 | 3.3757 | 84133672.0 |
| 2009-01-05 11:00:00 | AAPL | Stock | 3.3754 | 3.3911 | 3.3679 | 3.3736 | 60831512.0 |
| 2009-01-05 11:30:00 | AAPL | Stock | 3.3729 | 3.3857 | 3.3643 | 3.3664 | 38971240.0 |
| 2009-01-05 12:00:00 | AAPL | Stock | 3.3657 | 3.4036 | 3.365 | 3.3957 | 59677408.0 |
| 2009-01-05 12:30:00 | AAPL | Stock | 3.3957 | 3.3979 | 3.3793 | 3.3957 | 42817488.0 |
| 2009-01-05 13:00:00 | AAPL | Stock | 3.3961 | 3.4168 | 3.3882 | 3.4111 | 52478356.0 |
| 2009-01-05 13:30:00 | AAPL | Stock | 3.4096 | 3.4236 | 3.3921 | 3.4227 | 55397608.0 |
| 2009-01-05 14:00:00 | AAPL | Stock | 3.4225 | 3.435 | 3.4161 | 3.4257 | 75260668.0 |
| 2009-01-05 14:30:00 | AAPL | Stock | 3.425 | 3.4275 | 3.3607 | 3.3786 | 138658912.0 |
| 2009-01-05 15:00:00 | AAPL | Stock | 3.3779 | 3.4036 | 3.3671 | 3.3721 | 92190476.0 |
| 2009-01-05 15:30:00 | AAPL | Stock | 3.3721 | 3.3921 | 3.3696 | 3.3786 | 94884440.0 |
| 2009-01-05 16:00:00 | AAPL | Stock | 3.3789 | 3.3961 | 3.375 | 3.3771 | 13131804.0 |
| 2009-01-05 16:30:00 | AAPL | Stock | 3.3786 | 3.3821 | 3.375 | 3.3807 | 1877848.0 |
| 2009-01-05 17:00:00 | AAPL | Stock | 3.3796 | 3.3836 | 3.375 | 3.3779 | 457856.0 |
| 2009-01-05 17:30:00 | AAPL | Stock | 3.3804 | 3.3836 | 3.3804 | 3.3832 | 269220.0 |
| 2009-01-05 18:00:00 | AAPL | Stock | 3.3821 | 3.3875 | 3.3779 | 3.3871 | 6795180.0 |
| 2009-01-05 18:30:00 | AAPL | Stock | 3.3875 | 3.3889 | 3.3839 | 3.3839 | 146692.0 |
| 2009-01-05 19:00:00 | AAPL | Stock | 3.3854 | 3.3854 | 3.3786 | 3.3786 | 128100.0 |
| 2009-01-05 19:30:00 | AAPL | Stock | 3.3807 | 3.3889 | 3.3786 | 3.3804 | 240800.0 |
| 2009-01-05 20:00:00 | AAPL | Stock | 3.3779 | 3.3779 | 3.3779 | 3.3779 | 14000.0 |
| 2009-01-05 08:00:00 | MSFT | Stock | 20.28 | 20.28 | 20.11 | 20.11 | 2064.0 |
| 2009-01-05 08:30:00 | MSFT | Stock | 20.13 | 20.18 | 20.1 | 20.13 | 6600.0 |
| 2009-01-05 09:00:00 | MSFT | Stock | 20.2 | 20.22 | 20.1 | 20.19 | 52451.0 |
| 2009-01-05 09:30:00 | MSFT | Stock | 20.2 | 20.23 | 20.06 | 20.11 | 5967460.0 |
| 2009-01-05 10:00:00 | MSFT | Stock | 20.11 | 20.26 | 20.11 | 20.26 | 5708060.0 |
| 2009-01-05 10:30:00 | MSFT | Stock | 20.26 | 20.31 | 20.23 | 20.29 | 4617112.0 |
| 2009-01-05 11:00:00 | MSFT | Stock | 20.28 | 20.375 | 20.27 | 20.37 | 3200979.0 |
| 2009-01-05 11:30:00 | MSFT | Stock | 20.36 | 20.45 | 20.35 | 20.39 | 3681916.0 |
| 2009-01-05 12:00:00 | MSFT | Stock | 20.38 | 20.52 | 20.35 | 20.48 | 2813677.0 |
| 2009-01-05 12:30:00 | MSFT | Stock | 20.48 | 20.48 | 20.35 | 20.39 | 2151730.0 |
| 2009-01-05 13:00:00 | MSFT | Stock | 20.39 | 20.47 | 20.35 | 20.43 | 3723637.0 |
| 2009-01-05 13:30:00 | MSFT | Stock | 20.42 | 20.6 | 20.42 | 20.6 | 3890670.0 |
| 2009-01-05 14:00:00 | MSFT | Stock | 20.6 | 20.67 | 20.51 | 20.51 | 5511491.0 |
| 2009-01-05 14:30:00 | MSFT | Stock | 20.5 | 20.54 | 20.35 | 20.39 | 4057990.0 |
| 2009-01-05 15:00:00 | MSFT | Stock | 20.39 | 20.47 | 20.31 | 20.385 | 4189624.0 |
| 2009-01-05 15:30:00 | MSFT | Stock | 20.39 | 20.52 | 20.34 | 20.52 | 7098441.0 |
| 2009-01-05 16:00:00 | MSFT | Stock | 20.51 | 20.55 | 20.189 | 20.28 | 3186651.0 |
| 2009-01-05 16:30:00 | MSFT | Stock | 20.52 | 20.52 | 20.438 | 20.48 | 236966.0 |
| 2009-01-05 17:00:00 | MSFT | Stock | 20.52 | 20.52 | 20.49 | 20.49 | 141860.0 |
| 2009-01-05 17:30:00 | MSFT | Stock | 20.49 | 20.49 | 20.47 | 20.47 | 7265.0 |
| 2009-01-05 18:00:00 | MSFT | Stock | 20.49 | 20.5 | 20.47 | 20.47 | 1107.0 |
| 2009-01-05 18:30:00 | MSFT | Stock | 20.47 | 20.47 | 20.47 | 20.47 | 189.0 |
| 2009-01-05 19:00:00 | MSFT | Stock | 20.47 | 20.47 | 20.47 | 20.47 | 250.0 |
> showing 50 of 70,033 rows — these rows as CSV