PREVIEW / futures_1hour / 2010-05-06

all futures 1-hour files

  file:    by_date/futures_1hour/2010/2010-05-06.parquet
  size:    52 KB
  rows:    1,447

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-06 00:00:00	ES	Futures	1139.76	1140.0	1138.05	1138.78	6008.0
2010-05-06 01:00:00	ES	Futures	1138.78	1139.03	1138.05	1138.29	4890.0
2010-05-06 02:00:00	ES	Futures	1138.29	1139.27	1133.4	1133.65	34675.0
2010-05-06 03:00:00	ES	Futures	1133.89	1140.49	1132.18	1139.27	71899.0
2010-05-06 04:00:00	ES	Futures	1139.27	1141.72	1137.07	1141.47	43310.0
2010-05-06 05:00:00	ES	Futures	1141.23	1141.96	1138.78	1140.49	30262.0
2010-05-06 06:00:00	ES	Futures	1140.74	1142.69	1140.74	1142.45	30743.0
2010-05-06 07:00:00	ES	Futures	1142.2	1142.69	1136.34	1137.07	64871.0
2010-05-06 08:00:00	ES	Futures	1137.07	1139.03	1129.74	1130.23	152841.0
2010-05-06 09:00:00	ES	Futures	1130.47	1138.54	1129.49	1135.85	398117.0
2010-05-06 10:00:00	ES	Futures	1135.6	1139.03	1127.54	1129.74	524215.0
2010-05-06 11:00:00	ES	Futures	1129.74	1129.74	1121.67	1126.07	618337.0
2010-05-06 12:00:00	ES	Futures	1126.32	1131.45	1122.89	1126.32	347471.0
2010-05-06 13:00:00	ES	Futures	1126.56	1127.78	1115.32	1116.78	414013.0
2010-05-06 14:00:00	ES	Futures	1116.78	1118.25	1032.46	1087.94	1600843.0
2010-05-06 15:00:00	ES	Futures	1087.94	1110.67	1078.65	1098.45	1107895.0
2010-05-06 16:00:00	ES	Futures	1098.45	1099.92	1090.87	1091.36	199316.0
2010-05-06 17:00:00	ES	Futures	1091.61	1095.27	1091.12	1092.1	12140.0
2010-05-06 18:00:00	ES	Futures	1092.34	1095.76	1090.39	1091.61	16292.0
2010-05-06 19:00:00	ES	Futures	1091.61	1095.27	1088.67	1095.03	22995.0
2010-05-06 20:00:00	ES	Futures	1095.03	1097.47	1092.59	1096.5	21451.0
2010-05-06 21:00:00	ES	Futures	1096.74	1097.96	1095.27	1097.72	11752.0
2010-05-06 22:00:00	ES	Futures	1097.47	1104.81	1096.99	1102.12	25045.0
2010-05-06 23:00:00	ES	Futures	1102.12	1104.56	1099.92	1103.58	10562.0
2010-05-06 00:00:00	NQ	Futures	2245.16	2245.45	2242.87	2244.59	113.0
2010-05-06 01:00:00	NQ	Futures	2244.3	2244.3	2242.87	2243.16	78.0
2010-05-06 02:00:00	NQ	Futures	2243.16	2244.02	2233.42	2233.71	1161.0
2010-05-06 03:00:00	NQ	Futures	2233.71	2246.02	2231.7	2244.59	4417.0
2010-05-06 04:00:00	NQ	Futures	2244.3	2248.02	2240.58	2247.45	2191.0
2010-05-06 05:00:00	NQ	Futures	2247.45	2248.31	2241.72	2244.59	1547.0
2010-05-06 06:00:00	NQ	Futures	2244.87	2247.74	2244.87	2247.45	2118.0
2010-05-06 07:00:00	NQ	Futures	2247.74	2248.6	2237.43	2239.72	3553.0
2010-05-06 08:00:00	NQ	Futures	2239.72	2243.16	2222.25	2223.4	10842.0
2010-05-06 09:00:00	NQ	Futures	2223.4	2243.44	2220.82	2240.87	71601.0
2010-05-06 10:00:00	NQ	Futures	2240.58	2247.45	2223.68	2227.12	68941.0
2010-05-06 11:00:00	NQ	Futures	2227.12	2227.69	2213.09	2223.97	76639.0
2010-05-06 12:00:00	NQ	Futures	2224.26	2233.13	2214.52	2222.25	48572.0
2010-05-06 13:00:00	NQ	Futures	2222.25	2224.54	2201.06	2205.64	58328.0
2010-05-06 14:00:00	NQ	Futures	2205.36	2208.22	1981.98	2146.36	197562.0
2010-05-06 15:00:00	NQ	Futures	2146.36	2190.18	2126.6	2166.12	166080.0
2010-05-06 16:00:00	NQ	Futures	2165.84	2168.7	2149.51	2151.23	22783.0
2010-05-06 17:00:00	NQ	Futures	2151.52	2159.25	2150.09	2151.23	694.0
2010-05-06 18:00:00	NQ	Futures	2152.09	2157.82	2147.22	2149.23	740.0
2010-05-06 19:00:00	NQ	Futures	2148.94	2156.1	2142.93	2154.67	1428.0
2010-05-06 20:00:00	NQ	Futures	2154.95	2160.68	2152.66	2159.82	1416.0
2010-05-06 21:00:00	NQ	Futures	2158.39	2161.83	2156.67	2160.97	549.0
2010-05-06 22:00:00	NQ	Futures	2160.68	2177.0	2159.25	2169.85	1732.0
2010-05-06 23:00:00	NQ	Futures	2169.56	2174.43	2164.69	2172.71	946.0
2010-05-06 00:00:00	YM	Futures	10209.6	10210.6	10194.6	10198.3	160.0
2010-05-06 01:00:00	YM	Futures	10200.2	10200.2	10191.8	10196.5	219.0

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

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