PREVIEW / futures_30min / 2019-10-13
file: by_date/futures_30min/2019/2019-10-13.parquet size: 26 KB rows: 698
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 |
|---|---|---|---|---|---|---|---|
| 2019-10-13 18:00:00 | ES | Futures | 3224.8 | 3233.5 | 3224.26 | 3232.14 | 8416.0 |
| 2019-10-13 18:30:00 | ES | Futures | 3232.41 | 3237.3 | 3231.59 | 3235.4 | 5313.0 |
| 2019-10-13 19:00:00 | ES | Futures | 3235.4 | 3237.3 | 3235.4 | 3236.48 | 2188.0 |
| 2019-10-13 19:30:00 | ES | Futures | 3236.21 | 3239.74 | 3236.21 | 3239.74 | 3604.0 |
| 2019-10-13 20:00:00 | ES | Futures | 3239.74 | 3240.56 | 3234.31 | 3235.12 | 6940.0 |
| 2019-10-13 20:30:00 | ES | Futures | 3235.12 | 3235.12 | 3231.87 | 3234.04 | 4898.0 |
| 2019-10-13 21:00:00 | ES | Futures | 3234.04 | 3234.58 | 3225.89 | 3231.59 | 9240.0 |
| 2019-10-13 21:30:00 | ES | Futures | 3231.59 | 3234.04 | 3226.7 | 3233.77 | 6178.0 |
| 2019-10-13 22:00:00 | ES | Futures | 3233.77 | 3236.21 | 3231.87 | 3233.77 | 5173.0 |
| 2019-10-13 22:30:00 | ES | Futures | 3233.77 | 3235.94 | 3232.14 | 3234.04 | 3425.0 |
| 2019-10-13 23:00:00 | ES | Futures | 3234.31 | 3235.67 | 3232.95 | 3235.4 | 2655.0 |
| 2019-10-13 23:30:00 | ES | Futures | 3235.67 | 3236.48 | 3234.85 | 3235.94 | 1567.0 |
| 2019-10-13 18:00:00 | NQ | Futures | 9121.75 | 9157.48 | 9121.46 | 9149.35 | 2595.0 |
| 2019-10-13 18:30:00 | NQ | Futures | 9149.06 | 9167.07 | 9147.31 | 9160.67 | 2269.0 |
| 2019-10-13 19:00:00 | NQ | Futures | 9160.09 | 9164.45 | 9158.35 | 9162.71 | 1017.0 |
| 2019-10-13 19:30:00 | NQ | Futures | 9162.71 | 9171.71 | 9162.42 | 9171.13 | 1557.0 |
| 2019-10-13 20:00:00 | NQ | Futures | 9171.13 | 9173.46 | 9153.41 | 9156.9 | 3952.0 |
| 2019-10-13 20:30:00 | NQ | Futures | 9156.9 | 9156.9 | 9145.86 | 9151.09 | 2479.0 |
| 2019-10-13 21:00:00 | NQ | Futures | 9150.51 | 9155.16 | 9129.3 | 9143.83 | 4519.0 |
| 2019-10-13 21:30:00 | NQ | Futures | 9143.54 | 9152.25 | 9128.14 | 9151.67 | 3687.0 |
| 2019-10-13 22:00:00 | NQ | Futures | 9151.67 | 9160.09 | 9146.15 | 9151.38 | 2759.0 |
| 2019-10-13 22:30:00 | NQ | Futures | 9151.67 | 9156.9 | 9145.57 | 9150.8 | 1969.0 |
| 2019-10-13 23:00:00 | NQ | Futures | 9150.51 | 9154.87 | 9147.02 | 9153.99 | 2408.0 |
| 2019-10-13 23:30:00 | NQ | Futures | 9154.57 | 9156.9 | 9151.67 | 9155.45 | 873.0 |
| 2019-10-13 18:00:00 | YM | Futures | 29125.4 | 29214.6 | 29124.3 | 29207.0 | 2115.0 |
| 2019-10-13 18:30:00 | YM | Futures | 29207.0 | 29251.6 | 29203.8 | 29235.3 | 975.0 |
| 2019-10-13 19:00:00 | YM | Futures | 29233.1 | 29247.3 | 29229.9 | 29239.7 | 368.0 |
| 2019-10-13 19:30:00 | YM | Futures | 29238.6 | 29266.9 | 29237.5 | 29266.9 | 902.0 |
| 2019-10-13 20:00:00 | YM | Futures | 29268.0 | 29270.1 | 29209.2 | 29215.7 | 1429.0 |
| 2019-10-13 20:30:00 | YM | Futures | 29217.9 | 29219.0 | 29190.7 | 29209.2 | 1056.0 |
| 2019-10-13 21:00:00 | YM | Futures | 29207.0 | 29216.8 | 29137.4 | 29185.3 | 1944.0 |
| 2019-10-13 21:30:00 | YM | Futures | 29184.2 | 29205.9 | 29146.1 | 29204.8 | 1480.0 |
| 2019-10-13 22:00:00 | YM | Futures | 29204.8 | 29223.3 | 29184.2 | 29201.6 | 1108.0 |
| 2019-10-13 22:30:00 | YM | Futures | 29201.6 | 29224.4 | 29189.6 | 29207.0 | 892.0 |
| 2019-10-13 23:00:00 | YM | Futures | 29209.2 | 29220.1 | 29197.2 | 29216.8 | 549.0 |
| 2019-10-13 23:30:00 | YM | Futures | 29217.9 | 29224.4 | 29212.5 | 29219.0 | 493.0 |
| 2019-10-13 18:00:00 | CL | Futures | 48.77 | 48.77 | 48.61 | 48.66 | 2046.0 |
| 2019-10-13 18:30:00 | CL | Futures | 48.66 | 48.69 | 48.58 | 48.62 | 858.0 |
| 2019-10-13 19:00:00 | CL | Futures | 48.61 | 48.67 | 48.61 | 48.63 | 587.0 |
| 2019-10-13 19:30:00 | CL | Futures | 48.63 | 48.73 | 48.63 | 48.69 | 1057.0 |
| 2019-10-13 20:00:00 | CL | Futures | 48.69 | 48.69 | 48.55 | 48.58 | 1466.0 |
| 2019-10-13 20:30:00 | CL | Futures | 48.58 | 48.58 | 48.44 | 48.44 | 2445.0 |
| 2019-10-13 21:00:00 | CL | Futures | 48.44 | 48.45 | 48.25 | 48.3 | 6395.0 |
| 2019-10-13 21:30:00 | CL | Futures | 48.29 | 48.41 | 48.25 | 48.41 | 3737.0 |
| 2019-10-13 22:00:00 | CL | Futures | 48.41 | 48.45 | 48.31 | 48.33 | 4041.0 |
| 2019-10-13 22:30:00 | CL | Futures | 48.33 | 48.37 | 48.29 | 48.36 | 1886.0 |
| 2019-10-13 23:00:00 | CL | Futures | 48.37 | 48.38 | 48.33 | 48.34 | 1058.0 |
| 2019-10-13 23:30:00 | CL | Futures | 48.34 | 48.38 | 48.33 | 48.37 | 877.0 |
| 2019-10-13 18:00:00 | GC | Futures | 1890.2 | 1891.9 | 1886.9 | 1886.9 | 2736.0 |
| 2019-10-13 18:30:00 | GC | Futures | 1887.1 | 1887.8 | 1884.0 | 1885.7 | 2156.0 |
> showing 50 of 698 rows — these rows as CSV