PREVIEW / futures_1hour / 2012-12-24

all futures 1-hour files

  file:    by_date/futures_1hour/2012/2012-12-24.parquet
  size:    28 KB
  rows:    771

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-24 00:00:00	ES	Futures	1456.15	1456.41	1455.64	1455.64	1202.0
2012-12-24 01:00:00	ES	Futures	1455.9	1456.41	1455.13	1455.38	1596.0
2012-12-24 02:00:00	ES	Futures	1455.38	1456.67	1455.13	1455.9	1916.0
2012-12-24 03:00:00	ES	Futures	1456.15	1456.41	1454.87	1454.87	4696.0
2012-12-24 04:00:00	ES	Futures	1455.13	1456.41	1454.87	1456.41	4317.0
2012-12-24 05:00:00	ES	Futures	1456.15	1457.18	1456.15	1456.92	1825.0
2012-12-24 06:00:00	ES	Futures	1456.92	1458.72	1456.67	1458.46	3698.0
2012-12-24 07:00:00	ES	Futures	1458.46	1458.72	1457.44	1458.46	3591.0
2012-12-24 08:00:00	ES	Futures	1458.46	1460.26	1458.21	1460.0	8602.0
2012-12-24 09:00:00	ES	Futures	1460.26	1461.29	1456.67	1456.92	69715.0
2012-12-24 10:00:00	ES	Futures	1457.18	1460.26	1456.92	1457.69	58481.0
2012-12-24 11:00:00	ES	Futures	1457.69	1458.72	1456.92	1458.21	42245.0
2012-12-24 12:00:00	ES	Futures	1458.21	1459.49	1456.41	1458.21	57219.0
2012-12-24 13:00:00	ES	Futures	1458.21	1460.52	1456.41	1456.41	26645.0
2012-12-24 00:00:00	NQ	Futures	3085.04	3086.21	3085.04	3085.91	112.0
2012-12-24 01:00:00	NQ	Futures	3085.62	3086.5	3082.71	3082.71	168.0
2012-12-24 02:00:00	NQ	Futures	3082.71	3085.33	3082.71	3084.46	275.0
2012-12-24 03:00:00	NQ	Futures	3084.75	3085.62	3081.26	3081.55	484.0
2012-12-24 04:00:00	NQ	Futures	3081.84	3085.62	3081.84	3085.62	391.0
2012-12-24 05:00:00	NQ	Futures	3085.91	3091.15	3085.62	3086.5	396.0
2012-12-24 06:00:00	NQ	Futures	3086.79	3087.66	3081.84	3084.75	629.0
2012-12-24 07:00:00	NQ	Futures	3085.04	3086.79	3083.0	3085.91	575.0
2012-12-24 08:00:00	NQ	Futures	3085.91	3093.48	3084.75	3092.9	2194.0
2012-12-24 09:00:00	NQ	Futures	3092.9	3096.1	3082.71	3086.5	12162.0
2012-12-24 10:00:00	NQ	Futures	3086.5	3093.19	3083.29	3084.75	6711.0
2012-12-24 11:00:00	NQ	Futures	3084.75	3089.41	3083.88	3087.95	4255.0
2012-12-24 12:00:00	NQ	Futures	3087.95	3089.99	3085.33	3089.12	6065.0
2012-12-24 13:00:00	NQ	Futures	3089.12	3089.99	3085.33	3085.33	2185.0
2012-12-24 00:00:00	YM	Futures	13161.8	13163.8	13156.8	13157.8	127.0
2012-12-24 01:00:00	YM	Futures	13157.8	13163.8	13149.8	13153.8	308.0
2012-12-24 02:00:00	YM	Futures	13153.8	13163.8	13149.8	13158.8	294.0
2012-12-24 03:00:00	YM	Futures	13158.8	13161.8	13150.8	13152.8	467.0
2012-12-24 04:00:00	YM	Futures	13152.8	13166.9	13152.8	13165.8	314.0
2012-12-24 05:00:00	YM	Futures	13165.8	13167.9	13159.8	13161.8	312.0
2012-12-24 06:00:00	YM	Futures	13162.8	13185.0	13162.8	13181.9	441.0
2012-12-24 07:00:00	YM	Futures	13181.9	13181.9	13171.9	13174.9	322.0
2012-12-24 08:00:00	YM	Futures	13175.9	13189.0	13175.9	13187.0	813.0
2012-12-24 09:00:00	YM	Futures	13187.0	13193.0	13150.8	13159.8	4824.0
2012-12-24 10:00:00	YM	Futures	13159.8	13185.0	13157.8	13157.8	3929.0
2012-12-24 11:00:00	YM	Futures	13158.8	13168.9	13151.8	13160.8	2972.0
2012-12-24 12:00:00	YM	Futures	13161.8	13162.8	13141.7	13152.8	3611.0
2012-12-24 13:00:00	YM	Futures	13151.8	13168.9	13138.7	13139.7	1401.0
2012-12-24 00:00:00	CL	Futures	142.11	142.16	142.08	142.16	222.0
2012-12-24 01:00:00	CL	Futures	142.16	142.23	142.11	142.16	144.0
2012-12-24 02:00:00	CL	Futures	142.16	142.19	142.11	142.18	243.0
2012-12-24 03:00:00	CL	Futures	142.15	142.18	142.03	142.11	484.0
2012-12-24 04:00:00	CL	Futures	142.13	142.23	142.05	142.18	507.0
2012-12-24 05:00:00	CL	Futures	142.16	142.5	142.15	142.5	540.0
2012-12-24 06:00:00	CL	Futures	142.5	142.55	142.21	142.31	1101.0
2012-12-24 07:00:00	CL	Futures	142.31	142.31	141.81	141.98	2018.0

> showing 50 of 771 rows — these rows as CSV

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