PREVIEW / futures_1hour / 2010-06-15

all futures 1-hour files

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

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-15 00:00:00	ES	Futures	1069.36	1070.1	1067.4	1067.89	3871.0
2010-06-15 01:00:00	ES	Futures	1067.65	1069.61	1067.4	1068.87	2336.0
2010-06-15 02:00:00	ES	Futures	1068.87	1069.36	1064.21	1064.46	14121.0
2010-06-15 03:00:00	ES	Futures	1064.21	1068.38	1064.21	1068.14	41973.0
2010-06-15 04:00:00	ES	Futures	1068.14	1071.82	1067.65	1071.08	29432.0
2010-06-15 05:00:00	ES	Futures	1071.08	1074.76	1068.14	1074.03	44812.0
2010-06-15 06:00:00	ES	Futures	1074.03	1074.76	1072.8	1073.04	21908.0
2010-06-15 07:00:00	ES	Futures	1073.29	1074.27	1070.84	1072.8	47066.0
2010-06-15 08:00:00	ES	Futures	1072.55	1074.52	1070.1	1072.55	85452.0
2010-06-15 09:00:00	ES	Futures	1072.55	1076.73	1071.08	1075.25	287446.0
2010-06-15 10:00:00	ES	Futures	1075.25	1078.2	1072.31	1077.95	370569.0
2010-06-15 11:00:00	ES	Futures	1077.71	1079.92	1075.74	1078.93	215479.0
2010-06-15 12:00:00	ES	Futures	1078.93	1080.9	1077.71	1080.65	144626.0
2010-06-15 13:00:00	ES	Futures	1080.65	1083.6	1078.44	1083.35	179870.0
2010-06-15 14:00:00	ES	Futures	1083.35	1087.28	1083.11	1085.07	222647.0
2010-06-15 15:00:00	ES	Futures	1085.07	1090.96	1084.09	1089.73	364146.0
2010-06-15 16:00:00	ES	Futures	1089.73	1089.98	1087.28	1088.26	130260.0
2010-06-15 17:00:00	ES	Futures	1088.26	1088.26	1087.28	1087.52	3061.0
2010-06-15 18:00:00	ES	Futures	1087.52	1087.52	1086.3	1087.03	4706.0
2010-06-15 19:00:00	ES	Futures	1086.79	1087.28	1086.05	1086.79	3932.0
2010-06-15 20:00:00	ES	Futures	1086.79	1087.03	1085.8	1086.3	3170.0
2010-06-15 21:00:00	ES	Futures	1086.3	1087.28	1085.8	1086.05	2967.0
2010-06-15 22:00:00	ES	Futures	1086.05	1086.54	1085.8	1086.05	2179.0
2010-06-15 23:00:00	ES	Futures	1086.05	1087.77	1086.05	1087.28	2210.0
2010-06-15 00:00:00	NQ	Futures	2123.45	2124.89	2120.88	2121.45	145.0
2010-06-15 01:00:00	NQ	Futures	2121.45	2124.6	2120.88	2122.59	85.0
2010-06-15 02:00:00	NQ	Futures	2122.31	2123.45	2114.86	2115.14	1227.0
2010-06-15 03:00:00	NQ	Futures	2114.86	2122.31	2114.86	2121.45	2455.0
2010-06-15 04:00:00	NQ	Futures	2121.45	2128.9	2120.88	2128.9	2196.0
2010-06-15 05:00:00	NQ	Futures	2128.61	2135.2	2122.31	2134.34	3165.0
2010-06-15 06:00:00	NQ	Futures	2134.06	2135.2	2131.19	2131.48	1287.0
2010-06-15 07:00:00	NQ	Futures	2132.05	2134.06	2127.47	2130.05	1885.0
2010-06-15 08:00:00	NQ	Futures	2130.05	2132.05	2122.59	2123.74	8875.0
2010-06-15 09:00:00	NQ	Futures	2123.74	2150.39	2123.45	2145.81	53483.0
2010-06-15 10:00:00	NQ	Futures	2145.81	2149.25	2137.5	2148.1	49148.0
2010-06-15 11:00:00	NQ	Futures	2148.1	2153.83	2142.65	2152.11	34165.0
2010-06-15 12:00:00	NQ	Futures	2152.11	2157.27	2151.25	2156.41	25665.0
2010-06-15 13:00:00	NQ	Futures	2156.41	2162.71	2151.82	2161.57	25568.0
2010-06-15 14:00:00	NQ	Futures	2161.57	2168.16	2160.99	2164.15	27143.0
2010-06-15 15:00:00	NQ	Futures	2164.15	2175.9	2162.43	2172.46	48581.0
2010-06-15 16:00:00	NQ	Futures	2172.46	2172.74	2167.87	2168.45	13279.0
2010-06-15 17:00:00	NQ	Futures	2168.73	2169.02	2167.3	2168.45	113.0
2010-06-15 18:00:00	NQ	Futures	2168.16	2168.73	2165.87	2167.3	188.0
2010-06-15 19:00:00	NQ	Futures	2166.73	2167.3	2165.29	2166.73	179.0
2010-06-15 20:00:00	NQ	Futures	2166.44	2167.3	2165.29	2166.44	374.0
2010-06-15 21:00:00	NQ	Futures	2166.15	2167.87	2165.58	2165.58	205.0
2010-06-15 22:00:00	NQ	Futures	2165.87	2166.73	2165.01	2165.29	153.0
2010-06-15 23:00:00	NQ	Futures	2165.58	2167.59	2165.58	2167.3	224.0
2010-06-15 00:00:00	YM	Futures	9631.7	9635.5	9617.5	9618.5	362.0
2010-06-15 01:00:00	YM	Futures	9617.5	9629.8	9614.7	9623.2	262.0

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

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