PREVIEW / futures_1hour / 2016-06-13

all futures 1-hour files

  file:    by_date/futures_1hour/2016/2016-06-13.parquet
  size:    52 KB
  rows:    1,594

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
2016-06-13 00:00:00	ES	Futures	2254.6	2254.87	2253.79	2254.33	1036.0
2016-06-13 01:00:00	ES	Futures	2254.06	2256.76	2254.06	2254.87	3220.0
2016-06-13 02:00:00	ES	Futures	2254.87	2256.22	2252.98	2255.14	6288.0
2016-06-13 03:00:00	ES	Futures	2254.87	2260.0	2254.33	2258.38	14881.0
2016-06-13 04:00:00	ES	Futures	2258.11	2261.35	2255.41	2255.95	8583.0
2016-06-13 05:00:00	ES	Futures	2256.22	2256.49	2253.79	2254.87	6026.0
2016-06-13 06:00:00	ES	Futures	2254.87	2255.95	2254.06	2254.87	3200.0
2016-06-13 07:00:00	ES	Futures	2254.87	2259.19	2254.87	2257.57	6721.0
2016-06-13 08:00:00	ES	Futures	2257.3	2258.38	2255.41	2256.22	10651.0
2016-06-13 09:00:00	ES	Futures	2256.22	2263.24	2252.71	2261.35	72483.0
2016-06-13 10:00:00	ES	Futures	2261.35	2265.94	2258.65	2261.62	72634.0
2016-06-13 11:00:00	ES	Futures	2261.62	2262.43	2251.9	2252.44	57597.0
2016-06-13 12:00:00	ES	Futures	2252.44	2259.19	2251.63	2257.57	38491.0
2016-06-13 13:00:00	ES	Futures	2257.57	2258.65	2250.82	2251.9	24353.0
2016-06-13 14:00:00	ES	Futures	2252.17	2256.22	2250.55	2252.17	24102.0
2016-06-13 15:00:00	ES	Futures	2252.17	2252.71	2243.8	2244.88	69118.0
2016-06-13 16:00:00	ES	Futures	2245.15	2247.04	2241.64	2241.91	28998.0
2016-06-13 18:00:00	ES	Futures	2242.99	2242.99	2238.67	2239.75	4634.0
2016-06-13 19:00:00	ES	Futures	2240.02	2242.72	2239.75	2241.1	1712.0
2016-06-13 20:00:00	ES	Futures	2241.1	2245.69	2241.1	2243.53	4180.0
2016-06-13 21:00:00	ES	Futures	2243.53	2245.15	2242.45	2243.8	2287.0
2016-06-13 22:00:00	ES	Futures	2244.07	2244.61	2242.99	2243.53	1334.0
2016-06-13 23:00:00	ES	Futures	2243.8	2245.42	2243.26	2245.42	2036.0
2016-06-13 00:00:00	NQ	Futures	5293.65	5294.84	5291.86	5293.05	100.0
2016-06-13 01:00:00	NQ	Futures	5293.05	5298.11	5292.46	5294.84	150.0
2016-06-13 02:00:00	NQ	Futures	5292.76	5299.0	5284.72	5294.84	502.0
2016-06-13 03:00:00	NQ	Futures	5295.43	5304.95	5290.97	5300.79	1055.0
2016-06-13 04:00:00	NQ	Futures	5300.79	5307.93	5292.76	5294.24	646.0
2016-06-13 05:00:00	NQ	Futures	5293.35	5294.54	5287.4	5289.19	593.0
2016-06-13 06:00:00	NQ	Futures	5290.38	5293.05	5286.81	5289.19	397.0
2016-06-13 07:00:00	NQ	Futures	5289.48	5295.14	5289.19	5290.67	562.0
2016-06-13 08:00:00	NQ	Futures	5290.67	5293.65	5281.15	5285.02	1872.0
2016-06-13 09:00:00	NQ	Futures	5285.32	5304.66	5276.99	5299.6	11957.0
2016-06-13 10:00:00	NQ	Futures	5299.6	5310.01	5289.19	5296.33	8822.0
2016-06-13 11:00:00	NQ	Futures	5296.92	5301.09	5269.25	5270.74	7719.0
2016-06-13 12:00:00	NQ	Futures	5270.74	5290.67	5268.06	5286.21	5052.0
2016-06-13 13:00:00	NQ	Futures	5286.51	5288.59	5272.52	5274.61	2966.0
2016-06-13 14:00:00	NQ	Futures	5274.31	5292.16	5271.33	5281.15	3099.0
2016-06-13 15:00:00	NQ	Futures	5281.15	5283.83	5259.43	5265.98	6845.0
2016-06-13 16:00:00	NQ	Futures	5266.28	5271.63	5260.33	5262.71	1234.0
2016-06-13 18:00:00	NQ	Futures	5259.43	5261.22	5252.89	5255.27	180.0
2016-06-13 19:00:00	NQ	Futures	5255.56	5262.41	5255.27	5260.33	113.0
2016-06-13 20:00:00	NQ	Futures	5260.62	5268.66	5258.54	5264.19	221.0
2016-06-13 21:00:00	NQ	Futures	5263.3	5266.87	5261.52	5263.9	183.0
2016-06-13 22:00:00	NQ	Futures	5263.6	5265.68	5262.41	5263.3	122.0
2016-06-13 23:00:00	NQ	Futures	5263.3	5267.76	5262.71	5267.76	81.0
2016-06-13 00:00:00	YM	Futures	19056.4	19058.5	19049.9	19052.1	290.0
2016-06-13 01:00:00	YM	Futures	19053.1	19068.2	19051.0	19052.1	918.0
2016-06-13 02:00:00	YM	Futures	19051.0	19060.7	19039.1	19052.1	2232.0
2016-06-13 03:00:00	YM	Futures	19052.1	19087.6	19047.8	19076.8	5433.0

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

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