PREVIEW / futures_1hour / 2014-05-30

all futures 1-hour files

  file:    by_date/futures_1hour/2014/2014-05-30.parquet
  size:    41 KB
  rows:    1,269

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-05-30 00:00:00	ES	Futures	1989.34	1989.6	1989.08	1989.34	1254.0
2014-05-30 01:00:00	ES	Futures	1989.6	1990.38	1988.82	1989.08	4059.0
2014-05-30 02:00:00	ES	Futures	1989.08	1989.34	1988.3	1988.56	5304.0
2014-05-30 03:00:00	ES	Futures	1988.56	1990.12	1988.3	1989.34	16846.0
2014-05-30 04:00:00	ES	Futures	1989.34	1990.38	1989.08	1990.12	12567.0
2014-05-30 05:00:00	ES	Futures	1990.12	1991.16	1989.34	1989.86	11347.0
2014-05-30 06:00:00	ES	Futures	1989.86	1990.64	1988.82	1990.38	9314.0
2014-05-30 07:00:00	ES	Futures	1990.38	1991.42	1990.12	1990.38	10321.0
2014-05-30 08:00:00	ES	Futures	1990.64	1991.16	1989.34	1990.12	18132.0
2014-05-30 09:00:00	ES	Futures	1990.12	1991.16	1988.3	1990.38	129991.0
2014-05-30 10:00:00	ES	Futures	1990.38	1993.5	1989.6	1992.98	144888.0
2014-05-30 11:00:00	ES	Futures	1992.72	1994.02	1991.68	1992.98	84807.0
2014-05-30 12:00:00	ES	Futures	1992.98	1993.5	1988.82	1990.38	113425.0
2014-05-30 13:00:00	ES	Futures	1990.38	1991.42	1989.34	1991.16	82180.0
2014-05-30 14:00:00	ES	Futures	1991.16	1994.79	1990.9	1992.46	110799.0
2014-05-30 15:00:00	ES	Futures	1992.72	1996.61	1991.42	1995.05	257973.0
2014-05-30 16:00:00	ES	Futures	1995.05	1995.31	1992.72	1993.5	130565.0
2014-05-30 17:00:00	ES	Futures	1993.24	1993.76	1993.24	1993.24	2068.0
2014-05-30 00:00:00	NQ	Futures	4346.78	4347.66	4346.78	4347.07	159.0
2014-05-30 01:00:00	NQ	Futures	4346.78	4349.7	4345.91	4346.78	469.0
2014-05-30 02:00:00	NQ	Futures	4346.49	4347.07	4344.75	4345.04	487.0
2014-05-30 03:00:00	NQ	Futures	4344.75	4349.11	4343.58	4347.95	1859.0
2014-05-30 04:00:00	NQ	Futures	4347.66	4350.28	4347.37	4348.82	1281.0
2014-05-30 05:00:00	NQ	Futures	4349.11	4352.03	4347.66	4349.7	2042.0
2014-05-30 06:00:00	NQ	Futures	4349.7	4350.86	4347.37	4349.99	1424.0
2014-05-30 07:00:00	NQ	Futures	4349.99	4351.44	4349.11	4349.4	1899.0
2014-05-30 08:00:00	NQ	Futures	4349.4	4350.28	4346.2	4348.82	3606.0
2014-05-30 09:00:00	NQ	Futures	4348.82	4353.48	4342.12	4343.58	34406.0
2014-05-30 10:00:00	NQ	Futures	4343.58	4354.94	4340.96	4351.73	31747.0
2014-05-30 11:00:00	NQ	Futures	4351.73	4357.27	4349.4	4352.61	19642.0
2014-05-30 12:00:00	NQ	Futures	4352.32	4355.52	4331.35	4336.01	32566.0
2014-05-30 13:00:00	NQ	Futures	4335.72	4339.21	4327.85	4336.01	23071.0
2014-05-30 14:00:00	NQ	Futures	4336.01	4346.78	4332.51	4340.09	19083.0
2014-05-30 15:00:00	NQ	Futures	4340.38	4352.03	4338.63	4350.28	28537.0
2014-05-30 16:00:00	NQ	Futures	4350.28	4351.73	4343.0	4343.87	7935.0
2014-05-30 17:00:00	NQ	Futures	4343.58	4344.45	4343.0	4343.58	86.0
2014-05-30 00:00:00	YM	Futures	17163.6	17164.7	17162.6	17163.6	112.0
2014-05-30 01:00:00	YM	Futures	17164.7	17171.9	17158.5	17160.5	704.0
2014-05-30 02:00:00	YM	Futures	17160.5	17162.6	17155.4	17158.5	909.0
2014-05-30 03:00:00	YM	Futures	17157.5	17171.9	17149.2	17168.8	2918.0
2014-05-30 04:00:00	YM	Futures	17169.8	17176.0	17165.7	17172.9	1452.0
2014-05-30 05:00:00	YM	Futures	17173.9	17180.1	17165.7	17168.8	1598.0
2014-05-30 06:00:00	YM	Futures	17168.8	17173.9	17160.5	17170.8	1295.0
2014-05-30 07:00:00	YM	Futures	17171.9	17177.0	17167.8	17169.8	1212.0
2014-05-30 08:00:00	YM	Futures	17169.8	17171.9	17154.4	17163.6	1841.0
2014-05-30 09:00:00	YM	Futures	17164.7	17165.7	17131.7	17148.2	13653.0
2014-05-30 10:00:00	YM	Futures	17149.2	17171.9	17143.0	17160.5	12511.0
2014-05-30 11:00:00	YM	Futures	17160.5	17166.7	17150.3	17163.6	6649.0
2014-05-30 12:00:00	YM	Futures	17162.6	17170.8	17142.0	17153.3	8651.0
2014-05-30 13:00:00	YM	Futures	17152.3	17170.8	17148.2	17169.8	7124.0

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

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