PREVIEW / futures_30min / 2013-01-25
file: by_date/futures_30min/2013/2013-01-25.parquet size: 68 KB rows: 2,368
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 |
|---|---|---|---|---|---|---|---|
| 2013-01-25 00:00:00 | ES | Futures | 1526.97 | 1527.49 | 1526.72 | 1527.23 | 1747.0 |
| 2013-01-25 00:30:00 | ES | Futures | 1527.23 | 1528.77 | 1527.23 | 1528.0 | 3185.0 |
| 2013-01-25 01:00:00 | ES | Futures | 1528.26 | 1528.77 | 1528.0 | 1528.51 | 2236.0 |
| 2013-01-25 01:30:00 | ES | Futures | 1528.51 | 1529.28 | 1528.51 | 1529.03 | 1300.0 |
| 2013-01-25 02:00:00 | ES | Futures | 1529.03 | 1530.31 | 1529.03 | 1529.03 | 3273.0 |
| 2013-01-25 02:30:00 | ES | Futures | 1529.03 | 1531.08 | 1528.77 | 1530.82 | 5487.0 |
| 2013-01-25 03:00:00 | ES | Futures | 1530.82 | 1532.11 | 1530.05 | 1531.59 | 15395.0 |
| 2013-01-25 03:30:00 | ES | Futures | 1531.59 | 1534.93 | 1531.08 | 1533.9 | 29447.0 |
| 2013-01-25 04:00:00 | ES | Futures | 1534.16 | 1534.93 | 1533.13 | 1534.41 | 20062.0 |
| 2013-01-25 04:30:00 | ES | Futures | 1534.16 | 1534.67 | 1533.64 | 1534.41 | 8707.0 |
| 2013-01-25 05:00:00 | ES | Futures | 1534.16 | 1535.7 | 1533.9 | 1534.93 | 11068.0 |
| 2013-01-25 05:30:00 | ES | Futures | 1534.93 | 1535.7 | 1534.41 | 1534.41 | 11249.0 |
| 2013-01-25 06:00:00 | ES | Futures | 1534.41 | 1535.7 | 1533.64 | 1533.9 | 23483.0 |
| 2013-01-25 06:30:00 | ES | Futures | 1533.9 | 1535.18 | 1533.64 | 1534.67 | 12949.0 |
| 2013-01-25 07:00:00 | ES | Futures | 1534.41 | 1536.21 | 1534.41 | 1535.95 | 16773.0 |
| 2013-01-25 07:30:00 | ES | Futures | 1535.95 | 1536.98 | 1535.44 | 1535.44 | 23960.0 |
| 2013-01-25 08:00:00 | ES | Futures | 1535.7 | 1536.47 | 1534.41 | 1536.47 | 22454.0 |
| 2013-01-25 08:30:00 | ES | Futures | 1536.21 | 1536.47 | 1534.41 | 1534.93 | 16966.0 |
| 2013-01-25 09:00:00 | ES | Futures | 1534.93 | 1535.18 | 1533.9 | 1534.67 | 30091.0 |
| 2013-01-25 09:30:00 | ES | Futures | 1534.67 | 1536.98 | 1533.13 | 1536.21 | 155200.0 |
| 2013-01-25 10:00:00 | ES | Futures | 1536.21 | 1536.21 | 1530.31 | 1530.82 | 164139.0 |
| 2013-01-25 10:30:00 | ES | Futures | 1530.82 | 1532.36 | 1530.05 | 1531.85 | 111543.0 |
| 2013-01-25 11:00:00 | ES | Futures | 1531.85 | 1533.9 | 1531.34 | 1532.36 | 90021.0 |
| 2013-01-25 11:30:00 | ES | Futures | 1532.62 | 1533.9 | 1531.85 | 1531.85 | 54759.0 |
| 2013-01-25 12:00:00 | ES | Futures | 1531.85 | 1536.21 | 1531.85 | 1534.41 | 72037.0 |
| 2013-01-25 12:30:00 | ES | Futures | 1534.41 | 1535.44 | 1533.9 | 1534.16 | 36330.0 |
| 2013-01-25 13:00:00 | ES | Futures | 1534.41 | 1535.95 | 1534.16 | 1535.44 | 37276.0 |
| 2013-01-25 13:30:00 | ES | Futures | 1535.44 | 1537.49 | 1535.18 | 1536.72 | 52936.0 |
| 2013-01-25 14:00:00 | ES | Futures | 1536.72 | 1538.01 | 1536.21 | 1537.24 | 51327.0 |
| 2013-01-25 14:30:00 | ES | Futures | 1536.98 | 1538.26 | 1535.95 | 1536.21 | 52450.0 |
| 2013-01-25 15:00:00 | ES | Futures | 1536.21 | 1536.98 | 1534.93 | 1536.72 | 66302.0 |
| 2013-01-25 15:30:00 | ES | Futures | 1536.72 | 1538.01 | 1533.39 | 1537.75 | 199074.0 |
| 2013-01-25 16:00:00 | ES | Futures | 1537.75 | 1538.78 | 1534.41 | 1534.93 | 126485.0 |
| 2013-01-25 16:30:00 | ES | Futures | 1535.18 | 1535.7 | 1534.93 | 1535.44 | 6658.0 |
| 2013-01-25 17:00:00 | ES | Futures | 1535.18 | 1535.44 | 1534.93 | 1534.93 | 1319.0 |
| 2013-01-25 00:00:00 | NQ | Futures | 3161.01 | 3162.17 | 3160.72 | 3161.59 | 165.0 |
| 2013-01-25 00:30:00 | NQ | Futures | 3161.88 | 3163.92 | 3161.88 | 3163.63 | 265.0 |
| 2013-01-25 01:00:00 | NQ | Futures | 3163.34 | 3163.92 | 3163.05 | 3163.63 | 170.0 |
| 2013-01-25 01:30:00 | NQ | Futures | 3163.63 | 3165.09 | 3163.63 | 3164.5 | 72.0 |
| 2013-01-25 02:00:00 | NQ | Futures | 3165.09 | 3167.7 | 3165.09 | 3166.54 | 742.0 |
| 2013-01-25 02:30:00 | NQ | Futures | 3166.25 | 3169.16 | 3165.96 | 3169.16 | 755.0 |
| 2013-01-25 03:00:00 | NQ | Futures | 3169.16 | 3171.2 | 3167.12 | 3169.45 | 1724.0 |
| 2013-01-25 03:30:00 | NQ | Futures | 3169.74 | 3177.02 | 3168.87 | 3175.27 | 2426.0 |
| 2013-01-25 04:00:00 | NQ | Futures | 3174.98 | 3176.73 | 3172.94 | 3176.44 | 1749.0 |
| 2013-01-25 04:30:00 | NQ | Futures | 3176.15 | 3176.73 | 3174.11 | 3175.27 | 1005.0 |
| 2013-01-25 05:00:00 | NQ | Futures | 3175.27 | 3179.64 | 3174.98 | 3178.18 | 862.0 |
| 2013-01-25 05:30:00 | NQ | Futures | 3178.18 | 3180.22 | 3176.73 | 3176.73 | 956.0 |
| 2013-01-25 06:00:00 | NQ | Futures | 3176.73 | 3179.93 | 3174.4 | 3174.69 | 2094.0 |
| 2013-01-25 06:30:00 | NQ | Futures | 3174.98 | 3178.47 | 3174.4 | 3176.73 | 1332.0 |
| 2013-01-25 07:00:00 | NQ | Futures | 3176.44 | 3179.64 | 3176.44 | 3178.77 | 1152.0 |
> showing 50 of 2,368 rows — these rows as CSV