PREVIEW / futures_1hour / 2011-07-10
file: by_date/futures_1hour/2011/2011-07-10.parquet size: 14 KB rows: 267
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-10 18:00:00 | ES | Futures | 1336.07 | 1336.31 | 1329.08 | 1330.83 | 28966.0 |
| 2011-07-10 19:00:00 | ES | Futures | 1330.83 | 1332.57 | 1329.83 | 1331.58 | 7308.0 |
| 2011-07-10 20:00:00 | ES | Futures | 1331.83 | 1333.32 | 1331.08 | 1332.07 | 10104.0 |
| 2011-07-10 21:00:00 | ES | Futures | 1332.07 | 1332.82 | 1330.58 | 1332.57 | 4563.0 |
| 2011-07-10 22:00:00 | ES | Futures | 1332.57 | 1332.57 | 1330.83 | 1332.07 | 3006.0 |
| 2011-07-10 23:00:00 | ES | Futures | 1332.07 | 1332.32 | 1331.33 | 1331.58 | 1471.0 |
| 2011-07-10 18:00:00 | NQ | Futures | 2767.44 | 2767.44 | 2751.61 | 2754.2 | 2939.0 |
| 2011-07-10 19:00:00 | NQ | Futures | 2753.91 | 2758.81 | 2753.05 | 2756.5 | 995.0 |
| 2011-07-10 20:00:00 | NQ | Futures | 2756.79 | 2760.82 | 2756.5 | 2757.65 | 576.0 |
| 2011-07-10 21:00:00 | NQ | Futures | 2757.94 | 2759.09 | 2755.35 | 2758.52 | 350.0 |
| 2011-07-10 22:00:00 | NQ | Futures | 2758.52 | 2758.52 | 2756.5 | 2757.65 | 242.0 |
| 2011-07-10 23:00:00 | NQ | Futures | 2757.94 | 2757.94 | 2756.5 | 2756.79 | 63.0 |
| 2011-07-10 18:00:00 | YM | Futures | 12199.9 | 12199.9 | 12144.7 | 12154.4 | 665.0 |
| 2011-07-10 19:00:00 | YM | Futures | 12155.3 | 12170.8 | 12146.6 | 12164.1 | 201.0 |
| 2011-07-10 20:00:00 | YM | Futures | 12164.1 | 12179.6 | 12159.2 | 12166.0 | 262.0 |
| 2011-07-10 21:00:00 | YM | Futures | 12166.0 | 12173.7 | 12154.4 | 12171.8 | 147.0 |
| 2011-07-10 22:00:00 | YM | Futures | 12170.8 | 12173.7 | 12161.2 | 12169.9 | 259.0 |
| 2011-07-10 23:00:00 | YM | Futures | 12171.8 | 12172.8 | 12165.0 | 12167.0 | 61.0 |
| 2011-07-10 18:00:00 | CL | Futures | 164.64 | 165.75 | 164.0 | 164.33 | 1444.0 |
| 2011-07-10 19:00:00 | CL | Futures | 164.34 | 164.45 | 164.21 | 164.34 | 284.0 |
| 2011-07-10 20:00:00 | CL | Futures | 164.4 | 164.62 | 164.23 | 164.34 | 503.0 |
| 2011-07-10 21:00:00 | CL | Futures | 164.4 | 164.52 | 164.19 | 164.36 | 673.0 |
| 2011-07-10 22:00:00 | CL | Futures | 164.31 | 164.45 | 164.16 | 164.26 | 2895.0 |
| 2011-07-10 23:00:00 | CL | Futures | 164.24 | 164.4 | 163.92 | 163.95 | 1196.0 |
| 2011-07-10 18:00:00 | GC | Futures | 2154.9 | 2155.3 | 2151.1 | 2152.4 | 812.0 |
| 2011-07-10 19:00:00 | GC | Futures | 2152.4 | 2153.8 | 2151.3 | 2151.7 | 476.0 |
| 2011-07-10 20:00:00 | GC | Futures | 2152.1 | 2154.1 | 2151.1 | 2153.5 | 992.0 |
| 2011-07-10 21:00:00 | GC | Futures | 2153.5 | 2154.6 | 2152.1 | 2153.9 | 1468.0 |
| 2011-07-10 22:00:00 | GC | Futures | 2153.9 | 2155.4 | 2153.1 | 2154.6 | 1097.0 |
| 2011-07-10 23:00:00 | GC | Futures | 2154.5 | 2154.6 | 2152.5 | 2152.8 | 633.0 |
| 2011-07-10 18:00:00 | ZN | Futures | 106.616298 | 106.67011 | 106.575938 | 106.643204 | 6288.0 |
| 2011-07-10 19:00:00 | ZN | Futures | 106.643204 | 106.67011 | 106.616298 | 106.643204 | 4245.0 |
| 2011-07-10 20:00:00 | ZN | Futures | 106.629751 | 106.629751 | 106.589391 | 106.616298 | 6257.0 |
| 2011-07-10 21:00:00 | ZN | Futures | 106.602845 | 106.602845 | 106.549032 | 106.575938 | 6412.0 |
| 2011-07-10 22:00:00 | ZN | Futures | 106.589391 | 106.589391 | 106.427954 | 106.522126 | 12141.0 |
| 2011-07-10 23:00:00 | ZN | Futures | 106.522126 | 106.549032 | 106.508672 | 106.535579 | 1921.0 |
> showing 36 of 267 rows — these rows as CSV