PREVIEW / futures_1hour / 2015-07-15

all futures 1-hour files

  file:    by_date/futures_1hour/2015/2015-07-15.parquet
  size:    51 KB
  rows:    1,547

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-15 00:00:00	ES	Futures	2241.81	2241.81	2239.95	2240.21	2722.0
2015-07-15 01:00:00	ES	Futures	2240.21	2241.81	2239.15	2240.75	3446.0
2015-07-15 02:00:00	ES	Futures	2240.75	2241.81	2239.95	2241.54	6423.0
2015-07-15 03:00:00	ES	Futures	2241.54	2242.08	2238.62	2239.41	14439.0
2015-07-15 04:00:00	ES	Futures	2239.41	2241.28	2238.88	2240.75	10049.0
2015-07-15 05:00:00	ES	Futures	2241.01	2241.01	2239.68	2240.21	6356.0
2015-07-15 06:00:00	ES	Futures	2239.95	2240.75	2239.41	2239.95	8045.0
2015-07-15 07:00:00	ES	Futures	2239.95	2241.28	2239.95	2240.75	13428.0
2015-07-15 08:00:00	ES	Futures	2240.75	2241.01	2238.62	2239.15	22388.0
2015-07-15 09:00:00	ES	Futures	2239.15	2241.28	2236.22	2239.95	145540.0
2015-07-15 10:00:00	ES	Futures	2239.68	2243.94	2238.35	2242.61	137862.0
2015-07-15 11:00:00	ES	Futures	2242.88	2244.74	2239.68	2240.48	110976.0
2015-07-15 12:00:00	ES	Futures	2240.48	2241.81	2238.88	2239.95	77009.0
2015-07-15 13:00:00	ES	Futures	2239.95	2242.61	2238.88	2240.75	70111.0
2015-07-15 14:00:00	ES	Futures	2240.75	2241.81	2231.16	2233.56	159372.0
2015-07-15 15:00:00	ES	Futures	2233.82	2238.08	2232.49	2237.55	242451.0
2015-07-15 16:00:00	ES	Futures	2237.55	2241.54	2236.49	2241.28	75108.0
2015-07-15 17:00:00	ES	Futures	2241.28	2242.61	2241.01	2242.08	4062.0
2015-07-15 18:00:00	ES	Futures	2240.75	2245.27	2239.41	2244.21	8650.0
2015-07-15 19:00:00	ES	Futures	2244.21	2245.8	2243.14	2243.67	5964.0
2015-07-15 20:00:00	ES	Futures	2243.67	2243.94	2242.34	2243.67	4398.0
2015-07-15 21:00:00	ES	Futures	2243.67	2245.27	2243.41	2245.01	3389.0
2015-07-15 22:00:00	ES	Futures	2245.01	2249.8	2244.74	2248.73	11132.0
2015-07-15 23:00:00	ES	Futures	2249.0	2249.0	2246.87	2247.4	3532.0
2015-07-15 00:00:00	NQ	Futures	5354.38	5355.86	5351.42	5351.72	404.0
2015-07-15 01:00:00	NQ	Futures	5352.31	5353.79	5349.65	5352.31	374.0
2015-07-15 02:00:00	NQ	Futures	5352.31	5353.79	5349.94	5353.49	467.0
2015-07-15 03:00:00	NQ	Futures	5353.79	5356.45	5346.99	5348.76	1314.0
2015-07-15 04:00:00	NQ	Futures	5348.76	5356.45	5348.17	5355.56	1234.0
2015-07-15 05:00:00	NQ	Futures	5355.56	5356.75	5354.08	5355.27	932.0
2015-07-15 06:00:00	NQ	Futures	5354.97	5357.04	5354.08	5355.27	1347.0
2015-07-15 07:00:00	NQ	Futures	5355.56	5357.63	5354.68	5356.15	2928.0
2015-07-15 08:00:00	NQ	Futures	5356.45	5357.63	5352.9	5354.38	3588.0
2015-07-15 09:00:00	NQ	Futures	5354.68	5365.62	5347.28	5364.44	27691.0
2015-07-15 10:00:00	NQ	Futures	5364.44	5368.87	5355.56	5365.32	23030.0
2015-07-15 11:00:00	NQ	Futures	5365.32	5370.94	5357.04	5360.59	18671.0
2015-07-15 12:00:00	NQ	Futures	5360.3	5365.03	5354.08	5358.52	13199.0
2015-07-15 13:00:00	NQ	Futures	5358.23	5364.14	5354.97	5356.75	9184.0
2015-07-15 14:00:00	NQ	Futures	5357.04	5360.3	5335.15	5342.84	27810.0
2015-07-15 15:00:00	NQ	Futures	5342.84	5350.83	5337.82	5350.83	35660.0
2015-07-15 16:00:00	NQ	Futures	5350.83	5370.35	5347.58	5366.8	12435.0
2015-07-15 17:00:00	NQ	Futures	5366.8	5370.06	5366.51	5367.69	921.0
2015-07-15 18:00:00	NQ	Futures	5365.03	5374.79	5360.89	5371.24	1401.0
2015-07-15 19:00:00	NQ	Futures	5371.83	5374.79	5370.65	5371.24	925.0
2015-07-15 20:00:00	NQ	Futures	5371.24	5372.72	5367.99	5371.83	612.0
2015-07-15 21:00:00	NQ	Futures	5372.13	5375.68	5370.65	5374.49	552.0
2015-07-15 22:00:00	NQ	Futures	5375.09	5387.51	5374.49	5385.14	2208.0
2015-07-15 23:00:00	NQ	Futures	5384.85	5385.14	5378.34	5380.71	948.0
2015-07-15 00:00:00	YM	Futures	18945.4	18947.5	18932.8	18933.8	465.0
2015-07-15 01:00:00	YM	Futures	18934.9	18944.4	18928.6	18935.9	463.0

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

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