PREVIEW / futures_1hour / 2016-09-12

all futures 1-hour files

  file:    by_date/futures_1hour/2016/2016-09-12.parquet
  size:    51 KB
  rows:    1,555

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-09-12 00:00:00	ES	Futures	2288.27	2291.53	2287.46	2290.98	3824.0
2016-09-12 01:00:00	ES	Futures	2290.98	2291.8	2288.54	2290.98	3804.0
2016-09-12 02:00:00	ES	Futures	2290.98	2294.51	2288.54	2290.44	11369.0
2016-09-12 03:00:00	ES	Futures	2290.44	2293.69	2285.56	2288.27	26851.0
2016-09-12 04:00:00	ES	Futures	2288.27	2290.44	2285.83	2288.81	19038.0
2016-09-12 05:00:00	ES	Futures	2289.08	2291.53	2286.92	2288.0	13232.0
2016-09-12 06:00:00	ES	Futures	2288.0	2289.36	2286.1	2288.81	9142.0
2016-09-12 07:00:00	ES	Futures	2288.81	2295.59	2286.64	2294.51	22015.0
2016-09-12 08:00:00	ES	Futures	2294.78	2300.47	2293.15	2298.58	43938.0
2016-09-12 09:00:00	ES	Futures	2298.3	2311.59	2296.68	2309.15	125542.0
2016-09-12 10:00:00	ES	Futures	2309.15	2317.29	2308.34	2314.3	101666.0
2016-09-12 11:00:00	ES	Futures	2314.58	2321.9	2313.76	2320.0	57077.0
2016-09-12 12:00:00	ES	Futures	2320.0	2326.51	2317.56	2325.69	35579.0
2016-09-12 13:00:00	ES	Futures	2325.69	2332.75	2318.37	2331.39	89942.0
2016-09-12 14:00:00	ES	Futures	2331.39	2343.59	2330.85	2340.61	69243.0
2016-09-12 15:00:00	ES	Futures	2340.34	2346.03	2338.71	2340.34	88952.0
2016-09-12 16:00:00	ES	Futures	2340.34	2343.59	2339.53	2341.15	33150.0
2016-09-12 18:00:00	ES	Futures	2338.98	2340.34	2336.27	2337.9	2463.0
2016-09-12 19:00:00	ES	Futures	2337.9	2339.8	2337.63	2338.71	971.0
2016-09-12 20:00:00	ES	Futures	2338.71	2339.53	2335.46	2336.27	2315.0
2016-09-12 21:00:00	ES	Futures	2336.0	2337.08	2333.56	2334.37	3793.0
2016-09-12 22:00:00	ES	Futures	2334.37	2335.73	2333.02	2335.46	1557.0
2016-09-12 23:00:00	ES	Futures	2335.19	2335.73	2334.1	2334.37	1002.0
2016-09-12 00:00:00	NQ	Futures	5532.43	5540.18	5530.35	5539.88	385.0
2016-09-12 01:00:00	NQ	Futures	5539.59	5541.08	5530.64	5535.71	519.0
2016-09-12 02:00:00	NQ	Futures	5535.71	5545.85	5530.35	5535.41	2029.0
2016-09-12 03:00:00	NQ	Futures	5535.41	5543.46	5522.9	5527.96	2414.0
2016-09-12 04:00:00	NQ	Futures	5528.26	5533.03	5520.81	5527.07	1388.0
2016-09-12 05:00:00	NQ	Futures	5527.66	5534.22	5522.0	5524.09	1308.0
2016-09-12 06:00:00	NQ	Futures	5523.49	5526.77	5518.72	5525.28	575.0
2016-09-12 07:00:00	NQ	Futures	5525.58	5543.76	5522.0	5541.67	1142.0
2016-09-12 08:00:00	NQ	Futures	5541.37	5557.17	5538.99	5553.3	2532.0
2016-09-12 09:00:00	NQ	Futures	5552.7	5601.58	5548.53	5598.3	19587.0
2016-09-12 10:00:00	NQ	Futures	5597.71	5623.04	5597.71	5621.55	16894.0
2016-09-12 11:00:00	NQ	Futures	5621.85	5641.82	5620.95	5636.45	9586.0
2016-09-12 12:00:00	NQ	Futures	5635.86	5650.16	5627.81	5646.59	5952.0
2016-09-12 13:00:00	NQ	Futures	5646.59	5663.87	5629.6	5660.3	10333.0
2016-09-12 14:00:00	NQ	Futures	5659.7	5683.25	5658.51	5675.8	6959.0
2016-09-12 15:00:00	NQ	Futures	5676.39	5689.21	5671.62	5679.67	10330.0
2016-09-12 16:00:00	NQ	Futures	5679.67	5688.02	5679.37	5682.05	1875.0
2016-09-12 18:00:00	NQ	Futures	5678.78	5680.56	5671.03	5675.2	256.0
2016-09-12 19:00:00	NQ	Futures	5675.5	5680.27	5674.9	5678.48	120.0
2016-09-12 20:00:00	NQ	Futures	5678.18	5679.97	5671.03	5672.52	238.0
2016-09-12 21:00:00	NQ	Futures	5672.22	5672.52	5665.96	5667.15	174.0
2016-09-12 22:00:00	NQ	Futures	5668.34	5670.73	5661.79	5670.13	535.0
2016-09-12 23:00:00	NQ	Futures	5669.54	5669.83	5665.07	5666.26	108.0
2016-09-12 00:00:00	YM	Futures	19291.6	19320.8	19283.0	19319.7	1438.0
2016-09-12 01:00:00	YM	Futures	19318.6	19325.1	19292.7	19312.1	1665.0
2016-09-12 02:00:00	YM	Futures	19313.2	19338.1	19293.8	19308.9	4540.0
2016-09-12 03:00:00	YM	Futures	19308.9	19334.8	19261.4	19294.9	11041.0

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

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