PREVIEW / futures_30min / 2010-04-30
file: by_date/futures_30min/2010/2010-04-30.parquet size: 63 KB rows: 2,088
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-04-30 00:00:00 | ES | Futures | 1177.4 | 1178.13 | 1176.91 | 1177.65 | 2865.0 |
| 2010-04-30 00:30:00 | ES | Futures | 1177.65 | 1177.89 | 1176.18 | 1176.67 | 1298.0 |
| 2010-04-30 01:00:00 | ES | Futures | 1176.42 | 1176.67 | 1175.2 | 1175.69 | 1545.0 |
| 2010-04-30 01:30:00 | ES | Futures | 1175.69 | 1176.42 | 1175.2 | 1175.2 | 1553.0 |
| 2010-04-30 02:00:00 | ES | Futures | 1175.2 | 1176.91 | 1174.96 | 1176.91 | 2445.0 |
| 2010-04-30 02:30:00 | ES | Futures | 1176.91 | 1177.89 | 1176.42 | 1177.89 | 2996.0 |
| 2010-04-30 03:00:00 | ES | Futures | 1177.65 | 1179.85 | 1177.16 | 1179.6 | 18722.0 |
| 2010-04-30 03:30:00 | ES | Futures | 1179.36 | 1180.33 | 1178.87 | 1180.09 | 15993.0 |
| 2010-04-30 04:00:00 | ES | Futures | 1180.33 | 1180.82 | 1179.11 | 1179.11 | 10761.0 |
| 2010-04-30 04:30:00 | ES | Futures | 1179.11 | 1181.07 | 1179.11 | 1180.82 | 12244.0 |
| 2010-04-30 05:00:00 | ES | Futures | 1180.58 | 1180.82 | 1179.11 | 1179.36 | 6418.0 |
| 2010-04-30 05:30:00 | ES | Futures | 1179.36 | 1180.09 | 1177.65 | 1179.6 | 11637.0 |
| 2010-04-30 06:00:00 | ES | Futures | 1179.36 | 1180.33 | 1178.38 | 1179.6 | 7518.0 |
| 2010-04-30 06:30:00 | ES | Futures | 1179.6 | 1179.85 | 1176.67 | 1177.4 | 13045.0 |
| 2010-04-30 07:00:00 | ES | Futures | 1177.65 | 1179.85 | 1176.42 | 1179.6 | 15030.0 |
| 2010-04-30 07:30:00 | ES | Futures | 1179.36 | 1180.33 | 1179.36 | 1180.09 | 13477.0 |
| 2010-04-30 08:00:00 | ES | Futures | 1180.09 | 1180.33 | 1179.36 | 1179.85 | 16103.0 |
| 2010-04-30 08:30:00 | ES | Futures | 1179.85 | 1180.09 | 1176.91 | 1176.91 | 55270.0 |
| 2010-04-30 09:00:00 | ES | Futures | 1177.16 | 1177.89 | 1176.42 | 1177.16 | 32733.0 |
| 2010-04-30 09:30:00 | ES | Futures | 1177.16 | 1178.62 | 1173.73 | 1173.73 | 221539.0 |
| 2010-04-30 10:00:00 | ES | Futures | 1173.73 | 1174.96 | 1166.89 | 1171.05 | 354299.0 |
| 2010-04-30 10:30:00 | ES | Futures | 1171.05 | 1175.69 | 1169.58 | 1173.98 | 236215.0 |
| 2010-04-30 11:00:00 | ES | Futures | 1173.73 | 1175.2 | 1171.54 | 1172.02 | 153446.0 |
| 2010-04-30 11:30:00 | ES | Futures | 1172.27 | 1174.22 | 1171.54 | 1173.49 | 79843.0 |
| 2010-04-30 12:00:00 | ES | Futures | 1173.49 | 1173.73 | 1165.18 | 1166.16 | 218791.0 |
| 2010-04-30 12:30:00 | ES | Futures | 1165.91 | 1167.14 | 1162.0 | 1163.22 | 179168.0 |
| 2010-04-30 13:00:00 | ES | Futures | 1163.22 | 1165.91 | 1161.76 | 1165.67 | 128760.0 |
| 2010-04-30 13:30:00 | ES | Futures | 1165.67 | 1167.87 | 1164.45 | 1165.18 | 81018.0 |
| 2010-04-30 14:00:00 | ES | Futures | 1165.18 | 1167.14 | 1163.71 | 1166.16 | 75346.0 |
| 2010-04-30 14:30:00 | ES | Futures | 1166.16 | 1166.4 | 1160.29 | 1161.76 | 145413.0 |
| 2010-04-30 15:00:00 | ES | Futures | 1161.51 | 1163.71 | 1160.29 | 1161.51 | 152562.0 |
| 2010-04-30 15:30:00 | ES | Futures | 1161.51 | 1162.49 | 1156.38 | 1157.11 | 425095.0 |
| 2010-04-30 16:00:00 | ES | Futures | 1157.11 | 1160.29 | 1156.87 | 1159.31 | 162034.0 |
| 2010-04-30 00:00:00 | NQ | Futures | 2336.23 | 2340.52 | 2335.94 | 2339.09 | 785.0 |
| 2010-04-30 00:30:00 | NQ | Futures | 2339.09 | 2339.09 | 2335.65 | 2336.51 | 193.0 |
| 2010-04-30 01:00:00 | NQ | Futures | 2336.8 | 2336.8 | 2334.51 | 2334.8 | 103.0 |
| 2010-04-30 01:30:00 | NQ | Futures | 2334.8 | 2335.65 | 2334.22 | 2334.51 | 59.0 |
| 2010-04-30 02:00:00 | NQ | Futures | 2334.22 | 2336.23 | 2334.22 | 2335.94 | 141.0 |
| 2010-04-30 02:30:00 | NQ | Futures | 2336.23 | 2338.23 | 2335.94 | 2338.23 | 242.0 |
| 2010-04-30 03:00:00 | NQ | Futures | 2338.23 | 2341.38 | 2337.37 | 2340.52 | 1142.0 |
| 2010-04-30 03:30:00 | NQ | Futures | 2340.24 | 2341.96 | 2339.66 | 2341.67 | 615.0 |
| 2010-04-30 04:00:00 | NQ | Futures | 2341.96 | 2342.53 | 2340.81 | 2340.81 | 675.0 |
| 2010-04-30 04:30:00 | NQ | Futures | 2341.1 | 2344.82 | 2341.1 | 2343.39 | 980.0 |
| 2010-04-30 05:00:00 | NQ | Futures | 2343.67 | 2344.25 | 2341.38 | 2342.53 | 586.0 |
| 2010-04-30 05:30:00 | NQ | Futures | 2342.24 | 2343.67 | 2339.38 | 2342.24 | 1559.0 |
| 2010-04-30 06:00:00 | NQ | Futures | 2341.96 | 2343.1 | 2340.24 | 2342.53 | 376.0 |
| 2010-04-30 06:30:00 | NQ | Futures | 2341.96 | 2342.53 | 2335.94 | 2338.23 | 1301.0 |
| 2010-04-30 07:00:00 | NQ | Futures | 2337.37 | 2341.96 | 2336.23 | 2341.96 | 788.0 |
| 2010-04-30 07:30:00 | NQ | Futures | 2341.96 | 2343.39 | 2341.1 | 2343.1 | 831.0 |
| 2010-04-30 08:00:00 | NQ | Futures | 2343.1 | 2344.25 | 2342.24 | 2342.24 | 1264.0 |
> showing 50 of 2,088 rows — these rows as CSV