PREVIEW / futures_1hour / 2013-09-11

all futures 1-hour files

  file:    by_date/futures_1hour/2013/2013-09-11.parquet
  size:    46 KB
  rows:    1,444

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-09-11 00:00:00	ES	Futures	1738.38	1738.89	1737.6	1737.86	1899.0
2013-09-11 01:00:00	ES	Futures	1737.86	1738.89	1737.6	1738.64	2957.0
2013-09-11 02:00:00	ES	Futures	1738.64	1738.89	1736.83	1737.6	5586.0
2013-09-11 03:00:00	ES	Futures	1737.6	1739.67	1736.83	1737.6	18773.0
2013-09-11 04:00:00	ES	Futures	1737.6	1740.7	1737.6	1740.45	16434.0
2013-09-11 05:00:00	ES	Futures	1740.19	1740.45	1737.6	1737.86	10965.0
2013-09-11 06:00:00	ES	Futures	1737.86	1740.19	1737.6	1739.41	14762.0
2013-09-11 07:00:00	ES	Futures	1739.15	1740.19	1736.83	1737.34	21325.0
2013-09-11 08:00:00	ES	Futures	1737.6	1738.89	1737.34	1738.38	24361.0
2013-09-11 09:00:00	ES	Futures	1738.12	1739.93	1735.53	1736.57	203175.0
2013-09-11 10:00:00	ES	Futures	1736.57	1738.64	1734.76	1737.09	264158.0
2013-09-11 11:00:00	ES	Futures	1737.34	1743.03	1737.09	1741.74	246969.0
2013-09-11 12:00:00	ES	Futures	1742.0	1743.55	1740.7	1743.29	186189.0
2013-09-11 13:00:00	ES	Futures	1743.03	1744.84	1742.0	1744.32	140188.0
2013-09-11 14:00:00	ES	Futures	1744.06	1745.1	1742.26	1742.77	123229.0
2013-09-11 15:00:00	ES	Futures	1742.77	1745.87	1741.48	1745.87	184203.0
2013-09-11 16:00:00	ES	Futures	1745.87	1747.42	1744.84	1747.42	72450.0
2013-09-11 17:00:00	ES	Futures	1747.17	1747.94	1747.17	1747.68	3977.0
2013-09-11 18:00:00	ES	Futures	1747.17	1747.42	1746.13	1746.65	3700.0
2013-09-11 19:00:00	ES	Futures	1746.65	1746.91	1745.62	1746.13	4406.0
2013-09-11 20:00:00	ES	Futures	1745.87	1746.91	1744.84	1745.1	8080.0
2013-09-11 21:00:00	ES	Futures	1745.36	1747.42	1744.58	1744.58	9105.0
2013-09-11 22:00:00	ES	Futures	1744.58	1745.87	1744.58	1745.36	3474.0
2013-09-11 23:00:00	ES	Futures	1745.36	1745.87	1744.84	1745.62	1716.0
2013-09-11 00:00:00	NQ	Futures	3719.58	3720.45	3716.95	3717.24	559.0
2013-09-11 01:00:00	NQ	Futures	3717.53	3718.99	3716.95	3718.12	262.0
2013-09-11 02:00:00	NQ	Futures	3718.12	3718.7	3712.86	3713.15	2027.0
2013-09-11 03:00:00	NQ	Futures	3713.15	3717.82	3712.27	3713.44	4345.0
2013-09-11 04:00:00	NQ	Futures	3713.73	3717.82	3711.98	3716.36	2717.0
2013-09-11 05:00:00	NQ	Futures	3716.66	3716.95	3711.69	3712.27	1646.0
2013-09-11 06:00:00	NQ	Futures	3712.27	3714.9	3711.1	3713.15	2193.0
2013-09-11 07:00:00	NQ	Futures	3712.86	3714.32	3702.34	3704.38	6022.0
2013-09-11 08:00:00	NQ	Futures	3704.38	3708.18	3704.09	3705.84	5098.0
2013-09-11 09:00:00	NQ	Futures	3705.55	3709.93	3697.08	3698.54	41602.0
2013-09-11 10:00:00	NQ	Futures	3698.54	3707.01	3693.86	3700.58	35359.0
2013-09-11 11:00:00	NQ	Futures	3700.87	3711.1	3699.71	3708.47	22886.0
2013-09-11 12:00:00	NQ	Futures	3708.47	3714.03	3707.01	3712.56	15405.0
2013-09-11 13:00:00	NQ	Futures	3712.86	3717.24	3708.77	3714.9	13804.0
2013-09-11 14:00:00	NQ	Futures	3714.9	3718.12	3711.1	3714.32	13111.0
2013-09-11 15:00:00	NQ	Futures	3714.32	3717.24	3709.06	3716.95	19330.0
2013-09-11 16:00:00	NQ	Futures	3717.24	3721.92	3714.32	3721.92	4335.0
2013-09-11 17:00:00	NQ	Futures	3721.62	3724.55	3721.62	3722.5	333.0
2013-09-11 18:00:00	NQ	Futures	3722.21	3722.5	3719.58	3719.58	503.0
2013-09-11 19:00:00	NQ	Futures	3719.87	3719.87	3717.24	3717.24	454.0
2013-09-11 20:00:00	NQ	Futures	3717.24	3719.58	3716.36	3716.66	527.0
2013-09-11 21:00:00	NQ	Futures	3716.66	3721.04	3716.36	3716.66	642.0
2013-09-11 22:00:00	NQ	Futures	3716.36	3718.7	3716.36	3717.53	332.0
2013-09-11 23:00:00	NQ	Futures	3717.82	3718.41	3716.66	3717.82	212.0
2013-09-11 00:00:00	YM	Futures	15420.8	15423.9	15418.8	15419.8	18.0
2013-09-11 01:00:00	YM	Futures	15421.9	15423.9	15415.7	15420.8	127.0

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

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