PREVIEW / futures_daily / 2008-01-09
file: by_date/futures_daily/2008/2008-01-09.parquet size: 7 KB rows: 44
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 |
|---|---|---|---|---|---|---|---|
| 2008-01-09 | ES | Futures | 1295.06 | 1312.9 | 1283.71 | 1308.27 | 2811604.0 |
| 2008-01-09 | NQ | Futures | 2164.12 | 2205.37 | 2136.06 | 2196.11 | 665797.0 |
| 2008-01-09 | YM | Futures | 11229.5 | 11364.5 | 11147.7 | 11321.0 | 260541.0 |
| 2008-01-09 | CL | Futures | 410.81 | 418.19 | 407.31 | 408.38 | 346504.0 |
| 2008-01-09 | ZN | Futures | 83.057999 | 83.136567 | 82.698829 | 82.945758 | 1179016.0 |
| 2008-01-09 | A6 | Futures | 0.65984 | 0.66474 | 0.65901 | 0.66044 | 38664.0 |
| 2008-01-09 | AD | Futures | 0.97778 | 0.98063 | 0.97041 | 0.97189 | 35289.0 |
| 2008-01-09 | B6 | Futures | 2.0023 | 2.006 | 1.9846 | 1.9863 | 63254.0 |
| 2008-01-09 | DC | Futures | 43.96 | 44.39 | 42.71 | 42.79 | 353.0 |
| 2008-01-09 | DX | Futures | 82.177 | 82.63 | 82.15 | 82.544 | 1651.0 |
| 2008-01-09 | E1 | Futures | 1.20198 | 1.20397 | 1.19678 | 1.19944 | 32623.0 |
| 2008-01-09 | E6 | Futures | 1.7069 | 1.7105 | 1.69843 | 1.70121 | 130136.0 |
| 2008-01-09 | E7 | Futures | 1.6935 | 1.6975 | 1.6857 | 1.6884 | 1298.0 |
| 2008-01-09 | ED | Futures | 90.8641 | 90.9208 | 90.8404 | 90.9019 | 326675.0 |
| 2008-01-09 | ER | Futures | 94.106 | 94.12 | 94.101 | 94.116 | 114389.0 |
| 2008-01-09 | EW | Futures | 793.3 | 800.2 | 778.4 | 797.2 | 38094.0 |
| 2008-01-09 | FDAX | Futures | 8907.7 | 8950.7 | 8845.4 | 8879.4 | 203784.0 |
| 2008-01-09 | FESX | Futures | 2445.4 | 2459.1 | 2427.2 | 2443.1 | 1365436.0 |
| 2008-01-09 | FEU3 | Futures | 94.59 | 94.595 | 94.581 | 94.59 | 1602.0 |
| 2008-01-09 | FTDX | Futures | 821.3 | 846.8 | 805.8 | 821.3 | 1551.0 |
| 2008-01-09 | FTUK | Futures | 4082.3 | 4084.6 | 4039.9 | 4067.1 | 136923.0 |
| 2008-01-09 | G | Futures | 70.14 | 70.31 | 70.11 | 70.26 | 68802.0 |
| 2008-01-09 | HG | Futures | 4.581 | 4.749 | 4.581 | 4.6155 | 12505.0 |
| 2008-01-09 | J1 | Futures | 0.0118467 | 0.0118583 | 0.0117185 | 0.0117865 | 122317.0 |
| 2008-01-09 | J7 | Futures | 0.011635 | 0.011647 | 0.011514 | 0.011579 | 59.0 |
| 2008-01-09 | JB | Futures | 114.31 | 114.66 | 114.31 | 114.54 | 1944.0 |
| 2008-01-09 | KC | Futures | 430.57 | 432.01 | 426.6 | 431.21 | 9582.0 |
| 2008-01-09 | KE | Futures | 4962.3 | 4962.3 | 4816.03 | 4816.03 | 10574.0 |
| 2008-01-09 | L | Futures | 94.113 | 94.203 | 94.103 | 94.193 | 124614.0 |
| 2008-01-09 | MP | Futures | 0.04287 | 0.04308 | 0.04274 | 0.04287 | 33982.0 |
| 2008-01-09 | N6 | Futures | 0.57092 | 0.57527 | 0.57032 | 0.5731 | 1128.0 |
| 2008-01-09 | PA | Futures | 458.17 | 459.43 | 451.03 | 458.95 | 1249.0 |
| 2008-01-09 | PJY | Futures | 168.23 | 168.23 | 168.23 | 168.23 | 0.0 |
| 2008-01-09 | PL | Futures | 1846.8 | 1853.4 | 1830.4 | 1840.2 | 2736.0 |
| 2008-01-09 | PSI | Futures | 9857.7 | 9857.7 | 9799.5 | 9845.1 | 271.0 |
| 2008-01-09 | RP | Futures | 0.8512 | 0.85587 | 0.84967 | 0.85451 | 253.0 |
| 2008-01-09 | RTY | Futures | 715.3 | 725.5 | 701.0 | 722.1 | 388125.0 |
| 2008-01-09 | RY | Futures | 145.16 | 146.48 | 145.1 | 145.48 | 1924.0 |
| 2008-01-09 | SI | Futures | 27.214 | 28.032 | 26.955 | 27.291 | 36840.0 |
| 2008-01-09 | US | Futures | 90.458188 | 90.767488 | 90.125097 | 90.458188 | 375925.0 |
| 2008-01-09 | ZF | Futures | 91.6413626 | 91.8077505 | 91.4237783 | 91.6413626 | 677211.0 |
| 2008-01-09 | ZL | Futures | 50.87 | 51.3 | 50.86 | 50.93 | 35884.0 |
| 2008-01-09 | ZT | Futures | 98.19938094 | 98.31532737 | 98.09792781 | 98.2211209 | 299015.0 |
| 2008-01-09 | ZW | Futures | 6965.9 | 6998.35 | 6780.73 | 6792.18 | 50866.0 |
> showing 44 of 44 rows — these rows as CSV