PREVIEW / futures_30min / 2011-07-11
file: by_date/futures_30min/2011/2011-07-11.parquet size: 80 KB rows: 2,711
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 |
|---|---|---|---|---|---|---|---|
| 2011-07-11 00:00:00 | ES | Futures | 1331.33 | 1332.32 | 1331.33 | 1331.58 | 708.0 |
| 2011-07-11 00:30:00 | ES | Futures | 1331.58 | 1331.58 | 1330.33 | 1331.08 | 1480.0 |
| 2011-07-11 01:00:00 | ES | Futures | 1331.33 | 1331.58 | 1330.08 | 1330.83 | 1496.0 |
| 2011-07-11 01:30:00 | ES | Futures | 1331.08 | 1331.08 | 1329.58 | 1330.08 | 3556.0 |
| 2011-07-11 02:00:00 | ES | Futures | 1330.08 | 1330.83 | 1329.08 | 1330.58 | 4610.0 |
| 2011-07-11 02:30:00 | ES | Futures | 1330.83 | 1330.83 | 1327.34 | 1327.34 | 12574.0 |
| 2011-07-11 03:00:00 | ES | Futures | 1327.34 | 1329.83 | 1326.84 | 1328.33 | 24244.0 |
| 2011-07-11 03:30:00 | ES | Futures | 1328.33 | 1329.58 | 1327.09 | 1328.08 | 14522.0 |
| 2011-07-11 04:00:00 | ES | Futures | 1328.08 | 1329.33 | 1326.09 | 1326.34 | 12909.0 |
| 2011-07-11 04:30:00 | ES | Futures | 1326.34 | 1328.33 | 1326.09 | 1326.84 | 12525.0 |
| 2011-07-11 05:00:00 | ES | Futures | 1326.59 | 1327.34 | 1324.84 | 1325.59 | 18934.0 |
| 2011-07-11 05:30:00 | ES | Futures | 1325.59 | 1326.59 | 1325.59 | 1326.09 | 7603.0 |
| 2011-07-11 06:00:00 | ES | Futures | 1326.09 | 1327.59 | 1325.34 | 1327.09 | 9905.0 |
| 2011-07-11 06:30:00 | ES | Futures | 1327.09 | 1327.34 | 1324.84 | 1325.09 | 11415.0 |
| 2011-07-11 07:00:00 | ES | Futures | 1325.09 | 1325.34 | 1323.1 | 1324.59 | 29639.0 |
| 2011-07-11 07:30:00 | ES | Futures | 1324.59 | 1325.34 | 1320.35 | 1321.35 | 37170.0 |
| 2011-07-11 08:00:00 | ES | Futures | 1321.35 | 1321.6 | 1318.86 | 1319.11 | 55774.0 |
| 2011-07-11 08:30:00 | ES | Futures | 1319.36 | 1322.35 | 1319.11 | 1321.1 | 41270.0 |
| 2011-07-11 09:00:00 | ES | Futures | 1321.1 | 1321.85 | 1318.61 | 1319.85 | 54153.0 |
| 2011-07-11 09:30:00 | ES | Futures | 1319.85 | 1323.84 | 1319.11 | 1321.6 | 230015.0 |
| 2011-07-11 10:00:00 | ES | Futures | 1321.35 | 1322.1 | 1315.36 | 1316.36 | 243655.0 |
| 2011-07-11 10:30:00 | ES | Futures | 1316.61 | 1317.11 | 1312.12 | 1312.37 | 271102.0 |
| 2011-07-11 11:00:00 | ES | Futures | 1312.12 | 1316.36 | 1311.12 | 1316.36 | 227480.0 |
| 2011-07-11 11:30:00 | ES | Futures | 1316.11 | 1317.11 | 1314.62 | 1314.87 | 131573.0 |
| 2011-07-11 12:00:00 | ES | Futures | 1315.12 | 1316.61 | 1314.12 | 1315.86 | 59647.0 |
| 2011-07-11 12:30:00 | ES | Futures | 1316.11 | 1316.36 | 1313.12 | 1313.62 | 68520.0 |
| 2011-07-11 13:00:00 | ES | Futures | 1313.62 | 1314.37 | 1310.38 | 1311.87 | 80438.0 |
| 2011-07-11 13:30:00 | ES | Futures | 1311.87 | 1314.12 | 1311.12 | 1314.12 | 54752.0 |
| 2011-07-11 14:00:00 | ES | Futures | 1313.87 | 1314.37 | 1310.88 | 1311.37 | 57185.0 |
| 2011-07-11 14:30:00 | ES | Futures | 1311.62 | 1312.37 | 1309.63 | 1310.88 | 84492.0 |
| 2011-07-11 15:00:00 | ES | Futures | 1311.12 | 1312.12 | 1308.88 | 1311.62 | 108063.0 |
| 2011-07-11 15:30:00 | ES | Futures | 1311.87 | 1312.87 | 1308.63 | 1311.87 | 264974.0 |
| 2011-07-11 16:00:00 | ES | Futures | 1312.12 | 1316.11 | 1311.87 | 1315.36 | 133592.0 |
| 2011-07-11 16:30:00 | ES | Futures | 1314.87 | 1315.12 | 1313.87 | 1314.87 | 8452.0 |
| 2011-07-11 17:00:00 | ES | Futures | 1315.12 | 1315.12 | 1312.87 | 1313.12 | 5182.0 |
| 2011-07-11 18:00:00 | ES | Futures | 1313.12 | 1315.36 | 1313.12 | 1314.62 | 4408.0 |
| 2011-07-11 18:30:00 | ES | Futures | 1314.87 | 1314.87 | 1313.62 | 1313.62 | 1730.0 |
| 2011-07-11 19:00:00 | ES | Futures | 1313.62 | 1314.37 | 1312.87 | 1313.62 | 2739.0 |
| 2011-07-11 19:30:00 | ES | Futures | 1313.87 | 1314.62 | 1313.12 | 1314.12 | 2093.0 |
| 2011-07-11 20:00:00 | ES | Futures | 1314.12 | 1315.12 | 1312.62 | 1313.37 | 3966.0 |
| 2011-07-11 20:30:00 | ES | Futures | 1313.12 | 1313.62 | 1312.12 | 1312.37 | 3512.0 |
| 2011-07-11 21:00:00 | ES | Futures | 1312.37 | 1313.87 | 1307.38 | 1308.38 | 11069.0 |
| 2011-07-11 21:30:00 | ES | Futures | 1308.38 | 1309.13 | 1304.39 | 1307.38 | 15210.0 |
| 2011-07-11 22:00:00 | ES | Futures | 1307.38 | 1307.63 | 1303.64 | 1304.64 | 12198.0 |
| 2011-07-11 22:30:00 | ES | Futures | 1304.89 | 1305.64 | 1304.39 | 1304.89 | 3817.0 |
| 2011-07-11 23:00:00 | ES | Futures | 1304.89 | 1306.14 | 1303.89 | 1305.64 | 6135.0 |
| 2011-07-11 23:30:00 | ES | Futures | 1305.64 | 1306.39 | 1304.89 | 1305.89 | 2135.0 |
| 2011-07-11 00:00:00 | NQ | Futures | 2756.79 | 2757.65 | 2756.79 | 2756.79 | 23.0 |
| 2011-07-11 00:30:00 | NQ | Futures | 2756.79 | 2756.79 | 2754.78 | 2756.22 | 129.0 |
| 2011-07-11 01:00:00 | NQ | Futures | 2755.93 | 2756.22 | 2754.78 | 2755.06 | 191.0 |
> showing 50 of 2,711 rows — these rows as CSV