PREVIEW / futures_1hour / 2009-03-27
file: by_date/futures_1hour/2009/2009-03-27.parquet size: 37 KB rows: 1,015
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-03-27 00:00:00 | ES | Futures | 790.31 | 791.03 | 789.35 | 790.07 | 2053.0 |
| 2009-03-27 01:00:00 | ES | Futures | 790.07 | 790.79 | 788.63 | 788.63 | 1820.0 |
| 2009-03-27 02:00:00 | ES | Futures | 788.87 | 789.83 | 788.16 | 789.35 | 1956.0 |
| 2009-03-27 03:00:00 | ES | Futures | 789.35 | 791.51 | 787.92 | 788.63 | 6983.0 |
| 2009-03-27 04:00:00 | ES | Futures | 788.4 | 790.79 | 787.68 | 790.07 | 19153.0 |
| 2009-03-27 05:00:00 | ES | Futures | 790.07 | 791.03 | 786.48 | 787.92 | 14553.0 |
| 2009-03-27 06:00:00 | ES | Futures | 788.16 | 788.4 | 785.04 | 786.0 | 24263.0 |
| 2009-03-27 07:00:00 | ES | Futures | 785.76 | 788.87 | 783.84 | 784.56 | 30481.0 |
| 2009-03-27 08:00:00 | ES | Futures | 784.56 | 786.48 | 782.16 | 784.08 | 46665.0 |
| 2009-03-27 09:00:00 | ES | Futures | 784.32 | 785.04 | 779.53 | 782.4 | 229241.0 |
| 2009-03-27 10:00:00 | ES | Futures | 782.4 | 785.52 | 777.85 | 783.6 | 345186.0 |
| 2009-03-27 11:00:00 | ES | Futures | 783.6 | 787.44 | 782.16 | 784.8 | 259055.0 |
| 2009-03-27 12:00:00 | ES | Futures | 784.8 | 787.44 | 780.49 | 780.97 | 173000.0 |
| 2009-03-27 13:00:00 | ES | Futures | 780.97 | 784.8 | 775.93 | 777.85 | 258921.0 |
| 2009-03-27 14:00:00 | ES | Futures | 777.61 | 783.12 | 775.93 | 782.16 | 285783.0 |
| 2009-03-27 15:00:00 | ES | Futures | 782.16 | 786.0 | 776.17 | 778.81 | 367593.0 |
| 2009-03-27 16:00:00 | ES | Futures | 778.57 | 783.12 | 778.33 | 781.69 | 111907.0 |
| 2009-03-27 00:00:00 | NQ | Futures | 1442.01 | 1442.86 | 1440.59 | 1442.29 | 76.0 |
| 2009-03-27 01:00:00 | NQ | Futures | 1441.73 | 1442.58 | 1438.88 | 1438.88 | 123.0 |
| 2009-03-27 02:00:00 | NQ | Futures | 1439.17 | 1440.59 | 1438.6 | 1440.59 | 217.0 |
| 2009-03-27 03:00:00 | NQ | Futures | 1440.3 | 1444.85 | 1438.6 | 1439.17 | 497.0 |
| 2009-03-27 04:00:00 | NQ | Futures | 1438.88 | 1442.86 | 1437.75 | 1441.16 | 743.0 |
| 2009-03-27 05:00:00 | NQ | Futures | 1441.16 | 1442.86 | 1435.76 | 1438.88 | 725.0 |
| 2009-03-27 06:00:00 | NQ | Futures | 1438.6 | 1438.88 | 1433.49 | 1434.62 | 1507.0 |
| 2009-03-27 07:00:00 | NQ | Futures | 1434.91 | 1440.87 | 1428.37 | 1431.21 | 4023.0 |
| 2009-03-27 08:00:00 | NQ | Futures | 1431.21 | 1433.49 | 1427.52 | 1429.51 | 6612.0 |
| 2009-03-27 09:00:00 | NQ | Futures | 1429.22 | 1436.61 | 1426.38 | 1431.21 | 33986.0 |
| 2009-03-27 10:00:00 | NQ | Futures | 1431.5 | 1437.18 | 1424.39 | 1434.34 | 38089.0 |
| 2009-03-27 11:00:00 | NQ | Futures | 1434.62 | 1440.02 | 1427.52 | 1436.04 | 38514.0 |
| 2009-03-27 12:00:00 | NQ | Futures | 1436.04 | 1439.74 | 1426.1 | 1426.67 | 27605.0 |
| 2009-03-27 13:00:00 | NQ | Futures | 1426.67 | 1430.36 | 1418.43 | 1421.55 | 33316.0 |
| 2009-03-27 14:00:00 | NQ | Futures | 1421.55 | 1430.08 | 1419.56 | 1426.95 | 31359.0 |
| 2009-03-27 15:00:00 | NQ | Futures | 1426.95 | 1434.34 | 1418.43 | 1421.55 | 44893.0 |
| 2009-03-27 16:00:00 | NQ | Futures | 1421.84 | 1427.23 | 1420.7 | 1425.53 | 9178.0 |
| 2009-03-27 00:00:00 | YM | Futures | 7188.0 | 7198.1 | 7185.3 | 7190.8 | 94.0 |
| 2009-03-27 01:00:00 | YM | Futures | 7189.9 | 7195.4 | 7176.1 | 7176.1 | 132.0 |
| 2009-03-27 02:00:00 | YM | Futures | 7177.9 | 7186.2 | 7173.3 | 7182.5 | 217.0 |
| 2009-03-27 03:00:00 | YM | Futures | 7183.4 | 7199.0 | 7172.4 | 7177.9 | 467.0 |
| 2009-03-27 04:00:00 | YM | Futures | 7177.9 | 7196.3 | 7171.5 | 7188.9 | 1081.0 |
| 2009-03-27 05:00:00 | YM | Futures | 7189.9 | 7198.1 | 7164.1 | 7173.3 | 792.0 |
| 2009-03-27 06:00:00 | YM | Futures | 7174.2 | 7176.1 | 7151.3 | 7158.6 | 1442.0 |
| 2009-03-27 07:00:00 | YM | Futures | 7158.6 | 7177.0 | 7140.2 | 7142.1 | 1983.0 |
| 2009-03-27 08:00:00 | YM | Futures | 7141.2 | 7160.5 | 7126.5 | 7143.0 | 2574.0 |
| 2009-03-27 09:00:00 | YM | Futures | 7143.0 | 7147.6 | 7109.0 | 7124.6 | 15982.0 |
| 2009-03-27 10:00:00 | YM | Futures | 7123.7 | 7137.5 | 7089.7 | 7120.9 | 26515.0 |
| 2009-03-27 11:00:00 | YM | Futures | 7121.9 | 7154.9 | 7109.0 | 7136.6 | 21982.0 |
| 2009-03-27 12:00:00 | YM | Futures | 7137.5 | 7156.8 | 7100.7 | 7106.2 | 14345.0 |
| 2009-03-27 13:00:00 | YM | Futures | 7107.2 | 7133.8 | 7059.4 | 7075.0 | 20024.0 |
| 2009-03-27 14:00:00 | YM | Futures | 7075.0 | 7116.3 | 7054.8 | 7113.6 | 25855.0 |
| 2009-03-27 15:00:00 | YM | Futures | 7113.6 | 7146.7 | 7066.7 | 7099.8 | 30499.0 |
> showing 50 of 1,015 rows — these rows as CSV