PREVIEW / stock_1hour / 2003-05-29
file: by_date/stock_1hour/2003/2003-05-29.parquet size: 462 KB rows: 21,927 symbols: 1,573
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-05-29 08:00:00 | AAPL | Stock | 0.3264 | 0.3318 | 0.3264 | 0.3266 | 1005200.0 |
| 2003-05-29 09:00:00 | AAPL | Stock | 0.3273 | 0.3277 | 0.3223 | 0.3259 | 33386080.0 |
| 2003-05-29 10:00:00 | AAPL | Stock | 0.3259 | 0.3304 | 0.325 | 0.3279 | 56197176.0 |
| 2003-05-29 11:00:00 | AAPL | Stock | 0.3277 | 0.3298 | 0.3275 | 0.3288 | 21589568.0 |
| 2003-05-29 12:00:00 | AAPL | Stock | 0.3288 | 0.3288 | 0.3232 | 0.3252 | 28017528.0 |
| 2003-05-29 13:00:00 | AAPL | Stock | 0.325 | 0.3252 | 0.3196 | 0.3227 | 50755656.0 |
| 2003-05-29 14:00:00 | AAPL | Stock | 0.3225 | 0.3271 | 0.3218 | 0.3259 | 51564464.0 |
| 2003-05-29 15:00:00 | AAPL | Stock | 0.3257 | 0.3257 | 0.3213 | 0.3234 | 58235744.0 |
| 2003-05-29 16:00:00 | AAPL | Stock | 0.3236 | 0.3238 | 0.3229 | 0.3236 | 8515696.0 |
| 2003-05-29 17:00:00 | AAPL | Stock | 0.3236 | 0.3236 | 0.3236 | 0.3236 | 84000.0 |
| 2003-05-29 08:00:00 | MSFT | Stock | 24.415 | 24.5 | 24.38 | 24.46 | 137458.0 |
| 2003-05-29 09:00:00 | MSFT | Stock | 24.46 | 24.55 | 24.26 | 24.43 | 8458419.0 |
| 2003-05-29 10:00:00 | MSFT | Stock | 24.43 | 24.63 | 24.27 | 24.54 | 14362584.0 |
| 2003-05-29 11:00:00 | MSFT | Stock | 24.54 | 24.67 | 24.5 | 24.635 | 9241715.0 |
| 2003-05-29 12:00:00 | MSFT | Stock | 24.63 | 24.64 | 24.44 | 24.48 | 9196753.0 |
| 2003-05-29 13:00:00 | MSFT | Stock | 24.48 | 24.5 | 24.28 | 24.39 | 9891618.0 |
| 2003-05-29 14:00:00 | MSFT | Stock | 24.39 | 24.52 | 24.36 | 24.36 | 5008531.0 |
| 2003-05-29 15:00:00 | MSFT | Stock | 24.36 | 24.37 | 24.24 | 24.31 | 9956039.0 |
| 2003-05-29 16:00:00 | MSFT | Stock | 24.281 | 24.4271 | 24.2 | 24.31 | 995608.0 |
| 2003-05-29 17:00:00 | MSFT | Stock | 24.31 | 24.4 | 24.27 | 24.29 | 34821.0 |
| 2003-05-29 18:00:00 | MSFT | Stock | 24.3 | 24.349 | 24.28 | 24.349 | 19635.0 |
| 2003-05-29 08:00:00 | NVDA | Stock | 0.189 | 0.1904 | 0.189 | 0.1904 | 1656000.0 |
| 2003-05-29 09:00:00 | NVDA | Stock | 0.1904 | 0.2007 | 0.1883 | 0.1999 | 329304720.0 |
| 2003-05-29 10:00:00 | NVDA | Stock | 0.1999 | 0.2004 | 0.1971 | 0.1999 | 366962400.0 |
| 2003-05-29 11:00:00 | NVDA | Stock | 0.1997 | 0.204 | 0.1994 | 0.2037 | 302691120.0 |
| 2003-05-29 12:00:00 | NVDA | Stock | 0.2037 | 0.2082 | 0.2026 | 0.2032 | 439635120.0 |
| 2003-05-29 13:00:00 | NVDA | Stock | 0.2032 | 0.2042 | 0.2004 | 0.2028 | 272023080.0 |
| 2003-05-29 14:00:00 | NVDA | Stock | 0.2027 | 0.205 | 0.2018 | 0.2022 | 168500880.0 |
| 2003-05-29 15:00:00 | NVDA | Stock | 0.2022 | 0.2027 | 0.1992 | 0.2017 | 277064640.0 |
| 2003-05-29 16:00:00 | NVDA | Stock | 0.2017 | 0.2021 | 0.2 | 0.2017 | 33636600.0 |
| 2003-05-29 17:00:00 | NVDA | Stock | 0.2012 | 0.2017 | 0.2009 | 0.2015 | 1242000.0 |
| 2003-05-29 18:00:00 | NVDA | Stock | 0.2017 | 0.202 | 0.2017 | 0.202 | 900000.0 |
| 2003-05-29 08:00:00 | AMZN | Stock | 1.739 | 1.7475 | 1.7389 | 1.7465 | 309000.0 |
| 2003-05-29 09:00:00 | AMZN | Stock | 1.7469 | 1.785 | 1.735 | 1.7798 | 24939380.0 |
| 2003-05-29 10:00:00 | AMZN | Stock | 1.78 | 1.7965 | 1.7665 | 1.7845 | 39965680.0 |
| 2003-05-29 11:00:00 | AMZN | Stock | 1.784 | 1.7985 | 1.7795 | 1.791 | 18213440.0 |
| 2003-05-29 12:00:00 | AMZN | Stock | 1.7915 | 1.7915 | 1.777 | 1.781 | 18937960.0 |
| 2003-05-29 13:00:00 | AMZN | Stock | 1.7805 | 1.7815 | 1.763 | 1.775 | 25884740.0 |
| 2003-05-29 14:00:00 | AMZN | Stock | 1.775 | 1.784 | 1.774 | 1.7795 | 17543080.0 |
| 2003-05-29 15:00:00 | AMZN | Stock | 1.7795 | 1.78 | 1.7695 | 1.777 | 27259240.0 |
| 2003-05-29 16:00:00 | AMZN | Stock | 1.7747 | 1.7805 | 1.7747 | 1.7775 | 1354760.0 |
| 2003-05-29 17:00:00 | AMZN | Stock | 1.7765 | 1.781 | 1.7765 | 1.7766 | 252000.0 |
| 2003-05-29 09:00:00 | CL | Stock | 29.325 | 29.675 | 29.325 | 29.66 | 415400.0 |
| 2003-05-29 10:00:00 | CL | Stock | 29.665 | 29.675 | 29.52 | 29.52 | 592200.0 |
| 2003-05-29 11:00:00 | CL | Stock | 29.52 | 29.63 | 29.5 | 29.605 | 343600.0 |
| 2003-05-29 12:00:00 | CL | Stock | 29.61 | 29.625 | 29.52 | 29.55 | 264400.0 |
| 2003-05-29 13:00:00 | CL | Stock | 29.55 | 29.68 | 29.545 | 29.66 | 460000.0 |
| 2003-05-29 14:00:00 | CL | Stock | 29.66 | 29.725 | 29.59 | 29.66 | 443200.0 |
| 2003-05-29 15:00:00 | CL | Stock | 29.66 | 29.66 | 29.5 | 29.55 | 677600.0 |
| 2003-05-29 16:00:00 | CL | Stock | 29.55 | 29.57 | 29.55 | 29.57 | 222600.0 |
> showing 50 of 21,927 rows — these rows as CSV