PREVIEW / stock_30min / 2004-07-23
file: by_date/stock_30min/2004/2004-07-23.parquet size: 753 KB rows: 41,018 symbols: 1,789
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 |
|---|---|---|---|---|---|---|---|
| 2004-07-23 08:30:00 | AAPL | Stock | 0.5634 | 0.5634 | 0.5634 | 0.5634 | 33600.0 |
| 2004-07-23 09:00:00 | AAPL | Stock | 0.5639 | 0.5654 | 0.563 | 0.5643 | 410368.0 |
| 2004-07-23 09:30:00 | AAPL | Stock | 0.5661 | 0.567 | 0.5559 | 0.5566 | 18842824.0 |
| 2004-07-23 10:00:00 | AAPL | Stock | 0.5564 | 0.56 | 0.5521 | 0.5554 | 29951320.0 |
| 2004-07-23 10:30:00 | AAPL | Stock | 0.5554 | 0.5625 | 0.5548 | 0.5616 | 23300480.0 |
| 2004-07-23 11:00:00 | AAPL | Stock | 0.5616 | 0.5621 | 0.5589 | 0.5589 | 11046392.0 |
| 2004-07-23 11:30:00 | AAPL | Stock | 0.5589 | 0.5591 | 0.5518 | 0.5559 | 22683080.0 |
| 2004-07-23 12:00:00 | AAPL | Stock | 0.5557 | 0.5557 | 0.5518 | 0.5523 | 15575224.0 |
| 2004-07-23 12:30:00 | AAPL | Stock | 0.552 | 0.5559 | 0.5509 | 0.5546 | 8690360.0 |
| 2004-07-23 13:00:00 | AAPL | Stock | 0.5543 | 0.558 | 0.5536 | 0.5536 | 6809488.0 |
| 2004-07-23 13:30:00 | AAPL | Stock | 0.5536 | 0.5545 | 0.5488 | 0.5493 | 18536224.0 |
| 2004-07-23 14:00:00 | AAPL | Stock | 0.5493 | 0.5507 | 0.5473 | 0.5493 | 24181192.0 |
| 2004-07-23 14:30:00 | AAPL | Stock | 0.5495 | 0.5496 | 0.5475 | 0.5488 | 15273496.0 |
| 2004-07-23 15:00:00 | AAPL | Stock | 0.5486 | 0.5489 | 0.5443 | 0.5484 | 34567568.0 |
| 2004-07-23 15:30:00 | AAPL | Stock | 0.5484 | 0.5511 | 0.5463 | 0.5479 | 31133816.0 |
| 2004-07-23 16:00:00 | AAPL | Stock | 0.5475 | 0.5482 | 0.5455 | 0.5475 | 2443224.0 |
| 2004-07-23 16:30:00 | AAPL | Stock | 0.5482 | 0.5482 | 0.5482 | 0.5482 | 1140328.0 |
| 2004-07-23 17:00:00 | AAPL | Stock | 0.5482 | 0.5482 | 0.5482 | 0.5482 | 234080.0 |
| 2004-07-23 18:00:00 | AAPL | Stock | 0.55 | 0.55 | 0.55 | 0.55 | 11200.0 |
| 2004-07-23 08:00:00 | MSFT | Stock | 28.1 | 28.5 | 27.99 | 28.15 | 750320.0 |
| 2004-07-23 08:30:00 | MSFT | Stock | 28.16 | 28.19 | 28.05 | 28.15 | 120665.0 |
| 2004-07-23 09:00:00 | MSFT | Stock | 28.15 | 28.39 | 28.14 | 28.38 | 1105165.0 |
| 2004-07-23 09:30:00 | MSFT | Stock | 28.39 | 28.4 | 28.14 | 28.18 | 16327623.0 |
| 2004-07-23 10:00:00 | MSFT | Stock | 28.17 | 28.22 | 28.05 | 28.09 | 10626683.0 |
| 2004-07-23 10:30:00 | MSFT | Stock | 28.09 | 28.22 | 28.08 | 28.19 | 7057772.0 |
| 2004-07-23 11:00:00 | MSFT | Stock | 28.19 | 28.23 | 28.11 | 28.17 | 7523533.0 |
| 2004-07-23 11:30:00 | MSFT | Stock | 28.17 | 28.27 | 28.05 | 28.25 | 6891606.0 |
| 2004-07-23 12:00:00 | MSFT | Stock | 28.26 | 28.26 | 28.15 | 28.19 | 4929615.0 |
| 2004-07-23 12:30:00 | MSFT | Stock | 28.19 | 28.23 | 28.13 | 28.17 | 4245226.0 |
| 2004-07-23 13:00:00 | MSFT | Stock | 28.17 | 28.22 | 28.15 | 28.18 | 3413240.0 |
| 2004-07-23 13:30:00 | MSFT | Stock | 28.18 | 28.2 | 28.12 | 28.16 | 3240950.0 |
| 2004-07-23 14:00:00 | MSFT | Stock | 28.16 | 28.17 | 28.0704 | 28.14 | 5695940.0 |
| 2004-07-23 14:30:00 | MSFT | Stock | 28.14 | 28.23 | 28.11 | 28.2 | 5787397.0 |
| 2004-07-23 15:00:00 | MSFT | Stock | 28.19 | 28.2 | 28.09 | 28.17 | 5758880.0 |
| 2004-07-23 15:30:00 | MSFT | Stock | 28.18 | 28.2 | 28.03 | 28.05 | 9149778.0 |
| 2004-07-23 16:00:00 | MSFT | Stock | 28.03 | 28.17 | 28.0 | 28.05 | 1009297.0 |
| 2004-07-23 16:30:00 | MSFT | Stock | 28.05 | 28.09 | 28.03 | 28.08 | 23732.0 |
| 2004-07-23 17:00:00 | MSFT | Stock | 28.08 | 28.1 | 28.03 | 28.09 | 114050.0 |
| 2004-07-23 17:30:00 | MSFT | Stock | 28.09 | 28.1 | 28.07 | 28.07 | 183467.0 |
| 2004-07-23 18:00:00 | MSFT | Stock | 28.08 | 28.1 | 28.07 | 28.1 | 1550.0 |
| 2004-07-23 08:30:00 | NVDA | Stock | 0.1239 | 0.124 | 0.1239 | 0.124 | 60000.0 |
| 2004-07-23 09:00:00 | NVDA | Stock | 0.1238 | 0.1257 | 0.1238 | 0.1256 | 1945320.0 |
| 2004-07-23 09:30:00 | NVDA | Stock | 0.126 | 0.1262 | 0.1217 | 0.1222 | 45647520.0 |
| 2004-07-23 10:00:00 | NVDA | Stock | 0.1221 | 0.1242 | 0.1217 | 0.1236 | 41396520.0 |
| 2004-07-23 10:30:00 | NVDA | Stock | 0.1235 | 0.124 | 0.123 | 0.1235 | 27957600.0 |
| 2004-07-23 11:00:00 | NVDA | Stock | 0.1233 | 0.1234 | 0.1229 | 0.1232 | 17812200.0 |
| 2004-07-23 11:30:00 | NVDA | Stock | 0.1231 | 0.1241 | 0.1229 | 0.1238 | 21594240.0 |
| 2004-07-23 12:00:00 | NVDA | Stock | 0.1239 | 0.1241 | 0.1221 | 0.1227 | 29726160.0 |
| 2004-07-23 12:30:00 | NVDA | Stock | 0.1225 | 0.1236 | 0.1225 | 0.1234 | 16088400.0 |
| 2004-07-23 13:00:00 | NVDA | Stock | 0.1233 | 0.1242 | 0.1233 | 0.1241 | 16691040.0 |
> showing 50 of 41,018 rows — these rows as CSV