PREVIEW / stock_1hour / 2009-05-11
file: by_date/stock_1hour/2009/2009-05-11.parquet size: 884 KB rows: 43,956 symbols: 3,348
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-05-11 04:00:00 | AAPL | Stock | 4.67 | 4.67 | 4.67 | 4.67 | 2800.0 |
| 2009-05-11 07:00:00 | AAPL | Stock | 4.5714 | 4.5714 | 4.5554 | 4.5554 | 32116.0 |
| 2009-05-11 08:00:00 | AAPL | Stock | 4.5804 | 4.5804 | 4.5571 | 4.5696 | 533540.0 |
| 2009-05-11 09:00:00 | AAPL | Stock | 4.5679 | 4.5964 | 4.54 | 4.5657 | 55428352.0 |
| 2009-05-11 10:00:00 | AAPL | Stock | 4.5661 | 4.6707 | 4.5554 | 4.63 | 95321660.0 |
| 2009-05-11 11:00:00 | AAPL | Stock | 4.63 | 4.6564 | 4.6182 | 4.6304 | 45503864.0 |
| 2009-05-11 12:00:00 | AAPL | Stock | 4.6304 | 4.655 | 4.6196 | 4.6289 | 35683032.0 |
| 2009-05-11 13:00:00 | AAPL | Stock | 4.6293 | 4.6771 | 4.6287 | 4.6636 | 44316412.0 |
| 2009-05-11 14:00:00 | AAPL | Stock | 4.6636 | 4.6654 | 4.6429 | 4.6554 | 41657504.0 |
| 2009-05-11 15:00:00 | AAPL | Stock | 4.6564 | 4.6571 | 4.6071 | 4.6257 | 63531692.0 |
| 2009-05-11 16:00:00 | AAPL | Stock | 4.6239 | 4.64 | 4.6071 | 4.625 | 15442476.0 |
| 2009-05-11 17:00:00 | AAPL | Stock | 4.6214 | 4.6275 | 4.6196 | 4.6196 | 198968.0 |
| 2009-05-11 18:00:00 | AAPL | Stock | 4.6275 | 4.6275 | 4.6075 | 4.6075 | 193648.0 |
| 2009-05-11 19:00:00 | AAPL | Stock | 4.6143 | 4.6143 | 4.6107 | 4.6107 | 74200.0 |
| 2009-05-11 07:00:00 | MSFT | Stock | 19.4 | 19.4 | 19.26 | 19.36 | 9600.0 |
| 2009-05-11 08:00:00 | MSFT | Stock | 19.31 | 19.34 | 19.27 | 19.27 | 13163.0 |
| 2009-05-11 09:00:00 | MSFT | Stock | 19.27 | 19.35 | 19.01 | 19.24 | 7316379.0 |
| 2009-05-11 10:00:00 | MSFT | Stock | 19.23 | 19.73 | 19.18 | 19.64 | 14324599.0 |
| 2009-05-11 11:00:00 | MSFT | Stock | 19.641 | 19.7 | 19.32 | 19.338 | 9864120.0 |
| 2009-05-11 12:00:00 | MSFT | Stock | 19.33 | 19.5 | 19.31 | 19.43 | 3697757.0 |
| 2009-05-11 13:00:00 | MSFT | Stock | 19.44 | 19.67 | 19.41 | 19.652 | 5537649.0 |
| 2009-05-11 14:00:00 | MSFT | Stock | 19.66 | 19.67 | 19.44 | 19.442 | 7697741.0 |
| 2009-05-11 15:00:00 | MSFT | Stock | 19.44 | 19.55 | 19.33 | 19.33 | 11519322.0 |
| 2009-05-11 16:00:00 | MSFT | Stock | 19.33 | 19.48 | 19.05 | 19.37 | 2377738.0 |
| 2009-05-11 17:00:00 | MSFT | Stock | 19.38 | 19.42 | 19.32 | 19.38 | 67018.0 |
| 2009-05-11 18:00:00 | MSFT | Stock | 19.37 | 19.38 | 19.34 | 19.34 | 12135.0 |
| 2009-05-11 19:00:00 | MSFT | Stock | 19.34 | 19.37 | 19.34 | 19.37 | 3525.0 |
| 2009-05-11 08:00:00 | NVDA | Stock | 0.2332 | 0.2335 | 0.2288 | 0.229 | 1369680.0 |
| 2009-05-11 09:00:00 | NVDA | Stock | 0.2292 | 0.2342 | 0.2255 | 0.2335 | 158555000.0 |
| 2009-05-11 10:00:00 | NVDA | Stock | 0.2335 | 0.2415 | 0.2332 | 0.2382 | 274603720.0 |
| 2009-05-11 11:00:00 | NVDA | Stock | 0.2385 | 0.2415 | 0.2362 | 0.2378 | 134232360.0 |
| 2009-05-11 12:00:00 | NVDA | Stock | 0.2375 | 0.2395 | 0.2365 | 0.2385 | 70394920.0 |
| 2009-05-11 13:00:00 | NVDA | Stock | 0.2385 | 0.2412 | 0.238 | 0.2408 | 69024160.0 |
| 2009-05-11 14:00:00 | NVDA | Stock | 0.2408 | 0.2412 | 0.2385 | 0.2395 | 96627920.0 |
| 2009-05-11 15:00:00 | NVDA | Stock | 0.2395 | 0.2398 | 0.2358 | 0.2358 | 205743760.0 |
| 2009-05-11 16:00:00 | NVDA | Stock | 0.2358 | 0.2385 | 0.2338 | 0.2338 | 18022480.0 |
| 2009-05-11 17:00:00 | NVDA | Stock | 0.2348 | 0.2358 | 0.2338 | 0.2338 | 414640.0 |
| 2009-05-11 18:00:00 | NVDA | Stock | 0.2375 | 0.2388 | 0.2358 | 0.2375 | 83840.0 |
| 2009-05-11 19:00:00 | NVDA | Stock | 0.236 | 0.2368 | 0.2358 | 0.236 | 96960.0 |
| 2009-05-11 07:00:00 | AMZN | Stock | 3.9075 | 3.9075 | 3.875 | 3.875 | 11200.0 |
| 2009-05-11 08:00:00 | AMZN | Stock | 3.875 | 3.875 | 3.84 | 3.8475 | 30360.0 |
| 2009-05-11 09:00:00 | AMZN | Stock | 3.84 | 3.88 | 3.8005 | 3.8485 | 19630520.0 |
| 2009-05-11 10:00:00 | AMZN | Stock | 3.8495 | 3.917 | 3.8425 | 3.877 | 25129440.0 |
| 2009-05-11 11:00:00 | AMZN | Stock | 3.8765 | 3.9195 | 3.8705 | 3.8905 | 12229640.0 |
| 2009-05-11 12:00:00 | AMZN | Stock | 3.8895 | 3.9375 | 3.88 | 3.909 | 11495140.0 |
| 2009-05-11 13:00:00 | AMZN | Stock | 3.9095 | 3.9925 | 3.9025 | 3.972 | 26091220.0 |
| 2009-05-11 14:00:00 | AMZN | Stock | 3.9725 | 3.9773 | 3.9535 | 3.957 | 13708700.0 |
| 2009-05-11 15:00:00 | AMZN | Stock | 3.9585 | 3.9745 | 3.925 | 3.9285 | 24652820.0 |
| 2009-05-11 16:00:00 | AMZN | Stock | 3.9305 | 3.9422 | 3.9124 | 3.9225 | 3609820.0 |
| 2009-05-11 17:00:00 | AMZN | Stock | 3.9265 | 3.9305 | 3.9225 | 3.9265 | 56420.0 |
> showing 50 of 43,956 rows — these rows as CSV