PREVIEW / futures_1hour / 2013-09-24

all futures 1-hour files

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

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-24 00:00:00	ES	Futures	1743.81	1744.07	1743.55	1744.07	1605.0
2013-09-24 01:00:00	ES	Futures	1743.81	1745.36	1743.81	1745.36	3376.0
2013-09-24 02:00:00	ES	Futures	1745.1	1746.39	1745.1	1745.62	5717.0
2013-09-24 03:00:00	ES	Futures	1745.62	1747.68	1745.36	1746.13	24743.0
2013-09-24 04:00:00	ES	Futures	1746.13	1746.91	1744.07	1746.65	22032.0
2013-09-24 05:00:00	ES	Futures	1746.39	1747.42	1743.81	1744.59	17393.0
2013-09-24 06:00:00	ES	Futures	1744.84	1746.65	1744.07	1745.62	11757.0
2013-09-24 07:00:00	ES	Futures	1745.62	1747.17	1743.55	1743.81	30457.0
2013-09-24 08:00:00	ES	Futures	1744.07	1747.42	1743.81	1747.17	27517.0
2013-09-24 09:00:00	ES	Futures	1747.42	1749.23	1745.1	1745.88	202773.0
2013-09-24 10:00:00	ES	Futures	1745.88	1751.29	1741.23	1750.26	343630.0
2013-09-24 11:00:00	ES	Futures	1750.0	1752.58	1750.0	1751.81	157521.0
2013-09-24 12:00:00	ES	Futures	1751.81	1754.13	1750.26	1752.84	110823.0
2013-09-24 13:00:00	ES	Futures	1752.84	1755.16	1752.33	1753.1	90640.0
2013-09-24 14:00:00	ES	Futures	1753.36	1753.87	1750.52	1750.52	108026.0
2013-09-24 15:00:00	ES	Futures	1750.52	1751.55	1743.04	1745.1	240171.0
2013-09-24 16:00:00	ES	Futures	1744.84	1746.65	1744.33	1746.13	74833.0
2013-09-24 17:00:00	ES	Futures	1746.39	1746.65	1745.88	1746.13	1282.0
2013-09-24 18:00:00	ES	Futures	1746.13	1746.39	1744.84	1744.84	5694.0
2013-09-24 19:00:00	ES	Futures	1744.84	1745.62	1744.59	1745.1	3570.0
2013-09-24 20:00:00	ES	Futures	1745.1	1745.88	1744.84	1745.62	5424.0
2013-09-24 21:00:00	ES	Futures	1745.62	1746.65	1745.62	1746.65	4480.0
2013-09-24 22:00:00	ES	Futures	1746.65	1746.91	1745.88	1746.13	3460.0
2013-09-24 23:00:00	ES	Futures	1746.39	1746.39	1745.36	1745.62	2217.0
2013-09-24 00:00:00	NQ	Futures	3725.38	3726.83	3725.09	3726.25	245.0
2013-09-24 01:00:00	NQ	Futures	3726.25	3729.73	3725.67	3729.15	536.0
2013-09-24 02:00:00	NQ	Futures	3729.44	3732.06	3729.44	3730.02	655.0
2013-09-24 03:00:00	NQ	Futures	3730.02	3734.96	3729.15	3731.77	2775.0
2013-09-24 04:00:00	NQ	Futures	3731.77	3734.67	3727.41	3734.09	2418.0
2013-09-24 05:00:00	NQ	Futures	3733.8	3735.83	3728.86	3730.61	1538.0
2013-09-24 06:00:00	NQ	Futures	3730.61	3734.67	3729.73	3733.22	1234.0
2013-09-24 07:00:00	NQ	Futures	3732.93	3735.25	3728.86	3729.44	2283.0
2013-09-24 08:00:00	NQ	Futures	3729.44	3736.7	3729.15	3736.7	3611.0
2013-09-24 09:00:00	NQ	Futures	3736.7	3741.93	3732.64	3732.64	24169.0
2013-09-24 10:00:00	NQ	Futures	3733.22	3748.61	3720.73	3746.0	44309.0
2013-09-24 11:00:00	NQ	Futures	3746.0	3750.06	3742.22	3745.42	20110.0
2013-09-24 12:00:00	NQ	Futures	3745.42	3748.9	3741.93	3746.0	11019.0
2013-09-24 13:00:00	NQ	Futures	3746.0	3753.26	3744.55	3748.9	11443.0
2013-09-24 14:00:00	NQ	Futures	3748.9	3750.06	3741.93	3743.09	12884.0
2013-09-24 15:00:00	NQ	Futures	3743.09	3744.84	3726.25	3732.64	31850.0
2013-09-24 16:00:00	NQ	Futures	3732.64	3734.96	3732.06	3734.09	4756.0
2013-09-24 17:00:00	NQ	Futures	3734.09	3734.96	3734.09	3734.67	62.0
2013-09-24 18:00:00	NQ	Futures	3735.25	3735.25	3732.06	3732.64	355.0
2013-09-24 19:00:00	NQ	Futures	3732.93	3733.8	3732.64	3733.51	181.0
2013-09-24 20:00:00	NQ	Futures	3732.93	3736.41	3732.93	3735.25	554.0
2013-09-24 21:00:00	NQ	Futures	3735.54	3738.16	3735.54	3737.87	590.0
2013-09-24 22:00:00	NQ	Futures	3738.16	3738.16	3735.83	3737.58	358.0
2013-09-24 23:00:00	NQ	Futures	3737.58	3737.87	3735.54	3735.83	298.0
2013-09-24 00:00:00	YM	Futures	15637.3	15639.4	15636.3	15639.4	162.0
2013-09-24 01:00:00	YM	Futures	15638.4	15650.6	15638.4	15649.6	899.0

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

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