PREVIEW / futures_1hour / 2010-07-26

all futures 1-hour files

  file:    by_date/futures_1hour/2010/2010-07-26.parquet
  size:    44 KB
  rows:    1,332

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-26 00:00:00	ES	Futures	1082.37	1082.61	1081.39	1082.37	2370.0
2010-07-26 01:00:00	ES	Futures	1082.37	1082.61	1081.14	1081.63	3214.0
2010-07-26 02:00:00	ES	Futures	1081.39	1083.6	1080.9	1082.12	7936.0
2010-07-26 03:00:00	ES	Futures	1081.88	1082.12	1077.95	1079.67	36984.0
2010-07-26 04:00:00	ES	Futures	1079.92	1080.65	1076.73	1078.2	24633.0
2010-07-26 05:00:00	ES	Futures	1077.95	1079.42	1077.46	1078.44	10929.0
2010-07-26 06:00:00	ES	Futures	1078.44	1080.16	1077.46	1079.67	13182.0
2010-07-26 07:00:00	ES	Futures	1079.92	1079.92	1076.73	1078.44	22631.0
2010-07-26 08:00:00	ES	Futures	1078.44	1079.42	1077.22	1079.42	29813.0
2010-07-26 09:00:00	ES	Futures	1079.42	1082.61	1077.46	1080.9	196809.0
2010-07-26 10:00:00	ES	Futures	1080.9	1087.03	1080.65	1085.56	329500.0
2010-07-26 11:00:00	ES	Futures	1085.56	1088.99	1084.09	1087.77	192671.0
2010-07-26 12:00:00	ES	Futures	1088.01	1089.24	1086.3	1087.52	104255.0
2010-07-26 13:00:00	ES	Futures	1087.52	1088.75	1086.3	1088.01	86256.0
2010-07-26 14:00:00	ES	Futures	1088.26	1088.26	1084.09	1085.31	102483.0
2010-07-26 15:00:00	ES	Futures	1085.31	1091.2	1084.82	1090.22	245271.0
2010-07-26 16:00:00	ES	Futures	1090.22	1090.47	1088.5	1088.99	96096.0
2010-07-26 17:00:00	ES	Futures	1088.99	1089.24	1088.75	1088.99	1192.0
2010-07-26 18:00:00	ES	Futures	1088.99	1089.24	1087.77	1088.01	2503.0
2010-07-26 19:00:00	ES	Futures	1088.26	1088.5	1087.52	1087.77	1782.0
2010-07-26 20:00:00	ES	Futures	1087.77	1089.24	1087.52	1088.99	3757.0
2010-07-26 21:00:00	ES	Futures	1088.99	1090.47	1088.01	1088.26	4436.0
2010-07-26 22:00:00	ES	Futures	1088.26	1088.75	1087.28	1087.77	3184.0
2010-07-26 23:00:00	ES	Futures	1087.77	1088.01	1087.28	1087.28	1459.0
2010-07-26 00:00:00	NQ	Futures	2155.26	2155.26	2152.97	2154.4	190.0
2010-07-26 01:00:00	NQ	Futures	2154.69	2154.69	2151.82	2152.68	157.0
2010-07-26 02:00:00	NQ	Futures	2152.4	2156.12	2151.25	2152.97	515.0
2010-07-26 03:00:00	NQ	Futures	2152.97	2152.97	2145.52	2149.82	1980.0
2010-07-26 04:00:00	NQ	Futures	2149.53	2151.54	2143.51	2145.52	1212.0
2010-07-26 05:00:00	NQ	Futures	2146.09	2148.96	2144.95	2146.95	736.0
2010-07-26 06:00:00	NQ	Futures	2147.53	2149.82	2145.52	2149.82	968.0
2010-07-26 07:00:00	NQ	Futures	2149.82	2149.82	2142.65	2145.23	2377.0
2010-07-26 08:00:00	NQ	Futures	2145.23	2146.95	2142.65	2146.95	3269.0
2010-07-26 09:00:00	NQ	Futures	2146.95	2153.54	2138.93	2145.52	40835.0
2010-07-26 10:00:00	NQ	Futures	2145.81	2156.41	2145.23	2154.12	47884.0
2010-07-26 11:00:00	NQ	Futures	2154.4	2161.85	2152.4	2158.42	33796.0
2010-07-26 12:00:00	NQ	Futures	2158.7	2159.56	2151.54	2154.69	28010.0
2010-07-26 13:00:00	NQ	Futures	2154.98	2158.13	2152.11	2156.12	18568.0
2010-07-26 14:00:00	NQ	Futures	2155.84	2156.98	2150.1	2153.54	17456.0
2010-07-26 15:00:00	NQ	Futures	2153.54	2164.43	2152.68	2163.0	42206.0
2010-07-26 16:00:00	NQ	Futures	2163.0	2163.86	2160.42	2162.43	11915.0
2010-07-26 17:00:00	NQ	Futures	2163.57	2163.57	2162.43	2162.71	33.0
2010-07-26 18:00:00	NQ	Futures	2162.43	2162.71	2160.13	2160.42	180.0
2010-07-26 19:00:00	NQ	Futures	2160.42	2161.28	2160.13	2160.42	56.0
2010-07-26 20:00:00	NQ	Futures	2160.71	2163.0	2160.42	2163.0	495.0
2010-07-26 21:00:00	NQ	Futures	2162.71	2165.58	2161.85	2162.43	697.0
2010-07-26 22:00:00	NQ	Futures	2162.14	2162.71	2161.28	2161.57	385.0
2010-07-26 23:00:00	NQ	Futures	2161.57	2162.14	2160.99	2160.99	340.0
2010-07-26 00:00:00	YM	Futures	9845.7	9847.5	9837.1	9844.7	224.0
2010-07-26 01:00:00	YM	Futures	9844.7	9846.6	9832.4	9838.1	265.0

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

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