PREVIEW / futures_1hour / 2010-09-22

all futures 1-hour files

  file:    by_date/futures_1hour/2010/2010-09-22.parquet
  size:    47 KB
  rows:    1,411

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-09-22 00:00:00	ES	Futures	1122.96	1124.19	1122.96	1123.2	4632.0
2010-09-22 01:00:00	ES	Futures	1123.2	1123.7	1121.97	1122.22	3041.0
2010-09-22 02:00:00	ES	Futures	1121.97	1123.94	1120.99	1123.2	11279.0
2010-09-22 03:00:00	ES	Futures	1122.96	1123.2	1115.07	1116.55	47771.0
2010-09-22 04:00:00	ES	Futures	1116.3	1117.04	1113.1	1115.56	37913.0
2010-09-22 05:00:00	ES	Futures	1115.32	1117.29	1114.33	1116.55	26341.0
2010-09-22 06:00:00	ES	Futures	1116.55	1118.77	1116.06	1116.3	17498.0
2010-09-22 07:00:00	ES	Futures	1116.3	1116.55	1114.08	1116.06	23582.0
2010-09-22 08:00:00	ES	Futures	1116.06	1118.52	1115.56	1116.06	57763.0
2010-09-22 09:00:00	ES	Futures	1116.3	1123.7	1115.81	1120.49	261878.0
2010-09-22 10:00:00	ES	Futures	1120.74	1120.74	1114.33	1117.04	379490.0
2010-09-22 11:00:00	ES	Futures	1117.04	1117.78	1110.63	1113.84	301013.0
2010-09-22 12:00:00	ES	Futures	1113.84	1115.32	1112.36	1112.85	125625.0
2010-09-22 13:00:00	ES	Futures	1112.61	1115.07	1110.63	1114.08	145187.0
2010-09-22 14:00:00	ES	Futures	1113.84	1116.8	1112.11	1116.06	163405.0
2010-09-22 15:00:00	ES	Futures	1116.3	1116.8	1112.36	1114.08	240717.0
2010-09-22 16:00:00	ES	Futures	1114.08	1115.81	1113.59	1115.56	66965.0
2010-09-22 17:00:00	ES	Futures	1115.56	1116.06	1114.82	1115.81	1658.0
2010-09-22 18:00:00	ES	Futures	1115.81	1116.55	1115.56	1115.81	2645.0
2010-09-22 19:00:00	ES	Futures	1115.81	1116.06	1115.07	1115.56	1543.0
2010-09-22 20:00:00	ES	Futures	1115.56	1116.55	1115.07	1116.55	1988.0
2010-09-22 21:00:00	ES	Futures	1116.3	1117.29	1116.3	1116.8	2898.0
2010-09-22 22:00:00	ES	Futures	1116.8	1117.78	1116.55	1117.54	2214.0
2010-09-22 23:00:00	ES	Futures	1117.54	1117.78	1116.8	1117.04	1424.0
2010-09-22 00:00:00	NQ	Futures	2284.32	2286.61	2284.32	2286.33	222.0
2010-09-22 01:00:00	NQ	Futures	2286.04	2286.33	2283.46	2283.74	152.0
2010-09-22 02:00:00	NQ	Futures	2284.03	2286.04	2281.16	2284.6	833.0
2010-09-22 03:00:00	NQ	Futures	2284.6	2284.6	2269.4	2272.27	4116.0
2010-09-22 04:00:00	NQ	Futures	2272.27	2272.55	2267.39	2271.69	3531.0
2010-09-22 05:00:00	NQ	Futures	2271.69	2275.71	2269.4	2274.56	1916.0
2010-09-22 06:00:00	NQ	Futures	2274.28	2278.01	2271.69	2272.27	1813.0
2010-09-22 07:00:00	NQ	Futures	2272.55	2272.55	2267.68	2270.55	4319.0
2010-09-22 08:00:00	NQ	Futures	2270.55	2274.28	2265.96	2266.53	9803.0
2010-09-22 09:00:00	NQ	Futures	2266.53	2289.2	2265.96	2280.01	66086.0
2010-09-22 10:00:00	NQ	Futures	2280.01	2280.59	2266.82	2273.13	62334.0
2010-09-22 11:00:00	NQ	Futures	2272.84	2274.56	2261.65	2268.83	46111.0
2010-09-22 12:00:00	NQ	Futures	2268.83	2271.69	2264.52	2264.81	26852.0
2010-09-22 13:00:00	NQ	Futures	2264.52	2270.26	2261.37	2267.68	27797.0
2010-09-22 14:00:00	NQ	Futures	2267.68	2274.56	2263.95	2273.42	31201.0
2010-09-22 15:00:00	NQ	Futures	2273.42	2274.56	2266.82	2272.84	39099.0
2010-09-22 16:00:00	NQ	Futures	2272.84	2276.28	2271.69	2276.0	6512.0
2010-09-22 17:00:00	NQ	Futures	2275.71	2277.72	2275.14	2276.86	166.0
2010-09-22 18:00:00	NQ	Futures	2276.28	2277.43	2276.0	2276.28	171.0
2010-09-22 19:00:00	NQ	Futures	2276.57	2277.15	2275.14	2275.42	114.0
2010-09-22 20:00:00	NQ	Futures	2275.42	2278.29	2274.56	2277.72	230.0
2010-09-22 21:00:00	NQ	Futures	2277.72	2279.44	2277.72	2278.87	220.0
2010-09-22 22:00:00	NQ	Futures	2278.29	2279.73	2277.43	2279.73	142.0
2010-09-22 23:00:00	NQ	Futures	2279.73	2280.3	2278.29	2279.15	119.0
2010-09-22 00:00:00	YM	Futures	10223.9	10229.6	10220.1	10224.8	172.0
2010-09-22 01:00:00	YM	Futures	10223.9	10227.7	10213.4	10216.3	220.0

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

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