PREVIEW / stock_30min / 2021-03-15
file: by_date/stock_30min/2021/2021-03-15.parquet size: 2.3 MB rows: 118,910 symbols: 2,896
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 |
|---|---|---|---|---|---|---|---|
| 2021-03-15 04:00:00 | AAPL | Stock | 121.0 | 121.5 | 120.61 | 121.24 | 14695.0 |
| 2021-03-15 04:30:00 | AAPL | Stock | 121.27 | 121.59 | 121.25 | 121.55 | 11576.0 |
| 2021-03-15 05:00:00 | AAPL | Stock | 121.49 | 121.7 | 121.49 | 121.65 | 6727.0 |
| 2021-03-15 05:30:00 | AAPL | Stock | 121.67 | 121.94 | 121.65 | 121.7 | 15546.0 |
| 2021-03-15 06:00:00 | AAPL | Stock | 121.72 | 121.77 | 121.43 | 121.61 | 11757.0 |
| 2021-03-15 06:30:00 | AAPL | Stock | 121.57 | 121.7 | 121.25 | 121.5 | 9651.0 |
| 2021-03-15 07:00:00 | AAPL | Stock | 121.51 | 121.88 | 121.49 | 121.61 | 140600.0 |
| 2021-03-15 07:30:00 | AAPL | Stock | 121.62 | 121.81 | 121.4 | 121.42 | 102583.0 |
| 2021-03-15 08:00:00 | AAPL | Stock | 121.51 | 121.86 | 121.09 | 121.25 | 321775.0 |
| 2021-03-15 08:30:00 | AAPL | Stock | 121.26 | 121.39 | 121.09 | 121.32 | 142039.0 |
| 2021-03-15 09:00:00 | AAPL | Stock | 121.32 | 121.66 | 121.25 | 121.39 | 276723.0 |
| 2021-03-15 09:30:00 | AAPL | Stock | 121.39 | 123.64 | 120.42 | 123.2501 | 13220005.0 |
| 2021-03-15 10:00:00 | AAPL | Stock | 123.25 | 123.47 | 122.4001 | 122.5984 | 7705596.0 |
| 2021-03-15 10:30:00 | AAPL | Stock | 122.5997 | 123.18 | 122.235 | 123.11 | 6057163.0 |
| 2021-03-15 11:00:00 | AAPL | Stock | 123.115 | 123.23 | 122.31 | 122.39 | 4141119.0 |
| 2021-03-15 11:30:00 | AAPL | Stock | 122.39 | 122.49 | 122.04 | 122.34 | 3840027.0 |
| 2021-03-15 12:00:00 | AAPL | Stock | 122.34 | 122.44 | 122.2001 | 122.335 | 2897333.0 |
| 2021-03-15 12:30:00 | AAPL | Stock | 122.34 | 122.62 | 122.24 | 122.5299 | 2832606.0 |
| 2021-03-15 13:00:00 | AAPL | Stock | 122.53 | 122.72 | 122.441 | 122.6801 | 2191531.0 |
| 2021-03-15 13:30:00 | AAPL | Stock | 122.68 | 123.16 | 122.65 | 123.1 | 3458191.0 |
| 2021-03-15 14:00:00 | AAPL | Stock | 123.1 | 123.64 | 123.0902 | 123.48 | 4408540.0 |
| 2021-03-15 14:30:00 | AAPL | Stock | 123.47 | 123.58 | 123.28 | 123.37 | 3937085.0 |
| 2021-03-15 15:00:00 | AAPL | Stock | 123.365 | 123.4 | 123.06 | 123.345 | 3816555.0 |
| 2021-03-15 15:30:00 | AAPL | Stock | 123.35 | 124.0 | 123.275 | 124.0 | 9292285.0 |
| 2021-03-15 16:00:00 | AAPL | Stock | 123.99 | 124.11 | 123.7 | 124.05 | 12100094.0 |
| 2021-03-15 16:30:00 | AAPL | Stock | 124.0501 | 124.2 | 124.03 | 124.2 | 97483.0 |
| 2021-03-15 17:00:00 | AAPL | Stock | 124.19 | 124.46 | 124.17 | 124.43 | 113342.0 |
| 2021-03-15 17:30:00 | AAPL | Stock | 124.43 | 124.56 | 124.37 | 124.47 | 134948.0 |
| 2021-03-15 18:00:00 | AAPL | Stock | 124.45 | 124.49 | 124.25 | 124.29 | 70291.0 |
| 2021-03-15 18:30:00 | AAPL | Stock | 124.28 | 124.33 | 124.11 | 124.23 | 50962.0 |
| 2021-03-15 19:00:00 | AAPL | Stock | 124.23 | 124.25 | 124.16 | 124.19 | 34559.0 |
| 2021-03-15 19:30:00 | AAPL | Stock | 124.23 | 124.25 | 124.1 | 124.12 | 48813.0 |
| 2021-03-15 04:00:00 | MSFT | Stock | 234.96 | 234.96 | 234.96 | 234.96 | 265.0 |
| 2021-03-15 04:30:00 | MSFT | Stock | 235.75 | 235.75 | 235.4 | 235.4 | 301.0 |
| 2021-03-15 05:00:00 | MSFT | Stock | 235.84 | 235.84 | 235.84 | 235.84 | 193.0 |
| 2021-03-15 05:30:00 | MSFT | Stock | 236.1 | 236.47 | 236.1 | 236.47 | 314.0 |
| 2021-03-15 06:00:00 | MSFT | Stock | 236.4 | 236.4 | 236.0 | 236.0 | 413.0 |
| 2021-03-15 06:30:00 | MSFT | Stock | 235.99 | 236.42 | 235.88 | 236.42 | 871.0 |
| 2021-03-15 07:00:00 | MSFT | Stock | 236.21 | 236.25 | 235.4 | 235.4 | 11869.0 |
| 2021-03-15 07:30:00 | MSFT | Stock | 235.43 | 235.72 | 235.31 | 235.45 | 3521.0 |
| 2021-03-15 08:00:00 | MSFT | Stock | 235.4 | 235.75 | 235.1 | 235.4 | 10965.0 |
| 2021-03-15 08:30:00 | MSFT | Stock | 235.4 | 236.0 | 235.3 | 235.76 | 5718.0 |
| 2021-03-15 09:00:00 | MSFT | Stock | 235.76 | 236.49 | 234.96 | 234.96 | 29934.0 |
| 2021-03-15 09:30:00 | MSFT | Stock | 234.96 | 235.185 | 233.41 | 234.02 | 2319080.0 |
| 2021-03-15 10:00:00 | MSFT | Stock | 234.02 | 234.14 | 232.5 | 232.74 | 1904504.0 |
| 2021-03-15 10:30:00 | MSFT | Stock | 232.75 | 233.26 | 232.25 | 233.23 | 1480883.0 |
| 2021-03-15 11:00:00 | MSFT | Stock | 233.235 | 233.4016 | 232.26 | 232.48 | 1116863.0 |
| 2021-03-15 11:30:00 | MSFT | Stock | 232.48 | 232.98 | 231.81 | 232.79 | 1178204.0 |
| 2021-03-15 12:00:00 | MSFT | Stock | 232.77 | 233.08 | 232.52 | 232.68 | 803148.0 |
| 2021-03-15 12:30:00 | MSFT | Stock | 232.7 | 233.12 | 232.495 | 232.86 | 705163.0 |
> showing 50 of 118,910 rows — these rows as CSV