PREVIEW / futures_1hour / 2015-07-08

all futures 1-hour files

  file:    by_date/futures_1hour/2015/2015-07-08.parquet
  size:    53 KB
  rows:    1,566

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
2015-07-08 00:00:00	ES	Futures	2192.29	2193.09	2189.36	2190.16	7152.0
2015-07-08 01:00:00	ES	Futures	2190.16	2194.95	2189.89	2191.49	10214.0
2015-07-08 02:00:00	ES	Futures	2191.49	2192.02	2182.44	2184.3	33258.0
2015-07-08 03:00:00	ES	Futures	2184.57	2186.7	2174.98	2185.1	66033.0
2015-07-08 04:00:00	ES	Futures	2185.37	2191.22	2179.77	2185.63	49702.0
2015-07-08 05:00:00	ES	Futures	2185.9	2187.23	2182.44	2186.16	26776.0
2015-07-08 06:00:00	ES	Futures	2186.43	2193.09	2184.83	2192.29	28541.0
2015-07-08 07:00:00	ES	Futures	2192.29	2197.88	2190.42	2191.76	74986.0
2015-07-08 08:00:00	ES	Futures	2191.76	2196.81	2189.36	2192.55	47364.0
2015-07-08 09:00:00	ES	Futures	2192.55	2195.75	2184.83	2187.5	241841.0
2015-07-08 10:00:00	ES	Futures	2187.5	2191.76	2180.31	2190.16	381546.0
2015-07-08 11:00:00	ES	Futures	2190.16	2190.42	2176.05	2178.71	274617.0
2015-07-08 12:00:00	ES	Futures	2178.71	2185.1	2177.38	2184.57	151572.0
2015-07-08 13:00:00	ES	Futures	2184.3	2186.7	2180.31	2184.3	132353.0
2015-07-08 14:00:00	ES	Futures	2184.3	2185.1	2168.59	2171.52	259521.0
2015-07-08 15:00:00	ES	Futures	2171.52	2180.04	2170.19	2171.25	426921.0
2015-07-08 16:00:00	ES	Futures	2171.52	2173.92	2170.19	2171.52	109337.0
2015-07-08 17:00:00	ES	Futures	2171.25	2172.59	2170.99	2172.05	3154.0
2015-07-08 18:00:00	ES	Futures	2172.32	2176.05	2172.32	2175.78	5930.0
2015-07-08 19:00:00	ES	Futures	2176.05	2177.64	2175.51	2177.38	4230.0
2015-07-08 20:00:00	ES	Futures	2177.11	2178.71	2172.32	2176.05	14746.0
2015-07-08 21:00:00	ES	Futures	2176.31	2182.17	2176.05	2181.64	17699.0
2015-07-08 22:00:00	ES	Futures	2181.9	2185.1	2180.57	2183.24	18033.0
2015-07-08 23:00:00	ES	Futures	2183.24	2186.43	2182.17	2183.5	9019.0
2015-07-08 00:00:00	NQ	Futures	5191.4	5193.47	5184.6	5186.67	722.0
2015-07-08 01:00:00	NQ	Futures	5186.67	5199.39	5186.67	5189.33	892.0
2015-07-08 02:00:00	NQ	Futures	5189.03	5190.51	5170.4	5173.95	3102.0
2015-07-08 03:00:00	NQ	Futures	5174.84	5183.12	5149.4	5173.65	10824.0
2015-07-08 04:00:00	NQ	Futures	5173.95	5191.1	5159.75	5174.54	7265.0
2015-07-08 05:00:00	NQ	Futures	5174.84	5180.16	5166.55	5179.57	4877.0
2015-07-08 06:00:00	NQ	Futures	5180.16	5194.95	5175.43	5192.58	3753.0
2015-07-08 07:00:00	NQ	Futures	5192.88	5207.96	5189.92	5193.17	14156.0
2015-07-08 08:00:00	NQ	Futures	5193.17	5204.71	5188.74	5195.84	6210.0
2015-07-08 09:00:00	NQ	Futures	5195.84	5201.46	5163.0	5170.1	35993.0
2015-07-08 10:00:00	NQ	Futures	5170.1	5187.55	5152.65	5183.12	48960.0
2015-07-08 11:00:00	NQ	Futures	5183.41	5183.71	5144.07	5152.06	37167.0
2015-07-08 12:00:00	NQ	Futures	5152.06	5169.51	5148.51	5167.44	19486.0
2015-07-08 13:00:00	NQ	Futures	5167.44	5177.5	5157.98	5174.24	16750.0
2015-07-08 14:00:00	NQ	Futures	5173.95	5176.31	5130.76	5138.16	40180.0
2015-07-08 15:00:00	NQ	Futures	5137.86	5159.16	5136.09	5139.64	59606.0
2015-07-08 16:00:00	NQ	Futures	5139.64	5148.21	5137.86	5142.59	10779.0
2015-07-08 17:00:00	NQ	Futures	5142.89	5145.85	5142.3	5145.85	243.0
2015-07-08 18:00:00	NQ	Futures	5144.07	5153.24	5144.07	5152.95	719.0
2015-07-08 19:00:00	NQ	Futures	5152.95	5156.2	5152.36	5155.31	477.0
2015-07-08 20:00:00	NQ	Futures	5155.31	5158.57	5142.89	5153.83	1602.0
2015-07-08 21:00:00	NQ	Futures	5155.02	5167.15	5153.54	5165.96	2164.0
2015-07-08 22:00:00	NQ	Futures	5165.96	5172.77	5162.71	5170.1	2605.0
2015-07-08 23:00:00	NQ	Futures	5170.4	5176.91	5168.03	5171.88	998.0
2015-07-08 00:00:00	YM	Futures	18500.9	18510.3	18480.9	18486.1	1252.0
2015-07-08 01:00:00	YM	Futures	18487.2	18519.8	18487.2	18491.4	1916.0

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

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