PREVIEW / stock_1hour / 2006-11-15
file: by_date/stock_1hour/2006/2006-11-15.parquet size: 635 KB rows: 30,111 symbols: 2,440
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 |
|---|---|---|---|---|---|---|---|
| 2006-11-15 07:00:00 | AAPL | Stock | 3.0407 | 3.0464 | 3.0368 | 3.0464 | 358400.0 |
| 2006-11-15 08:00:00 | AAPL | Stock | 3.0496 | 3.0536 | 3.0429 | 3.0511 | 2144884.0 |
| 2006-11-15 09:00:00 | AAPL | Stock | 3.0511 | 3.0675 | 3.0368 | 3.0621 | 84313740.0 |
| 2006-11-15 10:00:00 | AAPL | Stock | 3.0621 | 3.0679 | 3.0393 | 3.0393 | 94575124.0 |
| 2006-11-15 11:00:00 | AAPL | Stock | 3.0393 | 3.0439 | 3.0268 | 3.0362 | 93150568.0 |
| 2006-11-15 12:00:00 | AAPL | Stock | 3.0361 | 3.0486 | 3.0268 | 3.0311 | 85267252.0 |
| 2006-11-15 13:00:00 | AAPL | Stock | 3.0311 | 3.0375 | 3.0089 | 3.0218 | 93714600.0 |
| 2006-11-15 14:00:00 | AAPL | Stock | 3.0218 | 3.0346 | 3.0061 | 3.0089 | 97742344.0 |
| 2006-11-15 15:00:00 | AAPL | Stock | 3.0089 | 3.0179 | 3.0 | 3.0014 | 86214016.0 |
| 2006-11-15 16:00:00 | AAPL | Stock | 3.0 | 3.0054 | 3.0 | 3.0054 | 3877048.0 |
| 2006-11-15 17:00:00 | AAPL | Stock | 3.0036 | 3.0064 | 3.0004 | 3.0064 | 146048.0 |
| 2006-11-15 18:00:00 | AAPL | Stock | 3.0064 | 3.0321 | 3.0064 | 3.0271 | 3854032.0 |
| 2006-11-15 19:00:00 | AAPL | Stock | 3.0257 | 3.0275 | 3.0243 | 3.025 | 312508.0 |
| 2006-11-15 07:00:00 | MSFT | Stock | 29.11 | 29.2 | 29.11 | 29.2 | 694.0 |
| 2006-11-15 08:00:00 | MSFT | Stock | 29.12 | 29.15 | 29.11 | 29.13 | 344811.0 |
| 2006-11-15 09:00:00 | MSFT | Stock | 29.13 | 29.33 | 29.1 | 29.257 | 7493031.0 |
| 2006-11-15 10:00:00 | MSFT | Stock | 29.25 | 29.36 | 29.13 | 29.34 | 9340447.0 |
| 2006-11-15 11:00:00 | MSFT | Stock | 29.35 | 29.35 | 29.26 | 29.28 | 5364508.0 |
| 2006-11-15 12:00:00 | MSFT | Stock | 29.28 | 29.33 | 29.23 | 29.23 | 6233772.0 |
| 2006-11-15 13:00:00 | MSFT | Stock | 29.23 | 29.27 | 29.22 | 29.248 | 4100227.0 |
| 2006-11-15 14:00:00 | MSFT | Stock | 29.25 | 29.3 | 29.18 | 29.21 | 10808648.0 |
| 2006-11-15 15:00:00 | MSFT | Stock | 29.215 | 29.27 | 29.11 | 29.11 | 10823831.0 |
| 2006-11-15 16:00:00 | MSFT | Stock | 29.11 | 29.312 | 29.11 | 29.12 | 1044330.0 |
| 2006-11-15 17:00:00 | MSFT | Stock | 29.11 | 29.13 | 29.1 | 29.1 | 14820.0 |
| 2006-11-15 18:00:00 | MSFT | Stock | 29.12 | 29.12 | 29.02 | 29.05 | 35629.0 |
| 2006-11-15 19:00:00 | MSFT | Stock | 29.03 | 29.09 | 29.03 | 29.08 | 7186.0 |
| 2006-11-15 08:00:00 | NVDA | Stock | 0.6095 | 0.6095 | 0.5993 | 0.5995 | 270000.0 |
| 2006-11-15 09:00:00 | NVDA | Stock | 0.6058 | 0.6125 | 0.6007 | 0.6088 | 78403800.0 |
| 2006-11-15 10:00:00 | NVDA | Stock | 0.6092 | 0.6105 | 0.6005 | 0.601 | 90736020.0 |
| 2006-11-15 11:00:00 | NVDA | Stock | 0.601 | 0.6022 | 0.5983 | 0.5993 | 63358320.0 |
| 2006-11-15 12:00:00 | NVDA | Stock | 0.5994 | 0.6057 | 0.5987 | 0.6052 | 45191400.0 |
| 2006-11-15 13:00:00 | NVDA | Stock | 0.6052 | 0.6052 | 0.6025 | 0.6027 | 30076560.0 |
| 2006-11-15 14:00:00 | NVDA | Stock | 0.6027 | 0.6035 | 0.5927 | 0.5945 | 92344920.0 |
| 2006-11-15 15:00:00 | NVDA | Stock | 0.5943 | 0.599 | 0.5942 | 0.596 | 76476720.0 |
| 2006-11-15 16:00:00 | NVDA | Stock | 0.596 | 0.5973 | 0.5952 | 0.596 | 7443420.0 |
| 2006-11-15 17:00:00 | NVDA | Stock | 0.5962 | 0.5962 | 0.596 | 0.5962 | 216000.0 |
| 2006-11-15 18:00:00 | NVDA | Stock | 0.5962 | 0.5962 | 0.5962 | 0.5962 | 42000.0 |
| 2006-11-15 19:00:00 | NVDA | Stock | 0.5957 | 0.5957 | 0.595 | 0.595 | 256800.0 |
| 2006-11-15 08:00:00 | AMZN | Stock | 2.085 | 2.0875 | 2.08 | 2.0835 | 176000.0 |
| 2006-11-15 09:00:00 | AMZN | Stock | 2.081 | 2.132 | 2.075 | 2.131 | 44573240.0 |
| 2006-11-15 10:00:00 | AMZN | Stock | 2.131 | 2.155 | 2.1225 | 2.1275 | 72905680.0 |
| 2006-11-15 11:00:00 | AMZN | Stock | 2.1275 | 2.129 | 2.1135 | 2.126 | 32496920.0 |
| 2006-11-15 12:00:00 | AMZN | Stock | 2.126 | 2.15 | 2.125 | 2.1445 | 25983200.0 |
| 2006-11-15 13:00:00 | AMZN | Stock | 2.1445 | 2.1525 | 2.1405 | 2.1475 | 20466480.0 |
| 2006-11-15 14:00:00 | AMZN | Stock | 2.1475 | 2.154 | 2.1215 | 2.1275 | 34178700.0 |
| 2006-11-15 15:00:00 | AMZN | Stock | 2.127 | 2.1345 | 2.122 | 2.13 | 35627820.0 |
| 2006-11-15 16:00:00 | AMZN | Stock | 2.1295 | 2.1355 | 2.129 | 2.135 | 978540.0 |
| 2006-11-15 17:00:00 | AMZN | Stock | 2.13 | 2.13 | 2.1275 | 2.13 | 41900.0 |
| 2006-11-15 18:00:00 | AMZN | Stock | 2.1325 | 2.135 | 2.1275 | 2.1285 | 60000.0 |
| 2006-11-15 19:00:00 | AMZN | Stock | 2.1285 | 2.1285 | 2.1285 | 2.1285 | 2000.0 |
> showing 50 of 30,111 rows — these rows as CSV