PREVIEW / stock_30min / 2009-06-22
file: by_date/stock_30min/2009/2009-06-22.parquet size: 1.3 MB rows: 73,108 symbols: 3,350
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-06-22 04:00:00 | AAPL | Stock | 4.9811 | 4.9857 | 4.9811 | 4.9857 | 19600.0 |
| 2009-06-22 06:00:00 | AAPL | Stock | 4.9343 | 4.9496 | 4.9325 | 4.9325 | 44380.0 |
| 2009-06-22 07:00:00 | AAPL | Stock | 4.9325 | 4.9621 | 4.9286 | 4.9325 | 117572.0 |
| 2009-06-22 07:30:00 | AAPL | Stock | 4.9264 | 4.9382 | 4.9204 | 4.9382 | 112588.0 |
| 2009-06-22 08:00:00 | AAPL | Stock | 4.9371 | 4.95 | 4.9221 | 4.9304 | 1636068.0 |
| 2009-06-22 08:30:00 | AAPL | Stock | 4.9314 | 5.0282 | 4.9314 | 5.0079 | 7477484.0 |
| 2009-06-22 09:00:00 | AAPL | Stock | 5.0071 | 5.0357 | 4.9864 | 5.0243 | 8083684.0 |
| 2009-06-22 09:30:00 | AAPL | Stock | 5.0232 | 5.0557 | 4.9654 | 4.9746 | 127740900.0 |
| 2009-06-22 10:00:00 | AAPL | Stock | 4.9746 | 4.975 | 4.9189 | 4.9375 | 75650512.0 |
| 2009-06-22 10:30:00 | AAPL | Stock | 4.9382 | 4.9386 | 4.8929 | 4.8982 | 58341696.0 |
| 2009-06-22 11:00:00 | AAPL | Stock | 4.8986 | 4.9214 | 4.8689 | 4.91 | 59296888.0 |
| 2009-06-22 11:30:00 | AAPL | Stock | 4.9096 | 4.9125 | 4.8818 | 4.9018 | 30889936.0 |
| 2009-06-22 12:00:00 | AAPL | Stock | 4.9024 | 4.9025 | 4.8714 | 4.8764 | 28274316.0 |
| 2009-06-22 12:30:00 | AAPL | Stock | 4.8775 | 4.895 | 4.8771 | 4.8929 | 17902108.0 |
| 2009-06-22 13:00:00 | AAPL | Stock | 4.8925 | 4.8954 | 4.8775 | 4.8839 | 21859572.0 |
| 2009-06-22 13:30:00 | AAPL | Stock | 4.8842 | 4.9014 | 4.8832 | 4.9011 | 19898480.0 |
| 2009-06-22 14:00:00 | AAPL | Stock | 4.9007 | 4.9179 | 4.8971 | 4.9058 | 28075012.0 |
| 2009-06-22 14:30:00 | AAPL | Stock | 4.9057 | 4.9207 | 4.9014 | 4.9096 | 23239888.0 |
| 2009-06-22 15:00:00 | AAPL | Stock | 4.9104 | 4.9229 | 4.9021 | 4.9182 | 27473152.0 |
| 2009-06-22 15:30:00 | AAPL | Stock | 4.9186 | 4.9329 | 4.9007 | 4.9057 | 66045644.0 |
| 2009-06-22 16:00:00 | AAPL | Stock | 4.905 | 4.9319 | 4.8906 | 4.9036 | 16002896.0 |
| 2009-06-22 16:30:00 | AAPL | Stock | 4.9312 | 4.9312 | 4.9007 | 4.9036 | 5305944.0 |
| 2009-06-22 17:00:00 | AAPL | Stock | 4.9061 | 4.95 | 4.8857 | 4.8929 | 4592896.0 |
| 2009-06-22 17:30:00 | AAPL | Stock | 4.8929 | 4.9 | 4.8929 | 4.8971 | 320152.0 |
| 2009-06-22 18:00:00 | AAPL | Stock | 4.8943 | 4.9061 | 4.8929 | 4.8968 | 902692.0 |
| 2009-06-22 18:30:00 | AAPL | Stock | 4.8968 | 4.9 | 4.8957 | 4.8957 | 47600.0 |
| 2009-06-22 19:00:00 | AAPL | Stock | 4.8936 | 4.8982 | 4.8882 | 4.8882 | 128212.0 |
| 2009-06-22 19:30:00 | AAPL | Stock | 4.8882 | 4.8925 | 4.875 | 4.8768 | 536536.0 |
| 2009-06-22 04:00:00 | MSFT | Stock | 24.11 | 24.11 | 24.11 | 24.11 | 900.0 |
| 2009-06-22 05:00:00 | MSFT | Stock | 24.06 | 24.06 | 24.06 | 24.06 | 152.0 |
| 2009-06-22 05:30:00 | MSFT | Stock | 24.06 | 24.06 | 24.06 | 24.06 | 148.0 |
| 2009-06-22 06:30:00 | MSFT | Stock | 24.06 | 24.11 | 24.06 | 24.09 | 1122.0 |
| 2009-06-22 07:00:00 | MSFT | Stock | 24.04 | 24.04 | 23.93 | 23.94 | 1689.0 |
| 2009-06-22 07:30:00 | MSFT | Stock | 23.99 | 24.0 | 23.98 | 24.0 | 2200.0 |
| 2009-06-22 08:00:00 | MSFT | Stock | 24.0 | 24.07 | 23.97 | 24.02 | 32935.0 |
| 2009-06-22 08:30:00 | MSFT | Stock | 23.98 | 24.0 | 23.89 | 23.91 | 19133.0 |
| 2009-06-22 09:00:00 | MSFT | Stock | 23.91 | 24.0 | 23.9 | 23.95 | 35460.0 |
| 2009-06-22 09:30:00 | MSFT | Stock | 23.95 | 23.95 | 23.65 | 23.65 | 8869206.0 |
| 2009-06-22 10:00:00 | MSFT | Stock | 23.66 | 23.71 | 23.56 | 23.67 | 6070308.0 |
| 2009-06-22 10:30:00 | MSFT | Stock | 23.67 | 23.67 | 23.54 | 23.62 | 4221521.0 |
| 2009-06-22 11:00:00 | MSFT | Stock | 23.63 | 23.63 | 23.54 | 23.58 | 2703198.0 |
| 2009-06-22 11:30:00 | MSFT | Stock | 23.59 | 23.62 | 23.48 | 23.58 | 3443232.0 |
| 2009-06-22 12:00:00 | MSFT | Stock | 23.578 | 23.595 | 23.43 | 23.47 | 4307978.0 |
| 2009-06-22 12:30:00 | MSFT | Stock | 23.47 | 23.47 | 23.32 | 23.36 | 4822005.0 |
| 2009-06-22 13:00:00 | MSFT | Stock | 23.34 | 23.42 | 23.33 | 23.36 | 3302186.0 |
| 2009-06-22 13:30:00 | MSFT | Stock | 23.37 | 23.44 | 23.36 | 23.43 | 2812415.0 |
| 2009-06-22 14:00:00 | MSFT | Stock | 23.43 | 23.44 | 23.33 | 23.347 | 4333048.0 |
| 2009-06-22 14:30:00 | MSFT | Stock | 23.34 | 23.35 | 23.28 | 23.305 | 3704514.0 |
| 2009-06-22 15:00:00 | MSFT | Stock | 23.3 | 23.41 | 23.3 | 23.35 | 5400181.0 |
| 2009-06-22 15:30:00 | MSFT | Stock | 23.34 | 23.43 | 23.25 | 23.29 | 11860134.0 |
> showing 50 of 73,108 rows — these rows as CSV