PREVIEW / stock_5min / 2010-11-03
file: by_date/stock_5min/2010/2010-11-03.parquet size: 4.6 MB rows: 316,970 symbols: 3,475
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 |
|---|---|---|---|---|---|---|---|
| 2010-11-03 04:30:00 | AAPL | Stock | 11.095 | 11.095 | 11.095 | 11.095 | 2800.0 |
| 2010-11-03 05:00:00 | AAPL | Stock | 11.0854 | 11.0854 | 11.08 | 11.08 | 19600.0 |
| 2010-11-03 06:25:00 | AAPL | Stock | 11.0925 | 11.0925 | 11.0925 | 11.0925 | 2800.0 |
| 2010-11-03 06:40:00 | AAPL | Stock | 11.0818 | 11.0818 | 11.0818 | 11.0818 | 2800.0 |
| 2010-11-03 06:45:00 | AAPL | Stock | 11.0918 | 11.0918 | 11.0918 | 11.0918 | 2800.0 |
| 2010-11-03 06:50:00 | AAPL | Stock | 11.0921 | 11.0921 | 11.0921 | 11.0921 | 2800.0 |
| 2010-11-03 07:00:00 | AAPL | Stock | 11.0789 | 11.0793 | 11.0786 | 11.0786 | 19600.0 |
| 2010-11-03 07:05:00 | AAPL | Stock | 11.0836 | 11.0836 | 11.0757 | 11.0757 | 11200.0 |
| 2010-11-03 07:20:00 | AAPL | Stock | 11.0779 | 11.0893 | 11.0779 | 11.0893 | 13720.0 |
| 2010-11-03 07:25:00 | AAPL | Stock | 11.0821 | 11.0832 | 11.0821 | 11.0829 | 36120.0 |
| 2010-11-03 07:30:00 | AAPL | Stock | 11.0821 | 11.0871 | 11.0821 | 11.0871 | 144032.0 |
| 2010-11-03 07:40:00 | AAPL | Stock | 11.0871 | 11.0871 | 11.0871 | 11.0871 | 2800.0 |
| 2010-11-03 07:45:00 | AAPL | Stock | 11.0796 | 11.0796 | 11.0796 | 11.0796 | 2800.0 |
| 2010-11-03 07:50:00 | AAPL | Stock | 11.0854 | 11.0857 | 11.0854 | 11.0857 | 11648.0 |
| 2010-11-03 07:55:00 | AAPL | Stock | 11.0861 | 11.0889 | 11.0861 | 11.0889 | 28000.0 |
| 2010-11-03 08:00:00 | AAPL | Stock | 11.0907 | 11.0914 | 11.0796 | 11.0821 | 334964.0 |
| 2010-11-03 08:05:00 | AAPL | Stock | 11.0786 | 11.0857 | 11.0786 | 11.0818 | 215824.0 |
| 2010-11-03 08:10:00 | AAPL | Stock | 11.0821 | 11.0893 | 11.0804 | 11.0875 | 260008.0 |
| 2010-11-03 08:15:00 | AAPL | Stock | 11.0875 | 11.0946 | 11.0786 | 11.0821 | 477288.0 |
| 2010-11-03 08:20:00 | AAPL | Stock | 11.0893 | 11.1061 | 11.0893 | 11.09 | 567840.0 |
| 2010-11-03 08:25:00 | AAPL | Stock | 11.09 | 11.0996 | 11.09 | 11.0982 | 225540.0 |
| 2010-11-03 08:30:00 | AAPL | Stock | 11.0918 | 11.1 | 11.0871 | 11.0975 | 90020.0 |
| 2010-11-03 08:35:00 | AAPL | Stock | 11.0982 | 11.1 | 11.0893 | 11.09 | 263480.0 |
| 2010-11-03 08:40:00 | AAPL | Stock | 11.09 | 11.0964 | 11.0832 | 11.0946 | 335440.0 |
| 2010-11-03 08:45:00 | AAPL | Stock | 11.0946 | 11.1125 | 11.0932 | 11.1104 | 1173620.0 |
| 2010-11-03 08:50:00 | AAPL | Stock | 11.1093 | 11.1214 | 11.1029 | 11.1196 | 778652.0 |
| 2010-11-03 08:55:00 | AAPL | Stock | 11.12 | 11.1429 | 11.1179 | 11.1375 | 1075396.0 |
| 2010-11-03 09:00:00 | AAPL | Stock | 11.1407 | 11.1429 | 11.1325 | 11.1368 | 1412320.0 |
| 2010-11-03 09:05:00 | AAPL | Stock | 11.1364 | 11.1382 | 11.1293 | 11.1311 | 485660.0 |
| 2010-11-03 09:10:00 | AAPL | Stock | 11.1304 | 11.1321 | 11.1232 | 11.125 | 528640.0 |
| 2010-11-03 09:15:00 | AAPL | Stock | 11.125 | 11.125 | 11.1157 | 11.1214 | 292460.0 |
| 2010-11-03 09:20:00 | AAPL | Stock | 11.1211 | 11.1211 | 11.1157 | 11.1179 | 245560.0 |
| 2010-11-03 09:25:00 | AAPL | Stock | 11.1175 | 11.1293 | 11.1175 | 11.1218 | 289380.0 |
| 2010-11-03 09:30:00 | AAPL | Stock | 11.1204 | 11.1321 | 11.0746 | 11.1246 | 28436128.0 |
| 2010-11-03 09:35:00 | AAPL | Stock | 11.1297 | 11.1429 | 11.1111 | 11.1282 | 16571548.0 |
| 2010-11-03 09:40:00 | AAPL | Stock | 11.1275 | 11.1343 | 11.1143 | 11.1214 | 9235128.0 |
| 2010-11-03 09:45:00 | AAPL | Stock | 11.12 | 11.1293 | 11.1107 | 11.125 | 8144360.0 |
| 2010-11-03 09:50:00 | AAPL | Stock | 11.125 | 11.1271 | 11.0989 | 11.0993 | 6338724.0 |
| 2010-11-03 09:55:00 | AAPL | Stock | 11.1018 | 11.1196 | 11.0964 | 11.1084 | 6096384.0 |
| 2010-11-03 10:00:00 | AAPL | Stock | 11.1086 | 11.1161 | 11.0993 | 11.1132 | 6981940.0 |
| 2010-11-03 10:05:00 | AAPL | Stock | 11.1111 | 11.1168 | 11.1061 | 11.1168 | 3486056.0 |
| 2010-11-03 10:10:00 | AAPL | Stock | 11.1171 | 11.1429 | 11.1139 | 11.1229 | 9373028.0 |
| 2010-11-03 10:15:00 | AAPL | Stock | 11.1243 | 11.1268 | 11.1071 | 11.1086 | 5043892.0 |
| 2010-11-03 10:20:00 | AAPL | Stock | 11.1103 | 11.1139 | 11.0979 | 11.1075 | 5219816.0 |
| 2010-11-03 10:25:00 | AAPL | Stock | 11.1074 | 11.1139 | 11.0964 | 11.1003 | 4186028.0 |
| 2010-11-03 10:30:00 | AAPL | Stock | 11.1004 | 11.1125 | 11.0982 | 11.105 | 3802904.0 |
| 2010-11-03 10:35:00 | AAPL | Stock | 11.1018 | 11.1089 | 11.0939 | 11.0973 | 4722228.0 |
| 2010-11-03 10:40:00 | AAPL | Stock | 11.0984 | 11.0989 | 11.0661 | 11.0701 | 10340232.0 |
| 2010-11-03 10:45:00 | AAPL | Stock | 11.07 | 11.0796 | 11.0646 | 11.0729 | 5887476.0 |
| 2010-11-03 10:50:00 | AAPL | Stock | 11.0721 | 11.0911 | 11.0721 | 11.0854 | 3505488.0 |
> showing 50 of 316,970 rows — these rows as CSV