PREVIEW / futures_1hour / 2008-07-30

all futures 1-hour files

  file:    by_date/futures_1hour/2008/2008-07-30.parquet
  size:    41 KB
  rows:    1,220

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-30 00:00:00	ES	Futures	1172.54	1173.23	1172.07	1172.77	877.0
2008-07-30 01:00:00	ES	Futures	1172.77	1173.93	1172.54	1173.7	1399.0
2008-07-30 02:00:00	ES	Futures	1173.7	1175.32	1172.77	1174.86	7123.0
2008-07-30 03:00:00	ES	Futures	1174.63	1175.56	1172.07	1172.54	15266.0
2008-07-30 04:00:00	ES	Futures	1172.54	1173.23	1171.14	1173.23	11300.0
2008-07-30 05:00:00	ES	Futures	1173.0	1173.23	1171.14	1172.54	8799.0
2008-07-30 06:00:00	ES	Futures	1172.54	1175.56	1172.54	1174.86	9435.0
2008-07-30 07:00:00	ES	Futures	1174.63	1175.56	1172.3	1173.93	15840.0
2008-07-30 08:00:00	ES	Futures	1173.7	1179.74	1171.61	1179.74	78699.0
2008-07-30 09:00:00	ES	Futures	1179.51	1186.02	1179.04	1182.53	327417.0
2008-07-30 10:00:00	ES	Futures	1182.53	1190.43	1182.3	1184.39	501188.0
2008-07-30 11:00:00	ES	Futures	1184.39	1187.87	1182.76	1184.39	217462.0
2008-07-30 12:00:00	ES	Futures	1184.39	1184.85	1175.56	1178.35	203685.0
2008-07-30 13:00:00	ES	Futures	1178.35	1181.13	1175.09	1177.42	198632.0
2008-07-30 14:00:00	ES	Futures	1177.18	1184.16	1176.02	1183.69	198741.0
2008-07-30 15:00:00	ES	Futures	1183.92	1193.45	1179.97	1193.22	414466.0
2008-07-30 16:00:00	ES	Futures	1193.22	1195.31	1192.76	1194.85	125048.0
2008-07-30 17:00:00	ES	Futures	1194.85	1194.85	1193.45	1193.92	3382.0
2008-07-30 18:00:00	ES	Futures	1193.92	1195.08	1193.69	1194.15	2252.0
2008-07-30 19:00:00	ES	Futures	1194.15	1194.38	1193.45	1193.69	1577.0
2008-07-30 20:00:00	ES	Futures	1193.69	1194.38	1193.22	1193.22	2414.0
2008-07-30 21:00:00	ES	Futures	1193.22	1193.45	1192.06	1192.29	2918.0
2008-07-30 22:00:00	ES	Futures	1192.29	1192.52	1191.36	1192.06	2066.0
2008-07-30 23:00:00	ES	Futures	1192.29	1192.99	1191.36	1192.06	1503.0
2008-07-30 00:00:00	NQ	Futures	2074.5	2075.63	2074.5	2075.35	64.0
2008-07-30 01:00:00	NQ	Futures	2074.79	2076.19	2074.5	2075.35	53.0
2008-07-30 02:00:00	NQ	Futures	2075.63	2080.41	2075.35	2080.41	762.0
2008-07-30 03:00:00	NQ	Futures	2080.13	2081.26	2074.79	2075.91	1751.0
2008-07-30 04:00:00	NQ	Futures	2075.63	2078.72	2073.1	2077.6	1002.0
2008-07-30 05:00:00	NQ	Futures	2077.88	2079.57	2075.63	2078.44	987.0
2008-07-30 06:00:00	NQ	Futures	2078.44	2083.79	2078.44	2082.66	1212.0
2008-07-30 07:00:00	NQ	Futures	2083.22	2085.48	2080.97	2082.94	2634.0
2008-07-30 08:00:00	NQ	Futures	2082.66	2090.54	2079.01	2089.98	11016.0
2008-07-30 09:00:00	NQ	Futures	2089.98	2093.07	2080.13	2080.69	49282.0
2008-07-30 10:00:00	NQ	Futures	2080.69	2100.38	2080.13	2087.44	78660.0
2008-07-30 11:00:00	NQ	Futures	2087.73	2093.07	2085.19	2089.98	33996.0
2008-07-30 12:00:00	NQ	Futures	2090.26	2091.1	2067.75	2070.85	48756.0
2008-07-30 13:00:00	NQ	Futures	2070.85	2072.25	2057.06	2063.53	57650.0
2008-07-30 14:00:00	NQ	Futures	2062.97	2073.38	2058.19	2072.25	39334.0
2008-07-30 15:00:00	NQ	Futures	2072.54	2088.57	2059.88	2088.57	75385.0
2008-07-30 16:00:00	NQ	Futures	2088.57	2090.82	2087.73	2089.98	8841.0
2008-07-30 17:00:00	NQ	Futures	2089.41	2091.94	2088.85	2091.1	218.0
2008-07-30 18:00:00	NQ	Futures	2090.26	2091.94	2089.69	2091.1	139.0
2008-07-30 19:00:00	NQ	Futures	2090.26	2090.54	2088.01	2088.57	298.0
2008-07-30 20:00:00	NQ	Futures	2088.85	2089.69	2085.76	2085.76	343.0
2008-07-30 21:00:00	NQ	Futures	2086.6	2086.6	2084.07	2084.91	77.0
2008-07-30 22:00:00	NQ	Futures	2084.63	2084.91	2082.66	2083.79	91.0
2008-07-30 23:00:00	NQ	Futures	2084.63	2084.91	2082.66	2084.91	75.0
2008-07-30 00:00:00	YM	Futures	10331.2	10337.5	10330.3	10334.8	73.0
2008-07-30 01:00:00	YM	Futures	10333.9	10341.2	10333.9	10338.4	69.0

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

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