PREVIEW / stock_30min / 2007-12-13
file: by_date/stock_30min/2007/2007-12-13.parquet size: 1.2 MB rows: 69,702 symbols: 3,218
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-12-13 05:00:00 | AAPL | Stock | 6.7746 | 6.7746 | 6.75 | 6.75 | 8960.0 |
| 2007-12-13 07:00:00 | AAPL | Stock | 6.7589 | 6.7589 | 6.7179 | 6.7286 | 72240.0 |
| 2007-12-13 07:30:00 | AAPL | Stock | 6.7286 | 6.7743 | 6.7232 | 6.75 | 279580.0 |
| 2007-12-13 08:00:00 | AAPL | Stock | 6.75 | 6.7661 | 6.7304 | 6.7593 | 2211440.0 |
| 2007-12-13 08:30:00 | AAPL | Stock | 6.76 | 6.7936 | 6.7443 | 6.7857 | 4989908.0 |
| 2007-12-13 09:00:00 | AAPL | Stock | 6.7857 | 6.8004 | 6.78 | 6.7925 | 2262036.0 |
| 2007-12-13 09:30:00 | AAPL | Stock | 6.7943 | 6.8614 | 6.7679 | 6.7843 | 130985512.0 |
| 2007-12-13 10:00:00 | AAPL | Stock | 6.7839 | 6.8539 | 6.7711 | 6.8082 | 96426820.0 |
| 2007-12-13 10:30:00 | AAPL | Stock | 6.8082 | 6.8368 | 6.7586 | 6.78 | 61442024.0 |
| 2007-12-13 11:00:00 | AAPL | Stock | 6.78 | 6.79 | 6.7411 | 6.7593 | 63392196.0 |
| 2007-12-13 11:30:00 | AAPL | Stock | 6.7596 | 6.7971 | 6.7554 | 6.7637 | 43864184.0 |
| 2007-12-13 12:00:00 | AAPL | Stock | 6.7639 | 6.7718 | 6.7279 | 6.7346 | 51554272.0 |
| 2007-12-13 12:30:00 | AAPL | Stock | 6.7346 | 6.7518 | 6.7218 | 6.7418 | 30443840.0 |
| 2007-12-13 13:00:00 | AAPL | Stock | 6.7418 | 6.7696 | 6.7339 | 6.7571 | 32178076.0 |
| 2007-12-13 13:30:00 | AAPL | Stock | 6.7575 | 6.7593 | 6.7079 | 6.7364 | 48506192.0 |
| 2007-12-13 14:00:00 | AAPL | Stock | 6.7364 | 6.8104 | 6.7257 | 6.8054 | 64396220.0 |
| 2007-12-13 14:30:00 | AAPL | Stock | 6.8064 | 6.8079 | 6.765 | 6.7993 | 51957052.0 |
| 2007-12-13 15:00:00 | AAPL | Stock | 6.7979 | 6.8314 | 6.7696 | 6.8239 | 75029528.0 |
| 2007-12-13 15:30:00 | AAPL | Stock | 6.8239 | 6.8571 | 6.8129 | 6.8507 | 94523156.0 |
| 2007-12-13 16:00:00 | AAPL | Stock | 6.8486 | 6.8571 | 6.7807 | 6.85 | 7987168.0 |
| 2007-12-13 16:30:00 | AAPL | Stock | 6.8511 | 6.8536 | 6.8464 | 6.85 | 1887144.0 |
| 2007-12-13 17:00:00 | AAPL | Stock | 6.8493 | 6.8571 | 6.8468 | 6.8521 | 223888.0 |
| 2007-12-13 17:30:00 | AAPL | Stock | 6.8536 | 6.855 | 6.8504 | 6.855 | 100520.0 |
| 2007-12-13 18:00:00 | AAPL | Stock | 6.855 | 6.8554 | 6.8468 | 6.8529 | 103320.0 |
| 2007-12-13 18:30:00 | AAPL | Stock | 6.8486 | 6.855 | 6.8486 | 6.85 | 227612.0 |
| 2007-12-13 19:00:00 | AAPL | Stock | 6.85 | 6.85 | 6.8436 | 6.8464 | 153328.0 |
| 2007-12-13 19:30:00 | AAPL | Stock | 6.8514 | 6.865 | 6.8514 | 6.8636 | 739172.0 |
| 2007-12-13 07:30:00 | MSFT | Stock | 34.5 | 34.5 | 34.5 | 34.5 | 200.0 |
| 2007-12-13 08:00:00 | MSFT | Stock | 34.4 | 34.4 | 34.25 | 34.3 | 13700.0 |
| 2007-12-13 08:30:00 | MSFT | Stock | 34.26 | 34.39 | 34.21 | 34.38 | 26950.0 |
| 2007-12-13 09:00:00 | MSFT | Stock | 34.38 | 34.48 | 34.33 | 34.48 | 61035.0 |
| 2007-12-13 09:30:00 | MSFT | Stock | 34.44 | 35.0 | 34.28 | 34.99 | 7949808.0 |
| 2007-12-13 10:00:00 | MSFT | Stock | 35.0 | 35.26 | 34.95 | 35.21 | 8133904.0 |
| 2007-12-13 10:30:00 | MSFT | Stock | 35.2 | 35.35 | 34.93 | 35.01 | 6363401.0 |
| 2007-12-13 11:00:00 | MSFT | Stock | 35.01 | 35.23 | 34.9 | 35.21 | 4065727.0 |
| 2007-12-13 11:30:00 | MSFT | Stock | 35.2 | 35.35 | 35.1 | 35.33 | 3685235.0 |
| 2007-12-13 12:00:00 | MSFT | Stock | 35.33 | 35.4 | 35.21 | 35.35 | 3283072.0 |
| 2007-12-13 12:30:00 | MSFT | Stock | 35.35 | 35.39 | 35.24 | 35.32 | 2874100.0 |
| 2007-12-13 13:00:00 | MSFT | Stock | 35.32 | 35.45 | 35.25 | 35.415 | 3295103.0 |
| 2007-12-13 13:30:00 | MSFT | Stock | 35.42 | 35.44 | 35.18 | 35.224 | 3193930.0 |
| 2007-12-13 14:00:00 | MSFT | Stock | 35.23 | 35.32 | 35.09 | 35.21 | 4295763.0 |
| 2007-12-13 14:30:00 | MSFT | Stock | 35.21 | 35.3 | 35.11 | 35.23 | 3485732.0 |
| 2007-12-13 15:00:00 | MSFT | Stock | 35.23 | 35.36 | 35.18 | 35.29 | 5952315.0 |
| 2007-12-13 15:30:00 | MSFT | Stock | 35.29 | 35.39 | 35.21 | 35.23 | 10560835.0 |
| 2007-12-13 16:00:00 | MSFT | Stock | 35.23 | 35.29 | 35.162 | 35.22 | 5871141.0 |
| 2007-12-13 16:30:00 | MSFT | Stock | 35.23 | 35.24 | 35.16 | 35.22 | 686991.0 |
| 2007-12-13 17:00:00 | MSFT | Stock | 35.21 | 35.21 | 34.98 | 35.21 | 11855.0 |
| 2007-12-13 17:30:00 | MSFT | Stock | 35.245 | 35.245 | 35.18 | 35.18 | 110930.0 |
| 2007-12-13 18:00:00 | MSFT | Stock | 35.17 | 35.23 | 35.17 | 35.23 | 3500.0 |
| 2007-12-13 18:30:00 | MSFT | Stock | 35.23 | 35.3 | 35.23 | 35.3 | 3828.0 |
> showing 50 of 69,702 rows — these rows as CSV