PREVIEW / futures_30min / 2012-04-09
file: by_date/futures_30min/2012/2012-04-09.parquet size: 59 KB rows: 2,108
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 |
|---|---|---|---|---|---|---|---|
| 2012-04-09 00:00:00 | ES | Futures | 1391.67 | 1392.17 | 1390.91 | 1391.41 | 715.0 |
| 2012-04-09 00:30:00 | ES | Futures | 1391.41 | 1391.67 | 1390.91 | 1391.41 | 523.0 |
| 2012-04-09 01:00:00 | ES | Futures | 1391.41 | 1392.43 | 1391.41 | 1392.17 | 1111.0 |
| 2012-04-09 01:30:00 | ES | Futures | 1392.43 | 1392.68 | 1391.92 | 1392.43 | 1101.0 |
| 2012-04-09 02:00:00 | ES | Futures | 1392.43 | 1392.93 | 1391.92 | 1392.68 | 998.0 |
| 2012-04-09 02:30:00 | ES | Futures | 1392.43 | 1392.93 | 1392.17 | 1392.17 | 752.0 |
| 2012-04-09 03:00:00 | ES | Futures | 1392.17 | 1392.43 | 1390.91 | 1391.41 | 1365.0 |
| 2012-04-09 03:30:00 | ES | Futures | 1391.41 | 1391.92 | 1391.16 | 1391.67 | 1016.0 |
| 2012-04-09 04:00:00 | ES | Futures | 1391.92 | 1392.93 | 1391.67 | 1392.43 | 1428.0 |
| 2012-04-09 04:30:00 | ES | Futures | 1391.92 | 1392.43 | 1391.67 | 1392.17 | 885.0 |
| 2012-04-09 05:00:00 | ES | Futures | 1392.43 | 1394.7 | 1392.17 | 1393.94 | 4784.0 |
| 2012-04-09 05:30:00 | ES | Futures | 1393.69 | 1394.2 | 1391.16 | 1391.41 | 3166.0 |
| 2012-04-09 06:00:00 | ES | Futures | 1391.67 | 1392.17 | 1391.16 | 1391.92 | 1886.0 |
| 2012-04-09 06:30:00 | ES | Futures | 1391.67 | 1391.92 | 1390.66 | 1391.41 | 3472.0 |
| 2012-04-09 07:00:00 | ES | Futures | 1391.41 | 1393.18 | 1391.16 | 1392.93 | 4501.0 |
| 2012-04-09 07:30:00 | ES | Futures | 1392.93 | 1393.44 | 1390.66 | 1391.41 | 7229.0 |
| 2012-04-09 08:00:00 | ES | Futures | 1391.41 | 1391.92 | 1390.91 | 1391.16 | 9229.0 |
| 2012-04-09 08:30:00 | ES | Futures | 1391.16 | 1392.17 | 1391.16 | 1392.17 | 7013.0 |
| 2012-04-09 09:00:00 | ES | Futures | 1391.92 | 1392.43 | 1390.91 | 1391.41 | 25841.0 |
| 2012-04-09 09:30:00 | ES | Futures | 1391.67 | 1393.94 | 1389.64 | 1390.66 | 153817.0 |
| 2012-04-09 10:00:00 | ES | Futures | 1390.66 | 1395.21 | 1390.66 | 1394.2 | 112862.0 |
| 2012-04-09 10:30:00 | ES | Futures | 1394.2 | 1394.45 | 1392.43 | 1394.2 | 75017.0 |
| 2012-04-09 11:00:00 | ES | Futures | 1393.94 | 1394.2 | 1390.4 | 1390.66 | 63165.0 |
| 2012-04-09 11:30:00 | ES | Futures | 1390.66 | 1392.93 | 1390.66 | 1392.68 | 32138.0 |
| 2012-04-09 12:00:00 | ES | Futures | 1392.68 | 1394.2 | 1391.92 | 1393.94 | 33639.0 |
| 2012-04-09 12:30:00 | ES | Futures | 1393.94 | 1396.47 | 1393.69 | 1395.71 | 54676.0 |
| 2012-04-09 13:00:00 | ES | Futures | 1395.71 | 1396.47 | 1393.94 | 1394.2 | 40373.0 |
| 2012-04-09 13:30:00 | ES | Futures | 1394.2 | 1397.99 | 1394.2 | 1397.49 | 42023.0 |
| 2012-04-09 14:00:00 | ES | Futures | 1397.74 | 1397.99 | 1395.71 | 1397.23 | 37903.0 |
| 2012-04-09 14:30:00 | ES | Futures | 1397.23 | 1399.26 | 1396.73 | 1397.99 | 44534.0 |
| 2012-04-09 15:00:00 | ES | Futures | 1397.99 | 1399.0 | 1396.22 | 1396.22 | 34219.0 |
| 2012-04-09 15:30:00 | ES | Futures | 1396.22 | 1396.73 | 1393.44 | 1393.69 | 144923.0 |
| 2012-04-09 16:00:00 | ES | Futures | 1393.69 | 1393.94 | 1390.66 | 1390.91 | 101157.0 |
| 2012-04-09 16:30:00 | ES | Futures | 1390.66 | 1391.92 | 1390.66 | 1391.67 | 9855.0 |
| 2012-04-09 17:00:00 | ES | Futures | 1391.92 | 1391.92 | 1391.41 | 1391.67 | 1600.0 |
| 2012-04-09 18:00:00 | ES | Futures | 1392.17 | 1393.18 | 1392.17 | 1392.93 | 2782.0 |
| 2012-04-09 18:30:00 | ES | Futures | 1392.93 | 1392.93 | 1391.92 | 1392.43 | 785.0 |
| 2012-04-09 19:00:00 | ES | Futures | 1392.43 | 1392.68 | 1391.67 | 1392.43 | 2479.0 |
| 2012-04-09 19:30:00 | ES | Futures | 1392.43 | 1392.93 | 1392.17 | 1392.43 | 765.0 |
| 2012-04-09 20:00:00 | ES | Futures | 1392.43 | 1392.93 | 1392.17 | 1392.43 | 2632.0 |
| 2012-04-09 20:30:00 | ES | Futures | 1392.43 | 1393.69 | 1392.17 | 1393.69 | 2089.0 |
| 2012-04-09 21:00:00 | ES | Futures | 1393.44 | 1393.94 | 1392.93 | 1393.94 | 3059.0 |
| 2012-04-09 21:30:00 | ES | Futures | 1393.94 | 1395.71 | 1393.69 | 1394.96 | 5268.0 |
| 2012-04-09 22:00:00 | ES | Futures | 1394.96 | 1395.46 | 1394.96 | 1394.96 | 1253.0 |
| 2012-04-09 22:30:00 | ES | Futures | 1394.96 | 1395.71 | 1394.45 | 1395.71 | 1609.0 |
| 2012-04-09 23:00:00 | ES | Futures | 1395.71 | 1395.97 | 1394.2 | 1394.96 | 3720.0 |
| 2012-04-09 23:30:00 | ES | Futures | 1395.21 | 1395.46 | 1393.94 | 1394.96 | 2392.0 |
| 2012-04-09 00:00:00 | NQ | Futures | 3152.0 | 3154.02 | 3151.71 | 3152.29 | 272.0 |
| 2012-04-09 00:30:00 | NQ | Futures | 3152.86 | 3154.02 | 3152.0 | 3153.15 | 152.0 |
| 2012-04-09 01:00:00 | NQ | Futures | 3153.15 | 3154.6 | 3153.15 | 3154.6 | 51.0 |
> showing 50 of 2,108 rows — these rows as CSV