PREVIEW / futures_1hour / 2010-03-12
file: by_date/futures_1hour/2010/2010-03-12.parquet size: 37 KB rows: 1,077
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-03-12 00:00:00 | ES | Futures | 1118.75 | 1119.23 | 1118.75 | 1118.99 | 815.0 |
| 2010-03-12 01:00:00 | ES | Futures | 1118.99 | 1118.99 | 1118.02 | 1118.99 | 1250.0 |
| 2010-03-12 02:00:00 | ES | Futures | 1118.75 | 1119.23 | 1118.26 | 1118.5 | 4669.0 |
| 2010-03-12 03:00:00 | ES | Futures | 1118.5 | 1119.72 | 1118.02 | 1118.75 | 8366.0 |
| 2010-03-12 04:00:00 | ES | Futures | 1118.75 | 1120.45 | 1118.02 | 1120.21 | 5083.0 |
| 2010-03-12 05:00:00 | ES | Futures | 1120.21 | 1122.64 | 1119.96 | 1122.15 | 15963.0 |
| 2010-03-12 06:00:00 | ES | Futures | 1122.15 | 1122.64 | 1120.45 | 1120.94 | 4553.0 |
| 2010-03-12 07:00:00 | ES | Futures | 1121.18 | 1122.64 | 1121.18 | 1121.91 | 6961.0 |
| 2010-03-12 08:00:00 | ES | Futures | 1121.91 | 1128.23 | 1120.94 | 1124.59 | 39518.0 |
| 2010-03-12 09:00:00 | ES | Futures | 1124.59 | 1124.59 | 1119.72 | 1120.94 | 73945.0 |
| 2010-03-12 10:00:00 | ES | Futures | 1121.18 | 1121.18 | 1115.83 | 1117.29 | 77125.0 |
| 2010-03-12 11:00:00 | ES | Futures | 1117.77 | 1120.21 | 1116.8 | 1117.77 | 41283.0 |
| 2010-03-12 12:00:00 | ES | Futures | 1118.02 | 1119.23 | 1116.8 | 1118.5 | 16846.0 |
| 2010-03-12 13:00:00 | ES | Futures | 1118.26 | 1119.48 | 1118.02 | 1119.48 | 10367.0 |
| 2010-03-12 14:00:00 | ES | Futures | 1119.48 | 1120.21 | 1117.53 | 1118.5 | 15647.0 |
| 2010-03-12 15:00:00 | ES | Futures | 1118.75 | 1119.23 | 1116.07 | 1118.5 | 34391.0 |
| 2010-03-12 16:00:00 | ES | Futures | 1118.26 | 1120.69 | 1118.26 | 1120.45 | 15702.0 |
| 2010-03-12 00:00:00 | NQ | Futures | 2197.63 | 2198.77 | 2197.63 | 2198.2 | 21.0 |
| 2010-03-12 01:00:00 | NQ | Futures | 2197.63 | 2198.49 | 2197.06 | 2197.92 | 36.0 |
| 2010-03-12 02:00:00 | NQ | Futures | 2197.92 | 2198.77 | 2197.34 | 2197.34 | 169.0 |
| 2010-03-12 03:00:00 | NQ | Futures | 2197.06 | 2199.34 | 2197.06 | 2197.92 | 366.0 |
| 2010-03-12 04:00:00 | NQ | Futures | 2198.2 | 2200.49 | 2197.34 | 2200.49 | 133.0 |
| 2010-03-12 05:00:00 | NQ | Futures | 2200.49 | 2202.49 | 2200.2 | 2201.63 | 785.0 |
| 2010-03-12 06:00:00 | NQ | Futures | 2201.06 | 2202.77 | 2199.63 | 2199.92 | 174.0 |
| 2010-03-12 07:00:00 | NQ | Futures | 2200.77 | 2202.77 | 2200.49 | 2200.77 | 648.0 |
| 2010-03-12 08:00:00 | NQ | Futures | 2201.06 | 2211.06 | 2199.92 | 2205.34 | 3424.0 |
| 2010-03-12 09:00:00 | NQ | Futures | 2205.34 | 2206.2 | 2197.34 | 2201.92 | 11917.0 |
| 2010-03-12 10:00:00 | NQ | Futures | 2202.2 | 2202.49 | 2189.63 | 2194.49 | 8888.0 |
| 2010-03-12 11:00:00 | NQ | Futures | 2195.06 | 2201.63 | 2192.77 | 2197.92 | 6033.0 |
| 2010-03-12 12:00:00 | NQ | Futures | 2198.2 | 2199.92 | 2194.49 | 2198.2 | 4764.0 |
| 2010-03-12 13:00:00 | NQ | Futures | 2198.49 | 2200.49 | 2197.06 | 2200.2 | 1520.0 |
| 2010-03-12 14:00:00 | NQ | Futures | 2200.2 | 2201.63 | 2198.2 | 2200.2 | 2074.0 |
| 2010-03-12 15:00:00 | NQ | Futures | 2200.49 | 2200.49 | 2195.35 | 2199.06 | 5833.0 |
| 2010-03-12 16:00:00 | NQ | Futures | 2198.49 | 2201.34 | 2198.2 | 2200.49 | 1284.0 |
| 2010-03-12 00:00:00 | YM | Futures | 9918.9 | 9918.9 | 9917.0 | 9917.0 | 31.0 |
| 2010-03-12 01:00:00 | YM | Futures | 9917.9 | 9918.9 | 9915.1 | 9917.0 | 39.0 |
| 2010-03-12 02:00:00 | YM | Futures | 9917.0 | 9921.7 | 9914.2 | 9916.0 | 160.0 |
| 2010-03-12 03:00:00 | YM | Futures | 9915.1 | 9925.5 | 9912.3 | 9918.9 | 692.0 |
| 2010-03-12 04:00:00 | YM | Futures | 9918.9 | 9933.0 | 9915.1 | 9931.1 | 690.0 |
| 2010-03-12 05:00:00 | YM | Futures | 9933.0 | 9949.9 | 9933.0 | 9946.2 | 862.0 |
| 2010-03-12 06:00:00 | YM | Futures | 9946.2 | 9950.9 | 9935.8 | 9938.6 | 387.0 |
| 2010-03-12 07:00:00 | YM | Futures | 9938.6 | 9952.7 | 9938.6 | 9948.0 | 493.0 |
| 2010-03-12 08:00:00 | YM | Futures | 9947.1 | 9968.7 | 9937.7 | 9962.2 | 2903.0 |
| 2010-03-12 09:00:00 | YM | Futures | 9961.2 | 9962.2 | 9934.9 | 9948.0 | 13228.0 |
| 2010-03-12 10:00:00 | YM | Futures | 9947.1 | 9948.0 | 9911.3 | 9924.5 | 18858.0 |
| 2010-03-12 11:00:00 | YM | Futures | 9924.5 | 9947.1 | 9918.9 | 9926.4 | 10507.0 |
| 2010-03-12 12:00:00 | YM | Futures | 9925.5 | 9933.9 | 9913.2 | 9925.5 | 7831.0 |
| 2010-03-12 13:00:00 | YM | Futures | 9925.5 | 9938.6 | 9924.5 | 9935.8 | 3368.0 |
| 2010-03-12 14:00:00 | YM | Futures | 9935.8 | 9942.4 | 9920.8 | 9933.0 | 6257.0 |
| 2010-03-12 15:00:00 | YM | Futures | 9933.0 | 9941.5 | 9917.0 | 9936.7 | 7531.0 |
> showing 50 of 1,077 rows — these rows as CSV