PREVIEW / futures_daily / 2012-10-30
file: by_date/futures_daily/2012/2012-10-30.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 |
|---|---|---|---|---|---|---|---|
| 2012-10-30 | ES | Futures | 1424.13 | 1437.37 | 1417.77 | 1432.53 | 178848.0 |
| 2012-10-30 | NQ | Futures | 3034.45 | 3059.48 | 3021.51 | 3059.48 | 18475.0 |
| 2012-10-30 | YM | Futures | 12668.0 | 12758.8 | 12622.1 | 12747.1 | 16858.0 |
| 2012-10-30 | CL | Futures | 153.75 | 155.43 | 153.37 | 154.42 | 106222.0 |
| 2012-10-30 | GC | Futures | 2283.5 | 2290.7 | 2276.7 | 2285.9 | 57253.0 |
| 2012-10-30 | ZN | Futures | 116.75262 | 116.944896 | 116.532876 | 116.61528 | 291929.0 |
| 2012-10-30 | A6 | Futures | 0.93535 | 0.94007 | 0.9348 | 0.9388 | 44062.0 |
| 2012-10-30 | AD | Futures | 1.00148 | 1.00429 | 1.00067 | 1.00338 | 29320.0 |
| 2012-10-30 | B | Futures | 99.67 | 100.5 | 99.26 | 99.64 | 106187.0 |
| 2012-10-30 | B6 | Futures | 1.6739 | 1.6798 | 1.673 | 1.6789 | 41223.0 |
| 2012-10-30 | BFX | Futures | 2849.8 | 2856.4 | 2849.8 | 2854.0 | 93.0 |
| 2012-10-30 | BR | Futures | 0.23794 | 0.23799 | 0.23777 | 0.23799 | 2871.0 |
| 2012-10-30 | BZ | Futures | 102.63 | 103.58 | 102.36 | 102.74 | 672.0 |
| 2012-10-30 | C | Futures | 1559.0 | 1610.0 | 1553.0 | 1565.0 | 6862.0 |
| 2012-10-30 | CB | Futures | 92.327 | 92.327 | 91.926 | 91.926 | 56.0 |
| 2012-10-30 | CC | Futures | 1776.0 | 1853.0 | 1774.0 | 1802.0 | 16962.0 |
| 2012-10-30 | CT | Futures | 93.88 | 94.37 | 91.3 | 91.52 | 19503.0 |
| 2012-10-30 | DC | Futures | 30.48 | 30.71 | 30.3 | 30.65 | 294.0 |
| 2012-10-30 | DX | Futures | 77.799 | 77.852 | 77.392 | 77.476 | 14486.0 |
| 2012-10-30 | E1 | Futures | 1.37583 | 1.38509 | 1.37402 | 1.38175 | 16795.0 |
| 2012-10-30 | E6 | Futures | 1.52026 | 1.52968 | 1.51814 | 1.5272 | 120267.0 |
| 2012-10-30 | E7 | Futures | 1.5112 | 1.5206 | 1.5089 | 1.5181 | 2996.0 |
| 2012-10-30 | ED | Futures | 95.2253 | 95.2253 | 95.2157 | 95.2253 | 55944.0 |
| 2012-10-30 | ER | Futures | 97.871 | 97.876 | 97.862 | 97.871 | 80981.0 |
| 2012-10-30 | EW | Futures | 981.8 | 992.0 | 978.5 | 992.0 | 559.0 |
| 2012-10-30 | FBTP | Futures | 72.08 | 72.27 | 71.95 | 72.1 | 30943.0 |
| 2012-10-30 | FBTS | Futures | 89.466 | 89.659 | 89.416 | 89.541 | 3354.0 |
| 2012-10-30 | FCE | Futures | 2556.1 | 2602.7 | 2555.4 | 2598.6 | 54374.0 |
| 2012-10-30 | FDAX | Futures | 7885.8 | 7992.0 | 7885.8 | 7971.8 | 61806.0 |
| 2012-10-30 | FESX | Futures | 1682.4 | 1713.7 | 1681.7 | 1707.6 | 495292.0 |
| 2012-10-30 | FGBL | Futures | 118.53 | 118.68 | 118.13 | 118.29 | 471887.0 |
| 2012-10-30 | FGBM | Futures | 116.46 | 116.51 | 116.28 | 116.36 | 290429.0 |
| 2012-10-30 | FGBS | Futures | 110.377 | 110.392 | 110.338 | 110.358 | 260583.0 |
| 2012-10-30 | FGBX | Futures | 125.19 | 125.53 | 124.3 | 124.75 | 6682.0 |
| 2012-10-30 | FOAT | Futures | 103.75 | 103.84 | 103.61 | 103.64 | 17953.0 |
| 2012-10-30 | FTDX | Futures | 754.7 | 757.1 | 753.3 | 755.2 | 20.0 |
| 2012-10-30 | FTI | Futures | 280.38 | 284.58 | 280.29 | 284.32 | 16118.0 |
| 2012-10-30 | FTUK | Futures | 4220.5 | 4266.9 | 4211.3 | 4257.4 | 43385.0 |
| 2012-10-30 | FVSA | Futures | 5161.35 | 5161.35 | 5048.41 | 5059.7 | 5497.0 |
| 2012-10-30 | FXXP | Futures | 194.6 | 196.4 | 194.5 | 195.6 | 2439.0 |
| 2012-10-30 | G | Futures | 98.69 | 98.73 | 98.47 | 98.59 | 94328.0 |
| 2012-10-30 | GF | Futures | 280.595 | 284.052 | 279.587 | 282.371 | 1181.0 |
| 2012-10-30 | GSCI | Futures | 1031.67 | 1031.67 | 1026.09 | 1026.82 | 16.0 |
| 2012-10-30 | HE | Futures | 96.86 | 97.388 | 96.611 | 97.077 | 13055.0 |
| 2012-10-30 | HG | Futures | 4.5094 | 4.5396 | 4.4869 | 4.5055 | 30826.0 |
| 2012-10-30 | HH | Futures | 42.945 | 42.945 | 42.945 | 42.945 | 201.0 |
| 2012-10-30 | HO | Futures | 2.4941 | 2.5064 | 2.471 | 2.4881 | 57521.0 |
| 2012-10-30 | HRC | Futures | 2458.3 | 2458.3 | 2458.3 | 2458.3 | 0.0 |
| 2012-10-30 | J1 | Futures | 0.0156953 | 0.0158255 | 0.0156264 | 0.0157341 | 65831.0 |
| 2012-10-30 | J7 | Futures | 0.015631 | 0.015785 | 0.01557 | 0.015667 | 478.0 |
> showing 50 of 94 rows — these rows as CSV