PREVIEW / futures_1hour / 2010-05-17

all futures 1-hour files

  file:    by_date/futures_1hour/2010/2010-05-17.parquet
  size:    47 KB
  rows:    1,366

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
2010-05-17 00:00:00	ES	Futures	1096.01	1099.67	1096.01	1098.94	7318.0
2010-05-17 01:00:00	ES	Futures	1099.18	1099.67	1096.5	1097.96	7803.0
2010-05-17 02:00:00	ES	Futures	1097.72	1103.1	1095.52	1102.61	22355.0
2010-05-17 03:00:00	ES	Futures	1102.85	1107.98	1102.12	1103.34	59051.0
2010-05-17 04:00:00	ES	Futures	1103.58	1109.7	1102.12	1107.25	39369.0
2010-05-17 05:00:00	ES	Futures	1107.01	1112.63	1106.76	1109.45	33576.0
2010-05-17 06:00:00	ES	Futures	1109.45	1113.36	1109.21	1110.92	22352.0
2010-05-17 07:00:00	ES	Futures	1110.92	1114.58	1110.67	1112.63	32110.0
2010-05-17 08:00:00	ES	Futures	1112.63	1113.12	1104.56	1108.72	96848.0
2010-05-17 09:00:00	ES	Futures	1108.96	1114.83	1105.78	1107.01	294132.0
2010-05-17 10:00:00	ES	Futures	1106.76	1110.92	1105.05	1105.3	389821.0
2010-05-17 11:00:00	ES	Futures	1105.05	1106.27	1096.01	1096.5	408780.0
2010-05-17 12:00:00	ES	Futures	1096.5	1096.74	1087.94	1092.59	409123.0
2010-05-17 13:00:00	ES	Futures	1092.59	1099.43	1092.1	1097.47	233331.0
2010-05-17 14:00:00	ES	Futures	1097.72	1104.56	1096.99	1104.07	304551.0
2010-05-17 15:00:00	ES	Futures	1104.07	1111.16	1098.7	1109.45	492559.0
2010-05-17 16:00:00	ES	Futures	1109.21	1112.38	1107.98	1111.41	94748.0
2010-05-17 17:00:00	ES	Futures	1111.41	1111.41	1110.43	1110.92	1956.0
2010-05-17 18:00:00	ES	Futures	1110.43	1112.38	1110.43	1111.65	4052.0
2010-05-17 19:00:00	ES	Futures	1111.41	1111.65	1109.94	1111.16	3520.0
2010-05-17 20:00:00	ES	Futures	1110.92	1111.65	1106.76	1107.25	7530.0
2010-05-17 21:00:00	ES	Futures	1107.25	1107.74	1105.05	1107.5	8752.0
2010-05-17 22:00:00	ES	Futures	1107.25	1108.96	1105.3	1105.54	5891.0
2010-05-17 23:00:00	ES	Futures	1105.54	1108.47	1104.81	1107.98	4541.0
2010-05-17 00:00:00	NQ	Futures	2161.25	2166.7	2160.97	2166.7	590.0
2010-05-17 01:00:00	NQ	Futures	2166.98	2167.84	2162.4	2164.69	569.0
2010-05-17 02:00:00	NQ	Futures	2164.12	2174.14	2160.11	2173.28	1725.0
2010-05-17 03:00:00	NQ	Futures	2173.57	2185.02	2173.0	2175.0	4807.0
2010-05-17 04:00:00	NQ	Futures	2174.71	2186.45	2172.42	2181.3	2288.0
2010-05-17 05:00:00	NQ	Futures	2181.59	2192.18	2181.01	2187.03	2099.0
2010-05-17 06:00:00	NQ	Futures	2187.03	2193.04	2186.17	2189.03	1095.0
2010-05-17 07:00:00	NQ	Futures	2189.03	2195.91	2189.03	2193.33	1980.0
2010-05-17 08:00:00	NQ	Futures	2193.9	2194.47	2176.72	2183.02	9298.0
2010-05-17 09:00:00	NQ	Futures	2183.02	2198.77	2179.01	2182.45	43659.0
2010-05-17 10:00:00	NQ	Futures	2182.45	2197.05	2179.87	2184.45	48785.0
2010-05-17 11:00:00	NQ	Futures	2184.16	2186.45	2162.69	2162.97	43469.0
2010-05-17 12:00:00	NQ	Futures	2163.26	2163.26	2142.64	2153.81	62045.0
2010-05-17 13:00:00	NQ	Futures	2153.81	2167.84	2152.38	2166.98	31394.0
2010-05-17 14:00:00	NQ	Futures	2166.98	2180.44	2164.98	2179.3	35763.0
2010-05-17 15:00:00	NQ	Futures	2179.3	2194.19	2167.84	2190.75	57887.0
2010-05-17 16:00:00	NQ	Futures	2190.75	2195.05	2189.89	2193.04	9947.0
2010-05-17 17:00:00	NQ	Futures	2192.47	2194.19	2191.61	2192.75	222.0
2010-05-17 18:00:00	NQ	Futures	2192.75	2197.05	2191.9	2195.62	330.0
2010-05-17 19:00:00	NQ	Futures	2195.33	2195.33	2190.46	2194.47	278.0
2010-05-17 20:00:00	NQ	Futures	2194.19	2194.19	2185.88	2186.45	452.0
2010-05-17 21:00:00	NQ	Futures	2186.45	2187.6	2182.45	2187.03	447.0
2010-05-17 22:00:00	NQ	Futures	2187.03	2190.46	2183.88	2183.88	261.0
2010-05-17 23:00:00	NQ	Futures	2183.88	2190.18	2183.02	2189.89	345.0
2010-05-17 00:00:00	YM	Futures	9867.1	9893.5	9863.4	9885.9	1051.0
2010-05-17 01:00:00	YM	Futures	9887.8	9893.5	9865.2	9877.5	1144.0

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

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