PREVIEW / futures_30min / 2011-04-07
file: by_date/futures_30min/2011/2011-04-07.parquet size: 74 KB rows: 2,737
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 |
|---|---|---|---|---|---|---|---|
| 2011-04-07 00:00:00 | ES | Futures | 1320.41 | 1320.66 | 1318.92 | 1319.17 | 1318.0 |
| 2011-04-07 00:30:00 | ES | Futures | 1319.17 | 1319.41 | 1317.92 | 1318.42 | 3845.0 |
| 2011-04-07 01:00:00 | ES | Futures | 1318.42 | 1318.67 | 1317.92 | 1318.42 | 1042.0 |
| 2011-04-07 01:30:00 | ES | Futures | 1318.17 | 1319.17 | 1318.17 | 1318.92 | 1706.0 |
| 2011-04-07 02:00:00 | ES | Futures | 1318.92 | 1320.16 | 1318.92 | 1319.91 | 3832.0 |
| 2011-04-07 02:30:00 | ES | Futures | 1319.91 | 1320.91 | 1319.41 | 1319.91 | 3163.0 |
| 2011-04-07 03:00:00 | ES | Futures | 1319.91 | 1321.4 | 1319.17 | 1320.41 | 14354.0 |
| 2011-04-07 03:30:00 | ES | Futures | 1320.41 | 1320.41 | 1319.41 | 1320.16 | 7825.0 |
| 2011-04-07 04:00:00 | ES | Futures | 1320.41 | 1321.4 | 1319.91 | 1321.15 | 8719.0 |
| 2011-04-07 04:30:00 | ES | Futures | 1321.15 | 1321.4 | 1320.91 | 1320.91 | 3281.0 |
| 2011-04-07 05:00:00 | ES | Futures | 1321.15 | 1321.15 | 1320.41 | 1320.66 | 3148.0 |
| 2011-04-07 05:30:00 | ES | Futures | 1320.66 | 1320.66 | 1319.91 | 1320.41 | 1882.0 |
| 2011-04-07 06:00:00 | ES | Futures | 1320.41 | 1320.66 | 1319.41 | 1319.91 | 3621.0 |
| 2011-04-07 06:30:00 | ES | Futures | 1319.91 | 1320.41 | 1319.17 | 1320.16 | 5633.0 |
| 2011-04-07 07:00:00 | ES | Futures | 1320.16 | 1321.65 | 1319.91 | 1321.4 | 7016.0 |
| 2011-04-07 07:30:00 | ES | Futures | 1321.65 | 1323.14 | 1320.91 | 1323.14 | 19170.0 |
| 2011-04-07 08:00:00 | ES | Futures | 1323.14 | 1324.13 | 1322.64 | 1323.14 | 29831.0 |
| 2011-04-07 08:30:00 | ES | Futures | 1323.14 | 1324.13 | 1320.91 | 1321.15 | 37307.0 |
| 2011-04-07 09:00:00 | ES | Futures | 1321.4 | 1321.9 | 1319.91 | 1321.4 | 44076.0 |
| 2011-04-07 09:30:00 | ES | Futures | 1321.4 | 1326.37 | 1321.15 | 1326.12 | 194268.0 |
| 2011-04-07 10:00:00 | ES | Futures | 1326.12 | 1326.87 | 1323.64 | 1324.13 | 104118.0 |
| 2011-04-07 10:30:00 | ES | Futures | 1324.13 | 1324.38 | 1313.95 | 1320.66 | 452360.0 |
| 2011-04-07 11:00:00 | ES | Futures | 1320.66 | 1321.9 | 1318.42 | 1319.41 | 204650.0 |
| 2011-04-07 11:30:00 | ES | Futures | 1319.66 | 1320.16 | 1314.69 | 1319.91 | 242863.0 |
| 2011-04-07 12:00:00 | ES | Futures | 1319.91 | 1321.9 | 1319.17 | 1320.66 | 102032.0 |
| 2011-04-07 12:30:00 | ES | Futures | 1320.66 | 1323.64 | 1320.41 | 1322.64 | 62197.0 |
| 2011-04-07 13:00:00 | ES | Futures | 1322.64 | 1322.64 | 1318.92 | 1318.92 | 76334.0 |
| 2011-04-07 13:30:00 | ES | Futures | 1319.17 | 1319.91 | 1316.68 | 1318.17 | 81405.0 |
| 2011-04-07 14:00:00 | ES | Futures | 1318.17 | 1319.17 | 1316.93 | 1316.93 | 56163.0 |
| 2011-04-07 14:30:00 | ES | Futures | 1317.18 | 1320.16 | 1316.93 | 1319.66 | 74261.0 |
| 2011-04-07 15:00:00 | ES | Futures | 1319.66 | 1321.15 | 1318.17 | 1319.17 | 73376.0 |
| 2011-04-07 15:30:00 | ES | Futures | 1319.17 | 1321.65 | 1318.17 | 1320.66 | 144140.0 |
| 2011-04-07 16:00:00 | ES | Futures | 1320.91 | 1321.15 | 1319.66 | 1320.16 | 78921.0 |
| 2011-04-07 16:30:00 | ES | Futures | 1320.16 | 1320.91 | 1319.91 | 1320.41 | 3785.0 |
| 2011-04-07 17:00:00 | ES | Futures | 1320.41 | 1321.15 | 1319.91 | 1320.66 | 1230.0 |
| 2011-04-07 18:00:00 | ES | Futures | 1320.91 | 1321.65 | 1319.91 | 1319.91 | 2088.0 |
| 2011-04-07 18:30:00 | ES | Futures | 1320.16 | 1320.41 | 1319.41 | 1319.91 | 982.0 |
| 2011-04-07 19:00:00 | ES | Futures | 1320.16 | 1320.66 | 1319.91 | 1320.41 | 486.0 |
| 2011-04-07 19:30:00 | ES | Futures | 1320.16 | 1321.15 | 1320.16 | 1320.66 | 823.0 |
| 2011-04-07 20:00:00 | ES | Futures | 1320.41 | 1321.9 | 1320.16 | 1321.65 | 4055.0 |
| 2011-04-07 20:30:00 | ES | Futures | 1321.4 | 1321.9 | 1320.66 | 1321.65 | 1925.0 |
| 2011-04-07 21:00:00 | ES | Futures | 1321.65 | 1322.15 | 1320.66 | 1321.15 | 2863.0 |
| 2011-04-07 21:30:00 | ES | Futures | 1321.15 | 1322.4 | 1320.66 | 1321.9 | 4830.0 |
| 2011-04-07 22:00:00 | ES | Futures | 1321.9 | 1322.15 | 1321.4 | 1321.9 | 1082.0 |
| 2011-04-07 22:30:00 | ES | Futures | 1321.9 | 1322.64 | 1321.9 | 1322.4 | 1454.0 |
| 2011-04-07 23:00:00 | ES | Futures | 1322.4 | 1322.89 | 1321.9 | 1322.64 | 2819.0 |
| 2011-04-07 23:30:00 | ES | Futures | 1322.64 | 1323.14 | 1322.4 | 1322.64 | 2290.0 |
| 2011-04-07 00:00:00 | NQ | Futures | 2673.75 | 2674.04 | 2670.59 | 2670.88 | 70.0 |
| 2011-04-07 00:30:00 | NQ | Futures | 2670.88 | 2671.17 | 2669.15 | 2669.44 | 344.0 |
| 2011-04-07 01:00:00 | NQ | Futures | 2669.44 | 2670.3 | 2668.58 | 2668.87 | 130.0 |
> showing 50 of 2,737 rows — these rows as CSV