PREVIEW / futures_1hour / 2013-12-20

all futures 1-hour files

  file:    by_date/futures_1hour/2013/2013-12-20.parquet
  size:    43 KB
  rows:    1,277

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-12-20 00:00:00	ES	Futures	1867.74	1867.74	1866.96	1866.96	1687.0
2013-12-20 01:00:00	ES	Futures	1867.22	1867.48	1866.18	1866.96	2753.0
2013-12-20 02:00:00	ES	Futures	1866.7	1867.99	1866.44	1867.22	5093.0
2013-12-20 03:00:00	ES	Futures	1867.22	1867.74	1864.89	1866.96	15174.0
2013-12-20 04:00:00	ES	Futures	1866.96	1869.29	1866.44	1868.25	11857.0
2013-12-20 05:00:00	ES	Futures	1867.99	1868.77	1866.44	1866.7	11031.0
2013-12-20 06:00:00	ES	Futures	1866.96	1867.99	1866.18	1866.44	10941.0
2013-12-20 07:00:00	ES	Futures	1866.44	1866.7	1864.89	1866.18	18402.0
2013-12-20 08:00:00	ES	Futures	1866.18	1869.03	1865.41	1868.25	40265.0
2013-12-20 09:00:00	ES	Futures	1868.25	1874.72	1866.7	1873.68	236826.0
2013-12-20 10:00:00	ES	Futures	1873.68	1876.01	1871.36	1873.94	143392.0
2013-12-20 11:00:00	ES	Futures	1873.94	1878.6	1873.43	1878.08	158056.0
2013-12-20 12:00:00	ES	Futures	1878.08	1879.89	1876.79	1878.34	100355.0
2013-12-20 13:00:00	ES	Futures	1878.6	1880.41	1877.82	1880.15	70706.0
2013-12-20 14:00:00	ES	Futures	1880.15	1880.67	1878.86	1879.63	75849.0
2013-12-20 15:00:00	ES	Futures	1879.89	1879.89	1875.24	1876.01	257553.0
2013-12-20 16:00:00	ES	Futures	1876.01	1879.63	1875.49	1879.37	132751.0
2013-12-20 17:00:00	ES	Futures	1879.37	1880.93	1879.12	1880.15	7308.0
2013-12-20 00:00:00	NQ	Futures	4069.0	4069.3	4068.13	4069.3	222.0
2013-12-20 01:00:00	NQ	Futures	4069.0	4069.3	4067.55	4068.13	196.0
2013-12-20 02:00:00	NQ	Futures	4068.13	4069.59	4067.55	4069.0	443.0
2013-12-20 03:00:00	NQ	Futures	4069.0	4069.3	4062.61	4067.26	1907.0
2013-12-20 04:00:00	NQ	Futures	4067.26	4072.2	4066.97	4069.88	948.0
2013-12-20 05:00:00	NQ	Futures	4069.59	4071.33	4065.81	4067.26	1365.0
2013-12-20 06:00:00	NQ	Futures	4067.55	4070.17	4066.68	4067.55	886.0
2013-12-20 07:00:00	NQ	Futures	4067.55	4067.84	4064.94	4067.26	1368.0
2013-12-20 08:00:00	NQ	Futures	4067.26	4071.62	4064.94	4071.62	3354.0
2013-12-20 09:00:00	NQ	Futures	4071.33	4087.61	4066.1	4084.12	32389.0
2013-12-20 10:00:00	NQ	Futures	4083.83	4096.62	4080.92	4094.59	27950.0
2013-12-20 11:00:00	NQ	Futures	4094.29	4105.63	4092.84	4104.76	22804.0
2013-12-20 12:00:00	NQ	Futures	4104.76	4109.12	4101.85	4105.63	17365.0
2013-12-20 13:00:00	NQ	Futures	4105.63	4109.12	4103.6	4108.25	10068.0
2013-12-20 14:00:00	NQ	Futures	4108.54	4112.9	4107.08	4110.57	11183.0
2013-12-20 15:00:00	NQ	Futures	4110.57	4110.86	4102.14	4102.72	30556.0
2013-12-20 16:00:00	NQ	Futures	4102.43	4108.83	4101.27	4108.25	6254.0
2013-12-20 17:00:00	NQ	Futures	4108.25	4112.61	4107.96	4112.32	296.0
2013-12-20 00:00:00	YM	Futures	16541.8	16542.8	16538.7	16541.8	290.0
2013-12-20 01:00:00	YM	Futures	16541.8	16542.8	16535.6	16538.7	322.0
2013-12-20 02:00:00	YM	Futures	16537.7	16543.9	16536.7	16541.8	661.0
2013-12-20 03:00:00	YM	Futures	16541.8	16548.0	16526.4	16542.8	1567.0
2013-12-20 04:00:00	YM	Futures	16543.9	16562.3	16540.8	16554.1	1382.0
2013-12-20 05:00:00	YM	Futures	16553.1	16557.2	16538.7	16541.8	1541.0
2013-12-20 06:00:00	YM	Futures	16542.8	16552.1	16536.7	16540.8	1039.0
2013-12-20 07:00:00	YM	Futures	16540.8	16544.9	16530.5	16540.8	1558.0
2013-12-20 08:00:00	YM	Futures	16540.8	16552.1	16532.6	16545.9	2469.0
2013-12-20 09:00:00	YM	Futures	16546.9	16603.3	16541.8	16598.2	15406.0
2013-12-20 10:00:00	YM	Futures	16598.2	16603.3	16575.6	16591.0	11311.0
2013-12-20 11:00:00	YM	Futures	16589.0	16620.8	16586.9	16615.6	10048.0
2013-12-20 12:00:00	YM	Futures	16615.6	16630.0	16605.4	16616.7	7721.0
2013-12-20 13:00:00	YM	Futures	16617.7	16635.1	16611.5	16632.0	5002.0

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

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