PREVIEW / stock_1hour / 2002-11-25
file: by_date/stock_1hour/2002/2002-11-25.parquet size: 428 KB rows: 19,946 symbols: 1,515
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 |
|---|---|---|---|---|---|---|---|
| 2002-11-25 08:00:00 | AAPL | Stock | 0.2875 | 0.2875 | 0.2857 | 0.2857 | 1405600.0 |
| 2002-11-25 09:00:00 | AAPL | Stock | 0.2863 | 0.2882 | 0.2845 | 0.2863 | 20863640.0 |
| 2002-11-25 10:00:00 | AAPL | Stock | 0.2863 | 0.288 | 0.2841 | 0.2859 | 28824880.0 |
| 2002-11-25 11:00:00 | AAPL | Stock | 0.2861 | 0.2861 | 0.2809 | 0.2811 | 28153104.0 |
| 2002-11-25 12:00:00 | AAPL | Stock | 0.2811 | 0.2838 | 0.2805 | 0.2834 | 17023832.0 |
| 2002-11-25 13:00:00 | AAPL | Stock | 0.2834 | 0.2838 | 0.2811 | 0.2827 | 17919216.0 |
| 2002-11-25 14:00:00 | AAPL | Stock | 0.2827 | 0.2854 | 0.2818 | 0.2846 | 21546224.0 |
| 2002-11-25 15:00:00 | AAPL | Stock | 0.2846 | 0.2866 | 0.2843 | 0.2852 | 28755776.0 |
| 2002-11-25 16:00:00 | AAPL | Stock | 0.2852 | 0.2864 | 0.2839 | 0.2852 | 4401880.0 |
| 2002-11-25 17:00:00 | AAPL | Stock | 0.2821 | 0.2834 | 0.2821 | 0.2821 | 113400.0 |
| 2002-11-25 08:00:00 | MSFT | Stock | 29.125 | 29.29 | 27.735 | 29.2 | 55926.0 |
| 2002-11-25 09:00:00 | MSFT | Stock | 29.1805 | 29.245 | 28.835 | 29.145 | 7452190.0 |
| 2002-11-25 10:00:00 | MSFT | Stock | 29.145 | 29.32 | 29.055 | 29.12 | 10293212.0 |
| 2002-11-25 11:00:00 | MSFT | Stock | 29.125 | 29.13 | 28.8805 | 28.8805 | 11316116.0 |
| 2002-11-25 12:00:00 | MSFT | Stock | 28.885 | 28.99 | 28.79 | 28.955 | 6027036.0 |
| 2002-11-25 13:00:00 | MSFT | Stock | 28.955 | 29.04 | 28.92 | 28.995 | 4049808.0 |
| 2002-11-25 14:00:00 | MSFT | Stock | 28.995 | 29.17 | 28.97 | 29.135 | 6518136.0 |
| 2002-11-25 15:00:00 | MSFT | Stock | 29.14 | 29.24 | 29.09 | 29.1095 | 8826176.0 |
| 2002-11-25 16:00:00 | MSFT | Stock | 29.11 | 29.225 | 29.035 | 29.075 | 1331126.0 |
| 2002-11-25 17:00:00 | MSFT | Stock | 29.1 | 29.1 | 29.04 | 29.04 | 6446.0 |
| 2002-11-25 18:00:00 | MSFT | Stock | 29.055 | 29.06 | 29.055 | 29.06 | 400.0 |
| 2002-11-25 08:00:00 | NVDA | Stock | 0.1317 | 0.1392 | 0.1317 | 0.1373 | 8046000.0 |
| 2002-11-25 09:00:00 | NVDA | Stock | 0.1371 | 0.1391 | 0.1358 | 0.1377 | 172498920.0 |
| 2002-11-25 10:00:00 | NVDA | Stock | 0.1377 | 0.1387 | 0.1351 | 0.1353 | 263122560.0 |
| 2002-11-25 11:00:00 | NVDA | Stock | 0.1353 | 0.1354 | 0.1317 | 0.1326 | 221559000.0 |
| 2002-11-25 12:00:00 | NVDA | Stock | 0.1325 | 0.134 | 0.1317 | 0.1337 | 109770240.0 |
| 2002-11-25 13:00:00 | NVDA | Stock | 0.1337 | 0.1357 | 0.1333 | 0.1352 | 98187840.0 |
| 2002-11-25 14:00:00 | NVDA | Stock | 0.1351 | 0.1367 | 0.1348 | 0.1365 | 123637560.0 |
| 2002-11-25 15:00:00 | NVDA | Stock | 0.1364 | 0.137 | 0.1355 | 0.1357 | 149200800.0 |
| 2002-11-25 16:00:00 | NVDA | Stock | 0.1356 | 0.1368 | 0.1355 | 0.1366 | 12958920.0 |
| 2002-11-25 17:00:00 | NVDA | Stock | 0.1367 | 0.1367 | 0.1356 | 0.1358 | 1022760.0 |
| 2002-11-25 18:00:00 | NVDA | Stock | 0.1358 | 0.1358 | 0.1357 | 0.1357 | 204000.0 |
| 2002-11-25 08:00:00 | AMZN | Stock | 1.1995 | 1.209 | 1.1995 | 1.203 | 176800.0 |
| 2002-11-25 09:00:00 | AMZN | Stock | 1.2045 | 1.2235 | 1.195 | 1.2225 | 32504920.0 |
| 2002-11-25 10:00:00 | AMZN | Stock | 1.223 | 1.225 | 1.2095 | 1.2115 | 32171160.0 |
| 2002-11-25 11:00:00 | AMZN | Stock | 1.2115 | 1.2145 | 1.195 | 1.1955 | 28898880.0 |
| 2002-11-25 12:00:00 | AMZN | Stock | 1.1955 | 1.205 | 1.191 | 1.201 | 31367460.0 |
| 2002-11-25 13:00:00 | AMZN | Stock | 1.201 | 1.209 | 1.197 | 1.204 | 13299840.0 |
| 2002-11-25 14:00:00 | AMZN | Stock | 1.204 | 1.2085 | 1.2 | 1.2045 | 12188640.0 |
| 2002-11-25 15:00:00 | AMZN | Stock | 1.204 | 1.2155 | 1.204 | 1.2133 | 33646560.0 |
| 2002-11-25 16:00:00 | AMZN | Stock | 1.2135 | 1.2135 | 1.201 | 1.2135 | 3097800.0 |
| 2002-11-25 17:00:00 | AMZN | Stock | 1.2125 | 1.2135 | 1.211 | 1.2135 | 258000.0 |
| 2002-11-25 18:00:00 | AMZN | Stock | 1.214 | 1.214 | 1.214 | 1.214 | 4000.0 |
| 2002-11-25 09:00:00 | CL | Stock | 25.91 | 25.91 | 25.65 | 25.825 | 480600.0 |
| 2002-11-25 10:00:00 | CL | Stock | 25.83 | 25.93 | 25.695 | 25.695 | 1840600.0 |
| 2002-11-25 11:00:00 | CL | Stock | 25.695 | 25.85 | 25.675 | 25.79 | 415200.0 |
| 2002-11-25 12:00:00 | CL | Stock | 25.75 | 25.8 | 25.71 | 25.74 | 315600.0 |
| 2002-11-25 13:00:00 | CL | Stock | 25.74 | 25.75 | 25.55 | 25.665 | 311200.0 |
| 2002-11-25 14:00:00 | CL | Stock | 25.665 | 25.685 | 25.45 | 25.555 | 598400.0 |
| 2002-11-25 15:00:00 | CL | Stock | 25.575 | 25.595 | 25.5 | 25.545 | 594000.0 |
> showing 50 of 19,946 rows — these rows as CSV