PREVIEW / futures_30min / 2014-05-01
file: by_date/futures_30min/2014/2014-05-01.parquet size: 63 KB rows: 2,493
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 |
|---|---|---|---|---|---|---|---|
| 2014-05-01 00:00:00 | ES | Futures | 1950.65 | 1950.91 | 1948.83 | 1949.61 | 3058.0 |
| 2014-05-01 00:30:00 | ES | Futures | 1949.87 | 1950.13 | 1949.35 | 1949.61 | 527.0 |
| 2014-05-01 01:00:00 | ES | Futures | 1949.87 | 1950.39 | 1949.61 | 1949.87 | 737.0 |
| 2014-05-01 01:30:00 | ES | Futures | 1949.87 | 1950.39 | 1949.61 | 1950.13 | 858.0 |
| 2014-05-01 02:00:00 | ES | Futures | 1950.13 | 1950.91 | 1949.87 | 1950.39 | 2127.0 |
| 2014-05-01 02:30:00 | ES | Futures | 1950.39 | 1950.65 | 1949.87 | 1950.39 | 951.0 |
| 2014-05-01 03:00:00 | ES | Futures | 1950.39 | 1950.91 | 1950.13 | 1950.65 | 1602.0 |
| 2014-05-01 03:30:00 | ES | Futures | 1950.65 | 1952.21 | 1950.65 | 1952.21 | 2444.0 |
| 2014-05-01 04:00:00 | ES | Futures | 1951.95 | 1952.47 | 1951.69 | 1952.47 | 1215.0 |
| 2014-05-01 04:30:00 | ES | Futures | 1952.21 | 1953.25 | 1951.95 | 1952.21 | 3187.0 |
| 2014-05-01 05:00:00 | ES | Futures | 1951.95 | 1952.47 | 1951.69 | 1951.95 | 815.0 |
| 2014-05-01 05:30:00 | ES | Futures | 1951.95 | 1952.21 | 1951.69 | 1951.95 | 598.0 |
| 2014-05-01 06:00:00 | ES | Futures | 1951.95 | 1952.21 | 1951.43 | 1951.69 | 1212.0 |
| 2014-05-01 06:30:00 | ES | Futures | 1951.69 | 1952.47 | 1951.69 | 1952.47 | 760.0 |
| 2014-05-01 07:00:00 | ES | Futures | 1952.47 | 1952.47 | 1950.65 | 1950.65 | 2940.0 |
| 2014-05-01 07:30:00 | ES | Futures | 1950.65 | 1951.17 | 1950.13 | 1950.39 | 2609.0 |
| 2014-05-01 08:00:00 | ES | Futures | 1950.65 | 1951.43 | 1950.39 | 1950.91 | 4178.0 |
| 2014-05-01 08:30:00 | ES | Futures | 1950.91 | 1951.43 | 1949.09 | 1949.61 | 9349.0 |
| 2014-05-01 09:00:00 | ES | Futures | 1949.61 | 1949.87 | 1948.83 | 1949.09 | 8200.0 |
| 2014-05-01 09:30:00 | ES | Futures | 1949.35 | 1952.21 | 1946.75 | 1948.05 | 121313.0 |
| 2014-05-01 10:00:00 | ES | Futures | 1948.31 | 1950.13 | 1943.9 | 1947.27 | 117922.0 |
| 2014-05-01 10:30:00 | ES | Futures | 1947.27 | 1952.73 | 1947.01 | 1951.69 | 89734.0 |
| 2014-05-01 11:00:00 | ES | Futures | 1951.43 | 1952.73 | 1950.13 | 1952.21 | 45613.0 |
| 2014-05-01 11:30:00 | ES | Futures | 1951.95 | 1955.58 | 1951.17 | 1951.95 | 85071.0 |
| 2014-05-01 12:00:00 | ES | Futures | 1951.95 | 1954.03 | 1951.17 | 1953.51 | 35773.0 |
| 2014-05-01 12:30:00 | ES | Futures | 1953.25 | 1953.77 | 1951.17 | 1952.21 | 29755.0 |
| 2014-05-01 13:00:00 | ES | Futures | 1952.21 | 1953.51 | 1950.65 | 1950.91 | 23250.0 |
| 2014-05-01 13:30:00 | ES | Futures | 1950.91 | 1951.69 | 1946.75 | 1947.79 | 53743.0 |
| 2014-05-01 14:00:00 | ES | Futures | 1947.79 | 1950.65 | 1947.27 | 1950.39 | 40396.0 |
| 2014-05-01 14:30:00 | ES | Futures | 1950.13 | 1950.91 | 1945.98 | 1948.31 | 54556.0 |
| 2014-05-01 15:00:00 | ES | Futures | 1948.31 | 1950.65 | 1946.24 | 1947.53 | 47851.0 |
| 2014-05-01 15:30:00 | ES | Futures | 1947.53 | 1950.65 | 1946.75 | 1950.39 | 74507.0 |
| 2014-05-01 16:00:00 | ES | Futures | 1950.65 | 1951.69 | 1949.35 | 1950.13 | 41982.0 |
| 2014-05-01 16:30:00 | ES | Futures | 1950.65 | 1951.69 | 1950.39 | 1951.43 | 4746.0 |
| 2014-05-01 17:00:00 | ES | Futures | 1951.69 | 1952.21 | 1951.43 | 1951.69 | 3272.0 |
| 2014-05-01 18:00:00 | ES | Futures | 1951.43 | 1952.21 | 1950.65 | 1951.43 | 2161.0 |
| 2014-05-01 18:30:00 | ES | Futures | 1951.69 | 1951.69 | 1950.91 | 1951.43 | 680.0 |
| 2014-05-01 19:00:00 | ES | Futures | 1951.69 | 1952.21 | 1951.43 | 1951.69 | 466.0 |
| 2014-05-01 19:30:00 | ES | Futures | 1951.69 | 1951.95 | 1950.91 | 1951.43 | 675.0 |
| 2014-05-01 20:00:00 | ES | Futures | 1951.43 | 1951.43 | 1950.65 | 1950.65 | 2311.0 |
| 2014-05-01 20:30:00 | ES | Futures | 1950.65 | 1951.69 | 1950.65 | 1951.69 | 787.0 |
| 2014-05-01 21:00:00 | ES | Futures | 1951.43 | 1951.69 | 1950.65 | 1951.17 | 901.0 |
| 2014-05-01 21:30:00 | ES | Futures | 1950.91 | 1951.43 | 1950.91 | 1951.43 | 528.0 |
| 2014-05-01 22:00:00 | ES | Futures | 1951.43 | 1951.69 | 1951.17 | 1951.43 | 996.0 |
| 2014-05-01 22:30:00 | ES | Futures | 1951.43 | 1951.69 | 1951.17 | 1951.43 | 831.0 |
| 2014-05-01 23:00:00 | ES | Futures | 1951.17 | 1951.69 | 1951.17 | 1951.43 | 332.0 |
| 2014-05-01 23:30:00 | ES | Futures | 1951.69 | 1951.95 | 1951.17 | 1951.17 | 788.0 |
| 2014-05-01 00:00:00 | NQ | Futures | 4166.52 | 4166.81 | 4161.86 | 4164.48 | 606.0 |
| 2014-05-01 00:30:00 | NQ | Futures | 4164.48 | 4165.35 | 4163.6 | 4164.48 | 193.0 |
| 2014-05-01 01:00:00 | NQ | Futures | 4164.77 | 4165.93 | 4164.19 | 4165.06 | 137.0 |
> showing 50 of 2,493 rows — these rows as CSV