PREVIEW / futures_1hour / 2013-12-27

all futures 1-hour files

  file:    by_date/futures_1hour/2013/2013-12-27.parquet
  size:    42 KB
  rows:    1,266

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-27 00:00:00	ES	Futures	1898.52	1899.29	1898.26	1899.03	1173.0
2013-12-27 01:00:00	ES	Futures	1898.77	1900.58	1898.77	1900.07	2178.0
2013-12-27 02:00:00	ES	Futures	1899.81	1900.33	1898.26	1898.77	4015.0
2013-12-27 03:00:00	ES	Futures	1898.77	1899.55	1897.48	1899.03	8436.0
2013-12-27 04:00:00	ES	Futures	1898.77	1899.55	1898.0	1898.0	6299.0
2013-12-27 05:00:00	ES	Futures	1898.26	1898.77	1896.7	1897.74	6712.0
2013-12-27 06:00:00	ES	Futures	1898.0	1899.55	1897.74	1899.03	4208.0
2013-12-27 07:00:00	ES	Futures	1898.77	1901.36	1898.52	1901.36	8199.0
2013-12-27 08:00:00	ES	Futures	1901.36	1901.36	1900.07	1900.84	7826.0
2013-12-27 09:00:00	ES	Futures	1900.84	1903.69	1900.84	1901.62	95621.0
2013-12-27 10:00:00	ES	Futures	1901.88	1902.91	1897.74	1898.0	111338.0
2013-12-27 11:00:00	ES	Futures	1898.0	1901.36	1898.0	1900.07	83096.0
2013-12-27 12:00:00	ES	Futures	1900.33	1900.58	1898.26	1898.77	46654.0
2013-12-27 13:00:00	ES	Futures	1898.77	1899.55	1898.26	1899.29	29449.0
2013-12-27 14:00:00	ES	Futures	1899.29	1900.84	1898.77	1899.03	41086.0
2013-12-27 15:00:00	ES	Futures	1898.77	1900.58	1898.77	1899.55	106037.0
2013-12-27 16:00:00	ES	Futures	1899.81	1901.1	1899.29	1900.33	44163.0
2013-12-27 17:00:00	ES	Futures	1900.33	1900.58	1899.81	1900.33	1150.0
2013-12-27 00:00:00	NQ	Futures	4164.35	4166.09	4163.48	4165.51	308.0
2013-12-27 01:00:00	NQ	Futures	4165.51	4167.84	4165.51	4167.26	190.0
2013-12-27 02:00:00	NQ	Futures	4166.38	4167.84	4163.77	4164.93	460.0
2013-12-27 03:00:00	NQ	Futures	4164.93	4166.97	4162.61	4164.93	930.0
2013-12-27 04:00:00	NQ	Futures	4164.93	4165.22	4162.02	4162.02	459.0
2013-12-27 05:00:00	NQ	Futures	4162.61	4163.77	4159.7	4161.73	653.0
2013-12-27 06:00:00	NQ	Futures	4162.31	4165.22	4161.44	4164.93	755.0
2013-12-27 07:00:00	NQ	Futures	4164.64	4168.71	4164.06	4168.42	749.0
2013-12-27 08:00:00	NQ	Futures	4168.42	4168.42	4164.64	4166.09	1112.0
2013-12-27 09:00:00	NQ	Futures	4166.09	4171.33	4161.73	4162.31	16388.0
2013-12-27 10:00:00	NQ	Futures	4162.31	4168.42	4152.14	4152.72	19526.0
2013-12-27 11:00:00	NQ	Futures	4152.72	4161.73	4152.43	4158.25	11642.0
2013-12-27 12:00:00	NQ	Futures	4158.54	4159.12	4153.59	4154.18	5326.0
2013-12-27 13:00:00	NQ	Futures	4154.47	4155.92	4150.98	4153.3	5995.0
2013-12-27 14:00:00	NQ	Futures	4153.3	4156.21	4150.4	4150.69	6278.0
2013-12-27 15:00:00	NQ	Futures	4150.4	4153.01	4147.49	4152.72	18174.0
2013-12-27 16:00:00	NQ	Futures	4153.01	4154.47	4150.11	4151.27	3571.0
2013-12-27 17:00:00	NQ	Futures	4151.27	4152.43	4150.98	4151.56	86.0
2013-12-27 00:00:00	YM	Futures	16822.8	16828.9	16821.7	16828.9	239.0
2013-12-27 01:00:00	YM	Futures	16828.9	16841.2	16827.9	16837.1	317.0
2013-12-27 02:00:00	YM	Futures	16836.1	16840.2	16826.9	16834.0	470.0
2013-12-27 03:00:00	YM	Futures	16834.0	16840.2	16822.8	16833.0	1300.0
2013-12-27 04:00:00	YM	Futures	16833.0	16841.2	16832.0	16832.0	959.0
2013-12-27 05:00:00	YM	Futures	16833.0	16837.1	16824.8	16835.1	1290.0
2013-12-27 06:00:00	YM	Futures	16835.1	16847.4	16833.0	16842.2	975.0
2013-12-27 07:00:00	YM	Futures	16841.2	16857.6	16838.1	16856.6	1196.0
2013-12-27 08:00:00	YM	Futures	16857.6	16860.7	16848.4	16855.6	1023.0
2013-12-27 09:00:00	YM	Futures	16855.6	16884.3	16855.6	16857.6	9296.0
2013-12-27 10:00:00	YM	Futures	16857.6	16867.9	16815.6	16816.6	8616.0
2013-12-27 11:00:00	YM	Futures	16816.6	16849.4	16812.5	16842.2	7428.0
2013-12-27 12:00:00	YM	Futures	16842.2	16846.3	16820.7	16822.8	4055.0
2013-12-27 13:00:00	YM	Futures	16822.8	16842.2	16818.7	16835.1	3975.0

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

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