PREVIEW / futures_30min / 2010-01-13
file: by_date/futures_30min/2010/2010-01-13.parquet size: 72 KB rows: 2,608
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-01-13 00:00:00 | ES | Futures | 1105.12 | 1105.85 | 1104.88 | 1105.61 | 1527.0 |
| 2010-01-13 00:30:00 | ES | Futures | 1105.61 | 1105.85 | 1104.15 | 1104.15 | 1696.0 |
| 2010-01-13 01:00:00 | ES | Futures | 1104.15 | 1104.15 | 1103.67 | 1104.15 | 1693.0 |
| 2010-01-13 01:30:00 | ES | Futures | 1103.91 | 1104.15 | 1103.42 | 1103.67 | 1990.0 |
| 2010-01-13 02:00:00 | ES | Futures | 1103.67 | 1103.67 | 1102.69 | 1102.94 | 5195.0 |
| 2010-01-13 02:30:00 | ES | Futures | 1102.69 | 1102.94 | 1101.72 | 1101.72 | 5636.0 |
| 2010-01-13 03:00:00 | ES | Futures | 1101.96 | 1104.88 | 1101.72 | 1104.39 | 12988.0 |
| 2010-01-13 03:30:00 | ES | Futures | 1104.64 | 1105.61 | 1104.39 | 1104.88 | 8995.0 |
| 2010-01-13 04:00:00 | ES | Futures | 1104.88 | 1106.34 | 1104.39 | 1105.85 | 11292.0 |
| 2010-01-13 04:30:00 | ES | Futures | 1105.85 | 1106.1 | 1104.88 | 1105.12 | 6174.0 |
| 2010-01-13 05:00:00 | ES | Futures | 1105.12 | 1105.61 | 1103.42 | 1103.67 | 10047.0 |
| 2010-01-13 05:30:00 | ES | Futures | 1103.67 | 1104.64 | 1103.42 | 1104.64 | 5272.0 |
| 2010-01-13 06:00:00 | ES | Futures | 1104.64 | 1104.88 | 1103.91 | 1104.64 | 6488.0 |
| 2010-01-13 06:30:00 | ES | Futures | 1104.39 | 1104.88 | 1103.67 | 1103.91 | 3517.0 |
| 2010-01-13 07:00:00 | ES | Futures | 1103.91 | 1106.1 | 1103.67 | 1105.61 | 8816.0 |
| 2010-01-13 07:30:00 | ES | Futures | 1105.61 | 1106.58 | 1105.37 | 1106.1 | 10663.0 |
| 2010-01-13 08:00:00 | ES | Futures | 1106.1 | 1106.83 | 1105.12 | 1105.85 | 16899.0 |
| 2010-01-13 08:30:00 | ES | Futures | 1106.1 | 1106.1 | 1104.88 | 1105.12 | 13935.0 |
| 2010-01-13 09:00:00 | ES | Futures | 1104.88 | 1105.37 | 1104.15 | 1104.64 | 19320.0 |
| 2010-01-13 09:30:00 | ES | Futures | 1104.64 | 1106.1 | 1102.94 | 1103.42 | 189151.0 |
| 2010-01-13 10:00:00 | ES | Futures | 1103.42 | 1103.91 | 1099.04 | 1100.02 | 208570.0 |
| 2010-01-13 10:30:00 | ES | Futures | 1100.02 | 1102.21 | 1098.8 | 1102.21 | 147637.0 |
| 2010-01-13 11:00:00 | ES | Futures | 1102.21 | 1105.37 | 1101.23 | 1104.88 | 135702.0 |
| 2010-01-13 11:30:00 | ES | Futures | 1104.88 | 1106.1 | 1104.64 | 1105.37 | 110909.0 |
| 2010-01-13 12:00:00 | ES | Futures | 1105.37 | 1108.77 | 1105.37 | 1108.04 | 339030.0 |
| 2010-01-13 12:30:00 | ES | Futures | 1108.29 | 1110.23 | 1107.56 | 1108.29 | 121198.0 |
| 2010-01-13 13:00:00 | ES | Futures | 1108.29 | 1109.26 | 1107.8 | 1109.02 | 57683.0 |
| 2010-01-13 13:30:00 | ES | Futures | 1108.77 | 1109.75 | 1107.56 | 1108.04 | 83571.0 |
| 2010-01-13 14:00:00 | ES | Futures | 1108.04 | 1109.99 | 1107.8 | 1108.77 | 73375.0 |
| 2010-01-13 14:30:00 | ES | Futures | 1109.02 | 1111.69 | 1108.77 | 1111.45 | 99166.0 |
| 2010-01-13 15:00:00 | ES | Futures | 1111.45 | 1112.91 | 1110.23 | 1112.42 | 101972.0 |
| 2010-01-13 15:30:00 | ES | Futures | 1112.42 | 1114.37 | 1110.96 | 1111.45 | 183695.0 |
| 2010-01-13 16:00:00 | ES | Futures | 1111.45 | 1111.45 | 1110.48 | 1110.48 | 76953.0 |
| 2010-01-13 16:30:00 | ES | Futures | 1110.72 | 1111.21 | 1110.48 | 1110.96 | 3565.0 |
| 2010-01-13 17:00:00 | ES | Futures | 1110.96 | 1111.21 | 1110.48 | 1110.48 | 797.0 |
| 2010-01-13 18:00:00 | ES | Futures | 1110.48 | 1111.21 | 1110.23 | 1110.96 | 1100.0 |
| 2010-01-13 18:30:00 | ES | Futures | 1110.96 | 1111.21 | 1110.48 | 1111.21 | 701.0 |
| 2010-01-13 19:00:00 | ES | Futures | 1110.96 | 1111.69 | 1110.72 | 1111.21 | 2910.0 |
| 2010-01-13 19:30:00 | ES | Futures | 1111.21 | 1112.91 | 1111.21 | 1112.67 | 3774.0 |
| 2010-01-13 20:00:00 | ES | Futures | 1112.67 | 1112.67 | 1111.69 | 1112.18 | 1006.0 |
| 2010-01-13 20:30:00 | ES | Futures | 1112.42 | 1113.15 | 1111.69 | 1112.67 | 1994.0 |
| 2010-01-13 21:00:00 | ES | Futures | 1112.67 | 1113.15 | 1112.42 | 1112.67 | 1223.0 |
| 2010-01-13 21:30:00 | ES | Futures | 1112.67 | 1113.88 | 1112.67 | 1113.15 | 2879.0 |
| 2010-01-13 22:00:00 | ES | Futures | 1113.4 | 1113.88 | 1112.91 | 1113.64 | 1941.0 |
| 2010-01-13 22:30:00 | ES | Futures | 1113.4 | 1114.13 | 1113.4 | 1113.4 | 1299.0 |
| 2010-01-13 23:00:00 | ES | Futures | 1113.4 | 1113.64 | 1112.91 | 1112.91 | 1081.0 |
| 2010-01-13 23:30:00 | ES | Futures | 1112.91 | 1113.88 | 1112.91 | 1113.64 | 419.0 |
| 2010-01-13 00:00:00 | NQ | Futures | 2132.22 | 2133.36 | 2131.94 | 2133.08 | 97.0 |
| 2010-01-13 00:30:00 | NQ | Futures | 2132.79 | 2133.08 | 2131.36 | 2131.36 | 271.0 |
| 2010-01-13 01:00:00 | NQ | Futures | 2131.08 | 2131.65 | 2130.51 | 2131.36 | 137.0 |
> showing 50 of 2,608 rows — these rows as CSV