PREVIEW / futures_1hour / 2014-07-23

all futures 1-hour files

  file:    by_date/futures_1hour/2014/2014-07-23.parquet
  size:    47 KB
  rows:    1,551

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-07-23 00:00:00	ES	Futures	2058.59	2059.11	2058.33	2058.59	1096.0
2014-07-23 01:00:00	ES	Futures	2058.59	2058.85	2057.55	2057.55	1580.0
2014-07-23 02:00:00	ES	Futures	2057.81	2059.63	2057.81	2059.11	4819.0
2014-07-23 03:00:00	ES	Futures	2059.11	2061.98	2058.33	2060.15	23982.0
2014-07-23 04:00:00	ES	Futures	2060.15	2061.72	2060.15	2060.67	10028.0
2014-07-23 05:00:00	ES	Futures	2060.67	2062.24	2060.15	2061.72	8724.0
2014-07-23 06:00:00	ES	Futures	2061.98	2063.54	2061.46	2061.72	16230.0
2014-07-23 07:00:00	ES	Futures	2061.72	2063.02	2060.94	2060.94	16799.0
2014-07-23 08:00:00	ES	Futures	2060.94	2063.02	2060.94	2062.76	20469.0
2014-07-23 09:00:00	ES	Futures	2062.76	2065.11	2059.63	2061.72	230899.0
2014-07-23 10:00:00	ES	Futures	2061.98	2067.71	2060.67	2066.15	231157.0
2014-07-23 11:00:00	ES	Futures	2066.15	2067.19	2065.37	2066.41	115166.0
2014-07-23 12:00:00	ES	Futures	2066.41	2066.67	2062.24	2063.8	113927.0
2014-07-23 13:00:00	ES	Futures	2063.54	2066.67	2063.02	2066.15	76113.0
2014-07-23 14:00:00	ES	Futures	2066.41	2066.93	2065.11	2065.89	77950.0
2014-07-23 15:00:00	ES	Futures	2065.89	2066.93	2064.84	2065.63	110807.0
2014-07-23 16:00:00	ES	Futures	2065.63	2066.15	2064.32	2065.37	70739.0
2014-07-23 17:00:00	ES	Futures	2065.11	2065.63	2064.84	2065.37	2680.0
2014-07-23 18:00:00	ES	Futures	2065.11	2065.63	2064.32	2064.58	4455.0
2014-07-23 19:00:00	ES	Futures	2064.84	2065.63	2064.58	2065.11	1061.0
2014-07-23 20:00:00	ES	Futures	2065.37	2065.63	2065.11	2065.63	1258.0
2014-07-23 21:00:00	ES	Futures	2065.63	2067.71	2064.84	2064.84	8618.0
2014-07-23 22:00:00	ES	Futures	2065.11	2065.37	2063.28	2063.54	5340.0
2014-07-23 23:00:00	ES	Futures	2063.54	2063.8	2062.5	2062.5	3978.0
2014-07-23 00:00:00	NQ	Futures	4611.2	4614.42	4611.2	4612.96	328.0
2014-07-23 01:00:00	NQ	Futures	4612.37	4612.96	4610.04	4610.33	224.0
2014-07-23 02:00:00	NQ	Futures	4610.33	4616.75	4610.33	4615.88	1214.0
2014-07-23 03:00:00	NQ	Futures	4615.88	4621.42	4614.12	4616.46	3438.0
2014-07-23 04:00:00	NQ	Futures	4616.75	4621.42	4616.46	4619.38	1627.0
2014-07-23 05:00:00	NQ	Futures	4619.67	4622.59	4617.92	4620.55	1538.0
2014-07-23 06:00:00	NQ	Futures	4620.26	4624.34	4620.26	4621.42	2479.0
2014-07-23 07:00:00	NQ	Futures	4621.72	4635.15	4621.42	4629.31	6257.0
2014-07-23 08:00:00	NQ	Futures	4629.31	4632.52	4627.26	4630.48	4023.0
2014-07-23 09:00:00	NQ	Futures	4630.18	4640.99	4625.51	4633.69	43700.0
2014-07-23 10:00:00	NQ	Futures	4633.98	4652.67	4629.89	4647.41	46193.0
2014-07-23 11:00:00	NQ	Futures	4647.41	4651.79	4643.91	4646.83	22588.0
2014-07-23 12:00:00	NQ	Futures	4646.83	4649.75	4638.36	4643.03	15507.0
2014-07-23 13:00:00	NQ	Futures	4642.74	4648.87	4639.82	4648.0	10184.0
2014-07-23 14:00:00	NQ	Futures	4648.0	4651.79	4645.66	4648.29	14521.0
2014-07-23 15:00:00	NQ	Futures	4648.29	4651.5	4645.08	4646.54	19384.0
2014-07-23 16:00:00	NQ	Futures	4646.54	4650.63	4639.24	4646.25	12141.0
2014-07-23 17:00:00	NQ	Futures	4646.25	4648.87	4645.66	4648.0	404.0
2014-07-23 18:00:00	NQ	Futures	4646.54	4648.0	4644.79	4645.08	392.0
2014-07-23 19:00:00	NQ	Futures	4645.37	4648.87	4645.37	4648.0	251.0
2014-07-23 20:00:00	NQ	Futures	4648.0	4649.46	4647.71	4648.87	323.0
2014-07-23 21:00:00	NQ	Futures	4648.87	4655.01	4648.87	4649.46	1448.0
2014-07-23 22:00:00	NQ	Futures	4648.87	4650.92	4645.66	4647.71	730.0
2014-07-23 23:00:00	NQ	Futures	4647.41	4647.41	4643.91	4644.2	577.0
2014-07-23 00:00:00	YM	Futures	17624.9	17626.9	17620.7	17620.7	337.0
2014-07-23 01:00:00	YM	Futures	17621.8	17624.9	17613.5	17614.5	230.0

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

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