PREVIEW / stock_1hour / 2003-04-01
file: by_date/stock_1hour/2003/2003-04-01.parquet size: 426 KB rows: 21,173 symbols: 1,562
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 |
|---|---|---|---|---|---|---|---|
| 2003-04-01 08:00:00 | AAPL | Stock | 0.2536 | 0.2536 | 0.2527 | 0.2527 | 1559600.0 |
| 2003-04-01 09:00:00 | AAPL | Stock | 0.253 | 0.2552 | 0.2514 | 0.2518 | 25111576.0 |
| 2003-04-01 10:00:00 | AAPL | Stock | 0.2518 | 0.2555 | 0.2514 | 0.2539 | 31944248.0 |
| 2003-04-01 11:00:00 | AAPL | Stock | 0.2539 | 0.2545 | 0.2538 | 0.2545 | 11749696.0 |
| 2003-04-01 12:00:00 | AAPL | Stock | 0.2545 | 0.2555 | 0.2538 | 0.2545 | 13388984.0 |
| 2003-04-01 13:00:00 | AAPL | Stock | 0.2545 | 0.255 | 0.253 | 0.2541 | 10204544.0 |
| 2003-04-01 14:00:00 | AAPL | Stock | 0.2541 | 0.2552 | 0.2527 | 0.2532 | 11680144.0 |
| 2003-04-01 15:00:00 | AAPL | Stock | 0.2532 | 0.2538 | 0.2513 | 0.2527 | 23254728.0 |
| 2003-04-01 16:00:00 | AAPL | Stock | 0.2521 | 0.2529 | 0.2514 | 0.2516 | 2690632.0 |
| 2003-04-01 17:00:00 | AAPL | Stock | 0.2518 | 0.2535 | 0.2518 | 0.252 | 9856000.0 |
| 2003-04-01 18:00:00 | AAPL | Stock | 0.2518 | 0.2518 | 0.2518 | 0.2518 | 33600.0 |
| 2003-04-01 08:00:00 | MSFT | Stock | 24.4 | 24.53 | 24.22 | 24.5 | 133134.0 |
| 2003-04-01 09:00:00 | MSFT | Stock | 24.21 | 24.6 | 24.21 | 24.35 | 5583576.0 |
| 2003-04-01 10:00:00 | MSFT | Stock | 24.35 | 24.6 | 24.25 | 24.29 | 9406250.0 |
| 2003-04-01 11:00:00 | MSFT | Stock | 24.28 | 24.4 | 24.26 | 24.34 | 4463558.0 |
| 2003-04-01 12:00:00 | MSFT | Stock | 24.35 | 24.61 | 24.34 | 24.6 | 6368977.0 |
| 2003-04-01 13:00:00 | MSFT | Stock | 24.6 | 24.63 | 24.44 | 24.59 | 3463162.0 |
| 2003-04-01 14:00:00 | MSFT | Stock | 24.588 | 24.7 | 24.499 | 24.52 | 5316234.0 |
| 2003-04-01 15:00:00 | MSFT | Stock | 24.52 | 24.604 | 24.3 | 24.33 | 8792645.0 |
| 2003-04-01 16:00:00 | MSFT | Stock | 24.34 | 24.466 | 24.2 | 24.339 | 1010235.0 |
| 2003-04-01 17:00:00 | MSFT | Stock | 24.31 | 24.4647 | 24.3 | 24.35 | 540800.0 |
| 2003-04-01 18:00:00 | MSFT | Stock | 24.36 | 24.55 | 24.34 | 24.55 | 54000.0 |
| 2003-04-01 08:00:00 | NVDA | Stock | 0.1081 | 0.1092 | 0.1081 | 0.1087 | 2930760.0 |
| 2003-04-01 09:00:00 | NVDA | Stock | 0.109 | 0.1101 | 0.1072 | 0.1087 | 71339160.0 |
| 2003-04-01 10:00:00 | NVDA | Stock | 0.1086 | 0.1107 | 0.1082 | 0.1098 | 148445040.0 |
| 2003-04-01 11:00:00 | NVDA | Stock | 0.1097 | 0.1105 | 0.1096 | 0.11 | 44594040.0 |
| 2003-04-01 12:00:00 | NVDA | Stock | 0.11 | 0.1111 | 0.1099 | 0.1111 | 60566640.0 |
| 2003-04-01 13:00:00 | NVDA | Stock | 0.1109 | 0.1117 | 0.1104 | 0.1116 | 36524040.0 |
| 2003-04-01 14:00:00 | NVDA | Stock | 0.1116 | 0.1117 | 0.1106 | 0.1107 | 50376000.0 |
| 2003-04-01 15:00:00 | NVDA | Stock | 0.1108 | 0.111 | 0.1097 | 0.1105 | 73169400.0 |
| 2003-04-01 16:00:00 | NVDA | Stock | 0.1104 | 0.1105 | 0.1096 | 0.1101 | 7113840.0 |
| 2003-04-01 17:00:00 | NVDA | Stock | 0.1106 | 0.1106 | 0.11 | 0.1105 | 5058600.0 |
| 2003-04-01 18:00:00 | NVDA | Stock | 0.1104 | 0.1104 | 0.1104 | 0.1104 | 276000.0 |
| 2003-04-01 08:00:00 | AMZN | Stock | 1.282 | 1.302 | 0.9975 | 1.275 | 1939180.0 |
| 2003-04-01 09:00:00 | AMZN | Stock | 1.2745 | 1.354 | 1.253 | 1.2575 | 44673060.0 |
| 2003-04-01 10:00:00 | AMZN | Stock | 1.2585 | 1.276 | 1.2555 | 1.264 | 37967600.0 |
| 2003-04-01 11:00:00 | AMZN | Stock | 1.264 | 1.2715 | 1.2625 | 1.27 | 18046080.0 |
| 2003-04-01 12:00:00 | AMZN | Stock | 1.2695 | 1.2795 | 1.268 | 1.2775 | 19705180.0 |
| 2003-04-01 13:00:00 | AMZN | Stock | 1.277 | 1.2785 | 1.2695 | 1.2745 | 9677840.0 |
| 2003-04-01 14:00:00 | AMZN | Stock | 1.2745 | 1.275 | 1.2625 | 1.2635 | 14604840.0 |
| 2003-04-01 15:00:00 | AMZN | Stock | 1.2635 | 1.277 | 1.258 | 1.2755 | 26614340.0 |
| 2003-04-01 16:00:00 | AMZN | Stock | 1.2755 | 1.285 | 1.273 | 1.285 | 2559600.0 |
| 2003-04-01 17:00:00 | AMZN | Stock | 1.2776 | 1.28 | 1.2684 | 1.28 | 976800.0 |
| 2003-04-01 18:00:00 | AMZN | Stock | 1.28 | 1.28 | 1.279 | 1.28 | 26000.0 |
| 2003-04-01 09:00:00 | CL | Stock | 27.25 | 27.25 | 27.0 | 27.165 | 308600.0 |
| 2003-04-01 10:00:00 | CL | Stock | 27.17 | 27.505 | 27.15 | 27.375 | 562600.0 |
| 2003-04-01 11:00:00 | CL | Stock | 27.375 | 27.5 | 27.375 | 27.435 | 580200.0 |
| 2003-04-01 12:00:00 | CL | Stock | 27.45 | 27.735 | 27.45 | 27.71 | 665400.0 |
| 2003-04-01 13:00:00 | CL | Stock | 27.71 | 27.725 | 27.65 | 27.675 | 324000.0 |
| 2003-04-01 14:00:00 | CL | Stock | 27.71 | 27.72 | 27.555 | 27.595 | 500600.0 |
> showing 50 of 21,173 rows — these rows as CSV