PREVIEW / futures_1hour / 2009-02-13
file: by_date/futures_1hour/2009/2009-02-13.parquet size: 36 KB rows: 1,003
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-02-13 00:00:00 | ES | Futures | 795.28 | 795.76 | 793.15 | 793.86 | 1570.0 |
| 2009-02-13 01:00:00 | ES | Futures | 793.62 | 795.05 | 792.67 | 793.38 | 1866.0 |
| 2009-02-13 02:00:00 | ES | Futures | 793.38 | 794.1 | 790.3 | 792.67 | 6110.0 |
| 2009-02-13 03:00:00 | ES | Futures | 792.44 | 795.99 | 790.06 | 794.33 | 16183.0 |
| 2009-02-13 04:00:00 | ES | Futures | 794.33 | 797.42 | 792.2 | 795.52 | 15328.0 |
| 2009-02-13 05:00:00 | ES | Futures | 795.52 | 795.76 | 792.44 | 793.15 | 8135.0 |
| 2009-02-13 06:00:00 | ES | Futures | 792.91 | 794.33 | 790.06 | 791.96 | 10657.0 |
| 2009-02-13 07:00:00 | ES | Futures | 791.96 | 796.71 | 791.49 | 794.33 | 15478.0 |
| 2009-02-13 08:00:00 | ES | Futures | 794.1 | 794.81 | 786.98 | 786.98 | 40244.0 |
| 2009-02-13 09:00:00 | ES | Futures | 787.22 | 791.01 | 783.66 | 788.17 | 252122.0 |
| 2009-02-13 10:00:00 | ES | Futures | 788.17 | 794.81 | 785.8 | 792.67 | 352873.0 |
| 2009-02-13 11:00:00 | ES | Futures | 792.44 | 792.91 | 783.66 | 783.66 | 229806.0 |
| 2009-02-13 12:00:00 | ES | Futures | 783.66 | 786.98 | 780.58 | 782.0 | 205028.0 |
| 2009-02-13 13:00:00 | ES | Futures | 782.0 | 792.67 | 781.29 | 790.78 | 199851.0 |
| 2009-02-13 14:00:00 | ES | Futures | 790.78 | 792.44 | 786.51 | 788.4 | 211064.0 |
| 2009-02-13 15:00:00 | ES | Futures | 788.17 | 789.59 | 780.81 | 781.05 | 326319.0 |
| 2009-02-13 16:00:00 | ES | Futures | 780.81 | 782.0 | 776.78 | 777.97 | 106598.0 |
| 2009-02-13 00:00:00 | NQ | Futures | 1412.75 | 1413.6 | 1408.23 | 1408.51 | 200.0 |
| 2009-02-13 01:00:00 | NQ | Futures | 1408.51 | 1408.51 | 1404.56 | 1406.82 | 240.0 |
| 2009-02-13 02:00:00 | NQ | Futures | 1406.54 | 1409.93 | 1404.0 | 1409.08 | 485.0 |
| 2009-02-13 03:00:00 | NQ | Futures | 1409.08 | 1413.6 | 1405.69 | 1411.9 | 1229.0 |
| 2009-02-13 04:00:00 | NQ | Futures | 1411.9 | 1416.42 | 1409.08 | 1413.88 | 1450.0 |
| 2009-02-13 05:00:00 | NQ | Futures | 1413.88 | 1415.86 | 1411.9 | 1412.47 | 946.0 |
| 2009-02-13 06:00:00 | NQ | Futures | 1412.47 | 1414.73 | 1407.95 | 1411.06 | 1346.0 |
| 2009-02-13 07:00:00 | NQ | Futures | 1411.9 | 1417.55 | 1409.36 | 1410.21 | 1483.0 |
| 2009-02-13 08:00:00 | NQ | Futures | 1409.93 | 1411.06 | 1397.78 | 1397.78 | 3474.0 |
| 2009-02-13 09:00:00 | NQ | Futures | 1397.5 | 1404.0 | 1389.03 | 1398.35 | 36584.0 |
| 2009-02-13 10:00:00 | NQ | Futures | 1398.35 | 1410.77 | 1392.42 | 1408.23 | 49636.0 |
| 2009-02-13 11:00:00 | NQ | Futures | 1407.95 | 1408.8 | 1394.68 | 1394.68 | 32548.0 |
| 2009-02-13 12:00:00 | NQ | Futures | 1394.68 | 1400.61 | 1389.31 | 1391.57 | 30129.0 |
| 2009-02-13 13:00:00 | NQ | Futures | 1391.57 | 1408.8 | 1390.44 | 1405.69 | 30071.0 |
| 2009-02-13 14:00:00 | NQ | Futures | 1405.97 | 1409.64 | 1399.2 | 1403.71 | 34956.0 |
| 2009-02-13 15:00:00 | NQ | Futures | 1403.71 | 1406.54 | 1393.55 | 1394.4 | 45902.0 |
| 2009-02-13 16:00:00 | NQ | Futures | 1394.68 | 1394.96 | 1384.79 | 1387.62 | 14443.0 |
| 2009-02-13 00:00:00 | YM | Futures | 7241.9 | 7243.7 | 7226.4 | 7230.0 | 128.0 |
| 2009-02-13 01:00:00 | YM | Futures | 7231.0 | 7239.2 | 7221.8 | 7231.0 | 231.0 |
| 2009-02-13 02:00:00 | YM | Futures | 7232.8 | 7234.6 | 7207.3 | 7221.8 | 478.0 |
| 2009-02-13 03:00:00 | YM | Futures | 7220.0 | 7252.8 | 7202.7 | 7241.0 | 1618.0 |
| 2009-02-13 04:00:00 | YM | Futures | 7241.0 | 7258.3 | 7221.8 | 7247.4 | 852.0 |
| 2009-02-13 05:00:00 | YM | Futures | 7247.4 | 7251.9 | 7221.8 | 7228.2 | 472.0 |
| 2009-02-13 06:00:00 | YM | Futures | 7227.3 | 7234.6 | 7204.5 | 7220.0 | 561.0 |
| 2009-02-13 07:00:00 | YM | Futures | 7221.8 | 7252.8 | 7219.1 | 7237.3 | 923.0 |
| 2009-02-13 08:00:00 | YM | Futures | 7238.2 | 7245.5 | 7182.7 | 7184.5 | 2242.0 |
| 2009-02-13 09:00:00 | YM | Futures | 7183.6 | 7216.4 | 7148.0 | 7182.7 | 21272.0 |
| 2009-02-13 10:00:00 | YM | Futures | 7181.7 | 7240.1 | 7162.6 | 7220.0 | 33150.0 |
| 2009-02-13 11:00:00 | YM | Futures | 7220.0 | 7222.8 | 7135.3 | 7137.1 | 23168.0 |
| 2009-02-13 12:00:00 | YM | Futures | 7138.0 | 7160.8 | 7117.0 | 7127.1 | 20206.0 |
| 2009-02-13 13:00:00 | YM | Futures | 7127.1 | 7211.8 | 7118.9 | 7199.1 | 21411.0 |
| 2009-02-13 14:00:00 | YM | Futures | 7198.2 | 7214.6 | 7161.7 | 7179.9 | 30594.0 |
| 2009-02-13 15:00:00 | YM | Futures | 7179.9 | 7187.2 | 7112.5 | 7113.4 | 31530.0 |
> showing 50 of 1,003 rows — these rows as CSV