PREVIEW / stock_30min / 2009-03-18
file: by_date/stock_30min/2009/2009-03-18.parquet size: 1.2 MB rows: 68,621 symbols: 3,338
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-03-18 05:30:00 | AAPL | Stock | 3.55 | 3.55 | 3.55 | 3.55 | 5600.0 |
| 2009-03-18 06:30:00 | AAPL | Stock | 3.5525 | 3.5525 | 3.5525 | 3.5525 | 5600.0 |
| 2009-03-18 07:30:00 | AAPL | Stock | 3.5496 | 3.5625 | 3.5486 | 3.5625 | 18396.0 |
| 2009-03-18 08:00:00 | AAPL | Stock | 3.545 | 3.545 | 3.5268 | 3.5329 | 443940.0 |
| 2009-03-18 08:30:00 | AAPL | Stock | 3.5339 | 3.5864 | 3.5311 | 3.5786 | 2486596.0 |
| 2009-03-18 09:00:00 | AAPL | Stock | 3.5757 | 3.5804 | 3.5536 | 3.5632 | 1963640.0 |
| 2009-03-18 09:30:00 | AAPL | Stock | 3.5679 | 3.6543 | 3.5668 | 3.6279 | 144936148.0 |
| 2009-03-18 10:00:00 | AAPL | Stock | 3.6275 | 3.6389 | 3.5853 | 3.5889 | 74608268.0 |
| 2009-03-18 10:30:00 | AAPL | Stock | 3.5875 | 3.5982 | 3.5614 | 3.5825 | 51862580.0 |
| 2009-03-18 11:00:00 | AAPL | Stock | 3.5829 | 3.5996 | 3.5718 | 3.581 | 38960236.0 |
| 2009-03-18 11:30:00 | AAPL | Stock | 3.5811 | 3.5946 | 3.5714 | 3.5932 | 24162460.0 |
| 2009-03-18 12:00:00 | AAPL | Stock | 3.5936 | 3.6214 | 3.5932 | 3.6175 | 33038740.0 |
| 2009-03-18 12:30:00 | AAPL | Stock | 3.6171 | 3.6393 | 3.6071 | 3.6318 | 28114296.0 |
| 2009-03-18 13:00:00 | AAPL | Stock | 3.6318 | 3.6332 | 3.6079 | 3.6204 | 25720856.0 |
| 2009-03-18 13:30:00 | AAPL | Stock | 3.6211 | 3.6389 | 3.6182 | 3.6236 | 22859060.0 |
| 2009-03-18 14:00:00 | AAPL | Stock | 3.6236 | 3.6857 | 3.6129 | 3.6704 | 72394868.0 |
| 2009-03-18 14:30:00 | AAPL | Stock | 3.6714 | 3.6957 | 3.6379 | 3.6893 | 80652292.0 |
| 2009-03-18 15:00:00 | AAPL | Stock | 3.6904 | 3.6921 | 3.6105 | 3.6246 | 80037944.0 |
| 2009-03-18 15:30:00 | AAPL | Stock | 3.6246 | 3.6461 | 3.6036 | 3.6271 | 83586048.0 |
| 2009-03-18 16:00:00 | AAPL | Stock | 3.6271 | 3.6444 | 3.5754 | 3.6271 | 15957256.0 |
| 2009-03-18 16:30:00 | AAPL | Stock | 3.6268 | 3.6286 | 3.6232 | 3.6232 | 271068.0 |
| 2009-03-18 17:00:00 | AAPL | Stock | 3.6229 | 3.6282 | 3.6161 | 3.6196 | 97076.0 |
| 2009-03-18 17:30:00 | AAPL | Stock | 3.6146 | 3.625 | 3.6146 | 3.615 | 89628.0 |
| 2009-03-18 18:00:00 | AAPL | Stock | 3.6214 | 3.6257 | 3.6143 | 3.6182 | 169232.0 |
| 2009-03-18 18:30:00 | AAPL | Stock | 3.6186 | 3.6186 | 3.6164 | 3.6164 | 15400.0 |
| 2009-03-18 19:00:00 | AAPL | Stock | 3.6171 | 3.6175 | 3.6121 | 3.6129 | 34496.0 |
| 2009-03-18 19:30:00 | AAPL | Stock | 3.61 | 3.6207 | 3.61 | 3.62 | 104720.0 |
| 2009-03-18 07:00:00 | MSFT | Stock | 16.97 | 16.97 | 16.97 | 16.97 | 1000.0 |
| 2009-03-18 07:30:00 | MSFT | Stock | 16.97 | 16.97 | 16.9 | 16.9 | 2100.0 |
| 2009-03-18 08:00:00 | MSFT | Stock | 16.9 | 16.95 | 16.88 | 16.9 | 29481.0 |
| 2009-03-18 08:30:00 | MSFT | Stock | 16.9 | 16.9 | 16.88 | 16.89 | 12781.0 |
| 2009-03-18 09:00:00 | MSFT | Stock | 16.85 | 17.04 | 16.68 | 17.03 | 114675.0 |
| 2009-03-18 09:30:00 | MSFT | Stock | 17.03 | 17.04 | 16.73 | 16.81 | 4852629.0 |
| 2009-03-18 10:00:00 | MSFT | Stock | 16.81 | 16.89 | 16.73 | 16.75 | 3501361.0 |
| 2009-03-18 10:30:00 | MSFT | Stock | 16.75 | 16.76 | 16.64 | 16.75 | 2536514.0 |
| 2009-03-18 11:00:00 | MSFT | Stock | 16.75 | 16.76 | 16.63 | 16.66 | 2484483.0 |
| 2009-03-18 11:30:00 | MSFT | Stock | 16.66 | 16.71 | 16.6 | 16.66 | 2827148.0 |
| 2009-03-18 12:00:00 | MSFT | Stock | 16.67 | 16.76 | 16.66 | 16.72 | 2825446.0 |
| 2009-03-18 12:30:00 | MSFT | Stock | 16.72 | 16.755 | 16.64 | 16.73 | 2352932.0 |
| 2009-03-18 13:00:00 | MSFT | Stock | 16.74 | 16.76 | 16.64 | 16.719 | 2538316.0 |
| 2009-03-18 13:30:00 | MSFT | Stock | 16.72 | 16.79 | 16.67 | 16.732 | 3717470.0 |
| 2009-03-18 14:00:00 | MSFT | Stock | 16.74 | 17.07 | 16.67 | 16.991 | 9185790.0 |
| 2009-03-18 14:30:00 | MSFT | Stock | 17.0 | 17.22 | 16.9 | 17.18 | 9142396.0 |
| 2009-03-18 15:00:00 | MSFT | Stock | 17.18 | 17.19 | 16.79 | 16.92 | 8684214.0 |
| 2009-03-18 15:30:00 | MSFT | Stock | 16.92 | 16.98 | 16.82 | 16.96 | 10085934.0 |
| 2009-03-18 16:00:00 | MSFT | Stock | 16.97 | 17.17 | 16.615 | 17.1 | 4793691.0 |
| 2009-03-18 16:30:00 | MSFT | Stock | 16.96 | 17.11 | 16.96 | 17.05 | 115801.0 |
| 2009-03-18 17:00:00 | MSFT | Stock | 17.1 | 17.16 | 17.1 | 17.15 | 21562.0 |
| 2009-03-18 17:30:00 | MSFT | Stock | 17.14 | 17.17 | 17.12 | 17.12 | 12618.0 |
| 2009-03-18 18:00:00 | MSFT | Stock | 17.11 | 17.15 | 16.96 | 17.15 | 42341.0 |
> showing 50 of 68,621 rows — these rows as CSV