PREVIEW / futures_30min / 2008-07-18
file: by_date/futures_30min/2008/2008-07-18.parquet size: 58 KB rows: 1,852
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 |
|---|---|---|---|---|---|---|---|
| 2008-07-18 00:00:00 | ES | Futures | 1155.8 | 1156.27 | 1155.1 | 1155.1 | 918.0 |
| 2008-07-18 00:30:00 | ES | Futures | 1155.1 | 1155.57 | 1154.64 | 1155.34 | 1284.0 |
| 2008-07-18 01:00:00 | ES | Futures | 1155.34 | 1155.57 | 1154.41 | 1155.1 | 925.0 |
| 2008-07-18 01:30:00 | ES | Futures | 1155.1 | 1155.57 | 1154.64 | 1155.57 | 1130.0 |
| 2008-07-18 02:00:00 | ES | Futures | 1155.34 | 1157.66 | 1153.94 | 1156.96 | 4424.0 |
| 2008-07-18 02:30:00 | ES | Futures | 1156.96 | 1157.2 | 1154.87 | 1155.57 | 3632.0 |
| 2008-07-18 03:00:00 | ES | Futures | 1155.57 | 1158.82 | 1153.71 | 1158.59 | 10253.0 |
| 2008-07-18 03:30:00 | ES | Futures | 1158.59 | 1161.84 | 1158.13 | 1159.75 | 10970.0 |
| 2008-07-18 04:00:00 | ES | Futures | 1159.75 | 1159.75 | 1157.66 | 1158.36 | 5284.0 |
| 2008-07-18 04:30:00 | ES | Futures | 1158.36 | 1160.68 | 1157.89 | 1158.13 | 4256.0 |
| 2008-07-18 05:00:00 | ES | Futures | 1158.13 | 1158.36 | 1156.27 | 1158.13 | 6613.0 |
| 2008-07-18 05:30:00 | ES | Futures | 1157.89 | 1159.06 | 1157.43 | 1158.13 | 4407.0 |
| 2008-07-18 06:00:00 | ES | Futures | 1157.89 | 1160.45 | 1157.43 | 1158.59 | 8629.0 |
| 2008-07-18 06:30:00 | ES | Futures | 1158.59 | 1169.05 | 1158.13 | 1167.65 | 39522.0 |
| 2008-07-18 07:00:00 | ES | Futures | 1167.42 | 1171.14 | 1166.96 | 1170.21 | 29180.0 |
| 2008-07-18 07:30:00 | ES | Futures | 1169.98 | 1172.3 | 1168.82 | 1170.21 | 29586.0 |
| 2008-07-18 08:00:00 | ES | Futures | 1170.21 | 1173.23 | 1169.98 | 1173.0 | 24186.0 |
| 2008-07-18 08:30:00 | ES | Futures | 1173.0 | 1173.47 | 1168.82 | 1172.77 | 50626.0 |
| 2008-07-18 09:00:00 | ES | Futures | 1173.0 | 1173.93 | 1171.14 | 1173.0 | 53317.0 |
| 2008-07-18 09:30:00 | ES | Futures | 1173.23 | 1173.47 | 1164.4 | 1166.03 | 302605.0 |
| 2008-07-18 10:00:00 | ES | Futures | 1166.03 | 1168.82 | 1164.17 | 1168.12 | 181201.0 |
| 2008-07-18 10:30:00 | ES | Futures | 1168.12 | 1172.54 | 1165.56 | 1170.21 | 157855.0 |
| 2008-07-18 11:00:00 | ES | Futures | 1170.21 | 1174.16 | 1169.05 | 1172.3 | 159555.0 |
| 2008-07-18 11:30:00 | ES | Futures | 1172.3 | 1173.0 | 1168.12 | 1169.05 | 93776.0 |
| 2008-07-18 12:00:00 | ES | Futures | 1168.82 | 1170.44 | 1166.03 | 1166.49 | 78408.0 |
| 2008-07-18 12:30:00 | ES | Futures | 1166.49 | 1168.35 | 1164.17 | 1164.87 | 75144.0 |
| 2008-07-18 13:00:00 | ES | Futures | 1164.87 | 1167.65 | 1163.47 | 1167.19 | 82391.0 |
| 2008-07-18 13:30:00 | ES | Futures | 1166.96 | 1169.98 | 1165.56 | 1167.89 | 59430.0 |
| 2008-07-18 14:00:00 | ES | Futures | 1168.12 | 1171.14 | 1166.96 | 1170.21 | 45262.0 |
| 2008-07-18 14:30:00 | ES | Futures | 1169.98 | 1170.44 | 1165.33 | 1166.96 | 60611.0 |
| 2008-07-18 15:00:00 | ES | Futures | 1166.96 | 1169.28 | 1166.03 | 1168.35 | 58646.0 |
| 2008-07-18 15:30:00 | ES | Futures | 1168.35 | 1173.0 | 1168.12 | 1170.68 | 132849.0 |
| 2008-07-18 16:00:00 | ES | Futures | 1170.68 | 1172.07 | 1169.51 | 1171.84 | 84191.0 |
| 2008-07-18 00:00:00 | NQ | Futures | 2054.53 | 2055.38 | 2053.41 | 2053.69 | 279.0 |
| 2008-07-18 00:30:00 | NQ | Futures | 2053.41 | 2053.69 | 2050.6 | 2053.69 | 410.0 |
| 2008-07-18 01:00:00 | NQ | Futures | 2053.13 | 2053.13 | 2051.16 | 2051.16 | 45.0 |
| 2008-07-18 01:30:00 | NQ | Futures | 2051.16 | 2053.97 | 2050.88 | 2051.72 | 284.0 |
| 2008-07-18 02:00:00 | NQ | Futures | 2051.72 | 2054.81 | 2049.75 | 2053.97 | 416.0 |
| 2008-07-18 02:30:00 | NQ | Futures | 2053.69 | 2054.25 | 2050.31 | 2051.44 | 184.0 |
| 2008-07-18 03:00:00 | NQ | Futures | 2051.16 | 2056.78 | 2048.34 | 2056.22 | 1162.0 |
| 2008-07-18 03:30:00 | NQ | Futures | 2056.5 | 2061.0 | 2054.81 | 2058.47 | 1122.0 |
| 2008-07-18 04:00:00 | NQ | Futures | 2058.19 | 2058.19 | 2054.25 | 2055.94 | 531.0 |
| 2008-07-18 04:30:00 | NQ | Futures | 2055.94 | 2059.03 | 2054.81 | 2055.1 | 570.0 |
| 2008-07-18 05:00:00 | NQ | Futures | 2054.81 | 2055.1 | 2052.28 | 2053.41 | 1014.0 |
| 2008-07-18 05:30:00 | NQ | Futures | 2053.41 | 2055.1 | 2051.72 | 2053.13 | 587.0 |
| 2008-07-18 06:00:00 | NQ | Futures | 2053.41 | 2057.63 | 2052.28 | 2055.38 | 655.0 |
| 2008-07-18 06:30:00 | NQ | Futures | 2055.1 | 2071.41 | 2054.81 | 2070.0 | 3754.0 |
| 2008-07-18 07:00:00 | NQ | Futures | 2069.72 | 2075.35 | 2068.6 | 2073.1 | 2369.0 |
| 2008-07-18 07:30:00 | NQ | Futures | 2073.1 | 2074.79 | 2068.6 | 2071.41 | 2313.0 |
| 2008-07-18 08:00:00 | NQ | Futures | 2071.41 | 2079.85 | 2070.0 | 2079.29 | 4167.0 |
> showing 50 of 1,852 rows — these rows as CSV