PREVIEW / futures_1hour / 2014-01-20

all futures 1-hour files

  file:    by_date/futures_1hour/2014/2014-01-20.parquet
  size:    35 KB
  rows:    1,079

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
2014-01-20 00:00:00	ES	Futures	1897.22	1898.26	1896.7	1897.22	1976.0
2014-01-20 01:00:00	ES	Futures	1897.22	1898.0	1896.7	1896.7	1096.0
2014-01-20 02:00:00	ES	Futures	1896.7	1896.96	1895.15	1895.67	4497.0
2014-01-20 03:00:00	ES	Futures	1895.67	1897.22	1894.12	1896.96	14414.0
2014-01-20 04:00:00	ES	Futures	1896.96	1897.22	1895.93	1896.7	7722.0
2014-01-20 05:00:00	ES	Futures	1896.96	1897.74	1896.7	1897.48	4294.0
2014-01-20 06:00:00	ES	Futures	1897.74	1897.74	1896.7	1897.48	4218.0
2014-01-20 07:00:00	ES	Futures	1897.48	1898.0	1896.7	1896.96	3522.0
2014-01-20 08:00:00	ES	Futures	1896.96	1897.74	1896.19	1896.96	6272.0
2014-01-20 09:00:00	ES	Futures	1897.22	1898.0	1896.7	1897.48	4700.0
2014-01-20 10:00:00	ES	Futures	1897.48	1897.48	1896.45	1896.45	4364.0
2014-01-20 11:00:00	ES	Futures	1896.45	1897.74	1896.45	1897.74	6019.0
2014-01-20 18:00:00	ES	Futures	1897.48	1897.74	1896.96	1897.22	1974.0
2014-01-20 19:00:00	ES	Futures	1897.22	1901.62	1897.22	1900.58	7963.0
2014-01-20 20:00:00	ES	Futures	1900.33	1906.79	1900.07	1905.24	15622.0
2014-01-20 21:00:00	ES	Futures	1905.24	1906.02	1904.46	1905.5	5267.0
2014-01-20 22:00:00	ES	Futures	1905.24	1905.76	1904.72	1904.98	2250.0
2014-01-20 23:00:00	ES	Futures	1904.98	1905.76	1904.72	1905.76	2193.0
2014-01-20 00:00:00	NQ	Futures	4166.68	4168.42	4165.8	4166.97	181.0
2014-01-20 01:00:00	NQ	Futures	4166.97	4168.42	4165.51	4165.51	85.0
2014-01-20 02:00:00	NQ	Futures	4165.51	4166.68	4161.73	4163.19	422.0
2014-01-20 03:00:00	NQ	Futures	4162.9	4166.97	4159.99	4166.09	1319.0
2014-01-20 04:00:00	NQ	Futures	4166.38	4167.84	4164.64	4167.55	648.0
2014-01-20 05:00:00	NQ	Futures	4167.84	4169.87	4166.97	4169.58	538.0
2014-01-20 06:00:00	NQ	Futures	4169.58	4170.45	4168.13	4169.87	581.0
2014-01-20 07:00:00	NQ	Futures	4169.87	4170.74	4167.26	4169.87	557.0
2014-01-20 08:00:00	NQ	Futures	4170.16	4172.49	4169.0	4171.33	689.0
2014-01-20 09:00:00	NQ	Futures	4171.04	4171.91	4168.71	4169.0	833.0
2014-01-20 10:00:00	NQ	Futures	4169.29	4170.45	4168.42	4170.45	531.0
2014-01-20 11:00:00	NQ	Futures	4170.16	4173.07	4170.16	4172.49	665.0
2014-01-20 18:00:00	NQ	Futures	4172.2	4172.49	4171.33	4171.62	177.0
2014-01-20 19:00:00	NQ	Futures	4171.91	4179.76	4171.91	4178.3	783.0
2014-01-20 20:00:00	NQ	Futures	4178.01	4192.26	4177.72	4189.64	2059.0
2014-01-20 21:00:00	NQ	Futures	4189.93	4191.09	4187.02	4189.64	710.0
2014-01-20 22:00:00	NQ	Futures	4189.64	4190.51	4189.35	4189.64	443.0
2014-01-20 23:00:00	NQ	Futures	4189.64	4194.58	4189.35	4193.71	1057.0
2014-01-20 00:00:00	YM	Futures	16811.5	16819.7	16807.4	16812.5	183.0
2014-01-20 01:00:00	YM	Futures	16811.5	16815.6	16805.3	16807.4	151.0
2014-01-20 02:00:00	YM	Futures	16807.4	16809.4	16792.0	16798.2	463.0
2014-01-20 03:00:00	YM	Futures	16798.2	16810.5	16782.8	16805.3	1707.0
2014-01-20 04:00:00	YM	Futures	16806.4	16809.4	16797.1	16807.4	745.0
2014-01-20 05:00:00	YM	Futures	16807.4	16814.6	16804.3	16811.5	362.0
2014-01-20 06:00:00	YM	Futures	16811.5	16814.6	16803.3	16811.5	519.0
2014-01-20 07:00:00	YM	Futures	16809.4	16812.5	16802.3	16807.4	296.0
2014-01-20 08:00:00	YM	Futures	16807.4	16810.5	16798.2	16805.3	698.0
2014-01-20 09:00:00	YM	Futures	16805.3	16810.5	16802.3	16807.4	378.0
2014-01-20 10:00:00	YM	Futures	16808.4	16812.5	16803.3	16807.4	691.0
2014-01-20 11:00:00	YM	Futures	16807.4	16813.5	16807.4	16812.5	752.0
2014-01-20 18:00:00	YM	Futures	16813.5	16817.6	16811.5	16817.6	349.0
2014-01-20 19:00:00	YM	Futures	16817.6	16855.6	16816.6	16845.3	1348.0

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

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