PREVIEW / stock_30min / 2007-09-21
file: by_date/stock_30min/2007/2007-09-21.parquet size: 1.2 MB rows: 65,484 symbols: 3,120
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 |
|---|---|---|---|---|---|---|---|
| 2007-09-21 09:30:00 | AAPL | Stock | 5.0407 | 5.05 | 5.0221 | 5.0407 | 82314904.0 |
| 2007-09-21 10:00:00 | AAPL | Stock | 5.0404 | 5.0789 | 5.0371 | 5.0714 | 79184056.0 |
| 2007-09-21 10:30:00 | AAPL | Stock | 5.0714 | 5.1089 | 5.0625 | 5.1018 | 106470308.0 |
| 2007-09-21 11:00:00 | AAPL | Stock | 5.1014 | 5.1375 | 5.1011 | 5.1371 | 80822868.0 |
| 2007-09-21 11:30:00 | AAPL | Stock | 5.1371 | 5.1429 | 5.1157 | 5.1407 | 71099364.0 |
| 2007-09-21 12:00:00 | AAPL | Stock | 5.1407 | 5.1475 | 5.1329 | 5.1388 | 47497016.0 |
| 2007-09-21 12:30:00 | AAPL | Stock | 5.1382 | 5.1446 | 5.1339 | 5.1368 | 30468788.0 |
| 2007-09-21 13:00:00 | AAPL | Stock | 5.1371 | 5.1393 | 5.1164 | 5.1254 | 44846676.0 |
| 2007-09-21 13:30:00 | AAPL | Stock | 5.1257 | 5.1314 | 5.1179 | 5.1207 | 33469156.0 |
| 2007-09-21 14:00:00 | AAPL | Stock | 5.1211 | 5.1371 | 5.1189 | 5.1371 | 40183164.0 |
| 2007-09-21 14:30:00 | AAPL | Stock | 5.1371 | 5.1464 | 5.1257 | 5.1454 | 47694304.0 |
| 2007-09-21 15:00:00 | AAPL | Stock | 5.145 | 5.1661 | 5.1411 | 5.1586 | 78314068.0 |
| 2007-09-21 15:30:00 | AAPL | Stock | 5.1589 | 5.1629 | 5.1396 | 5.1496 | 98416780.0 |
| 2007-09-21 16:00:00 | AAPL | Stock | 5.1496 | 5.15 | 5.1464 | 5.1482 | 38254608.0 |
| 2007-09-21 09:30:00 | MSFT | Stock | 28.69 | 28.72 | 28.55 | 28.71 | 27729055.0 |
| 2007-09-21 10:00:00 | MSFT | Stock | 28.7 | 28.81 | 28.67 | 28.73 | 4907651.0 |
| 2007-09-21 10:30:00 | MSFT | Stock | 28.732 | 28.74 | 28.68 | 28.69 | 3331238.0 |
| 2007-09-21 11:00:00 | MSFT | Stock | 28.68 | 28.81 | 28.67 | 28.8 | 2620322.0 |
| 2007-09-21 11:30:00 | MSFT | Stock | 28.8 | 28.81 | 28.73 | 28.74 | 3084879.0 |
| 2007-09-21 12:00:00 | MSFT | Stock | 28.74 | 28.75 | 28.69 | 28.73 | 2721129.0 |
| 2007-09-21 12:30:00 | MSFT | Stock | 28.733 | 28.76 | 28.65 | 28.69 | 3523361.0 |
| 2007-09-21 13:00:00 | MSFT | Stock | 28.68 | 28.69 | 28.62 | 28.685 | 3980443.0 |
| 2007-09-21 13:30:00 | MSFT | Stock | 28.685 | 28.75 | 28.67 | 28.681 | 2431917.0 |
| 2007-09-21 14:00:00 | MSFT | Stock | 28.69 | 28.75 | 28.68 | 28.74 | 1489750.0 |
| 2007-09-21 14:30:00 | MSFT | Stock | 28.74 | 28.78 | 28.7 | 28.72 | 3791412.0 |
| 2007-09-21 15:00:00 | MSFT | Stock | 28.72 | 28.74 | 28.67 | 28.7 | 4864279.0 |
| 2007-09-21 15:30:00 | MSFT | Stock | 28.69 | 28.72 | 28.62 | 28.62 | 16175107.0 |
| 2007-09-21 16:00:00 | MSFT | Stock | 28.62 | 28.65 | 28.62 | 28.65 | 21304463.0 |
| 2007-09-21 08:00:00 | NVDA | Stock | 0.861 | 0.862 | 0.861 | 0.8615 | 157200.0 |
| 2007-09-21 08:30:00 | NVDA | Stock | 0.862 | 0.8638 | 0.862 | 0.8632 | 125920.0 |
| 2007-09-21 09:00:00 | NVDA | Stock | 0.8632 | 0.865 | 0.8575 | 0.8628 | 763720.0 |
| 2007-09-21 09:30:00 | NVDA | Stock | 0.8615 | 0.8682 | 0.8575 | 0.86 | 129319680.0 |
| 2007-09-21 10:00:00 | NVDA | Stock | 0.86 | 0.8712 | 0.8582 | 0.865 | 30341280.0 |
| 2007-09-21 10:30:00 | NVDA | Stock | 0.865 | 0.8718 | 0.8632 | 0.8688 | 19184600.0 |
| 2007-09-21 11:00:00 | NVDA | Stock | 0.869 | 0.875 | 0.8685 | 0.8712 | 24963080.0 |
| 2007-09-21 11:30:00 | NVDA | Stock | 0.8712 | 0.8715 | 0.8655 | 0.8685 | 19244040.0 |
| 2007-09-21 12:00:00 | NVDA | Stock | 0.8685 | 0.8688 | 0.8658 | 0.8675 | 10026200.0 |
| 2007-09-21 12:30:00 | NVDA | Stock | 0.8675 | 0.87 | 0.8645 | 0.8648 | 15313040.0 |
| 2007-09-21 13:00:00 | NVDA | Stock | 0.8648 | 0.867 | 0.863 | 0.8658 | 18206080.0 |
| 2007-09-21 13:30:00 | NVDA | Stock | 0.8658 | 0.8672 | 0.8652 | 0.8658 | 16740560.0 |
| 2007-09-21 14:00:00 | NVDA | Stock | 0.8658 | 0.8675 | 0.8645 | 0.867 | 17301440.0 |
| 2007-09-21 14:30:00 | NVDA | Stock | 0.867 | 0.8678 | 0.8638 | 0.8638 | 18067720.0 |
| 2007-09-21 15:00:00 | NVDA | Stock | 0.8638 | 0.868 | 0.8635 | 0.866 | 25165040.0 |
| 2007-09-21 15:30:00 | NVDA | Stock | 0.866 | 0.8665 | 0.861 | 0.8622 | 42275960.0 |
| 2007-09-21 16:00:00 | NVDA | Stock | 0.8622 | 0.8625 | 0.8608 | 0.8622 | 30705640.0 |
| 2007-09-21 16:30:00 | NVDA | Stock | 0.8621 | 0.8622 | 0.8621 | 0.8621 | 1781240.0 |
| 2007-09-21 17:30:00 | NVDA | Stock | 0.8645 | 0.8645 | 0.8645 | 0.8645 | 4000.0 |
| 2007-09-21 18:00:00 | NVDA | Stock | 0.862 | 0.862 | 0.862 | 0.862 | 8000.0 |
| 2007-09-21 19:30:00 | NVDA | Stock | 0.862 | 0.862 | 0.862 | 0.862 | 32000.0 |
| 2007-09-21 08:00:00 | AMZN | Stock | 4.52 | 4.52 | 4.508 | 4.508 | 27380.0 |
> showing 50 of 65,484 rows — these rows as CSV