PREVIEW / futures_1hour / 2017-05-05

all futures 1-hour files

  file:    by_date/futures_1hour/2017/2017-05-05.parquet
  size:    47 KB
  rows:    1,393

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-05-05 00:00:00	ES	Futures	2600.32	2601.41	2599.23	2601.41	5661.0
2017-05-05 01:00:00	ES	Futures	2601.41	2602.51	2600.59	2602.23	4231.0
2017-05-05 02:00:00	ES	Futures	2602.23	2603.33	2601.14	2602.51	5443.0
2017-05-05 03:00:00	ES	Futures	2602.51	2606.33	2602.23	2604.96	14327.0
2017-05-05 04:00:00	ES	Futures	2604.96	2607.7	2604.42	2607.42	9132.0
2017-05-05 05:00:00	ES	Futures	2607.42	2607.97	2606.06	2607.15	8914.0
2017-05-05 06:00:00	ES	Futures	2607.15	2607.97	2606.6	2607.7	6427.0
2017-05-05 07:00:00	ES	Futures	2607.97	2608.24	2607.15	2607.42	8827.0
2017-05-05 08:00:00	ES	Futures	2607.42	2612.07	2606.06	2610.15	51237.0
2017-05-05 09:00:00	ES	Futures	2610.15	2612.89	2607.42	2607.7	134721.0
2017-05-05 10:00:00	ES	Futures	2607.97	2610.15	2605.78	2608.24	160330.0
2017-05-05 11:00:00	ES	Futures	2607.97	2610.7	2606.88	2610.15	100593.0
2017-05-05 12:00:00	ES	Futures	2610.15	2610.97	2606.33	2608.79	100731.0
2017-05-05 13:00:00	ES	Futures	2609.06	2610.7	2607.7	2610.7	54132.0
2017-05-05 14:00:00	ES	Futures	2610.43	2613.98	2609.88	2612.07	95586.0
2017-05-05 15:00:00	ES	Futures	2612.07	2617.53	2610.97	2617.53	221316.0
2017-05-05 16:00:00	ES	Futures	2617.26	2621.35	2616.16	2621.08	108245.0
2017-05-05 00:00:00	NQ	Futures	6695.04	6699.21	6693.25	6699.21	956.0
2017-05-05 01:00:00	NQ	Futures	6699.21	6700.7	6697.42	6699.21	918.0
2017-05-05 02:00:00	NQ	Futures	6699.21	6703.09	6697.42	6700.4	1252.0
2017-05-05 03:00:00	NQ	Futures	6700.1	6708.75	6699.51	6704.87	1843.0
2017-05-05 04:00:00	NQ	Futures	6705.17	6710.84	6703.38	6710.54	2042.0
2017-05-05 05:00:00	NQ	Futures	6710.54	6712.03	6707.86	6710.24	1335.0
2017-05-05 06:00:00	NQ	Futures	6709.94	6713.82	6709.65	6712.33	1277.0
2017-05-05 07:00:00	NQ	Futures	6712.33	6713.52	6710.54	6711.43	1168.0
2017-05-05 08:00:00	NQ	Futures	6710.84	6725.45	6707.86	6719.48	10170.0
2017-05-05 09:00:00	NQ	Futures	6719.48	6725.45	6708.45	6709.05	23509.0
2017-05-05 10:00:00	NQ	Futures	6709.05	6711.73	6697.72	6703.09	31346.0
2017-05-05 11:00:00	NQ	Futures	6703.09	6711.43	6698.91	6710.24	16715.0
2017-05-05 12:00:00	NQ	Futures	6710.24	6713.52	6702.79	6709.65	14010.0
2017-05-05 13:00:00	NQ	Futures	6709.94	6717.69	6708.75	6716.8	7974.0
2017-05-05 14:00:00	NQ	Futures	6716.5	6720.38	6711.43	6716.5	13022.0
2017-05-05 15:00:00	NQ	Futures	6716.5	6731.11	6713.52	6730.51	21986.0
2017-05-05 16:00:00	NQ	Futures	6730.81	6737.37	6729.02	6736.78	10330.0
2017-05-05 00:00:00	YM	Futures	22624.8	22638.9	22619.4	22638.9	1292.0
2017-05-05 01:00:00	YM	Futures	22638.9	22648.7	22629.2	22644.4	1365.0
2017-05-05 02:00:00	YM	Futures	22643.3	22652.0	22635.7	22642.2	1339.0
2017-05-05 03:00:00	YM	Futures	22641.1	22670.5	22640.0	22661.8	2707.0
2017-05-05 04:00:00	YM	Futures	22660.7	22680.2	22655.2	22675.9	1691.0
2017-05-05 05:00:00	YM	Futures	22675.9	22679.2	22662.9	22669.4	1398.0
2017-05-05 06:00:00	YM	Futures	22670.5	22675.9	22665.0	22675.9	1010.0
2017-05-05 07:00:00	YM	Futures	22675.9	22677.0	22661.8	22663.9	1259.0
2017-05-05 08:00:00	YM	Futures	22663.9	22696.5	22654.2	22678.1	7737.0
2017-05-05 09:00:00	YM	Futures	22677.0	22687.9	22655.2	22667.2	12280.0
2017-05-05 10:00:00	YM	Futures	22667.2	22688.9	22641.1	22666.1	13337.0
2017-05-05 11:00:00	YM	Futures	22665.0	22691.1	22658.5	22687.9	7881.0
2017-05-05 12:00:00	YM	Futures	22687.9	22694.4	22650.9	22678.1	6928.0
2017-05-05 13:00:00	YM	Futures	22678.1	22706.3	22671.6	22705.2	5013.0
2017-05-05 14:00:00	YM	Futures	22705.2	22732.4	22700.9	22715.0	8945.0
2017-05-05 15:00:00	YM	Futures	22715.0	22753.1	22706.3	22750.9	12024.0

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

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