PREVIEW / stock_30min / 2022-01-03
file: by_date/stock_30min/2022/2022-01-03.parquet size: 2.3 MB rows: 111,438 symbols: 2,647
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 |
|---|---|---|---|---|---|---|---|
| 2022-01-03 04:00:00 | AAPL | Stock | 178.26 | 178.34 | 177.76 | 177.82 | 19868.0 |
| 2022-01-03 04:30:00 | AAPL | Stock | 177.87 | 178.1 | 177.76 | 178.08 | 19899.0 |
| 2022-01-03 05:00:00 | AAPL | Stock | 178.08 | 178.22 | 177.99 | 178.18 | 22068.0 |
| 2022-01-03 05:30:00 | AAPL | Stock | 178.17 | 178.22 | 178.07 | 178.17 | 12641.0 |
| 2022-01-03 06:00:00 | AAPL | Stock | 178.17 | 178.45 | 178.16 | 178.43 | 16475.0 |
| 2022-01-03 06:30:00 | AAPL | Stock | 178.39 | 178.46 | 178.25 | 178.45 | 7530.0 |
| 2022-01-03 07:00:00 | AAPL | Stock | 178.46 | 178.5 | 178.15 | 178.21 | 52834.0 |
| 2022-01-03 07:30:00 | AAPL | Stock | 178.19 | 178.3 | 178.09 | 178.22 | 17188.0 |
| 2022-01-03 08:00:00 | AAPL | Stock | 178.37 | 178.48 | 177.57 | 178.36 | 170721.0 |
| 2022-01-03 08:30:00 | AAPL | Stock | 178.35 | 178.36 | 177.61 | 177.65 | 165817.0 |
| 2022-01-03 09:00:00 | AAPL | Stock | 177.64 | 177.93 | 177.5 | 177.89 | 309787.0 |
| 2022-01-03 09:30:00 | AAPL | Stock | 177.87 | 180.93 | 177.71 | 180.45 | 12584270.0 |
| 2022-01-03 10:00:00 | AAPL | Stock | 180.46 | 181.43 | 180.2713 | 180.84 | 8476920.0 |
| 2022-01-03 10:30:00 | AAPL | Stock | 180.85 | 181.2301 | 180.57 | 180.96 | 4340400.0 |
| 2022-01-03 11:00:00 | AAPL | Stock | 180.95 | 181.77 | 180.39 | 181.75 | 5351386.0 |
| 2022-01-03 11:30:00 | AAPL | Stock | 181.75 | 181.77 | 181.14 | 181.47 | 4058450.0 |
| 2022-01-03 12:00:00 | AAPL | Stock | 181.47 | 181.695 | 181.075 | 181.6 | 2982247.0 |
| 2022-01-03 12:30:00 | AAPL | Stock | 181.595 | 182.1675 | 181.49 | 181.69 | 4274573.0 |
| 2022-01-03 13:00:00 | AAPL | Stock | 181.6904 | 182.279 | 181.64 | 182.2297 | 3193401.0 |
| 2022-01-03 13:30:00 | AAPL | Stock | 182.225 | 182.88 | 182.21 | 182.365 | 6198429.0 |
| 2022-01-03 14:00:00 | AAPL | Stock | 182.3742 | 182.465 | 181.81 | 181.865 | 4113189.0 |
| 2022-01-03 14:30:00 | AAPL | Stock | 181.86 | 182.29 | 181.66 | 181.88 | 3552453.0 |
| 2022-01-03 15:00:00 | AAPL | Stock | 181.87 | 182.2 | 181.71 | 182.145 | 3445427.0 |
| 2022-01-03 15:30:00 | AAPL | Stock | 182.15 | 182.15 | 181.195 | 182.0 | 9256975.0 |
| 2022-01-03 16:00:00 | AAPL | Stock | 182.0 | 182.3 | 181.7 | 182.26 | 12146331.0 |
| 2022-01-03 16:30:00 | AAPL | Stock | 182.25 | 182.28 | 182.01 | 182.14 | 5022510.0 |
| 2022-01-03 17:00:00 | AAPL | Stock | 182.13 | 182.13 | 182.01 | 182.01 | 33247.0 |
| 2022-01-03 17:30:00 | AAPL | Stock | 182.01 | 182.2 | 182.01 | 182.11 | 18262.0 |
| 2022-01-03 18:00:00 | AAPL | Stock | 182.12 | 182.19 | 182.01 | 182.15 | 29600.0 |
| 2022-01-03 18:30:00 | AAPL | Stock | 182.14 | 182.16 | 181.9 | 181.91 | 30075.0 |
| 2022-01-03 19:00:00 | AAPL | Stock | 181.93 | 182.0 | 181.75 | 181.75 | 23738.0 |
| 2022-01-03 19:30:00 | AAPL | Stock | 181.8 | 182.0 | 181.8 | 181.99 | 33481.0 |
| 2022-01-03 04:00:00 | MSFT | Stock | 338.0 | 338.4 | 336.83 | 336.83 | 7194.0 |
| 2022-01-03 04:30:00 | MSFT | Stock | 336.47 | 336.8 | 336.46 | 336.7 | 3844.0 |
| 2022-01-03 05:00:00 | MSFT | Stock | 336.78 | 337.14 | 336.7 | 337.0 | 7832.0 |
| 2022-01-03 05:30:00 | MSFT | Stock | 337.16 | 337.16 | 337.16 | 337.16 | 100.0 |
| 2022-01-03 06:00:00 | MSFT | Stock | 337.35 | 337.93 | 337.35 | 337.93 | 2084.0 |
| 2022-01-03 06:30:00 | MSFT | Stock | 337.6 | 337.98 | 337.58 | 337.8 | 2070.0 |
| 2022-01-03 07:00:00 | MSFT | Stock | 337.5 | 337.79 | 337.5 | 337.68 | 8932.0 |
| 2022-01-03 07:30:00 | MSFT | Stock | 337.66 | 337.8 | 337.5 | 337.6 | 3051.0 |
| 2022-01-03 08:00:00 | MSFT | Stock | 337.75 | 337.89 | 337.5 | 337.72 | 18820.0 |
| 2022-01-03 08:30:00 | MSFT | Stock | 337.71 | 337.89 | 336.12 | 336.12 | 22094.0 |
| 2022-01-03 09:00:00 | MSFT | Stock | 336.15 | 336.9999 | 335.0 | 335.17 | 40117.0 |
| 2022-01-03 09:30:00 | MSFT | Stock | 335.12 | 338.0 | 329.78 | 330.3252 | 3167420.0 |
| 2022-01-03 10:00:00 | MSFT | Stock | 330.36 | 332.755 | 329.86 | 332.55 | 2092849.0 |
| 2022-01-03 10:30:00 | MSFT | Stock | 332.545 | 332.59 | 331.41 | 332.17 | 1229954.0 |
| 2022-01-03 11:00:00 | MSFT | Stock | 332.18 | 332.26 | 331.0893 | 331.99 | 1089911.0 |
| 2022-01-03 11:30:00 | MSFT | Stock | 331.99 | 332.71 | 331.38 | 331.7 | 906983.0 |
| 2022-01-03 12:00:00 | MSFT | Stock | 331.69 | 332.96 | 331.31 | 332.64 | 842391.0 |
| 2022-01-03 12:30:00 | MSFT | Stock | 332.62 | 332.8 | 332.08 | 332.22 | 660128.0 |
> showing 50 of 111,438 rows — these rows as CSV