PREVIEW / stock_1hour / 2005-02-25
file: by_date/stock_1hour/2005/2005-02-25.parquet size: 548 KB rows: 25,737 symbols: 1,940
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 |
|---|---|---|---|---|---|---|---|
| 2005-02-25 08:00:00 | AAPL | Stock | 1.6004 | 1.6038 | 1.5941 | 1.5966 | 7562856.0 |
| 2005-02-25 09:00:00 | AAPL | Stock | 1.5973 | 1.6055 | 1.5911 | 1.5991 | 151002656.0 |
| 2005-02-25 10:00:00 | AAPL | Stock | 1.5995 | 1.6025 | 1.5814 | 1.5916 | 198562560.0 |
| 2005-02-25 11:00:00 | AAPL | Stock | 1.5932 | 1.5938 | 1.5793 | 1.5859 | 128318848.0 |
| 2005-02-25 12:00:00 | AAPL | Stock | 1.5859 | 1.5868 | 1.5786 | 1.5827 | 68426904.0 |
| 2005-02-25 13:00:00 | AAPL | Stock | 1.5827 | 1.5866 | 1.5763 | 1.5795 | 66651256.0 |
| 2005-02-25 14:00:00 | AAPL | Stock | 1.5795 | 1.5873 | 1.5748 | 1.5795 | 83341720.0 |
| 2005-02-25 15:00:00 | AAPL | Stock | 1.5796 | 1.5927 | 1.5779 | 1.5888 | 185617656.0 |
| 2005-02-25 16:00:00 | AAPL | Stock | 1.5904 | 1.592 | 1.5838 | 1.5895 | 10138856.0 |
| 2005-02-25 17:00:00 | AAPL | Stock | 1.5895 | 1.5904 | 1.5891 | 1.5893 | 331688.0 |
| 2005-02-25 18:00:00 | AAPL | Stock | 1.5895 | 1.5905 | 1.5891 | 1.5905 | 246624.0 |
| 2005-02-25 08:00:00 | MSFT | Stock | 25.47 | 25.47 | 25.37 | 25.43 | 743476.0 |
| 2005-02-25 09:00:00 | MSFT | Stock | 25.43 | 25.43 | 25.24 | 25.27 | 5685320.0 |
| 2005-02-25 10:00:00 | MSFT | Stock | 25.27 | 25.28 | 25.21 | 25.27 | 11778700.0 |
| 2005-02-25 11:00:00 | MSFT | Stock | 25.27 | 25.29 | 25.22 | 25.25 | 9043994.0 |
| 2005-02-25 12:00:00 | MSFT | Stock | 25.25 | 25.29 | 25.21 | 25.219 | 9255138.0 |
| 2005-02-25 13:00:00 | MSFT | Stock | 25.22 | 25.29 | 25.15 | 25.24 | 4169873.0 |
| 2005-02-25 14:00:00 | MSFT | Stock | 25.231 | 25.261 | 25.22 | 25.23 | 7400744.0 |
| 2005-02-25 15:00:00 | MSFT | Stock | 25.22 | 25.27 | 25.19 | 25.27 | 10548916.0 |
| 2005-02-25 16:00:00 | MSFT | Stock | 25.26 | 25.32 | 25.25 | 25.28 | 1587132.0 |
| 2005-02-25 17:00:00 | MSFT | Stock | 25.28 | 25.29 | 25.23 | 25.23 | 40831.0 |
| 2005-02-25 08:00:00 | NVDA | Stock | 0.2369 | 0.2369 | 0.2369 | 0.2369 | 264000.0 |
| 2005-02-25 09:00:00 | NVDA | Stock | 0.2367 | 0.2387 | 0.2347 | 0.2356 | 103602240.0 |
| 2005-02-25 10:00:00 | NVDA | Stock | 0.2355 | 0.2396 | 0.2351 | 0.2396 | 102590160.0 |
| 2005-02-25 11:00:00 | NVDA | Stock | 0.2396 | 0.2415 | 0.2388 | 0.2415 | 86975040.0 |
| 2005-02-25 12:00:00 | NVDA | Stock | 0.2413 | 0.2416 | 0.2391 | 0.2395 | 70323000.0 |
| 2005-02-25 13:00:00 | NVDA | Stock | 0.2394 | 0.2403 | 0.2382 | 0.2396 | 38834760.0 |
| 2005-02-25 14:00:00 | NVDA | Stock | 0.2396 | 0.2412 | 0.2391 | 0.2391 | 47146440.0 |
| 2005-02-25 15:00:00 | NVDA | Stock | 0.2391 | 0.241 | 0.2391 | 0.2404 | 71204520.0 |
| 2005-02-25 16:00:00 | NVDA | Stock | 0.2389 | 0.2407 | 0.2389 | 0.2399 | 780600.0 |
| 2005-02-25 17:00:00 | NVDA | Stock | 0.2403 | 0.2403 | 0.2403 | 0.2403 | 37200.0 |
| 2005-02-25 08:00:00 | AMZN | Stock | 1.7345 | 1.7345 | 1.7345 | 1.7345 | 6000.0 |
| 2005-02-25 09:00:00 | AMZN | Stock | 1.7335 | 1.756 | 1.724 | 1.7425 | 18736620.0 |
| 2005-02-25 10:00:00 | AMZN | Stock | 1.742 | 1.754 | 1.737 | 1.7445 | 30066320.0 |
| 2005-02-25 11:00:00 | AMZN | Stock | 1.745 | 1.7615 | 1.7405 | 1.7584 | 18025780.0 |
| 2005-02-25 12:00:00 | AMZN | Stock | 1.7585 | 1.759 | 1.742 | 1.742 | 10367180.0 |
| 2005-02-25 13:00:00 | AMZN | Stock | 1.743 | 1.7495 | 1.74 | 1.742 | 6693420.0 |
| 2005-02-25 14:00:00 | AMZN | Stock | 1.7425 | 1.753 | 1.736 | 1.7455 | 12646100.0 |
| 2005-02-25 15:00:00 | AMZN | Stock | 1.746 | 1.752 | 1.7435 | 1.748 | 18822540.0 |
| 2005-02-25 16:00:00 | AMZN | Stock | 1.748 | 1.7515 | 1.7465 | 1.749 | 251040.0 |
| 2005-02-25 17:00:00 | AMZN | Stock | 1.749 | 1.7495 | 1.749 | 1.749 | 48080.0 |
| 2005-02-25 18:00:00 | AMZN | Stock | 1.749 | 1.749 | 1.7455 | 1.7455 | 55000.0 |
| 2005-02-25 09:00:00 | CL | Stock | 26.25 | 26.365 | 26.23 | 26.275 | 289800.0 |
| 2005-02-25 10:00:00 | CL | Stock | 26.275 | 26.325 | 26.215 | 26.325 | 404600.0 |
| 2005-02-25 11:00:00 | CL | Stock | 26.325 | 26.455 | 26.315 | 26.35 | 562000.0 |
| 2005-02-25 12:00:00 | CL | Stock | 26.35 | 26.42 | 26.28 | 26.325 | 567800.0 |
| 2005-02-25 13:00:00 | CL | Stock | 26.325 | 26.34 | 26.24 | 26.265 | 444600.0 |
| 2005-02-25 14:00:00 | CL | Stock | 26.265 | 26.295 | 26.17 | 26.295 | 515200.0 |
| 2005-02-25 15:00:00 | CL | Stock | 26.295 | 26.35 | 26.255 | 26.32 | 690200.0 |
| 2005-02-25 16:00:00 | CL | Stock | 26.3 | 26.3 | 26.3 | 26.3 | 1200.0 |
> showing 50 of 25,737 rows — these rows as CSV