PREVIEW / stock_5min / 2003-09-19
file: by_date/stock_5min/2003/2003-09-19.parquet size: 2.2 MB rows: 158,062 symbols: 1,610
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-09-19 08:00:00 | AAPL | Stock | 0.4086 | 0.4086 | 0.4086 | 0.4086 | 5600.0 |
| 2003-09-19 09:25:00 | AAPL | Stock | 0.4107 | 0.4114 | 0.4086 | 0.4114 | 3144400.0 |
| 2003-09-19 09:30:00 | AAPL | Stock | 0.4113 | 0.4116 | 0.402 | 0.4055 | 21541800.0 |
| 2003-09-19 09:35:00 | AAPL | Stock | 0.4063 | 0.4084 | 0.402 | 0.4059 | 14005544.0 |
| 2003-09-19 09:40:00 | AAPL | Stock | 0.4036 | 0.405 | 0.403 | 0.4043 | 2466128.0 |
| 2003-09-19 09:45:00 | AAPL | Stock | 0.4039 | 0.4044 | 0.4023 | 0.4025 | 5370120.0 |
| 2003-09-19 09:50:00 | AAPL | Stock | 0.4027 | 0.4034 | 0.4025 | 0.403 | 1664320.0 |
| 2003-09-19 09:55:00 | AAPL | Stock | 0.4029 | 0.4032 | 0.4021 | 0.4029 | 2154376.0 |
| 2003-09-19 10:00:00 | AAPL | Stock | 0.4027 | 0.4054 | 0.4027 | 0.4045 | 2968616.0 |
| 2003-09-19 10:05:00 | AAPL | Stock | 0.4046 | 0.405 | 0.4036 | 0.405 | 1563184.0 |
| 2003-09-19 10:10:00 | AAPL | Stock | 0.4052 | 0.4059 | 0.4046 | 0.4059 | 2028936.0 |
| 2003-09-19 10:15:00 | AAPL | Stock | 0.4059 | 0.4061 | 0.4057 | 0.4061 | 1131200.0 |
| 2003-09-19 10:20:00 | AAPL | Stock | 0.4061 | 0.407 | 0.4055 | 0.4068 | 2494744.0 |
| 2003-09-19 10:25:00 | AAPL | Stock | 0.4068 | 0.407 | 0.4054 | 0.4057 | 2585968.0 |
| 2003-09-19 10:30:00 | AAPL | Stock | 0.4055 | 0.4057 | 0.4041 | 0.4045 | 1715672.0 |
| 2003-09-19 10:35:00 | AAPL | Stock | 0.4045 | 0.4046 | 0.4036 | 0.4036 | 1696800.0 |
| 2003-09-19 10:40:00 | AAPL | Stock | 0.4036 | 0.4038 | 0.402 | 0.402 | 2168600.0 |
| 2003-09-19 10:45:00 | AAPL | Stock | 0.4023 | 0.4025 | 0.4014 | 0.402 | 1739696.0 |
| 2003-09-19 10:50:00 | AAPL | Stock | 0.402 | 0.4027 | 0.4011 | 0.4013 | 1697024.0 |
| 2003-09-19 10:55:00 | AAPL | Stock | 0.4014 | 0.4018 | 0.4013 | 0.4014 | 1052296.0 |
| 2003-09-19 11:00:00 | AAPL | Stock | 0.4014 | 0.4023 | 0.4005 | 0.402 | 1833384.0 |
| 2003-09-19 11:05:00 | AAPL | Stock | 0.402 | 0.4041 | 0.402 | 0.4041 | 2156000.0 |
| 2003-09-19 11:10:00 | AAPL | Stock | 0.4041 | 0.405 | 0.4039 | 0.405 | 2564800.0 |
| 2003-09-19 11:15:00 | AAPL | Stock | 0.4048 | 0.405 | 0.4039 | 0.4045 | 2209088.0 |
| 2003-09-19 11:20:00 | AAPL | Stock | 0.4043 | 0.4043 | 0.4034 | 0.4034 | 851200.0 |
| 2003-09-19 11:25:00 | AAPL | Stock | 0.4034 | 0.4036 | 0.4032 | 0.4034 | 588000.0 |
| 2003-09-19 11:30:00 | AAPL | Stock | 0.4032 | 0.4045 | 0.4032 | 0.4045 | 1925784.0 |
| 2003-09-19 11:35:00 | AAPL | Stock | 0.4045 | 0.4045 | 0.404 | 0.4045 | 928872.0 |
| 2003-09-19 11:40:00 | AAPL | Stock | 0.4045 | 0.4045 | 0.4041 | 0.4043 | 364000.0 |
| 2003-09-19 11:45:00 | AAPL | Stock | 0.4043 | 0.4045 | 0.4039 | 0.4045 | 850640.0 |
| 2003-09-19 11:50:00 | AAPL | Stock | 0.4043 | 0.4045 | 0.4043 | 0.4043 | 1652000.0 |
| 2003-09-19 11:55:00 | AAPL | Stock | 0.4043 | 0.4045 | 0.4041 | 0.4043 | 890400.0 |
| 2003-09-19 12:00:00 | AAPL | Stock | 0.4043 | 0.4045 | 0.4041 | 0.4043 | 450128.0 |
| 2003-09-19 12:05:00 | AAPL | Stock | 0.4045 | 0.4045 | 0.4043 | 0.4045 | 532000.0 |
| 2003-09-19 12:10:00 | AAPL | Stock | 0.4045 | 0.4045 | 0.4043 | 0.4043 | 672224.0 |
| 2003-09-19 12:15:00 | AAPL | Stock | 0.4045 | 0.4048 | 0.4045 | 0.4046 | 520800.0 |
| 2003-09-19 12:20:00 | AAPL | Stock | 0.4046 | 0.4048 | 0.4043 | 0.4046 | 319312.0 |
| 2003-09-19 12:25:00 | AAPL | Stock | 0.4046 | 0.4048 | 0.4046 | 0.4046 | 733544.0 |
| 2003-09-19 12:30:00 | AAPL | Stock | 0.4046 | 0.4048 | 0.4041 | 0.4045 | 464800.0 |
| 2003-09-19 12:35:00 | AAPL | Stock | 0.4045 | 0.4059 | 0.4045 | 0.4057 | 1585920.0 |
| 2003-09-19 12:40:00 | AAPL | Stock | 0.4057 | 0.4057 | 0.4055 | 0.4055 | 330400.0 |
| 2003-09-19 12:45:00 | AAPL | Stock | 0.4059 | 0.4059 | 0.4055 | 0.4055 | 838264.0 |
| 2003-09-19 12:50:00 | AAPL | Stock | 0.4055 | 0.4059 | 0.4055 | 0.4059 | 324688.0 |
| 2003-09-19 12:55:00 | AAPL | Stock | 0.4059 | 0.4063 | 0.4055 | 0.4055 | 1965600.0 |
| 2003-09-19 13:00:00 | AAPL | Stock | 0.4057 | 0.4057 | 0.4052 | 0.4054 | 448000.0 |
| 2003-09-19 13:05:00 | AAPL | Stock | 0.4054 | 0.4054 | 0.4046 | 0.4048 | 537600.0 |
| 2003-09-19 13:10:00 | AAPL | Stock | 0.4046 | 0.4048 | 0.4046 | 0.4048 | 252000.0 |
| 2003-09-19 13:15:00 | AAPL | Stock | 0.4048 | 0.4048 | 0.4048 | 0.4048 | 274400.0 |
| 2003-09-19 13:20:00 | AAPL | Stock | 0.4048 | 0.4052 | 0.4046 | 0.4052 | 414904.0 |
| 2003-09-19 13:25:00 | AAPL | Stock | 0.4052 | 0.4052 | 0.4048 | 0.405 | 329392.0 |
> showing 50 of 158,062 rows — these rows as CSV