PREVIEW / futures_30min / 2010-04-02
file: by_date/futures_30min/2010/2010-04-02.parquet size: 18 KB rows: 465
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-04-02 00:00:00 | ES | Futures | 1145.14 | 1145.38 | 1144.89 | 1145.14 | 589.0 |
| 2010-04-02 00:30:00 | ES | Futures | 1144.89 | 1145.63 | 1144.89 | 1145.38 | 265.0 |
| 2010-04-02 01:00:00 | ES | Futures | 1145.38 | 1145.87 | 1145.38 | 1145.38 | 409.0 |
| 2010-04-02 01:30:00 | ES | Futures | 1145.63 | 1145.87 | 1145.38 | 1145.87 | 232.0 |
| 2010-04-02 02:00:00 | ES | Futures | 1145.87 | 1146.85 | 1145.63 | 1146.6 | 1133.0 |
| 2010-04-02 02:30:00 | ES | Futures | 1146.85 | 1146.85 | 1146.6 | 1146.85 | 784.0 |
| 2010-04-02 03:00:00 | ES | Futures | 1146.6 | 1146.85 | 1146.36 | 1146.85 | 130.0 |
| 2010-04-02 03:30:00 | ES | Futures | 1146.6 | 1146.85 | 1146.36 | 1146.6 | 149.0 |
| 2010-04-02 04:00:00 | ES | Futures | 1146.85 | 1146.85 | 1146.11 | 1146.11 | 160.0 |
| 2010-04-02 04:30:00 | ES | Futures | 1146.36 | 1146.6 | 1146.11 | 1146.11 | 93.0 |
| 2010-04-02 05:00:00 | ES | Futures | 1146.36 | 1146.85 | 1146.36 | 1146.6 | 138.0 |
| 2010-04-02 05:30:00 | ES | Futures | 1146.6 | 1146.85 | 1146.36 | 1146.36 | 448.0 |
| 2010-04-02 06:00:00 | ES | Futures | 1146.36 | 1146.85 | 1146.36 | 1146.6 | 527.0 |
| 2010-04-02 06:30:00 | ES | Futures | 1146.6 | 1146.85 | 1146.11 | 1146.36 | 549.0 |
| 2010-04-02 07:00:00 | ES | Futures | 1146.36 | 1146.6 | 1145.63 | 1146.11 | 708.0 |
| 2010-04-02 07:30:00 | ES | Futures | 1146.11 | 1146.6 | 1145.63 | 1146.11 | 1087.0 |
| 2010-04-02 08:00:00 | ES | Futures | 1146.11 | 1147.58 | 1145.38 | 1147.34 | 7950.0 |
| 2010-04-02 08:30:00 | ES | Futures | 1146.6 | 1152.47 | 1144.16 | 1150.27 | 55049.0 |
| 2010-04-02 09:00:00 | ES | Futures | 1150.27 | 1152.23 | 1150.03 | 1151.74 | 16287.0 |
| 2010-04-02 00:00:00 | NQ | Futures | 2236.0 | 2236.86 | 2235.71 | 2236.0 | 101.0 |
| 2010-04-02 00:30:00 | NQ | Futures | 2236.0 | 2236.28 | 2236.0 | 2236.0 | 19.0 |
| 2010-04-02 01:00:00 | NQ | Futures | 2236.28 | 2236.28 | 2236.0 | 2236.0 | 9.0 |
| 2010-04-02 01:30:00 | NQ | Futures | 2235.71 | 2236.57 | 2235.42 | 2235.71 | 53.0 |
| 2010-04-02 02:00:00 | NQ | Futures | 2236.28 | 2237.14 | 2236.0 | 2236.57 | 75.0 |
| 2010-04-02 02:30:00 | NQ | Futures | 2237.14 | 2237.43 | 2237.14 | 2237.43 | 29.0 |
| 2010-04-02 03:00:00 | NQ | Futures | 2237.14 | 2238.29 | 2237.14 | 2238.29 | 37.0 |
| 2010-04-02 03:30:00 | NQ | Futures | 2238.0 | 2238.29 | 2237.72 | 2238.29 | 35.0 |
| 2010-04-02 04:00:00 | NQ | Futures | 2238.0 | 2238.0 | 2237.72 | 2238.0 | 87.0 |
| 2010-04-02 04:30:00 | NQ | Futures | 2238.0 | 2238.29 | 2237.72 | 2238.0 | 16.0 |
| 2010-04-02 05:00:00 | NQ | Futures | 2237.72 | 2238.0 | 2237.72 | 2237.72 | 4.0 |
| 2010-04-02 05:30:00 | NQ | Futures | 2238.0 | 2238.29 | 2237.72 | 2238.0 | 19.0 |
| 2010-04-02 06:00:00 | NQ | Futures | 2238.0 | 2238.86 | 2237.72 | 2238.29 | 12.0 |
| 2010-04-02 06:30:00 | NQ | Futures | 2238.57 | 2238.57 | 2238.0 | 2238.29 | 21.0 |
| 2010-04-02 07:00:00 | NQ | Futures | 2238.0 | 2238.0 | 2236.86 | 2237.14 | 133.0 |
| 2010-04-02 07:30:00 | NQ | Futures | 2237.14 | 2237.72 | 2236.0 | 2236.57 | 128.0 |
| 2010-04-02 08:00:00 | NQ | Futures | 2236.86 | 2239.15 | 2236.57 | 2238.29 | 467.0 |
| 2010-04-02 08:30:00 | NQ | Futures | 2238.29 | 2248.02 | 2232.27 | 2245.16 | 3363.0 |
| 2010-04-02 09:00:00 | NQ | Futures | 2245.16 | 2247.45 | 2244.59 | 2246.88 | 832.0 |
| 2010-04-02 00:00:00 | YM | Futures | 10208.7 | 10209.6 | 10206.8 | 10207.8 | 31.0 |
| 2010-04-02 00:30:00 | YM | Futures | 10208.7 | 10208.7 | 10206.8 | 10208.7 | 15.0 |
| 2010-04-02 01:00:00 | YM | Futures | 10209.6 | 10212.5 | 10209.6 | 10209.6 | 71.0 |
| 2010-04-02 01:30:00 | YM | Futures | 10210.6 | 10211.5 | 10209.6 | 10209.6 | 30.0 |
| 2010-04-02 02:00:00 | YM | Futures | 10211.5 | 10219.0 | 10209.6 | 10215.3 | 31.0 |
| 2010-04-02 02:30:00 | YM | Futures | 10219.0 | 10220.0 | 10217.2 | 10220.0 | 16.0 |
| 2010-04-02 03:00:00 | YM | Futures | 10217.2 | 10217.2 | 10217.2 | 10217.2 | 1.0 |
| 2010-04-02 03:30:00 | YM | Futures | 10217.2 | 10218.1 | 10213.4 | 10213.4 | 7.0 |
| 2010-04-02 04:00:00 | YM | Futures | 10214.3 | 10214.3 | 10212.5 | 10213.4 | 12.0 |
| 2010-04-02 04:30:00 | YM | Futures | 10213.4 | 10219.0 | 10210.6 | 10215.3 | 31.0 |
| 2010-04-02 05:00:00 | YM | Futures | 10218.1 | 10219.0 | 10217.2 | 10217.2 | 34.0 |
| 2010-04-02 05:30:00 | YM | Futures | 10218.1 | 10218.1 | 10217.2 | 10217.2 | 6.0 |
> showing 50 of 465 rows — these rows as CSV