PREVIEW / futures_1hour / 2010-06-22

all futures 1-hour files

  file:    by_date/futures_1hour/2010/2010-06-22.parquet
  size:    46 KB
  rows:    1,370

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-06-22 00:00:00	ES	Futures	1090.71	1090.96	1089.98	1090.22	4016.0
2010-06-22 01:00:00	ES	Futures	1090.47	1090.71	1089.98	1090.47	9145.0
2010-06-22 02:00:00	ES	Futures	1090.47	1091.2	1087.52	1090.22	18986.0
2010-06-22 03:00:00	ES	Futures	1090.22	1092.43	1089.98	1091.2	28905.0
2010-06-22 04:00:00	ES	Futures	1091.45	1092.18	1089.98	1090.71	12961.0
2010-06-22 05:00:00	ES	Futures	1090.47	1090.71	1083.84	1084.09	38314.0
2010-06-22 06:00:00	ES	Futures	1084.09	1087.52	1083.11	1085.31	30255.0
2010-06-22 07:00:00	ES	Futures	1085.31	1088.26	1085.07	1086.3	41545.0
2010-06-22 08:00:00	ES	Futures	1086.05	1089.49	1084.58	1089.24	49754.0
2010-06-22 09:00:00	ES	Futures	1089.24	1093.9	1088.26	1088.99	246991.0
2010-06-22 10:00:00	ES	Futures	1089.24	1089.73	1084.09	1088.01	362781.0
2010-06-22 11:00:00	ES	Futures	1088.26	1092.18	1084.82	1089.49	243598.0
2010-06-22 12:00:00	ES	Futures	1089.49	1090.22	1086.3	1087.77	117787.0
2010-06-22 13:00:00	ES	Futures	1087.77	1089.24	1084.58	1085.8	200602.0
2010-06-22 14:00:00	ES	Futures	1085.56	1085.8	1072.8	1075.25	359630.0
2010-06-22 15:00:00	ES	Futures	1075.25	1077.71	1069.36	1071.33	381215.0
2010-06-22 16:00:00	ES	Futures	1071.08	1072.55	1069.36	1071.82	87054.0
2010-06-22 17:00:00	ES	Futures	1071.82	1072.55	1071.08	1071.57	3085.0
2010-06-22 18:00:00	ES	Futures	1071.57	1072.55	1071.33	1071.82	2925.0
2010-06-22 19:00:00	ES	Futures	1071.82	1073.29	1071.33	1072.06	3616.0
2010-06-22 20:00:00	ES	Futures	1071.82	1073.04	1071.82	1071.82	5684.0
2010-06-22 21:00:00	ES	Futures	1072.06	1074.27	1071.82	1074.27	7154.0
2010-06-22 22:00:00	ES	Futures	1074.27	1074.76	1073.29	1074.52	5080.0
2010-06-22 23:00:00	ES	Futures	1074.27	1074.27	1072.31	1073.54	4459.0
2010-06-22 00:00:00	NQ	Futures	2180.19	2180.77	2177.9	2178.47	381.0
2010-06-22 01:00:00	NQ	Futures	2178.19	2178.76	2177.33	2178.19	379.0
2010-06-22 02:00:00	NQ	Futures	2178.19	2179.91	2173.6	2178.76	813.0
2010-06-22 03:00:00	NQ	Futures	2178.76	2182.77	2177.9	2180.48	1498.0
2010-06-22 04:00:00	NQ	Futures	2180.77	2182.2	2179.05	2179.91	1148.0
2010-06-22 05:00:00	NQ	Futures	2179.91	2179.91	2167.87	2168.45	2902.0
2010-06-22 06:00:00	NQ	Futures	2168.45	2175.32	2166.44	2171.88	2332.0
2010-06-22 07:00:00	NQ	Futures	2171.88	2176.18	2170.45	2172.46	3711.0
2010-06-22 08:00:00	NQ	Futures	2172.46	2179.91	2169.59	2179.33	7408.0
2010-06-22 09:00:00	NQ	Futures	2179.33	2197.1	2177.62	2185.93	49140.0
2010-06-22 10:00:00	NQ	Futures	2186.21	2189.94	2173.32	2187.36	58951.0
2010-06-22 11:00:00	NQ	Futures	2187.36	2195.38	2178.47	2189.08	39503.0
2010-06-22 12:00:00	NQ	Futures	2189.08	2192.23	2184.78	2187.07	25011.0
2010-06-22 13:00:00	NQ	Futures	2186.79	2190.8	2179.05	2181.91	25630.0
2010-06-22 14:00:00	NQ	Futures	2182.2	2182.2	2157.27	2161.28	48685.0
2010-06-22 15:00:00	NQ	Futures	2161.57	2166.44	2150.96	2154.4	55346.0
2010-06-22 16:00:00	NQ	Futures	2154.69	2156.98	2152.4	2155.84	8036.0
2010-06-22 17:00:00	NQ	Futures	2156.41	2157.56	2154.98	2155.55	210.0
2010-06-22 18:00:00	NQ	Futures	2156.12	2157.27	2154.69	2155.84	287.0
2010-06-22 19:00:00	NQ	Futures	2155.84	2158.7	2154.98	2156.41	195.0
2010-06-22 20:00:00	NQ	Futures	2155.84	2157.84	2154.12	2155.55	359.0
2010-06-22 21:00:00	NQ	Futures	2155.55	2159.56	2154.98	2159.56	385.0
2010-06-22 22:00:00	NQ	Futures	2159.56	2161.28	2158.13	2160.42	410.0
2010-06-22 23:00:00	NQ	Futures	2159.85	2159.85	2156.7	2158.7	303.0
2010-06-22 00:00:00	YM	Futures	9847.5	9852.3	9840.0	9841.9	125.0
2010-06-22 01:00:00	YM	Futures	9842.8	9847.5	9841.9	9843.8	106.0

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

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