PREVIEW / futures_1hour / 2008-07-20

all futures 1-hour files

  file:    by_date/futures_1hour/2008/2008-07-20.parquet
  size:    13 KB
  rows:    219

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-07-20 18:00:00	ES	Futures	1170.68	1172.54	1170.68	1172.3	7898.0
2008-07-20 19:00:00	ES	Futures	1172.3	1172.54	1171.37	1171.37	6824.0
2008-07-20 20:00:00	ES	Futures	1171.37	1171.61	1170.21	1170.21	2761.0
2008-07-20 21:00:00	ES	Futures	1170.21	1171.37	1169.51	1170.68	2315.0
2008-07-20 22:00:00	ES	Futures	1170.68	1173.23	1170.44	1173.0	2050.0
2008-07-20 23:00:00	ES	Futures	1172.77	1173.93	1172.07	1173.0	1354.0
2008-07-20 18:00:00	NQ	Futures	2056.5	2059.88	2056.5	2059.6	182.0
2008-07-20 19:00:00	NQ	Futures	2059.32	2059.32	2056.78	2057.91	82.0
2008-07-20 20:00:00	NQ	Futures	2057.91	2058.75	2056.22	2056.22	85.0
2008-07-20 21:00:00	NQ	Futures	2055.94	2056.5	2053.13	2056.5	222.0
2008-07-20 22:00:00	NQ	Futures	2054.81	2058.47	2054.81	2057.35	222.0
2008-07-20 23:00:00	NQ	Futures	2056.78	2058.75	2056.5	2058.75	45.0
2008-07-20 18:00:00	YM	Futures	10439.3	10461.1	10439.3	10453.9	312.0
2008-07-20 19:00:00	YM	Futures	10453.9	10456.6	10447.5	10447.5	129.0
2008-07-20 20:00:00	YM	Futures	10447.5	10450.2	10440.2	10443.0	139.0
2008-07-20 21:00:00	YM	Futures	10440.2	10451.1	10437.5	10447.5	152.0
2008-07-20 22:00:00	YM	Futures	10444.8	10463.0	10444.8	10460.2	231.0
2008-07-20 23:00:00	YM	Futures	10460.2	10470.2	10455.7	10467.5	186.0
2008-07-20 18:00:00	CL	Futures	489.63	494.43	489.29	493.6	793.0
2008-07-20 19:00:00	CL	Futures	493.79	493.79	492.39	493.0	253.0
2008-07-20 20:00:00	CL	Futures	493.0	493.0	492.24	492.51	115.0
2008-07-20 21:00:00	CL	Futures	492.39	492.73	491.49	491.94	347.0
2008-07-20 22:00:00	CL	Futures	492.01	493.04	492.01	492.13	89.0
2008-07-20 23:00:00	CL	Futures	491.83	492.81	491.64	492.81	95.0
2008-07-20 18:00:00	GC	Futures	1380.0	1383.3	1377.6	1378.8	413.0
2008-07-20 19:00:00	GC	Futures	1379.1	1382.3	1379.1	1382.3	311.0
2008-07-20 20:00:00	GC	Futures	1382.0	1383.3	1380.5	1382.8	549.0
2008-07-20 21:00:00	GC	Futures	1382.8	1383.6	1381.7	1382.5	324.0
2008-07-20 22:00:00	GC	Futures	1382.7	1384.1	1382.3	1383.4	280.0
2008-07-20 23:00:00	GC	Futures	1383.1	1384.0	1382.7	1383.0	91.0
2008-07-20 18:00:00	ZN	Futures	85.066541	85.066541	84.984633	85.008035	739.0
2008-07-20 19:00:00	ZN	Futures	85.008035	85.019736	84.867623	84.914427	1801.0
2008-07-20 20:00:00	ZN	Futures	84.926128	84.972932	84.902726	84.972932	1639.0
2008-07-20 21:00:00	ZN	Futures	84.984633	84.996334	84.961231	84.984633	901.0
2008-07-20 22:00:00	ZN	Futures	84.972932	84.996334	84.961231	84.961231	949.0
2008-07-20 23:00:00	ZN	Futures	84.961231	84.984633	84.961231	84.961231	438.0

> showing 36 of 219 rows — these rows as CSV

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