PREVIEW / futures_30min / 2019-09-13
file: by_date/futures_30min/2019/2019-09-13.parquet size: 77 KB rows: 2,737
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-09-13 00:00:00 | ES | Futures | 3264.97 | 3265.79 | 3264.7 | 3265.24 | 657.0 |
| 2019-09-13 00:30:00 | ES | Futures | 3265.24 | 3267.68 | 3264.7 | 3267.14 | 1938.0 |
| 2019-09-13 01:00:00 | ES | Futures | 3267.14 | 3268.76 | 3266.87 | 3267.68 | 2825.0 |
| 2019-09-13 01:30:00 | ES | Futures | 3267.68 | 3268.22 | 3267.14 | 3267.41 | 1909.0 |
| 2019-09-13 02:00:00 | ES | Futures | 3267.41 | 3267.95 | 3266.06 | 3267.41 | 2595.0 |
| 2019-09-13 02:30:00 | ES | Futures | 3267.14 | 3267.41 | 3265.52 | 3266.06 | 3793.0 |
| 2019-09-13 03:00:00 | ES | Futures | 3266.06 | 3270.66 | 3265.24 | 3270.12 | 6747.0 |
| 2019-09-13 03:30:00 | ES | Futures | 3270.39 | 3270.66 | 3267.95 | 3268.49 | 5217.0 |
| 2019-09-13 04:00:00 | ES | Futures | 3268.22 | 3269.03 | 3266.6 | 3267.68 | 6091.0 |
| 2019-09-13 04:30:00 | ES | Futures | 3267.41 | 3271.74 | 3265.79 | 3266.33 | 12149.0 |
| 2019-09-13 05:00:00 | ES | Futures | 3266.06 | 3269.31 | 3265.24 | 3268.76 | 11243.0 |
| 2019-09-13 05:30:00 | ES | Futures | 3268.76 | 3271.2 | 3267.68 | 3269.58 | 9603.0 |
| 2019-09-13 06:00:00 | ES | Futures | 3269.85 | 3271.74 | 3269.85 | 3271.2 | 4406.0 |
| 2019-09-13 06:30:00 | ES | Futures | 3270.93 | 3273.64 | 3270.93 | 3273.64 | 4871.0 |
| 2019-09-13 07:00:00 | ES | Futures | 3273.37 | 3274.18 | 3271.74 | 3271.74 | 6069.0 |
| 2019-09-13 07:30:00 | ES | Futures | 3271.74 | 3272.28 | 3269.58 | 3270.93 | 5831.0 |
| 2019-09-13 08:00:00 | ES | Futures | 3270.66 | 3272.01 | 3269.03 | 3269.85 | 6852.0 |
| 2019-09-13 08:30:00 | ES | Futures | 3269.85 | 3271.74 | 3266.33 | 3266.6 | 12993.0 |
| 2019-09-13 09:00:00 | ES | Futures | 3266.87 | 3266.87 | 3264.16 | 3264.43 | 16833.0 |
| 2019-09-13 09:30:00 | ES | Futures | 3264.43 | 3267.14 | 3260.64 | 3263.08 | 81759.0 |
| 2019-09-13 10:00:00 | ES | Futures | 3262.81 | 3266.33 | 3259.02 | 3264.43 | 56586.0 |
| 2019-09-13 10:30:00 | ES | Futures | 3264.43 | 3266.33 | 3262.0 | 3265.24 | 35884.0 |
| 2019-09-13 11:00:00 | ES | Futures | 3265.24 | 3268.76 | 3262.0 | 3263.89 | 37009.0 |
| 2019-09-13 11:30:00 | ES | Futures | 3263.89 | 3265.24 | 3261.45 | 3262.27 | 25557.0 |
| 2019-09-13 12:00:00 | ES | Futures | 3262.27 | 3265.52 | 3259.29 | 3260.64 | 23829.0 |
| 2019-09-13 12:30:00 | ES | Futures | 3260.37 | 3262.27 | 3259.29 | 3260.37 | 20748.0 |
| 2019-09-13 13:00:00 | ES | Futures | 3260.37 | 3262.54 | 3259.56 | 3261.18 | 12026.0 |
| 2019-09-13 13:30:00 | ES | Futures | 3261.45 | 3261.45 | 3256.31 | 3257.66 | 23661.0 |
| 2019-09-13 14:00:00 | ES | Futures | 3257.39 | 3260.37 | 3256.58 | 3258.48 | 21095.0 |
| 2019-09-13 14:30:00 | ES | Futures | 3258.21 | 3260.1 | 3257.39 | 3258.48 | 14575.0 |
| 2019-09-13 15:00:00 | ES | Futures | 3258.48 | 3258.75 | 3252.25 | 3256.04 | 33638.0 |
| 2019-09-13 15:30:00 | ES | Futures | 3256.04 | 3260.91 | 3255.23 | 3256.58 | 82232.0 |
| 2019-09-13 16:00:00 | ES | Futures | 3256.58 | 3258.75 | 3254.42 | 3255.77 | 32037.0 |
| 2019-09-13 16:30:00 | ES | Futures | 3255.23 | 3257.94 | 3255.23 | 3256.04 | 5996.0 |
| 2019-09-13 00:00:00 | NQ | Futures | 9209.12 | 9212.89 | 9208.25 | 9210.28 | 334.0 |
| 2019-09-13 00:30:00 | NQ | Futures | 9209.99 | 9220.73 | 9208.83 | 9217.54 | 1296.0 |
| 2019-09-13 01:00:00 | NQ | Futures | 9217.83 | 9222.47 | 9216.37 | 9217.83 | 504.0 |
| 2019-09-13 01:30:00 | NQ | Futures | 9218.12 | 9220.73 | 9216.66 | 9217.83 | 413.0 |
| 2019-09-13 02:00:00 | NQ | Futures | 9217.83 | 9217.83 | 9212.31 | 9215.5 | 914.0 |
| 2019-09-13 02:30:00 | NQ | Futures | 9215.5 | 9216.37 | 9208.25 | 9209.41 | 936.0 |
| 2019-09-13 03:00:00 | NQ | Futures | 9209.41 | 9225.95 | 9204.48 | 9224.21 | 2509.0 |
| 2019-09-13 03:30:00 | NQ | Futures | 9224.21 | 9227.4 | 9217.24 | 9218.12 | 1908.0 |
| 2019-09-13 04:00:00 | NQ | Futures | 9218.41 | 9221.31 | 9210.28 | 9214.34 | 1282.0 |
| 2019-09-13 04:30:00 | NQ | Futures | 9214.34 | 9226.24 | 9206.8 | 9208.54 | 2320.0 |
| 2019-09-13 05:00:00 | NQ | Futures | 9208.54 | 9219.86 | 9205.35 | 9218.7 | 1744.0 |
| 2019-09-13 05:30:00 | NQ | Futures | 9218.99 | 9226.53 | 9216.08 | 9225.08 | 2046.0 |
| 2019-09-13 06:00:00 | NQ | Futures | 9225.08 | 9227.98 | 9219.86 | 9222.18 | 2060.0 |
| 2019-09-13 06:30:00 | NQ | Futures | 9222.18 | 9236.39 | 9221.31 | 9234.36 | 1889.0 |
| 2019-09-13 07:00:00 | NQ | Futures | 9234.07 | 9235.52 | 9228.85 | 9230.59 | 1610.0 |
| 2019-09-13 07:30:00 | NQ | Futures | 9230.3 | 9231.17 | 9217.54 | 9219.57 | 2103.0 |
> showing 50 of 2,737 rows — these rows as CSV