PREVIEW / stock_1hour / 2003-03-20
file: by_date/stock_1hour/2003/2003-03-20.parquet size: 413 KB rows: 20,582 symbols: 1,540
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 |
|---|---|---|---|---|---|---|---|
| 2003-03-20 09:00:00 | AAPL | Stock | 0.2666 | 0.2671 | 0.2643 | 0.2646 | 14383600.0 |
| 2003-03-20 10:00:00 | AAPL | Stock | 0.2645 | 0.2652 | 0.2607 | 0.2628 | 45302320.0 |
| 2003-03-20 11:00:00 | AAPL | Stock | 0.2632 | 0.2655 | 0.2623 | 0.263 | 22250928.0 |
| 2003-03-20 12:00:00 | AAPL | Stock | 0.263 | 0.2671 | 0.2618 | 0.2648 | 18560864.0 |
| 2003-03-20 13:00:00 | AAPL | Stock | 0.2646 | 0.2677 | 0.2643 | 0.2659 | 18377296.0 |
| 2003-03-20 14:00:00 | AAPL | Stock | 0.2657 | 0.2668 | 0.2639 | 0.2645 | 13851712.0 |
| 2003-03-20 15:00:00 | AAPL | Stock | 0.2646 | 0.2675 | 0.2645 | 0.2666 | 21943824.0 |
| 2003-03-20 16:00:00 | AAPL | Stock | 0.2657 | 0.267 | 0.2641 | 0.2647 | 2403744.0 |
| 2003-03-20 08:00:00 | MSFT | Stock | 26.3 | 26.35 | 26.0 | 26.087 | 158089.0 |
| 2003-03-20 09:00:00 | MSFT | Stock | 26.08 | 26.33 | 25.91 | 25.95 | 8745632.0 |
| 2003-03-20 10:00:00 | MSFT | Stock | 25.94 | 26.03 | 25.67 | 26.001 | 13830978.0 |
| 2003-03-20 11:00:00 | MSFT | Stock | 26.0 | 26.26 | 25.941 | 26.051 | 9829126.0 |
| 2003-03-20 12:00:00 | MSFT | Stock | 26.05 | 26.35 | 25.92 | 26.14 | 7987077.0 |
| 2003-03-20 13:00:00 | MSFT | Stock | 26.13 | 26.52 | 26.12 | 26.36 | 9886392.0 |
| 2003-03-20 14:00:00 | MSFT | Stock | 26.36 | 26.5 | 26.17 | 26.19 | 6991265.0 |
| 2003-03-20 15:00:00 | MSFT | Stock | 26.18 | 26.4 | 26.09 | 26.27 | 9354348.0 |
| 2003-03-20 16:00:00 | MSFT | Stock | 26.258 | 26.28 | 26.1504 | 26.25 | 604441.0 |
| 2003-03-20 17:00:00 | MSFT | Stock | 26.22 | 26.25 | 26.15 | 26.2 | 86020.0 |
| 2003-03-20 18:00:00 | MSFT | Stock | 26.22 | 26.22 | 26.18 | 26.18 | 16980.0 |
| 2003-03-20 08:00:00 | NVDA | Stock | 0.1165 | 0.1177 | 0.1163 | 0.1163 | 816000.0 |
| 2003-03-20 09:00:00 | NVDA | Stock | 0.1163 | 0.1182 | 0.1149 | 0.1154 | 91980000.0 |
| 2003-03-20 10:00:00 | NVDA | Stock | 0.1154 | 0.1179 | 0.115 | 0.1177 | 92294760.0 |
| 2003-03-20 11:00:00 | NVDA | Stock | 0.1177 | 0.1193 | 0.1168 | 0.1174 | 104057640.0 |
| 2003-03-20 12:00:00 | NVDA | Stock | 0.1174 | 0.1193 | 0.117 | 0.1183 | 81082320.0 |
| 2003-03-20 13:00:00 | NVDA | Stock | 0.1183 | 0.1216 | 0.1182 | 0.1202 | 145838760.0 |
| 2003-03-20 14:00:00 | NVDA | Stock | 0.1201 | 0.1207 | 0.1187 | 0.1192 | 92079840.0 |
| 2003-03-20 15:00:00 | NVDA | Stock | 0.119 | 0.1203 | 0.1185 | 0.1192 | 108654240.0 |
| 2003-03-20 16:00:00 | NVDA | Stock | 0.1192 | 0.12 | 0.1186 | 0.1191 | 15467640.0 |
| 2003-03-20 17:00:00 | NVDA | Stock | 0.1192 | 0.1192 | 0.1191 | 0.1191 | 708000.0 |
| 2003-03-20 18:00:00 | NVDA | Stock | 0.1191 | 0.1191 | 0.1188 | 0.1188 | 115920.0 |
| 2003-03-20 08:00:00 | AMZN | Stock | 1.32 | 1.32 | 1.315 | 1.3175 | 295000.0 |
| 2003-03-20 09:00:00 | AMZN | Stock | 1.3175 | 1.326 | 1.3065 | 1.3145 | 15711880.0 |
| 2003-03-20 10:00:00 | AMZN | Stock | 1.315 | 1.3225 | 1.3105 | 1.322 | 19988760.0 |
| 2003-03-20 11:00:00 | AMZN | Stock | 1.321 | 1.3392 | 1.3205 | 1.336 | 22321220.0 |
| 2003-03-20 12:00:00 | AMZN | Stock | 1.3365 | 1.347 | 1.3295 | 1.341 | 21556300.0 |
| 2003-03-20 13:00:00 | AMZN | Stock | 1.3409 | 1.3625 | 1.3405 | 1.353 | 29255660.0 |
| 2003-03-20 14:00:00 | AMZN | Stock | 1.353 | 1.359 | 1.348 | 1.357 | 17465220.0 |
| 2003-03-20 15:00:00 | AMZN | Stock | 1.3571 | 1.3815 | 1.357 | 1.3735 | 49523740.0 |
| 2003-03-20 16:00:00 | AMZN | Stock | 1.3725 | 1.379 | 1.3455 | 1.3675 | 2637200.0 |
| 2003-03-20 17:00:00 | AMZN | Stock | 1.3725 | 1.3725 | 1.346 | 1.3675 | 248000.0 |
| 2003-03-20 18:00:00 | AMZN | Stock | 1.365 | 1.365 | 1.365 | 1.365 | 19000.0 |
| 2003-03-20 09:00:00 | CL | Stock | 27.1 | 27.13 | 26.92 | 26.92 | 375200.0 |
| 2003-03-20 10:00:00 | CL | Stock | 26.92 | 27.155 | 26.88 | 27.155 | 537400.0 |
| 2003-03-20 11:00:00 | CL | Stock | 27.16 | 27.275 | 27.105 | 27.275 | 486400.0 |
| 2003-03-20 12:00:00 | CL | Stock | 27.275 | 27.345 | 27.135 | 27.165 | 773800.0 |
| 2003-03-20 13:00:00 | CL | Stock | 27.18 | 27.375 | 27.17 | 27.34 | 422800.0 |
| 2003-03-20 14:00:00 | CL | Stock | 27.335 | 27.385 | 27.14 | 27.19 | 359400.0 |
| 2003-03-20 15:00:00 | CL | Stock | 27.19 | 27.32 | 27.15 | 27.29 | 528800.0 |
| 2003-03-20 16:00:00 | CL | Stock | 27.295 | 27.295 | 27.125 | 27.295 | 89200.0 |
> showing 49 of 20,582 rows — these rows as CSV