PREVIEW / futures_30min / 2008-07-13
file: by_date/futures_30min/2008/2008-07-13.parquet size: 19 KB rows: 425
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-13 18:00:00 | ES | Futures | 1152.78 | 1164.63 | 1152.78 | 1163.47 | 15185.0 |
| 2008-07-13 18:30:00 | ES | Futures | 1163.47 | 1165.33 | 1162.31 | 1163.24 | 6928.0 |
| 2008-07-13 19:00:00 | ES | Futures | 1163.24 | 1163.24 | 1161.38 | 1163.01 | 3726.0 |
| 2008-07-13 19:30:00 | ES | Futures | 1162.77 | 1163.47 | 1160.68 | 1162.08 | 3219.0 |
| 2008-07-13 20:00:00 | ES | Futures | 1162.08 | 1164.63 | 1161.15 | 1164.4 | 2641.0 |
| 2008-07-13 20:30:00 | ES | Futures | 1164.63 | 1164.87 | 1162.54 | 1163.01 | 2600.0 |
| 2008-07-13 21:00:00 | ES | Futures | 1163.01 | 1164.87 | 1163.01 | 1164.17 | 1366.0 |
| 2008-07-13 21:30:00 | ES | Futures | 1164.4 | 1166.96 | 1164.17 | 1166.03 | 4039.0 |
| 2008-07-13 22:00:00 | ES | Futures | 1166.26 | 1166.73 | 1165.33 | 1165.8 | 2174.0 |
| 2008-07-13 22:30:00 | ES | Futures | 1166.03 | 1166.49 | 1163.94 | 1163.94 | 1816.0 |
| 2008-07-13 23:00:00 | ES | Futures | 1164.17 | 1164.63 | 1162.77 | 1163.01 | 2350.0 |
| 2008-07-13 23:30:00 | ES | Futures | 1163.01 | 1163.24 | 1162.54 | 1163.24 | 950.0 |
| 2008-07-13 18:00:00 | NQ | Futures | 2045.25 | 2070.29 | 2045.25 | 2066.91 | 962.0 |
| 2008-07-13 18:30:00 | NQ | Futures | 2066.91 | 2070.57 | 2066.35 | 2066.91 | 414.0 |
| 2008-07-13 19:00:00 | NQ | Futures | 2067.19 | 2067.19 | 2064.38 | 2066.91 | 338.0 |
| 2008-07-13 19:30:00 | NQ | Futures | 2066.91 | 2066.91 | 2064.1 | 2064.94 | 436.0 |
| 2008-07-13 20:00:00 | NQ | Futures | 2065.5 | 2070.57 | 2065.22 | 2070.0 | 155.0 |
| 2008-07-13 20:30:00 | NQ | Futures | 2069.16 | 2070.85 | 2066.07 | 2066.07 | 255.0 |
| 2008-07-13 21:00:00 | NQ | Futures | 2067.75 | 2070.29 | 2067.19 | 2069.72 | 86.0 |
| 2008-07-13 21:30:00 | NQ | Futures | 2069.72 | 2074.5 | 2069.72 | 2073.94 | 307.0 |
| 2008-07-13 22:00:00 | NQ | Futures | 2073.66 | 2075.35 | 2071.13 | 2072.25 | 174.0 |
| 2008-07-13 22:30:00 | NQ | Futures | 2071.41 | 2072.25 | 2068.6 | 2069.16 | 230.0 |
| 2008-07-13 23:00:00 | NQ | Futures | 2068.88 | 2068.88 | 2066.91 | 2067.19 | 141.0 |
| 2008-07-13 23:30:00 | NQ | Futures | 2066.91 | 2067.47 | 2065.5 | 2066.35 | 127.0 |
| 2008-07-13 18:00:00 | YM | Futures | 10079.4 | 10170.3 | 10034.0 | 10161.2 | 820.0 |
| 2008-07-13 18:30:00 | YM | Futures | 10162.1 | 10170.3 | 10152.1 | 10154.9 | 274.0 |
| 2008-07-13 19:00:00 | YM | Futures | 10154.9 | 10156.7 | 10144.9 | 10153.9 | 143.0 |
| 2008-07-13 19:30:00 | YM | Futures | 10153.9 | 10154.9 | 10145.8 | 10150.3 | 224.0 |
| 2008-07-13 20:00:00 | YM | Futures | 10153.0 | 10169.4 | 10147.6 | 10164.8 | 175.0 |
| 2008-07-13 20:30:00 | YM | Futures | 10169.4 | 10169.4 | 10157.6 | 10158.5 | 225.0 |
| 2008-07-13 21:00:00 | YM | Futures | 10163.9 | 10171.2 | 10159.4 | 10163.9 | 132.0 |
| 2008-07-13 21:30:00 | YM | Futures | 10165.8 | 10185.8 | 10165.8 | 10176.7 | 453.0 |
| 2008-07-13 22:00:00 | YM | Futures | 10178.5 | 10180.3 | 10173.9 | 10178.5 | 106.0 |
| 2008-07-13 22:30:00 | YM | Futures | 10178.5 | 10178.5 | 10164.8 | 10164.8 | 157.0 |
| 2008-07-13 23:00:00 | YM | Futures | 10164.8 | 10169.4 | 10156.7 | 10156.7 | 91.0 |
| 2008-07-13 23:30:00 | YM | Futures | 10156.7 | 10158.5 | 10153.9 | 10156.7 | 82.0 |
| 2008-07-13 18:00:00 | CL | Futures | 549.1 | 550.47 | 546.94 | 547.09 | 602.0 |
| 2008-07-13 18:30:00 | CL | Futures | 547.13 | 548.27 | 546.75 | 547.09 | 388.0 |
| 2008-07-13 19:00:00 | CL | Futures | 547.05 | 547.05 | 540.75 | 544.97 | 1265.0 |
| 2008-07-13 19:30:00 | CL | Futures | 545.04 | 545.16 | 543.3 | 544.05 | 325.0 |
| 2008-07-13 20:00:00 | CL | Futures | 544.4 | 545.31 | 543.83 | 544.78 | 195.0 |
| 2008-07-13 20:30:00 | CL | Futures | 544.93 | 544.97 | 543.94 | 544.17 | 207.0 |
| 2008-07-13 21:00:00 | CL | Futures | 544.21 | 545.38 | 544.13 | 544.97 | 308.0 |
| 2008-07-13 21:30:00 | CL | Futures | 544.97 | 545.42 | 544.89 | 545.42 | 258.0 |
| 2008-07-13 22:00:00 | CL | Futures | 545.46 | 546.41 | 545.34 | 546.1 | 439.0 |
| 2008-07-13 22:30:00 | CL | Futures | 546.14 | 546.45 | 545.99 | 546.41 | 94.0 |
| 2008-07-13 23:00:00 | CL | Futures | 546.45 | 549.71 | 546.29 | 548.08 | 568.0 |
| 2008-07-13 23:30:00 | CL | Futures | 548.0 | 550.85 | 547.62 | 550.51 | 544.0 |
| 2008-07-13 18:00:00 | GC | Futures | 1393.6 | 1395.4 | 1387.6 | 1388.9 | 1518.0 |
| 2008-07-13 18:30:00 | GC | Futures | 1389.0 | 1393.2 | 1389.0 | 1391.1 | 629.0 |
> showing 50 of 425 rows — these rows as CSV