PREVIEW / futures_daily / 2011-03-04
file: by_date/futures_daily/2011/2011-03-04.parquet size: 9 KB rows: 94
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-03-04 | ES | Futures | 1308.91 | 1313.58 | 1290.7 | 1299.55 | 2944659.0 |
| 2011-03-04 | NQ | Futures | 2692.09 | 2700.6 | 2661.44 | 2679.03 | 299221.0 |
| 2011-03-04 | YM | Futures | 11456.7 | 11500.7 | 11292.9 | 11375.3 | 152536.0 |
| 2011-03-04 | CL | Futures | 197.6 | 204.34 | 197.29 | 202.89 | 369148.0 |
| 2011-03-04 | GC | Futures | 1921.3 | 1946.1 | 1918.7 | 1938.8 | 141350.0 |
| 2011-03-04 | ZN | Futures | 99.269682 | 99.893611 | 98.983714 | 99.828618 | 48222.0 |
| 2011-03-04 | A6 | Futures | 0.85809 | 0.85979 | 0.85343 | 0.85809 | 103748.0 |
| 2011-03-04 | AD | Futures | 1.02024 | 1.02311 | 1.01845 | 1.02043 | 97590.0 |
| 2011-03-04 | B | Futures | 97.54 | 98.73 | 97.39 | 98.29 | 114567.0 |
| 2011-03-04 | B6 | Futures | 1.6882 | 1.694 | 1.6826 | 1.6868 | 108310.0 |
| 2011-03-04 | BFX | Futures | 3125.7 | 3138.3 | 3115.4 | 3117.9 | 30.0 |
| 2011-03-04 | BR | Futures | 0.26222 | 0.26266 | 0.26198 | 0.26253 | 43.0 |
| 2011-03-04 | BZ | Futures | 103.63 | 103.89 | 103.19 | 103.54 | 1208.0 |
| 2011-03-04 | C | Futures | 2655.0 | 2658.0 | 2566.0 | 2571.0 | 11177.0 |
| 2011-03-04 | CB | Futures | 121.002 | 123.202 | 121.002 | 121.882 | 8.0 |
| 2011-03-04 | CC | Futures | 3014.0 | 3034.0 | 2904.0 | 2939.0 | 8406.0 |
| 2011-03-04 | CSC | Futures | 4.348 | 4.348 | 4.348 | 4.348 | 5.0 |
| 2011-03-04 | CT | Futures | 185.1 | 190.2 | 184.57 | 190.2 | 7741.0 |
| 2011-03-04 | DC | Futures | 29.5 | 29.59 | 29.26 | 29.38 | 221.0 |
| 2011-03-04 | DX | Futures | 76.372 | 76.502 | 76.148 | 76.278 | 32455.0 |
| 2011-03-04 | E1 | Futures | 1.40655 | 1.42123 | 1.40471 | 1.4152 | 68984.0 |
| 2011-03-04 | E6 | Futures | 1.65141 | 1.65709 | 1.64893 | 1.65449 | 342618.0 |
| 2011-03-04 | E7 | Futures | 1.6394 | 1.6448 | 1.6368 | 1.6422 | 4220.0 |
| 2011-03-04 | EBM | Futures | 231.95 | 232.86 | 228.54 | 229.68 | 1074.0 |
| 2011-03-04 | ED | Futures | 94.8646 | 94.867 | 94.8599 | 94.8646 | 162185.0 |
| 2011-03-04 | ER | Futures | 97.178 | 97.217 | 97.178 | 97.198 | 216018.0 |
| 2011-03-04 | EW | Futures | 960.7 | 963.7 | 947.4 | 954.4 | 26320.0 |
| 2011-03-04 | FBTP | Futures | 63.26 | 63.34 | 63.13 | 63.32 | 12495.0 |
| 2011-03-04 | FCE | Futures | 2709.6 | 2719.9 | 2649.5 | 2671.8 | 181855.0 |
| 2011-03-04 | FDAX | Futures | 7781.4 | 7833.3 | 7635.2 | 7681.3 | 181454.0 |
| 2011-03-04 | FESX | Futures | 1855.1 | 1863.8 | 1815.4 | 1830.3 | 1621492.0 |
| 2011-03-04 | FEU3 | Futures | 97.751 | 97.761 | 97.751 | 97.756 | 244.0 |
| 2011-03-04 | FGBL | Futures | 97.14 | 97.67 | 97.06 | 97.53 | 1350882.0 |
| 2011-03-04 | FGBM | Futures | 102.62 | 102.87 | 102.45 | 102.78 | 930391.0 |
| 2011-03-04 | FGBS | Futures | 106.191 | 106.295 | 106.147 | 106.241 | 1176178.0 |
| 2011-03-04 | FGBX | Futures | 93.72 | 94.5 | 93.48 | 94.27 | 21182.0 |
| 2011-03-04 | FTDX | Futures | 793.4 | 800.4 | 782.4 | 786.4 | 1018.0 |
| 2011-03-04 | FTI | Futures | 298.79 | 300.2 | 295.63 | 297.86 | 79875.0 |
| 2011-03-04 | FTUK | Futures | 4175.3 | 4194.7 | 4122.8 | 4146.8 | 113156.0 |
| 2011-03-04 | FXXP | Futures | 184.0 | 184.0 | 181.8 | 182.7 | 3898.0 |
| 2011-03-04 | G | Futures | 80.34 | 81.03 | 80.34 | 80.85 | 139392.0 |
| 2011-03-04 | GF | Futures | 321.661 | 322.71 | 318.331 | 320.551 | 2285.0 |
| 2011-03-04 | GSCI | Futures | 1127.57 | 1131.42 | 1125.53 | 1130.4 | 132.0 |
| 2011-03-04 | HE | Futures | 103.264 | 103.905 | 102.388 | 103.234 | 21959.0 |
| 2011-03-04 | HG | Futures | 5.982 | 6.0659 | 5.9473 | 5.9746 | 30785.0 |
| 2011-03-04 | HO | Futures | 2.5538 | 2.5806 | 2.5503 | 2.5778 | 26649.0 |
| 2011-03-04 | HRC | Futures | 3081.2 | 3081.2 | 3081.2 | 3081.2 | 0.0 |
| 2011-03-04 | J1 | Futures | 0.0152377 | 0.0152767 | 0.0151147 | 0.0152503 | 189780.0 |
| 2011-03-04 | J7 | Futures | 0.015139 | 0.015166 | 0.015012 | 0.015142 | 238.0 |
| 2011-03-04 | JB | Futures | 120.66 | 120.71 | 120.3 | 120.47 | 3473.0 |
> showing 50 of 94 rows — these rows as CSV