PREVIEW / futures_30min / 2008-04-09
file: by_date/futures_30min/2008/2008-04-09.parquet size: 69 KB rows: 2,274
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 |
|---|---|---|---|---|---|---|---|
| 2008-04-09 00:00:00 | ES | Futures | 1274.35 | 1275.05 | 1273.66 | 1273.89 | 1164.0 |
| 2008-04-09 00:30:00 | ES | Futures | 1273.89 | 1274.82 | 1273.42 | 1274.12 | 691.0 |
| 2008-04-09 01:00:00 | ES | Futures | 1274.12 | 1274.82 | 1272.49 | 1273.42 | 1307.0 |
| 2008-04-09 01:30:00 | ES | Futures | 1273.42 | 1274.12 | 1272.49 | 1273.89 | 1789.0 |
| 2008-04-09 02:00:00 | ES | Futures | 1273.89 | 1273.89 | 1272.03 | 1272.26 | 2558.0 |
| 2008-04-09 02:30:00 | ES | Futures | 1272.26 | 1272.49 | 1271.33 | 1271.79 | 3164.0 |
| 2008-04-09 03:00:00 | ES | Futures | 1271.56 | 1272.03 | 1269.7 | 1270.16 | 5250.0 |
| 2008-04-09 03:30:00 | ES | Futures | 1270.4 | 1271.56 | 1269.7 | 1271.33 | 5065.0 |
| 2008-04-09 04:00:00 | ES | Futures | 1271.33 | 1272.03 | 1269.46 | 1269.93 | 5102.0 |
| 2008-04-09 04:30:00 | ES | Futures | 1269.93 | 1271.79 | 1269.46 | 1270.63 | 3180.0 |
| 2008-04-09 05:00:00 | ES | Futures | 1270.4 | 1271.79 | 1270.16 | 1270.63 | 2627.0 |
| 2008-04-09 05:30:00 | ES | Futures | 1270.4 | 1270.86 | 1270.16 | 1270.63 | 2860.0 |
| 2008-04-09 06:00:00 | ES | Futures | 1270.4 | 1273.66 | 1269.46 | 1272.49 | 6301.0 |
| 2008-04-09 06:30:00 | ES | Futures | 1272.96 | 1275.75 | 1272.49 | 1274.82 | 8131.0 |
| 2008-04-09 07:00:00 | ES | Futures | 1274.82 | 1278.31 | 1274.82 | 1276.68 | 14802.0 |
| 2008-04-09 07:30:00 | ES | Futures | 1276.91 | 1276.91 | 1273.19 | 1275.05 | 14001.0 |
| 2008-04-09 08:00:00 | ES | Futures | 1275.28 | 1276.45 | 1273.19 | 1274.35 | 17315.0 |
| 2008-04-09 08:30:00 | ES | Futures | 1274.12 | 1275.75 | 1273.19 | 1274.59 | 11101.0 |
| 2008-04-09 09:00:00 | ES | Futures | 1274.35 | 1275.05 | 1273.19 | 1274.82 | 13110.0 |
| 2008-04-09 09:30:00 | ES | Futures | 1275.05 | 1276.68 | 1269.7 | 1270.86 | 171342.0 |
| 2008-04-09 10:00:00 | ES | Futures | 1270.86 | 1271.79 | 1268.07 | 1270.16 | 143019.0 |
| 2008-04-09 10:30:00 | ES | Futures | 1270.16 | 1271.09 | 1267.37 | 1270.63 | 144849.0 |
| 2008-04-09 11:00:00 | ES | Futures | 1270.63 | 1272.03 | 1265.51 | 1266.44 | 120829.0 |
| 2008-04-09 11:30:00 | ES | Futures | 1266.67 | 1267.14 | 1262.01 | 1262.48 | 173798.0 |
| 2008-04-09 12:00:00 | ES | Futures | 1262.48 | 1264.57 | 1261.55 | 1264.34 | 88253.0 |
| 2008-04-09 12:30:00 | ES | Futures | 1264.34 | 1265.27 | 1260.85 | 1261.31 | 75309.0 |
| 2008-04-09 13:00:00 | ES | Futures | 1261.08 | 1264.11 | 1259.68 | 1262.94 | 107964.0 |
| 2008-04-09 13:30:00 | ES | Futures | 1263.18 | 1265.27 | 1262.25 | 1265.04 | 66588.0 |
| 2008-04-09 14:00:00 | ES | Futures | 1265.27 | 1266.2 | 1260.62 | 1261.78 | 107243.0 |
| 2008-04-09 14:30:00 | ES | Futures | 1262.01 | 1262.94 | 1259.45 | 1260.15 | 114364.0 |
| 2008-04-09 15:00:00 | ES | Futures | 1260.15 | 1262.71 | 1258.52 | 1261.31 | 122321.0 |
| 2008-04-09 15:30:00 | ES | Futures | 1261.08 | 1265.27 | 1260.85 | 1263.41 | 167179.0 |
| 2008-04-09 16:00:00 | ES | Futures | 1263.64 | 1267.37 | 1263.41 | 1266.9 | 64941.0 |
| 2008-04-09 16:30:00 | ES | Futures | 1265.97 | 1267.14 | 1265.74 | 1266.2 | 5549.0 |
| 2008-04-09 17:00:00 | ES | Futures | 1266.2 | 1267.14 | 1265.97 | 1266.9 | 1506.0 |
| 2008-04-09 18:00:00 | ES | Futures | 1266.67 | 1267.37 | 1265.74 | 1266.44 | 1121.0 |
| 2008-04-09 18:30:00 | ES | Futures | 1266.44 | 1266.44 | 1265.51 | 1265.97 | 582.0 |
| 2008-04-09 19:00:00 | ES | Futures | 1265.97 | 1266.67 | 1265.27 | 1265.27 | 699.0 |
| 2008-04-09 19:30:00 | ES | Futures | 1265.27 | 1266.9 | 1265.04 | 1266.44 | 830.0 |
| 2008-04-09 20:00:00 | ES | Futures | 1266.2 | 1266.44 | 1265.51 | 1265.74 | 994.0 |
| 2008-04-09 20:30:00 | ES | Futures | 1265.74 | 1266.67 | 1265.27 | 1265.51 | 1118.0 |
| 2008-04-09 21:00:00 | ES | Futures | 1265.51 | 1266.2 | 1265.51 | 1265.97 | 655.0 |
| 2008-04-09 21:30:00 | ES | Futures | 1265.97 | 1268.53 | 1265.74 | 1267.83 | 3723.0 |
| 2008-04-09 22:00:00 | ES | Futures | 1267.83 | 1267.83 | 1265.97 | 1266.67 | 1027.0 |
| 2008-04-09 22:30:00 | ES | Futures | 1266.9 | 1267.6 | 1266.9 | 1267.37 | 429.0 |
| 2008-04-09 23:00:00 | ES | Futures | 1267.37 | 1267.6 | 1266.67 | 1266.67 | 376.0 |
| 2008-04-09 23:30:00 | ES | Futures | 1266.44 | 1266.9 | 1265.51 | 1265.51 | 563.0 |
| 2008-04-09 00:00:00 | NQ | Futures | 2097.74 | 2097.74 | 2094.91 | 2094.91 | 26.0 |
| 2008-04-09 00:30:00 | NQ | Futures | 2094.91 | 2097.74 | 2094.91 | 2095.19 | 26.0 |
| 2008-04-09 01:00:00 | NQ | Futures | 2095.48 | 2096.61 | 2094.35 | 2094.35 | 63.0 |
> showing 50 of 2,274 rows — these rows as CSV