PREVIEW / futures_1hour / 2009-02-18
file: by_date/futures_1hour/2009/2009-02-18.parquet size: 43 KB rows: 1,252
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 |
|---|---|---|---|---|---|---|---|
| 2009-02-18 00:00:00 | ES | Futures | 747.85 | 749.51 | 747.61 | 749.03 | 1732.0 |
| 2009-02-18 01:00:00 | ES | Futures | 749.03 | 753.06 | 749.03 | 752.11 | 6136.0 |
| 2009-02-18 02:00:00 | ES | Futures | 751.88 | 754.01 | 750.93 | 754.01 | 10624.0 |
| 2009-02-18 03:00:00 | ES | Futures | 754.01 | 754.25 | 750.45 | 751.17 | 19027.0 |
| 2009-02-18 04:00:00 | ES | Futures | 750.93 | 751.64 | 746.42 | 747.37 | 26265.0 |
| 2009-02-18 05:00:00 | ES | Futures | 747.13 | 749.27 | 744.52 | 748.32 | 19027.0 |
| 2009-02-18 06:00:00 | ES | Futures | 748.32 | 751.64 | 746.9 | 750.69 | 13631.0 |
| 2009-02-18 07:00:00 | ES | Futures | 750.69 | 750.69 | 748.08 | 748.32 | 16034.0 |
| 2009-02-18 08:00:00 | ES | Futures | 748.56 | 752.59 | 748.32 | 752.35 | 33578.0 |
| 2009-02-18 09:00:00 | ES | Futures | 752.35 | 755.44 | 744.76 | 745.24 | 321072.0 |
| 2009-02-18 10:00:00 | ES | Futures | 745.24 | 747.61 | 738.12 | 743.81 | 537967.0 |
| 2009-02-18 11:00:00 | ES | Futures | 743.58 | 752.35 | 741.68 | 749.74 | 316712.0 |
| 2009-02-18 12:00:00 | ES | Futures | 749.74 | 754.01 | 745.47 | 749.27 | 261449.0 |
| 2009-02-18 13:00:00 | ES | Futures | 749.03 | 751.4 | 742.15 | 743.81 | 255342.0 |
| 2009-02-18 14:00:00 | ES | Futures | 743.58 | 747.61 | 740.49 | 747.61 | 312301.0 |
| 2009-02-18 15:00:00 | ES | Futures | 747.61 | 749.27 | 743.58 | 745.24 | 416168.0 |
| 2009-02-18 16:00:00 | ES | Futures | 745.24 | 745.95 | 736.7 | 738.36 | 134079.0 |
| 2009-02-18 17:00:00 | ES | Futures | 738.12 | 738.6 | 736.7 | 738.36 | 3458.0 |
| 2009-02-18 18:00:00 | ES | Futures | 737.88 | 740.73 | 737.17 | 740.73 | 4627.0 |
| 2009-02-18 19:00:00 | ES | Futures | 740.73 | 741.68 | 739.78 | 740.26 | 4577.0 |
| 2009-02-18 20:00:00 | ES | Futures | 740.26 | 742.39 | 739.07 | 740.26 | 3411.0 |
| 2009-02-18 21:00:00 | ES | Futures | 740.26 | 741.44 | 739.78 | 740.97 | 2476.0 |
| 2009-02-18 22:00:00 | ES | Futures | 740.97 | 743.58 | 740.97 | 743.34 | 2896.0 |
| 2009-02-18 23:00:00 | ES | Futures | 743.1 | 743.81 | 742.63 | 743.34 | 1886.0 |
| 2009-02-18 00:00:00 | NQ | Futures | 1340.18 | 1342.16 | 1339.61 | 1341.59 | 115.0 |
| 2009-02-18 01:00:00 | NQ | Futures | 1341.59 | 1347.24 | 1341.59 | 1346.96 | 395.0 |
| 2009-02-18 02:00:00 | NQ | Futures | 1346.96 | 1349.21 | 1343.57 | 1349.21 | 451.0 |
| 2009-02-18 03:00:00 | NQ | Futures | 1349.21 | 1349.78 | 1341.31 | 1341.87 | 1968.0 |
| 2009-02-18 04:00:00 | NQ | Futures | 1341.87 | 1343.57 | 1334.25 | 1335.94 | 1866.0 |
| 2009-02-18 05:00:00 | NQ | Futures | 1335.66 | 1340.46 | 1333.12 | 1338.2 | 1217.0 |
| 2009-02-18 06:00:00 | NQ | Futures | 1339.05 | 1343.85 | 1336.79 | 1342.72 | 482.0 |
| 2009-02-18 07:00:00 | NQ | Futures | 1342.44 | 1343.28 | 1338.2 | 1339.61 | 1249.0 |
| 2009-02-18 08:00:00 | NQ | Futures | 1339.9 | 1350.63 | 1339.33 | 1349.78 | 5286.0 |
| 2009-02-18 09:00:00 | NQ | Futures | 1349.78 | 1354.86 | 1336.79 | 1337.92 | 39166.0 |
| 2009-02-18 10:00:00 | NQ | Futures | 1337.92 | 1345.54 | 1323.24 | 1340.46 | 74817.0 |
| 2009-02-18 11:00:00 | NQ | Futures | 1340.74 | 1357.69 | 1338.2 | 1352.04 | 50365.0 |
| 2009-02-18 12:00:00 | NQ | Futures | 1352.04 | 1359.95 | 1346.96 | 1351.76 | 33546.0 |
| 2009-02-18 13:00:00 | NQ | Futures | 1351.47 | 1354.86 | 1336.79 | 1339.61 | 34393.0 |
| 2009-02-18 14:00:00 | NQ | Futures | 1339.61 | 1347.8 | 1333.97 | 1347.52 | 40663.0 |
| 2009-02-18 15:00:00 | NQ | Futures | 1347.52 | 1348.93 | 1340.18 | 1341.03 | 54450.0 |
| 2009-02-18 16:00:00 | NQ | Futures | 1341.03 | 1341.87 | 1327.75 | 1328.88 | 12917.0 |
| 2009-02-18 17:00:00 | NQ | Futures | 1328.6 | 1329.73 | 1326.62 | 1329.45 | 224.0 |
| 2009-02-18 18:00:00 | NQ | Futures | 1329.45 | 1331.14 | 1325.49 | 1331.14 | 690.0 |
| 2009-02-18 19:00:00 | NQ | Futures | 1330.58 | 1332.27 | 1329.45 | 1331.42 | 331.0 |
| 2009-02-18 20:00:00 | NQ | Futures | 1331.71 | 1333.4 | 1330.01 | 1330.58 | 196.0 |
| 2009-02-18 21:00:00 | NQ | Futures | 1331.14 | 1333.4 | 1330.3 | 1333.4 | 106.0 |
| 2009-02-18 22:00:00 | NQ | Futures | 1333.12 | 1334.53 | 1332.84 | 1334.53 | 141.0 |
| 2009-02-18 23:00:00 | NQ | Futures | 1335.1 | 1335.1 | 1333.97 | 1334.81 | 85.0 |
| 2009-02-18 00:00:00 | YM | Futures | 6863.7 | 6871.9 | 6861.0 | 6864.6 | 121.0 |
| 2009-02-18 01:00:00 | YM | Futures | 6871.0 | 6899.3 | 6871.0 | 6893.8 | 621.0 |
> showing 50 of 1,252 rows — these rows as CSV