PREVIEW / stock_30min / 2006-09-07
file: by_date/stock_30min/2006/2006-09-07.parquet size: 892 KB rows: 48,946 symbols: 2,357
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 |
|---|---|---|---|---|---|---|---|
| 2006-09-07 04:00:00 | AAPL | Stock | 2.4964 | 2.4964 | 2.4964 | 2.4964 | 2800.0 |
| 2006-09-07 04:30:00 | AAPL | Stock | 2.4964 | 2.4964 | 2.4964 | 2.4964 | 25200.0 |
| 2006-09-07 06:30:00 | AAPL | Stock | 2.5018 | 2.5018 | 2.5004 | 2.5004 | 8400.0 |
| 2006-09-07 07:00:00 | AAPL | Stock | 2.5089 | 2.5161 | 2.5089 | 2.5161 | 72100.0 |
| 2006-09-07 07:30:00 | AAPL | Stock | 2.5096 | 2.5179 | 2.5096 | 2.5136 | 173600.0 |
| 2006-09-07 08:00:00 | AAPL | Stock | 2.5175 | 2.5211 | 2.5107 | 2.5211 | 2599072.0 |
| 2006-09-07 08:30:00 | AAPL | Stock | 2.5204 | 2.525 | 2.5179 | 2.5232 | 3344320.0 |
| 2006-09-07 09:00:00 | AAPL | Stock | 2.5218 | 2.5243 | 2.5179 | 2.5207 | 2735404.0 |
| 2006-09-07 09:30:00 | AAPL | Stock | 2.5214 | 2.5493 | 2.5089 | 2.5371 | 160023752.0 |
| 2006-09-07 10:00:00 | AAPL | Stock | 2.5375 | 2.5589 | 2.5296 | 2.5543 | 127399104.0 |
| 2006-09-07 10:30:00 | AAPL | Stock | 2.5543 | 2.5714 | 2.5496 | 2.5586 | 122651200.0 |
| 2006-09-07 11:00:00 | AAPL | Stock | 2.5586 | 2.5839 | 2.5579 | 2.5814 | 99215620.0 |
| 2006-09-07 11:30:00 | AAPL | Stock | 2.5814 | 2.6 | 2.5796 | 2.595 | 103668684.0 |
| 2006-09-07 12:00:00 | AAPL | Stock | 2.595 | 2.5996 | 2.5911 | 2.5943 | 51528036.0 |
| 2006-09-07 12:30:00 | AAPL | Stock | 2.5939 | 2.6018 | 2.5875 | 2.5911 | 51951732.0 |
| 2006-09-07 13:00:00 | AAPL | Stock | 2.5914 | 2.5975 | 2.5839 | 2.5939 | 49780388.0 |
| 2006-09-07 13:30:00 | AAPL | Stock | 2.5939 | 2.6179 | 2.5929 | 2.6086 | 88369148.0 |
| 2006-09-07 14:00:00 | AAPL | Stock | 2.6089 | 2.6243 | 2.605 | 2.6125 | 80833396.0 |
| 2006-09-07 14:30:00 | AAPL | Stock | 2.6125 | 2.6193 | 2.5964 | 2.5993 | 88937268.0 |
| 2006-09-07 15:00:00 | AAPL | Stock | 2.5996 | 2.6086 | 2.5875 | 2.6086 | 104063288.0 |
| 2006-09-07 15:30:00 | AAPL | Stock | 2.6086 | 2.6086 | 2.5932 | 2.5989 | 116048324.0 |
| 2006-09-07 16:00:00 | AAPL | Stock | 2.5989 | 2.6046 | 2.5979 | 2.6004 | 3171196.0 |
| 2006-09-07 16:30:00 | AAPL | Stock | 2.6007 | 2.6018 | 2.5957 | 2.5964 | 358512.0 |
| 2006-09-07 17:00:00 | AAPL | Stock | 2.5982 | 2.6018 | 2.5979 | 2.5986 | 131208.0 |
| 2006-09-07 17:30:00 | AAPL | Stock | 2.5986 | 2.6011 | 2.5982 | 2.6011 | 84840.0 |
| 2006-09-07 18:00:00 | AAPL | Stock | 2.6 | 2.6021 | 2.5993 | 2.6011 | 56980.0 |
| 2006-09-07 04:00:00 | MSFT | Stock | 25.56 | 25.56 | 25.54 | 25.54 | 300.0 |
| 2006-09-07 04:30:00 | MSFT | Stock | 25.31 | 25.31 | 25.31 | 25.31 | 100.0 |
| 2006-09-07 07:00:00 | MSFT | Stock | 25.52 | 25.52 | 25.47 | 25.47 | 1200.0 |
| 2006-09-07 07:30:00 | MSFT | Stock | 25.5 | 25.55 | 25.5 | 25.55 | 2850.0 |
| 2006-09-07 08:00:00 | MSFT | Stock | 25.55 | 25.55 | 25.5 | 25.5 | 21707.0 |
| 2006-09-07 08:30:00 | MSFT | Stock | 25.5 | 25.54 | 25.5 | 25.54 | 16500.0 |
| 2006-09-07 09:00:00 | MSFT | Stock | 25.53 | 25.54 | 25.47 | 25.48 | 136025.0 |
| 2006-09-07 09:30:00 | MSFT | Stock | 25.48 | 25.7 | 25.39 | 25.61 | 6906415.0 |
| 2006-09-07 10:00:00 | MSFT | Stock | 25.61 | 25.62 | 25.52 | 25.56 | 4237862.0 |
| 2006-09-07 10:30:00 | MSFT | Stock | 25.55 | 25.59 | 25.52 | 25.57 | 3557887.0 |
| 2006-09-07 11:00:00 | MSFT | Stock | 25.56 | 25.6 | 25.54 | 25.56 | 2228641.0 |
| 2006-09-07 11:30:00 | MSFT | Stock | 25.56 | 25.62 | 25.54 | 25.61 | 2820561.0 |
| 2006-09-07 12:00:00 | MSFT | Stock | 25.61 | 25.65 | 25.58 | 25.593 | 1593916.0 |
| 2006-09-07 12:30:00 | MSFT | Stock | 25.6 | 25.61 | 25.54 | 25.55 | 1728439.0 |
| 2006-09-07 13:00:00 | MSFT | Stock | 25.56 | 25.58 | 25.55 | 25.56 | 1857491.0 |
| 2006-09-07 13:30:00 | MSFT | Stock | 25.56 | 25.68 | 25.55 | 25.65 | 3793944.0 |
| 2006-09-07 14:00:00 | MSFT | Stock | 25.66 | 25.67 | 25.61 | 25.61 | 3201487.0 |
| 2006-09-07 14:30:00 | MSFT | Stock | 25.61 | 25.64 | 25.56 | 25.6 | 2902927.0 |
| 2006-09-07 15:00:00 | MSFT | Stock | 25.6 | 25.61 | 25.55 | 25.57 | 3763499.0 |
| 2006-09-07 15:30:00 | MSFT | Stock | 25.57 | 25.57 | 25.43 | 25.43 | 8288639.0 |
| 2006-09-07 16:00:00 | MSFT | Stock | 25.43 | 25.472 | 25.41 | 25.43 | 1300888.0 |
| 2006-09-07 16:30:00 | MSFT | Stock | 25.44 | 25.44 | 25.4 | 25.42 | 3995.0 |
| 2006-09-07 17:00:00 | MSFT | Stock | 25.43 | 25.44 | 25.43 | 25.44 | 3200.0 |
| 2006-09-07 17:30:00 | MSFT | Stock | 25.42 | 25.42 | 25.42 | 25.42 | 1000.0 |
> showing 50 of 48,946 rows — these rows as CSV