PREVIEW / futures_1hour / 2017-06-19

all futures 1-hour files

  file:    by_date/futures_1hour/2017/2017-06-19.parquet
  size:    52 KB
  rows:    1,622

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
2017-06-19 00:00:00	ES	Futures	2663.42	2663.69	2662.6	2663.14	1946.0
2017-06-19 01:00:00	ES	Futures	2663.42	2663.69	2662.87	2663.42	1711.0
2017-06-19 02:00:00	ES	Futures	2663.42	2665.6	2663.14	2665.33	13650.0
2017-06-19 03:00:00	ES	Futures	2665.33	2668.06	2665.06	2665.33	30244.0
2017-06-19 04:00:00	ES	Futures	2665.33	2666.97	2664.78	2665.6	11382.0
2017-06-19 05:00:00	ES	Futures	2665.6	2666.97	2664.24	2665.06	12686.0
2017-06-19 06:00:00	ES	Futures	2665.06	2665.88	2664.24	2665.6	5493.0
2017-06-19 07:00:00	ES	Futures	2665.88	2666.97	2665.6	2666.42	11174.0
2017-06-19 08:00:00	ES	Futures	2666.7	2667.52	2665.06	2666.15	27163.0
2017-06-19 09:00:00	ES	Futures	2666.15	2671.07	2665.88	2670.8	165005.0
2017-06-19 10:00:00	ES	Futures	2670.8	2678.72	2670.52	2674.08	266080.0
2017-06-19 11:00:00	ES	Futures	2674.08	2675.99	2672.98	2675.17	112176.0
2017-06-19 12:00:00	ES	Futures	2675.44	2677.36	2675.17	2676.54	68086.0
2017-06-19 13:00:00	ES	Futures	2676.54	2679.54	2676.54	2676.81	74756.0
2017-06-19 14:00:00	ES	Futures	2676.81	2677.36	2673.8	2674.9	85118.0
2017-06-19 15:00:00	ES	Futures	2674.62	2680.36	2674.62	2679.0	186068.0
2017-06-19 16:00:00	ES	Futures	2679.0	2679.82	2675.44	2675.99	107164.0
2017-06-19 18:00:00	ES	Futures	2676.26	2677.63	2675.99	2677.08	3475.0
2017-06-19 19:00:00	ES	Futures	2677.08	2678.18	2676.26	2677.36	4178.0
2017-06-19 20:00:00	ES	Futures	2677.63	2679.27	2677.63	2677.9	6768.0
2017-06-19 21:00:00	ES	Futures	2677.9	2679.82	2677.63	2678.18	7015.0
2017-06-19 22:00:00	ES	Futures	2678.18	2678.72	2677.63	2677.9	2814.0
2017-06-19 23:00:00	ES	Futures	2678.18	2678.72	2678.18	2678.45	1106.0
2017-06-19 00:00:00	NQ	Futures	6798.55	6800.04	6796.17	6798.85	603.0
2017-06-19 01:00:00	NQ	Futures	6798.85	6799.15	6795.28	6796.17	733.0
2017-06-19 02:00:00	NQ	Futures	6795.87	6806.3	6795.58	6805.7	1956.0
2017-06-19 03:00:00	NQ	Futures	6805.7	6818.21	6805.4	6809.87	5277.0
2017-06-19 04:00:00	NQ	Futures	6810.17	6816.42	6808.98	6814.04	1911.0
2017-06-19 05:00:00	NQ	Futures	6814.04	6822.67	6809.57	6811.95	3137.0
2017-06-19 06:00:00	NQ	Futures	6811.66	6813.74	6808.98	6813.14	1092.0
2017-06-19 07:00:00	NQ	Futures	6813.44	6822.97	6813.14	6821.78	5442.0
2017-06-19 08:00:00	NQ	Futures	6821.78	6833.09	6819.99	6827.73	10196.0
2017-06-19 09:00:00	NQ	Futures	6828.03	6853.94	6822.08	6849.47	43001.0
2017-06-19 10:00:00	NQ	Futures	6848.87	6876.86	6848.87	6864.95	51834.0
2017-06-19 11:00:00	NQ	Futures	6864.95	6870.01	6861.68	6863.17	22687.0
2017-06-19 12:00:00	NQ	Futures	6863.46	6869.42	6858.4	6867.63	16966.0
2017-06-19 13:00:00	NQ	Futures	6867.93	6886.99	6866.14	6875.08	19141.0
2017-06-19 14:00:00	NQ	Futures	6875.08	6878.05	6859.59	6864.06	20046.0
2017-06-19 15:00:00	NQ	Futures	6864.06	6886.69	6861.68	6879.54	42079.0
2017-06-19 16:00:00	NQ	Futures	6879.54	6880.14	6865.85	6872.1	12612.0
2017-06-19 18:00:00	NQ	Futures	6868.23	6878.05	6868.23	6877.76	1539.0
2017-06-19 19:00:00	NQ	Futures	6877.76	6881.63	6874.48	6880.14	968.0
2017-06-19 20:00:00	NQ	Futures	6880.14	6886.69	6878.65	6880.73	1705.0
2017-06-19 21:00:00	NQ	Futures	6880.73	6887.58	6878.35	6882.22	2392.0
2017-06-19 22:00:00	NQ	Futures	6881.92	6883.71	6879.54	6882.52	944.0
2017-06-19 23:00:00	NQ	Futures	6882.82	6885.2	6882.52	6884.01	419.0
2017-06-19 00:00:00	YM	Futures	23267.4	23271.7	23253.2	23258.7	1264.0
2017-06-19 01:00:00	YM	Futures	23258.7	23263.0	23256.5	23258.7	508.0
2017-06-19 02:00:00	YM	Futures	23259.8	23285.9	23258.7	23280.5	2260.0
2017-06-19 03:00:00	YM	Futures	23280.5	23321.8	23278.3	23302.2	5715.0

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

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