PREVIEW / futures_1hour / 2012-12-12

all futures 1-hour files

  file:    by_date/futures_1hour/2012/2012-12-12.parquet
  size:    47 KB
  rows:    1,443

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-12 00:00:00	ES	Futures	1460.74	1462.27	1460.49	1462.02	3728.0
2012-12-12 01:00:00	ES	Futures	1462.02	1463.04	1461.76	1462.27	3143.0
2012-12-12 02:00:00	ES	Futures	1462.02	1462.79	1461.25	1461.76	5012.0
2012-12-12 03:00:00	ES	Futures	1461.76	1464.32	1461.0	1464.06	23372.0
2012-12-12 04:00:00	ES	Futures	1464.32	1465.6	1464.06	1464.83	20929.0
2012-12-12 05:00:00	ES	Futures	1464.83	1465.6	1463.81	1464.57	12263.0
2012-12-12 06:00:00	ES	Futures	1464.57	1464.83	1463.81	1464.06	8173.0
2012-12-12 07:00:00	ES	Futures	1464.32	1466.87	1463.81	1465.85	29240.0
2012-12-12 08:00:00	ES	Futures	1465.6	1466.11	1463.3	1465.08	31005.0
2012-12-12 09:00:00	ES	Futures	1465.34	1466.36	1462.02	1462.53	158685.0
2012-12-12 10:00:00	ES	Futures	1462.79	1463.04	1459.98	1461.25	176923.0
2012-12-12 11:00:00	ES	Futures	1461.25	1462.79	1460.23	1460.74	164625.0
2012-12-12 12:00:00	ES	Futures	1460.49	1469.94	1459.46	1468.41	260990.0
2012-12-12 13:00:00	ES	Futures	1468.66	1470.19	1466.36	1468.15	179315.0
2012-12-12 14:00:00	ES	Futures	1468.15	1468.92	1464.32	1465.08	161938.0
2012-12-12 15:00:00	ES	Futures	1465.08	1465.34	1457.42	1459.21	316217.0
2012-12-12 16:00:00	ES	Futures	1459.46	1459.98	1456.91	1457.16	86365.0
2012-12-12 17:00:00	ES	Futures	1456.91	1457.42	1456.91	1457.16	1057.0
2012-12-12 18:00:00	ES	Futures	1456.91	1459.72	1456.91	1459.46	6393.0
2012-12-12 19:00:00	ES	Futures	1459.46	1460.23	1458.7	1458.95	4781.0
2012-12-12 20:00:00	ES	Futures	1458.95	1459.72	1458.19	1459.21	6000.0
2012-12-12 21:00:00	ES	Futures	1459.21	1459.72	1458.7	1459.21	3631.0
2012-12-12 22:00:00	ES	Futures	1458.95	1461.0	1458.95	1459.46	6047.0
2012-12-12 23:00:00	ES	Futures	1459.46	1461.0	1459.21	1460.49	2951.0
2012-12-12 00:00:00	NQ	Futures	3119.63	3122.24	3119.34	3121.08	317.0
2012-12-12 01:00:00	NQ	Futures	3121.08	3123.99	3121.08	3123.41	720.0
2012-12-12 02:00:00	NQ	Futures	3123.41	3123.7	3120.21	3121.95	608.0
2012-12-12 03:00:00	NQ	Futures	3121.95	3126.31	3119.34	3126.31	2866.0
2012-12-12 04:00:00	NQ	Futures	3126.6	3128.93	3125.44	3127.76	2187.0
2012-12-12 05:00:00	NQ	Futures	3127.76	3128.93	3126.02	3127.76	1358.0
2012-12-12 06:00:00	NQ	Futures	3127.76	3128.35	3126.02	3126.31	1283.0
2012-12-12 07:00:00	NQ	Futures	3126.31	3131.83	3126.02	3130.67	3139.0
2012-12-12 08:00:00	NQ	Futures	3130.67	3132.12	3128.35	3130.96	6540.0
2012-12-12 09:00:00	NQ	Futures	3131.25	3133.58	3119.34	3120.79	32912.0
2012-12-12 10:00:00	NQ	Futures	3121.08	3121.66	3112.65	3114.69	34393.0
2012-12-12 11:00:00	NQ	Futures	3114.98	3118.47	3109.75	3110.62	23762.0
2012-12-12 12:00:00	NQ	Futures	3110.62	3130.67	3107.42	3127.47	37149.0
2012-12-12 13:00:00	NQ	Futures	3127.76	3130.09	3118.18	3125.44	31497.0
2012-12-12 14:00:00	NQ	Futures	3125.73	3130.09	3117.88	3119.63	29600.0
2012-12-12 15:00:00	NQ	Futures	3119.63	3120.5	3101.03	3108.88	46211.0
2012-12-12 16:00:00	NQ	Futures	3108.59	3109.75	3102.77	3103.36	5457.0
2012-12-12 17:00:00	NQ	Futures	3103.36	3104.23	3103.07	3103.94	136.0
2012-12-12 18:00:00	NQ	Futures	3103.65	3107.42	3103.65	3106.84	368.0
2012-12-12 19:00:00	NQ	Futures	3106.84	3108.59	3105.39	3105.97	393.0
2012-12-12 20:00:00	NQ	Futures	3105.97	3107.42	3104.23	3106.26	584.0
2012-12-12 21:00:00	NQ	Futures	3106.26	3107.71	3105.1	3105.68	183.0
2012-12-12 22:00:00	NQ	Futures	3105.68	3109.75	3105.68	3108.01	636.0
2012-12-12 23:00:00	NQ	Futures	3108.01	3110.62	3107.71	3110.04	233.0
2012-12-12 00:00:00	YM	Futures	13275.5	13284.6	13275.5	13284.6	29.0
2012-12-12 01:00:00	YM	Futures	13285.6	13291.6	13285.6	13286.6	27.0

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

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