PREVIEW / futures_1hour / 2012-12-27

all futures 1-hour files

  file:    by_date/futures_1hour/2012/2012-12-27.parquet
  size:    48 KB
  rows:    1,513

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
2012-12-27 00:00:00	ES	Futures	1451.02	1451.79	1450.25	1451.28	3079.0
2012-12-27 01:00:00	ES	Futures	1451.54	1451.79	1451.02	1451.28	930.0
2012-12-27 02:00:00	ES	Futures	1451.02	1452.31	1450.77	1451.02	3731.0
2012-12-27 03:00:00	ES	Futures	1451.02	1451.28	1448.46	1451.02	15379.0
2012-12-27 04:00:00	ES	Futures	1451.02	1451.79	1450.51	1451.54	7867.0
2012-12-27 05:00:00	ES	Futures	1451.79	1452.05	1450.0	1451.28	6460.0
2012-12-27 06:00:00	ES	Futures	1451.28	1454.36	1451.28	1454.1	10064.0
2012-12-27 07:00:00	ES	Futures	1454.1	1455.64	1453.59	1453.59	8034.0
2012-12-27 08:00:00	ES	Futures	1453.85	1454.36	1452.31	1453.59	17904.0
2012-12-27 09:00:00	ES	Futures	1453.33	1455.9	1450.77	1452.05	102623.0
2012-12-27 10:00:00	ES	Futures	1451.79	1452.05	1440.5	1442.81	295609.0
2012-12-27 11:00:00	ES	Futures	1442.81	1444.35	1438.71	1439.73	167108.0
2012-12-27 12:00:00	ES	Futures	1439.73	1439.99	1432.8	1437.42	184801.0
2012-12-27 13:00:00	ES	Futures	1437.68	1440.5	1435.37	1436.14	128697.0
2012-12-27 14:00:00	ES	Futures	1436.4	1445.12	1434.34	1443.84	178790.0
2012-12-27 15:00:00	ES	Futures	1444.09	1453.85	1442.56	1450.25	257999.0
2012-12-27 16:00:00	ES	Futures	1450.51	1451.79	1446.92	1451.79	56912.0
2012-12-27 17:00:00	ES	Futures	1451.54	1452.05	1450.77	1451.02	1575.0
2012-12-27 18:00:00	ES	Futures	1450.51	1454.1	1450.51	1452.05	8276.0
2012-12-27 19:00:00	ES	Futures	1451.79	1452.05	1450.25	1451.28	5249.0
2012-12-27 20:00:00	ES	Futures	1451.28	1451.28	1447.43	1448.71	6745.0
2012-12-27 21:00:00	ES	Futures	1448.71	1450.51	1448.46	1450.25	2882.0
2012-12-27 22:00:00	ES	Futures	1450.0	1450.77	1449.23	1449.48	1339.0
2012-12-27 23:00:00	ES	Futures	1449.74	1450.0	1448.46	1449.48	3003.0
2012-12-27 00:00:00	NQ	Futures	3063.21	3063.79	3062.05	3062.92	323.0
2012-12-27 01:00:00	NQ	Futures	3063.79	3063.79	3062.63	3063.21	58.0
2012-12-27 02:00:00	NQ	Futures	3062.92	3064.96	3060.01	3060.3	595.0
2012-12-27 03:00:00	NQ	Futures	3060.3	3061.76	3055.35	3060.59	2560.0
2012-12-27 04:00:00	NQ	Futures	3060.3	3061.17	3058.55	3060.3	1128.0
2012-12-27 05:00:00	NQ	Futures	3060.3	3066.12	3059.72	3066.12	1083.0
2012-12-27 06:00:00	NQ	Futures	3066.41	3070.49	3065.54	3068.16	1487.0
2012-12-27 07:00:00	NQ	Futures	3068.16	3071.07	3067.29	3068.45	834.0
2012-12-27 08:00:00	NQ	Futures	3068.74	3069.61	3064.96	3067.29	2305.0
2012-12-27 09:00:00	NQ	Futures	3067.29	3068.16	3056.52	3061.76	19997.0
2012-12-27 10:00:00	NQ	Futures	3061.76	3062.34	3036.43	3047.49	42369.0
2012-12-27 11:00:00	NQ	Futures	3047.2	3052.15	3031.78	3033.81	24987.0
2012-12-27 12:00:00	NQ	Futures	3034.4	3035.56	3019.55	3029.16	26237.0
2012-12-27 13:00:00	NQ	Futures	3029.16	3037.89	3027.41	3028.57	19571.0
2012-12-27 14:00:00	NQ	Futures	3028.86	3048.37	3024.21	3046.91	26907.0
2012-12-27 15:00:00	NQ	Futures	3046.91	3069.03	3044.58	3057.97	33283.0
2012-12-27 16:00:00	NQ	Futures	3057.68	3059.72	3053.31	3058.26	5115.0
2012-12-27 17:00:00	NQ	Futures	3058.84	3058.84	3057.1	3057.1	418.0
2012-12-27 18:00:00	NQ	Futures	3056.23	3062.63	3056.23	3059.43	471.0
2012-12-27 19:00:00	NQ	Futures	3059.43	3060.3	3057.1	3059.72	370.0
2012-12-27 20:00:00	NQ	Futures	3059.14	3059.43	3052.15	3055.06	715.0
2012-12-27 21:00:00	NQ	Futures	3054.77	3057.68	3054.77	3056.52	316.0
2012-12-27 22:00:00	NQ	Futures	3056.23	3056.81	3053.02	3053.31	303.0
2012-12-27 23:00:00	NQ	Futures	3053.9	3054.77	3051.57	3053.31	942.0
2012-12-27 00:00:00	YM	Futures	13124.6	13131.6	13121.6	13127.6	253.0
2012-12-27 01:00:00	YM	Futures	13126.6	13131.6	13126.6	13129.6	90.0

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

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