PREVIEW / futures_30min / 2013-07-12
file: by_date/futures_30min/2013/2013-07-12.parquet size: 66 KB rows: 2,328
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 |
|---|---|---|---|---|---|---|---|
| 2013-07-12 00:00:00 | ES | Futures | 1724.42 | 1725.71 | 1723.38 | 1724.42 | 2342.0 |
| 2013-07-12 00:30:00 | ES | Futures | 1724.68 | 1725.19 | 1724.42 | 1724.94 | 1289.0 |
| 2013-07-12 01:00:00 | ES | Futures | 1724.94 | 1725.45 | 1724.94 | 1725.45 | 469.0 |
| 2013-07-12 01:30:00 | ES | Futures | 1725.19 | 1725.97 | 1725.19 | 1725.45 | 1440.0 |
| 2013-07-12 02:00:00 | ES | Futures | 1725.45 | 1725.97 | 1723.9 | 1724.68 | 4751.0 |
| 2013-07-12 02:30:00 | ES | Futures | 1724.68 | 1725.19 | 1723.9 | 1724.42 | 3281.0 |
| 2013-07-12 03:00:00 | ES | Futures | 1724.68 | 1726.23 | 1723.38 | 1725.71 | 13964.0 |
| 2013-07-12 03:30:00 | ES | Futures | 1725.45 | 1725.45 | 1723.38 | 1724.16 | 9121.0 |
| 2013-07-12 04:00:00 | ES | Futures | 1724.16 | 1726.23 | 1724.16 | 1725.71 | 8899.0 |
| 2013-07-12 04:30:00 | ES | Futures | 1725.71 | 1725.97 | 1724.68 | 1725.45 | 5231.0 |
| 2013-07-12 05:00:00 | ES | Futures | 1725.71 | 1725.97 | 1724.68 | 1725.19 | 5404.0 |
| 2013-07-12 05:30:00 | ES | Futures | 1725.19 | 1727.52 | 1724.68 | 1727.0 | 8666.0 |
| 2013-07-12 06:00:00 | ES | Futures | 1727.0 | 1728.55 | 1727.0 | 1728.55 | 8911.0 |
| 2013-07-12 06:30:00 | ES | Futures | 1728.55 | 1729.07 | 1727.26 | 1728.81 | 10615.0 |
| 2013-07-12 07:00:00 | ES | Futures | 1728.81 | 1729.59 | 1725.97 | 1727.78 | 16101.0 |
| 2013-07-12 07:30:00 | ES | Futures | 1727.78 | 1728.81 | 1727.52 | 1728.55 | 10080.0 |
| 2013-07-12 08:00:00 | ES | Futures | 1728.55 | 1728.55 | 1726.75 | 1727.52 | 11027.0 |
| 2013-07-12 08:30:00 | ES | Futures | 1727.52 | 1727.52 | 1724.94 | 1725.71 | 25431.0 |
| 2013-07-12 09:00:00 | ES | Futures | 1725.71 | 1727.0 | 1723.64 | 1726.23 | 30712.0 |
| 2013-07-12 09:30:00 | ES | Futures | 1726.49 | 1727.78 | 1724.16 | 1726.23 | 153628.0 |
| 2013-07-12 10:00:00 | ES | Futures | 1726.23 | 1728.04 | 1724.42 | 1727.0 | 82531.0 |
| 2013-07-12 10:30:00 | ES | Futures | 1727.26 | 1729.59 | 1726.23 | 1726.75 | 80486.0 |
| 2013-07-12 11:00:00 | ES | Futures | 1726.75 | 1727.52 | 1725.45 | 1725.71 | 57929.0 |
| 2013-07-12 11:30:00 | ES | Futures | 1725.71 | 1726.49 | 1723.9 | 1724.16 | 58561.0 |
| 2013-07-12 12:00:00 | ES | Futures | 1724.42 | 1724.94 | 1723.64 | 1724.42 | 36226.0 |
| 2013-07-12 12:30:00 | ES | Futures | 1724.68 | 1725.71 | 1723.64 | 1725.45 | 39676.0 |
| 2013-07-12 13:00:00 | ES | Futures | 1725.45 | 1726.49 | 1723.64 | 1725.97 | 60869.0 |
| 2013-07-12 13:30:00 | ES | Futures | 1726.23 | 1727.26 | 1725.19 | 1726.23 | 28343.0 |
| 2013-07-12 14:00:00 | ES | Futures | 1726.23 | 1727.0 | 1724.68 | 1725.97 | 32930.0 |
| 2013-07-12 14:30:00 | ES | Futures | 1725.97 | 1726.75 | 1724.68 | 1726.75 | 27671.0 |
| 2013-07-12 15:00:00 | ES | Futures | 1726.75 | 1727.0 | 1724.94 | 1726.75 | 27771.0 |
| 2013-07-12 15:30:00 | ES | Futures | 1727.0 | 1731.14 | 1726.49 | 1729.33 | 144752.0 |
| 2013-07-12 16:00:00 | ES | Futures | 1729.33 | 1729.59 | 1726.49 | 1727.26 | 101657.0 |
| 2013-07-12 16:30:00 | ES | Futures | 1727.0 | 1727.78 | 1726.75 | 1727.26 | 5166.0 |
| 2013-07-12 17:00:00 | ES | Futures | 1727.0 | 1727.78 | 1726.75 | 1726.75 | 2307.0 |
| 2013-07-12 00:00:00 | NQ | Futures | 3569.08 | 3569.95 | 3567.32 | 3568.49 | 338.0 |
| 2013-07-12 00:30:00 | NQ | Futures | 3569.08 | 3570.25 | 3569.08 | 3569.95 | 111.0 |
| 2013-07-12 01:00:00 | NQ | Futures | 3569.95 | 3570.25 | 3569.66 | 3570.25 | 40.0 |
| 2013-07-12 01:30:00 | NQ | Futures | 3570.54 | 3571.12 | 3569.66 | 3570.83 | 129.0 |
| 2013-07-12 02:00:00 | NQ | Futures | 3570.83 | 3571.71 | 3568.2 | 3570.54 | 744.0 |
| 2013-07-12 02:30:00 | NQ | Futures | 3570.54 | 3571.41 | 3567.62 | 3568.2 | 505.0 |
| 2013-07-12 03:00:00 | NQ | Futures | 3568.78 | 3572.0 | 3567.03 | 3570.83 | 2029.0 |
| 2013-07-12 03:30:00 | NQ | Futures | 3570.25 | 3570.54 | 3566.45 | 3568.2 | 1331.0 |
| 2013-07-12 04:00:00 | NQ | Futures | 3567.91 | 3571.71 | 3567.91 | 3570.54 | 921.0 |
| 2013-07-12 04:30:00 | NQ | Futures | 3570.25 | 3570.54 | 3568.2 | 3569.66 | 752.0 |
| 2013-07-12 05:00:00 | NQ | Futures | 3569.95 | 3570.54 | 3567.91 | 3568.78 | 672.0 |
| 2013-07-12 05:30:00 | NQ | Futures | 3568.78 | 3573.17 | 3568.2 | 3572.58 | 971.0 |
| 2013-07-12 06:00:00 | NQ | Futures | 3573.17 | 3575.21 | 3573.17 | 3575.21 | 1695.0 |
| 2013-07-12 06:30:00 | NQ | Futures | 3575.21 | 3576.67 | 3574.63 | 3576.38 | 2362.0 |
| 2013-07-12 07:00:00 | NQ | Futures | 3576.38 | 3576.97 | 3573.46 | 3576.38 | 4321.0 |
> showing 50 of 2,328 rows — these rows as CSV