PREVIEW / futures_1hour / 2010-10-13
file: by_date/futures_1hour/2010/2010-10-13.parquet size: 48 KB rows: 1,442
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-10-13 00:00:00 | ES | Futures | 1149.33 | 1150.07 | 1149.08 | 1149.33 | 3073.0 |
| 2010-10-13 01:00:00 | ES | Futures | 1149.33 | 1149.33 | 1148.35 | 1148.84 | 7111.0 |
| 2010-10-13 02:00:00 | ES | Futures | 1148.84 | 1151.3 | 1148.59 | 1150.32 | 11682.0 |
| 2010-10-13 03:00:00 | ES | Futures | 1150.32 | 1153.27 | 1150.32 | 1153.27 | 34415.0 |
| 2010-10-13 04:00:00 | ES | Futures | 1153.03 | 1155.74 | 1152.78 | 1154.51 | 35028.0 |
| 2010-10-13 05:00:00 | ES | Futures | 1154.51 | 1157.22 | 1154.51 | 1156.73 | 28886.0 |
| 2010-10-13 06:00:00 | ES | Futures | 1156.48 | 1157.46 | 1155.74 | 1156.73 | 20101.0 |
| 2010-10-13 07:00:00 | ES | Futures | 1156.97 | 1157.96 | 1155.0 | 1156.73 | 44784.0 |
| 2010-10-13 08:00:00 | ES | Futures | 1156.73 | 1158.2 | 1155.49 | 1156.48 | 68594.0 |
| 2010-10-13 09:00:00 | ES | Futures | 1156.48 | 1157.22 | 1152.78 | 1156.48 | 314415.0 |
| 2010-10-13 10:00:00 | ES | Futures | 1156.48 | 1159.68 | 1155.25 | 1159.44 | 343912.0 |
| 2010-10-13 11:00:00 | ES | Futures | 1159.68 | 1161.65 | 1158.45 | 1159.93 | 248689.0 |
| 2010-10-13 12:00:00 | ES | Futures | 1159.93 | 1163.13 | 1159.93 | 1161.9 | 143999.0 |
| 2010-10-13 13:00:00 | ES | Futures | 1161.9 | 1163.38 | 1160.92 | 1162.39 | 113665.0 |
| 2010-10-13 14:00:00 | ES | Futures | 1162.39 | 1164.37 | 1160.67 | 1161.16 | 212861.0 |
| 2010-10-13 15:00:00 | ES | Futures | 1161.16 | 1162.39 | 1156.97 | 1157.71 | 385288.0 |
| 2010-10-13 16:00:00 | ES | Futures | 1157.96 | 1158.7 | 1157.22 | 1157.46 | 93578.0 |
| 2010-10-13 17:00:00 | ES | Futures | 1157.46 | 1157.96 | 1157.22 | 1157.71 | 2498.0 |
| 2010-10-13 18:00:00 | ES | Futures | 1157.71 | 1157.71 | 1156.97 | 1157.46 | 2950.0 |
| 2010-10-13 19:00:00 | ES | Futures | 1157.46 | 1158.45 | 1157.22 | 1157.71 | 4873.0 |
| 2010-10-13 20:00:00 | ES | Futures | 1157.96 | 1161.9 | 1157.71 | 1160.92 | 15964.0 |
| 2010-10-13 21:00:00 | ES | Futures | 1160.92 | 1163.13 | 1160.67 | 1162.39 | 11168.0 |
| 2010-10-13 22:00:00 | ES | Futures | 1162.89 | 1162.89 | 1160.42 | 1160.67 | 8434.0 |
| 2010-10-13 23:00:00 | ES | Futures | 1160.67 | 1161.65 | 1159.68 | 1161.65 | 5934.0 |
| 2010-10-13 00:00:00 | NQ | Futures | 2339.69 | 2342.56 | 2339.12 | 2342.27 | 176.0 |
| 2010-10-13 01:00:00 | NQ | Futures | 2341.41 | 2341.41 | 2339.12 | 2340.26 | 423.0 |
| 2010-10-13 02:00:00 | NQ | Futures | 2339.98 | 2345.71 | 2339.98 | 2344.28 | 746.0 |
| 2010-10-13 03:00:00 | NQ | Futures | 2344.28 | 2349.16 | 2343.71 | 2349.16 | 2837.0 |
| 2010-10-13 04:00:00 | NQ | Futures | 2348.87 | 2354.61 | 2348.58 | 2351.45 | 2564.0 |
| 2010-10-13 05:00:00 | NQ | Futures | 2351.45 | 2359.77 | 2351.45 | 2357.76 | 3409.0 |
| 2010-10-13 06:00:00 | NQ | Futures | 2357.48 | 2358.05 | 2355.18 | 2356.9 | 1811.0 |
| 2010-10-13 07:00:00 | NQ | Futures | 2356.9 | 2358.34 | 2353.17 | 2356.62 | 3053.0 |
| 2010-10-13 08:00:00 | NQ | Futures | 2356.62 | 2358.91 | 2354.32 | 2354.61 | 5289.0 |
| 2010-10-13 09:00:00 | NQ | Futures | 2354.9 | 2356.33 | 2347.72 | 2351.74 | 43353.0 |
| 2010-10-13 10:00:00 | NQ | Futures | 2352.03 | 2362.07 | 2351.74 | 2362.07 | 45282.0 |
| 2010-10-13 11:00:00 | NQ | Futures | 2362.07 | 2365.51 | 2360.35 | 2362.36 | 35203.0 |
| 2010-10-13 12:00:00 | NQ | Futures | 2362.36 | 2366.95 | 2360.92 | 2363.79 | 20013.0 |
| 2010-10-13 13:00:00 | NQ | Futures | 2363.5 | 2368.38 | 2360.92 | 2367.23 | 29461.0 |
| 2010-10-13 14:00:00 | NQ | Futures | 2367.23 | 2370.1 | 2360.92 | 2364.94 | 36284.0 |
| 2010-10-13 15:00:00 | NQ | Futures | 2364.94 | 2367.52 | 2356.9 | 2359.2 | 54015.0 |
| 2010-10-13 16:00:00 | NQ | Futures | 2359.2 | 2360.92 | 2358.34 | 2359.49 | 8728.0 |
| 2010-10-13 17:00:00 | NQ | Futures | 2359.49 | 2360.06 | 2358.91 | 2359.49 | 81.0 |
| 2010-10-13 18:00:00 | NQ | Futures | 2359.49 | 2359.49 | 2358.05 | 2358.63 | 118.0 |
| 2010-10-13 19:00:00 | NQ | Futures | 2358.34 | 2360.35 | 2358.05 | 2358.63 | 1534.0 |
| 2010-10-13 20:00:00 | NQ | Futures | 2358.91 | 2367.52 | 2358.91 | 2366.37 | 924.0 |
| 2010-10-13 21:00:00 | NQ | Futures | 2365.8 | 2369.53 | 2364.94 | 2368.09 | 626.0 |
| 2010-10-13 22:00:00 | NQ | Futures | 2368.09 | 2368.09 | 2364.65 | 2364.94 | 381.0 |
| 2010-10-13 23:00:00 | NQ | Futures | 2365.51 | 2366.95 | 2363.5 | 2366.37 | 255.0 |
| 2010-10-13 00:00:00 | YM | Futures | 10443.0 | 10448.7 | 10442.0 | 10447.7 | 130.0 |
| 2010-10-13 01:00:00 | YM | Futures | 10446.8 | 10446.8 | 10438.2 | 10444.9 | 262.0 |
> showing 50 of 1,442 rows — these rows as CSV