PREVIEW / futures_1hour / 2013-08-07

all futures 1-hour files

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

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-08-07 00:00:00	ES	Futures	1747.94	1748.46	1747.17	1747.42	2703.0
2013-08-07 01:00:00	ES	Futures	1747.42	1747.68	1744.58	1744.84	11014.0
2013-08-07 02:00:00	ES	Futures	1744.58	1746.39	1744.58	1745.62	8334.0
2013-08-07 03:00:00	ES	Futures	1745.36	1745.87	1742.77	1743.55	25180.0
2013-08-07 04:00:00	ES	Futures	1743.29	1746.39	1742.51	1745.62	18994.0
2013-08-07 05:00:00	ES	Futures	1745.87	1746.91	1742.77	1743.55	24209.0
2013-08-07 06:00:00	ES	Futures	1743.55	1746.39	1742.51	1744.84	22923.0
2013-08-07 07:00:00	ES	Futures	1744.84	1746.91	1744.58	1746.39	20457.0
2013-08-07 08:00:00	ES	Futures	1746.65	1747.42	1746.13	1746.91	19615.0
2013-08-07 09:00:00	ES	Futures	1747.17	1747.17	1740.96	1741.22	260894.0
2013-08-07 10:00:00	ES	Futures	1741.22	1741.48	1737.6	1740.96	274339.0
2013-08-07 11:00:00	ES	Futures	1740.96	1742.0	1738.64	1740.7	135105.0
2013-08-07 12:00:00	ES	Futures	1740.7	1744.32	1739.93	1744.06	105490.0
2013-08-07 13:00:00	ES	Futures	1744.32	1745.62	1743.29	1744.84	103392.0
2013-08-07 14:00:00	ES	Futures	1744.84	1745.36	1742.51	1744.58	95196.0
2013-08-07 15:00:00	ES	Futures	1744.58	1746.91	1743.81	1744.84	177115.0
2013-08-07 16:00:00	ES	Futures	1744.84	1746.39	1744.32	1746.39	50974.0
2013-08-07 17:00:00	ES	Futures	1746.65	1746.65	1746.13	1746.13	1275.0
2013-08-07 18:00:00	ES	Futures	1746.13	1746.13	1745.36	1745.87	3515.0
2013-08-07 19:00:00	ES	Futures	1745.87	1747.17	1745.1	1746.91	2820.0
2013-08-07 20:00:00	ES	Futures	1747.17	1750.01	1746.91	1749.49	12035.0
2013-08-07 21:00:00	ES	Futures	1749.49	1750.79	1748.98	1748.98	5883.0
2013-08-07 22:00:00	ES	Futures	1749.23	1750.27	1748.72	1749.23	2341.0
2013-08-07 23:00:00	ES	Futures	1748.98	1752.08	1748.72	1751.04	11845.0
2013-08-07 00:00:00	NQ	Futures	3641.26	3642.14	3639.8	3639.8	328.0
2013-08-07 01:00:00	NQ	Futures	3640.38	3640.97	3635.12	3635.12	1319.0
2013-08-07 02:00:00	NQ	Futures	3635.41	3639.21	3635.12	3637.75	918.0
2013-08-07 03:00:00	NQ	Futures	3637.46	3638.04	3631.03	3632.2	4385.0
2013-08-07 04:00:00	NQ	Futures	3631.91	3636.58	3630.15	3636.29	2345.0
2013-08-07 05:00:00	NQ	Futures	3636.29	3638.63	3631.03	3632.2	3405.0
2013-08-07 06:00:00	NQ	Futures	3632.49	3636.58	3629.86	3634.25	3310.0
2013-08-07 07:00:00	NQ	Futures	3634.25	3637.46	3633.95	3637.17	2889.0
2013-08-07 08:00:00	NQ	Futures	3637.17	3641.84	3636.88	3640.97	3599.0
2013-08-07 09:00:00	NQ	Futures	3640.97	3646.52	3629.28	3630.45	35612.0
2013-08-07 10:00:00	NQ	Futures	3630.74	3630.74	3612.91	3622.56	62186.0
2013-08-07 11:00:00	NQ	Futures	3622.56	3625.48	3616.42	3620.22	20101.0
2013-08-07 12:00:00	NQ	Futures	3620.22	3633.37	3619.05	3632.78	18253.0
2013-08-07 13:00:00	NQ	Futures	3633.08	3638.04	3632.2	3636.58	13338.0
2013-08-07 14:00:00	NQ	Futures	3636.58	3640.67	3633.08	3639.21	20017.0
2013-08-07 15:00:00	NQ	Futures	3639.21	3643.6	3638.04	3639.8	28517.0
2013-08-07 16:00:00	NQ	Futures	3639.8	3645.06	3639.51	3645.06	4880.0
2013-08-07 17:00:00	NQ	Futures	3644.47	3645.35	3643.89	3645.06	249.0
2013-08-07 18:00:00	NQ	Futures	3643.89	3645.06	3642.43	3644.77	502.0
2013-08-07 19:00:00	NQ	Futures	3645.06	3647.69	3643.3	3647.4	641.0
2013-08-07 20:00:00	NQ	Futures	3647.4	3652.36	3647.1	3652.07	1539.0
2013-08-07 21:00:00	NQ	Futures	3652.07	3653.24	3650.03	3650.32	976.0
2013-08-07 22:00:00	NQ	Futures	3650.32	3652.36	3650.03	3651.19	408.0
2013-08-07 23:00:00	NQ	Futures	3651.19	3655.87	3650.32	3654.7	1334.0
2013-08-07 00:00:00	YM	Futures	15681.1	15686.2	15670.9	15673.0	383.0
2013-08-07 01:00:00	YM	Futures	15674.0	15676.0	15654.7	15654.7	1287.0

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

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