PREVIEW / futures_1hour / 2011-02-03
file: by_date/futures_1hour/2011/2011-02-03.parquet size: 49 KB rows: 1,491
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-02-03 00:00:00 | ES | Futures | 1284.89 | 1285.88 | 1284.15 | 1285.63 | 2186.0 |
| 2011-02-03 01:00:00 | ES | Futures | 1285.63 | 1285.63 | 1284.64 | 1285.14 | 2247.0 |
| 2011-02-03 02:00:00 | ES | Futures | 1285.38 | 1287.36 | 1284.89 | 1286.87 | 8248.0 |
| 2011-02-03 03:00:00 | ES | Futures | 1286.87 | 1288.35 | 1283.9 | 1285.14 | 22633.0 |
| 2011-02-03 04:00:00 | ES | Futures | 1285.38 | 1287.61 | 1284.64 | 1286.37 | 15506.0 |
| 2011-02-03 05:00:00 | ES | Futures | 1286.37 | 1287.61 | 1286.37 | 1286.87 | 6713.0 |
| 2011-02-03 06:00:00 | ES | Futures | 1286.62 | 1286.87 | 1284.64 | 1284.89 | 11758.0 |
| 2011-02-03 07:00:00 | ES | Futures | 1285.14 | 1285.63 | 1284.39 | 1284.64 | 15011.0 |
| 2011-02-03 08:00:00 | ES | Futures | 1284.64 | 1284.64 | 1282.41 | 1283.4 | 49612.0 |
| 2011-02-03 09:00:00 | ES | Futures | 1283.4 | 1287.86 | 1283.16 | 1286.37 | 217897.0 |
| 2011-02-03 10:00:00 | ES | Futures | 1286.37 | 1287.86 | 1278.21 | 1282.91 | 446438.0 |
| 2011-02-03 11:00:00 | ES | Futures | 1283.16 | 1286.87 | 1280.44 | 1286.13 | 243802.0 |
| 2011-02-03 12:00:00 | ES | Futures | 1286.13 | 1287.36 | 1284.64 | 1286.62 | 140137.0 |
| 2011-02-03 13:00:00 | ES | Futures | 1286.37 | 1286.87 | 1284.64 | 1285.88 | 110385.0 |
| 2011-02-03 14:00:00 | ES | Futures | 1285.88 | 1289.84 | 1285.14 | 1288.85 | 146933.0 |
| 2011-02-03 15:00:00 | ES | Futures | 1289.1 | 1292.31 | 1288.85 | 1290.33 | 289461.0 |
| 2011-02-03 16:00:00 | ES | Futures | 1290.33 | 1290.83 | 1289.59 | 1290.08 | 78059.0 |
| 2011-02-03 17:00:00 | ES | Futures | 1290.33 | 1290.33 | 1289.59 | 1290.08 | 1424.0 |
| 2011-02-03 18:00:00 | ES | Futures | 1290.08 | 1290.33 | 1289.1 | 1290.08 | 4361.0 |
| 2011-02-03 19:00:00 | ES | Futures | 1290.33 | 1290.58 | 1288.6 | 1290.08 | 4836.0 |
| 2011-02-03 20:00:00 | ES | Futures | 1290.08 | 1290.08 | 1288.35 | 1289.34 | 3675.0 |
| 2011-02-03 21:00:00 | ES | Futures | 1289.1 | 1289.59 | 1288.6 | 1288.6 | 2253.0 |
| 2011-02-03 22:00:00 | ES | Futures | 1288.6 | 1289.84 | 1288.6 | 1289.59 | 1420.0 |
| 2011-02-03 23:00:00 | ES | Futures | 1289.59 | 1291.07 | 1289.34 | 1290.58 | 2064.0 |
| 2011-02-03 00:00:00 | NQ | Futures | 2657.35 | 2658.78 | 2656.49 | 2658.49 | 242.0 |
| 2011-02-03 01:00:00 | NQ | Futures | 2658.78 | 2658.78 | 2657.06 | 2657.92 | 142.0 |
| 2011-02-03 02:00:00 | NQ | Futures | 2658.21 | 2663.09 | 2657.35 | 2662.8 | 373.0 |
| 2011-02-03 03:00:00 | NQ | Futures | 2662.23 | 2663.95 | 2655.05 | 2658.21 | 1315.0 |
| 2011-02-03 04:00:00 | NQ | Futures | 2658.21 | 2662.8 | 2657.35 | 2661.08 | 591.0 |
| 2011-02-03 05:00:00 | NQ | Futures | 2660.79 | 2663.37 | 2660.79 | 2661.08 | 307.0 |
| 2011-02-03 06:00:00 | NQ | Futures | 2661.08 | 2661.08 | 2657.35 | 2658.49 | 520.0 |
| 2011-02-03 07:00:00 | NQ | Futures | 2658.49 | 2659.36 | 2657.06 | 2657.06 | 396.0 |
| 2011-02-03 08:00:00 | NQ | Futures | 2657.35 | 2657.63 | 2651.89 | 2655.34 | 5209.0 |
| 2011-02-03 09:00:00 | NQ | Futures | 2655.34 | 2663.66 | 2655.05 | 2660.5 | 30855.0 |
| 2011-02-03 10:00:00 | NQ | Futures | 2660.79 | 2663.66 | 2635.82 | 2650.17 | 91015.0 |
| 2011-02-03 11:00:00 | NQ | Futures | 2650.46 | 2663.66 | 2644.43 | 2662.8 | 46184.0 |
| 2011-02-03 12:00:00 | NQ | Futures | 2662.8 | 2665.67 | 2656.77 | 2661.94 | 21508.0 |
| 2011-02-03 13:00:00 | NQ | Futures | 2661.94 | 2663.09 | 2657.06 | 2660.22 | 9476.0 |
| 2011-02-03 14:00:00 | NQ | Futures | 2659.93 | 2666.53 | 2658.49 | 2664.24 | 15447.0 |
| 2011-02-03 15:00:00 | NQ | Futures | 2663.95 | 2670.84 | 2663.66 | 2665.1 | 27145.0 |
| 2011-02-03 16:00:00 | NQ | Futures | 2665.1 | 2667.11 | 2663.95 | 2667.11 | 6144.0 |
| 2011-02-03 17:00:00 | NQ | Futures | 2666.82 | 2667.39 | 2665.96 | 2666.53 | 52.0 |
| 2011-02-03 18:00:00 | NQ | Futures | 2666.82 | 2666.82 | 2664.24 | 2666.53 | 184.0 |
| 2011-02-03 19:00:00 | NQ | Futures | 2666.53 | 2667.11 | 2663.95 | 2666.24 | 326.0 |
| 2011-02-03 20:00:00 | NQ | Futures | 2666.53 | 2666.53 | 2663.09 | 2664.81 | 249.0 |
| 2011-02-03 21:00:00 | NQ | Futures | 2664.81 | 2665.96 | 2663.66 | 2664.52 | 531.0 |
| 2011-02-03 22:00:00 | NQ | Futures | 2664.52 | 2666.53 | 2664.24 | 2666.24 | 136.0 |
| 2011-02-03 23:00:00 | NQ | Futures | 2666.53 | 2668.83 | 2666.24 | 2668.25 | 106.0 |
| 2011-02-03 00:00:00 | YM | Futures | 11468.5 | 11475.2 | 11462.7 | 11474.2 | 252.0 |
| 2011-02-03 01:00:00 | YM | Futures | 11475.2 | 11475.2 | 11466.6 | 11472.3 | 316.0 |
> showing 50 of 1,491 rows — these rows as CSV