PREVIEW / futures_1hour / 2012-08-15

all futures 1-hour files

  file:    by_date/futures_1hour/2012/2012-08-15.parquet
  size:    47 KB
  rows:    1,446

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-08-15 00:00:00	ES	Futures	1421.95	1422.46	1421.7	1422.21	1392.0
2012-08-15 01:00:00	ES	Futures	1421.95	1422.97	1421.44	1422.72	3001.0
2012-08-15 02:00:00	ES	Futures	1422.72	1424.75	1422.46	1423.48	7510.0
2012-08-15 03:00:00	ES	Futures	1423.48	1423.99	1421.19	1421.95	18948.0
2012-08-15 04:00:00	ES	Futures	1421.95	1423.99	1420.94	1423.48	24021.0
2012-08-15 05:00:00	ES	Futures	1423.48	1424.5	1422.21	1422.97	10123.0
2012-08-15 06:00:00	ES	Futures	1422.97	1423.48	1421.7	1422.72	15943.0
2012-08-15 07:00:00	ES	Futures	1422.72	1423.73	1421.95	1422.46	21327.0
2012-08-15 08:00:00	ES	Futures	1422.46	1424.5	1421.44	1422.72	44832.0
2012-08-15 09:00:00	ES	Futures	1422.72	1428.82	1422.46	1427.8	158838.0
2012-08-15 10:00:00	ES	Futures	1427.8	1428.82	1424.75	1426.53	229947.0
2012-08-15 11:00:00	ES	Futures	1426.53	1428.06	1425.51	1427.55	142670.0
2012-08-15 12:00:00	ES	Futures	1427.55	1428.31	1426.78	1427.29	53357.0
2012-08-15 13:00:00	ES	Futures	1427.55	1427.55	1425.77	1426.02	37701.0
2012-08-15 14:00:00	ES	Futures	1425.77	1429.84	1425.51	1428.82	99717.0
2012-08-15 15:00:00	ES	Futures	1428.56	1429.07	1426.28	1427.04	143625.0
2012-08-15 16:00:00	ES	Futures	1427.04	1428.82	1426.78	1428.56	67795.0
2012-08-15 17:00:00	ES	Futures	1428.56	1428.56	1427.55	1428.06	2574.0
2012-08-15 18:00:00	ES	Futures	1427.8	1428.31	1427.29	1427.8	1293.0
2012-08-15 19:00:00	ES	Futures	1428.06	1428.31	1427.55	1428.06	597.0
2012-08-15 20:00:00	ES	Futures	1427.8	1429.58	1427.55	1429.07	3622.0
2012-08-15 21:00:00	ES	Futures	1428.82	1429.58	1427.8	1429.07	5010.0
2012-08-15 22:00:00	ES	Futures	1429.07	1430.85	1428.82	1429.33	7362.0
2012-08-15 23:00:00	ES	Futures	1429.58	1430.09	1428.82	1429.84	3475.0
2012-08-15 00:00:00	NQ	Futures	3154.82	3156.27	3154.82	3156.27	197.0
2012-08-15 01:00:00	NQ	Futures	3155.98	3157.43	3154.82	3156.85	316.0
2012-08-15 02:00:00	NQ	Futures	3156.85	3162.36	3156.85	3160.62	810.0
2012-08-15 03:00:00	NQ	Futures	3160.33	3161.49	3152.21	3154.53	2477.0
2012-08-15 04:00:00	NQ	Futures	3154.53	3159.17	3152.5	3158.01	1895.0
2012-08-15 05:00:00	NQ	Futures	3158.3	3160.04	3155.4	3156.85	784.0
2012-08-15 06:00:00	NQ	Futures	3156.85	3158.88	3154.24	3158.59	1270.0
2012-08-15 07:00:00	NQ	Futures	3158.59	3159.46	3154.53	3156.85	1550.0
2012-08-15 08:00:00	NQ	Futures	3157.14	3161.78	3155.69	3158.3	4281.0
2012-08-15 09:00:00	NQ	Futures	3158.01	3172.5	3157.72	3169.89	28635.0
2012-08-15 10:00:00	NQ	Futures	3170.18	3171.92	3161.49	3169.6	28713.0
2012-08-15 11:00:00	NQ	Futures	3169.31	3174.53	3167.57	3173.66	18026.0
2012-08-15 12:00:00	NQ	Futures	3173.95	3175.98	3170.76	3172.79	17200.0
2012-08-15 13:00:00	NQ	Futures	3172.79	3172.79	3164.96	3164.96	10436.0
2012-08-15 14:00:00	NQ	Futures	3164.96	3172.79	3162.93	3171.63	15974.0
2012-08-15 15:00:00	NQ	Futures	3171.63	3174.53	3168.44	3171.34	20527.0
2012-08-15 16:00:00	NQ	Futures	3171.34	3180.04	3170.47	3178.59	7491.0
2012-08-15 17:00:00	NQ	Futures	3178.3	3178.59	3176.85	3178.01	173.0
2012-08-15 18:00:00	NQ	Futures	3178.3	3178.3	3176.56	3177.72	173.0
2012-08-15 19:00:00	NQ	Futures	3177.72	3178.3	3176.85	3178.01	126.0
2012-08-15 20:00:00	NQ	Futures	3178.01	3183.23	3177.43	3180.91	680.0
2012-08-15 21:00:00	NQ	Futures	3180.91	3182.07	3179.17	3181.2	414.0
2012-08-15 22:00:00	NQ	Futures	3181.2	3186.13	3181.2	3182.94	824.0
2012-08-15 23:00:00	NQ	Futures	3183.23	3184.97	3182.36	3183.81	543.0
2012-08-15 00:00:00	YM	Futures	13030.7	13034.6	13028.7	13034.6	223.0
2012-08-15 01:00:00	YM	Futures	13031.6	13041.6	13030.7	13039.6	367.0

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

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