PREVIEW / stock_30min / 2003-07-07
file: by_date/stock_30min/2003/2003-07-07.parquet size: 717 KB rows: 38,629 symbols: 1,587
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-07-07 09:00:00 | AAPL | Stock | 0.3464 | 0.3464 | 0.3427 | 0.3438 | 218400.0 |
| 2003-07-07 09:30:00 | AAPL | Stock | 0.3441 | 0.3509 | 0.3416 | 0.3505 | 23047304.0 |
| 2003-07-07 10:00:00 | AAPL | Stock | 0.3505 | 0.3564 | 0.3489 | 0.3563 | 39146632.0 |
| 2003-07-07 10:30:00 | AAPL | Stock | 0.3564 | 0.3571 | 0.3552 | 0.357 | 23219672.0 |
| 2003-07-07 11:00:00 | AAPL | Stock | 0.3568 | 0.358 | 0.3554 | 0.3573 | 28946232.0 |
| 2003-07-07 11:30:00 | AAPL | Stock | 0.3571 | 0.358 | 0.3561 | 0.3577 | 13698328.0 |
| 2003-07-07 12:00:00 | AAPL | Stock | 0.3577 | 0.3602 | 0.3571 | 0.3595 | 18686864.0 |
| 2003-07-07 12:30:00 | AAPL | Stock | 0.3596 | 0.3604 | 0.3566 | 0.3568 | 14094808.0 |
| 2003-07-07 13:00:00 | AAPL | Stock | 0.3568 | 0.3569 | 0.3554 | 0.3563 | 12621056.0 |
| 2003-07-07 13:30:00 | AAPL | Stock | 0.3563 | 0.358 | 0.3561 | 0.3579 | 7406672.0 |
| 2003-07-07 14:00:00 | AAPL | Stock | 0.3579 | 0.3591 | 0.3568 | 0.357 | 7348880.0 |
| 2003-07-07 14:30:00 | AAPL | Stock | 0.3568 | 0.3582 | 0.3564 | 0.3579 | 10327968.0 |
| 2003-07-07 15:00:00 | AAPL | Stock | 0.3579 | 0.358 | 0.3525 | 0.3546 | 25053168.0 |
| 2003-07-07 15:30:00 | AAPL | Stock | 0.3545 | 0.357 | 0.3532 | 0.3548 | 29369536.0 |
| 2003-07-07 16:00:00 | AAPL | Stock | 0.3543 | 0.3571 | 0.3543 | 0.3557 | 7772800.0 |
| 2003-07-07 16:30:00 | AAPL | Stock | 0.3554 | 0.3554 | 0.3548 | 0.355 | 2637600.0 |
| 2003-07-07 17:00:00 | AAPL | Stock | 0.355 | 0.3554 | 0.3548 | 0.3548 | 560000.0 |
| 2003-07-07 17:30:00 | AAPL | Stock | 0.356 | 0.356 | 0.356 | 0.356 | 4060000.0 |
| 2003-07-07 08:00:00 | MSFT | Stock | 27.21 | 27.52 | 26.5 | 27.15 | 482800.0 |
| 2003-07-07 08:30:00 | MSFT | Stock | 27.14 | 27.3 | 27.06 | 27.12 | 165800.0 |
| 2003-07-07 09:00:00 | MSFT | Stock | 27.12 | 27.45 | 27.01 | 27.01 | 1120301.0 |
| 2003-07-07 09:30:00 | MSFT | Stock | 27.01 | 27.45 | 26.985 | 27.42 | 17824881.0 |
| 2003-07-07 10:00:00 | MSFT | Stock | 27.42 | 27.53 | 27.341 | 27.5 | 9388068.0 |
| 2003-07-07 10:30:00 | MSFT | Stock | 27.49 | 27.5 | 27.379 | 27.47 | 6127226.0 |
| 2003-07-07 11:00:00 | MSFT | Stock | 27.47 | 27.551 | 27.43 | 27.49 | 5310039.0 |
| 2003-07-07 11:30:00 | MSFT | Stock | 27.49 | 27.53 | 27.4 | 27.47 | 4300693.0 |
| 2003-07-07 12:00:00 | MSFT | Stock | 27.47 | 27.53 | 27.46 | 27.5 | 3944549.0 |
| 2003-07-07 12:30:00 | MSFT | Stock | 27.51 | 27.51 | 27.41 | 27.4501 | 3118658.0 |
| 2003-07-07 13:00:00 | MSFT | Stock | 27.46 | 27.46 | 27.38 | 27.411 | 3218679.0 |
| 2003-07-07 13:30:00 | MSFT | Stock | 27.42 | 27.48 | 27.4 | 27.42 | 3007916.0 |
| 2003-07-07 14:00:00 | MSFT | Stock | 27.43 | 27.49 | 27.42 | 27.45 | 3389468.0 |
| 2003-07-07 14:30:00 | MSFT | Stock | 27.46 | 27.52 | 27.44 | 27.51 | 4221336.0 |
| 2003-07-07 15:00:00 | MSFT | Stock | 27.52 | 27.54 | 27.4 | 27.46 | 5755914.0 |
| 2003-07-07 15:30:00 | MSFT | Stock | 27.47 | 27.53 | 27.38 | 27.41 | 6350434.0 |
| 2003-07-07 16:00:00 | MSFT | Stock | 27.38 | 27.54 | 27.37 | 27.46 | 1074771.0 |
| 2003-07-07 16:30:00 | MSFT | Stock | 27.45 | 27.48 | 27.42 | 27.43 | 608553.0 |
| 2003-07-07 17:00:00 | MSFT | Stock | 27.47 | 27.47 | 27.3773 | 27.47 | 165100.0 |
| 2003-07-07 17:30:00 | MSFT | Stock | 27.46 | 27.5003 | 27.3991 | 27.47 | 286224.0 |
| 2003-07-07 18:00:00 | MSFT | Stock | 27.47 | 27.51 | 27.24 | 27.49 | 8900.0 |
| 2003-07-07 08:00:00 | NVDA | Stock | 0.1996 | 0.2 | 0.1996 | 0.2 | 120000.0 |
| 2003-07-07 08:30:00 | NVDA | Stock | 0.2 | 0.2 | 0.2 | 0.2 | 180000.0 |
| 2003-07-07 09:00:00 | NVDA | Stock | 0.2008 | 0.2008 | 0.1987 | 0.1987 | 1272600.0 |
| 2003-07-07 09:30:00 | NVDA | Stock | 0.1986 | 0.2057 | 0.1985 | 0.2051 | 182666880.0 |
| 2003-07-07 10:00:00 | NVDA | Stock | 0.205 | 0.2077 | 0.2045 | 0.2075 | 98066520.0 |
| 2003-07-07 10:30:00 | NVDA | Stock | 0.2074 | 0.2074 | 0.2047 | 0.2058 | 58672200.0 |
| 2003-07-07 11:00:00 | NVDA | Stock | 0.2057 | 0.2062 | 0.2051 | 0.206 | 40390320.0 |
| 2003-07-07 11:30:00 | NVDA | Stock | 0.2061 | 0.2065 | 0.2042 | 0.2048 | 39588960.0 |
| 2003-07-07 12:00:00 | NVDA | Stock | 0.2048 | 0.2066 | 0.2048 | 0.2058 | 33782880.0 |
| 2003-07-07 12:30:00 | NVDA | Stock | 0.2058 | 0.2064 | 0.2047 | 0.2051 | 19758120.0 |
| 2003-07-07 13:00:00 | NVDA | Stock | 0.2052 | 0.2062 | 0.2047 | 0.2061 | 28302240.0 |
> showing 50 of 38,629 rows — these rows as CSV