PREVIEW / stock_30min / 2009-02-24
file: by_date/stock_30min/2009/2009-02-24.parquet size: 1.3 MB rows: 72,168 symbols: 3,356
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-02-24 06:30:00 | AAPL | Stock | 3.1118 | 3.1118 | 3.1118 | 3.1118 | 2800.0 |
| 2009-02-24 07:00:00 | AAPL | Stock | 3.1214 | 3.1214 | 3.0857 | 3.0857 | 92400.0 |
| 2009-02-24 07:30:00 | AAPL | Stock | 3.0861 | 3.0861 | 3.0443 | 3.0761 | 198240.0 |
| 2009-02-24 08:00:00 | AAPL | Stock | 3.0746 | 3.1125 | 3.0746 | 3.0893 | 497364.0 |
| 2009-02-24 08:30:00 | AAPL | Stock | 3.0896 | 3.1214 | 3.0893 | 3.1125 | 1626912.0 |
| 2009-02-24 09:00:00 | AAPL | Stock | 3.1125 | 3.15 | 3.1107 | 3.1236 | 2553096.0 |
| 2009-02-24 09:30:00 | AAPL | Stock | 3.1229 | 3.1704 | 3.1071 | 3.1439 | 87756452.0 |
| 2009-02-24 10:00:00 | AAPL | Stock | 3.1429 | 3.1786 | 3.1293 | 3.1729 | 62968752.0 |
| 2009-02-24 10:30:00 | AAPL | Stock | 3.1732 | 3.1971 | 3.1646 | 3.1779 | 70686784.0 |
| 2009-02-24 11:00:00 | AAPL | Stock | 3.1771 | 3.1854 | 3.1482 | 3.1579 | 48209952.0 |
| 2009-02-24 11:30:00 | AAPL | Stock | 3.1579 | 3.1661 | 3.1379 | 3.1457 | 33997796.0 |
| 2009-02-24 12:00:00 | AAPL | Stock | 3.1457 | 3.1696 | 3.1436 | 3.1679 | 41955788.0 |
| 2009-02-24 12:30:00 | AAPL | Stock | 3.1679 | 3.1746 | 3.1586 | 3.1718 | 29746388.0 |
| 2009-02-24 13:00:00 | AAPL | Stock | 3.1718 | 3.1968 | 3.1643 | 3.1936 | 38757320.0 |
| 2009-02-24 13:30:00 | AAPL | Stock | 3.1932 | 3.2114 | 3.1911 | 3.21 | 47281752.0 |
| 2009-02-24 14:00:00 | AAPL | Stock | 3.2093 | 3.2364 | 3.2004 | 3.2334 | 62498268.0 |
| 2009-02-24 14:30:00 | AAPL | Stock | 3.2325 | 3.2332 | 3.2054 | 3.218 | 48192480.0 |
| 2009-02-24 15:00:00 | AAPL | Stock | 3.2175 | 3.2461 | 3.2093 | 3.2364 | 52481996.0 |
| 2009-02-24 15:30:00 | AAPL | Stock | 3.2364 | 3.2414 | 3.2129 | 3.2232 | 94114300.0 |
| 2009-02-24 16:00:00 | AAPL | Stock | 3.2232 | 3.2292 | 3.1871 | 3.2232 | 18742780.0 |
| 2009-02-24 16:30:00 | AAPL | Stock | 3.2232 | 3.2289 | 3.2182 | 3.2214 | 150752.0 |
| 2009-02-24 17:00:00 | AAPL | Stock | 3.2207 | 3.2271 | 3.2204 | 3.2229 | 1256864.0 |
| 2009-02-24 17:30:00 | AAPL | Stock | 3.2271 | 3.2275 | 3.2229 | 3.2275 | 48692.0 |
| 2009-02-24 18:00:00 | AAPL | Stock | 3.2279 | 3.2279 | 3.2232 | 3.2279 | 50713404.0 |
| 2009-02-24 18:30:00 | AAPL | Stock | 3.2261 | 3.2279 | 3.2254 | 3.2279 | 63168.0 |
| 2009-02-24 19:00:00 | AAPL | Stock | 3.2268 | 3.2304 | 3.2268 | 3.2304 | 77560.0 |
| 2009-02-24 19:30:00 | AAPL | Stock | 3.2261 | 3.2321 | 3.2261 | 3.2314 | 62048.0 |
| 2009-02-24 20:00:00 | AAPL | Stock | 3.1429 | 3.1429 | 3.1429 | 3.1429 | 210000.0 |
| 2009-02-24 07:30:00 | MSFT | Stock | 17.38 | 17.38 | 17.32 | 17.32 | 1500.0 |
| 2009-02-24 08:00:00 | MSFT | Stock | 17.32 | 17.34 | 17.08 | 17.1 | 99840.0 |
| 2009-02-24 08:30:00 | MSFT | Stock | 17.1 | 17.11 | 16.95 | 17.03 | 103841.0 |
| 2009-02-24 09:00:00 | MSFT | Stock | 17.04 | 17.1 | 17.01 | 17.05 | 73151.0 |
| 2009-02-24 09:30:00 | MSFT | Stock | 17.03 | 17.35 | 16.9 | 16.91 | 9927240.0 |
| 2009-02-24 10:00:00 | MSFT | Stock | 16.91 | 16.93 | 16.67 | 16.84 | 10551393.0 |
| 2009-02-24 10:30:00 | MSFT | Stock | 16.83 | 17.11 | 16.83 | 16.962 | 10198157.0 |
| 2009-02-24 11:00:00 | MSFT | Stock | 16.97 | 17.02 | 16.86 | 16.9 | 6695432.0 |
| 2009-02-24 11:30:00 | MSFT | Stock | 16.9 | 16.92 | 16.62 | 16.64 | 7159010.0 |
| 2009-02-24 12:00:00 | MSFT | Stock | 16.632 | 16.68 | 16.52 | 16.675 | 7337364.0 |
| 2009-02-24 12:30:00 | MSFT | Stock | 16.678 | 16.71 | 16.6 | 16.66 | 7349699.0 |
| 2009-02-24 13:00:00 | MSFT | Stock | 16.66 | 16.66 | 16.36 | 16.6 | 12716207.0 |
| 2009-02-24 13:30:00 | MSFT | Stock | 16.598 | 16.79 | 16.55 | 16.77 | 6744271.0 |
| 2009-02-24 14:00:00 | MSFT | Stock | 16.77 | 16.92 | 16.73 | 16.895 | 6046792.0 |
| 2009-02-24 14:30:00 | MSFT | Stock | 16.89 | 17.02 | 16.86 | 17.0 | 6487332.0 |
| 2009-02-24 15:00:00 | MSFT | Stock | 16.99 | 17.19 | 16.99 | 17.127 | 6842520.0 |
| 2009-02-24 15:30:00 | MSFT | Stock | 17.12 | 17.18 | 17.0 | 17.17 | 12437089.0 |
| 2009-02-24 16:00:00 | MSFT | Stock | 17.18 | 17.22 | 16.819 | 16.882 | 6186935.0 |
| 2009-02-24 16:30:00 | MSFT | Stock | 17.18 | 17.18 | 17.15 | 17.17 | 6351.0 |
| 2009-02-24 17:00:00 | MSFT | Stock | 17.17 | 17.19 | 17.16 | 17.17 | 266737.0 |
| 2009-02-24 17:30:00 | MSFT | Stock | 17.19 | 17.24 | 17.18 | 17.24 | 3302.0 |
| 2009-02-24 18:00:00 | MSFT | Stock | 17.19 | 17.2 | 17.18 | 17.18 | 5100.0 |
> showing 50 of 72,168 rows — these rows as CSV