PREVIEW / stock_30min / 2009-08-11
file: by_date/stock_30min/2009/2009-08-11.parquet size: 1.3 MB rows: 73,367 symbols: 3,357
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-08-11 06:00:00 | AAPL | Stock | 5.8932 | 5.8932 | 5.8932 | 5.8932 | 14000.0 |
| 2009-08-11 08:00:00 | AAPL | Stock | 5.8875 | 5.8875 | 5.875 | 5.8782 | 85232.0 |
| 2009-08-11 08:30:00 | AAPL | Stock | 5.8804 | 5.8804 | 5.8579 | 5.8579 | 197484.0 |
| 2009-08-11 09:00:00 | AAPL | Stock | 5.8579 | 5.8711 | 5.8361 | 5.8446 | 4404904.0 |
| 2009-08-11 09:30:00 | AAPL | Stock | 5.8461 | 5.8707 | 5.8311 | 5.8686 | 49095368.0 |
| 2009-08-11 10:00:00 | AAPL | Stock | 5.8679 | 5.8679 | 5.8393 | 5.8393 | 34944000.0 |
| 2009-08-11 10:30:00 | AAPL | Stock | 5.8393 | 5.8432 | 5.7946 | 5.8096 | 41988492.0 |
| 2009-08-11 11:00:00 | AAPL | Stock | 5.8094 | 5.8146 | 5.7954 | 5.8093 | 21799680.0 |
| 2009-08-11 11:30:00 | AAPL | Stock | 5.8086 | 5.8089 | 5.785 | 5.7875 | 22624924.0 |
| 2009-08-11 12:00:00 | AAPL | Stock | 5.7868 | 5.7996 | 5.7821 | 5.7964 | 16375716.0 |
| 2009-08-11 12:30:00 | AAPL | Stock | 5.7964 | 5.7989 | 5.7814 | 5.7857 | 13907404.0 |
| 2009-08-11 13:00:00 | AAPL | Stock | 5.7854 | 5.7993 | 5.7846 | 5.7893 | 14134932.0 |
| 2009-08-11 13:30:00 | AAPL | Stock | 5.79 | 5.8036 | 5.7896 | 5.7971 | 13280764.0 |
| 2009-08-11 14:00:00 | AAPL | Stock | 5.7971 | 5.8214 | 5.7971 | 5.8175 | 22395688.0 |
| 2009-08-11 14:30:00 | AAPL | Stock | 5.8179 | 5.8304 | 5.8146 | 5.8275 | 27228264.0 |
| 2009-08-11 15:00:00 | AAPL | Stock | 5.8275 | 5.8396 | 5.8221 | 5.8346 | 25354672.0 |
| 2009-08-11 15:30:00 | AAPL | Stock | 5.8354 | 5.8425 | 5.8154 | 5.8168 | 34485472.0 |
| 2009-08-11 16:00:00 | AAPL | Stock | 5.8168 | 5.8217 | 5.8143 | 5.8161 | 5099640.0 |
| 2009-08-11 16:30:00 | AAPL | Stock | 5.8154 | 5.8761 | 5.8139 | 5.8179 | 2876496.0 |
| 2009-08-11 17:00:00 | AAPL | Stock | 5.8699 | 5.8699 | 5.8143 | 5.8146 | 22932.0 |
| 2009-08-11 17:30:00 | AAPL | Stock | 5.8164 | 5.8164 | 5.8107 | 5.8107 | 85120.0 |
| 2009-08-11 18:00:00 | AAPL | Stock | 5.8129 | 5.8175 | 5.8111 | 5.8111 | 345940.0 |
| 2009-08-11 18:30:00 | AAPL | Stock | 5.8179 | 5.8179 | 5.8125 | 5.8125 | 28000.0 |
| 2009-08-11 19:00:00 | AAPL | Stock | 5.8171 | 5.8196 | 5.8132 | 5.8139 | 66024.0 |
| 2009-08-11 19:30:00 | AAPL | Stock | 5.8204 | 5.8243 | 5.8179 | 5.8179 | 42532.0 |
| 2009-08-11 04:30:00 | MSFT | Stock | 23.55 | 23.62 | 23.55 | 23.62 | 600.0 |
| 2009-08-11 07:00:00 | MSFT | Stock | 23.5 | 23.55 | 23.5 | 23.55 | 1600.0 |
| 2009-08-11 08:00:00 | MSFT | Stock | 23.46 | 23.5 | 23.37 | 23.45 | 6754.0 |
| 2009-08-11 08:30:00 | MSFT | Stock | 23.48 | 23.48 | 23.45 | 23.45 | 1400.0 |
| 2009-08-11 09:00:00 | MSFT | Stock | 23.45 | 23.48 | 23.3 | 23.32 | 26272.0 |
| 2009-08-11 09:30:00 | MSFT | Stock | 23.32 | 23.4 | 23.15 | 23.16 | 5550930.0 |
| 2009-08-11 10:00:00 | MSFT | Stock | 23.16 | 23.23 | 23.05 | 23.12 | 4135153.0 |
| 2009-08-11 10:30:00 | MSFT | Stock | 23.13 | 23.16 | 23.09 | 23.129 | 2382477.0 |
| 2009-08-11 11:00:00 | MSFT | Stock | 23.12 | 23.2 | 23.09 | 23.2 | 2243437.0 |
| 2009-08-11 11:30:00 | MSFT | Stock | 23.2 | 23.23 | 23.17 | 23.19 | 1299634.0 |
| 2009-08-11 12:00:00 | MSFT | Stock | 23.19 | 23.2 | 23.11 | 23.125 | 1095060.0 |
| 2009-08-11 12:30:00 | MSFT | Stock | 23.127 | 23.15 | 23.11 | 23.14 | 977098.0 |
| 2009-08-11 13:00:00 | MSFT | Stock | 23.14 | 23.17 | 23.1 | 23.1 | 1489867.0 |
| 2009-08-11 13:30:00 | MSFT | Stock | 23.11 | 23.15 | 23.1 | 23.122 | 1749951.0 |
| 2009-08-11 14:00:00 | MSFT | Stock | 23.13 | 23.24 | 23.125 | 23.21 | 2234740.0 |
| 2009-08-11 14:30:00 | MSFT | Stock | 23.205 | 23.23 | 23.16 | 23.23 | 1806974.0 |
| 2009-08-11 15:00:00 | MSFT | Stock | 23.23 | 23.27 | 23.2 | 23.22 | 1409394.0 |
| 2009-08-11 15:30:00 | MSFT | Stock | 23.22 | 23.26 | 23.12 | 23.14 | 4189927.0 |
| 2009-08-11 16:00:00 | MSFT | Stock | 23.15 | 23.2 | 23.12 | 23.17 | 1777359.0 |
| 2009-08-11 16:30:00 | MSFT | Stock | 23.17 | 23.2 | 23.15 | 23.18 | 303614.0 |
| 2009-08-11 17:00:00 | MSFT | Stock | 23.368 | 23.368 | 23.15 | 23.19 | 6323.0 |
| 2009-08-11 17:30:00 | MSFT | Stock | 23.22 | 23.26 | 23.19 | 23.19 | 3030.0 |
| 2009-08-11 18:00:00 | MSFT | Stock | 23.19 | 23.19 | 23.19 | 23.19 | 600.0 |
| 2009-08-11 18:30:00 | MSFT | Stock | 23.18 | 23.18 | 23.15 | 23.15 | 530.0 |
| 2009-08-11 19:00:00 | MSFT | Stock | 23.21 | 23.21 | 23.21 | 23.21 | 100.0 |
> showing 50 of 73,367 rows — these rows as CSV