PREVIEW / futures_1hour / 2012-08-17

all futures 1-hour files

  file:    by_date/futures_1hour/2012/2012-08-17.parquet
  size:    39 KB
  rows:    1,161

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-17 00:00:00	ES	Futures	1436.45	1436.96	1435.94	1436.19	3375.0
2012-08-17 01:00:00	ES	Futures	1436.45	1436.96	1435.94	1435.94	3025.0
2012-08-17 02:00:00	ES	Futures	1436.19	1437.97	1435.94	1437.72	6427.0
2012-08-17 03:00:00	ES	Futures	1437.72	1438.23	1435.68	1435.94	30919.0
2012-08-17 04:00:00	ES	Futures	1435.68	1437.21	1435.43	1436.45	16912.0
2012-08-17 05:00:00	ES	Futures	1436.7	1437.97	1436.45	1436.45	18922.0
2012-08-17 06:00:00	ES	Futures	1436.45	1436.96	1435.18	1436.19	13028.0
2012-08-17 07:00:00	ES	Futures	1436.19	1436.7	1434.92	1435.68	26602.0
2012-08-17 08:00:00	ES	Futures	1435.68	1436.96	1435.18	1436.45	29975.0
2012-08-17 09:00:00	ES	Futures	1436.7	1440.77	1436.45	1439.24	218449.0
2012-08-17 10:00:00	ES	Futures	1439.24	1439.75	1436.45	1437.46	167048.0
2012-08-17 11:00:00	ES	Futures	1437.46	1439.5	1436.45	1439.24	142523.0
2012-08-17 12:00:00	ES	Futures	1439.24	1439.24	1436.7	1437.21	82031.0
2012-08-17 13:00:00	ES	Futures	1437.46	1438.74	1437.21	1437.97	43774.0
2012-08-17 14:00:00	ES	Futures	1437.97	1439.24	1437.46	1438.99	46393.0
2012-08-17 15:00:00	ES	Futures	1438.99	1441.02	1437.46	1439.75	177599.0
2012-08-17 16:00:00	ES	Futures	1439.5	1441.02	1438.99	1439.75	80350.0
2012-08-17 00:00:00	NQ	Futures	3205.26	3206.71	3204.97	3206.13	402.0
2012-08-17 01:00:00	NQ	Futures	3206.13	3207.0	3204.97	3205.55	143.0
2012-08-17 02:00:00	NQ	Futures	3205.84	3209.32	3205.84	3209.03	593.0
2012-08-17 03:00:00	NQ	Futures	3208.74	3210.77	3205.26	3207.58	2229.0
2012-08-17 04:00:00	NQ	Futures	3207.87	3211.06	3207.0	3209.9	1369.0
2012-08-17 05:00:00	NQ	Futures	3209.9	3213.37	3209.61	3209.61	1667.0
2012-08-17 06:00:00	NQ	Futures	3210.19	3210.77	3207.58	3209.61	1233.0
2012-08-17 07:00:00	NQ	Futures	3209.9	3210.19	3207.0	3207.58	1985.0
2012-08-17 08:00:00	NQ	Futures	3207.87	3211.93	3206.42	3210.77	3869.0
2012-08-17 09:00:00	NQ	Futures	3211.06	3218.88	3209.61	3218.01	37315.0
2012-08-17 10:00:00	NQ	Futures	3218.01	3219.75	3209.03	3213.66	27784.0
2012-08-17 11:00:00	NQ	Futures	3213.66	3219.75	3208.45	3219.17	16656.0
2012-08-17 12:00:00	NQ	Futures	3219.17	3220.62	3213.66	3215.11	11626.0
2012-08-17 13:00:00	NQ	Futures	3214.82	3219.17	3214.82	3216.27	7678.0
2012-08-17 14:00:00	NQ	Futures	3216.27	3220.04	3214.82	3219.17	6920.0
2012-08-17 15:00:00	NQ	Futures	3219.46	3224.1	3216.56	3223.23	19713.0
2012-08-17 16:00:00	NQ	Futures	3222.94	3223.81	3218.3	3219.75	7127.0
2012-08-17 00:00:00	YM	Futures	13145.0	13150.0	13140.0	13148.0	394.0
2012-08-17 01:00:00	YM	Futures	13149.0	13155.0	13145.0	13148.0	420.0
2012-08-17 02:00:00	YM	Futures	13149.0	13158.9	13148.0	13156.9	510.0
2012-08-17 03:00:00	YM	Futures	13156.9	13162.9	13143.0	13146.0	1801.0
2012-08-17 04:00:00	YM	Futures	13146.0	13156.9	13143.0	13152.0	1313.0
2012-08-17 05:00:00	YM	Futures	13152.0	13162.9	13150.0	13150.0	981.0
2012-08-17 06:00:00	YM	Futures	13149.0	13154.0	13142.0	13148.0	676.0
2012-08-17 07:00:00	YM	Futures	13148.0	13151.0	13139.0	13143.0	1556.0
2012-08-17 08:00:00	YM	Futures	13143.0	13153.0	13140.0	13151.0	1793.0
2012-08-17 09:00:00	YM	Futures	13151.0	13178.8	13145.0	13169.9	14713.0
2012-08-17 10:00:00	YM	Futures	13170.9	13174.8	13150.0	13156.9	11308.0
2012-08-17 11:00:00	YM	Futures	13157.9	13174.8	13151.0	13170.9	7108.0
2012-08-17 12:00:00	YM	Futures	13171.9	13172.9	13155.9	13158.9	3536.0
2012-08-17 13:00:00	YM	Futures	13158.9	13163.9	13155.0	13158.9	2186.0
2012-08-17 14:00:00	YM	Futures	13158.9	13169.9	13156.9	13167.9	2805.0
2012-08-17 15:00:00	YM	Futures	13168.9	13181.8	13156.9	13173.8	7368.0

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

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