PREVIEW / futures_1hour / 2008-10-20

all futures 1-hour files

  file:    by_date/futures_1hour/2008/2008-10-20.parquet
  size:    44 KB
  rows:    1,237

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-10-20 00:00:00	ES	Futures	894.06	901.4	893.83	901.16	6276.0
2008-10-20 01:00:00	ES	Futures	901.16	904.47	899.27	904.24	4085.0
2008-10-20 02:00:00	ES	Futures	904.47	911.57	903.76	910.63	12293.0
2008-10-20 03:00:00	ES	Futures	910.63	913.23	901.16	907.08	34487.0
2008-10-20 04:00:00	ES	Futures	907.08	910.86	904.24	910.39	20587.0
2008-10-20 05:00:00	ES	Futures	910.39	914.65	905.42	906.84	19367.0
2008-10-20 06:00:00	ES	Futures	906.84	910.86	904.47	908.5	15980.0
2008-10-20 07:00:00	ES	Futures	908.26	908.73	894.77	898.56	40489.0
2008-10-20 08:00:00	ES	Futures	898.56	905.89	898.32	901.87	36288.0
2008-10-20 09:00:00	ES	Futures	901.64	912.28	896.19	911.34	287108.0
2008-10-20 10:00:00	ES	Futures	911.1	918.2	899.98	903.76	391432.0
2008-10-20 11:00:00	ES	Futures	903.76	911.1	892.64	908.26	316670.0
2008-10-20 12:00:00	ES	Futures	908.5	913.94	905.18	908.73	187850.0
2008-10-20 13:00:00	ES	Futures	908.5	916.78	904.24	913.23	184651.0
2008-10-20 14:00:00	ES	Futures	913.23	920.33	909.21	918.2	239443.0
2008-10-20 15:00:00	ES	Futures	918.2	934.06	913.94	932.87	443809.0
2008-10-20 16:00:00	ES	Futures	932.87	939.74	932.4	934.77	151698.0
2008-10-20 17:00:00	ES	Futures	934.53	936.19	934.29	934.77	4940.0
2008-10-20 18:00:00	ES	Futures	935.24	936.66	933.82	933.82	5567.0
2008-10-20 19:00:00	ES	Futures	933.82	936.19	933.82	935.0	2906.0
2008-10-20 20:00:00	ES	Futures	935.0	936.9	934.53	934.77	4499.0
2008-10-20 21:00:00	ES	Futures	934.77	936.42	933.58	933.82	3171.0
2008-10-20 22:00:00	ES	Futures	933.82	934.77	930.27	931.93	5964.0
2008-10-20 23:00:00	ES	Futures	931.93	933.58	931.22	932.16	3323.0
2008-10-20 00:00:00	NQ	Futures	1502.82	1513.01	1502.54	1511.02	449.0
2008-10-20 01:00:00	NQ	Futures	1513.01	1517.82	1508.48	1517.82	304.0
2008-10-20 02:00:00	NQ	Futures	1517.82	1528.29	1517.25	1527.72	548.0
2008-10-20 03:00:00	NQ	Futures	1527.72	1533.1	1511.02	1520.93	2209.0
2008-10-20 04:00:00	NQ	Futures	1520.93	1530.27	1516.97	1529.42	1412.0
2008-10-20 05:00:00	NQ	Futures	1529.7	1537.06	1517.25	1519.51	1533.0
2008-10-20 06:00:00	NQ	Futures	1520.08	1530.55	1518.66	1523.47	741.0
2008-10-20 07:00:00	NQ	Futures	1524.04	1524.04	1499.99	1507.06	1698.0
2008-10-20 08:00:00	NQ	Futures	1507.35	1521.21	1506.78	1512.16	3049.0
2008-10-20 09:00:00	NQ	Futures	1511.59	1516.12	1490.93	1509.89	41635.0
2008-10-20 10:00:00	NQ	Futures	1510.18	1519.8	1475.65	1483.58	69108.0
2008-10-20 11:00:00	NQ	Futures	1483.29	1498.01	1461.22	1492.35	70879.0
2008-10-20 12:00:00	NQ	Futures	1492.63	1503.95	1486.41	1489.8	33550.0
2008-10-20 13:00:00	NQ	Futures	1489.52	1507.06	1482.16	1500.84	36615.0
2008-10-20 14:00:00	NQ	Futures	1500.84	1516.12	1493.48	1508.76	41829.0
2008-10-20 15:00:00	NQ	Futures	1508.48	1534.51	1501.97	1533.94	60126.0
2008-10-20 16:00:00	NQ	Futures	1533.66	1544.13	1527.44	1530.27	15878.0
2008-10-20 17:00:00	NQ	Futures	1529.42	1530.83	1528.0	1528.57	552.0
2008-10-20 18:00:00	NQ	Futures	1529.13	1532.53	1528.57	1529.98	487.0
2008-10-20 19:00:00	NQ	Futures	1529.7	1532.25	1528.57	1530.83	110.0
2008-10-20 20:00:00	NQ	Futures	1531.4	1533.94	1529.42	1529.42	386.0
2008-10-20 21:00:00	NQ	Futures	1529.98	1532.81	1528.29	1528.57	159.0
2008-10-20 22:00:00	NQ	Futures	1530.55	1530.83	1522.63	1526.59	528.0
2008-10-20 23:00:00	NQ	Futures	1526.87	1529.7	1525.74	1526.87	282.0
2008-10-20 00:00:00	YM	Futures	8053.8	8123.8	8053.8	8117.5	728.0
2008-10-20 01:00:00	YM	Futures	8122.0	8143.8	8102.9	8140.2	339.0

> showing 50 of 1,237 rows — these rows as CSV

> unlock the full archive -- $79 one-time