PREVIEW / futures_1hour / 2013-09-25

all futures 1-hour files

  file:    by_date/futures_1hour/2013/2013-09-25.parquet
  size:    49 KB
  rows:    1,525

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-25 00:00:00	ES	Futures	1745.62	1746.13	1745.36	1745.88	1089.0
2013-09-25 01:00:00	ES	Futures	1746.13	1746.13	1745.62	1746.13	2523.0
2013-09-25 02:00:00	ES	Futures	1745.88	1746.39	1744.59	1744.59	6694.0
2013-09-25 03:00:00	ES	Futures	1744.84	1745.36	1742.01	1742.26	25588.0
2013-09-25 04:00:00	ES	Futures	1742.26	1745.36	1740.97	1745.1	20090.0
2013-09-25 05:00:00	ES	Futures	1744.84	1747.42	1744.59	1746.13	19492.0
2013-09-25 06:00:00	ES	Futures	1746.39	1746.65	1742.78	1743.3	18181.0
2013-09-25 07:00:00	ES	Futures	1743.3	1744.84	1742.26	1744.84	24625.0
2013-09-25 08:00:00	ES	Futures	1744.84	1747.42	1743.3	1746.39	38995.0
2013-09-25 09:00:00	ES	Futures	1746.39	1747.68	1739.69	1742.52	215064.0
2013-09-25 10:00:00	ES	Futures	1742.78	1745.62	1738.14	1743.3	298737.0
2013-09-25 11:00:00	ES	Futures	1743.55	1748.97	1741.75	1747.94	172937.0
2013-09-25 12:00:00	ES	Futures	1748.2	1748.46	1743.04	1745.88	139413.0
2013-09-25 13:00:00	ES	Futures	1745.88	1747.17	1738.4	1742.01	205697.0
2013-09-25 14:00:00	ES	Futures	1742.01	1743.55	1739.69	1741.23	156239.0
2013-09-25 15:00:00	ES	Futures	1741.49	1744.84	1739.69	1740.46	201146.0
2013-09-25 16:00:00	ES	Futures	1740.2	1741.49	1739.17	1739.94	65742.0
2013-09-25 17:00:00	ES	Futures	1739.94	1740.46	1739.94	1739.94	1333.0
2013-09-25 18:00:00	ES	Futures	1740.2	1742.01	1740.2	1741.23	2515.0
2013-09-25 19:00:00	ES	Futures	1741.23	1741.75	1740.72	1740.97	1832.0
2013-09-25 20:00:00	ES	Futures	1740.72	1741.75	1740.2	1740.97	3576.0
2013-09-25 21:00:00	ES	Futures	1740.97	1741.75	1740.46	1740.97	2682.0
2013-09-25 22:00:00	ES	Futures	1740.72	1743.04	1740.46	1742.52	5890.0
2013-09-25 23:00:00	ES	Futures	1742.52	1743.04	1742.26	1742.52	2528.0
2013-09-25 00:00:00	NQ	Futures	3735.83	3737.58	3735.83	3737.29	144.0
2013-09-25 01:00:00	NQ	Futures	3737.29	3737.58	3736.41	3737.0	286.0
2013-09-25 02:00:00	NQ	Futures	3737.29	3737.29	3732.35	3733.22	681.0
2013-09-25 03:00:00	NQ	Futures	3733.51	3734.96	3725.96	3727.7	3382.0
2013-09-25 04:00:00	NQ	Futures	3727.41	3734.09	3723.64	3732.93	2676.0
2013-09-25 05:00:00	NQ	Futures	3732.93	3739.9	3732.64	3737.0	2285.0
2013-09-25 06:00:00	NQ	Futures	3737.0	3737.0	3728.28	3729.73	2513.0
2013-09-25 07:00:00	NQ	Futures	3729.73	3732.06	3725.96	3731.77	5666.0
2013-09-25 08:00:00	NQ	Futures	3732.35	3738.74	3729.73	3736.12	4730.0
2013-09-25 09:00:00	NQ	Futures	3736.41	3738.74	3719.28	3721.02	35295.0
2013-09-25 10:00:00	NQ	Futures	3721.31	3733.8	3712.6	3727.41	58333.0
2013-09-25 11:00:00	NQ	Futures	3727.7	3739.9	3723.34	3738.16	23018.0
2013-09-25 12:00:00	NQ	Futures	3738.16	3741.35	3727.7	3734.09	19291.0
2013-09-25 13:00:00	NQ	Futures	3734.38	3737.87	3716.37	3724.51	29292.0
2013-09-25 14:00:00	NQ	Futures	3724.51	3727.12	3719.57	3722.18	29468.0
2013-09-25 15:00:00	NQ	Futures	3722.18	3730.02	3719.57	3721.02	26162.0
2013-09-25 16:00:00	NQ	Futures	3721.02	3723.34	3718.41	3719.57	4473.0
2013-09-25 17:00:00	NQ	Futures	3719.57	3720.73	3719.28	3720.73	84.0
2013-09-25 18:00:00	NQ	Futures	3720.44	3724.51	3720.15	3722.47	422.0
2013-09-25 19:00:00	NQ	Futures	3722.76	3724.22	3721.6	3721.89	243.0
2013-09-25 20:00:00	NQ	Futures	3722.18	3723.64	3720.73	3722.76	492.0
2013-09-25 21:00:00	NQ	Futures	3723.05	3724.22	3722.18	3723.34	548.0
2013-09-25 22:00:00	NQ	Futures	3723.34	3729.15	3723.05	3727.99	907.0
2013-09-25 23:00:00	NQ	Futures	3727.7	3728.86	3727.41	3728.28	328.0
2013-09-25 00:00:00	YM	Futures	15608.7	15611.8	15607.7	15610.8	117.0
2013-09-25 01:00:00	YM	Futures	15611.8	15612.8	15607.7	15610.8	405.0

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

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