PREVIEW / futures_1hour / 2015-05-22
file: by_date/futures_1hour/2015/2015-05-22.parquet size: 43 KB rows: 1,277
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 |
|---|---|---|---|---|---|---|---|
| 2015-05-22 00:00:00 | ES | Futures | 2249.76 | 2251.34 | 2249.76 | 2251.08 | 1934.0 |
| 2015-05-22 01:00:00 | ES | Futures | 2250.81 | 2251.08 | 2249.76 | 2250.81 | 2187.0 |
| 2015-05-22 02:00:00 | ES | Futures | 2251.08 | 2251.08 | 2249.76 | 2250.28 | 4642.0 |
| 2015-05-22 03:00:00 | ES | Futures | 2250.55 | 2250.81 | 2247.91 | 2248.96 | 9492.0 |
| 2015-05-22 04:00:00 | ES | Futures | 2248.7 | 2249.23 | 2247.91 | 2247.91 | 4678.0 |
| 2015-05-22 05:00:00 | ES | Futures | 2248.17 | 2249.23 | 2246.85 | 2247.64 | 8110.0 |
| 2015-05-22 06:00:00 | ES | Futures | 2247.38 | 2248.7 | 2246.32 | 2248.7 | 7474.0 |
| 2015-05-22 07:00:00 | ES | Futures | 2248.7 | 2249.76 | 2247.91 | 2249.49 | 13410.0 |
| 2015-05-22 08:00:00 | ES | Futures | 2249.76 | 2249.76 | 2242.89 | 2245.0 | 53875.0 |
| 2015-05-22 09:00:00 | ES | Futures | 2245.0 | 2247.91 | 2243.15 | 2246.59 | 131195.0 |
| 2015-05-22 10:00:00 | ES | Futures | 2246.85 | 2248.7 | 2245.53 | 2248.17 | 79564.0 |
| 2015-05-22 11:00:00 | ES | Futures | 2247.91 | 2248.43 | 2243.42 | 2246.06 | 95989.0 |
| 2015-05-22 12:00:00 | ES | Futures | 2246.06 | 2247.11 | 2244.47 | 2246.59 | 40959.0 |
| 2015-05-22 13:00:00 | ES | Futures | 2246.32 | 2250.02 | 2245.0 | 2247.64 | 86076.0 |
| 2015-05-22 14:00:00 | ES | Futures | 2247.91 | 2247.91 | 2245.79 | 2247.11 | 57253.0 |
| 2015-05-22 15:00:00 | ES | Futures | 2246.85 | 2249.23 | 2243.42 | 2244.21 | 106906.0 |
| 2015-05-22 16:00:00 | ES | Futures | 2244.21 | 2244.74 | 2242.62 | 2244.47 | 46305.0 |
| 2015-05-22 17:00:00 | ES | Futures | 2244.47 | 2244.74 | 2244.21 | 2244.47 | 776.0 |
| 2015-05-22 00:00:00 | NQ | Futures | 5331.37 | 5334.9 | 5330.78 | 5333.14 | 361.0 |
| 2015-05-22 01:00:00 | NQ | Futures | 5333.43 | 5333.72 | 5331.08 | 5333.43 | 350.0 |
| 2015-05-22 02:00:00 | NQ | Futures | 5333.43 | 5334.02 | 5330.78 | 5334.02 | 489.0 |
| 2015-05-22 03:00:00 | NQ | Futures | 5333.72 | 5334.9 | 5329.31 | 5331.67 | 1453.0 |
| 2015-05-22 04:00:00 | NQ | Futures | 5331.08 | 5333.43 | 5329.61 | 5329.9 | 1017.0 |
| 2015-05-22 05:00:00 | NQ | Futures | 5330.2 | 5331.96 | 5327.84 | 5329.61 | 1145.0 |
| 2015-05-22 06:00:00 | NQ | Futures | 5329.31 | 5331.96 | 5327.55 | 5331.96 | 719.0 |
| 2015-05-22 07:00:00 | NQ | Futures | 5332.25 | 5333.72 | 5328.14 | 5333.43 | 1532.0 |
| 2015-05-22 08:00:00 | NQ | Futures | 5333.72 | 5334.61 | 5320.2 | 5325.78 | 7851.0 |
| 2015-05-22 09:00:00 | NQ | Futures | 5325.49 | 5337.84 | 5319.02 | 5332.25 | 20876.0 |
| 2015-05-22 10:00:00 | NQ | Futures | 5332.84 | 5339.9 | 5330.78 | 5337.55 | 11098.0 |
| 2015-05-22 11:00:00 | NQ | Futures | 5337.55 | 5339.02 | 5323.73 | 5330.49 | 12729.0 |
| 2015-05-22 12:00:00 | NQ | Futures | 5330.49 | 5335.78 | 5328.14 | 5332.55 | 5620.0 |
| 2015-05-22 13:00:00 | NQ | Futures | 5332.55 | 5342.55 | 5329.02 | 5337.55 | 11976.0 |
| 2015-05-22 14:00:00 | NQ | Futures | 5337.55 | 5337.55 | 5329.9 | 5334.31 | 5677.0 |
| 2015-05-22 15:00:00 | NQ | Futures | 5334.02 | 5339.31 | 5323.73 | 5324.61 | 12164.0 |
| 2015-05-22 16:00:00 | NQ | Futures | 5324.61 | 5328.14 | 5320.2 | 5325.49 | 4121.0 |
| 2015-05-22 17:00:00 | NQ | Futures | 5325.2 | 5325.49 | 5324.31 | 5324.9 | 79.0 |
| 2015-05-22 00:00:00 | YM | Futures | 19164.4 | 19185.4 | 19161.2 | 19179.1 | 1500.0 |
| 2015-05-22 01:00:00 | YM | Futures | 19179.1 | 19179.1 | 19154.9 | 19170.7 | 2452.0 |
| 2015-05-22 02:00:00 | YM | Futures | 19167.5 | 19172.8 | 19159.1 | 19170.7 | 789.0 |
| 2015-05-22 03:00:00 | YM | Futures | 19170.7 | 19173.8 | 19154.9 | 19162.3 | 1534.0 |
| 2015-05-22 04:00:00 | YM | Futures | 19161.2 | 19166.5 | 19154.9 | 19156.0 | 867.0 |
| 2015-05-22 05:00:00 | YM | Futures | 19157.0 | 19166.5 | 19146.6 | 19153.9 | 1097.0 |
| 2015-05-22 06:00:00 | YM | Futures | 19153.9 | 19163.3 | 19144.5 | 19162.3 | 1506.0 |
| 2015-05-22 07:00:00 | YM | Futures | 19163.3 | 19168.6 | 19152.8 | 19168.6 | 1541.0 |
| 2015-05-22 08:00:00 | YM | Futures | 19168.6 | 19168.6 | 19114.0 | 19129.8 | 6104.0 |
| 2015-05-22 09:00:00 | YM | Futures | 19130.8 | 19150.7 | 19114.0 | 19125.6 | 12427.0 |
| 2015-05-22 10:00:00 | YM | Futures | 19126.6 | 19143.4 | 19121.4 | 19126.6 | 7276.0 |
| 2015-05-22 11:00:00 | YM | Futures | 19127.7 | 19129.8 | 19076.3 | 19098.3 | 12198.0 |
| 2015-05-22 12:00:00 | YM | Futures | 19099.4 | 19120.3 | 19089.9 | 19116.1 | 4985.0 |
| 2015-05-22 13:00:00 | YM | Futures | 19115.1 | 19149.7 | 19102.5 | 19132.9 | 9879.0 |
> showing 50 of 1,277 rows — these rows as CSV