PREVIEW / stock_30min / 2004-09-23
file: by_date/stock_30min/2004/2004-09-23.parquet size: 732 KB rows: 39,603 symbols: 1,824
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-09-23 08:00:00 | AAPL | Stock | 0.6591 | 0.6593 | 0.6591 | 0.6591 | 51184.0 |
| 2004-09-23 08:30:00 | AAPL | Stock | 0.6598 | 0.6598 | 0.6598 | 0.6598 | 39200.0 |
| 2004-09-23 09:00:00 | AAPL | Stock | 0.6613 | 0.6613 | 0.6604 | 0.6607 | 935200.0 |
| 2004-09-23 09:30:00 | AAPL | Stock | 0.6614 | 0.6652 | 0.6602 | 0.6634 | 64517040.0 |
| 2004-09-23 10:00:00 | AAPL | Stock | 0.6632 | 0.667 | 0.6595 | 0.6659 | 51202088.0 |
| 2004-09-23 10:30:00 | AAPL | Stock | 0.6657 | 0.668 | 0.6634 | 0.6679 | 32148984.0 |
| 2004-09-23 11:00:00 | AAPL | Stock | 0.6679 | 0.6689 | 0.6654 | 0.6663 | 23702840.0 |
| 2004-09-23 11:30:00 | AAPL | Stock | 0.6663 | 0.6673 | 0.6643 | 0.6663 | 10987928.0 |
| 2004-09-23 12:00:00 | AAPL | Stock | 0.6663 | 0.6677 | 0.6643 | 0.6645 | 10083640.0 |
| 2004-09-23 12:30:00 | AAPL | Stock | 0.6646 | 0.6654 | 0.6618 | 0.665 | 13758920.0 |
| 2004-09-23 13:00:00 | AAPL | Stock | 0.665 | 0.6673 | 0.6643 | 0.6654 | 16649696.0 |
| 2004-09-23 13:30:00 | AAPL | Stock | 0.6654 | 0.6663 | 0.6636 | 0.6648 | 17844792.0 |
| 2004-09-23 14:00:00 | AAPL | Stock | 0.6648 | 0.667 | 0.6646 | 0.6661 | 19816328.0 |
| 2004-09-23 14:30:00 | AAPL | Stock | 0.6661 | 0.6668 | 0.6639 | 0.6666 | 13342504.0 |
| 2004-09-23 15:00:00 | AAPL | Stock | 0.6666 | 0.6696 | 0.6661 | 0.668 | 39211200.0 |
| 2004-09-23 15:30:00 | AAPL | Stock | 0.668 | 0.6695 | 0.6655 | 0.6657 | 50574832.0 |
| 2004-09-23 16:00:00 | AAPL | Stock | 0.6655 | 0.6664 | 0.665 | 0.6655 | 3297672.0 |
| 2004-09-23 17:00:00 | AAPL | Stock | 0.6655 | 0.6659 | 0.6655 | 0.6659 | 4709600.0 |
| 2004-09-23 08:00:00 | MSFT | Stock | 27.115 | 27.115 | 27.1 | 27.1 | 25800.0 |
| 2004-09-23 08:30:00 | MSFT | Stock | 27.12 | 27.17 | 27.1 | 27.17 | 77700.0 |
| 2004-09-23 09:00:00 | MSFT | Stock | 27.15 | 27.2 | 27.15 | 27.19 | 79880.0 |
| 2004-09-23 09:30:00 | MSFT | Stock | 27.19 | 27.28 | 27.17 | 27.24 | 6945358.0 |
| 2004-09-23 10:00:00 | MSFT | Stock | 27.24 | 27.33 | 27.2 | 27.29 | 5466666.0 |
| 2004-09-23 10:30:00 | MSFT | Stock | 27.29 | 27.37 | 27.27 | 27.36 | 5364452.0 |
| 2004-09-23 11:00:00 | MSFT | Stock | 27.36 | 27.37 | 27.32 | 27.33 | 2097002.0 |
| 2004-09-23 11:30:00 | MSFT | Stock | 27.33 | 27.36 | 27.3 | 27.31 | 2267357.0 |
| 2004-09-23 12:00:00 | MSFT | Stock | 27.31 | 27.34 | 27.3 | 27.31 | 1696871.0 |
| 2004-09-23 12:30:00 | MSFT | Stock | 27.31 | 27.34 | 27.23 | 27.26 | 3798606.0 |
| 2004-09-23 13:00:00 | MSFT | Stock | 27.26 | 27.31 | 27.23 | 27.3 | 1986625.0 |
| 2004-09-23 13:30:00 | MSFT | Stock | 27.29 | 27.31 | 27.23 | 27.26 | 2364564.0 |
| 2004-09-23 14:00:00 | MSFT | Stock | 27.26 | 27.35 | 27.25 | 27.3 | 3392026.0 |
| 2004-09-23 14:30:00 | MSFT | Stock | 27.3 | 27.35 | 27.29 | 27.3 | 2059167.0 |
| 2004-09-23 15:00:00 | MSFT | Stock | 27.31 | 27.38 | 27.3 | 27.36 | 3825616.0 |
| 2004-09-23 15:30:00 | MSFT | Stock | 27.36 | 27.39 | 27.27 | 27.35 | 6647549.0 |
| 2004-09-23 16:00:00 | MSFT | Stock | 27.35 | 27.42 | 27.31 | 27.33 | 1767246.0 |
| 2004-09-23 16:30:00 | MSFT | Stock | 27.33 | 27.35 | 27.2789 | 27.35 | 96251.0 |
| 2004-09-23 17:00:00 | MSFT | Stock | 27.34 | 27.35 | 27.34 | 27.34 | 5100.0 |
| 2004-09-23 17:30:00 | MSFT | Stock | 27.34 | 27.34 | 27.34 | 27.34 | 300.0 |
| 2004-09-23 18:00:00 | MSFT | Stock | 27.35 | 27.35 | 27.34 | 27.34 | 850.0 |
| 2004-09-23 08:00:00 | NVDA | Stock | 0.1207 | 0.1207 | 0.1207 | 0.1207 | 204000.0 |
| 2004-09-23 08:30:00 | NVDA | Stock | 0.1204 | 0.1204 | 0.1204 | 0.1204 | 120000.0 |
| 2004-09-23 09:00:00 | NVDA | Stock | 0.1204 | 0.1212 | 0.12 | 0.1212 | 2916000.0 |
| 2004-09-23 09:30:00 | NVDA | Stock | 0.1211 | 0.1214 | 0.1182 | 0.1195 | 73415280.0 |
| 2004-09-23 10:00:00 | NVDA | Stock | 0.1193 | 0.1202 | 0.1184 | 0.1196 | 80399160.0 |
| 2004-09-23 10:30:00 | NVDA | Stock | 0.1196 | 0.1196 | 0.1184 | 0.1192 | 47088840.0 |
| 2004-09-23 11:00:00 | NVDA | Stock | 0.1192 | 0.1192 | 0.1188 | 0.1192 | 24146640.0 |
| 2004-09-23 11:30:00 | NVDA | Stock | 0.1191 | 0.1192 | 0.1183 | 0.1184 | 22113240.0 |
| 2004-09-23 12:00:00 | NVDA | Stock | 0.1184 | 0.1189 | 0.1182 | 0.1184 | 34445760.0 |
| 2004-09-23 12:30:00 | NVDA | Stock | 0.1184 | 0.1187 | 0.1178 | 0.118 | 35518080.0 |
| 2004-09-23 13:00:00 | NVDA | Stock | 0.118 | 0.1185 | 0.1176 | 0.1184 | 33845040.0 |
> showing 50 of 39,603 rows — these rows as CSV