PREVIEW / futures_30min / 2008-01-04
file: by_date/futures_30min/2008/2008-01-04.parquet size: 37 KB rows: 1,098
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 |
|---|---|---|---|---|---|---|---|
| 2008-01-04 00:00:00 | ES | Futures | 1363.5 | 1363.96 | 1363.26 | 1363.73 | 1452.0 |
| 2008-01-04 00:30:00 | ES | Futures | 1363.73 | 1364.2 | 1363.5 | 1363.73 | 694.0 |
| 2008-01-04 01:00:00 | ES | Futures | 1363.96 | 1364.2 | 1363.5 | 1363.96 | 376.0 |
| 2008-01-04 01:30:00 | ES | Futures | 1364.2 | 1364.43 | 1363.73 | 1363.96 | 549.0 |
| 2008-01-04 02:00:00 | ES | Futures | 1363.96 | 1364.2 | 1362.56 | 1362.8 | 2127.0 |
| 2008-01-04 02:30:00 | ES | Futures | 1363.03 | 1363.03 | 1362.1 | 1362.1 | 990.0 |
| 2008-01-04 03:00:00 | ES | Futures | 1362.33 | 1363.26 | 1361.4 | 1362.33 | 6568.0 |
| 2008-01-04 03:30:00 | ES | Futures | 1362.33 | 1363.03 | 1362.1 | 1362.56 | 2534.0 |
| 2008-01-04 04:00:00 | ES | Futures | 1362.56 | 1363.96 | 1362.33 | 1363.73 | 2172.0 |
| 2008-01-04 04:30:00 | ES | Futures | 1363.73 | 1364.43 | 1363.03 | 1363.73 | 4936.0 |
| 2008-01-04 05:00:00 | ES | Futures | 1363.96 | 1364.66 | 1363.73 | 1364.2 | 4247.0 |
| 2008-01-04 05:30:00 | ES | Futures | 1364.2 | 1364.2 | 1363.03 | 1363.96 | 2629.0 |
| 2008-01-04 06:00:00 | ES | Futures | 1363.73 | 1364.2 | 1363.03 | 1363.73 | 2105.0 |
| 2008-01-04 06:30:00 | ES | Futures | 1363.73 | 1364.43 | 1363.5 | 1363.73 | 2307.0 |
| 2008-01-04 07:00:00 | ES | Futures | 1363.73 | 1363.73 | 1361.4 | 1363.03 | 6565.0 |
| 2008-01-04 07:30:00 | ES | Futures | 1363.03 | 1363.26 | 1362.56 | 1363.03 | 4975.0 |
| 2008-01-04 08:00:00 | ES | Futures | 1363.26 | 1364.66 | 1360.47 | 1363.5 | 32337.0 |
| 2008-01-04 08:30:00 | ES | Futures | 1363.26 | 1363.26 | 1345.08 | 1346.24 | 131192.0 |
| 2008-01-04 09:00:00 | ES | Futures | 1346.48 | 1346.71 | 1343.45 | 1345.78 | 47754.0 |
| 2008-01-04 09:30:00 | ES | Futures | 1345.54 | 1346.48 | 1339.25 | 1342.05 | 214158.0 |
| 2008-01-04 10:00:00 | ES | Futures | 1341.81 | 1344.15 | 1335.52 | 1336.68 | 187596.0 |
| 2008-01-04 10:30:00 | ES | Futures | 1336.68 | 1338.08 | 1331.32 | 1332.25 | 166067.0 |
| 2008-01-04 11:00:00 | ES | Futures | 1332.25 | 1336.92 | 1330.16 | 1336.45 | 153948.0 |
| 2008-01-04 11:30:00 | ES | Futures | 1336.45 | 1337.38 | 1333.42 | 1335.75 | 94293.0 |
| 2008-01-04 12:00:00 | ES | Futures | 1335.98 | 1339.48 | 1333.65 | 1334.35 | 88599.0 |
| 2008-01-04 12:30:00 | ES | Futures | 1334.35 | 1335.75 | 1332.02 | 1334.12 | 65478.0 |
| 2008-01-04 13:00:00 | ES | Futures | 1334.12 | 1334.82 | 1330.62 | 1332.72 | 63782.0 |
| 2008-01-04 13:30:00 | ES | Futures | 1332.49 | 1334.59 | 1328.06 | 1332.95 | 117582.0 |
| 2008-01-04 14:00:00 | ES | Futures | 1332.72 | 1332.95 | 1326.19 | 1326.43 | 131276.0 |
| 2008-01-04 14:30:00 | ES | Futures | 1326.43 | 1328.76 | 1322.93 | 1327.82 | 155971.0 |
| 2008-01-04 15:00:00 | ES | Futures | 1327.82 | 1330.62 | 1324.56 | 1328.76 | 145680.0 |
| 2008-01-04 15:30:00 | ES | Futures | 1328.99 | 1330.62 | 1322.23 | 1322.46 | 214654.0 |
| 2008-01-04 16:00:00 | ES | Futures | 1322.23 | 1327.36 | 1322.0 | 1326.66 | 115375.0 |
| 2008-01-04 00:00:00 | NQ | Futures | 2362.15 | 2362.15 | 2358.46 | 2360.44 | 135.0 |
| 2008-01-04 00:30:00 | NQ | Futures | 2360.44 | 2360.44 | 2359.31 | 2360.16 | 75.0 |
| 2008-01-04 01:00:00 | NQ | Futures | 2360.44 | 2361.01 | 2360.44 | 2360.44 | 26.0 |
| 2008-01-04 01:30:00 | NQ | Futures | 2360.44 | 2361.58 | 2360.16 | 2361.3 | 52.0 |
| 2008-01-04 02:00:00 | NQ | Futures | 2360.44 | 2361.01 | 2358.74 | 2359.02 | 56.0 |
| 2008-01-04 02:30:00 | NQ | Futures | 2358.46 | 2358.46 | 2356.75 | 2357.61 | 71.0 |
| 2008-01-04 03:00:00 | NQ | Futures | 2357.89 | 2359.88 | 2356.19 | 2359.02 | 537.0 |
| 2008-01-04 03:30:00 | NQ | Futures | 2359.31 | 2361.86 | 2357.61 | 2358.46 | 362.0 |
| 2008-01-04 04:00:00 | NQ | Futures | 2358.17 | 2360.73 | 2357.89 | 2360.44 | 125.0 |
| 2008-01-04 04:30:00 | NQ | Futures | 2360.44 | 2362.15 | 2358.17 | 2360.16 | 319.0 |
| 2008-01-04 05:00:00 | NQ | Futures | 2360.16 | 2361.01 | 2359.31 | 2360.44 | 308.0 |
| 2008-01-04 05:30:00 | NQ | Futures | 2360.44 | 2361.01 | 2359.59 | 2360.44 | 234.0 |
| 2008-01-04 06:00:00 | NQ | Futures | 2360.16 | 2360.44 | 2359.02 | 2359.59 | 138.0 |
| 2008-01-04 06:30:00 | NQ | Futures | 2359.88 | 2360.44 | 2358.46 | 2358.74 | 419.0 |
| 2008-01-04 07:00:00 | NQ | Futures | 2358.74 | 2358.74 | 2353.35 | 2356.47 | 1000.0 |
| 2008-01-04 07:30:00 | NQ | Futures | 2356.75 | 2357.61 | 2354.48 | 2355.05 | 989.0 |
| 2008-01-04 08:00:00 | NQ | Futures | 2355.33 | 2357.61 | 2347.95 | 2351.08 | 4892.0 |
> showing 50 of 1,098 rows — these rows as CSV