PREVIEW / futures_1hour / 2011-07-24
file: by_date/futures_1hour/2011/2011-07-24.parquet size: 14 KB rows: 269
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-24 18:00:00 | ES | Futures | 1326.84 | 1327.59 | 1318.86 | 1326.09 | 46519.0 |
| 2011-07-24 19:00:00 | ES | Futures | 1326.09 | 1327.84 | 1325.59 | 1327.34 | 6594.0 |
| 2011-07-24 20:00:00 | ES | Futures | 1327.34 | 1327.59 | 1324.59 | 1325.34 | 14078.0 |
| 2011-07-24 21:00:00 | ES | Futures | 1325.34 | 1327.09 | 1324.59 | 1325.59 | 5457.0 |
| 2011-07-24 22:00:00 | ES | Futures | 1325.59 | 1326.09 | 1323.84 | 1324.09 | 5484.0 |
| 2011-07-24 23:00:00 | ES | Futures | 1324.09 | 1324.34 | 1322.1 | 1324.34 | 5924.0 |
| 2011-07-24 18:00:00 | NQ | Futures | 2782.98 | 2782.98 | 2739.53 | 2766.0 | 7712.0 |
| 2011-07-24 19:00:00 | NQ | Futures | 2766.0 | 2768.01 | 2764.85 | 2767.73 | 522.0 |
| 2011-07-24 20:00:00 | NQ | Futures | 2767.73 | 2769.74 | 2764.27 | 2764.85 | 1081.0 |
| 2011-07-24 21:00:00 | NQ | Futures | 2764.85 | 2770.03 | 2764.85 | 2768.01 | 641.0 |
| 2011-07-24 22:00:00 | NQ | Futures | 2767.73 | 2769.17 | 2764.56 | 2764.56 | 357.0 |
| 2011-07-24 23:00:00 | NQ | Futures | 2764.27 | 2765.71 | 2761.68 | 2764.85 | 788.0 |
| 2011-07-24 18:00:00 | YM | Futures | 12139.9 | 12140.8 | 12040.1 | 12116.6 | 1979.0 |
| 2011-07-24 19:00:00 | YM | Futures | 12116.6 | 12129.2 | 12110.8 | 12124.4 | 210.0 |
| 2011-07-24 20:00:00 | YM | Futures | 12123.4 | 12124.4 | 12106.0 | 12109.8 | 673.0 |
| 2011-07-24 21:00:00 | YM | Futures | 12109.8 | 12124.4 | 12106.9 | 12112.7 | 373.0 |
| 2011-07-24 22:00:00 | YM | Futures | 12114.7 | 12119.5 | 12099.2 | 12102.1 | 338.0 |
| 2011-07-24 23:00:00 | YM | Futures | 12100.2 | 12103.1 | 12085.6 | 12103.1 | 541.0 |
| 2011-07-24 18:00:00 | CL | Futures | 170.21 | 170.4 | 168.95 | 169.34 | 3151.0 |
| 2011-07-24 19:00:00 | CL | Futures | 169.34 | 169.39 | 169.17 | 169.27 | 453.0 |
| 2011-07-24 20:00:00 | CL | Futures | 169.27 | 169.32 | 168.84 | 169.03 | 1120.0 |
| 2011-07-24 21:00:00 | CL | Futures | 169.03 | 169.13 | 168.47 | 168.64 | 1284.0 |
| 2011-07-24 22:00:00 | CL | Futures | 168.66 | 168.91 | 168.57 | 168.73 | 512.0 |
| 2011-07-24 23:00:00 | CL | Futures | 168.73 | 168.79 | 168.54 | 168.78 | 394.0 |
| 2011-07-24 18:00:00 | GC | Futures | 2242.6 | 2265.5 | 2236.9 | 2262.0 | 14583.0 |
| 2011-07-24 19:00:00 | GC | Futures | 2261.6 | 2263.0 | 2253.6 | 2253.6 | 3107.0 |
| 2011-07-24 20:00:00 | GC | Futures | 2253.6 | 2254.5 | 2248.6 | 2250.9 | 4717.0 |
| 2011-07-24 21:00:00 | GC | Futures | 2250.9 | 2251.1 | 2241.6 | 2247.8 | 4419.0 |
| 2011-07-24 22:00:00 | GC | Futures | 2247.8 | 2251.8 | 2247.1 | 2250.3 | 2155.0 |
| 2011-07-24 23:00:00 | GC | Futures | 2250.3 | 2251.5 | 2249.2 | 2251.0 | 1159.0 |
| 2011-07-24 18:00:00 | ZN | Futures | 106.871908 | 106.992986 | 106.818095 | 106.979533 | 8686.0 |
| 2011-07-24 19:00:00 | ZN | Futures | 106.96608 | 106.992986 | 106.92572 | 106.96608 | 2992.0 |
| 2011-07-24 20:00:00 | ZN | Futures | 106.96608 | 106.979533 | 106.845001 | 106.858455 | 7221.0 |
| 2011-07-24 21:00:00 | ZN | Futures | 106.858455 | 106.898814 | 106.831548 | 106.885361 | 6306.0 |
| 2011-07-24 22:00:00 | ZN | Futures | 106.885361 | 106.912267 | 106.845001 | 106.912267 | 2726.0 |
| 2011-07-24 23:00:00 | ZN | Futures | 106.912267 | 106.952627 | 106.898814 | 106.912267 | 2931.0 |
> showing 36 of 269 rows — these rows as CSV