PREVIEW / futures_30min / 2009-12-18
file: by_date/futures_30min/2009/2009-12-18.parquet size: 58 KB rows: 2,028
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 |
|---|---|---|---|---|---|---|---|
| 2009-12-18 00:00:00 | ES | Futures | 1067.18 | 1067.42 | 1066.69 | 1066.69 | 1114.0 |
| 2009-12-18 00:30:00 | ES | Futures | 1066.93 | 1067.66 | 1066.69 | 1067.66 | 530.0 |
| 2009-12-18 01:00:00 | ES | Futures | 1067.42 | 1069.37 | 1067.42 | 1068.88 | 3386.0 |
| 2009-12-18 01:30:00 | ES | Futures | 1068.88 | 1069.37 | 1067.66 | 1067.66 | 1718.0 |
| 2009-12-18 02:00:00 | ES | Futures | 1067.91 | 1069.37 | 1066.93 | 1069.12 | 5308.0 |
| 2009-12-18 02:30:00 | ES | Futures | 1068.88 | 1069.37 | 1067.91 | 1068.39 | 4254.0 |
| 2009-12-18 03:00:00 | ES | Futures | 1068.15 | 1070.1 | 1068.15 | 1069.85 | 11025.0 |
| 2009-12-18 03:30:00 | ES | Futures | 1069.85 | 1070.34 | 1068.39 | 1068.64 | 10193.0 |
| 2009-12-18 04:00:00 | ES | Futures | 1068.39 | 1070.34 | 1068.39 | 1068.88 | 7817.0 |
| 2009-12-18 04:30:00 | ES | Futures | 1068.88 | 1071.07 | 1068.64 | 1070.83 | 5929.0 |
| 2009-12-18 05:00:00 | ES | Futures | 1070.83 | 1073.01 | 1070.58 | 1072.28 | 14757.0 |
| 2009-12-18 05:30:00 | ES | Futures | 1072.28 | 1073.01 | 1070.34 | 1071.07 | 10169.0 |
| 2009-12-18 06:00:00 | ES | Futures | 1070.83 | 1071.8 | 1070.1 | 1070.58 | 7595.0 |
| 2009-12-18 06:30:00 | ES | Futures | 1070.58 | 1071.07 | 1066.93 | 1067.66 | 15676.0 |
| 2009-12-18 07:00:00 | ES | Futures | 1067.42 | 1070.34 | 1067.42 | 1070.1 | 20255.0 |
| 2009-12-18 07:30:00 | ES | Futures | 1069.85 | 1070.34 | 1068.15 | 1069.37 | 18040.0 |
| 2009-12-18 08:00:00 | ES | Futures | 1069.37 | 1070.1 | 1067.42 | 1068.39 | 14064.0 |
| 2009-12-18 08:30:00 | ES | Futures | 1068.39 | 1068.64 | 1066.69 | 1066.93 | 18626.0 |
| 2009-12-18 09:00:00 | ES | Futures | 1066.93 | 1068.39 | 1066.45 | 1068.15 | 47970.0 |
| 2009-12-18 09:30:00 | ES | Futures | 1068.39 | 1069.37 | 1065.47 | 1066.93 | 183658.0 |
| 2009-12-18 10:00:00 | ES | Futures | 1066.93 | 1068.39 | 1064.74 | 1065.96 | 119033.0 |
| 2009-12-18 10:30:00 | ES | Futures | 1065.96 | 1066.2 | 1062.55 | 1064.01 | 132225.0 |
| 2009-12-18 11:00:00 | ES | Futures | 1063.77 | 1064.5 | 1059.15 | 1061.09 | 127103.0 |
| 2009-12-18 11:30:00 | ES | Futures | 1061.09 | 1061.58 | 1059.39 | 1061.34 | 101013.0 |
| 2009-12-18 12:00:00 | ES | Futures | 1061.34 | 1064.26 | 1060.37 | 1063.77 | 74752.0 |
| 2009-12-18 12:30:00 | ES | Futures | 1064.01 | 1064.99 | 1063.28 | 1064.26 | 68900.0 |
| 2009-12-18 13:00:00 | ES | Futures | 1064.5 | 1066.93 | 1064.01 | 1066.69 | 77977.0 |
| 2009-12-18 13:30:00 | ES | Futures | 1066.69 | 1066.93 | 1064.74 | 1065.47 | 51027.0 |
| 2009-12-18 14:00:00 | ES | Futures | 1065.47 | 1065.96 | 1064.5 | 1065.23 | 42893.0 |
| 2009-12-18 14:30:00 | ES | Futures | 1065.23 | 1066.2 | 1064.26 | 1065.96 | 47444.0 |
| 2009-12-18 15:00:00 | ES | Futures | 1065.96 | 1066.69 | 1064.74 | 1064.74 | 54840.0 |
| 2009-12-18 15:30:00 | ES | Futures | 1064.74 | 1069.37 | 1063.53 | 1068.64 | 237034.0 |
| 2009-12-18 16:00:00 | ES | Futures | 1068.88 | 1069.12 | 1067.18 | 1068.39 | 123282.0 |
| 2009-12-18 00:00:00 | NQ | Futures | 2043.68 | 2044.53 | 2043.68 | 2043.68 | 98.0 |
| 2009-12-18 00:30:00 | NQ | Futures | 2043.96 | 2046.53 | 2043.96 | 2046.25 | 118.0 |
| 2009-12-18 01:00:00 | NQ | Futures | 2046.53 | 2047.1 | 2045.68 | 2045.96 | 220.0 |
| 2009-12-18 01:30:00 | NQ | Futures | 2045.96 | 2046.25 | 2043.68 | 2044.53 | 190.0 |
| 2009-12-18 02:00:00 | NQ | Futures | 2044.25 | 2045.39 | 2041.96 | 2045.1 | 619.0 |
| 2009-12-18 02:30:00 | NQ | Futures | 2045.1 | 2045.39 | 2043.11 | 2043.11 | 313.0 |
| 2009-12-18 03:00:00 | NQ | Futures | 2043.11 | 2047.96 | 2043.11 | 2047.39 | 802.0 |
| 2009-12-18 03:30:00 | NQ | Futures | 2047.1 | 2048.82 | 2043.11 | 2043.68 | 1670.0 |
| 2009-12-18 04:00:00 | NQ | Futures | 2043.68 | 2046.82 | 2043.68 | 2045.1 | 636.0 |
| 2009-12-18 04:30:00 | NQ | Futures | 2044.82 | 2048.25 | 2044.82 | 2047.96 | 316.0 |
| 2009-12-18 05:00:00 | NQ | Futures | 2047.96 | 2051.1 | 2047.39 | 2050.25 | 1285.0 |
| 2009-12-18 05:30:00 | NQ | Futures | 2050.53 | 2051.39 | 2046.82 | 2048.25 | 949.0 |
| 2009-12-18 06:00:00 | NQ | Futures | 2048.53 | 2049.1 | 2046.25 | 2047.1 | 551.0 |
| 2009-12-18 06:30:00 | NQ | Futures | 2046.82 | 2047.68 | 2041.96 | 2043.11 | 1048.0 |
| 2009-12-18 07:00:00 | NQ | Futures | 2043.11 | 2046.82 | 2042.53 | 2045.68 | 1033.0 |
| 2009-12-18 07:30:00 | NQ | Futures | 2045.68 | 2046.53 | 2044.53 | 2045.68 | 985.0 |
| 2009-12-18 08:00:00 | NQ | Futures | 2045.68 | 2046.53 | 2042.53 | 2044.25 | 1344.0 |
> showing 50 of 2,028 rows — these rows as CSV