PREVIEW / futures_daily / 2011-08-17
file: by_date/futures_daily/2011/2011-08-17.parquet size: 9 KB rows: 97
schema
date DATE symbol VARCHAR asset_type VARCHAR open DOUBLE high DOUBLE low DOUBLE close DOUBLE volume DOUBLE
sample rows
| date | symbol | asset_type | open | high | low | close | volume |
|---|---|---|---|---|---|---|---|
| 2011-08-17 | ES | Futures | 1183.57 | 1198.46 | 1173.39 | 1181.83 | 2112805.0 |
| 2011-08-17 | NQ | Futures | 2502.99 | 2521.21 | 2456.59 | 2477.08 | 273534.0 |
| 2011-08-17 | YM | Futures | 10763.4 | 10879.7 | 10683.1 | 10759.7 | 117318.0 |
| 2011-08-17 | CL | Futures | 166.62 | 169.89 | 165.44 | 167.11 | 153155.0 |
| 2011-08-17 | GC | Futures | 2414.8 | 2427.0 | 2405.4 | 2421.9 | 137235.0 |
| 2011-08-17 | ZN | Futures | 110.72398 | 111.056605 | 110.511101 | 111.003385 | 986570.0 |
| 2011-08-17 | A6 | Futures | 0.90691 | 0.91831 | 0.90369 | 0.91483 | 98214.0 |
| 2011-08-17 | AD | Futures | 1.01513 | 1.02041 | 1.01283 | 1.01712 | 64206.0 |
| 2011-08-17 | B | Futures | 93.73 | 95.58 | 93.32 | 94.61 | 171442.0 |
| 2011-08-17 | B6 | Futures | 1.7108 | 1.7258 | 1.6997 | 1.7229 | 113022.0 |
| 2011-08-17 | BFX | Futures | 2669.9 | 2728.4 | 2669.9 | 2720.4 | 666.0 |
| 2011-08-17 | BR | Futures | 0.28027 | 0.28027 | 0.27994 | 0.27994 | 553.0 |
| 2011-08-17 | BZ | Futures | 97.83 | 98.62 | 97.7 | 97.71 | 572.0 |
| 2011-08-17 | C | Futures | 2035.0 | 2058.0 | 2026.0 | 2051.0 | 2923.0 |
| 2011-08-17 | CC | Futures | 2352.0 | 2397.0 | 2333.0 | 2383.0 | 16643.0 |
| 2011-08-17 | CSC | Futures | 4.742 | 4.742 | 4.605 | 4.605 | 18.0 |
| 2011-08-17 | CT | Futures | 134.82 | 140.96 | 134.82 | 140.71 | 39.0 |
| 2011-08-17 | DC | Futures | 32.48 | 32.48 | 31.38 | 31.38 | 793.0 |
| 2011-08-17 | DX | Futures | 73.43 | 73.593 | 72.806 | 73.046 | 21303.0 |
| 2011-08-17 | E1 | Futures | 1.64279 | 1.67379 | 1.63325 | 1.66006 | 50994.0 |
| 2011-08-17 | E6 | Futures | 1.70955 | 1.72357 | 1.70065 | 1.71573 | 320199.0 |
| 2011-08-17 | E7 | Futures | 1.6974 | 1.7109 | 1.6883 | 1.7032 | 4582.0 |
| 2011-08-17 | ED | Futures | 94.9382 | 94.9406 | 94.9168 | 94.9287 | 165529.0 |
| 2011-08-17 | ER | Futures | 97.534 | 97.573 | 97.534 | 97.554 | 96571.0 |
| 2011-08-17 | EW | Futures | 847.7 | 855.9 | 833.7 | 841.0 | 25922.0 |
| 2011-08-17 | FBTP | Futures | 64.44 | 64.8 | 64.23 | 64.7 | 7434.0 |
| 2011-08-17 | FCE | Futures | 2260.8 | 2305.7 | 2230.6 | 2280.4 | 136460.0 |
| 2011-08-17 | FDAX | Futures | 6372.6 | 6435.6 | 6277.5 | 6364.0 | 156095.0 |
| 2011-08-17 | FESX | Futures | 1481.0 | 1510.5 | 1461.8 | 1494.5 | 1334082.0 |
| 2011-08-17 | FEU3 | Futures | 98.089 | 98.099 | 98.089 | 98.094 | 17.0 |
| 2011-08-17 | FGBL | Futures | 107.12 | 107.79 | 106.98 | 107.43 | 692661.0 |
| 2011-08-17 | FGBM | Futures | 109.45 | 109.74 | 109.27 | 109.53 | 464573.0 |
| 2011-08-17 | FGBS | Futures | 108.825 | 108.88 | 108.721 | 108.79 | 506787.0 |
| 2011-08-17 | FGBX | Futures | 103.95 | 105.06 | 103.62 | 104.39 | 6190.0 |
| 2011-08-17 | FTDX | Futures | 654.2 | 654.2 | 635.4 | 643.0 | 311.0 |
| 2011-08-17 | FTI | Futures | 237.36 | 240.54 | 234.21 | 238.74 | 40983.0 |
| 2011-08-17 | FTUK | Futures | 3745.9 | 3786.9 | 3720.5 | 3760.0 | 96725.0 |
| 2011-08-17 | FVSA | Futures | 13117.51 | 13117.51 | 12360.73 | 12438.35 | 4293.0 |
| 2011-08-17 | FXXP | Futures | 159.1 | 162.0 | 159.1 | 161.1 | 2182.0 |
| 2011-08-17 | G | Futures | 89.55 | 90.33 | 89.55 | 90.13 | 99962.0 |
| 2011-08-17 | GF | Futures | 314.312 | 314.312 | 309.389 | 310.076 | 1754.0 |
| 2011-08-17 | GSCI | Futures | 1035.03 | 1037.62 | 1026.73 | 1026.73 | 133.0 |
| 2011-08-17 | HE | Futures | 108.916 | 108.947 | 106.626 | 106.748 | 17662.0 |
| 2011-08-17 | HG | Futures | 5.2924 | 5.3916 | 5.2468 | 5.3301 | 33582.0 |
| 2011-08-17 | HO | Futures | 2.3849 | 2.4288 | 2.3762 | 2.3977 | 47893.0 |
| 2011-08-17 | HRC | Futures | 2846.9 | 2868.4 | 2846.9 | 2868.4 | 20.0 |
| 2011-08-17 | J1 | Futures | 0.0163663 | 0.0164555 | 0.0163663 | 0.0164392 | 60121.0 |
| 2011-08-17 | J7 | Futures | 0.016261 | 0.016343 | 0.016261 | 0.016329 | 261.0 |
| 2011-08-17 | JB | Futures | 123.94 | 124.1 | 123.85 | 123.95 | 714.0 |
| 2011-08-17 | KC | Futures | 594.16 | 623.61 | 592.98 | 622.67 | 5601.0 |
> showing 50 of 97 rows — these rows as CSV