PREVIEW / futures_1hour / 2010-07-28

all futures 1-hour files

  file:    by_date/futures_1hour/2010/2010-07-28.parquet
  size:    45 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-07-28 00:00:00	ES	Futures	1090.71	1090.96	1089.98	1090.47	2286.0
2010-07-28 01:00:00	ES	Futures	1090.47	1094.15	1090.47	1093.41	6650.0
2010-07-28 02:00:00	ES	Futures	1093.41	1094.39	1092.43	1093.17	13959.0
2010-07-28 03:00:00	ES	Futures	1093.17	1095.13	1091.94	1092.18	27112.0
2010-07-28 04:00:00	ES	Futures	1091.94	1093.17	1091.45	1092.43	17342.0
2010-07-28 05:00:00	ES	Futures	1092.18	1093.17	1090.96	1091.2	14866.0
2010-07-28 06:00:00	ES	Futures	1091.2	1091.2	1087.77	1090.22	25552.0
2010-07-28 07:00:00	ES	Futures	1090.22	1092.43	1089.49	1092.18	23071.0
2010-07-28 08:00:00	ES	Futures	1091.94	1092.18	1086.54	1088.75	78397.0
2010-07-28 09:00:00	ES	Futures	1088.75	1090.96	1086.05	1088.5	208090.0
2010-07-28 10:00:00	ES	Futures	1088.5	1089.49	1083.11	1086.3	269469.0
2010-07-28 11:00:00	ES	Futures	1086.54	1087.03	1083.6	1085.07	168907.0
2010-07-28 12:00:00	ES	Futures	1085.07	1088.26	1084.33	1088.01	86994.0
2010-07-28 13:00:00	ES	Futures	1088.01	1088.75	1084.58	1086.05	123778.0
2010-07-28 14:00:00	ES	Futures	1086.05	1087.52	1081.88	1082.61	187623.0
2010-07-28 15:00:00	ES	Futures	1082.86	1083.35	1078.93	1082.61	279133.0
2010-07-28 16:00:00	ES	Futures	1082.37	1083.11	1081.39	1082.12	84588.0
2010-07-28 17:00:00	ES	Futures	1082.12	1082.12	1080.65	1081.14	1986.0
2010-07-28 18:00:00	ES	Futures	1081.14	1082.12	1081.14	1081.63	1340.0
2010-07-28 19:00:00	ES	Futures	1081.63	1083.11	1081.39	1082.37	3116.0
2010-07-28 20:00:00	ES	Futures	1082.61	1084.09	1081.88	1082.86	5609.0
2010-07-28 21:00:00	ES	Futures	1082.86	1083.11	1081.39	1082.37	3488.0
2010-07-28 22:00:00	ES	Futures	1082.61	1083.35	1081.14	1081.63	3886.0
2010-07-28 23:00:00	ES	Futures	1081.63	1085.31	1081.39	1084.82	4345.0
2010-07-28 00:00:00	NQ	Futures	2164.15	2164.43	2162.71	2163.57	80.0
2010-07-28 01:00:00	NQ	Futures	2163.86	2169.88	2163.86	2169.3	260.0
2010-07-28 02:00:00	NQ	Futures	2169.3	2171.6	2167.87	2168.16	550.0
2010-07-28 03:00:00	NQ	Futures	2167.87	2171.88	2167.3	2167.59	1713.0
2010-07-28 04:00:00	NQ	Futures	2167.3	2169.02	2166.15	2167.87	951.0
2010-07-28 05:00:00	NQ	Futures	2167.59	2169.02	2165.29	2165.58	891.0
2010-07-28 06:00:00	NQ	Futures	2165.29	2165.58	2158.7	2163.29	1620.0
2010-07-28 07:00:00	NQ	Futures	2163.0	2168.45	2161.57	2168.16	1602.0
2010-07-28 08:00:00	NQ	Futures	2168.16	2168.45	2154.98	2158.99	7415.0
2010-07-28 09:00:00	NQ	Futures	2159.28	2170.16	2157.27	2167.3	34596.0
2010-07-28 10:00:00	NQ	Futures	2167.59	2169.59	2152.4	2157.27	44444.0
2010-07-28 11:00:00	NQ	Futures	2157.27	2158.13	2150.96	2152.97	30683.0
2010-07-28 12:00:00	NQ	Futures	2152.97	2157.56	2151.54	2156.41	18601.0
2010-07-28 13:00:00	NQ	Futures	2156.41	2157.84	2146.09	2148.1	24494.0
2010-07-28 14:00:00	NQ	Futures	2148.39	2151.54	2142.37	2144.37	32427.0
2010-07-28 15:00:00	NQ	Futures	2144.37	2146.67	2137.5	2145.52	43940.0
2010-07-28 16:00:00	NQ	Futures	2145.52	2146.67	2140.65	2141.22	8092.0
2010-07-28 17:00:00	NQ	Futures	2140.93	2141.22	2139.22	2139.5	279.0
2010-07-28 18:00:00	NQ	Futures	2140.36	2140.93	2140.08	2140.36	219.0
2010-07-28 19:00:00	NQ	Futures	2140.65	2143.51	2140.65	2142.37	173.0
2010-07-28 20:00:00	NQ	Futures	2142.37	2145.81	2142.08	2143.8	461.0
2010-07-28 21:00:00	NQ	Futures	2143.8	2143.8	2140.93	2142.65	342.0
2010-07-28 22:00:00	NQ	Futures	2143.23	2144.09	2140.65	2141.51	293.0
2010-07-28 23:00:00	NQ	Futures	2141.51	2147.81	2141.51	2146.95	339.0
2010-07-28 00:00:00	YM	Futures	9933.7	9936.5	9930.8	9931.8	179.0
2010-07-28 01:00:00	YM	Futures	9933.7	9958.3	9933.7	9953.6	413.0

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

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