PREVIEW / futures_1hour / 2008-07-29

all futures 1-hour files

  file:    by_date/futures_1hour/2008/2008-07-29.parquet
  size:    42 KB
  rows:    1,218

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-29 00:00:00	ES	Futures	1149.53	1150.46	1149.06	1149.29	1607.0
2008-07-29 01:00:00	ES	Futures	1149.29	1149.99	1148.83	1148.83	1043.0
2008-07-29 02:00:00	ES	Futures	1148.83	1150.22	1146.97	1147.9	8872.0
2008-07-29 03:00:00	ES	Futures	1147.9	1149.99	1146.27	1149.76	17706.0
2008-07-29 04:00:00	ES	Futures	1149.53	1151.39	1148.83	1149.53	10761.0
2008-07-29 05:00:00	ES	Futures	1149.53	1151.85	1146.97	1147.2	12331.0
2008-07-29 06:00:00	ES	Futures	1147.2	1149.29	1144.88	1149.06	13617.0
2008-07-29 07:00:00	ES	Futures	1149.29	1153.71	1148.6	1153.25	39010.0
2008-07-29 08:00:00	ES	Futures	1153.25	1154.41	1151.62	1152.32	38399.0
2008-07-29 09:00:00	ES	Futures	1152.32	1156.27	1150.22	1156.27	245311.0
2008-07-29 10:00:00	ES	Futures	1156.27	1162.31	1156.27	1160.45	384845.0
2008-07-29 11:00:00	ES	Futures	1160.22	1164.63	1158.13	1163.01	214534.0
2008-07-29 12:00:00	ES	Futures	1163.24	1165.33	1161.61	1164.4	196179.0
2008-07-29 13:00:00	ES	Futures	1164.63	1168.35	1162.54	1168.12	173586.0
2008-07-29 14:00:00	ES	Futures	1168.12	1168.58	1161.84	1165.33	245283.0
2008-07-29 15:00:00	ES	Futures	1165.33	1173.7	1164.63	1173.47	361533.0
2008-07-29 16:00:00	ES	Futures	1173.47	1174.39	1172.54	1173.0	108723.0
2008-07-29 17:00:00	ES	Futures	1173.0	1173.93	1172.3	1173.7	2902.0
2008-07-29 18:00:00	ES	Futures	1173.47	1174.39	1173.0	1173.0	2003.0
2008-07-29 19:00:00	ES	Futures	1173.0	1173.7	1172.77	1173.23	1964.0
2008-07-29 20:00:00	ES	Futures	1173.23	1173.47	1172.3	1173.23	1641.0
2008-07-29 21:00:00	ES	Futures	1173.0	1173.47	1172.54	1172.77	1364.0
2008-07-29 22:00:00	ES	Futures	1172.54	1172.77	1172.07	1172.77	1214.0
2008-07-29 23:00:00	ES	Futures	1172.54	1172.77	1172.07	1172.77	886.0
2008-07-29 00:00:00	NQ	Futures	2041.03	2042.16	2039.34	2039.34	105.0
2008-07-29 01:00:00	NQ	Futures	2040.75	2043.0	2039.91	2039.91	185.0
2008-07-29 02:00:00	NQ	Futures	2039.63	2041.31	2035.69	2037.37	605.0
2008-07-29 03:00:00	NQ	Futures	2037.37	2042.16	2034.84	2041.31	1282.0
2008-07-29 04:00:00	NQ	Futures	2041.03	2043.56	2040.19	2040.19	953.0
2008-07-29 05:00:00	NQ	Futures	2039.63	2044.41	2034.56	2035.97	1486.0
2008-07-29 06:00:00	NQ	Futures	2035.69	2040.75	2032.59	2040.47	1667.0
2008-07-29 07:00:00	NQ	Futures	2040.47	2050.03	2039.91	2049.75	2381.0
2008-07-29 08:00:00	NQ	Futures	2049.19	2050.31	2044.97	2046.94	4479.0
2008-07-29 09:00:00	NQ	Futures	2047.22	2059.6	2043.0	2057.63	41729.0
2008-07-29 10:00:00	NQ	Futures	2057.63	2087.73	2057.63	2082.94	110829.0
2008-07-29 11:00:00	NQ	Futures	2082.94	2086.04	2075.63	2081.26	46183.0
2008-07-29 12:00:00	NQ	Futures	2081.26	2086.04	2071.41	2074.5	37192.0
2008-07-29 13:00:00	NQ	Futures	2074.22	2083.22	2071.41	2079.85	23902.0
2008-07-29 14:00:00	NQ	Futures	2079.85	2080.41	2068.88	2073.94	37566.0
2008-07-29 15:00:00	NQ	Futures	2073.94	2083.51	2071.97	2079.29	46390.0
2008-07-29 16:00:00	NQ	Futures	2079.57	2081.54	2071.97	2072.82	14270.0
2008-07-29 17:00:00	NQ	Futures	2072.82	2075.07	2072.54	2074.79	248.0
2008-07-29 18:00:00	NQ	Futures	2074.22	2075.63	2073.66	2073.66	244.0
2008-07-29 19:00:00	NQ	Futures	2073.1	2074.5	2073.1	2074.5	105.0
2008-07-29 20:00:00	NQ	Futures	2074.5	2074.5	2073.1	2073.66	39.0
2008-07-29 21:00:00	NQ	Futures	2073.66	2074.79	2073.66	2073.94	102.0
2008-07-29 22:00:00	NQ	Futures	2073.66	2074.22	2073.1	2074.22	369.0
2008-07-29 23:00:00	NQ	Futures	2073.94	2074.79	2073.94	2074.79	214.0
2008-07-29 00:00:00	YM	Futures	10118.5	10125.8	10116.7	10120.3	149.0
2008-07-29 01:00:00	YM	Futures	10120.3	10129.4	10120.3	10121.2	101.0

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

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