PREVIEW / futures_1hour / 2010-04-12

all futures 1-hour files

  file:    by_date/futures_1hour/2010/2010-04-12.parquet
  size:    44 KB
  rows:    1,356

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-04-12 00:00:00	ES	Futures	1169.82	1170.31	1169.58	1169.82	3613.0
2010-04-12 01:00:00	ES	Futures	1170.07	1170.07	1169.34	1169.82	2150.0
2010-04-12 02:00:00	ES	Futures	1169.82	1170.56	1167.87	1168.36	17429.0
2010-04-12 03:00:00	ES	Futures	1168.36	1169.09	1167.14	1167.62	19180.0
2010-04-12 04:00:00	ES	Futures	1167.87	1168.36	1166.65	1168.11	12957.0
2010-04-12 05:00:00	ES	Futures	1168.11	1168.6	1166.65	1167.38	9617.0
2010-04-12 06:00:00	ES	Futures	1167.14	1167.38	1165.91	1166.65	11643.0
2010-04-12 07:00:00	ES	Futures	1166.65	1167.14	1164.45	1166.16	25127.0
2010-04-12 08:00:00	ES	Futures	1166.16	1166.65	1164.45	1165.18	38273.0
2010-04-12 09:00:00	ES	Futures	1165.18	1168.11	1164.45	1164.69	175182.0
2010-04-12 10:00:00	ES	Futures	1164.69	1167.62	1164.2	1167.38	198283.0
2010-04-12 11:00:00	ES	Futures	1167.38	1167.87	1165.18	1166.89	98802.0
2010-04-12 12:00:00	ES	Futures	1166.89	1167.62	1166.16	1167.62	67945.0
2010-04-12 13:00:00	ES	Futures	1167.38	1169.09	1166.65	1166.65	105434.0
2010-04-12 14:00:00	ES	Futures	1166.89	1168.36	1166.16	1167.62	95342.0
2010-04-12 15:00:00	ES	Futures	1167.87	1168.36	1164.45	1166.4	248993.0
2010-04-12 16:00:00	ES	Futures	1166.16	1166.89	1164.94	1165.91	87566.0
2010-04-12 17:00:00	ES	Futures	1165.91	1165.91	1165.18	1165.18	1747.0
2010-04-12 18:00:00	ES	Futures	1165.42	1165.91	1164.94	1165.18	1259.0
2010-04-12 19:00:00	ES	Futures	1165.42	1165.42	1164.69	1164.69	2190.0
2010-04-12 20:00:00	ES	Futures	1164.69	1165.18	1162.49	1162.74	6558.0
2010-04-12 21:00:00	ES	Futures	1162.74	1163.22	1162.0	1163.22	5120.0
2010-04-12 22:00:00	ES	Futures	1162.98	1163.96	1162.74	1163.22	2125.0
2010-04-12 23:00:00	ES	Futures	1163.22	1163.47	1161.51	1161.76	5211.0
2010-04-12 00:00:00	NQ	Futures	2289.84	2290.41	2289.26	2290.12	112.0
2010-04-12 01:00:00	NQ	Futures	2290.12	2290.12	2287.54	2288.69	253.0
2010-04-12 02:00:00	NQ	Futures	2288.69	2289.84	2286.11	2286.4	1011.0
2010-04-12 03:00:00	NQ	Futures	2286.69	2287.54	2284.39	2285.25	1971.0
2010-04-12 04:00:00	NQ	Futures	2284.97	2286.11	2283.54	2285.83	1002.0
2010-04-12 05:00:00	NQ	Futures	2285.83	2286.11	2283.54	2284.39	1020.0
2010-04-12 06:00:00	NQ	Futures	2284.39	2284.39	2282.96	2284.11	1094.0
2010-04-12 07:00:00	NQ	Futures	2284.11	2284.39	2280.38	2282.96	1653.0
2010-04-12 08:00:00	NQ	Futures	2282.68	2283.25	2279.81	2280.96	2983.0
2010-04-12 09:00:00	NQ	Futures	2280.96	2288.12	2277.81	2277.81	36109.0
2010-04-12 10:00:00	NQ	Futures	2277.81	2284.97	2276.95	2284.39	31424.0
2010-04-12 11:00:00	NQ	Futures	2284.68	2285.83	2280.38	2282.96	17135.0
2010-04-12 12:00:00	NQ	Futures	2283.25	2284.97	2281.53	2284.39	9538.0
2010-04-12 13:00:00	NQ	Futures	2284.39	2288.69	2284.39	2284.97	17034.0
2010-04-12 14:00:00	NQ	Futures	2284.97	2288.4	2284.39	2287.54	15266.0
2010-04-12 15:00:00	NQ	Futures	2287.26	2288.12	2280.67	2282.39	33208.0
2010-04-12 16:00:00	NQ	Futures	2282.1	2282.96	2279.24	2280.96	8765.0
2010-04-12 17:00:00	NQ	Futures	2280.67	2281.24	2280.67	2280.96	24.0
2010-04-12 18:00:00	NQ	Futures	2280.38	2282.39	2280.38	2280.96	198.0
2010-04-12 19:00:00	NQ	Futures	2280.96	2281.24	2280.1	2280.38	168.0
2010-04-12 20:00:00	NQ	Futures	2280.38	2280.38	2276.38	2276.38	496.0
2010-04-12 21:00:00	NQ	Futures	2276.66	2277.52	2275.23	2276.66	433.0
2010-04-12 22:00:00	NQ	Futures	2276.66	2278.38	2276.66	2277.23	147.0
2010-04-12 23:00:00	NQ	Futures	2277.23	2277.52	2274.94	2275.52	275.0
2010-04-12 00:00:00	YM	Futures	10338.5	10341.4	10336.7	10341.4	252.0
2010-04-12 01:00:00	YM	Futures	10341.4	10341.4	10336.7	10337.6	120.0

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

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