PREVIEW / futures_1hour / 2014-01-06

all futures 1-hour files

  file:    by_date/futures_1hour/2014/2014-01-06.parquet
  size:    48 KB
  rows:    1,510

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-06 00:00:00	ES	Futures	1888.43	1888.69	1887.65	1887.65	2436.0
2014-01-06 01:00:00	ES	Futures	1887.65	1888.17	1886.62	1887.91	2913.0
2014-01-06 02:00:00	ES	Futures	1887.65	1888.69	1887.13	1887.65	4378.0
2014-01-06 03:00:00	ES	Futures	1887.39	1890.76	1886.36	1887.13	23021.0
2014-01-06 04:00:00	ES	Futures	1887.13	1889.46	1886.36	1889.2	12689.0
2014-01-06 05:00:00	ES	Futures	1889.46	1890.5	1888.94	1889.46	9501.0
2014-01-06 06:00:00	ES	Futures	1889.46	1891.53	1889.2	1890.5	6758.0
2014-01-06 07:00:00	ES	Futures	1890.5	1893.34	1889.98	1892.05	13563.0
2014-01-06 08:00:00	ES	Futures	1891.79	1893.08	1891.27	1892.57	15261.0
2014-01-06 09:00:00	ES	Futures	1892.82	1895.93	1886.88	1889.72	190159.0
2014-01-06 10:00:00	ES	Futures	1889.46	1891.01	1885.07	1885.58	216465.0
2014-01-06 11:00:00	ES	Futures	1885.58	1886.62	1880.15	1883.51	210239.0
2014-01-06 12:00:00	ES	Futures	1883.51	1884.29	1880.93	1883.0	125402.0
2014-01-06 13:00:00	ES	Futures	1883.25	1887.91	1881.44	1886.36	115021.0
2014-01-06 14:00:00	ES	Futures	1886.62	1889.2	1885.07	1888.43	128982.0
2014-01-06 15:00:00	ES	Futures	1888.17	1888.69	1883.0	1883.77	168478.0
2014-01-06 16:00:00	ES	Futures	1883.77	1884.29	1882.22	1882.74	80752.0
2014-01-06 17:00:00	ES	Futures	1882.74	1883.25	1882.48	1883.0	1955.0
2014-01-06 18:00:00	ES	Futures	1882.74	1884.03	1882.48	1883.51	6034.0
2014-01-06 19:00:00	ES	Futures	1883.77	1884.03	1883.0	1883.77	4813.0
2014-01-06 20:00:00	ES	Futures	1883.51	1885.32	1883.25	1884.81	6332.0
2014-01-06 21:00:00	ES	Futures	1885.07	1887.13	1884.81	1886.62	5334.0
2014-01-06 22:00:00	ES	Futures	1886.62	1887.65	1886.62	1887.65	3627.0
2014-01-06 23:00:00	ES	Futures	1887.39	1887.65	1886.1	1886.88	2222.0
2014-01-06 00:00:00	NQ	Futures	4108.54	4108.83	4106.5	4107.38	376.0
2014-01-06 01:00:00	NQ	Futures	4107.08	4107.96	4104.47	4107.08	399.0
2014-01-06 02:00:00	NQ	Futures	4107.08	4108.54	4106.79	4107.96	769.0
2014-01-06 03:00:00	NQ	Futures	4107.67	4109.99	4100.98	4102.72	3691.0
2014-01-06 04:00:00	NQ	Futures	4102.43	4109.41	4101.56	4108.83	1296.0
2014-01-06 05:00:00	NQ	Futures	4109.12	4109.41	4106.5	4107.38	1238.0
2014-01-06 06:00:00	NQ	Futures	4107.38	4109.41	4106.79	4107.08	1473.0
2014-01-06 07:00:00	NQ	Futures	4107.08	4112.03	4105.92	4109.7	1632.0
2014-01-06 08:00:00	NQ	Futures	4109.41	4112.32	4103.31	4106.5	4244.0
2014-01-06 09:00:00	NQ	Futures	4106.5	4112.9	4088.48	4091.97	41964.0
2014-01-06 10:00:00	NQ	Futures	4091.68	4093.71	4083.25	4085.86	41486.0
2014-01-06 11:00:00	NQ	Futures	4085.57	4090.81	4076.27	4086.16	29235.0
2014-01-06 12:00:00	NQ	Futures	4086.45	4089.93	4081.5	4087.61	25067.0
2014-01-06 13:00:00	NQ	Futures	4087.61	4096.91	4081.21	4094.59	23101.0
2014-01-06 14:00:00	NQ	Futures	4094.88	4105.92	4093.13	4103.89	23197.0
2014-01-06 15:00:00	NQ	Futures	4103.89	4105.05	4091.97	4092.55	35526.0
2014-01-06 16:00:00	NQ	Futures	4092.55	4094.59	4087.32	4087.32	6330.0
2014-01-06 17:00:00	NQ	Futures	4087.61	4088.77	4087.32	4088.19	172.0
2014-01-06 18:00:00	NQ	Futures	4088.48	4091.97	4088.19	4091.39	496.0
2014-01-06 19:00:00	NQ	Futures	4091.68	4093.13	4091.1	4092.26	812.0
2014-01-06 20:00:00	NQ	Futures	4092.55	4095.75	4091.1	4094.29	793.0
2014-01-06 21:00:00	NQ	Futures	4094.59	4098.07	4094.29	4097.49	712.0
2014-01-06 22:00:00	NQ	Futures	4097.2	4099.24	4097.2	4099.24	613.0
2014-01-06 23:00:00	NQ	Futures	4099.53	4099.53	4096.91	4097.2	347.0
2014-01-06 00:00:00	YM	Futures	16819.7	16821.7	16814.6	16817.6	389.0
2014-01-06 01:00:00	YM	Futures	16817.6	16819.7	16807.4	16816.6	341.0

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

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