PREVIEW / futures_30min / 2012-04-05
file: by_date/futures_30min/2012/2012-04-05.parquet size: 69 KB rows: 2,459
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-05 00:00:00 | ES | Futures | 1411.65 | 1411.91 | 1411.15 | 1411.65 | 987.0 |
| 2012-04-05 00:30:00 | ES | Futures | 1411.65 | 1412.66 | 1411.4 | 1412.41 | 953.0 |
| 2012-04-05 01:00:00 | ES | Futures | 1412.16 | 1413.68 | 1412.16 | 1413.17 | 4833.0 |
| 2012-04-05 01:30:00 | ES | Futures | 1412.92 | 1413.68 | 1412.92 | 1412.92 | 1429.0 |
| 2012-04-05 02:00:00 | ES | Futures | 1413.17 | 1414.18 | 1412.66 | 1413.93 | 3308.0 |
| 2012-04-05 02:30:00 | ES | Futures | 1414.18 | 1414.44 | 1412.66 | 1412.66 | 4815.0 |
| 2012-04-05 03:00:00 | ES | Futures | 1412.66 | 1413.93 | 1411.91 | 1412.92 | 13859.0 |
| 2012-04-05 03:30:00 | ES | Futures | 1412.66 | 1413.93 | 1411.4 | 1413.42 | 11315.0 |
| 2012-04-05 04:00:00 | ES | Futures | 1413.42 | 1413.68 | 1410.39 | 1410.64 | 12281.0 |
| 2012-04-05 04:30:00 | ES | Futures | 1410.39 | 1410.89 | 1406.09 | 1408.11 | 28160.0 |
| 2012-04-05 05:00:00 | ES | Futures | 1408.11 | 1409.63 | 1405.83 | 1406.34 | 24556.0 |
| 2012-04-05 05:30:00 | ES | Futures | 1406.34 | 1406.34 | 1401.53 | 1402.55 | 49141.0 |
| 2012-04-05 06:00:00 | ES | Futures | 1402.55 | 1403.05 | 1400.52 | 1403.05 | 27449.0 |
| 2012-04-05 06:30:00 | ES | Futures | 1402.8 | 1405.33 | 1402.55 | 1405.08 | 15432.0 |
| 2012-04-05 07:00:00 | ES | Futures | 1404.82 | 1405.58 | 1403.81 | 1404.82 | 18378.0 |
| 2012-04-05 07:30:00 | ES | Futures | 1404.82 | 1405.58 | 1403.05 | 1405.58 | 20391.0 |
| 2012-04-05 08:00:00 | ES | Futures | 1405.33 | 1405.58 | 1401.79 | 1402.55 | 32179.0 |
| 2012-04-05 08:30:00 | ES | Futures | 1402.29 | 1406.34 | 1402.04 | 1405.08 | 52222.0 |
| 2012-04-05 09:00:00 | ES | Futures | 1405.08 | 1406.09 | 1404.06 | 1405.33 | 25907.0 |
| 2012-04-05 09:30:00 | ES | Futures | 1405.33 | 1410.13 | 1404.06 | 1408.36 | 205891.0 |
| 2012-04-05 10:00:00 | ES | Futures | 1408.11 | 1411.4 | 1408.11 | 1409.63 | 132064.0 |
| 2012-04-05 10:30:00 | ES | Futures | 1409.63 | 1413.17 | 1408.36 | 1413.17 | 113817.0 |
| 2012-04-05 11:00:00 | ES | Futures | 1412.92 | 1413.93 | 1411.65 | 1412.16 | 97411.0 |
| 2012-04-05 11:30:00 | ES | Futures | 1411.91 | 1412.41 | 1410.13 | 1411.65 | 86846.0 |
| 2012-04-05 12:00:00 | ES | Futures | 1411.65 | 1412.41 | 1410.13 | 1410.89 | 73590.0 |
| 2012-04-05 12:30:00 | ES | Futures | 1410.89 | 1411.15 | 1409.12 | 1409.63 | 33384.0 |
| 2012-04-05 13:00:00 | ES | Futures | 1409.63 | 1410.89 | 1409.38 | 1409.88 | 30936.0 |
| 2012-04-05 13:30:00 | ES | Futures | 1409.88 | 1410.39 | 1406.09 | 1407.6 | 65599.0 |
| 2012-04-05 14:00:00 | ES | Futures | 1407.6 | 1409.38 | 1407.1 | 1408.62 | 36315.0 |
| 2012-04-05 14:30:00 | ES | Futures | 1408.87 | 1410.13 | 1407.86 | 1409.38 | 37875.0 |
| 2012-04-05 15:00:00 | ES | Futures | 1409.63 | 1410.13 | 1408.36 | 1409.88 | 33703.0 |
| 2012-04-05 15:30:00 | ES | Futures | 1410.13 | 1411.15 | 1409.12 | 1409.38 | 120806.0 |
| 2012-04-05 16:00:00 | ES | Futures | 1409.63 | 1409.63 | 1406.59 | 1406.85 | 71988.0 |
| 2012-04-05 16:30:00 | ES | Futures | 1407.1 | 1407.86 | 1406.09 | 1407.86 | 5266.0 |
| 2012-04-05 17:00:00 | ES | Futures | 1407.6 | 1408.11 | 1407.35 | 1407.86 | 892.0 |
| 2012-04-05 18:00:00 | ES | Futures | 1407.6 | 1408.11 | 1407.1 | 1407.86 | 1311.0 |
| 2012-04-05 18:30:00 | ES | Futures | 1408.11 | 1408.36 | 1407.86 | 1407.86 | 676.0 |
| 2012-04-05 19:00:00 | ES | Futures | 1408.11 | 1408.11 | 1407.1 | 1407.1 | 458.0 |
| 2012-04-05 19:30:00 | ES | Futures | 1407.35 | 1408.36 | 1406.85 | 1408.11 | 825.0 |
| 2012-04-05 20:00:00 | ES | Futures | 1408.11 | 1408.62 | 1407.35 | 1408.11 | 1624.0 |
| 2012-04-05 20:30:00 | ES | Futures | 1408.11 | 1410.89 | 1408.11 | 1410.89 | 3220.0 |
| 2012-04-05 21:00:00 | ES | Futures | 1410.89 | 1410.89 | 1409.38 | 1410.39 | 1387.0 |
| 2012-04-05 21:30:00 | ES | Futures | 1410.39 | 1410.64 | 1409.38 | 1409.63 | 661.0 |
| 2012-04-05 22:00:00 | ES | Futures | 1409.38 | 1409.88 | 1409.38 | 1409.88 | 207.0 |
| 2012-04-05 22:30:00 | ES | Futures | 1409.63 | 1410.13 | 1409.63 | 1409.88 | 216.0 |
| 2012-04-05 23:00:00 | ES | Futures | 1410.13 | 1410.13 | 1408.62 | 1408.87 | 891.0 |
| 2012-04-05 23:30:00 | ES | Futures | 1408.87 | 1409.38 | 1408.87 | 1408.87 | 284.0 |
| 2012-04-05 00:00:00 | NQ | Futures | 3171.37 | 3171.66 | 3170.22 | 3171.66 | 157.0 |
| 2012-04-05 00:30:00 | NQ | Futures | 3171.66 | 3173.4 | 3171.37 | 3173.11 | 91.0 |
| 2012-04-05 01:00:00 | NQ | Futures | 3173.4 | 3174.55 | 3172.53 | 3174.27 | 371.0 |
> showing 50 of 2,459 rows — these rows as CSV