PREVIEW / futures_1hour / 2010-05-12

all futures 1-hour files

  file:    by_date/futures_1hour/2010/2010-05-12.parquet
  size:    48 KB
  rows:    1,399

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-12 00:00:00	ES	Futures	1120.69	1121.92	1115.56	1116.54	10698.0
2010-05-12 01:00:00	ES	Futures	1116.54	1122.16	1115.81	1121.67	8794.0
2010-05-12 02:00:00	ES	Futures	1121.67	1123.63	1119.47	1121.92	16298.0
2010-05-12 03:00:00	ES	Futures	1122.16	1129.0	1119.96	1128.76	46997.0
2010-05-12 04:00:00	ES	Futures	1129.0	1130.96	1127.78	1127.78	52600.0
2010-05-12 05:00:00	ES	Futures	1128.03	1128.52	1123.38	1126.81	34408.0
2010-05-12 06:00:00	ES	Futures	1127.05	1131.2	1126.56	1129.98	36168.0
2010-05-12 07:00:00	ES	Futures	1130.23	1134.14	1129.0	1133.4	41365.0
2010-05-12 08:00:00	ES	Futures	1133.4	1134.14	1130.72	1132.92	59650.0
2010-05-12 09:00:00	ES	Futures	1132.92	1137.56	1130.23	1137.32	264057.0
2010-05-12 10:00:00	ES	Futures	1137.32	1139.76	1134.87	1137.56	279031.0
2010-05-12 11:00:00	ES	Futures	1137.56	1140.98	1133.4	1137.32	316095.0
2010-05-12 12:00:00	ES	Futures	1137.32	1140.74	1137.07	1140.49	133831.0
2010-05-12 13:00:00	ES	Futures	1140.49	1143.43	1138.54	1138.54	216858.0
2010-05-12 14:00:00	ES	Futures	1138.54	1143.67	1138.29	1142.69	159013.0
2010-05-12 15:00:00	ES	Futures	1142.94	1145.14	1140.25	1143.67	284163.0
2010-05-12 16:00:00	ES	Futures	1143.67	1143.91	1141.47	1141.96	91193.0
2010-05-12 17:00:00	ES	Futures	1141.96	1143.91	1141.47	1142.94	3512.0
2010-05-12 18:00:00	ES	Futures	1142.94	1143.18	1141.23	1141.47	3414.0
2010-05-12 19:00:00	ES	Futures	1141.47	1142.94	1141.23	1142.45	2289.0
2010-05-12 20:00:00	ES	Futures	1142.45	1143.67	1142.2	1142.69	4070.0
2010-05-12 21:00:00	ES	Futures	1142.69	1143.43	1141.96	1143.18	3750.0
2010-05-12 22:00:00	ES	Futures	1143.43	1144.4	1143.18	1143.43	5096.0
2010-05-12 23:00:00	ES	Futures	1143.43	1143.91	1142.94	1143.67	1754.0
2010-05-12 00:00:00	NQ	Futures	2204.21	2206.79	2195.91	2197.91	670.0
2010-05-12 01:00:00	NQ	Futures	2197.62	2206.5	2196.19	2206.5	904.0
2010-05-12 02:00:00	NQ	Futures	2206.21	2211.37	2202.21	2207.93	1499.0
2010-05-12 03:00:00	NQ	Futures	2208.22	2219.67	2203.06	2219.67	3343.0
2010-05-12 04:00:00	NQ	Futures	2219.67	2224.54	2218.24	2218.53	3145.0
2010-05-12 05:00:00	NQ	Futures	2218.53	2219.39	2210.22	2217.96	2706.0
2010-05-12 06:00:00	NQ	Futures	2218.24	2223.97	2216.52	2221.96	1591.0
2010-05-12 07:00:00	NQ	Futures	2221.96	2230.84	2220.53	2229.7	2221.0
2010-05-12 08:00:00	NQ	Futures	2229.7	2232.56	2225.97	2231.42	6395.0
2010-05-12 09:00:00	NQ	Futures	2231.13	2244.87	2227.12	2244.3	51014.0
2010-05-12 10:00:00	NQ	Futures	2244.02	2252.61	2241.44	2249.46	52235.0
2010-05-12 11:00:00	NQ	Futures	2249.46	2254.9	2241.15	2248.88	48678.0
2010-05-12 12:00:00	NQ	Futures	2248.88	2254.04	2247.45	2252.89	22313.0
2010-05-12 13:00:00	NQ	Futures	2252.89	2258.62	2250.32	2251.17	35387.0
2010-05-12 14:00:00	NQ	Futures	2251.46	2261.48	2249.74	2259.77	26203.0
2010-05-12 15:00:00	NQ	Futures	2259.48	2263.78	2254.9	2261.48	48122.0
2010-05-12 16:00:00	NQ	Futures	2261.48	2261.77	2251.46	2253.47	14102.0
2010-05-12 17:00:00	NQ	Futures	2253.47	2256.04	2251.46	2254.9	1188.0
2010-05-12 18:00:00	NQ	Futures	2255.76	2255.76	2252.03	2253.18	386.0
2010-05-12 19:00:00	NQ	Futures	2253.47	2256.62	2253.18	2255.47	203.0
2010-05-12 20:00:00	NQ	Futures	2255.76	2256.9	2254.04	2254.61	281.0
2010-05-12 21:00:00	NQ	Futures	2254.33	2256.9	2253.47	2256.04	256.0
2010-05-12 22:00:00	NQ	Futures	2256.33	2257.76	2254.61	2256.04	499.0
2010-05-12 23:00:00	NQ	Futures	2256.04	2256.33	2254.9	2255.76	131.0
2010-05-12 00:00:00	YM	Futures	10032.7	10045.0	9995.1	10002.6	775.0
2010-05-12 01:00:00	YM	Futures	10001.7	10046.8	9998.9	10043.1	689.0

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

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