PREVIEW / futures_1hour / 2014-10-24

all futures 1-hour files

  file:    by_date/futures_1hour/2014/2014-10-24.parquet
  size:    44 KB
  rows:    1,299

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-10-24 00:00:00	ES	Futures	2030.25	2031.82	2028.41	2030.51	2527.0
2014-10-24 01:00:00	ES	Futures	2030.77	2036.53	2029.99	2031.03	10019.0
2014-10-24 02:00:00	ES	Futures	2031.03	2034.44	2030.77	2033.91	8848.0
2014-10-24 03:00:00	ES	Futures	2033.91	2036.53	2030.77	2036.01	35627.0
2014-10-24 04:00:00	ES	Futures	2036.01	2038.11	2034.18	2035.49	21851.0
2014-10-24 05:00:00	ES	Futures	2035.49	2035.75	2032.87	2034.18	18122.0
2014-10-24 06:00:00	ES	Futures	2033.91	2034.7	2030.51	2032.34	16792.0
2014-10-24 07:00:00	ES	Futures	2032.6	2034.44	2029.99	2031.82	28057.0
2014-10-24 08:00:00	ES	Futures	2031.82	2037.84	2029.99	2036.01	65308.0
2014-10-24 09:00:00	ES	Futures	2036.27	2045.97	2035.75	2038.37	213244.0
2014-10-24 10:00:00	ES	Futures	2038.63	2043.61	2031.82	2043.08	302452.0
2014-10-24 11:00:00	ES	Futures	2043.35	2049.37	2040.73	2047.01	192949.0
2014-10-24 12:00:00	ES	Futures	2047.01	2050.68	2043.35	2044.66	127740.0
2014-10-24 13:00:00	ES	Futures	2044.92	2047.54	2041.25	2046.49	116448.0
2014-10-24 14:00:00	ES	Futures	2046.49	2050.16	2045.44	2048.58	94752.0
2014-10-24 15:00:00	ES	Futures	2048.58	2053.04	2047.01	2051.99	181057.0
2014-10-24 16:00:00	ES	Futures	2051.73	2054.35	2051.47	2054.09	71906.0
2014-10-24 17:00:00	ES	Futures	2054.09	2055.13	2053.82	2054.35	3288.0
2014-10-24 00:00:00	NQ	Futures	4669.63	4673.73	4666.12	4670.8	405.0
2014-10-24 01:00:00	NQ	Futures	4671.39	4683.4	4668.46	4673.15	1150.0
2014-10-24 02:00:00	NQ	Futures	4672.56	4681.06	4672.56	4679.89	889.0
2014-10-24 03:00:00	NQ	Futures	4679.89	4685.45	4672.56	4685.45	5569.0
2014-10-24 04:00:00	NQ	Futures	4685.16	4688.38	4678.42	4683.11	2801.0
2014-10-24 05:00:00	NQ	Futures	4682.82	4684.58	4677.25	4679.89	2232.0
2014-10-24 06:00:00	NQ	Futures	4680.18	4680.77	4671.39	4675.79	2544.0
2014-10-24 07:00:00	NQ	Futures	4676.08	4680.47	4671.98	4676.08	3747.0
2014-10-24 08:00:00	NQ	Futures	4676.37	4690.14	4671.68	4689.26	8832.0
2014-10-24 09:00:00	NQ	Futures	4689.56	4711.82	4687.51	4695.71	50138.0
2014-10-24 10:00:00	NQ	Futures	4695.12	4710.95	4681.06	4709.48	58304.0
2014-10-24 11:00:00	NQ	Futures	4709.19	4717.39	4702.16	4713.88	33018.0
2014-10-24 12:00:00	NQ	Futures	4713.58	4718.27	4703.33	4705.09	21110.0
2014-10-24 13:00:00	NQ	Futures	4705.38	4715.93	4696.88	4713.0	23047.0
2014-10-24 14:00:00	NQ	Futures	4713.58	4718.27	4711.24	4714.46	15115.0
2014-10-24 15:00:00	NQ	Futures	4714.17	4731.46	4712.41	4726.18	32744.0
2014-10-24 16:00:00	NQ	Futures	4726.18	4733.21	4725.89	4731.75	9652.0
2014-10-24 17:00:00	NQ	Futures	4731.46	4733.21	4730.87	4732.63	279.0
2014-10-24 00:00:00	YM	Futures	17221.6	17232.0	17207.0	17223.7	480.0
2014-10-24 01:00:00	YM	Futures	17225.8	17273.6	17219.5	17243.4	3281.0
2014-10-24 02:00:00	YM	Futures	17242.4	17256.9	17231.0	17250.7	2180.0
2014-10-24 03:00:00	YM	Futures	17251.8	17272.5	17231.0	17268.4	7065.0
2014-10-24 04:00:00	YM	Futures	17268.4	17284.0	17252.8	17263.2	3495.0
2014-10-24 05:00:00	YM	Futures	17262.1	17269.4	17246.6	17253.8	2701.0
2014-10-24 06:00:00	YM	Futures	17253.8	17258.0	17221.6	17237.2	2574.0
2014-10-24 07:00:00	YM	Futures	17237.2	17251.8	17215.4	17229.9	3823.0
2014-10-24 08:00:00	YM	Futures	17229.9	17271.5	17219.5	17256.9	7339.0
2014-10-24 09:00:00	YM	Futures	17259.0	17331.8	17255.9	17281.9	21683.0
2014-10-24 10:00:00	YM	Futures	17282.9	17318.3	17233.0	17314.1	27989.0
2014-10-24 11:00:00	YM	Futures	17315.2	17367.2	17294.4	17353.6	17680.0
2014-10-24 12:00:00	YM	Futures	17352.6	17380.7	17327.7	17343.2	11849.0
2014-10-24 13:00:00	YM	Futures	17343.2	17359.9	17317.3	17352.6	10397.0

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

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