PREVIEW / stock_1hour / 2008-07-18
file: by_date/stock_1hour/2008/2008-07-18.parquet size: 824 KB rows: 40,131 symbols: 3,315
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 |
|---|---|---|---|---|---|---|---|
| 2008-07-18 06:00:00 | AAPL | Stock | 6.0596 | 6.0714 | 6.0596 | 6.0714 | 7000.0 |
| 2008-07-18 07:00:00 | AAPL | Stock | 6.0536 | 6.07 | 6.01 | 6.0429 | 747460.0 |
| 2008-07-18 08:00:00 | AAPL | Stock | 6.0389 | 6.0707 | 6.0182 | 6.0554 | 4646964.0 |
| 2008-07-18 09:00:00 | AAPL | Stock | 6.0521 | 6.0589 | 5.9814 | 6.0082 | 163538424.0 |
| 2008-07-18 10:00:00 | AAPL | Stock | 6.0093 | 6.0407 | 5.9925 | 5.9986 | 106398404.0 |
| 2008-07-18 11:00:00 | AAPL | Stock | 5.9989 | 6.0332 | 5.9854 | 6.0 | 93040080.0 |
| 2008-07-18 12:00:00 | AAPL | Stock | 6.0 | 6.005 | 5.9286 | 5.9339 | 121057664.0 |
| 2008-07-18 13:00:00 | AAPL | Stock | 5.9336 | 5.9546 | 5.9107 | 5.9343 | 105338716.0 |
| 2008-07-18 14:00:00 | AAPL | Stock | 5.9343 | 5.9525 | 5.9096 | 5.93 | 77884576.0 |
| 2008-07-18 15:00:00 | AAPL | Stock | 5.9289 | 5.9449 | 5.8929 | 5.9018 | 151780748.0 |
| 2008-07-18 16:00:00 | AAPL | Stock | 5.9004 | 5.9704 | 5.8868 | 5.8946 | 18788308.0 |
| 2008-07-18 17:00:00 | AAPL | Stock | 5.8943 | 5.9368 | 5.8932 | 5.9321 | 6030416.0 |
| 2008-07-18 18:00:00 | AAPL | Stock | 5.9321 | 5.9346 | 5.9161 | 5.9179 | 365568.0 |
| 2008-07-18 19:00:00 | AAPL | Stock | 5.9221 | 5.9282 | 5.9114 | 5.9114 | 319956.0 |
| 2008-07-18 05:00:00 | MSFT | Stock | 25.92 | 25.92 | 25.91 | 25.91 | 1500.0 |
| 2008-07-18 06:00:00 | MSFT | Stock | 26.01 | 26.22 | 26.01 | 26.01 | 4800.0 |
| 2008-07-18 07:00:00 | MSFT | Stock | 26.01 | 26.25 | 25.86 | 26.15 | 252774.0 |
| 2008-07-18 08:00:00 | MSFT | Stock | 26.15 | 26.33 | 26.01 | 26.22 | 675250.0 |
| 2008-07-18 09:00:00 | MSFT | Stock | 26.22 | 26.47 | 25.63 | 25.78 | 35581768.0 |
| 2008-07-18 10:00:00 | MSFT | Stock | 25.773 | 25.878 | 25.11 | 25.31 | 33414719.0 |
| 2008-07-18 11:00:00 | MSFT | Stock | 25.31 | 25.64 | 25.31 | 25.49 | 15287357.0 |
| 2008-07-18 12:00:00 | MSFT | Stock | 25.49 | 25.51 | 25.36 | 25.41 | 10036650.0 |
| 2008-07-18 13:00:00 | MSFT | Stock | 25.41 | 25.74 | 25.41 | 25.63 | 13270104.0 |
| 2008-07-18 14:00:00 | MSFT | Stock | 25.62 | 25.76 | 25.56 | 25.663 | 9367716.0 |
| 2008-07-18 15:00:00 | MSFT | Stock | 25.66 | 25.91 | 25.55 | 25.89 | 21472313.0 |
| 2008-07-18 16:00:00 | MSFT | Stock | 25.86 | 25.9 | 25.4 | 25.8 | 6573681.0 |
| 2008-07-18 17:00:00 | MSFT | Stock | 25.86 | 25.88 | 25.734 | 25.84 | 102829.0 |
| 2008-07-18 18:00:00 | MSFT | Stock | 25.8 | 25.85 | 25.79 | 25.83 | 9797.0 |
| 2008-07-18 19:00:00 | MSFT | Stock | 25.85 | 25.91 | 25.85 | 25.85 | 11673.0 |
| 2008-07-18 08:00:00 | NVDA | Stock | 0.2798 | 0.2812 | 0.2788 | 0.2812 | 268520.0 |
| 2008-07-18 09:00:00 | NVDA | Stock | 0.28 | 0.284 | 0.274 | 0.274 | 124769680.0 |
| 2008-07-18 10:00:00 | NVDA | Stock | 0.2742 | 0.2815 | 0.274 | 0.2796 | 117371560.0 |
| 2008-07-18 11:00:00 | NVDA | Stock | 0.2796 | 0.285 | 0.278 | 0.2848 | 111979680.0 |
| 2008-07-18 12:00:00 | NVDA | Stock | 0.2848 | 0.2858 | 0.281 | 0.282 | 119119600.0 |
| 2008-07-18 13:00:00 | NVDA | Stock | 0.282 | 0.287 | 0.2819 | 0.2845 | 128707760.0 |
| 2008-07-18 14:00:00 | NVDA | Stock | 0.2842 | 0.2898 | 0.283 | 0.288 | 134539960.0 |
| 2008-07-18 15:00:00 | NVDA | Stock | 0.2878 | 0.2908 | 0.2872 | 0.289 | 140791160.0 |
| 2008-07-18 16:00:00 | NVDA | Stock | 0.289 | 0.2898 | 0.2831 | 0.289 | 14418280.0 |
| 2008-07-18 17:00:00 | NVDA | Stock | 0.289 | 0.289 | 0.289 | 0.289 | 3307560.0 |
| 2008-07-18 18:00:00 | NVDA | Stock | 0.2898 | 0.2905 | 0.2898 | 0.2905 | 45880.0 |
| 2008-07-18 19:00:00 | NVDA | Stock | 0.2905 | 0.2905 | 0.2905 | 0.2905 | 36000.0 |
| 2008-07-18 08:00:00 | AMZN | Stock | 3.4685 | 3.6055 | 3.4685 | 3.6055 | 2315000.0 |
| 2008-07-18 09:00:00 | AMZN | Stock | 3.4845 | 3.5395 | 3.475 | 3.496 | 30826060.0 |
| 2008-07-18 10:00:00 | AMZN | Stock | 3.4944 | 3.5375 | 3.4645 | 3.5 | 28856700.0 |
| 2008-07-18 11:00:00 | AMZN | Stock | 3.501 | 3.542 | 3.4865 | 3.4885 | 14640480.0 |
| 2008-07-18 12:00:00 | AMZN | Stock | 3.4865 | 3.4955 | 3.4275 | 3.433 | 16943880.0 |
| 2008-07-18 13:00:00 | AMZN | Stock | 3.433 | 3.4785 | 3.4325 | 3.472 | 9939780.0 |
| 2008-07-18 14:00:00 | AMZN | Stock | 3.4725 | 3.4985 | 3.457 | 3.46 | 11503040.0 |
| 2008-07-18 15:00:00 | AMZN | Stock | 3.4605 | 3.4625 | 3.42 | 3.4555 | 36948520.0 |
| 2008-07-18 16:00:00 | AMZN | Stock | 3.4555 | 3.6055 | 3.45 | 3.456 | 10173160.0 |
> showing 50 of 40,131 rows — these rows as CSV