PREVIEW / futures_1hour / 2010-03-19
file: by_date/futures_1hour/2010/2010-03-19.parquet size: 38 KB rows: 1,084
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-19 00:00:00 | ES | Futures | 1135.36 | 1135.85 | 1135.12 | 1135.6 | 1176.0 |
| 2010-03-19 01:00:00 | ES | Futures | 1135.36 | 1136.09 | 1135.12 | 1135.36 | 1409.0 |
| 2010-03-19 02:00:00 | ES | Futures | 1135.36 | 1136.09 | 1135.12 | 1136.09 | 1337.0 |
| 2010-03-19 03:00:00 | ES | Futures | 1135.85 | 1136.34 | 1135.36 | 1135.85 | 4842.0 |
| 2010-03-19 04:00:00 | ES | Futures | 1135.85 | 1136.58 | 1134.38 | 1135.12 | 14043.0 |
| 2010-03-19 05:00:00 | ES | Futures | 1135.12 | 1136.09 | 1133.89 | 1135.12 | 12109.0 |
| 2010-03-19 06:00:00 | ES | Futures | 1135.12 | 1136.83 | 1134.63 | 1136.34 | 17939.0 |
| 2010-03-19 07:00:00 | ES | Futures | 1136.34 | 1136.58 | 1134.38 | 1135.6 | 16625.0 |
| 2010-03-19 08:00:00 | ES | Futures | 1135.6 | 1137.56 | 1135.36 | 1137.56 | 49888.0 |
| 2010-03-19 09:00:00 | ES | Futures | 1137.32 | 1139.03 | 1134.63 | 1135.6 | 350231.0 |
| 2010-03-19 10:00:00 | ES | Futures | 1135.85 | 1135.85 | 1128.76 | 1129.98 | 400698.0 |
| 2010-03-19 11:00:00 | ES | Futures | 1130.23 | 1130.47 | 1126.32 | 1128.76 | 303952.0 |
| 2010-03-19 12:00:00 | ES | Futures | 1128.52 | 1129.49 | 1126.81 | 1128.03 | 148241.0 |
| 2010-03-19 13:00:00 | ES | Futures | 1128.03 | 1129.25 | 1126.81 | 1128.76 | 94365.0 |
| 2010-03-19 14:00:00 | ES | Futures | 1128.52 | 1130.47 | 1127.78 | 1128.03 | 154407.0 |
| 2010-03-19 15:00:00 | ES | Futures | 1128.03 | 1129.25 | 1124.61 | 1129.25 | 392263.0 |
| 2010-03-19 16:00:00 | ES | Futures | 1129.0 | 1130.96 | 1128.76 | 1130.47 | 141202.0 |
| 2010-03-19 00:00:00 | NQ | Futures | 2223.11 | 2223.97 | 2223.11 | 2223.97 | 68.0 |
| 2010-03-19 01:00:00 | NQ | Futures | 2223.68 | 2224.26 | 2223.11 | 2223.4 | 95.0 |
| 2010-03-19 02:00:00 | NQ | Futures | 2223.68 | 2224.54 | 2223.68 | 2224.26 | 92.0 |
| 2010-03-19 03:00:00 | NQ | Futures | 2224.26 | 2224.26 | 2223.11 | 2223.68 | 365.0 |
| 2010-03-19 04:00:00 | NQ | Futures | 2223.68 | 2224.83 | 2221.39 | 2222.54 | 1226.0 |
| 2010-03-19 05:00:00 | NQ | Futures | 2222.54 | 2224.54 | 2220.82 | 2222.25 | 1416.0 |
| 2010-03-19 06:00:00 | NQ | Futures | 2222.54 | 2225.69 | 2221.96 | 2225.4 | 1484.0 |
| 2010-03-19 07:00:00 | NQ | Futures | 2225.4 | 2225.69 | 2222.82 | 2225.4 | 1396.0 |
| 2010-03-19 08:00:00 | NQ | Futures | 2225.4 | 2229.98 | 2225.12 | 2229.7 | 7484.0 |
| 2010-03-19 09:00:00 | NQ | Futures | 2229.7 | 2231.7 | 2220.25 | 2222.54 | 55680.0 |
| 2010-03-19 10:00:00 | NQ | Futures | 2222.54 | 2222.82 | 2207.93 | 2210.8 | 64672.0 |
| 2010-03-19 11:00:00 | NQ | Futures | 2210.8 | 2211.66 | 2204.78 | 2210.22 | 40389.0 |
| 2010-03-19 12:00:00 | NQ | Futures | 2209.94 | 2212.23 | 2205.07 | 2206.79 | 23807.0 |
| 2010-03-19 13:00:00 | NQ | Futures | 2206.79 | 2209.08 | 2205.36 | 2208.79 | 19324.0 |
| 2010-03-19 14:00:00 | NQ | Futures | 2208.51 | 2211.37 | 2207.36 | 2207.93 | 19926.0 |
| 2010-03-19 15:00:00 | NQ | Futures | 2207.93 | 2210.51 | 2201.92 | 2209.65 | 41356.0 |
| 2010-03-19 16:00:00 | NQ | Futures | 2209.65 | 2214.52 | 2208.51 | 2211.66 | 11983.0 |
| 2010-03-19 00:00:00 | YM | Futures | 10079.8 | 10082.6 | 10078.8 | 10082.6 | 69.0 |
| 2010-03-19 01:00:00 | YM | Futures | 10082.6 | 10085.4 | 10079.8 | 10080.7 | 46.0 |
| 2010-03-19 02:00:00 | YM | Futures | 10081.7 | 10087.3 | 10080.7 | 10084.5 | 198.0 |
| 2010-03-19 03:00:00 | YM | Futures | 10083.5 | 10087.3 | 10082.6 | 10084.5 | 268.0 |
| 2010-03-19 04:00:00 | YM | Futures | 10086.4 | 10093.9 | 10076.0 | 10080.7 | 1168.0 |
| 2010-03-19 05:00:00 | YM | Futures | 10079.8 | 10091.1 | 10077.0 | 10084.5 | 831.0 |
| 2010-03-19 06:00:00 | YM | Futures | 10084.5 | 10096.7 | 10082.6 | 10090.1 | 913.0 |
| 2010-03-19 07:00:00 | YM | Futures | 10091.1 | 10092.0 | 10077.0 | 10083.5 | 1836.0 |
| 2010-03-19 08:00:00 | YM | Futures | 10086.4 | 10102.4 | 10079.8 | 10101.4 | 2051.0 |
| 2010-03-19 09:00:00 | YM | Futures | 10101.4 | 10122.1 | 10079.8 | 10091.1 | 20219.0 |
| 2010-03-19 10:00:00 | YM | Futures | 10091.1 | 10094.8 | 10045.9 | 10052.5 | 22468.0 |
| 2010-03-19 11:00:00 | YM | Futures | 10052.5 | 10055.3 | 10017.7 | 10037.4 | 19619.0 |
| 2010-03-19 12:00:00 | YM | Futures | 10039.3 | 10044.0 | 10024.3 | 10027.1 | 9930.0 |
| 2010-03-19 13:00:00 | YM | Futures | 10027.1 | 10036.5 | 10007.3 | 10031.8 | 10704.0 |
| 2010-03-19 14:00:00 | YM | Futures | 10030.8 | 10049.7 | 10026.1 | 10030.8 | 11638.0 |
| 2010-03-19 15:00:00 | YM | Futures | 10029.9 | 10046.8 | 10004.5 | 10045.9 | 20054.0 |
> showing 50 of 1,084 rows — these rows as CSV