PREVIEW / futures_1hour / 2016-01-04

all futures 1-hour files

  file:    by_date/futures_1hour/2016/2016-01-04.parquet
  size:    54 KB
  rows:    1,629

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-01-04 00:00:00	ES	Futures	2169.29	2173.05	2167.68	2171.44	11331.0
2016-01-04 01:00:00	ES	Futures	2171.71	2173.05	2166.06	2168.48	8606.0
2016-01-04 02:00:00	ES	Futures	2168.48	2169.83	2159.61	2163.65	19897.0
2016-01-04 03:00:00	ES	Futures	2163.65	2166.06	2150.75	2156.66	49408.0
2016-01-04 04:00:00	ES	Futures	2156.66	2160.69	2152.9	2154.51	30287.0
2016-01-04 05:00:00	ES	Futures	2154.51	2157.73	2153.43	2157.2	16151.0
2016-01-04 06:00:00	ES	Futures	2156.93	2157.46	2147.52	2147.79	34245.0
2016-01-04 07:00:00	ES	Futures	2148.06	2151.55	2144.3	2149.94	36037.0
2016-01-04 08:00:00	ES	Futures	2150.21	2153.7	2147.25	2148.06	47556.0
2016-01-04 09:00:00	ES	Futures	2148.33	2150.75	2139.46	2146.18	295446.0
2016-01-04 10:00:00	ES	Futures	2146.18	2147.25	2134.09	2134.62	353876.0
2016-01-04 11:00:00	ES	Futures	2134.62	2139.19	2128.44	2137.04	301350.0
2016-01-04 12:00:00	ES	Futures	2137.31	2143.76	2134.36	2141.34	153117.0
2016-01-04 13:00:00	ES	Futures	2141.61	2146.72	2140.27	2142.69	149987.0
2016-01-04 14:00:00	ES	Futures	2142.69	2145.37	2135.97	2139.19	161128.0
2016-01-04 15:00:00	ES	Futures	2139.19	2155.05	2132.47	2154.78	347817.0
2016-01-04 16:00:00	ES	Futures	2154.78	2160.42	2153.43	2159.88	120987.0
2016-01-04 18:00:00	ES	Futures	2159.35	2163.38	2159.35	2163.11	9898.0
2016-01-04 19:00:00	ES	Futures	2162.84	2164.18	2161.23	2161.76	10250.0
2016-01-04 20:00:00	ES	Futures	2161.76	2166.6	2160.15	2165.26	16849.0
2016-01-04 21:00:00	ES	Futures	2165.26	2165.53	2162.84	2165.53	7197.0
2016-01-04 22:00:00	ES	Futures	2165.26	2167.94	2164.45	2164.99	7851.0
2016-01-04 23:00:00	ES	Futures	2164.72	2165.79	2161.76	2162.84	5429.0
2016-01-04 00:00:00	NQ	Futures	5396.13	5405.04	5389.6	5397.62	3192.0
2016-01-04 01:00:00	NQ	Futures	5398.51	5402.67	5386.93	5394.65	1881.0
2016-01-04 02:00:00	NQ	Futures	5394.35	5397.02	5371.19	5379.8	3775.0
2016-01-04 03:00:00	NQ	Futures	5380.1	5387.23	5343.58	5361.69	10839.0
2016-01-04 04:00:00	NQ	Futures	5361.99	5370.89	5353.38	5355.75	4104.0
2016-01-04 05:00:00	NQ	Futures	5356.05	5363.17	5349.52	5359.61	3154.0
2016-01-04 06:00:00	NQ	Futures	5359.31	5362.58	5332.89	5334.67	6904.0
2016-01-04 07:00:00	NQ	Futures	5334.07	5340.9	5325.46	5337.04	5403.0
2016-01-04 08:00:00	NQ	Futures	5337.34	5346.25	5328.73	5329.03	9358.0
2016-01-04 09:00:00	NQ	Futures	5329.03	5331.7	5296.66	5310.02	59118.0
2016-01-04 10:00:00	NQ	Futures	5309.43	5310.32	5276.17	5277.36	65009.0
2016-01-04 11:00:00	NQ	Futures	5277.66	5299.04	5261.33	5292.8	47128.0
2016-01-04 12:00:00	NQ	Futures	5293.1	5307.65	5282.11	5303.19	22416.0
2016-01-04 13:00:00	NQ	Futures	5303.79	5315.07	5299.63	5304.68	22168.0
2016-01-04 14:00:00	NQ	Futures	5304.68	5312.99	5283.0	5292.21	20258.0
2016-01-04 15:00:00	NQ	Futures	5292.8	5333.48	5269.94	5332.89	49282.0
2016-01-04 16:00:00	NQ	Futures	5332.89	5357.24	5331.4	5352.19	14210.0
2016-01-04 18:00:00	NQ	Futures	5351.3	5359.61	5342.69	5356.94	1511.0
2016-01-04 19:00:00	NQ	Futures	5356.64	5359.91	5353.08	5353.38	1352.0
2016-01-04 20:00:00	NQ	Futures	5353.67	5370.3	5351.89	5366.74	3233.0
2016-01-04 21:00:00	NQ	Futures	5367.03	5367.92	5361.69	5366.74	1537.0
2016-01-04 22:00:00	NQ	Futures	5366.74	5372.08	5364.66	5364.66	1271.0
2016-01-04 23:00:00	NQ	Futures	5364.66	5367.33	5358.72	5362.28	1176.0
2016-01-04 00:00:00	YM	Futures	18292.0	18317.5	18278.2	18304.8	3164.0
2016-01-04 01:00:00	YM	Futures	18306.9	18317.5	18260.1	18277.1	2176.0
2016-01-04 02:00:00	YM	Futures	18278.2	18290.9	18211.1	18234.5	4394.0
2016-01-04 03:00:00	YM	Futures	18235.6	18254.7	18131.3	18173.8	10685.0

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

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