PREVIEW / stock_30min / 2001-07-18
file: by_date/stock_30min/2001/2001-07-18.parquet size: 544 KB rows: 28,747 symbols: 1,316
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 |
|---|---|---|---|---|---|---|---|
| 2001-07-18 08:00:00 | AAPL | Stock | 0.4018 | 0.4089 | 0.3964 | 0.4064 | 5476800.0 |
| 2001-07-18 08:30:00 | AAPL | Stock | 0.4063 | 0.4079 | 0.3959 | 0.3959 | 11838400.0 |
| 2001-07-18 09:00:00 | AAPL | Stock | 0.3964 | 0.4089 | 0.3841 | 0.3891 | 26163200.0 |
| 2001-07-18 09:30:00 | AAPL | Stock | 0.3889 | 0.3929 | 0.3768 | 0.378 | 203660800.0 |
| 2001-07-18 10:00:00 | AAPL | Stock | 0.378 | 0.3823 | 0.3689 | 0.3723 | 152829600.0 |
| 2001-07-18 10:30:00 | AAPL | Stock | 0.3723 | 0.3777 | 0.3679 | 0.3775 | 122186400.0 |
| 2001-07-18 11:00:00 | AAPL | Stock | 0.3775 | 0.3805 | 0.372 | 0.3727 | 65016000.0 |
| 2001-07-18 11:30:00 | AAPL | Stock | 0.3727 | 0.3736 | 0.367 | 0.3695 | 48809600.0 |
| 2001-07-18 12:00:00 | AAPL | Stock | 0.3695 | 0.3734 | 0.3686 | 0.3705 | 36064000.0 |
| 2001-07-18 12:30:00 | AAPL | Stock | 0.3714 | 0.3759 | 0.3707 | 0.3732 | 46004000.0 |
| 2001-07-18 13:00:00 | AAPL | Stock | 0.3732 | 0.3739 | 0.3652 | 0.3686 | 66836000.0 |
| 2001-07-18 13:30:00 | AAPL | Stock | 0.3684 | 0.3714 | 0.3666 | 0.3686 | 27479200.0 |
| 2001-07-18 14:00:00 | AAPL | Stock | 0.3689 | 0.3711 | 0.3668 | 0.3696 | 22747200.0 |
| 2001-07-18 14:30:00 | AAPL | Stock | 0.3695 | 0.3711 | 0.3673 | 0.3695 | 35448000.0 |
| 2001-07-18 15:00:00 | AAPL | Stock | 0.3698 | 0.3732 | 0.3684 | 0.3725 | 91039200.0 |
| 2001-07-18 15:30:00 | AAPL | Stock | 0.3725 | 0.3759 | 0.3704 | 0.3711 | 95334400.0 |
| 2001-07-18 16:00:00 | AAPL | Stock | 0.3713 | 0.3929 | 0.3654 | 0.3929 | 20361600.0 |
| 2001-07-18 16:30:00 | AAPL | Stock | 0.3696 | 0.3746 | 0.3643 | 0.3723 | 1573600.0 |
| 2001-07-18 17:00:00 | AAPL | Stock | 0.3713 | 0.3713 | 0.3616 | 0.3646 | 190400.0 |
| 2001-07-18 17:30:00 | AAPL | Stock | 0.3652 | 0.3713 | 0.3643 | 0.3643 | 39200.0 |
| 2001-07-18 18:00:00 | AAPL | Stock | 0.3646 | 0.3688 | 0.3646 | 0.3688 | 84000.0 |
| 2001-07-18 08:00:00 | MSFT | Stock | 35.45 | 35.905 | 35.45 | 35.64 | 166200.0 |
| 2001-07-18 08:30:00 | MSFT | Stock | 35.61 | 35.905 | 35.45 | 35.45 | 98000.0 |
| 2001-07-18 09:00:00 | MSFT | Stock | 35.495 | 35.65 | 35.15 | 35.33 | 625400.0 |
| 2001-07-18 09:30:00 | MSFT | Stock | 35.3 | 35.61 | 35.265 | 35.585 | 6291800.0 |
| 2001-07-18 10:00:00 | MSFT | Stock | 35.585 | 35.75 | 35.25 | 35.365 | 7514400.0 |
| 2001-07-18 10:30:00 | MSFT | Stock | 35.37 | 35.405 | 35.1 | 35.275 | 6051600.0 |
| 2001-07-18 11:00:00 | MSFT | Stock | 35.265 | 35.44 | 35.13 | 35.355 | 2875200.0 |
| 2001-07-18 11:30:00 | MSFT | Stock | 35.36 | 35.42 | 35.26 | 35.325 | 2008600.0 |
| 2001-07-18 12:00:00 | MSFT | Stock | 35.33 | 35.405 | 35.225 | 35.275 | 1715400.0 |
| 2001-07-18 12:30:00 | MSFT | Stock | 35.28 | 35.445 | 35.215 | 35.37 | 2167000.0 |
| 2001-07-18 13:00:00 | MSFT | Stock | 35.37 | 35.54 | 35.29 | 35.475 | 3208400.0 |
| 2001-07-18 13:30:00 | MSFT | Stock | 35.475 | 35.5 | 35.345 | 35.41 | 3210400.0 |
| 2001-07-18 14:00:00 | MSFT | Stock | 35.415 | 35.44 | 35.17 | 35.225 | 3075400.0 |
| 2001-07-18 14:30:00 | MSFT | Stock | 35.215 | 35.31 | 34.94 | 34.96 | 4448600.0 |
| 2001-07-18 15:00:00 | MSFT | Stock | 34.95 | 35.105 | 34.935 | 35.02 | 4098200.0 |
| 2001-07-18 15:30:00 | MSFT | Stock | 35.015 | 35.3 | 34.975 | 35.285 | 4797400.0 |
| 2001-07-18 16:00:00 | MSFT | Stock | 35.29 | 35.495 | 34.99 | 34.99 | 1498000.0 |
| 2001-07-18 16:30:00 | MSFT | Stock | 35.285 | 35.34 | 35.11 | 35.13 | 637400.0 |
| 2001-07-18 17:00:00 | MSFT | Stock | 35.13 | 35.13 | 35.0 | 35.0 | 25600.0 |
| 2001-07-18 17:30:00 | MSFT | Stock | 35.0 | 35.285 | 34.95 | 35.2 | 23000.0 |
| 2001-07-18 18:00:00 | MSFT | Stock | 35.1 | 35.14 | 35.1 | 35.1 | 6600.0 |
| 2001-07-18 08:00:00 | NVDA | Stock | 0.3219 | 0.3219 | 0.3214 | 0.3219 | 192000.0 |
| 2001-07-18 08:30:00 | NVDA | Stock | 0.3206 | 0.3219 | 0.3175 | 0.3175 | 1536000.0 |
| 2001-07-18 09:00:00 | NVDA | Stock | 0.3175 | 0.3228 | 0.3169 | 0.3195 | 6600000.0 |
| 2001-07-18 09:30:00 | NVDA | Stock | 0.3198 | 0.326 | 0.3181 | 0.3258 | 111552000.0 |
| 2001-07-18 10:00:00 | NVDA | Stock | 0.3259 | 0.3286 | 0.3172 | 0.3197 | 110232000.0 |
| 2001-07-18 10:30:00 | NVDA | Stock | 0.3199 | 0.3208 | 0.3095 | 0.3153 | 94800000.0 |
| 2001-07-18 11:00:00 | NVDA | Stock | 0.3153 | 0.3177 | 0.313 | 0.3164 | 47712000.0 |
| 2001-07-18 11:30:00 | NVDA | Stock | 0.3164 | 0.3167 | 0.3125 | 0.3138 | 21168000.0 |
> showing 50 of 28,747 rows — these rows as CSV