PREVIEW / futures_30min / 2012-02-02
file: by_date/futures_30min/2012/2012-02-02.parquet size: 73 KB rows: 2,795
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-02-02 00:00:00 | ES | Futures | 1331.76 | 1332.51 | 1331.76 | 1332.01 | 1257.0 |
| 2012-02-02 00:30:00 | ES | Futures | 1332.26 | 1333.52 | 1331.76 | 1333.02 | 1740.0 |
| 2012-02-02 01:00:00 | ES | Futures | 1333.27 | 1334.53 | 1333.02 | 1334.53 | 2181.0 |
| 2012-02-02 01:30:00 | ES | Futures | 1334.28 | 1334.78 | 1334.02 | 1334.28 | 1630.0 |
| 2012-02-02 02:00:00 | ES | Futures | 1334.28 | 1335.28 | 1333.52 | 1334.28 | 4787.0 |
| 2012-02-02 02:30:00 | ES | Futures | 1334.28 | 1334.78 | 1333.77 | 1334.28 | 4127.0 |
| 2012-02-02 03:00:00 | ES | Futures | 1334.28 | 1335.79 | 1331.5 | 1331.76 | 17330.0 |
| 2012-02-02 03:30:00 | ES | Futures | 1332.01 | 1333.52 | 1330.5 | 1330.5 | 9925.0 |
| 2012-02-02 04:00:00 | ES | Futures | 1330.75 | 1331.0 | 1328.73 | 1329.49 | 14966.0 |
| 2012-02-02 04:30:00 | ES | Futures | 1329.49 | 1330.75 | 1328.73 | 1329.99 | 17318.0 |
| 2012-02-02 05:00:00 | ES | Futures | 1330.24 | 1331.5 | 1328.98 | 1329.74 | 9679.0 |
| 2012-02-02 05:30:00 | ES | Futures | 1329.74 | 1333.27 | 1329.49 | 1330.75 | 20949.0 |
| 2012-02-02 06:00:00 | ES | Futures | 1330.75 | 1331.5 | 1329.49 | 1331.0 | 8288.0 |
| 2012-02-02 06:30:00 | ES | Futures | 1331.25 | 1332.26 | 1330.5 | 1330.5 | 7460.0 |
| 2012-02-02 07:00:00 | ES | Futures | 1330.5 | 1331.0 | 1327.72 | 1329.74 | 26888.0 |
| 2012-02-02 07:30:00 | ES | Futures | 1329.49 | 1329.74 | 1327.47 | 1328.73 | 17483.0 |
| 2012-02-02 08:00:00 | ES | Futures | 1328.73 | 1329.99 | 1327.98 | 1329.49 | 14776.0 |
| 2012-02-02 08:30:00 | ES | Futures | 1329.49 | 1332.26 | 1329.49 | 1331.76 | 35792.0 |
| 2012-02-02 09:00:00 | ES | Futures | 1331.76 | 1333.52 | 1331.0 | 1333.02 | 37331.0 |
| 2012-02-02 09:30:00 | ES | Futures | 1333.02 | 1334.02 | 1329.74 | 1332.01 | 144853.0 |
| 2012-02-02 10:00:00 | ES | Futures | 1332.01 | 1334.78 | 1332.01 | 1333.02 | 130043.0 |
| 2012-02-02 10:30:00 | ES | Futures | 1333.02 | 1336.54 | 1333.02 | 1334.78 | 112617.0 |
| 2012-02-02 11:00:00 | ES | Futures | 1334.78 | 1336.04 | 1333.27 | 1333.52 | 84500.0 |
| 2012-02-02 11:30:00 | ES | Futures | 1333.52 | 1333.77 | 1330.75 | 1332.01 | 90951.0 |
| 2012-02-02 12:00:00 | ES | Futures | 1331.76 | 1332.51 | 1329.24 | 1330.5 | 91853.0 |
| 2012-02-02 12:30:00 | ES | Futures | 1330.5 | 1331.25 | 1327.98 | 1331.0 | 53692.0 |
| 2012-02-02 13:00:00 | ES | Futures | 1331.0 | 1331.76 | 1330.24 | 1330.24 | 30772.0 |
| 2012-02-02 13:30:00 | ES | Futures | 1330.24 | 1333.02 | 1329.99 | 1332.51 | 30769.0 |
| 2012-02-02 14:00:00 | ES | Futures | 1332.26 | 1333.02 | 1331.76 | 1332.51 | 23837.0 |
| 2012-02-02 14:30:00 | ES | Futures | 1332.51 | 1333.52 | 1331.0 | 1332.26 | 43117.0 |
| 2012-02-02 15:00:00 | ES | Futures | 1332.26 | 1333.27 | 1332.01 | 1332.76 | 38176.0 |
| 2012-02-02 15:30:00 | ES | Futures | 1332.51 | 1334.53 | 1331.76 | 1332.76 | 109325.0 |
| 2012-02-02 16:00:00 | ES | Futures | 1332.76 | 1334.53 | 1332.51 | 1333.27 | 76388.0 |
| 2012-02-02 16:30:00 | ES | Futures | 1333.27 | 1333.77 | 1332.76 | 1333.52 | 3959.0 |
| 2012-02-02 17:00:00 | ES | Futures | 1333.27 | 1333.77 | 1332.76 | 1332.76 | 1794.0 |
| 2012-02-02 18:00:00 | ES | Futures | 1333.02 | 1333.52 | 1332.76 | 1332.76 | 1347.0 |
| 2012-02-02 18:30:00 | ES | Futures | 1332.76 | 1333.77 | 1332.76 | 1333.02 | 1130.0 |
| 2012-02-02 19:00:00 | ES | Futures | 1333.27 | 1333.77 | 1332.51 | 1333.27 | 2407.0 |
| 2012-02-02 19:30:00 | ES | Futures | 1333.27 | 1334.28 | 1332.76 | 1334.02 | 2147.0 |
| 2012-02-02 20:00:00 | ES | Futures | 1334.02 | 1334.02 | 1331.5 | 1331.76 | 4619.0 |
| 2012-02-02 20:30:00 | ES | Futures | 1331.76 | 1333.02 | 1331.5 | 1332.51 | 1835.0 |
| 2012-02-02 21:00:00 | ES | Futures | 1332.26 | 1332.76 | 1332.26 | 1332.76 | 814.0 |
| 2012-02-02 21:30:00 | ES | Futures | 1332.76 | 1333.52 | 1332.01 | 1332.51 | 1386.0 |
| 2012-02-02 22:00:00 | ES | Futures | 1332.51 | 1333.02 | 1332.26 | 1332.51 | 803.0 |
| 2012-02-02 22:30:00 | ES | Futures | 1332.51 | 1333.27 | 1332.01 | 1332.51 | 1062.0 |
| 2012-02-02 23:00:00 | ES | Futures | 1332.51 | 1332.51 | 1331.5 | 1331.76 | 1328.0 |
| 2012-02-02 23:30:00 | ES | Futures | 1331.5 | 1332.26 | 1330.5 | 1331.25 | 2085.0 |
| 2012-02-02 00:00:00 | NQ | Futures | 2876.43 | 2877.3 | 2876.14 | 2877.01 | 69.0 |
| 2012-02-02 00:30:00 | NQ | Futures | 2877.01 | 2877.88 | 2876.14 | 2877.88 | 123.0 |
| 2012-02-02 01:00:00 | NQ | Futures | 2877.88 | 2880.76 | 2877.59 | 2880.47 | 274.0 |
> showing 50 of 2,795 rows — these rows as CSV