PREVIEW / stock_1hour / 2009-03-24
file: by_date/stock_1hour/2009/2009-03-24.parquet size: 836 KB rows: 42,055 symbols: 3,309
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 |
|---|---|---|---|---|---|---|---|
| 2009-03-24 06:00:00 | AAPL | Stock | 3.7929 | 3.7929 | 3.7761 | 3.7761 | 22400.0 |
| 2009-03-24 07:00:00 | AAPL | Stock | 3.7757 | 3.8121 | 3.7757 | 3.8036 | 110040.0 |
| 2009-03-24 08:00:00 | AAPL | Stock | 3.8036 | 3.8214 | 3.7982 | 3.8043 | 880712.0 |
| 2009-03-24 09:00:00 | AAPL | Stock | 3.8039 | 3.845 | 3.7857 | 3.8107 | 77655900.0 |
| 2009-03-24 10:00:00 | AAPL | Stock | 3.8093 | 3.8282 | 3.7643 | 3.8064 | 101793552.0 |
| 2009-03-24 11:00:00 | AAPL | Stock | 3.8064 | 3.8393 | 3.7968 | 3.8189 | 72822568.0 |
| 2009-03-24 12:00:00 | AAPL | Stock | 3.8193 | 3.8875 | 3.8054 | 3.8829 | 92417388.0 |
| 2009-03-24 13:00:00 | AAPL | Stock | 3.8829 | 3.9086 | 3.8054 | 3.8558 | 86832396.0 |
| 2009-03-24 14:00:00 | AAPL | Stock | 3.8568 | 3.8896 | 3.8229 | 3.8321 | 80886316.0 |
| 2009-03-24 15:00:00 | AAPL | Stock | 3.8329 | 3.8339 | 3.795 | 3.8043 | 107616880.0 |
| 2009-03-24 16:00:00 | AAPL | Stock | 3.8039 | 3.8487 | 3.7929 | 3.8093 | 1825348.0 |
| 2009-03-24 17:00:00 | AAPL | Stock | 3.8096 | 3.8154 | 3.8036 | 3.8136 | 2202648.0 |
| 2009-03-24 18:00:00 | AAPL | Stock | 3.8157 | 3.8204 | 3.81 | 3.8189 | 6152888.0 |
| 2009-03-24 19:00:00 | AAPL | Stock | 3.8139 | 3.8214 | 3.8125 | 3.8211 | 302708.0 |
| 2009-03-24 20:00:00 | AAPL | Stock | 3.8164 | 3.8164 | 3.8164 | 3.8164 | 2205000.0 |
| 2009-03-24 07:00:00 | MSFT | Stock | 18.26 | 18.26 | 18.24 | 18.25 | 600.0 |
| 2009-03-24 08:00:00 | MSFT | Stock | 18.25 | 18.25 | 18.02 | 18.05 | 13590.0 |
| 2009-03-24 09:00:00 | MSFT | Stock | 18.06 | 18.33 | 17.92 | 18.09 | 7377830.0 |
| 2009-03-24 10:00:00 | MSFT | Stock | 18.09 | 18.2 | 17.91 | 18.01 | 8359800.0 |
| 2009-03-24 11:00:00 | MSFT | Stock | 18.008 | 18.13 | 17.95 | 17.95 | 4354127.0 |
| 2009-03-24 12:00:00 | MSFT | Stock | 17.96 | 18.12 | 17.9 | 18.09 | 5652184.0 |
| 2009-03-24 13:00:00 | MSFT | Stock | 18.09 | 18.16 | 17.98 | 18.04 | 5699668.0 |
| 2009-03-24 14:00:00 | MSFT | Stock | 18.04 | 18.17 | 17.99 | 18.02 | 6157924.0 |
| 2009-03-24 15:00:00 | MSFT | Stock | 18.02 | 18.06 | 17.85 | 17.93 | 9786977.0 |
| 2009-03-24 16:00:00 | MSFT | Stock | 17.92 | 18.036 | 17.84 | 17.91 | 295863.0 |
| 2009-03-24 17:00:00 | MSFT | Stock | 17.87 | 17.93 | 17.84 | 17.9 | 1154147.0 |
| 2009-03-24 18:00:00 | MSFT | Stock | 17.88 | 17.95 | 17.85 | 17.95 | 155782.0 |
| 2009-03-24 19:00:00 | MSFT | Stock | 17.88 | 17.91 | 17.88 | 17.91 | 4772.0 |
| 2009-03-24 20:00:00 | MSFT | Stock | 17.96 | 17.96 | 17.96 | 17.96 | 36000.0 |
| 2009-03-24 08:00:00 | NVDA | Stock | 0.2518 | 0.2518 | 0.2518 | 0.2518 | 60000.0 |
| 2009-03-24 09:00:00 | NVDA | Stock | 0.25 | 0.2555 | 0.2434 | 0.248 | 136686880.0 |
| 2009-03-24 10:00:00 | NVDA | Stock | 0.248 | 0.2493 | 0.245 | 0.2455 | 264978240.0 |
| 2009-03-24 11:00:00 | NVDA | Stock | 0.2455 | 0.2498 | 0.2445 | 0.2475 | 172911840.0 |
| 2009-03-24 12:00:00 | NVDA | Stock | 0.2475 | 0.2513 | 0.247 | 0.2507 | 102514640.0 |
| 2009-03-24 13:00:00 | NVDA | Stock | 0.2507 | 0.2515 | 0.2478 | 0.248 | 86256480.0 |
| 2009-03-24 14:00:00 | NVDA | Stock | 0.248 | 0.2495 | 0.2453 | 0.2463 | 104868360.0 |
| 2009-03-24 15:00:00 | NVDA | Stock | 0.2464 | 0.248 | 0.2438 | 0.2445 | 225171560.0 |
| 2009-03-24 16:00:00 | NVDA | Stock | 0.2475 | 0.2475 | 0.2438 | 0.2438 | 3804040.0 |
| 2009-03-24 17:00:00 | NVDA | Stock | 0.2438 | 0.2453 | 0.2425 | 0.2448 | 4049280.0 |
| 2009-03-24 18:00:00 | NVDA | Stock | 0.245 | 0.245 | 0.245 | 0.245 | 7000.0 |
| 2009-03-24 19:00:00 | NVDA | Stock | 0.245 | 0.245 | 0.245 | 0.245 | 29000.0 |
| 2009-03-24 04:00:00 | AMZN | Stock | 3.7675 | 3.7675 | 3.7675 | 3.7675 | 10000.0 |
| 2009-03-24 07:00:00 | AMZN | Stock | 3.7525 | 3.7525 | 3.7525 | 3.7525 | 2000.0 |
| 2009-03-24 08:00:00 | AMZN | Stock | 3.7725 | 3.7725 | 3.7375 | 3.7475 | 108800.0 |
| 2009-03-24 09:00:00 | AMZN | Stock | 3.7455 | 3.779 | 3.681 | 3.7019 | 22411860.0 |
| 2009-03-24 10:00:00 | AMZN | Stock | 3.7005 | 3.7185 | 3.616 | 3.6405 | 32961360.0 |
| 2009-03-24 11:00:00 | AMZN | Stock | 3.64 | 3.6765 | 3.634 | 3.6375 | 14106160.0 |
| 2009-03-24 12:00:00 | AMZN | Stock | 3.638 | 3.69 | 3.631 | 3.681 | 10828340.0 |
| 2009-03-24 13:00:00 | AMZN | Stock | 3.6815 | 3.7055 | 3.6625 | 3.6715 | 15713580.0 |
| 2009-03-24 14:00:00 | AMZN | Stock | 3.672 | 3.6875 | 3.646 | 3.6525 | 11490560.0 |
> showing 50 of 42,055 rows — these rows as CSV