PREVIEW / futures_1hour / 2012-09-12

all futures 1-hour files

  file:    by_date/futures_1hour/2012/2012-09-12.parquet
  size:    45 KB
  rows:    1,388

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-09-12 00:00:00	ES	Futures	1456.79	1458.82	1456.28	1458.57	3992.0
2012-09-12 01:00:00	ES	Futures	1458.82	1458.82	1457.04	1457.3	4116.0
2012-09-12 02:00:00	ES	Futures	1457.55	1459.59	1457.3	1459.08	7768.0
2012-09-12 03:00:00	ES	Futures	1459.08	1459.59	1456.54	1458.57	28650.0
2012-09-12 04:00:00	ES	Futures	1458.82	1464.42	1455.52	1462.13	146680.0
2012-09-12 05:00:00	ES	Futures	1462.13	1463.91	1461.37	1463.4	33245.0
2012-09-12 06:00:00	ES	Futures	1463.4	1463.66	1460.86	1461.11	16773.0
2012-09-12 07:00:00	ES	Futures	1461.11	1462.64	1459.33	1460.35	34039.0
2012-09-12 08:00:00	ES	Futures	1460.35	1461.37	1459.08	1460.6	37568.0
2012-09-12 09:00:00	ES	Futures	1460.6	1463.66	1459.59	1461.88	163433.0
2012-09-12 10:00:00	ES	Futures	1461.88	1463.15	1457.55	1459.84	278026.0
2012-09-12 11:00:00	ES	Futures	1460.1	1462.64	1459.84	1460.86	143450.0
2012-09-12 12:00:00	ES	Futures	1461.11	1461.62	1459.59	1461.62	69244.0
2012-09-12 13:00:00	ES	Futures	1461.37	1463.66	1460.86	1461.88	139439.0
2012-09-12 14:00:00	ES	Futures	1461.62	1462.38	1459.08	1459.84	106810.0
2012-09-12 15:00:00	ES	Futures	1459.59	1461.62	1457.04	1461.37	156760.0
2012-09-12 16:00:00	ES	Futures	1461.62	1464.93	1461.37	1462.64	92263.0
2012-09-12 17:00:00	ES	Futures	1462.64	1463.91	1462.64	1463.15	1848.0
2012-09-12 18:00:00	ES	Futures	1463.15	1464.16	1463.15	1463.91	2595.0
2012-09-12 19:00:00	ES	Futures	1463.91	1463.91	1462.89	1462.89	1414.0
2012-09-12 20:00:00	ES	Futures	1462.89	1463.15	1462.13	1462.64	4142.0
2012-09-12 21:00:00	ES	Futures	1462.64	1463.66	1462.13	1463.66	2576.0
2012-09-12 22:00:00	ES	Futures	1463.66	1464.16	1462.38	1462.38	2232.0
2012-09-12 23:00:00	ES	Futures	1462.64	1462.89	1462.13	1462.38	1830.0
2012-09-12 00:00:00	NQ	Futures	3230.77	3234.83	3228.45	3234.54	647.0
2012-09-12 01:00:00	NQ	Futures	3234.25	3234.83	3230.48	3231.93	375.0
2012-09-12 02:00:00	NQ	Futures	3231.64	3235.7	3231.35	3234.25	719.0
2012-09-12 03:00:00	NQ	Futures	3234.25	3236.28	3225.84	3230.77	3284.0
2012-09-12 04:00:00	NQ	Futures	3230.19	3244.68	3222.65	3240.91	11745.0
2012-09-12 05:00:00	NQ	Futures	3241.2	3247.0	3240.91	3245.55	2667.0
2012-09-12 06:00:00	NQ	Futures	3245.84	3247.0	3240.33	3241.2	1446.0
2012-09-12 07:00:00	NQ	Futures	3241.2	3241.78	3235.7	3236.57	2515.0
2012-09-12 08:00:00	NQ	Futures	3236.86	3241.2	3235.7	3239.46	3692.0
2012-09-12 09:00:00	NQ	Futures	3239.17	3246.13	3233.67	3235.99	25458.0
2012-09-12 10:00:00	NQ	Futures	3236.28	3238.59	3223.81	3230.48	34344.0
2012-09-12 11:00:00	NQ	Futures	3230.19	3235.41	3226.13	3232.8	20096.0
2012-09-12 12:00:00	NQ	Futures	3233.09	3234.83	3226.42	3233.96	10438.0
2012-09-12 13:00:00	NQ	Futures	3233.67	3243.23	3228.74	3236.28	35583.0
2012-09-12 14:00:00	NQ	Futures	3236.57	3240.04	3226.13	3226.71	22620.0
2012-09-12 15:00:00	NQ	Futures	3226.71	3238.02	3218.01	3238.02	36403.0
2012-09-12 16:00:00	NQ	Futures	3238.02	3244.97	3238.02	3241.2	7624.0
2012-09-12 17:00:00	NQ	Futures	3241.49	3242.94	3241.49	3242.07	114.0
2012-09-12 18:00:00	NQ	Futures	3242.07	3243.23	3240.62	3242.36	188.0
2012-09-12 19:00:00	NQ	Futures	3242.07	3242.36	3239.75	3239.75	150.0
2012-09-12 20:00:00	NQ	Futures	3239.75	3240.62	3238.88	3239.46	268.0
2012-09-12 21:00:00	NQ	Futures	3239.46	3242.36	3238.02	3242.07	493.0
2012-09-12 22:00:00	NQ	Futures	3242.36	3243.81	3239.75	3239.75	328.0
2012-09-12 23:00:00	NQ	Futures	3240.33	3240.33	3238.88	3239.75	222.0
2012-09-12 00:00:00	YM	Futures	13243.8	13262.8	13243.8	13262.8	21.0
2012-09-12 01:00:00	YM	Futures	13258.8	13261.8	13248.8	13248.8	18.0

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

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