PREVIEW / futures_30min / 2012-05-31
file: by_date/futures_30min/2012/2012-05-31.parquet size: 80 KB rows: 2,829
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 |
|---|---|---|---|---|---|---|---|
| 2012-05-31 00:00:00 | ES | Futures | 1322.35 | 1323.87 | 1322.1 | 1323.36 | 1756.0 |
| 2012-05-31 00:30:00 | ES | Futures | 1323.61 | 1324.63 | 1323.36 | 1324.63 | 1746.0 |
| 2012-05-31 01:00:00 | ES | Futures | 1324.37 | 1326.4 | 1324.37 | 1326.4 | 4164.0 |
| 2012-05-31 01:30:00 | ES | Futures | 1326.14 | 1327.66 | 1325.89 | 1326.9 | 5037.0 |
| 2012-05-31 02:00:00 | ES | Futures | 1327.16 | 1328.17 | 1326.14 | 1327.16 | 8602.0 |
| 2012-05-31 02:30:00 | ES | Futures | 1327.41 | 1328.17 | 1326.14 | 1326.65 | 6332.0 |
| 2012-05-31 03:00:00 | ES | Futures | 1326.4 | 1329.43 | 1326.14 | 1327.41 | 20839.0 |
| 2012-05-31 03:30:00 | ES | Futures | 1327.16 | 1328.67 | 1325.13 | 1327.91 | 24039.0 |
| 2012-05-31 04:00:00 | ES | Futures | 1327.91 | 1330.44 | 1327.16 | 1329.69 | 27428.0 |
| 2012-05-31 04:30:00 | ES | Futures | 1329.69 | 1331.96 | 1329.43 | 1330.44 | 19136.0 |
| 2012-05-31 05:00:00 | ES | Futures | 1330.44 | 1331.71 | 1329.94 | 1330.7 | 16173.0 |
| 2012-05-31 05:30:00 | ES | Futures | 1330.7 | 1331.46 | 1329.94 | 1330.7 | 9449.0 |
| 2012-05-31 06:00:00 | ES | Futures | 1330.44 | 1331.2 | 1329.18 | 1329.69 | 10618.0 |
| 2012-05-31 06:30:00 | ES | Futures | 1329.69 | 1330.19 | 1327.91 | 1329.94 | 16818.0 |
| 2012-05-31 07:00:00 | ES | Futures | 1329.94 | 1330.44 | 1328.42 | 1329.69 | 12031.0 |
| 2012-05-31 07:30:00 | ES | Futures | 1329.69 | 1330.44 | 1328.17 | 1329.94 | 18982.0 |
| 2012-05-31 08:00:00 | ES | Futures | 1329.69 | 1330.19 | 1325.64 | 1325.89 | 47905.0 |
| 2012-05-31 08:30:00 | ES | Futures | 1325.89 | 1327.66 | 1323.87 | 1327.41 | 75828.0 |
| 2012-05-31 09:00:00 | ES | Futures | 1327.41 | 1327.66 | 1325.64 | 1326.9 | 31605.0 |
| 2012-05-31 09:30:00 | ES | Futures | 1326.9 | 1328.42 | 1317.54 | 1319.31 | 335790.0 |
| 2012-05-31 10:00:00 | ES | Futures | 1319.31 | 1320.33 | 1315.27 | 1318.81 | 230794.0 |
| 2012-05-31 10:30:00 | ES | Futures | 1318.55 | 1320.07 | 1314.25 | 1315.77 | 200097.0 |
| 2012-05-31 11:00:00 | ES | Futures | 1315.77 | 1316.53 | 1312.74 | 1316.28 | 193502.0 |
| 2012-05-31 11:30:00 | ES | Futures | 1316.28 | 1321.08 | 1315.77 | 1318.05 | 161007.0 |
| 2012-05-31 12:00:00 | ES | Futures | 1318.05 | 1327.16 | 1317.29 | 1325.39 | 180622.0 |
| 2012-05-31 12:30:00 | ES | Futures | 1325.39 | 1326.4 | 1322.6 | 1324.37 | 102832.0 |
| 2012-05-31 13:00:00 | ES | Futures | 1324.37 | 1329.18 | 1324.12 | 1325.39 | 125118.0 |
| 2012-05-31 13:30:00 | ES | Futures | 1325.64 | 1326.9 | 1321.59 | 1322.86 | 95489.0 |
| 2012-05-31 14:00:00 | ES | Futures | 1322.6 | 1326.9 | 1322.1 | 1324.63 | 75338.0 |
| 2012-05-31 14:30:00 | ES | Futures | 1324.37 | 1327.16 | 1323.87 | 1325.89 | 73365.0 |
| 2012-05-31 15:00:00 | ES | Futures | 1326.14 | 1332.22 | 1324.12 | 1331.2 | 112260.0 |
| 2012-05-31 15:30:00 | ES | Futures | 1331.46 | 1334.75 | 1324.37 | 1325.39 | 299328.0 |
| 2012-05-31 16:00:00 | ES | Futures | 1325.39 | 1325.64 | 1321.34 | 1321.59 | 136129.0 |
| 2012-05-31 16:30:00 | ES | Futures | 1321.84 | 1322.6 | 1321.08 | 1322.35 | 10306.0 |
| 2012-05-31 17:00:00 | ES | Futures | 1322.35 | 1322.35 | 1321.08 | 1321.84 | 3111.0 |
| 2012-05-31 18:00:00 | ES | Futures | 1321.84 | 1323.11 | 1321.34 | 1321.84 | 3746.0 |
| 2012-05-31 18:30:00 | ES | Futures | 1321.84 | 1322.6 | 1321.84 | 1322.1 | 753.0 |
| 2012-05-31 19:00:00 | ES | Futures | 1322.35 | 1322.6 | 1321.84 | 1321.84 | 612.0 |
| 2012-05-31 19:30:00 | ES | Futures | 1322.1 | 1323.11 | 1321.84 | 1323.11 | 1210.0 |
| 2012-05-31 20:00:00 | ES | Futures | 1322.86 | 1323.11 | 1321.84 | 1322.35 | 2831.0 |
| 2012-05-31 20:30:00 | ES | Futures | 1322.35 | 1322.6 | 1317.04 | 1317.54 | 10112.0 |
| 2012-05-31 21:00:00 | ES | Futures | 1317.29 | 1319.06 | 1315.01 | 1318.05 | 17470.0 |
| 2012-05-31 21:30:00 | ES | Futures | 1318.3 | 1318.81 | 1316.28 | 1318.05 | 4981.0 |
| 2012-05-31 22:00:00 | ES | Futures | 1317.8 | 1319.06 | 1317.04 | 1318.3 | 3042.0 |
| 2012-05-31 22:30:00 | ES | Futures | 1318.3 | 1319.57 | 1317.8 | 1319.31 | 4484.0 |
| 2012-05-31 23:00:00 | ES | Futures | 1319.31 | 1319.57 | 1317.54 | 1318.3 | 2820.0 |
| 2012-05-31 23:30:00 | ES | Futures | 1318.05 | 1318.3 | 1316.02 | 1317.54 | 3603.0 |
| 2012-05-31 00:00:00 | NQ | Futures | 2921.5 | 2925.55 | 2921.5 | 2925.26 | 140.0 |
| 2012-05-31 00:30:00 | NQ | Futures | 2925.26 | 2929.6 | 2924.4 | 2928.44 | 276.0 |
| 2012-05-31 01:00:00 | NQ | Futures | 2928.73 | 2932.2 | 2928.73 | 2932.2 | 452.0 |
> showing 50 of 2,829 rows — these rows as CSV