PREVIEW / futures_1hour / 2012-07-30

all futures 1-hour files

  file:    by_date/futures_1hour/2012/2012-07-30.parquet
  size:    46 KB
  rows:    1,437

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-07-30 00:00:00	ES	Futures	1403.14	1403.14	1400.85	1401.36	3214.0
2012-07-30 01:00:00	ES	Futures	1401.36	1402.37	1401.1	1402.12	3047.0
2012-07-30 02:00:00	ES	Futures	1402.37	1402.63	1400.59	1400.85	7350.0
2012-07-30 03:00:00	ES	Futures	1400.59	1402.37	1399.83	1401.61	41960.0
2012-07-30 04:00:00	ES	Futures	1401.61	1401.86	1399.32	1400.34	20192.0
2012-07-30 05:00:00	ES	Futures	1400.34	1404.41	1399.83	1403.14	30055.0
2012-07-30 06:00:00	ES	Futures	1403.14	1404.15	1401.61	1402.63	17945.0
2012-07-30 07:00:00	ES	Futures	1402.63	1403.64	1401.86	1402.37	22526.0
2012-07-30 08:00:00	ES	Futures	1402.63	1403.64	1400.59	1402.63	38768.0
2012-07-30 09:00:00	ES	Futures	1402.63	1407.71	1402.12	1407.46	206412.0
2012-07-30 10:00:00	ES	Futures	1407.46	1411.27	1404.41	1404.92	307271.0
2012-07-30 11:00:00	ES	Futures	1404.92	1407.46	1400.34	1402.37	239164.0
2012-07-30 12:00:00	ES	Futures	1402.37	1404.41	1400.08	1402.88	110744.0
2012-07-30 13:00:00	ES	Futures	1403.14	1405.42	1401.61	1402.12	78718.0
2012-07-30 14:00:00	ES	Futures	1402.12	1405.42	1400.85	1404.41	82747.0
2012-07-30 15:00:00	ES	Futures	1404.41	1405.68	1401.1	1404.66	173080.0
2012-07-30 16:00:00	ES	Futures	1404.66	1405.17	1402.63	1403.9	71178.0
2012-07-30 17:00:00	ES	Futures	1404.15	1404.41	1403.9	1403.9	686.0
2012-07-30 18:00:00	ES	Futures	1404.15	1405.42	1403.9	1405.17	2349.0
2012-07-30 19:00:00	ES	Futures	1404.92	1405.17	1402.88	1403.39	1785.0
2012-07-30 20:00:00	ES	Futures	1403.14	1403.64	1401.61	1402.37	6347.0
2012-07-30 21:00:00	ES	Futures	1402.37	1406.44	1402.12	1405.42	7291.0
2012-07-30 22:00:00	ES	Futures	1405.42	1408.73	1405.42	1408.48	8757.0
2012-07-30 23:00:00	ES	Futures	1408.48	1408.73	1406.7	1407.97	3741.0
2012-07-30 00:00:00	NQ	Futures	3060.61	3061.48	3057.13	3057.42	677.0
2012-07-30 01:00:00	NQ	Futures	3057.42	3059.16	3056.55	3059.16	234.0
2012-07-30 02:00:00	NQ	Futures	3059.45	3060.03	3056.26	3056.55	509.0
2012-07-30 03:00:00	NQ	Futures	3056.55	3062.34	3055.39	3060.61	4465.0
2012-07-30 04:00:00	NQ	Futures	3060.61	3061.48	3056.26	3058.58	2377.0
2012-07-30 05:00:00	NQ	Futures	3058.58	3066.4	3056.84	3063.79	2860.0
2012-07-30 06:00:00	NQ	Futures	3063.21	3065.53	3060.03	3062.34	2101.0
2012-07-30 07:00:00	NQ	Futures	3062.34	3065.24	3061.19	3062.92	2960.0
2012-07-30 08:00:00	NQ	Futures	3063.21	3067.85	3062.34	3067.27	5475.0
2012-07-30 09:00:00	NQ	Futures	3066.98	3081.19	3066.11	3079.16	39996.0
2012-07-30 10:00:00	NQ	Futures	3078.87	3081.77	3059.74	3060.61	43615.0
2012-07-30 11:00:00	NQ	Futures	3060.61	3067.85	3051.33	3057.42	41240.0
2012-07-30 12:00:00	NQ	Futures	3057.71	3061.48	3050.75	3055.39	22589.0
2012-07-30 13:00:00	NQ	Futures	3055.39	3062.05	3052.2	3055.1	12135.0
2012-07-30 14:00:00	NQ	Futures	3055.1	3061.48	3051.91	3059.16	12092.0
2012-07-30 15:00:00	NQ	Futures	3059.45	3060.32	3047.56	3057.13	28685.0
2012-07-30 16:00:00	NQ	Futures	3057.13	3060.61	3055.68	3059.45	7322.0
2012-07-30 17:00:00	NQ	Futures	3058.58	3059.74	3058.29	3059.45	32.0
2012-07-30 18:00:00	NQ	Futures	3058.58	3061.19	3058.0	3060.9	254.0
2012-07-30 19:00:00	NQ	Futures	3060.61	3060.9	3056.55	3057.42	160.0
2012-07-30 20:00:00	NQ	Futures	3057.42	3058.29	3054.23	3055.39	611.0
2012-07-30 21:00:00	NQ	Futures	3055.68	3064.37	3055.68	3063.21	1418.0
2012-07-30 22:00:00	NQ	Futures	3063.21	3069.59	3063.21	3069.01	1336.0
2012-07-30 23:00:00	NQ	Futures	3069.01	3069.59	3064.95	3068.43	744.0
2012-07-30 00:00:00	YM	Futures	12939.2	12940.2	12921.3	12924.3	221.0
2012-07-30 01:00:00	YM	Futures	12924.3	12930.2	12919.3	12930.2	278.0

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

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