PREVIEW / stock_30min / 2008-07-07
file: by_date/stock_30min/2008/2008-07-07.parquet size: 1.3 MB rows: 70,754 symbols: 3,343
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 |
|---|---|---|---|---|---|---|---|
| 2008-07-07 05:00:00 | AAPL | Stock | 6.1136 | 6.1136 | 6.1136 | 6.1136 | 2800.0 |
| 2008-07-07 06:30:00 | AAPL | Stock | 6.1125 | 6.1125 | 6.1125 | 6.1125 | 24724.0 |
| 2008-07-07 07:00:00 | AAPL | Stock | 6.1107 | 6.1261 | 6.1057 | 6.1261 | 218540.0 |
| 2008-07-07 07:30:00 | AAPL | Stock | 6.1071 | 6.15 | 6.1071 | 6.1357 | 276080.0 |
| 2008-07-07 08:00:00 | AAPL | Stock | 6.1361 | 6.1796 | 6.1246 | 6.1757 | 1997744.0 |
| 2008-07-07 08:30:00 | AAPL | Stock | 6.1736 | 6.1786 | 6.1529 | 6.1707 | 1320704.0 |
| 2008-07-07 09:00:00 | AAPL | Stock | 6.1679 | 6.1964 | 6.1625 | 6.1754 | 2845024.0 |
| 2008-07-07 09:30:00 | AAPL | Stock | 6.1796 | 6.3261 | 6.1718 | 6.2775 | 107022776.0 |
| 2008-07-07 10:00:00 | AAPL | Stock | 6.2771 | 6.2857 | 6.2432 | 6.2729 | 67354476.0 |
| 2008-07-07 10:30:00 | AAPL | Stock | 6.2739 | 6.3132 | 6.2711 | 6.2871 | 62359500.0 |
| 2008-07-07 11:00:00 | AAPL | Stock | 6.2864 | 6.3025 | 6.2679 | 6.2982 | 42351540.0 |
| 2008-07-07 11:30:00 | AAPL | Stock | 6.2979 | 6.3104 | 6.2536 | 6.2779 | 42014140.0 |
| 2008-07-07 12:00:00 | AAPL | Stock | 6.2779 | 6.2929 | 6.1964 | 6.1976 | 58414076.0 |
| 2008-07-07 12:30:00 | AAPL | Stock | 6.1982 | 6.235 | 6.1711 | 6.1768 | 62121052.0 |
| 2008-07-07 13:00:00 | AAPL | Stock | 6.1775 | 6.2132 | 6.1393 | 6.1793 | 59141152.0 |
| 2008-07-07 13:30:00 | AAPL | Stock | 6.1793 | 6.2271 | 6.1761 | 6.2179 | 34123852.0 |
| 2008-07-07 14:00:00 | AAPL | Stock | 6.2189 | 6.2375 | 6.1746 | 6.2164 | 47511380.0 |
| 2008-07-07 14:30:00 | AAPL | Stock | 6.2129 | 6.2396 | 6.1786 | 6.1893 | 42900536.0 |
| 2008-07-07 15:00:00 | AAPL | Stock | 6.1865 | 6.2882 | 6.1865 | 6.2875 | 77130032.0 |
| 2008-07-07 15:30:00 | AAPL | Stock | 6.2886 | 6.3139 | 6.2507 | 6.2539 | 89977384.0 |
| 2008-07-07 16:00:00 | AAPL | Stock | 6.2526 | 6.2697 | 6.2438 | 6.2557 | 8807568.0 |
| 2008-07-07 16:30:00 | AAPL | Stock | 6.2557 | 6.2589 | 6.2518 | 6.2536 | 1142036.0 |
| 2008-07-07 17:00:00 | AAPL | Stock | 6.2536 | 6.2664 | 6.2529 | 6.2664 | 329784.0 |
| 2008-07-07 17:30:00 | AAPL | Stock | 6.2607 | 6.2607 | 6.2604 | 6.2607 | 38780.0 |
| 2008-07-07 18:00:00 | AAPL | Stock | 6.2589 | 6.2589 | 6.2539 | 6.2543 | 2414300.0 |
| 2008-07-07 18:30:00 | AAPL | Stock | 6.2543 | 6.3039 | 6.1511 | 6.2826 | 526624.0 |
| 2008-07-07 19:00:00 | AAPL | Stock | 6.2593 | 6.2629 | 6.2557 | 6.2629 | 134400.0 |
| 2008-07-07 19:30:00 | AAPL | Stock | 6.2629 | 6.2636 | 6.2575 | 6.2575 | 43512.0 |
| 2008-07-07 07:00:00 | MSFT | Stock | 26.04 | 26.04 | 26.04 | 26.04 | 1000.0 |
| 2008-07-07 07:30:00 | MSFT | Stock | 26.17 | 26.17 | 26.17 | 26.17 | 200.0 |
| 2008-07-07 08:00:00 | MSFT | Stock | 26.13 | 26.17 | 26.1 | 26.16 | 19455.0 |
| 2008-07-07 08:30:00 | MSFT | Stock | 26.11 | 26.24 | 26.11 | 26.24 | 27172.0 |
| 2008-07-07 09:00:00 | MSFT | Stock | 26.25 | 26.25 | 26.02 | 26.1 | 164450.0 |
| 2008-07-07 09:30:00 | MSFT | Stock | 26.15 | 26.39 | 26.1 | 26.3 | 7212296.0 |
| 2008-07-07 10:00:00 | MSFT | Stock | 26.29 | 26.35 | 26.14 | 26.19 | 5396723.0 |
| 2008-07-07 10:30:00 | MSFT | Stock | 26.2 | 26.25 | 26.12 | 26.16 | 3097864.0 |
| 2008-07-07 11:00:00 | MSFT | Stock | 26.17 | 26.2 | 26.04 | 26.1 | 4664764.0 |
| 2008-07-07 11:30:00 | MSFT | Stock | 26.1 | 26.1 | 25.9 | 26.01 | 5317052.0 |
| 2008-07-07 12:00:00 | MSFT | Stock | 26.01 | 26.05 | 25.68 | 25.7 | 4111981.0 |
| 2008-07-07 12:30:00 | MSFT | Stock | 25.69 | 25.89 | 25.63 | 25.64 | 3895285.0 |
| 2008-07-07 13:00:00 | MSFT | Stock | 25.64 | 25.7 | 25.55 | 25.57 | 4609492.0 |
| 2008-07-07 13:30:00 | MSFT | Stock | 25.57 | 25.61 | 25.5 | 25.552 | 2411718.0 |
| 2008-07-07 14:00:00 | MSFT | Stock | 25.55 | 25.66 | 25.45 | 25.58 | 3890731.0 |
| 2008-07-07 14:30:00 | MSFT | Stock | 25.58 | 25.81 | 25.58 | 25.792 | 5071738.0 |
| 2008-07-07 15:00:00 | MSFT | Stock | 25.8 | 26.2 | 25.8 | 26.19 | 8022572.0 |
| 2008-07-07 15:30:00 | MSFT | Stock | 26.18 | 26.28 | 26.01 | 26.018 | 8325895.0 |
| 2008-07-07 16:00:00 | MSFT | Stock | 26.03 | 26.179 | 25.961 | 26.02 | 2992222.0 |
| 2008-07-07 16:30:00 | MSFT | Stock | 25.95 | 26.03 | 25.93 | 25.93 | 188370.0 |
| 2008-07-07 17:00:00 | MSFT | Stock | 25.92 | 26.03 | 25.91 | 26.03 | 24329.0 |
| 2008-07-07 17:30:00 | MSFT | Stock | 26.0 | 26.0 | 25.97 | 25.98 | 500.0 |
> showing 50 of 70,754 rows — these rows as CSV