PREVIEW / stock_5min / 2009-01-15
file: by_date/stock_5min/2009/2009-01-15.parquet size: 4.5 MB rows: 310,181 symbols: 3,314
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 |
|---|---|---|---|---|---|---|---|
| 2009-01-15 04:15:00 | AAPL | Stock | 2.84 | 2.84 | 2.84 | 2.84 | 8400.0 |
| 2009-01-15 04:20:00 | AAPL | Stock | 2.8507 | 2.8507 | 2.84 | 2.84 | 25200.0 |
| 2009-01-15 05:00:00 | AAPL | Stock | 2.8218 | 2.8218 | 2.8214 | 2.8214 | 8400.0 |
| 2009-01-15 05:15:00 | AAPL | Stock | 2.8175 | 2.8175 | 2.8171 | 2.8171 | 5600.0 |
| 2009-01-15 05:20:00 | AAPL | Stock | 2.8171 | 2.8171 | 2.8171 | 2.8171 | 2800.0 |
| 2009-01-15 05:25:00 | AAPL | Stock | 2.8079 | 2.8079 | 2.8075 | 2.8075 | 5600.0 |
| 2009-01-15 05:45:00 | AAPL | Stock | 2.825 | 2.825 | 2.825 | 2.825 | 14000.0 |
| 2009-01-15 06:05:00 | AAPL | Stock | 2.8125 | 2.8125 | 2.8125 | 2.8125 | 2800.0 |
| 2009-01-15 06:40:00 | AAPL | Stock | 2.8196 | 2.8214 | 2.8196 | 2.8214 | 26600.0 |
| 2009-01-15 06:45:00 | AAPL | Stock | 2.8179 | 2.8179 | 2.8021 | 2.8021 | 97804.0 |
| 2009-01-15 06:50:00 | AAPL | Stock | 2.8036 | 2.8036 | 2.8036 | 2.8036 | 67396.0 |
| 2009-01-15 06:55:00 | AAPL | Stock | 2.8036 | 2.8043 | 2.7989 | 2.8043 | 45920.0 |
| 2009-01-15 07:00:00 | AAPL | Stock | 2.7982 | 2.8214 | 2.7982 | 2.8036 | 308196.0 |
| 2009-01-15 07:05:00 | AAPL | Stock | 2.8089 | 2.8093 | 2.7868 | 2.7982 | 281792.0 |
| 2009-01-15 07:10:00 | AAPL | Stock | 2.8036 | 2.8143 | 2.8036 | 2.8125 | 248500.0 |
| 2009-01-15 07:15:00 | AAPL | Stock | 2.8136 | 2.825 | 2.8136 | 2.8164 | 350504.0 |
| 2009-01-15 07:20:00 | AAPL | Stock | 2.8189 | 2.8189 | 2.8089 | 2.8136 | 382256.0 |
| 2009-01-15 07:25:00 | AAPL | Stock | 2.8132 | 2.8143 | 2.8125 | 2.8143 | 92400.0 |
| 2009-01-15 07:30:00 | AAPL | Stock | 2.8121 | 2.8179 | 2.8121 | 2.8179 | 181412.0 |
| 2009-01-15 07:35:00 | AAPL | Stock | 2.8179 | 2.8179 | 2.8036 | 2.8143 | 385504.0 |
| 2009-01-15 07:40:00 | AAPL | Stock | 2.8125 | 2.8325 | 2.8125 | 2.8325 | 331324.0 |
| 2009-01-15 07:45:00 | AAPL | Stock | 2.8318 | 2.8536 | 2.8214 | 2.8446 | 694708.0 |
| 2009-01-15 07:50:00 | AAPL | Stock | 2.8446 | 2.8461 | 2.8257 | 2.8357 | 684656.0 |
| 2009-01-15 07:55:00 | AAPL | Stock | 2.8357 | 2.8375 | 2.8261 | 2.8321 | 570080.0 |
| 2009-01-15 08:00:00 | AAPL | Stock | 2.8321 | 2.8382 | 2.8079 | 2.8196 | 2961308.0 |
| 2009-01-15 08:05:00 | AAPL | Stock | 2.8196 | 2.8446 | 2.8161 | 2.8393 | 3252844.0 |
| 2009-01-15 08:10:00 | AAPL | Stock | 2.8361 | 2.8364 | 2.8214 | 2.8318 | 1702680.0 |
| 2009-01-15 08:15:00 | AAPL | Stock | 2.8321 | 2.8354 | 2.8218 | 2.8271 | 1455188.0 |
| 2009-01-15 08:20:00 | AAPL | Stock | 2.8271 | 2.8286 | 2.8218 | 2.8282 | 956284.0 |
| 2009-01-15 08:25:00 | AAPL | Stock | 2.8282 | 2.8393 | 2.8246 | 2.8293 | 1361360.0 |
| 2009-01-15 08:30:00 | AAPL | Stock | 2.8286 | 2.8439 | 2.8264 | 2.8432 | 2197860.0 |
| 2009-01-15 08:35:00 | AAPL | Stock | 2.8418 | 2.8643 | 2.8393 | 2.8614 | 3420508.0 |
| 2009-01-15 08:40:00 | AAPL | Stock | 2.8611 | 2.8875 | 2.8589 | 2.8832 | 6600580.0 |
| 2009-01-15 08:45:00 | AAPL | Stock | 2.8825 | 2.9089 | 2.8814 | 2.9043 | 10979668.0 |
| 2009-01-15 08:50:00 | AAPL | Stock | 2.9043 | 2.9125 | 2.8964 | 2.8989 | 7465920.0 |
| 2009-01-15 08:55:00 | AAPL | Stock | 2.8989 | 2.9239 | 2.8964 | 2.9175 | 8221920.0 |
| 2009-01-15 09:00:00 | AAPL | Stock | 2.9179 | 2.9179 | 2.8393 | 2.9039 | 8101660.0 |
| 2009-01-15 09:05:00 | AAPL | Stock | 2.9046 | 2.92 | 2.9043 | 2.9161 | 4182164.0 |
| 2009-01-15 09:10:00 | AAPL | Stock | 2.9171 | 2.9221 | 2.8832 | 2.8836 | 6183856.0 |
| 2009-01-15 09:15:00 | AAPL | Stock | 2.8836 | 2.8918 | 2.875 | 2.875 | 3815952.0 |
| 2009-01-15 09:20:00 | AAPL | Stock | 2.875 | 2.8914 | 2.8736 | 2.8868 | 4924948.0 |
| 2009-01-15 09:25:00 | AAPL | Stock | 2.8861 | 2.9143 | 2.8714 | 2.8782 | 12188484.0 |
| 2009-01-15 09:30:00 | AAPL | Stock | 2.8775 | 2.9275 | 2.8589 | 2.9064 | 114253132.0 |
| 2009-01-15 09:35:00 | AAPL | Stock | 2.9064 | 2.9246 | 2.9018 | 2.9243 | 67631900.0 |
| 2009-01-15 09:40:00 | AAPL | Stock | 2.9243 | 2.9429 | 2.9143 | 2.94 | 71396808.0 |
| 2009-01-15 09:45:00 | AAPL | Stock | 2.94 | 2.9496 | 2.9193 | 2.9246 | 59004876.0 |
| 2009-01-15 09:50:00 | AAPL | Stock | 2.9246 | 2.9246 | 2.9075 | 2.9211 | 45089884.0 |
| 2009-01-15 09:55:00 | AAPL | Stock | 2.9214 | 2.9286 | 2.8968 | 2.9057 | 45110464.0 |
| 2009-01-15 10:00:00 | AAPL | Stock | 2.905 | 2.9146 | 2.8929 | 2.8996 | 33405848.0 |
| 2009-01-15 10:05:00 | AAPL | Stock | 2.8993 | 2.9032 | 2.8843 | 2.8871 | 32858644.0 |
> showing 50 of 310,181 rows — these rows as CSV