PREVIEW / futures_5min / 2012-04-19
file: by_date/futures_5min/2012/2012-04-19.parquet size: 226 KB rows: 13,424
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-19 00:00:00 | ES | Futures | 1397.23 | 1397.49 | 1396.73 | 1396.98 | 173.0 |
| 2012-04-19 00:05:00 | ES | Futures | 1396.98 | 1396.98 | 1396.47 | 1396.47 | 409.0 |
| 2012-04-19 00:10:00 | ES | Futures | 1396.73 | 1396.73 | 1396.47 | 1396.47 | 162.0 |
| 2012-04-19 00:15:00 | ES | Futures | 1396.22 | 1396.47 | 1395.97 | 1396.47 | 335.0 |
| 2012-04-19 00:20:00 | ES | Futures | 1396.47 | 1396.73 | 1396.22 | 1396.73 | 107.0 |
| 2012-04-19 00:25:00 | ES | Futures | 1396.73 | 1396.98 | 1396.47 | 1396.47 | 100.0 |
| 2012-04-19 00:30:00 | ES | Futures | 1396.47 | 1396.47 | 1396.22 | 1396.47 | 136.0 |
| 2012-04-19 00:35:00 | ES | Futures | 1396.73 | 1396.73 | 1396.22 | 1396.22 | 40.0 |
| 2012-04-19 00:40:00 | ES | Futures | 1396.47 | 1396.73 | 1395.97 | 1396.73 | 222.0 |
| 2012-04-19 00:45:00 | ES | Futures | 1396.73 | 1396.73 | 1396.22 | 1396.47 | 108.0 |
| 2012-04-19 00:50:00 | ES | Futures | 1396.73 | 1396.73 | 1396.47 | 1396.73 | 39.0 |
| 2012-04-19 00:55:00 | ES | Futures | 1396.47 | 1396.98 | 1396.47 | 1396.73 | 76.0 |
| 2012-04-19 01:00:00 | ES | Futures | 1396.98 | 1397.23 | 1396.73 | 1397.23 | 201.0 |
| 2012-04-19 01:05:00 | ES | Futures | 1397.23 | 1397.74 | 1397.23 | 1397.49 | 300.0 |
| 2012-04-19 01:10:00 | ES | Futures | 1397.49 | 1397.49 | 1396.98 | 1397.23 | 239.0 |
| 2012-04-19 01:15:00 | ES | Futures | 1396.98 | 1397.74 | 1396.98 | 1397.49 | 427.0 |
| 2012-04-19 01:20:00 | ES | Futures | 1397.49 | 1397.99 | 1397.23 | 1397.74 | 240.0 |
| 2012-04-19 01:25:00 | ES | Futures | 1397.74 | 1397.99 | 1397.49 | 1397.74 | 258.0 |
| 2012-04-19 01:30:00 | ES | Futures | 1397.49 | 1397.74 | 1397.23 | 1397.49 | 349.0 |
| 2012-04-19 01:35:00 | ES | Futures | 1397.49 | 1397.74 | 1397.23 | 1397.49 | 399.0 |
| 2012-04-19 01:40:00 | ES | Futures | 1397.23 | 1397.49 | 1397.23 | 1397.49 | 400.0 |
| 2012-04-19 01:45:00 | ES | Futures | 1397.49 | 1397.49 | 1397.23 | 1397.49 | 143.0 |
| 2012-04-19 01:50:00 | ES | Futures | 1397.49 | 1397.74 | 1397.49 | 1397.49 | 268.0 |
| 2012-04-19 01:55:00 | ES | Futures | 1397.74 | 1397.99 | 1397.49 | 1397.99 | 173.0 |
| 2012-04-19 02:00:00 | ES | Futures | 1397.74 | 1398.5 | 1397.74 | 1398.5 | 1328.0 |
| 2012-04-19 02:05:00 | ES | Futures | 1398.5 | 1398.75 | 1398.24 | 1398.5 | 643.0 |
| 2012-04-19 02:10:00 | ES | Futures | 1398.24 | 1398.5 | 1397.99 | 1397.99 | 338.0 |
| 2012-04-19 02:15:00 | ES | Futures | 1397.99 | 1397.99 | 1397.49 | 1397.74 | 285.0 |
| 2012-04-19 02:20:00 | ES | Futures | 1397.74 | 1398.5 | 1397.49 | 1398.24 | 557.0 |
| 2012-04-19 02:25:00 | ES | Futures | 1398.5 | 1399.0 | 1398.24 | 1398.5 | 571.0 |
| 2012-04-19 02:30:00 | ES | Futures | 1398.5 | 1400.02 | 1398.5 | 1399.51 | 1368.0 |
| 2012-04-19 02:35:00 | ES | Futures | 1399.26 | 1399.76 | 1399.0 | 1399.26 | 773.0 |
| 2012-04-19 02:40:00 | ES | Futures | 1399.0 | 1399.51 | 1398.75 | 1399.26 | 1109.0 |
| 2012-04-19 02:45:00 | ES | Futures | 1399.51 | 1399.76 | 1399.26 | 1399.76 | 503.0 |
| 2012-04-19 02:50:00 | ES | Futures | 1399.51 | 1400.52 | 1399.26 | 1400.27 | 926.0 |
| 2012-04-19 02:55:00 | ES | Futures | 1400.02 | 1400.27 | 1399.76 | 1400.02 | 635.0 |
| 2012-04-19 03:00:00 | ES | Futures | 1399.76 | 1401.53 | 1399.76 | 1401.03 | 5205.0 |
| 2012-04-19 03:05:00 | ES | Futures | 1401.03 | 1402.55 | 1401.03 | 1402.04 | 3954.0 |
| 2012-04-19 03:10:00 | ES | Futures | 1402.29 | 1403.81 | 1402.04 | 1402.29 | 6042.0 |
| 2012-04-19 03:15:00 | ES | Futures | 1402.29 | 1402.8 | 1401.53 | 1401.79 | 3160.0 |
| 2012-04-19 03:20:00 | ES | Futures | 1401.79 | 1402.8 | 1401.79 | 1402.04 | 2096.0 |
| 2012-04-19 03:25:00 | ES | Futures | 1402.29 | 1403.56 | 1401.79 | 1402.8 | 3357.0 |
| 2012-04-19 03:30:00 | ES | Futures | 1402.8 | 1403.05 | 1400.77 | 1400.77 | 2725.0 |
| 2012-04-19 03:35:00 | ES | Futures | 1400.77 | 1401.79 | 1400.52 | 1401.53 | 2775.0 |
| 2012-04-19 03:40:00 | ES | Futures | 1401.53 | 1402.55 | 1401.28 | 1402.55 | 1647.0 |
| 2012-04-19 03:45:00 | ES | Futures | 1402.29 | 1402.55 | 1401.53 | 1402.29 | 1002.0 |
| 2012-04-19 03:50:00 | ES | Futures | 1402.04 | 1403.05 | 1401.79 | 1403.05 | 1917.0 |
| 2012-04-19 03:55:00 | ES | Futures | 1403.05 | 1403.81 | 1402.55 | 1402.55 | 2568.0 |
| 2012-04-19 04:00:00 | ES | Futures | 1402.55 | 1403.05 | 1402.04 | 1402.29 | 1345.0 |
| 2012-04-19 04:05:00 | ES | Futures | 1402.29 | 1402.55 | 1401.79 | 1402.29 | 921.0 |
> showing 50 of 13,424 rows — these rows as CSV