PREVIEW / stock_30min / 2008-12-30
file: by_date/stock_30min/2008/2008-12-30.parquet size: 1.3 MB rows: 72,364 symbols: 3,381
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-12-30 04:00:00 | AAPL | Stock | 3.1293 | 3.1443 | 3.1293 | 3.1443 | 8400.0 |
| 2008-12-30 05:00:00 | AAPL | Stock | 3.1539 | 3.1539 | 3.1536 | 3.1536 | 19600.0 |
| 2008-12-30 07:00:00 | AAPL | Stock | 3.1536 | 3.1782 | 3.1536 | 3.1782 | 24164.0 |
| 2008-12-30 07:30:00 | AAPL | Stock | 3.1743 | 3.1743 | 3.1343 | 3.1429 | 340004.0 |
| 2008-12-30 08:00:00 | AAPL | Stock | 3.1339 | 3.1482 | 3.1143 | 3.1343 | 839580.0 |
| 2008-12-30 08:30:00 | AAPL | Stock | 3.1332 | 3.1357 | 3.1236 | 3.1275 | 853860.0 |
| 2008-12-30 09:00:00 | AAPL | Stock | 3.1275 | 3.1411 | 3.1239 | 3.125 | 1250312.0 |
| 2008-12-30 09:30:00 | AAPL | Stock | 3.1243 | 3.1357 | 3.1079 | 3.1146 | 61776456.0 |
| 2008-12-30 10:00:00 | AAPL | Stock | 3.1146 | 3.1246 | 3.0939 | 3.1232 | 65484580.0 |
| 2008-12-30 10:30:00 | AAPL | Stock | 3.1232 | 3.1296 | 3.1168 | 3.1179 | 35197680.0 |
| 2008-12-30 11:00:00 | AAPL | Stock | 3.1175 | 3.1196 | 3.1039 | 3.1161 | 31112620.0 |
| 2008-12-30 11:30:00 | AAPL | Stock | 3.1168 | 3.1446 | 3.1168 | 3.1393 | 53944044.0 |
| 2008-12-30 12:00:00 | AAPL | Stock | 3.1393 | 3.1425 | 3.1293 | 3.1375 | 31016244.0 |
| 2008-12-30 12:30:00 | AAPL | Stock | 3.1382 | 3.1436 | 3.0257 | 3.0675 | 177460920.0 |
| 2008-12-30 13:00:00 | AAPL | Stock | 3.0675 | 3.0875 | 3.0546 | 3.0568 | 96481168.0 |
| 2008-12-30 13:30:00 | AAPL | Stock | 3.0563 | 3.0979 | 3.0464 | 3.0696 | 110305860.0 |
| 2008-12-30 14:00:00 | AAPL | Stock | 3.0696 | 3.0921 | 3.0614 | 3.0879 | 68040644.0 |
| 2008-12-30 14:30:00 | AAPL | Stock | 3.0879 | 3.0907 | 3.0579 | 3.065 | 51183328.0 |
| 2008-12-30 15:00:00 | AAPL | Stock | 3.065 | 3.0732 | 3.0575 | 3.0704 | 50813028.0 |
| 2008-12-30 15:30:00 | AAPL | Stock | 3.0704 | 3.0886 | 3.0611 | 3.0818 | 106817704.0 |
| 2008-12-30 16:00:00 | AAPL | Stock | 3.0821 | 3.0963 | 3.075 | 3.0764 | 17234644.0 |
| 2008-12-30 16:30:00 | AAPL | Stock | 3.0764 | 3.0818 | 3.0654 | 3.0786 | 1031520.0 |
| 2008-12-30 17:00:00 | AAPL | Stock | 3.0768 | 3.0793 | 3.0725 | 3.0786 | 287896.0 |
| 2008-12-30 17:30:00 | AAPL | Stock | 3.0786 | 3.0818 | 3.0732 | 3.0768 | 200508.0 |
| 2008-12-30 18:00:00 | AAPL | Stock | 3.0768 | 3.0821 | 3.0768 | 3.0821 | 1162616.0 |
| 2008-12-30 18:30:00 | AAPL | Stock | 3.0821 | 3.085 | 3.0786 | 3.0832 | 231168.0 |
| 2008-12-30 19:00:00 | AAPL | Stock | 3.0829 | 3.0839 | 3.0818 | 3.0818 | 131012.0 |
| 2008-12-30 19:30:00 | AAPL | Stock | 3.0818 | 3.0854 | 3.0782 | 3.0843 | 177072.0 |
| 2008-12-30 04:00:00 | MSFT | Stock | 19.13 | 19.16 | 19.13 | 19.16 | 600.0 |
| 2008-12-30 07:00:00 | MSFT | Stock | 19.15 | 19.15 | 19.15 | 19.15 | 100.0 |
| 2008-12-30 07:30:00 | MSFT | Stock | 19.1 | 19.1 | 19.1 | 19.1 | 3000.0 |
| 2008-12-30 08:00:00 | MSFT | Stock | 18.96 | 19.14 | 18.95 | 19.1 | 11808.0 |
| 2008-12-30 08:30:00 | MSFT | Stock | 19.06 | 19.08 | 19.05 | 19.07 | 5600.0 |
| 2008-12-30 09:00:00 | MSFT | Stock | 19.03 | 19.08 | 19.0 | 19.0 | 50654.0 |
| 2008-12-30 09:30:00 | MSFT | Stock | 19.01 | 19.18 | 19.0 | 19.14 | 4710987.0 |
| 2008-12-30 10:00:00 | MSFT | Stock | 19.14 | 19.16 | 19.09 | 19.16 | 2655677.0 |
| 2008-12-30 10:30:00 | MSFT | Stock | 19.16 | 19.24 | 19.15 | 19.21 | 2353106.0 |
| 2008-12-30 11:00:00 | MSFT | Stock | 19.22 | 19.22 | 19.13 | 19.22 | 2463949.0 |
| 2008-12-30 11:30:00 | MSFT | Stock | 19.22 | 19.43 | 19.21 | 19.42 | 3626421.0 |
| 2008-12-30 12:00:00 | MSFT | Stock | 19.42 | 19.49 | 19.25 | 19.31 | 2190378.0 |
| 2008-12-30 12:30:00 | MSFT | Stock | 19.312 | 19.34 | 19.22 | 19.315 | 2382691.0 |
| 2008-12-30 13:00:00 | MSFT | Stock | 19.32 | 19.34 | 19.22 | 19.32 | 1706470.0 |
| 2008-12-30 13:30:00 | MSFT | Stock | 19.32 | 19.32 | 19.26 | 19.29 | 1485967.0 |
| 2008-12-30 14:00:00 | MSFT | Stock | 19.29 | 19.29 | 19.19 | 19.261 | 2496679.0 |
| 2008-12-30 14:30:00 | MSFT | Stock | 19.27 | 19.28 | 19.18 | 19.22 | 2112323.0 |
| 2008-12-30 15:00:00 | MSFT | Stock | 19.22 | 19.26 | 19.15 | 19.18 | 2261980.0 |
| 2008-12-30 15:30:00 | MSFT | Stock | 19.185 | 19.35 | 19.16 | 19.32 | 7843312.0 |
| 2008-12-30 16:00:00 | MSFT | Stock | 19.33 | 19.36 | 19.05 | 19.34 | 2501541.0 |
| 2008-12-30 16:30:00 | MSFT | Stock | 19.34 | 19.36 | 19.25 | 19.3 | 90487.0 |
| 2008-12-30 17:00:00 | MSFT | Stock | 19.31 | 19.37 | 19.31 | 19.36 | 1500.0 |
> showing 50 of 72,364 rows — these rows as CSV