PREVIEW / stock_1hour / 2009-08-12
file: by_date/stock_1hour/2009/2009-08-12.parquet size: 862 KB rows: 41,774 symbols: 3,373
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-08-12 06:00:00 | AAPL | Stock | 5.8093 | 5.8107 | 5.8093 | 5.8107 | 22400.0 |
| 2009-08-12 07:00:00 | AAPL | Stock | 5.8214 | 5.8282 | 5.8214 | 5.8282 | 7000.0 |
| 2009-08-12 08:00:00 | AAPL | Stock | 5.8189 | 5.8214 | 5.8 | 5.8 | 634060.0 |
| 2009-08-12 09:00:00 | AAPL | Stock | 5.7986 | 5.895 | 5.7986 | 5.8932 | 61956244.0 |
| 2009-08-12 10:00:00 | AAPL | Stock | 5.8936 | 5.9171 | 5.8868 | 5.9164 | 71485904.0 |
| 2009-08-12 11:00:00 | AAPL | Stock | 5.9164 | 5.93 | 5.9107 | 5.9157 | 46699660.0 |
| 2009-08-12 12:00:00 | AAPL | Stock | 5.9157 | 5.9275 | 5.9143 | 5.9268 | 28742644.0 |
| 2009-08-12 13:00:00 | AAPL | Stock | 5.9261 | 5.9286 | 5.9089 | 5.9121 | 28233044.0 |
| 2009-08-12 14:00:00 | AAPL | Stock | 5.9125 | 5.9386 | 5.8875 | 5.9386 | 74123560.0 |
| 2009-08-12 15:00:00 | AAPL | Stock | 5.9379 | 5.9539 | 5.9018 | 5.9096 | 111246492.0 |
| 2009-08-12 16:00:00 | AAPL | Stock | 5.9057 | 5.9102 | 5.9 | 5.9086 | 13122200.0 |
| 2009-08-12 17:00:00 | AAPL | Stock | 5.9093 | 5.9132 | 5.9086 | 5.9104 | 188412.0 |
| 2009-08-12 18:00:00 | AAPL | Stock | 5.91 | 5.9168 | 5.9039 | 5.9071 | 1072764.0 |
| 2009-08-12 19:00:00 | AAPL | Stock | 5.9107 | 5.9179 | 5.9107 | 5.9161 | 62104.0 |
| 2009-08-12 07:00:00 | MSFT | Stock | 23.2 | 23.2 | 23.2 | 23.2 | 470.0 |
| 2009-08-12 08:00:00 | MSFT | Stock | 23.25 | 23.27 | 23.2 | 23.2 | 17133.0 |
| 2009-08-12 09:00:00 | MSFT | Stock | 23.2 | 23.4 | 23.03 | 23.37 | 6403431.0 |
| 2009-08-12 10:00:00 | MSFT | Stock | 23.37 | 23.53 | 23.36 | 23.49 | 9270594.0 |
| 2009-08-12 11:00:00 | MSFT | Stock | 23.49 | 23.65 | 23.46 | 23.58 | 5794911.0 |
| 2009-08-12 12:00:00 | MSFT | Stock | 23.58 | 23.68 | 23.57 | 23.68 | 3276214.0 |
| 2009-08-12 13:00:00 | MSFT | Stock | 23.68 | 23.73 | 23.61 | 23.62 | 3774616.0 |
| 2009-08-12 14:00:00 | MSFT | Stock | 23.62 | 23.84 | 23.53 | 23.84 | 8458237.0 |
| 2009-08-12 15:00:00 | MSFT | Stock | 23.84 | 23.9 | 23.53 | 23.58 | 14784716.0 |
| 2009-08-12 16:00:00 | MSFT | Stock | 23.57 | 23.61 | 23.16 | 23.56 | 7150812.0 |
| 2009-08-12 17:00:00 | MSFT | Stock | 23.15 | 23.67 | 23.15 | 23.67 | 17271.0 |
| 2009-08-12 18:00:00 | MSFT | Stock | 23.56 | 23.59 | 23.53 | 23.54 | 7365.0 |
| 2009-08-12 19:00:00 | MSFT | Stock | 23.53 | 23.62 | 23.52 | 23.62 | 24640.0 |
| 2009-08-12 07:00:00 | NVDA | Stock | 0.3225 | 0.3225 | 0.3225 | 0.3225 | 20000.0 |
| 2009-08-12 08:00:00 | NVDA | Stock | 0.3248 | 0.325 | 0.3248 | 0.325 | 105200.0 |
| 2009-08-12 09:00:00 | NVDA | Stock | 0.325 | 0.335 | 0.3238 | 0.333 | 94792040.0 |
| 2009-08-12 10:00:00 | NVDA | Stock | 0.333 | 0.3339 | 0.3298 | 0.3337 | 143565200.0 |
| 2009-08-12 11:00:00 | NVDA | Stock | 0.3335 | 0.3339 | 0.3328 | 0.3338 | 51022280.0 |
| 2009-08-12 12:00:00 | NVDA | Stock | 0.3336 | 0.3353 | 0.3335 | 0.3348 | 47453600.0 |
| 2009-08-12 13:00:00 | NVDA | Stock | 0.3348 | 0.336 | 0.3316 | 0.3345 | 34266400.0 |
| 2009-08-12 14:00:00 | NVDA | Stock | 0.3345 | 0.3375 | 0.3322 | 0.3375 | 87208200.0 |
| 2009-08-12 15:00:00 | NVDA | Stock | 0.3375 | 0.3393 | 0.3348 | 0.3362 | 153115440.0 |
| 2009-08-12 16:00:00 | NVDA | Stock | 0.336 | 0.3362 | 0.333 | 0.3358 | 19578320.0 |
| 2009-08-12 17:00:00 | NVDA | Stock | 0.3238 | 0.3309 | 0.3238 | 0.3309 | 2167720.0 |
| 2009-08-12 19:00:00 | NVDA | Stock | 0.3375 | 0.3375 | 0.3375 | 0.3375 | 13000.0 |
| 2009-08-12 08:00:00 | AMZN | Stock | 4.185 | 4.185 | 4.185 | 4.185 | 4000.0 |
| 2009-08-12 09:00:00 | AMZN | Stock | 4.1785 | 4.2345 | 4.169 | 4.229 | 11415040.0 |
| 2009-08-12 10:00:00 | AMZN | Stock | 4.2285 | 4.2625 | 4.2268 | 4.26 | 16085720.0 |
| 2009-08-12 11:00:00 | AMZN | Stock | 4.2625 | 4.2675 | 4.25 | 4.26 | 5510980.0 |
| 2009-08-12 12:00:00 | AMZN | Stock | 4.26 | 4.2635 | 4.251 | 4.258 | 5557540.0 |
| 2009-08-12 13:00:00 | AMZN | Stock | 4.2585 | 4.2815 | 4.2525 | 4.274 | 9043900.0 |
| 2009-08-12 14:00:00 | AMZN | Stock | 4.274 | 4.325 | 4.271 | 4.3205 | 20677260.0 |
| 2009-08-12 15:00:00 | AMZN | Stock | 4.3195 | 4.33 | 4.2785 | 4.2985 | 39504440.0 |
| 2009-08-12 16:00:00 | AMZN | Stock | 4.298 | 4.315 | 4.2715 | 4.2995 | 1183180.0 |
| 2009-08-12 17:00:00 | AMZN | Stock | 4.299 | 4.299 | 4.295 | 4.295 | 14000.0 |
| 2009-08-12 18:00:00 | AMZN | Stock | 4.295 | 4.296 | 4.295 | 4.296 | 389580.0 |
> showing 50 of 41,774 rows — these rows as CSV