PREVIEW / futures_1hour / 2010-11-12
file: by_date/futures_1hour/2010/2010-11-12.parquet size: 41 KB rows: 1,156
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-11-12 00:00:00 | ES | Futures | 1186.55 | 1186.55 | 1182.11 | 1182.61 | 12387.0 |
| 2010-11-12 01:00:00 | ES | Futures | 1182.61 | 1183.84 | 1181.37 | 1181.62 | 10393.0 |
| 2010-11-12 02:00:00 | ES | Futures | 1181.87 | 1182.11 | 1178.42 | 1180.63 | 54044.0 |
| 2010-11-12 03:00:00 | ES | Futures | 1180.88 | 1182.11 | 1176.2 | 1181.37 | 68031.0 |
| 2010-11-12 04:00:00 | ES | Futures | 1181.37 | 1183.59 | 1180.14 | 1182.85 | 36904.0 |
| 2010-11-12 05:00:00 | ES | Futures | 1182.85 | 1190.49 | 1181.87 | 1187.54 | 63489.0 |
| 2010-11-12 06:00:00 | ES | Futures | 1187.78 | 1187.78 | 1184.58 | 1187.04 | 49685.0 |
| 2010-11-12 07:00:00 | ES | Futures | 1186.8 | 1188.52 | 1185.32 | 1186.3 | 37501.0 |
| 2010-11-12 08:00:00 | ES | Futures | 1186.3 | 1188.52 | 1184.58 | 1188.52 | 72155.0 |
| 2010-11-12 09:00:00 | ES | Futures | 1188.27 | 1191.73 | 1185.32 | 1190.25 | 296432.0 |
| 2010-11-12 10:00:00 | ES | Futures | 1190.49 | 1191.23 | 1181.37 | 1182.11 | 460994.0 |
| 2010-11-12 11:00:00 | ES | Futures | 1181.87 | 1184.82 | 1179.89 | 1181.62 | 288221.0 |
| 2010-11-12 12:00:00 | ES | Futures | 1181.62 | 1182.36 | 1174.96 | 1176.2 | 396171.0 |
| 2010-11-12 13:00:00 | ES | Futures | 1176.2 | 1179.4 | 1174.72 | 1176.44 | 202138.0 |
| 2010-11-12 14:00:00 | ES | Futures | 1176.44 | 1180.88 | 1175.46 | 1179.4 | 166661.0 |
| 2010-11-12 15:00:00 | ES | Futures | 1179.4 | 1182.36 | 1177.68 | 1180.14 | 354825.0 |
| 2010-11-12 16:00:00 | ES | Futures | 1180.14 | 1180.39 | 1177.68 | 1177.92 | 117307.0 |
| 2010-11-12 00:00:00 | NQ | Futures | 2478.55 | 2478.84 | 2470.23 | 2470.52 | 692.0 |
| 2010-11-12 01:00:00 | NQ | Futures | 2470.23 | 2473.39 | 2465.07 | 2468.8 | 1409.0 |
| 2010-11-12 02:00:00 | NQ | Futures | 2468.8 | 2468.8 | 2462.77 | 2466.79 | 2286.0 |
| 2010-11-12 03:00:00 | NQ | Futures | 2466.5 | 2466.79 | 2458.75 | 2465.35 | 4959.0 |
| 2010-11-12 04:00:00 | NQ | Futures | 2465.35 | 2470.8 | 2463.34 | 2469.08 | 1894.0 |
| 2010-11-12 05:00:00 | NQ | Futures | 2469.08 | 2481.99 | 2467.07 | 2477.98 | 3862.0 |
| 2010-11-12 06:00:00 | NQ | Futures | 2477.69 | 2478.84 | 2472.24 | 2477.4 | 3831.0 |
| 2010-11-12 07:00:00 | NQ | Futures | 2477.98 | 2480.85 | 2475.39 | 2476.54 | 2466.0 |
| 2010-11-12 08:00:00 | NQ | Futures | 2476.54 | 2480.56 | 2473.39 | 2478.84 | 7154.0 |
| 2010-11-12 09:00:00 | NQ | Futures | 2478.84 | 2489.17 | 2476.54 | 2486.3 | 46000.0 |
| 2010-11-12 10:00:00 | NQ | Futures | 2486.3 | 2487.44 | 2461.05 | 2462.2 | 63398.0 |
| 2010-11-12 11:00:00 | NQ | Futures | 2462.2 | 2467.36 | 2457.03 | 2459.33 | 44630.0 |
| 2010-11-12 12:00:00 | NQ | Futures | 2459.62 | 2460.76 | 2432.07 | 2439.53 | 72724.0 |
| 2010-11-12 13:00:00 | NQ | Futures | 2439.53 | 2449.57 | 2436.66 | 2442.4 | 34094.0 |
| 2010-11-12 14:00:00 | NQ | Futures | 2442.4 | 2456.75 | 2440.97 | 2453.88 | 31572.0 |
| 2010-11-12 15:00:00 | NQ | Futures | 2453.88 | 2459.62 | 2448.43 | 2450.43 | 57896.0 |
| 2010-11-12 16:00:00 | NQ | Futures | 2450.15 | 2453.02 | 2448.71 | 2449.29 | 8633.0 |
| 2010-11-12 00:00:00 | YM | Futures | 10651.6 | 10657.3 | 10623.0 | 10629.7 | 858.0 |
| 2010-11-12 01:00:00 | YM | Futures | 10629.7 | 10634.4 | 10618.2 | 10623.0 | 745.0 |
| 2010-11-12 02:00:00 | YM | Futures | 10623.0 | 10623.0 | 10595.4 | 10612.5 | 2415.0 |
| 2010-11-12 03:00:00 | YM | Futures | 10612.5 | 10622.0 | 10579.2 | 10617.3 | 3583.0 |
| 2010-11-12 04:00:00 | YM | Futures | 10616.3 | 10636.3 | 10608.7 | 10627.8 | 1503.0 |
| 2010-11-12 05:00:00 | YM | Futures | 10626.8 | 10687.8 | 10619.2 | 10668.7 | 2070.0 |
| 2010-11-12 06:00:00 | YM | Futures | 10669.7 | 10669.7 | 10641.1 | 10662.1 | 2034.0 |
| 2010-11-12 07:00:00 | YM | Futures | 10662.1 | 10674.4 | 10652.5 | 10658.2 | 1621.0 |
| 2010-11-12 08:00:00 | YM | Futures | 10659.2 | 10675.4 | 10648.7 | 10671.6 | 3670.0 |
| 2010-11-12 09:00:00 | YM | Futures | 10672.5 | 10708.7 | 10645.9 | 10698.3 | 18730.0 |
| 2010-11-12 10:00:00 | YM | Futures | 10698.3 | 10706.8 | 10621.1 | 10628.7 | 27029.0 |
| 2010-11-12 11:00:00 | YM | Futures | 10628.7 | 10660.2 | 10624.0 | 10634.4 | 15167.0 |
| 2010-11-12 12:00:00 | YM | Futures | 10635.4 | 10640.1 | 10584.9 | 10592.5 | 23810.0 |
| 2010-11-12 13:00:00 | YM | Futures | 10593.5 | 10622.0 | 10581.1 | 10599.2 | 11848.0 |
| 2010-11-12 14:00:00 | YM | Futures | 10599.2 | 10633.5 | 10587.8 | 10624.0 | 10165.0 |
| 2010-11-12 15:00:00 | YM | Futures | 10623.0 | 10644.0 | 10605.9 | 10629.7 | 21554.0 |
> showing 50 of 1,156 rows — these rows as CSV