PREVIEW / futures_1hour / 2010-04-04
file: by_date/futures_1hour/2010/2010-04-04.parquet size: 12 KB rows: 235
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 |
|---|---|---|---|---|---|---|---|
| 2010-04-04 18:00:00 | ES | Futures | 1152.47 | 1154.18 | 1151.98 | 1153.45 | 8886.0 |
| 2010-04-04 19:00:00 | ES | Futures | 1153.69 | 1153.69 | 1152.23 | 1152.96 | 1799.0 |
| 2010-04-04 20:00:00 | ES | Futures | 1152.71 | 1153.45 | 1152.71 | 1153.2 | 2200.0 |
| 2010-04-04 21:00:00 | ES | Futures | 1153.45 | 1153.45 | 1152.71 | 1152.96 | 1185.0 |
| 2010-04-04 22:00:00 | ES | Futures | 1152.96 | 1153.2 | 1152.47 | 1152.71 | 744.0 |
| 2010-04-04 23:00:00 | ES | Futures | 1152.47 | 1152.96 | 1152.23 | 1152.47 | 577.0 |
| 2010-04-04 18:00:00 | NQ | Futures | 2249.74 | 2252.03 | 2248.02 | 2250.03 | 734.0 |
| 2010-04-04 19:00:00 | NQ | Futures | 2250.32 | 2250.6 | 2248.6 | 2249.17 | 121.0 |
| 2010-04-04 20:00:00 | NQ | Futures | 2249.74 | 2250.32 | 2248.6 | 2249.46 | 189.0 |
| 2010-04-04 21:00:00 | NQ | Futures | 2249.46 | 2250.32 | 2249.17 | 2249.74 | 161.0 |
| 2010-04-04 22:00:00 | NQ | Futures | 2249.74 | 2249.74 | 2248.31 | 2249.17 | 96.0 |
| 2010-04-04 23:00:00 | NQ | Futures | 2248.88 | 2250.03 | 2248.88 | 2249.74 | 119.0 |
| 2010-04-04 18:00:00 | YM | Futures | 10254.8 | 10273.6 | 10254.8 | 10263.3 | 385.0 |
| 2010-04-04 19:00:00 | YM | Futures | 10264.2 | 10268.0 | 10259.5 | 10260.4 | 106.0 |
| 2010-04-04 20:00:00 | YM | Futures | 10261.4 | 10267.0 | 10259.5 | 10263.3 | 375.0 |
| 2010-04-04 21:00:00 | YM | Futures | 10263.3 | 10266.1 | 10262.3 | 10264.2 | 97.0 |
| 2010-04-04 22:00:00 | YM | Futures | 10264.2 | 10265.1 | 10259.5 | 10259.5 | 84.0 |
| 2010-04-04 23:00:00 | YM | Futures | 10259.5 | 10263.3 | 10257.6 | 10261.4 | 105.0 |
| 2010-04-04 18:00:00 | CL | Futures | 180.57 | 181.35 | 180.54 | 181.14 | 1607.0 |
| 2010-04-04 19:00:00 | CL | Futures | 181.12 | 181.31 | 181.01 | 181.07 | 465.0 |
| 2010-04-04 20:00:00 | CL | Futures | 181.07 | 181.79 | 181.03 | 181.52 | 1389.0 |
| 2010-04-04 21:00:00 | CL | Futures | 181.52 | 181.58 | 181.2 | 181.31 | 745.0 |
| 2010-04-04 22:00:00 | CL | Futures | 181.28 | 181.39 | 180.92 | 181.35 | 973.0 |
| 2010-04-04 23:00:00 | CL | Futures | 181.35 | 181.41 | 181.28 | 181.39 | 285.0 |
| 2010-04-04 18:00:00 | GC | Futures | 1577.6 | 1584.8 | 1575.9 | 1583.2 | 2363.0 |
| 2010-04-04 19:00:00 | GC | Futures | 1583.2 | 1585.1 | 1579.7 | 1580.1 | 1468.0 |
| 2010-04-04 20:00:00 | GC | Futures | 1580.4 | 1586.0 | 1580.1 | 1584.9 | 1408.0 |
| 2010-04-04 21:00:00 | GC | Futures | 1585.1 | 1585.3 | 1583.5 | 1584.1 | 966.0 |
| 2010-04-04 22:00:00 | GC | Futures | 1584.4 | 1584.4 | 1580.8 | 1581.1 | 677.0 |
| 2010-04-04 23:00:00 | GC | Futures | 1581.0 | 1582.0 | 1580.6 | 1582.0 | 360.0 |
| 2010-04-04 18:00:00 | ZN | Futures | 94.815831 | 94.892917 | 94.802983 | 94.880069 | 2048.0 |
| 2010-04-04 19:00:00 | ZN | Futures | 94.880069 | 94.905765 | 94.867222 | 94.880069 | 2728.0 |
| 2010-04-04 20:00:00 | ZN | Futures | 94.880069 | 94.892917 | 94.867222 | 94.880069 | 1869.0 |
| 2010-04-04 21:00:00 | ZN | Futures | 94.892917 | 94.892917 | 94.828679 | 94.828679 | 2610.0 |
| 2010-04-04 22:00:00 | ZN | Futures | 94.828679 | 94.841526 | 94.828679 | 94.841526 | 1223.0 |
| 2010-04-04 23:00:00 | ZN | Futures | 94.841526 | 94.854374 | 94.841526 | 94.841526 | 630.0 |
> showing 36 of 235 rows — these rows as CSV