PREVIEW / futures_1hour / 2013-08-09

all futures 1-hour files

  file:    by_date/futures_1hour/2013/2013-08-09.parquet
  size:    41 KB
  rows:    1,241

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-09 00:00:00	ES	Futures	1750.27	1750.53	1749.49	1750.01	1895.0
2013-08-09 01:00:00	ES	Futures	1750.01	1751.82	1749.75	1751.04	4407.0
2013-08-09 02:00:00	ES	Futures	1751.3	1752.34	1751.3	1751.56	4235.0
2013-08-09 03:00:00	ES	Futures	1751.82	1752.08	1747.94	1749.23	16344.0
2013-08-09 04:00:00	ES	Futures	1749.23	1749.49	1745.87	1746.65	16157.0
2013-08-09 05:00:00	ES	Futures	1746.91	1747.94	1745.62	1745.62	10981.0
2013-08-09 06:00:00	ES	Futures	1745.62	1745.87	1743.55	1745.36	20721.0
2013-08-09 07:00:00	ES	Futures	1745.1	1747.42	1744.84	1747.17	14943.0
2013-08-09 08:00:00	ES	Futures	1747.42	1747.42	1744.84	1746.13	29272.0
2013-08-09 09:00:00	ES	Futures	1746.39	1753.89	1745.87	1752.59	216268.0
2013-08-09 10:00:00	ES	Futures	1752.34	1753.11	1745.62	1746.39	298204.0
2013-08-09 11:00:00	ES	Futures	1746.13	1746.39	1739.67	1744.06	309854.0
2013-08-09 12:00:00	ES	Futures	1743.81	1748.46	1742.51	1746.65	152727.0
2013-08-09 13:00:00	ES	Futures	1746.65	1749.75	1746.13	1748.2	110541.0
2013-08-09 14:00:00	ES	Futures	1747.94	1748.98	1745.1	1747.17	153293.0
2013-08-09 15:00:00	ES	Futures	1747.17	1748.2	1744.06	1745.87	190677.0
2013-08-09 16:00:00	ES	Futures	1745.87	1746.13	1742.77	1742.77	84177.0
2013-08-09 17:00:00	ES	Futures	1742.77	1743.03	1742.26	1742.26	1926.0
2013-08-09 00:00:00	NQ	Futures	3654.99	3656.16	3653.53	3654.41	400.0
2013-08-09 01:00:00	NQ	Futures	3654.41	3658.21	3654.41	3657.04	724.0
2013-08-09 02:00:00	NQ	Futures	3657.33	3659.67	3657.33	3658.21	404.0
2013-08-09 03:00:00	NQ	Futures	3658.5	3658.5	3649.73	3652.07	3495.0
2013-08-09 04:00:00	NQ	Futures	3652.07	3652.07	3644.77	3647.69	3134.0
2013-08-09 05:00:00	NQ	Futures	3647.98	3652.07	3647.98	3648.86	1974.0
2013-08-09 06:00:00	NQ	Futures	3648.86	3649.15	3645.06	3648.86	1814.0
2013-08-09 07:00:00	NQ	Futures	3649.15	3652.36	3648.27	3652.36	1618.0
2013-08-09 08:00:00	NQ	Futures	3652.36	3653.53	3649.73	3650.9	3764.0
2013-08-09 09:00:00	NQ	Futures	3651.19	3664.35	3649.15	3661.42	23550.0
2013-08-09 10:00:00	NQ	Futures	3661.13	3663.18	3646.81	3648.86	36578.0
2013-08-09 11:00:00	NQ	Futures	3648.86	3648.86	3631.91	3642.43	36104.0
2013-08-09 12:00:00	NQ	Futures	3642.14	3655.29	3641.55	3650.32	20929.0
2013-08-09 13:00:00	NQ	Futures	3650.32	3654.7	3647.69	3650.32	13609.0
2013-08-09 14:00:00	NQ	Futures	3650.03	3651.49	3642.43	3645.93	22623.0
2013-08-09 15:00:00	NQ	Futures	3645.93	3647.69	3639.51	3643.01	18990.0
2013-08-09 16:00:00	NQ	Futures	3643.01	3644.77	3639.51	3639.51	5114.0
2013-08-09 17:00:00	NQ	Futures	3639.8	3639.8	3638.63	3638.63	280.0
2013-08-09 00:00:00	YM	Futures	15683.1	15686.2	15677.0	15680.1	452.0
2013-08-09 01:00:00	YM	Futures	15683.1	15697.4	15683.1	15693.3	547.0
2013-08-09 02:00:00	YM	Futures	15694.3	15705.5	15693.3	15697.4	579.0
2013-08-09 03:00:00	YM	Futures	15697.4	15699.4	15665.9	15679.1	1869.0
2013-08-09 04:00:00	YM	Futures	15679.1	15680.1	15646.6	15656.7	1857.0
2013-08-09 05:00:00	YM	Futures	15655.7	15664.9	15649.6	15650.6	1070.0
2013-08-09 06:00:00	YM	Futures	15650.6	15650.6	15633.4	15646.6	2452.0
2013-08-09 07:00:00	YM	Futures	15646.6	15658.8	15643.5	15658.8	1075.0
2013-08-09 08:00:00	YM	Futures	15659.8	15663.8	15636.4	15644.5	2672.0
2013-08-09 09:00:00	YM	Futures	15644.5	15714.6	15642.5	15704.5	15874.0
2013-08-09 10:00:00	YM	Futures	15704.5	15711.6	15623.2	15628.3	23656.0
2013-08-09 11:00:00	YM	Futures	15628.3	15628.3	15545.0	15580.6	33131.0
2013-08-09 12:00:00	YM	Futures	15580.6	15622.2	15569.4	15607.0	12600.0
2013-08-09 13:00:00	YM	Futures	15608.0	15650.6	15605.9	15641.5	11251.0

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

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