PREVIEW / stock_1hour / 2005-02-28
file: by_date/stock_1hour/2005/2005-02-28.parquet size: 551 KB rows: 25,397 symbols: 1,949
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-28 08:00:00 | AAPL | Stock | 1.5946 | 1.6004 | 1.5786 | 1.5871 | 5094712.0 |
| 2005-02-28 09:00:00 | AAPL | Stock | 1.5875 | 1.6121 | 1.575 | 1.5914 | 121795912.0 |
| 2005-02-28 10:00:00 | AAPL | Stock | 1.5921 | 1.6071 | 1.585 | 1.6007 | 106543752.0 |
| 2005-02-28 11:00:00 | AAPL | Stock | 1.6007 | 1.605 | 1.5907 | 1.5954 | 81963812.0 |
| 2005-02-28 12:00:00 | AAPL | Stock | 1.5954 | 1.5954 | 1.57 | 1.58 | 102601324.0 |
| 2005-02-28 13:00:00 | AAPL | Stock | 1.58 | 1.5875 | 1.5746 | 1.5814 | 45075016.0 |
| 2005-02-28 14:00:00 | AAPL | Stock | 1.5811 | 1.5939 | 1.5739 | 1.5914 | 63420392.0 |
| 2005-02-28 15:00:00 | AAPL | Stock | 1.5918 | 1.6018 | 1.5879 | 1.5993 | 99438472.0 |
| 2005-02-28 16:00:00 | AAPL | Stock | 1.5971 | 1.6021 | 1.5964 | 1.6021 | 5922560.0 |
| 2005-02-28 17:00:00 | AAPL | Stock | 1.5982 | 1.6032 | 1.5982 | 1.6032 | 672448.0 |
| 2005-02-28 18:00:00 | AAPL | Stock | 1.6021 | 1.6021 | 1.5982 | 1.5982 | 205940.0 |
| 2005-02-28 08:00:00 | MSFT | Stock | 25.3 | 25.31 | 25.26 | 25.28 | 67960.0 |
| 2005-02-28 09:00:00 | MSFT | Stock | 25.28 | 25.3 | 25.16 | 25.22 | 7989432.0 |
| 2005-02-28 10:00:00 | MSFT | Stock | 25.22 | 25.37 | 25.17 | 25.34 | 16109222.0 |
| 2005-02-28 11:00:00 | MSFT | Stock | 25.34 | 25.37 | 25.21 | 25.26 | 10873325.0 |
| 2005-02-28 12:00:00 | MSFT | Stock | 25.26 | 25.26 | 25.13 | 25.17 | 14311680.0 |
| 2005-02-28 13:00:00 | MSFT | Stock | 25.17 | 25.22 | 25.13 | 25.16 | 6703539.0 |
| 2005-02-28 14:00:00 | MSFT | Stock | 25.16 | 25.21 | 25.15 | 25.21 | 7526685.0 |
| 2005-02-28 15:00:00 | MSFT | Stock | 25.2 | 25.23 | 25.15 | 25.16 | 15232007.0 |
| 2005-02-28 16:00:00 | MSFT | Stock | 25.16 | 25.18 | 25.13 | 25.14 | 1265084.0 |
| 2005-02-28 17:00:00 | MSFT | Stock | 25.15 | 25.16 | 25.13 | 25.14 | 22130.0 |
| 2005-02-28 18:00:00 | MSFT | Stock | 25.15 | 25.15 | 25.15 | 25.15 | 1127.0 |
| 2005-02-28 08:00:00 | NVDA | Stock | 0.2403 | 0.2403 | 0.2403 | 0.2403 | 60000.0 |
| 2005-02-28 09:00:00 | NVDA | Stock | 0.2398 | 0.2417 | 0.2392 | 0.2402 | 103373760.0 |
| 2005-02-28 10:00:00 | NVDA | Stock | 0.2402 | 0.2408 | 0.2386 | 0.2396 | 96921720.0 |
| 2005-02-28 11:00:00 | NVDA | Stock | 0.2395 | 0.2399 | 0.2372 | 0.2394 | 78777840.0 |
| 2005-02-28 12:00:00 | NVDA | Stock | 0.2394 | 0.2395 | 0.2377 | 0.2386 | 52549680.0 |
| 2005-02-28 13:00:00 | NVDA | Stock | 0.2386 | 0.2387 | 0.2372 | 0.2374 | 53151600.0 |
| 2005-02-28 14:00:00 | NVDA | Stock | 0.2374 | 0.239 | 0.2371 | 0.2377 | 77176560.0 |
| 2005-02-28 15:00:00 | NVDA | Stock | 0.2377 | 0.2416 | 0.2374 | 0.2416 | 246840480.0 |
| 2005-02-28 16:00:00 | NVDA | Stock | 0.2408 | 0.2417 | 0.2406 | 0.2417 | 13599120.0 |
| 2005-02-28 17:00:00 | NVDA | Stock | 0.2417 | 0.2421 | 0.2417 | 0.2421 | 193920.0 |
| 2005-02-28 09:00:00 | AMZN | Stock | 1.7375 | 1.758 | 1.731 | 1.757 | 13042620.0 |
| 2005-02-28 10:00:00 | AMZN | Stock | 1.7565 | 1.771 | 1.746 | 1.769 | 20063900.0 |
| 2005-02-28 11:00:00 | AMZN | Stock | 1.7685 | 1.77 | 1.755 | 1.7625 | 26035640.0 |
| 2005-02-28 12:00:00 | AMZN | Stock | 1.7625 | 1.768 | 1.7515 | 1.765 | 24779660.0 |
| 2005-02-28 13:00:00 | AMZN | Stock | 1.765 | 1.7695 | 1.761 | 1.7645 | 12139140.0 |
| 2005-02-28 14:00:00 | AMZN | Stock | 1.7645 | 1.783 | 1.7475 | 1.7775 | 25857240.0 |
| 2005-02-28 15:00:00 | AMZN | Stock | 1.777 | 1.778 | 1.759 | 1.759 | 42459500.0 |
| 2005-02-28 16:00:00 | AMZN | Stock | 1.7605 | 1.772 | 1.7589 | 1.759 | 1435600.0 |
| 2005-02-28 17:00:00 | AMZN | Stock | 1.7595 | 1.7595 | 1.7595 | 1.7595 | 2000.0 |
| 2005-02-28 18:00:00 | AMZN | Stock | 1.7575 | 1.7575 | 1.7575 | 1.7575 | 5000.0 |
| 2005-02-28 09:00:00 | CL | Stock | 26.21 | 26.345 | 26.1 | 26.335 | 300200.0 |
| 2005-02-28 10:00:00 | CL | Stock | 26.35 | 26.415 | 26.305 | 26.37 | 427400.0 |
| 2005-02-28 11:00:00 | CL | Stock | 26.375 | 26.38 | 26.27 | 26.36 | 505000.0 |
| 2005-02-28 12:00:00 | CL | Stock | 26.37 | 26.405 | 26.345 | 26.36 | 450800.0 |
| 2005-02-28 13:00:00 | CL | Stock | 26.365 | 26.395 | 26.345 | 26.375 | 470800.0 |
| 2005-02-28 14:00:00 | CL | Stock | 26.38 | 26.45 | 26.35 | 26.4 | 530600.0 |
| 2005-02-28 15:00:00 | CL | Stock | 26.4 | 26.49 | 26.365 | 26.435 | 970400.0 |
| 2005-02-28 16:00:00 | CL | Stock | 26.415 | 26.46 | 26.415 | 26.46 | 26000.0 |
> showing 50 of 25,397 rows — these rows as CSV