PREVIEW / futures_1hour / 2010-05-14

all futures 1-hour files

  file:    by_date/futures_1hour/2010/2010-05-14.parquet
  size:    41 KB
  rows:    1,126

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-14 00:00:00	ES	Futures	1131.2	1133.16	1130.72	1132.67	3861.0
2010-05-14 01:00:00	ES	Futures	1132.67	1133.65	1130.47	1131.94	5078.0
2010-05-14 02:00:00	ES	Futures	1131.94	1133.16	1130.23	1132.18	9972.0
2010-05-14 03:00:00	ES	Futures	1132.18	1132.43	1126.56	1127.29	45830.0
2010-05-14 04:00:00	ES	Futures	1127.29	1128.52	1123.63	1123.87	34660.0
2010-05-14 05:00:00	ES	Futures	1123.87	1124.61	1119.96	1121.92	41061.0
2010-05-14 06:00:00	ES	Futures	1121.92	1123.87	1119.96	1123.63	26305.0
2010-05-14 07:00:00	ES	Futures	1123.63	1124.85	1121.92	1122.41	32519.0
2010-05-14 08:00:00	ES	Futures	1122.41	1124.36	1118.74	1122.16	96738.0
2010-05-14 09:00:00	ES	Futures	1121.92	1122.89	1109.45	1111.9	408398.0
2010-05-14 10:00:00	ES	Futures	1111.9	1116.54	1107.01	1111.41	436398.0
2010-05-14 11:00:00	ES	Futures	1111.41	1111.65	1100.41	1103.58	511724.0
2010-05-14 12:00:00	ES	Futures	1103.83	1107.98	1098.7	1107.5	284770.0
2010-05-14 13:00:00	ES	Futures	1107.5	1109.21	1101.87	1104.32	198784.0
2010-05-14 14:00:00	ES	Futures	1104.56	1106.27	1099.43	1102.85	213051.0
2010-05-14 15:00:00	ES	Futures	1102.61	1110.92	1098.94	1108.96	452414.0
2010-05-14 16:00:00	ES	Futures	1108.72	1110.67	1107.98	1109.94	110915.0
2010-05-14 00:00:00	NQ	Futures	2230.27	2233.13	2229.7	2232.85	282.0
2010-05-14 01:00:00	NQ	Futures	2232.27	2233.99	2229.41	2231.7	292.0
2010-05-14 02:00:00	NQ	Futures	2231.42	2234.28	2228.84	2233.13	943.0
2010-05-14 03:00:00	NQ	Futures	2232.85	2233.13	2223.97	2225.4	2626.0
2010-05-14 04:00:00	NQ	Futures	2225.4	2226.83	2218.81	2219.1	2229.0
2010-05-14 05:00:00	NQ	Futures	2219.1	2220.82	2211.66	2214.52	2839.0
2010-05-14 06:00:00	NQ	Futures	2214.81	2218.53	2211.94	2218.24	1472.0
2010-05-14 07:00:00	NQ	Futures	2218.53	2219.96	2214.81	2215.38	2152.0
2010-05-14 08:00:00	NQ	Futures	2215.66	2216.81	2207.07	2212.51	9411.0
2010-05-14 09:00:00	NQ	Futures	2212.23	2213.66	2177.58	2179.87	76414.0
2010-05-14 10:00:00	NQ	Futures	2179.58	2192.47	2173.57	2184.16	68485.0
2010-05-14 11:00:00	NQ	Futures	2184.16	2184.16	2162.4	2165.26	84041.0
2010-05-14 12:00:00	NQ	Futures	2165.26	2174.71	2156.96	2173.85	51392.0
2010-05-14 13:00:00	NQ	Futures	2173.57	2176.43	2163.54	2166.98	31605.0
2010-05-14 14:00:00	NQ	Futures	2166.41	2176.43	2160.68	2168.7	32214.0
2010-05-14 15:00:00	NQ	Futures	2168.7	2188.75	2161.54	2183.59	67434.0
2010-05-14 16:00:00	NQ	Futures	2183.59	2188.75	2181.87	2187.6	13589.0
2010-05-14 00:00:00	YM	Futures	10137.2	10153.2	10137.2	10153.2	350.0
2010-05-14 01:00:00	YM	Futures	10153.2	10157.9	10134.4	10145.6	410.0
2010-05-14 02:00:00	YM	Futures	10145.6	10155.1	10135.3	10147.5	723.0
2010-05-14 03:00:00	YM	Futures	10147.5	10149.4	10106.1	10110.8	2222.0
2010-05-14 04:00:00	YM	Futures	10109.9	10117.4	10085.4	10087.3	2325.0
2010-05-14 05:00:00	YM	Futures	10087.3	10093.0	10054.4	10067.5	2690.0
2010-05-14 06:00:00	YM	Futures	10066.6	10081.7	10055.3	10081.7	1529.0
2010-05-14 07:00:00	YM	Futures	10081.7	10089.2	10067.5	10070.4	1563.0
2010-05-14 08:00:00	YM	Futures	10070.4	10085.4	10045.0	10070.4	5711.0
2010-05-14 09:00:00	YM	Futures	10069.4	10081.7	9974.4	9991.3	31238.0
2010-05-14 10:00:00	YM	Futures	9990.4	10034.6	9955.6	9993.2	33666.0
2010-05-14 11:00:00	YM	Futures	9993.2	9994.1	9905.7	9935.8	37592.0
2010-05-14 12:00:00	YM	Futures	9935.8	9965.0	9893.5	9961.2	21474.0
2010-05-14 13:00:00	YM	Futures	9960.3	9974.4	9916.0	9934.9	14722.0
2010-05-14 14:00:00	YM	Futures	9934.9	9951.8	9891.6	9921.7	16923.0
2010-05-14 15:00:00	YM	Futures	9920.8	9990.4	9888.8	9974.4	29685.0

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

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