PREVIEW / futures_30min / 2012-04-08
file: by_date/futures_30min/2012/2012-04-08.parquet size: 19 KB rows: 494
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-08 18:00:00 | ES | Futures | 1391.41 | 1392.43 | 1388.38 | 1390.4 | 8790.0 |
| 2012-04-08 18:30:00 | ES | Futures | 1390.15 | 1390.66 | 1389.64 | 1389.9 | 2114.0 |
| 2012-04-08 19:00:00 | ES | Futures | 1390.15 | 1390.66 | 1388.88 | 1390.66 | 1817.0 |
| 2012-04-08 19:30:00 | ES | Futures | 1390.4 | 1391.67 | 1390.15 | 1390.66 | 3506.0 |
| 2012-04-08 20:00:00 | ES | Futures | 1390.91 | 1391.16 | 1389.9 | 1390.4 | 2691.0 |
| 2012-04-08 20:30:00 | ES | Futures | 1390.4 | 1390.91 | 1389.64 | 1390.15 | 3336.0 |
| 2012-04-08 21:00:00 | ES | Futures | 1389.9 | 1390.66 | 1388.13 | 1390.15 | 4740.0 |
| 2012-04-08 21:30:00 | ES | Futures | 1390.15 | 1390.91 | 1389.9 | 1390.66 | 4249.0 |
| 2012-04-08 22:00:00 | ES | Futures | 1390.66 | 1391.16 | 1390.4 | 1391.16 | 931.0 |
| 2012-04-08 22:30:00 | ES | Futures | 1391.16 | 1391.67 | 1390.91 | 1391.67 | 723.0 |
| 2012-04-08 23:00:00 | ES | Futures | 1391.41 | 1391.41 | 1390.91 | 1391.16 | 606.0 |
| 2012-04-08 23:30:00 | ES | Futures | 1391.16 | 1391.67 | 1390.66 | 1391.67 | 889.0 |
| 2012-04-08 18:00:00 | NQ | Futures | 3153.15 | 3155.47 | 3146.5 | 3150.55 | 1056.0 |
| 2012-04-08 18:30:00 | NQ | Futures | 3149.97 | 3151.42 | 3149.1 | 3150.55 | 140.0 |
| 2012-04-08 19:00:00 | NQ | Futures | 3150.55 | 3150.84 | 3147.66 | 3150.84 | 148.0 |
| 2012-04-08 19:30:00 | NQ | Futures | 3151.71 | 3153.15 | 3150.26 | 3151.13 | 200.0 |
| 2012-04-08 20:00:00 | NQ | Futures | 3151.13 | 3151.13 | 3149.39 | 3150.55 | 438.0 |
| 2012-04-08 20:30:00 | NQ | Futures | 3149.97 | 3151.42 | 3148.53 | 3149.68 | 330.0 |
| 2012-04-08 21:00:00 | NQ | Futures | 3149.68 | 3149.68 | 3145.35 | 3149.1 | 540.0 |
| 2012-04-08 21:30:00 | NQ | Futures | 3148.82 | 3149.97 | 3147.95 | 3149.68 | 257.0 |
| 2012-04-08 22:00:00 | NQ | Futures | 3149.68 | 3150.55 | 3149.39 | 3150.55 | 86.0 |
| 2012-04-08 22:30:00 | NQ | Futures | 3150.55 | 3152.0 | 3150.26 | 3151.71 | 88.0 |
| 2012-04-08 23:00:00 | NQ | Futures | 3151.42 | 3151.42 | 3150.55 | 3151.13 | 60.0 |
| 2012-04-08 23:30:00 | NQ | Futures | 3150.84 | 3152.0 | 3150.26 | 3151.71 | 106.0 |
| 2012-04-08 18:00:00 | YM | Futures | 12812.4 | 12812.4 | 12782.5 | 12799.5 | 647.0 |
| 2012-04-08 18:30:00 | YM | Futures | 12796.5 | 12803.4 | 12795.5 | 12797.5 | 141.0 |
| 2012-04-08 19:00:00 | YM | Futures | 12796.5 | 12799.5 | 12789.5 | 12799.5 | 88.0 |
| 2012-04-08 19:30:00 | YM | Futures | 12800.5 | 12808.4 | 12799.5 | 12803.4 | 78.0 |
| 2012-04-08 20:00:00 | YM | Futures | 12803.4 | 12806.4 | 12798.5 | 12799.5 | 112.0 |
| 2012-04-08 20:30:00 | YM | Futures | 12801.5 | 12803.4 | 12796.5 | 12799.5 | 191.0 |
| 2012-04-08 21:00:00 | YM | Futures | 12800.5 | 12800.5 | 12777.5 | 12797.5 | 446.0 |
| 2012-04-08 21:30:00 | YM | Futures | 12795.5 | 12802.4 | 12793.5 | 12801.5 | 142.0 |
| 2012-04-08 22:00:00 | YM | Futures | 12801.5 | 12804.4 | 12800.5 | 12804.4 | 64.0 |
| 2012-04-08 22:30:00 | YM | Futures | 12804.4 | 12809.4 | 12803.4 | 12808.4 | 137.0 |
| 2012-04-08 23:00:00 | YM | Futures | 12807.4 | 12807.4 | 12804.4 | 12805.4 | 33.0 |
| 2012-04-08 23:30:00 | YM | Futures | 12805.4 | 12811.4 | 12804.4 | 12811.4 | 75.0 |
| 2012-04-08 18:00:00 | CL | Futures | 171.23 | 171.26 | 170.49 | 170.64 | 1523.0 |
| 2012-04-08 18:30:00 | CL | Futures | 170.66 | 170.76 | 170.39 | 170.76 | 564.0 |
| 2012-04-08 19:00:00 | CL | Futures | 170.76 | 170.84 | 170.56 | 170.64 | 276.0 |
| 2012-04-08 19:30:00 | CL | Futures | 170.67 | 170.91 | 170.57 | 170.67 | 266.0 |
| 2012-04-08 20:00:00 | CL | Futures | 170.67 | 170.67 | 170.57 | 170.62 | 184.0 |
| 2012-04-08 20:30:00 | CL | Futures | 170.66 | 170.76 | 170.46 | 170.47 | 154.0 |
| 2012-04-08 21:00:00 | CL | Futures | 170.49 | 170.59 | 170.21 | 170.52 | 577.0 |
| 2012-04-08 21:30:00 | CL | Futures | 170.46 | 170.49 | 170.12 | 170.49 | 383.0 |
| 2012-04-08 22:00:00 | CL | Futures | 170.49 | 170.52 | 170.32 | 170.51 | 176.0 |
| 2012-04-08 22:30:00 | CL | Futures | 170.51 | 170.59 | 170.46 | 170.56 | 119.0 |
| 2012-04-08 23:00:00 | CL | Futures | 170.57 | 170.57 | 170.36 | 170.37 | 172.0 |
| 2012-04-08 23:30:00 | CL | Futures | 170.41 | 170.51 | 170.34 | 170.49 | 72.0 |
| 2012-04-08 18:00:00 | GC | Futures | 2274.2 | 2284.2 | 2274.2 | 2281.1 | 4076.0 |
| 2012-04-08 18:30:00 | GC | Futures | 2281.3 | 2283.3 | 2278.8 | 2281.1 | 872.0 |
> showing 50 of 494 rows — these rows as CSV