PREVIEW / futures_30min / 2013-04-26
file: by_date/futures_30min/2013/2013-04-26.parquet size: 65 KB rows: 2,337
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-04-26 00:00:00 | ES | Futures | 1625.61 | 1626.65 | 1625.1 | 1626.39 | 1516.0 |
| 2013-04-26 00:30:00 | ES | Futures | 1626.13 | 1626.65 | 1625.61 | 1626.13 | 1378.0 |
| 2013-04-26 01:00:00 | ES | Futures | 1626.13 | 1626.65 | 1625.36 | 1625.61 | 3203.0 |
| 2013-04-26 01:30:00 | ES | Futures | 1625.87 | 1626.9 | 1625.61 | 1626.9 | 1330.0 |
| 2013-04-26 02:00:00 | ES | Futures | 1626.9 | 1628.19 | 1626.13 | 1627.93 | 5608.0 |
| 2013-04-26 02:30:00 | ES | Futures | 1627.93 | 1629.48 | 1627.68 | 1628.96 | 5558.0 |
| 2013-04-26 03:00:00 | ES | Futures | 1628.96 | 1629.74 | 1625.36 | 1625.87 | 16291.0 |
| 2013-04-26 03:30:00 | ES | Futures | 1626.13 | 1627.16 | 1625.36 | 1626.39 | 9184.0 |
| 2013-04-26 04:00:00 | ES | Futures | 1626.39 | 1627.16 | 1625.87 | 1626.9 | 8169.0 |
| 2013-04-26 04:30:00 | ES | Futures | 1626.65 | 1627.16 | 1624.33 | 1625.1 | 14095.0 |
| 2013-04-26 05:00:00 | ES | Futures | 1625.1 | 1625.36 | 1623.81 | 1624.58 | 9416.0 |
| 2013-04-26 05:30:00 | ES | Futures | 1624.58 | 1625.87 | 1624.33 | 1625.61 | 8677.0 |
| 2013-04-26 06:00:00 | ES | Futures | 1625.36 | 1625.61 | 1624.33 | 1624.84 | 8860.0 |
| 2013-04-26 06:30:00 | ES | Futures | 1625.1 | 1625.36 | 1623.04 | 1625.1 | 12146.0 |
| 2013-04-26 07:00:00 | ES | Futures | 1625.1 | 1626.9 | 1624.33 | 1625.61 | 12927.0 |
| 2013-04-26 07:30:00 | ES | Futures | 1625.36 | 1626.39 | 1625.1 | 1625.1 | 7337.0 |
| 2013-04-26 08:00:00 | ES | Futures | 1625.1 | 1626.9 | 1624.58 | 1625.87 | 15394.0 |
| 2013-04-26 08:30:00 | ES | Futures | 1625.61 | 1625.87 | 1622.27 | 1625.61 | 48854.0 |
| 2013-04-26 09:00:00 | ES | Futures | 1625.36 | 1627.68 | 1624.84 | 1626.65 | 24268.0 |
| 2013-04-26 09:30:00 | ES | Futures | 1626.65 | 1629.22 | 1624.07 | 1628.71 | 151208.0 |
| 2013-04-26 10:00:00 | ES | Futures | 1628.71 | 1629.48 | 1622.52 | 1625.61 | 146082.0 |
| 2013-04-26 10:30:00 | ES | Futures | 1625.36 | 1626.13 | 1622.27 | 1623.55 | 106638.0 |
| 2013-04-26 11:00:00 | ES | Futures | 1623.81 | 1625.87 | 1623.04 | 1624.33 | 85873.0 |
| 2013-04-26 11:30:00 | ES | Futures | 1624.58 | 1625.1 | 1621.24 | 1621.75 | 89566.0 |
| 2013-04-26 12:00:00 | ES | Futures | 1621.75 | 1623.04 | 1620.21 | 1621.49 | 76441.0 |
| 2013-04-26 12:30:00 | ES | Futures | 1621.49 | 1623.55 | 1620.72 | 1623.3 | 43355.0 |
| 2013-04-26 13:00:00 | ES | Futures | 1623.3 | 1626.13 | 1622.52 | 1625.61 | 52112.0 |
| 2013-04-26 13:30:00 | ES | Futures | 1625.61 | 1626.9 | 1624.58 | 1625.87 | 40614.0 |
| 2013-04-26 14:00:00 | ES | Futures | 1625.61 | 1626.65 | 1624.58 | 1625.36 | 33730.0 |
| 2013-04-26 14:30:00 | ES | Futures | 1625.36 | 1627.16 | 1624.58 | 1625.61 | 37385.0 |
| 2013-04-26 15:00:00 | ES | Futures | 1625.87 | 1629.22 | 1625.61 | 1628.71 | 54928.0 |
| 2013-04-26 15:30:00 | ES | Futures | 1628.96 | 1629.22 | 1625.36 | 1625.87 | 101362.0 |
| 2013-04-26 16:00:00 | ES | Futures | 1625.87 | 1626.13 | 1623.81 | 1624.33 | 60063.0 |
| 2013-04-26 16:30:00 | ES | Futures | 1624.33 | 1625.36 | 1624.07 | 1624.58 | 5356.0 |
| 2013-04-26 17:00:00 | ES | Futures | 1624.58 | 1625.1 | 1624.33 | 1624.58 | 1706.0 |
| 2013-04-26 00:00:00 | NQ | Futures | 3308.97 | 3311.02 | 3308.1 | 3310.72 | 307.0 |
| 2013-04-26 00:30:00 | NQ | Futures | 3310.14 | 3310.72 | 3308.97 | 3310.43 | 250.0 |
| 2013-04-26 01:00:00 | NQ | Futures | 3310.72 | 3311.02 | 3308.1 | 3308.68 | 278.0 |
| 2013-04-26 01:30:00 | NQ | Futures | 3308.68 | 3310.43 | 3308.39 | 3310.43 | 113.0 |
| 2013-04-26 02:00:00 | NQ | Futures | 3310.72 | 3313.35 | 3310.72 | 3313.06 | 574.0 |
| 2013-04-26 02:30:00 | NQ | Futures | 3313.06 | 3316.27 | 3312.77 | 3314.81 | 439.0 |
| 2013-04-26 03:00:00 | NQ | Futures | 3314.52 | 3316.56 | 3308.68 | 3309.85 | 2228.0 |
| 2013-04-26 03:30:00 | NQ | Futures | 3309.85 | 3312.47 | 3308.97 | 3310.72 | 898.0 |
| 2013-04-26 04:00:00 | NQ | Futures | 3311.31 | 3312.77 | 3309.56 | 3311.6 | 880.0 |
| 2013-04-26 04:30:00 | NQ | Futures | 3311.6 | 3312.18 | 3304.89 | 3307.52 | 1566.0 |
| 2013-04-26 05:00:00 | NQ | Futures | 3307.52 | 3308.1 | 3304.6 | 3308.1 | 1070.0 |
| 2013-04-26 05:30:00 | NQ | Futures | 3308.1 | 3310.14 | 3307.22 | 3309.27 | 1334.0 |
| 2013-04-26 06:00:00 | NQ | Futures | 3309.27 | 3309.56 | 3307.22 | 3307.81 | 2113.0 |
| 2013-04-26 06:30:00 | NQ | Futures | 3307.81 | 3308.39 | 3304.6 | 3307.81 | 1243.0 |
| 2013-04-26 07:00:00 | NQ | Futures | 3307.52 | 3310.43 | 3305.47 | 3306.93 | 2085.0 |
> showing 50 of 2,337 rows — these rows as CSV