PREVIEW / stock_30min / 2007-08-30
file: by_date/stock_30min/2007/2007-08-30.parquet size: 1.1 MB rows: 63,180 symbols: 3,089
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-08-30 09:30:00 | AAPL | Stock | 4.7357 | 4.8982 | 4.725 | 4.8871 | 233033528.0 |
| 2007-08-30 10:00:00 | AAPL | Stock | 4.8857 | 4.9318 | 4.8571 | 4.9104 | 189547428.0 |
| 2007-08-30 10:30:00 | AAPL | Stock | 4.91 | 4.9318 | 4.8893 | 4.9218 | 116736424.0 |
| 2007-08-30 11:00:00 | AAPL | Stock | 4.9218 | 4.9375 | 4.9132 | 4.9179 | 92324624.0 |
| 2007-08-30 11:30:00 | AAPL | Stock | 4.9193 | 4.9279 | 4.8986 | 4.9004 | 53205516.0 |
| 2007-08-30 12:00:00 | AAPL | Stock | 4.8999 | 4.9025 | 4.8596 | 4.8975 | 94197796.0 |
| 2007-08-30 12:30:00 | AAPL | Stock | 4.8968 | 4.9161 | 4.8907 | 4.9075 | 54446952.0 |
| 2007-08-30 13:00:00 | AAPL | Stock | 4.9071 | 4.9146 | 4.8804 | 4.8868 | 39478992.0 |
| 2007-08-30 13:30:00 | AAPL | Stock | 4.8868 | 4.9004 | 4.8732 | 4.8975 | 43571612.0 |
| 2007-08-30 14:00:00 | AAPL | Stock | 4.8982 | 4.9018 | 4.8504 | 4.8568 | 67033568.0 |
| 2007-08-30 14:30:00 | AAPL | Stock | 4.8564 | 4.86 | 4.8071 | 4.8357 | 124594344.0 |
| 2007-08-30 15:00:00 | AAPL | Stock | 4.835 | 4.8796 | 4.8321 | 4.8593 | 92315916.0 |
| 2007-08-30 15:30:00 | AAPL | Stock | 4.8593 | 4.8704 | 4.8343 | 4.8668 | 100580368.0 |
| 2007-08-30 16:00:00 | AAPL | Stock | 4.8668 | 4.8671 | 4.8639 | 4.8661 | 10856804.0 |
| 2007-08-30 09:30:00 | MSFT | Stock | 28.42 | 28.5 | 28.32 | 28.42 | 2230105.0 |
| 2007-08-30 10:00:00 | MSFT | Stock | 28.42 | 28.74 | 28.4 | 28.68 | 2708702.0 |
| 2007-08-30 10:30:00 | MSFT | Stock | 28.68 | 28.77 | 28.63 | 28.69 | 1819704.0 |
| 2007-08-30 11:00:00 | MSFT | Stock | 28.69 | 28.91 | 28.67 | 28.9 | 1989724.0 |
| 2007-08-30 11:30:00 | MSFT | Stock | 28.89 | 28.93 | 28.83 | 28.852 | 1254824.0 |
| 2007-08-30 12:00:00 | MSFT | Stock | 28.85 | 28.86 | 28.63 | 28.72 | 2071122.0 |
| 2007-08-30 12:30:00 | MSFT | Stock | 28.72 | 28.78 | 28.68 | 28.75 | 1378786.0 |
| 2007-08-30 13:00:00 | MSFT | Stock | 28.74 | 28.8 | 28.64 | 28.67 | 1340626.0 |
| 2007-08-30 13:30:00 | MSFT | Stock | 28.68 | 28.68 | 28.56 | 28.62 | 1322970.0 |
| 2007-08-30 14:00:00 | MSFT | Stock | 28.61 | 28.68 | 28.53 | 28.54 | 1673284.0 |
| 2007-08-30 14:30:00 | MSFT | Stock | 28.54 | 28.56 | 28.33 | 28.38 | 2554749.0 |
| 2007-08-30 15:00:00 | MSFT | Stock | 28.38 | 28.57 | 28.37 | 28.47 | 2208765.0 |
| 2007-08-30 15:30:00 | MSFT | Stock | 28.47 | 28.5 | 28.36 | 28.45 | 3950228.0 |
| 2007-08-30 16:00:00 | MSFT | Stock | 28.45 | 28.45 | 28.45 | 28.45 | 1458526.0 |
| 2007-08-30 08:00:00 | NVDA | Stock | 0.8092 | 0.81 | 0.8075 | 0.8075 | 197940.0 |
| 2007-08-30 08:30:00 | NVDA | Stock | 0.8075 | 0.8082 | 0.807 | 0.807 | 138000.0 |
| 2007-08-30 09:00:00 | NVDA | Stock | 0.8063 | 0.8155 | 0.806 | 0.8115 | 273000.0 |
| 2007-08-30 09:30:00 | NVDA | Stock | 0.8082 | 0.825 | 0.808 | 0.822 | 69868200.0 |
| 2007-08-30 10:00:00 | NVDA | Stock | 0.8218 | 0.8315 | 0.8207 | 0.825 | 61093260.0 |
| 2007-08-30 10:30:00 | NVDA | Stock | 0.8252 | 0.828 | 0.8187 | 0.8213 | 30800100.0 |
| 2007-08-30 11:00:00 | NVDA | Stock | 0.8215 | 0.8263 | 0.821 | 0.8232 | 22976700.0 |
| 2007-08-30 11:30:00 | NVDA | Stock | 0.8229 | 0.826 | 0.8208 | 0.8227 | 17438820.0 |
| 2007-08-30 12:00:00 | NVDA | Stock | 0.8225 | 0.8227 | 0.8113 | 0.8173 | 34381500.0 |
| 2007-08-30 12:30:00 | NVDA | Stock | 0.8173 | 0.8235 | 0.8162 | 0.8223 | 22807560.0 |
| 2007-08-30 13:00:00 | NVDA | Stock | 0.822 | 0.8222 | 0.8155 | 0.8172 | 14470020.0 |
| 2007-08-30 13:30:00 | NVDA | Stock | 0.8172 | 0.8203 | 0.815 | 0.8195 | 23606220.0 |
| 2007-08-30 14:00:00 | NVDA | Stock | 0.8197 | 0.8205 | 0.8125 | 0.8125 | 27276000.0 |
| 2007-08-30 14:30:00 | NVDA | Stock | 0.8125 | 0.8135 | 0.8078 | 0.8103 | 34702920.0 |
| 2007-08-30 15:00:00 | NVDA | Stock | 0.8103 | 0.8176 | 0.8102 | 0.8148 | 34294380.0 |
| 2007-08-30 15:30:00 | NVDA | Stock | 0.815 | 0.8153 | 0.8085 | 0.8113 | 38592480.0 |
| 2007-08-30 16:00:00 | NVDA | Stock | 0.8113 | 0.8115 | 0.8113 | 0.8113 | 132000.0 |
| 2007-08-30 17:30:00 | NVDA | Stock | 0.8142 | 0.8143 | 0.8108 | 0.8113 | 147600.0 |
| 2007-08-30 18:00:00 | NVDA | Stock | 0.8115 | 0.8148 | 0.8115 | 0.8148 | 36000.0 |
| 2007-08-30 19:00:00 | NVDA | Stock | 0.8115 | 0.8115 | 0.8108 | 0.8108 | 97800.0 |
| 2007-08-30 19:30:00 | NVDA | Stock | 0.8108 | 0.8108 | 0.8108 | 0.8108 | 57000.0 |
| 2007-08-30 07:30:00 | AMZN | Stock | 3.9275 | 3.9275 | 3.9275 | 3.9275 | 4000.0 |
> showing 50 of 63,180 rows — these rows as CSV