PREVIEW / futures_1hour / 2013-07-31

all futures 1-hour files

  file:    by_date/futures_1hour/2013/2013-07-31.parquet
  size:    50 KB
  rows:    1,530

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
2013-07-31 00:00:00	ES	Futures	1743.55	1743.55	1742.77	1743.29	1024.0
2013-07-31 01:00:00	ES	Futures	1743.03	1743.29	1742.26	1742.26	1987.0
2013-07-31 02:00:00	ES	Futures	1742.26	1742.77	1739.41	1740.96	9929.0
2013-07-31 03:00:00	ES	Futures	1740.96	1742.26	1739.15	1741.74	20402.0
2013-07-31 04:00:00	ES	Futures	1741.74	1745.1	1740.7	1744.58	18657.0
2013-07-31 05:00:00	ES	Futures	1744.58	1744.84	1742.0	1742.77	10469.0
2013-07-31 06:00:00	ES	Futures	1742.51	1744.58	1742.0	1742.51	14655.0
2013-07-31 07:00:00	ES	Futures	1742.51	1743.29	1740.96	1741.22	15500.0
2013-07-31 08:00:00	ES	Futures	1741.48	1744.06	1738.64	1742.26	71497.0
2013-07-31 09:00:00	ES	Futures	1742.26	1745.62	1740.96	1744.06	157817.0
2013-07-31 10:00:00	ES	Futures	1744.06	1750.27	1742.51	1749.49	240605.0
2013-07-31 11:00:00	ES	Futures	1749.49	1750.01	1745.87	1745.87	144034.0
2013-07-31 12:00:00	ES	Futures	1745.87	1746.13	1742.0	1742.26	107088.0
2013-07-31 13:00:00	ES	Futures	1742.26	1743.03	1741.22	1742.77	95929.0
2013-07-31 14:00:00	ES	Futures	1742.51	1751.56	1738.12	1751.56	419067.0
2013-07-31 15:00:00	ES	Futures	1751.56	1751.56	1737.34	1738.89	506776.0
2013-07-31 16:00:00	ES	Futures	1738.89	1743.81	1737.86	1743.03	125656.0
2013-07-31 17:00:00	ES	Futures	1742.77	1743.29	1742.51	1742.51	2324.0
2013-07-31 18:00:00	ES	Futures	1742.77	1743.55	1742.26	1742.51	5296.0
2013-07-31 19:00:00	ES	Futures	1742.51	1743.03	1741.74	1742.77	2809.0
2013-07-31 20:00:00	ES	Futures	1742.77	1745.36	1742.26	1745.1	7682.0
2013-07-31 21:00:00	ES	Futures	1744.84	1746.13	1744.84	1745.87	9334.0
2013-07-31 22:00:00	ES	Futures	1745.87	1746.13	1744.84	1745.36	4716.0
2013-07-31 23:00:00	ES	Futures	1745.36	1746.65	1744.06	1745.87	5841.0
2013-07-31 00:00:00	NQ	Futures	3607.94	3607.94	3606.48	3607.65	185.0
2013-07-31 01:00:00	NQ	Futures	3607.94	3607.94	3604.44	3604.73	348.0
2013-07-31 02:00:00	NQ	Futures	3604.44	3605.9	3600.05	3603.56	1167.0
2013-07-31 03:00:00	NQ	Futures	3603.56	3605.9	3599.47	3604.73	3403.0
2013-07-31 04:00:00	NQ	Futures	3605.31	3610.57	3603.27	3610.28	2605.0
2013-07-31 05:00:00	NQ	Futures	3610.57	3610.57	3605.31	3607.36	1830.0
2013-07-31 06:00:00	NQ	Futures	3607.36	3610.57	3605.9	3606.78	2025.0
2013-07-31 07:00:00	NQ	Futures	3606.78	3610.28	3605.9	3606.48	2425.0
2013-07-31 08:00:00	NQ	Futures	3606.78	3611.45	3602.68	3608.53	8645.0
2013-07-31 09:00:00	NQ	Futures	3608.53	3620.8	3606.19	3617.3	27364.0
2013-07-31 10:00:00	NQ	Futures	3617.0	3618.76	3608.82	3616.42	28217.0
2013-07-31 11:00:00	NQ	Futures	3616.42	3618.17	3611.74	3614.37	14899.0
2013-07-31 12:00:00	NQ	Futures	3614.37	3614.37	3606.48	3607.65	14642.0
2013-07-31 13:00:00	NQ	Futures	3607.94	3612.04	3605.61	3611.16	13130.0
2013-07-31 14:00:00	NQ	Futures	3611.16	3629.57	3601.81	3629.28	49469.0
2013-07-31 15:00:00	NQ	Futures	3629.28	3629.57	3602.98	3607.65	74562.0
2013-07-31 16:00:00	NQ	Futures	3607.65	3616.13	3606.48	3615.25	6864.0
2013-07-31 17:00:00	NQ	Futures	3615.25	3615.83	3614.37	3614.37	101.0
2013-07-31 18:00:00	NQ	Futures	3610.57	3614.67	3610.57	3613.2	651.0
2013-07-31 19:00:00	NQ	Futures	3613.2	3614.37	3612.04	3613.79	246.0
2013-07-31 20:00:00	NQ	Futures	3613.79	3617.59	3613.2	3617.59	1105.0
2013-07-31 21:00:00	NQ	Futures	3617.3	3619.34	3616.71	3618.76	1224.0
2013-07-31 22:00:00	NQ	Futures	3618.76	3619.34	3617.3	3618.17	613.0
2013-07-31 23:00:00	NQ	Futures	3618.17	3620.22	3615.54	3618.76	705.0
2013-07-31 00:00:00	YM	Futures	15742.0	15743.1	15738.0	15740.0	152.0
2013-07-31 01:00:00	YM	Futures	15741.0	15742.0	15729.9	15731.9	477.0

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

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