PREVIEW / futures_1hour / 2010-07-11
file: by_date/futures_1hour/2010/2010-07-11.parquet size: 12 KB rows: 227
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 |
|---|---|---|---|---|---|---|---|
| 2010-07-11 18:00:00 | ES | Futures | 1051.7 | 1052.43 | 1050.72 | 1051.94 | 3845.0 |
| 2010-07-11 19:00:00 | ES | Futures | 1051.94 | 1051.94 | 1050.22 | 1050.72 | 2825.0 |
| 2010-07-11 20:00:00 | ES | Futures | 1050.72 | 1051.45 | 1049.98 | 1051.21 | 4886.0 |
| 2010-07-11 21:00:00 | ES | Futures | 1050.96 | 1052.19 | 1049.49 | 1049.73 | 4984.0 |
| 2010-07-11 22:00:00 | ES | Futures | 1049.73 | 1051.7 | 1049.49 | 1050.72 | 3690.0 |
| 2010-07-11 23:00:00 | ES | Futures | 1050.47 | 1051.45 | 1049.98 | 1050.96 | 2683.0 |
| 2010-07-11 18:00:00 | NQ | Futures | 2074.74 | 2076.46 | 2073.31 | 2075.6 | 284.0 |
| 2010-07-11 19:00:00 | NQ | Futures | 2075.31 | 2075.6 | 2071.87 | 2073.31 | 203.0 |
| 2010-07-11 20:00:00 | NQ | Futures | 2073.02 | 2074.16 | 2071.87 | 2073.88 | 260.0 |
| 2010-07-11 21:00:00 | NQ | Futures | 2073.88 | 2075.88 | 2071.01 | 2071.3 | 349.0 |
| 2010-07-11 22:00:00 | NQ | Futures | 2071.01 | 2075.6 | 2070.73 | 2073.31 | 380.0 |
| 2010-07-11 23:00:00 | NQ | Futures | 2073.31 | 2074.45 | 2071.59 | 2073.31 | 162.0 |
| 2010-07-11 18:00:00 | YM | Futures | 9576.8 | 9587.2 | 9576.8 | 9582.5 | 233.0 |
| 2010-07-11 19:00:00 | YM | Futures | 9582.5 | 9582.5 | 9572.1 | 9576.8 | 121.0 |
| 2010-07-11 20:00:00 | YM | Futures | 9576.8 | 9580.6 | 9570.2 | 9574.9 | 188.0 |
| 2010-07-11 21:00:00 | YM | Futures | 9577.8 | 9586.3 | 9567.4 | 9568.3 | 334.0 |
| 2010-07-11 22:00:00 | YM | Futures | 9567.4 | 9583.4 | 9566.4 | 9576.8 | 343.0 |
| 2010-07-11 23:00:00 | YM | Futures | 9576.8 | 9581.6 | 9573.0 | 9579.7 | 179.0 |
| 2010-07-11 18:00:00 | CL | Futures | 147.3 | 147.39 | 146.97 | 147.22 | 647.0 |
| 2010-07-11 19:00:00 | CL | Futures | 147.18 | 147.28 | 147.03 | 147.12 | 175.0 |
| 2010-07-11 20:00:00 | CL | Futures | 147.18 | 147.55 | 147.1 | 147.28 | 421.0 |
| 2010-07-11 21:00:00 | CL | Futures | 147.2 | 147.45 | 146.89 | 146.89 | 495.0 |
| 2010-07-11 22:00:00 | CL | Futures | 146.91 | 147.03 | 146.52 | 146.81 | 609.0 |
| 2010-07-11 23:00:00 | CL | Futures | 146.83 | 147.08 | 146.83 | 147.03 | 186.0 |
| 2010-07-11 18:00:00 | GC | Futures | 1701.5 | 1703.1 | 1699.6 | 1700.3 | 629.0 |
| 2010-07-11 19:00:00 | GC | Futures | 1700.6 | 1702.0 | 1696.8 | 1701.7 | 735.0 |
| 2010-07-11 20:00:00 | GC | Futures | 1701.6 | 1702.0 | 1697.1 | 1697.1 | 1010.0 |
| 2010-07-11 21:00:00 | GC | Futures | 1697.2 | 1698.9 | 1696.1 | 1698.2 | 1053.0 |
| 2010-07-11 22:00:00 | GC | Futures | 1698.2 | 1698.2 | 1696.5 | 1697.4 | 333.0 |
| 2010-07-11 23:00:00 | GC | Futures | 1697.4 | 1698.8 | 1696.5 | 1698.2 | 309.0 |
| 2010-07-11 18:00:00 | ZN | Futures | 100.911774 | 100.924705 | 100.885913 | 100.898843 | 1683.0 |
| 2010-07-11 19:00:00 | ZN | Futures | 100.911774 | 100.976428 | 100.898843 | 100.924705 | 2044.0 |
| 2010-07-11 20:00:00 | ZN | Futures | 100.937636 | 100.937636 | 100.898843 | 100.924705 | 3195.0 |
| 2010-07-11 21:00:00 | ZN | Futures | 100.924705 | 100.937636 | 100.898843 | 100.937636 | 1800.0 |
| 2010-07-11 22:00:00 | ZN | Futures | 100.937636 | 100.950567 | 100.924705 | 100.937636 | 1230.0 |
| 2010-07-11 23:00:00 | ZN | Futures | 100.950567 | 100.950567 | 100.911774 | 100.911774 | 994.0 |
> showing 36 of 227 rows — these rows as CSV