PREVIEW / stock_30min / 2005-07-21
file: by_date/stock_30min/2005/2005-07-21.parquet size: 853 KB rows: 45,523 symbols: 2,027
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 |
|---|---|---|---|---|---|---|---|
| 2005-07-21 07:30:00 | AAPL | Stock | 1.5714 | 1.5714 | 1.5714 | 1.5714 | 12600.0 |
| 2005-07-21 08:00:00 | AAPL | Stock | 1.5625 | 1.5721 | 1.5589 | 1.5625 | 707840.0 |
| 2005-07-21 08:30:00 | AAPL | Stock | 1.5636 | 1.5668 | 1.5536 | 1.5586 | 878668.0 |
| 2005-07-21 09:00:00 | AAPL | Stock | 1.5604 | 1.5679 | 1.5546 | 1.5564 | 1892016.0 |
| 2005-07-21 09:30:00 | AAPL | Stock | 1.5607 | 1.5729 | 1.555 | 1.5675 | 78164464.0 |
| 2005-07-21 10:00:00 | AAPL | Stock | 1.5675 | 1.5696 | 1.5464 | 1.5589 | 44742516.0 |
| 2005-07-21 10:30:00 | AAPL | Stock | 1.5586 | 1.5586 | 1.5432 | 1.5468 | 29607004.0 |
| 2005-07-21 11:00:00 | AAPL | Stock | 1.5471 | 1.5629 | 1.5464 | 1.5568 | 29479128.0 |
| 2005-07-21 11:30:00 | AAPL | Stock | 1.5568 | 1.5614 | 1.5321 | 1.5521 | 21727216.0 |
| 2005-07-21 12:00:00 | AAPL | Stock | 1.5521 | 1.5561 | 1.5475 | 1.5539 | 16371572.0 |
| 2005-07-21 12:30:00 | AAPL | Stock | 1.5536 | 1.5636 | 1.5532 | 1.5604 | 24514084.0 |
| 2005-07-21 13:00:00 | AAPL | Stock | 1.5607 | 1.5661 | 1.5561 | 1.5586 | 16205476.0 |
| 2005-07-21 13:30:00 | AAPL | Stock | 1.5586 | 1.5614 | 1.5564 | 1.5586 | 12264868.0 |
| 2005-07-21 14:00:00 | AAPL | Stock | 1.5586 | 1.5596 | 1.5461 | 1.5471 | 24875284.0 |
| 2005-07-21 14:30:00 | AAPL | Stock | 1.5475 | 1.5502 | 1.5357 | 1.5364 | 29291696.0 |
| 2005-07-21 15:00:00 | AAPL | Stock | 1.5368 | 1.5489 | 1.5357 | 1.5479 | 29152900.0 |
| 2005-07-21 15:30:00 | AAPL | Stock | 1.5475 | 1.5479 | 1.5407 | 1.5464 | 33371240.0 |
| 2005-07-21 16:00:00 | AAPL | Stock | 1.5464 | 1.5518 | 1.5432 | 1.5446 | 1622600.0 |
| 2005-07-21 16:30:00 | AAPL | Stock | 1.5446 | 1.5461 | 1.5432 | 1.5432 | 327180.0 |
| 2005-07-21 17:00:00 | AAPL | Stock | 1.5432 | 1.5456 | 1.5368 | 1.5368 | 155764.0 |
| 2005-07-21 17:30:00 | AAPL | Stock | 1.5375 | 1.5411 | 1.5375 | 1.5375 | 154000.0 |
| 2005-07-21 18:00:00 | AAPL | Stock | 1.5375 | 1.5393 | 1.5375 | 1.5375 | 75600.0 |
| 2005-07-21 07:30:00 | MSFT | Stock | 26.3 | 26.3 | 26.21 | 26.21 | 7800.0 |
| 2005-07-21 08:00:00 | MSFT | Stock | 26.25 | 26.29 | 26.17 | 26.18 | 311971.0 |
| 2005-07-21 08:30:00 | MSFT | Stock | 26.2 | 26.23 | 26.16 | 26.19 | 164701.0 |
| 2005-07-21 09:00:00 | MSFT | Stock | 26.19 | 26.33 | 26.19 | 26.3 | 236951.0 |
| 2005-07-21 09:30:00 | MSFT | Stock | 26.3 | 26.47 | 26.29 | 26.46 | 14852662.0 |
| 2005-07-21 10:00:00 | MSFT | Stock | 26.46 | 26.47 | 26.24 | 26.36 | 14159912.0 |
| 2005-07-21 10:30:00 | MSFT | Stock | 26.36 | 26.39 | 26.26 | 26.32 | 6419085.0 |
| 2005-07-21 11:00:00 | MSFT | Stock | 26.32 | 26.37 | 26.3 | 26.34 | 4914339.0 |
| 2005-07-21 11:30:00 | MSFT | Stock | 26.34 | 26.39 | 26.32 | 26.36 | 3954536.0 |
| 2005-07-21 12:00:00 | MSFT | Stock | 26.36 | 26.4 | 26.26 | 26.27 | 6832622.0 |
| 2005-07-21 12:30:00 | MSFT | Stock | 26.27 | 26.42 | 26.27 | 26.38 | 7489495.0 |
| 2005-07-21 13:00:00 | MSFT | Stock | 26.38 | 26.45 | 26.33 | 26.36 | 5171529.0 |
| 2005-07-21 13:30:00 | MSFT | Stock | 26.37 | 26.4 | 26.31 | 26.37 | 5443217.0 |
| 2005-07-21 14:00:00 | MSFT | Stock | 26.36 | 26.4 | 26.25 | 26.26 | 5310668.0 |
| 2005-07-21 14:30:00 | MSFT | Stock | 26.26 | 26.31 | 26.19 | 26.21 | 6984357.0 |
| 2005-07-21 15:00:00 | MSFT | Stock | 26.21 | 26.37 | 26.2 | 26.36 | 9094532.0 |
| 2005-07-21 15:30:00 | MSFT | Stock | 26.36 | 26.48 | 26.32 | 26.44 | 15252915.0 |
| 2005-07-21 16:00:00 | MSFT | Stock | 26.44 | 26.5 | 25.59 | 25.87 | 4473014.0 |
| 2005-07-21 16:30:00 | MSFT | Stock | 25.86 | 25.95 | 25.8 | 25.88 | 1089109.0 |
| 2005-07-21 17:00:00 | MSFT | Stock | 25.88 | 26.442 | 25.82 | 25.92 | 119353.0 |
| 2005-07-21 17:30:00 | MSFT | Stock | 25.96 | 26.44 | 25.85 | 25.9 | 324680.0 |
| 2005-07-21 18:00:00 | MSFT | Stock | 25.85 | 25.98 | 25.85 | 25.91 | 44438.0 |
| 2005-07-21 07:00:00 | NVDA | Stock | 0.2227 | 0.2227 | 0.2227 | 0.2227 | 12000.0 |
| 2005-07-21 08:00:00 | NVDA | Stock | 0.2167 | 0.2221 | 0.2167 | 0.2208 | 741240.0 |
| 2005-07-21 08:30:00 | NVDA | Stock | 0.2208 | 0.2212 | 0.2208 | 0.2212 | 196200.0 |
| 2005-07-21 09:00:00 | NVDA | Stock | 0.2205 | 0.2233 | 0.2204 | 0.2228 | 6999720.0 |
| 2005-07-21 09:30:00 | NVDA | Stock | 0.2219 | 0.2229 | 0.2164 | 0.2179 | 133126560.0 |
| 2005-07-21 10:00:00 | NVDA | Stock | 0.2177 | 0.2202 | 0.2177 | 0.2184 | 52826760.0 |
> showing 50 of 45,523 rows — these rows as CSV