PREVIEW / stock_1hour / 2005-02-14
file: by_date/stock_1hour/2005/2005-02-14.parquet size: 542 KB rows: 25,469 symbols: 1,928
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-02-14 08:00:00 | AAPL | Stock | 1.4641 | 1.4732 | 1.4589 | 1.4643 | 9327248.0 |
| 2005-02-14 09:00:00 | AAPL | Stock | 1.4643 | 1.4909 | 1.4557 | 1.4855 | 269689896.0 |
| 2005-02-14 10:00:00 | AAPL | Stock | 1.4855 | 1.4989 | 1.483 | 1.4902 | 252827008.0 |
| 2005-02-14 11:00:00 | AAPL | Stock | 1.4904 | 1.4923 | 1.4832 | 1.4855 | 156660672.0 |
| 2005-02-14 12:00:00 | AAPL | Stock | 1.4855 | 1.4943 | 1.4834 | 1.493 | 85821736.0 |
| 2005-02-14 13:00:00 | AAPL | Stock | 1.493 | 1.5009 | 1.4902 | 1.4988 | 100585744.0 |
| 2005-02-14 14:00:00 | AAPL | Stock | 1.4988 | 1.5125 | 1.497 | 1.5064 | 190392272.0 |
| 2005-02-14 15:00:00 | AAPL | Stock | 1.5064 | 1.5141 | 1.5038 | 1.5114 | 192749928.0 |
| 2005-02-14 16:00:00 | AAPL | Stock | 1.5114 | 1.5138 | 1.5095 | 1.5138 | 6433392.0 |
| 2005-02-14 17:00:00 | AAPL | Stock | 1.5138 | 1.5141 | 1.5116 | 1.5123 | 647528.0 |
| 2005-02-14 18:00:00 | AAPL | Stock | 1.5134 | 1.5141 | 1.5123 | 1.5123 | 327208.0 |
| 2005-02-14 08:00:00 | MSFT | Stock | 25.99 | 26.02 | 25.99 | 26.01 | 11020.0 |
| 2005-02-14 09:00:00 | MSFT | Stock | 26.01 | 26.05 | 25.91 | 26.01 | 7797438.0 |
| 2005-02-14 10:00:00 | MSFT | Stock | 26.01 | 26.09 | 25.99 | 26.05 | 13413883.0 |
| 2005-02-14 11:00:00 | MSFT | Stock | 26.04 | 26.12 | 25.97 | 26.039 | 9779949.0 |
| 2005-02-14 12:00:00 | MSFT | Stock | 26.03 | 26.05 | 25.98 | 26.0 | 6076348.0 |
| 2005-02-14 13:00:00 | MSFT | Stock | 26.0 | 26.03 | 25.96 | 25.98 | 5060612.0 |
| 2005-02-14 14:00:00 | MSFT | Stock | 25.989 | 26.02 | 25.96 | 25.97 | 5692122.0 |
| 2005-02-14 15:00:00 | MSFT | Stock | 25.98 | 26.05 | 25.97 | 26.02 | 9081005.0 |
| 2005-02-14 16:00:00 | MSFT | Stock | 26.01 | 26.03 | 25.91 | 26.01 | 233114.0 |
| 2005-02-14 17:00:00 | MSFT | Stock | 26.01 | 26.02 | 26.01 | 26.02 | 234353.0 |
| 2005-02-14 08:00:00 | NVDA | Stock | 0.2179 | 0.2179 | 0.2167 | 0.2168 | 144000.0 |
| 2005-02-14 09:00:00 | NVDA | Stock | 0.2167 | 0.2187 | 0.2158 | 0.2171 | 62515440.0 |
| 2005-02-14 10:00:00 | NVDA | Stock | 0.2171 | 0.2178 | 0.2151 | 0.2154 | 63470640.0 |
| 2005-02-14 11:00:00 | NVDA | Stock | 0.2153 | 0.2157 | 0.2142 | 0.215 | 63141000.0 |
| 2005-02-14 12:00:00 | NVDA | Stock | 0.215 | 0.215 | 0.2125 | 0.213 | 40024920.0 |
| 2005-02-14 13:00:00 | NVDA | Stock | 0.213 | 0.2143 | 0.2126 | 0.2133 | 43307640.0 |
| 2005-02-14 14:00:00 | NVDA | Stock | 0.2132 | 0.2146 | 0.2129 | 0.214 | 53354040.0 |
| 2005-02-14 15:00:00 | NVDA | Stock | 0.2139 | 0.2143 | 0.2129 | 0.2133 | 85059840.0 |
| 2005-02-14 16:00:00 | NVDA | Stock | 0.213 | 0.2136 | 0.2129 | 0.2133 | 12278760.0 |
| 2005-02-14 17:00:00 | NVDA | Stock | 0.2136 | 0.2136 | 0.2136 | 0.2136 | 60000.0 |
| 2005-02-14 08:00:00 | AMZN | Stock | 1.787 | 1.79 | 1.787 | 1.7875 | 6000.0 |
| 2005-02-14 09:00:00 | AMZN | Stock | 1.7875 | 1.7945 | 1.775 | 1.7845 | 10748000.0 |
| 2005-02-14 10:00:00 | AMZN | Stock | 1.7845 | 1.8175 | 1.7825 | 1.8125 | 34479040.0 |
| 2005-02-14 11:00:00 | AMZN | Stock | 1.8125 | 1.8155 | 1.8035 | 1.8125 | 23378060.0 |
| 2005-02-14 12:00:00 | AMZN | Stock | 1.8125 | 1.821 | 1.8065 | 1.817 | 12342620.0 |
| 2005-02-14 13:00:00 | AMZN | Stock | 1.8175 | 1.8315 | 1.8135 | 1.8255 | 17527720.0 |
| 2005-02-14 14:00:00 | AMZN | Stock | 1.8255 | 1.827 | 1.8105 | 1.816 | 13676640.0 |
| 2005-02-14 15:00:00 | AMZN | Stock | 1.816 | 1.819 | 1.8 | 1.803 | 24551060.0 |
| 2005-02-14 16:00:00 | AMZN | Stock | 1.8015 | 1.806 | 1.7995 | 1.8025 | 824500.0 |
| 2005-02-14 17:00:00 | AMZN | Stock | 1.8025 | 1.8045 | 1.8015 | 1.8045 | 109980.0 |
| 2005-02-14 18:00:00 | AMZN | Stock | 1.8045 | 1.8045 | 1.8045 | 1.8045 | 16000.0 |
| 2005-02-14 09:00:00 | CL | Stock | 27.33 | 27.35 | 27.205 | 27.23 | 257400.0 |
| 2005-02-14 10:00:00 | CL | Stock | 27.225 | 27.295 | 27.165 | 27.27 | 492200.0 |
| 2005-02-14 11:00:00 | CL | Stock | 27.27 | 27.395 | 27.25 | 27.29 | 494000.0 |
| 2005-02-14 12:00:00 | CL | Stock | 27.285 | 27.29 | 27.22 | 27.27 | 245800.0 |
| 2005-02-14 13:00:00 | CL | Stock | 27.275 | 27.37 | 27.27 | 27.32 | 203400.0 |
| 2005-02-14 14:00:00 | CL | Stock | 27.325 | 27.325 | 27.23 | 27.27 | 246800.0 |
| 2005-02-14 15:00:00 | CL | Stock | 27.27 | 27.305 | 27.245 | 27.25 | 756800.0 |
> showing 49 of 25,469 rows — these rows as CSV