PREVIEW / stock_1hour / 2021-02-10
file: by_date/stock_1hour/2021/2021-02-10.parquet size: 1.5 MB rows: 70,422 symbols: 2,810
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 |
|---|---|---|---|---|---|---|---|
| 2021-02-10 04:00:00 | AAPL | Stock | 136.7 | 136.85 | 136.35 | 136.41 | 32925.0 |
| 2021-02-10 05:00:00 | AAPL | Stock | 136.36 | 136.68 | 136.35 | 136.51 | 8001.0 |
| 2021-02-10 06:00:00 | AAPL | Stock | 136.5 | 136.6 | 136.41 | 136.45 | 11385.0 |
| 2021-02-10 07:00:00 | AAPL | Stock | 136.41 | 136.56 | 136.38 | 136.45 | 125051.0 |
| 2021-02-10 08:00:00 | AAPL | Stock | 136.446 | 136.6 | 136.05 | 136.4 | 349269.0 |
| 2021-02-10 09:00:00 | AAPL | Stock | 136.4 | 136.99 | 136.0 | 136.39 | 7466432.0 |
| 2021-02-10 10:00:00 | AAPL | Stock | 136.38 | 136.73 | 134.4 | 135.356 | 15645011.0 |
| 2021-02-10 11:00:00 | AAPL | Stock | 135.35 | 135.65 | 134.82 | 135.41 | 6878292.0 |
| 2021-02-10 12:00:00 | AAPL | Stock | 135.415 | 135.46 | 135.04 | 135.085 | 4683023.0 |
| 2021-02-10 13:00:00 | AAPL | Stock | 135.09 | 135.24 | 134.93 | 135.067 | 3643082.0 |
| 2021-02-10 14:00:00 | AAPL | Stock | 135.07 | 135.84 | 135.04 | 135.604 | 5355980.0 |
| 2021-02-10 15:00:00 | AAPL | Stock | 135.61 | 135.8 | 134.95 | 135.36 | 8302347.0 |
| 2021-02-10 16:00:00 | AAPL | Stock | 135.39 | 135.42 | 135.15 | 135.29 | 5789144.0 |
| 2021-02-10 17:00:00 | AAPL | Stock | 135.32 | 135.32 | 135.15 | 135.2 | 43202.0 |
| 2021-02-10 18:00:00 | AAPL | Stock | 135.2 | 135.3 | 135.16 | 135.27 | 41398.0 |
| 2021-02-10 19:00:00 | AAPL | Stock | 135.25 | 135.27 | 134.92 | 134.92 | 125529.0 |
| 2021-02-10 04:00:00 | MSFT | Stock | 244.99 | 245.0 | 244.65 | 244.65 | 2864.0 |
| 2021-02-10 05:00:00 | MSFT | Stock | 244.55 | 244.7 | 244.55 | 244.7 | 1025.0 |
| 2021-02-10 06:00:00 | MSFT | Stock | 244.7 | 244.9 | 244.46 | 244.46 | 5452.0 |
| 2021-02-10 07:00:00 | MSFT | Stock | 244.3 | 244.72 | 244.15 | 244.16 | 5723.0 |
| 2021-02-10 08:00:00 | MSFT | Stock | 244.486 | 244.8 | 244.12 | 244.71 | 15010.0 |
| 2021-02-10 09:00:00 | MSFT | Stock | 244.8 | 245.92 | 243.882 | 244.555 | 1918838.0 |
| 2021-02-10 10:00:00 | MSFT | Stock | 244.54 | 245.57 | 241.31 | 241.88 | 3284881.0 |
| 2021-02-10 11:00:00 | MSFT | Stock | 241.875 | 242.137 | 241.09 | 241.25 | 2408043.0 |
| 2021-02-10 12:00:00 | MSFT | Stock | 241.275 | 241.88 | 240.89 | 241.69 | 1406570.0 |
| 2021-02-10 13:00:00 | MSFT | Stock | 241.67 | 242.6 | 241.54 | 241.9 | 1545912.0 |
| 2021-02-10 14:00:00 | MSFT | Stock | 241.89 | 243.38 | 241.8 | 243.32 | 1444759.0 |
| 2021-02-10 15:00:00 | MSFT | Stock | 243.33 | 243.776 | 242.23 | 242.81 | 2462959.0 |
| 2021-02-10 16:00:00 | MSFT | Stock | 242.82 | 243.4 | 242.56 | 242.85 | 3230571.0 |
| 2021-02-10 17:00:00 | MSFT | Stock | 242.9 | 243.1 | 242.74 | 242.75 | 4323.0 |
| 2021-02-10 18:00:00 | MSFT | Stock | 242.68 | 242.93 | 242.45 | 242.53 | 4594.0 |
| 2021-02-10 19:00:00 | MSFT | Stock | 242.54 | 242.54 | 241.85 | 241.89 | 9955.0 |
| 2021-02-10 04:00:00 | NVDA | Stock | 14.3435 | 14.3435 | 14.3435 | 14.3435 | 4000.0 |
| 2021-02-10 06:00:00 | NVDA | Stock | 14.35 | 14.375 | 14.35 | 14.3508 | 38360.0 |
| 2021-02-10 07:00:00 | NVDA | Stock | 14.3528 | 14.3812 | 14.3528 | 14.38 | 235160.0 |
| 2021-02-10 08:00:00 | NVDA | Stock | 14.3625 | 14.4442 | 14.3625 | 14.4412 | 800640.0 |
| 2021-02-10 09:00:00 | NVDA | Stock | 14.4435 | 14.7488 | 14.4135 | 14.7174 | 57804560.0 |
| 2021-02-10 10:00:00 | NVDA | Stock | 14.7175 | 14.8412 | 14.3414 | 14.5222 | 137557000.0 |
| 2021-02-10 11:00:00 | NVDA | Stock | 14.5218 | 14.7648 | 14.45 | 14.7085 | 45366160.0 |
| 2021-02-10 12:00:00 | NVDA | Stock | 14.7122 | 14.758 | 14.6275 | 14.7225 | 30659960.0 |
| 2021-02-10 13:00:00 | NVDA | Stock | 14.7222 | 14.7772 | 14.6322 | 14.6748 | 17804600.0 |
| 2021-02-10 14:00:00 | NVDA | Stock | 14.679 | 14.8965 | 14.6688 | 14.8512 | 41399200.0 |
| 2021-02-10 15:00:00 | NVDA | Stock | 14.8539 | 14.905 | 14.68 | 14.7643 | 53604880.0 |
| 2021-02-10 16:00:00 | NVDA | Stock | 14.7643 | 14.845 | 14.7125 | 14.845 | 10780400.0 |
| 2021-02-10 17:00:00 | NVDA | Stock | 14.8455 | 14.8455 | 14.8058 | 14.8062 | 285000.0 |
| 2021-02-10 18:00:00 | NVDA | Stock | 14.8075 | 14.8192 | 14.7662 | 14.778 | 438520.0 |
| 2021-02-10 19:00:00 | NVDA | Stock | 14.8105 | 14.8105 | 14.7505 | 14.7568 | 472400.0 |
| 2021-02-10 04:00:00 | AMZN | Stock | 165.5 | 165.7 | 165.5 | 165.65 | 17240.0 |
| 2021-02-10 05:00:00 | AMZN | Stock | 165.5 | 165.5 | 165.5 | 165.5 | 2220.0 |
| 2021-02-10 06:00:00 | AMZN | Stock | 165.6335 | 165.6335 | 165.5505 | 165.5505 | 4940.0 |
> showing 50 of 70,422 rows — these rows as CSV