PREVIEW / stock_5min / 2022-05-06
file: by_date/stock_5min/2022/2022-05-06.parquet size: 7.2 MB rows: 449,638 symbols: 2,396
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-05-06 04:00:00 | AAPL | Stock | 157.29 | 157.29 | 156.2 | 156.36 | 5752.0 |
| 2022-05-06 04:05:00 | AAPL | Stock | 156.43 | 156.88 | 156.43 | 156.63 | 7073.0 |
| 2022-05-06 04:10:00 | AAPL | Stock | 156.64 | 156.68 | 156.62 | 156.62 | 2374.0 |
| 2022-05-06 04:15:00 | AAPL | Stock | 156.58 | 156.9 | 156.57 | 156.9 | 1537.0 |
| 2022-05-06 04:20:00 | AAPL | Stock | 156.93 | 156.99 | 156.86 | 156.99 | 1905.0 |
| 2022-05-06 04:25:00 | AAPL | Stock | 157.02 | 157.02 | 156.9 | 156.98 | 1988.0 |
| 2022-05-06 04:30:00 | AAPL | Stock | 157.13 | 157.3 | 157.03 | 157.28 | 2752.0 |
| 2022-05-06 04:35:00 | AAPL | Stock | 157.15 | 157.15 | 157.01 | 157.04 | 1176.0 |
| 2022-05-06 04:40:00 | AAPL | Stock | 157.01 | 157.06 | 156.9 | 156.91 | 4485.0 |
| 2022-05-06 04:45:00 | AAPL | Stock | 156.95 | 156.96 | 156.94 | 156.94 | 570.0 |
| 2022-05-06 04:50:00 | AAPL | Stock | 156.95 | 156.95 | 156.61 | 156.61 | 6795.0 |
| 2022-05-06 04:55:00 | AAPL | Stock | 156.55 | 156.56 | 156.5 | 156.5 | 7202.0 |
| 2022-05-06 05:00:00 | AAPL | Stock | 156.65 | 156.65 | 156.62 | 156.62 | 957.0 |
| 2022-05-06 05:05:00 | AAPL | Stock | 156.74 | 156.74 | 156.5 | 156.55 | 1799.0 |
| 2022-05-06 05:10:00 | AAPL | Stock | 156.58 | 156.58 | 156.58 | 156.58 | 227.0 |
| 2022-05-06 05:15:00 | AAPL | Stock | 156.52 | 156.54 | 156.3 | 156.43 | 3443.0 |
| 2022-05-06 05:20:00 | AAPL | Stock | 156.41 | 156.42 | 156.21 | 156.4 | 1566.0 |
| 2022-05-06 05:25:00 | AAPL | Stock | 156.24 | 156.3 | 156.21 | 156.25 | 1408.0 |
| 2022-05-06 05:30:00 | AAPL | Stock | 156.3 | 156.41 | 156.3 | 156.41 | 485.0 |
| 2022-05-06 05:35:00 | AAPL | Stock | 156.5 | 156.5 | 156.5 | 156.5 | 149.0 |
| 2022-05-06 05:40:00 | AAPL | Stock | 156.49 | 156.52 | 156.49 | 156.5 | 665.0 |
| 2022-05-06 05:45:00 | AAPL | Stock | 156.68 | 156.68 | 156.68 | 156.68 | 100.0 |
| 2022-05-06 05:50:00 | AAPL | Stock | 156.79 | 156.79 | 156.78 | 156.78 | 873.0 |
| 2022-05-06 05:55:00 | AAPL | Stock | 156.82 | 156.82 | 156.82 | 156.82 | 359.0 |
| 2022-05-06 06:00:00 | AAPL | Stock | 156.84 | 156.84 | 156.84 | 156.84 | 129.0 |
| 2022-05-06 06:05:00 | AAPL | Stock | 156.7 | 156.7 | 156.65 | 156.65 | 367.0 |
| 2022-05-06 06:10:00 | AAPL | Stock | 156.69 | 156.9 | 156.61 | 156.61 | 2036.0 |
| 2022-05-06 06:15:00 | AAPL | Stock | 156.61 | 156.61 | 156.52 | 156.52 | 649.0 |
| 2022-05-06 06:20:00 | AAPL | Stock | 156.55 | 156.62 | 156.55 | 156.62 | 550.0 |
| 2022-05-06 06:25:00 | AAPL | Stock | 156.74 | 156.87 | 156.74 | 156.87 | 1939.0 |
| 2022-05-06 06:30:00 | AAPL | Stock | 156.96 | 157.06 | 156.86 | 156.86 | 3459.0 |
| 2022-05-06 06:35:00 | AAPL | Stock | 156.88 | 156.9 | 156.8 | 156.85 | 3978.0 |
| 2022-05-06 06:40:00 | AAPL | Stock | 156.8 | 156.8 | 156.66 | 156.66 | 608.0 |
| 2022-05-06 06:45:00 | AAPL | Stock | 156.54 | 156.56 | 156.21 | 156.29 | 26074.0 |
| 2022-05-06 06:50:00 | AAPL | Stock | 156.46 | 156.52 | 156.3 | 156.33 | 2156.0 |
| 2022-05-06 06:55:00 | AAPL | Stock | 156.29 | 156.3 | 156.21 | 156.3 | 1086.0 |
| 2022-05-06 07:00:00 | AAPL | Stock | 156.4 | 156.44 | 156.16 | 156.2 | 13046.0 |
| 2022-05-06 07:05:00 | AAPL | Stock | 156.25 | 156.25 | 156.11 | 156.11 | 5181.0 |
| 2022-05-06 07:10:00 | AAPL | Stock | 156.11 | 156.11 | 155.77 | 155.78 | 14754.0 |
| 2022-05-06 07:15:00 | AAPL | Stock | 155.75 | 155.9 | 155.65 | 155.73 | 8041.0 |
| 2022-05-06 07:20:00 | AAPL | Stock | 155.77 | 156.0 | 155.77 | 155.99 | 11040.0 |
| 2022-05-06 07:25:00 | AAPL | Stock | 155.85 | 155.85 | 155.76 | 155.8 | 3810.0 |
| 2022-05-06 07:30:00 | AAPL | Stock | 155.76 | 155.78 | 155.51 | 155.78 | 8514.0 |
| 2022-05-06 07:35:00 | AAPL | Stock | 155.78 | 156.0 | 155.67 | 156.0 | 3887.0 |
| 2022-05-06 07:40:00 | AAPL | Stock | 156.05 | 156.18 | 156.0 | 156.1 | 9582.0 |
| 2022-05-06 07:45:00 | AAPL | Stock | 156.1 | 156.1 | 156.04 | 156.05 | 2911.0 |
| 2022-05-06 07:50:00 | AAPL | Stock | 156.09 | 156.17 | 156.09 | 156.15 | 7198.0 |
| 2022-05-06 07:55:00 | AAPL | Stock | 156.17 | 156.27 | 156.02 | 156.19 | 8388.0 |
| 2022-05-06 08:00:00 | AAPL | Stock | 156.1402 | 157.62 | 155.6 | 156.4201 | 240764.0 |
| 2022-05-06 08:05:00 | AAPL | Stock | 156.49 | 156.74 | 156.32 | 156.74 | 30439.0 |
> showing 50 of 449,638 rows — these rows as CSV