PREVIEW / futures_1hour / 2012-12-14
file: by_date/futures_1hour/2012/2012-12-14.parquet size: 39 KB rows: 1,191
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 |
|---|---|---|---|---|---|---|---|
| 2012-12-14 00:00:00 | ES | Futures | 1453.59 | 1453.59 | 1451.28 | 1452.31 | 2770.0 |
| 2012-12-14 01:00:00 | ES | Futures | 1452.56 | 1453.59 | 1451.79 | 1453.08 | 2057.0 |
| 2012-12-14 02:00:00 | ES | Futures | 1453.33 | 1455.64 | 1452.56 | 1454.87 | 6100.0 |
| 2012-12-14 03:00:00 | ES | Futures | 1454.87 | 1456.67 | 1452.31 | 1453.08 | 23170.0 |
| 2012-12-14 04:00:00 | ES | Futures | 1453.08 | 1454.1 | 1452.31 | 1453.59 | 11710.0 |
| 2012-12-14 05:00:00 | ES | Futures | 1453.33 | 1453.85 | 1452.05 | 1452.56 | 6765.0 |
| 2012-12-14 06:00:00 | ES | Futures | 1452.56 | 1453.85 | 1452.56 | 1453.59 | 5019.0 |
| 2012-12-14 07:00:00 | ES | Futures | 1453.59 | 1453.85 | 1450.51 | 1450.51 | 14381.0 |
| 2012-12-14 08:00:00 | ES | Futures | 1450.51 | 1452.31 | 1447.43 | 1448.97 | 41043.0 |
| 2012-12-14 09:00:00 | ES | Futures | 1448.97 | 1451.54 | 1445.38 | 1446.92 | 161223.0 |
| 2012-12-14 10:00:00 | ES | Futures | 1446.66 | 1449.74 | 1445.63 | 1447.94 | 175360.0 |
| 2012-12-14 11:00:00 | ES | Futures | 1447.69 | 1448.71 | 1444.35 | 1446.66 | 125243.0 |
| 2012-12-14 12:00:00 | ES | Futures | 1446.66 | 1449.23 | 1446.4 | 1447.69 | 84078.0 |
| 2012-12-14 13:00:00 | ES | Futures | 1447.94 | 1448.71 | 1446.15 | 1448.46 | 60861.0 |
| 2012-12-14 14:00:00 | ES | Futures | 1448.46 | 1449.23 | 1444.09 | 1444.61 | 66831.0 |
| 2012-12-14 15:00:00 | ES | Futures | 1444.35 | 1446.92 | 1442.81 | 1445.12 | 181174.0 |
| 2012-12-14 16:00:00 | ES | Futures | 1445.12 | 1447.69 | 1444.86 | 1447.43 | 79634.0 |
| 2012-12-14 17:00:00 | ES | Futures | 1447.43 | 1447.94 | 1447.43 | 1447.94 | 677.0 |
| 2012-12-14 00:00:00 | NQ | Futures | 3089.99 | 3090.28 | 3083.59 | 3085.62 | 807.0 |
| 2012-12-14 01:00:00 | NQ | Futures | 3085.91 | 3087.66 | 3084.75 | 3086.79 | 368.0 |
| 2012-12-14 02:00:00 | NQ | Futures | 3086.79 | 3090.86 | 3085.62 | 3088.83 | 871.0 |
| 2012-12-14 03:00:00 | NQ | Futures | 3088.83 | 3094.94 | 3084.75 | 3085.91 | 3118.0 |
| 2012-12-14 04:00:00 | NQ | Futures | 3085.62 | 3087.37 | 3082.13 | 3086.21 | 2105.0 |
| 2012-12-14 05:00:00 | NQ | Futures | 3086.21 | 3087.37 | 3083.0 | 3084.17 | 988.0 |
| 2012-12-14 06:00:00 | NQ | Futures | 3083.88 | 3086.5 | 3083.88 | 3086.21 | 679.0 |
| 2012-12-14 07:00:00 | NQ | Futures | 3085.91 | 3086.5 | 3076.31 | 3076.89 | 2840.0 |
| 2012-12-14 08:00:00 | NQ | Futures | 3076.89 | 3079.22 | 3067.58 | 3069.32 | 6708.0 |
| 2012-12-14 09:00:00 | NQ | Futures | 3069.61 | 3073.69 | 3053.9 | 3061.46 | 38437.0 |
| 2012-12-14 10:00:00 | NQ | Futures | 3061.46 | 3067.87 | 3057.68 | 3062.92 | 36166.0 |
| 2012-12-14 11:00:00 | NQ | Futures | 3063.21 | 3064.67 | 3055.64 | 3061.46 | 29372.0 |
| 2012-12-14 12:00:00 | NQ | Futures | 3061.76 | 3069.61 | 3061.46 | 3065.54 | 12767.0 |
| 2012-12-14 13:00:00 | NQ | Futures | 3065.54 | 3066.99 | 3058.84 | 3063.5 | 10823.0 |
| 2012-12-14 14:00:00 | NQ | Futures | 3063.5 | 3064.67 | 3045.16 | 3046.62 | 16988.0 |
| 2012-12-14 15:00:00 | NQ | Futures | 3046.62 | 3056.52 | 3045.16 | 3056.23 | 29617.0 |
| 2012-12-14 16:00:00 | NQ | Futures | 3055.93 | 3059.72 | 3054.48 | 3057.97 | 7722.0 |
| 2012-12-14 17:00:00 | NQ | Futures | 3057.97 | 3059.14 | 3056.81 | 3059.14 | 161.0 |
| 2012-12-14 00:00:00 | YM | Futures | 13205.1 | 13208.1 | 13195.0 | 13202.1 | 402.0 |
| 2012-12-14 01:00:00 | YM | Futures | 13202.1 | 13210.1 | 13198.0 | 13206.1 | 273.0 |
| 2012-12-14 02:00:00 | YM | Futures | 13206.1 | 13224.2 | 13204.1 | 13221.2 | 709.0 |
| 2012-12-14 03:00:00 | YM | Futures | 13221.2 | 13233.3 | 13204.1 | 13208.1 | 1831.0 |
| 2012-12-14 04:00:00 | YM | Futures | 13207.1 | 13216.1 | 13202.1 | 13215.1 | 1074.0 |
| 2012-12-14 05:00:00 | YM | Futures | 13214.1 | 13217.2 | 13207.1 | 13210.1 | 933.0 |
| 2012-12-14 06:00:00 | YM | Futures | 13210.1 | 13218.2 | 13209.1 | 13216.1 | 690.0 |
| 2012-12-14 07:00:00 | YM | Futures | 13215.1 | 13217.2 | 13194.0 | 13194.0 | 1411.0 |
| 2012-12-14 08:00:00 | YM | Futures | 13194.0 | 13203.1 | 13170.9 | 13179.9 | 3068.0 |
| 2012-12-14 09:00:00 | YM | Futures | 13179.9 | 13203.1 | 13171.9 | 13177.9 | 11734.0 |
| 2012-12-14 10:00:00 | YM | Futures | 13176.9 | 13207.1 | 13172.9 | 13192.0 | 14280.0 |
| 2012-12-14 11:00:00 | YM | Futures | 13193.0 | 13200.1 | 13153.8 | 13168.9 | 10565.0 |
| 2012-12-14 12:00:00 | YM | Futures | 13169.9 | 13190.0 | 13167.9 | 13177.9 | 7074.0 |
| 2012-12-14 13:00:00 | YM | Futures | 13177.9 | 13184.0 | 13168.9 | 13183.0 | 5397.0 |
> showing 50 of 1,191 rows — these rows as CSV