PREVIEW / futures_30min / 2012-04-22
file: by_date/futures_30min/2012/2012-04-22.parquet size: 18 KB rows: 474
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-22 18:00:00 | ES | Futures | 1388.63 | 1390.4 | 1387.62 | 1390.15 | 7430.0 |
| 2012-04-22 18:30:00 | ES | Futures | 1390.15 | 1390.66 | 1389.64 | 1389.64 | 1660.0 |
| 2012-04-22 19:00:00 | ES | Futures | 1389.39 | 1389.64 | 1388.38 | 1389.14 | 2645.0 |
| 2012-04-22 19:30:00 | ES | Futures | 1388.88 | 1389.64 | 1388.88 | 1389.14 | 997.0 |
| 2012-04-22 20:00:00 | ES | Futures | 1388.88 | 1391.16 | 1388.88 | 1390.66 | 3603.0 |
| 2012-04-22 20:30:00 | ES | Futures | 1390.4 | 1390.91 | 1387.87 | 1388.38 | 5164.0 |
| 2012-04-22 21:00:00 | ES | Futures | 1388.63 | 1389.64 | 1388.38 | 1388.38 | 3638.0 |
| 2012-04-22 21:30:00 | ES | Futures | 1388.38 | 1389.14 | 1386.86 | 1388.13 | 5806.0 |
| 2012-04-22 22:00:00 | ES | Futures | 1388.13 | 1388.38 | 1387.37 | 1388.13 | 1832.0 |
| 2012-04-22 22:30:00 | ES | Futures | 1388.38 | 1389.9 | 1388.13 | 1389.39 | 3040.0 |
| 2012-04-22 23:00:00 | ES | Futures | 1389.39 | 1390.15 | 1389.14 | 1389.39 | 766.0 |
| 2012-04-22 23:30:00 | ES | Futures | 1389.14 | 1389.64 | 1388.88 | 1389.14 | 627.0 |
| 2012-04-22 18:00:00 | NQ | Futures | 3089.82 | 3092.13 | 3084.61 | 3091.84 | 781.0 |
| 2012-04-22 18:30:00 | NQ | Futures | 3091.26 | 3092.71 | 3090.69 | 3090.69 | 123.0 |
| 2012-04-22 19:00:00 | NQ | Futures | 3090.4 | 3090.4 | 3087.5 | 3088.95 | 119.0 |
| 2012-04-22 19:30:00 | NQ | Futures | 3088.95 | 3090.98 | 3088.66 | 3090.11 | 90.0 |
| 2012-04-22 20:00:00 | NQ | Futures | 3089.82 | 3094.45 | 3089.82 | 3092.71 | 503.0 |
| 2012-04-22 20:30:00 | NQ | Futures | 3092.71 | 3093.29 | 3086.93 | 3088.37 | 478.0 |
| 2012-04-22 21:00:00 | NQ | Futures | 3088.37 | 3090.69 | 3087.79 | 3088.66 | 338.0 |
| 2012-04-22 21:30:00 | NQ | Futures | 3088.66 | 3089.53 | 3085.48 | 3088.08 | 553.0 |
| 2012-04-22 22:00:00 | NQ | Futures | 3087.79 | 3087.79 | 3086.35 | 3087.22 | 181.0 |
| 2012-04-22 22:30:00 | NQ | Futures | 3087.5 | 3090.69 | 3087.5 | 3089.82 | 320.0 |
| 2012-04-22 23:00:00 | NQ | Futures | 3089.82 | 3090.98 | 3088.66 | 3088.66 | 105.0 |
| 2012-04-22 23:30:00 | NQ | Futures | 3088.66 | 3089.82 | 3088.08 | 3088.37 | 90.0 |
| 2012-04-22 18:00:00 | YM | Futures | 12919.0 | 12927.0 | 12905.1 | 12923.0 | 594.0 |
| 2012-04-22 18:30:00 | YM | Futures | 12924.0 | 12929.0 | 12922.0 | 12922.0 | 68.0 |
| 2012-04-22 19:00:00 | YM | Futures | 12921.0 | 12921.0 | 12899.1 | 12910.0 | 676.0 |
| 2012-04-22 19:30:00 | YM | Futures | 12910.0 | 12918.0 | 12909.1 | 12914.0 | 116.0 |
| 2012-04-22 20:00:00 | YM | Futures | 12914.0 | 12930.0 | 12914.0 | 12924.0 | 162.0 |
| 2012-04-22 20:30:00 | YM | Futures | 12925.0 | 12928.0 | 12906.1 | 12910.0 | 254.0 |
| 2012-04-22 21:00:00 | YM | Futures | 12910.0 | 12917.0 | 12908.1 | 12910.0 | 164.0 |
| 2012-04-22 21:30:00 | YM | Futures | 12910.0 | 12925.0 | 12899.1 | 12908.1 | 1076.0 |
| 2012-04-22 22:00:00 | YM | Futures | 12908.1 | 12910.0 | 12903.1 | 12908.1 | 91.0 |
| 2012-04-22 22:30:00 | YM | Futures | 12910.0 | 12924.0 | 12909.1 | 12919.0 | 621.0 |
| 2012-04-22 23:00:00 | YM | Futures | 12919.0 | 12923.0 | 12916.0 | 12919.0 | 81.0 |
| 2012-04-22 23:30:00 | YM | Futures | 12917.0 | 12920.0 | 12907.1 | 12914.0 | 419.0 |
| 2012-04-22 18:00:00 | CL | Futures | 172.59 | 172.69 | 172.39 | 172.61 | 404.0 |
| 2012-04-22 18:30:00 | CL | Futures | 172.61 | 172.69 | 172.56 | 172.64 | 150.0 |
| 2012-04-22 19:00:00 | CL | Futures | 172.64 | 172.64 | 172.49 | 172.56 | 127.0 |
| 2012-04-22 19:30:00 | CL | Futures | 172.56 | 172.69 | 172.49 | 172.63 | 154.0 |
| 2012-04-22 20:00:00 | CL | Futures | 172.68 | 172.73 | 172.64 | 172.69 | 131.0 |
| 2012-04-22 20:30:00 | CL | Futures | 172.69 | 172.73 | 172.48 | 172.49 | 133.0 |
| 2012-04-22 21:00:00 | CL | Futures | 172.49 | 172.56 | 172.41 | 172.53 | 202.0 |
| 2012-04-22 21:30:00 | CL | Futures | 172.51 | 172.56 | 172.41 | 172.43 | 536.0 |
| 2012-04-22 22:00:00 | CL | Futures | 172.44 | 172.49 | 172.41 | 172.49 | 259.0 |
| 2012-04-22 22:30:00 | CL | Futures | 172.51 | 172.64 | 172.49 | 172.56 | 352.0 |
| 2012-04-22 23:00:00 | CL | Futures | 172.54 | 172.69 | 172.53 | 172.59 | 190.0 |
| 2012-04-22 23:30:00 | CL | Futures | 172.58 | 172.64 | 172.51 | 172.51 | 144.0 |
| 2012-04-22 18:00:00 | GC | Futures | 2276.7 | 2276.7 | 2273.6 | 2275.4 | 372.0 |
| 2012-04-22 18:30:00 | GC | Futures | 2275.4 | 2277.3 | 2275.2 | 2277.0 | 117.0 |
> showing 50 of 474 rows — these rows as CSV