PREVIEW / futures_1hour / 2017-07-06

all futures 1-hour files

  file:    by_date/futures_1hour/2017/2017-07-06.parquet
  size:    53 KB
  rows:    1,613

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-07-06 00:00:00	ES	Futures	2653.58	2654.12	2653.3	2653.58	1819.0
2017-07-06 01:00:00	ES	Futures	2653.85	2654.12	2652.76	2653.3	4103.0
2017-07-06 02:00:00	ES	Futures	2653.58	2654.12	2652.48	2652.76	6775.0
2017-07-06 03:00:00	ES	Futures	2652.76	2653.85	2649.75	2650.84	22636.0
2017-07-06 04:00:00	ES	Futures	2650.84	2653.03	2650.57	2651.94	10680.0
2017-07-06 05:00:00	ES	Futures	2651.94	2652.21	2645.92	2645.92	29782.0
2017-07-06 06:00:00	ES	Futures	2646.2	2646.47	2641.55	2645.92	32911.0
2017-07-06 07:00:00	ES	Futures	2645.92	2645.92	2641.82	2642.64	29287.0
2017-07-06 08:00:00	ES	Futures	2642.64	2646.74	2642.64	2646.2	38018.0
2017-07-06 09:00:00	ES	Futures	2646.47	2648.38	2639.36	2640.18	232577.0
2017-07-06 10:00:00	ES	Futures	2640.46	2642.64	2635.26	2639.64	275144.0
2017-07-06 11:00:00	ES	Futures	2639.64	2645.38	2639.64	2645.1	154386.0
2017-07-06 12:00:00	ES	Futures	2644.83	2645.92	2641.0	2644.28	82995.0
2017-07-06 13:00:00	ES	Futures	2644.28	2647.56	2640.46	2641.28	94659.0
2017-07-06 14:00:00	ES	Futures	2641.28	2641.28	2635.54	2638.27	131510.0
2017-07-06 15:00:00	ES	Futures	2638.27	2638.54	2629.8	2632.8	316002.0
2017-07-06 16:00:00	ES	Futures	2632.53	2634.72	2632.53	2633.35	98531.0
2017-07-06 18:00:00	ES	Futures	2634.17	2635.81	2633.9	2635.26	6068.0
2017-07-06 19:00:00	ES	Futures	2634.99	2635.54	2633.62	2634.44	2788.0
2017-07-06 20:00:00	ES	Futures	2634.44	2635.81	2634.17	2635.26	5291.0
2017-07-06 21:00:00	ES	Futures	2635.26	2636.63	2634.72	2635.54	6934.0
2017-07-06 22:00:00	ES	Futures	2635.26	2636.36	2635.26	2635.54	3340.0
2017-07-06 23:00:00	ES	Futures	2635.54	2635.81	2634.44	2634.72	2198.0
2017-07-06 00:00:00	NQ	Futures	6714.89	6718.76	6713.7	6718.76	471.0
2017-07-06 01:00:00	NQ	Futures	6718.46	6726.2	6716.08	6723.82	1271.0
2017-07-06 02:00:00	NQ	Futures	6724.12	6726.8	6718.16	6726.2	1398.0
2017-07-06 03:00:00	NQ	Futures	6726.2	6729.18	6706.85	6713.99	3672.0
2017-07-06 04:00:00	NQ	Futures	6713.1	6719.95	6711.31	6713.7	1613.0
2017-07-06 05:00:00	NQ	Futures	6713.7	6714.29	6682.73	6684.22	5880.0
2017-07-06 06:00:00	NQ	Futures	6684.22	6688.98	6673.2	6688.09	6830.0
2017-07-06 07:00:00	NQ	Futures	6688.09	6688.68	6660.1	6663.67	7524.0
2017-07-06 08:00:00	NQ	Futures	6663.67	6683.92	6660.1	6680.35	10887.0
2017-07-06 09:00:00	NQ	Futures	6680.35	6693.75	6658.02	6669.63	64572.0
2017-07-06 10:00:00	NQ	Futures	6669.63	6677.07	6645.81	6664.27	67834.0
2017-07-06 11:00:00	NQ	Futures	6664.57	6698.81	6659.8	6691.36	45413.0
2017-07-06 12:00:00	NQ	Futures	6691.07	6707.74	6681.54	6701.19	32269.0
2017-07-06 13:00:00	NQ	Futures	6701.19	6706.55	6686.3	6690.17	22657.0
2017-07-06 14:00:00	NQ	Futures	6690.47	6691.36	6672.01	6681.54	30510.0
2017-07-06 15:00:00	NQ	Futures	6681.84	6683.92	6660.4	6670.82	49225.0
2017-07-06 16:00:00	NQ	Futures	6670.52	6674.39	6663.67	6666.35	6422.0
2017-07-06 18:00:00	NQ	Futures	6667.84	6673.8	6667.84	6672.61	646.0
2017-07-06 19:00:00	NQ	Futures	6672.31	6674.69	6669.93	6672.31	409.0
2017-07-06 20:00:00	NQ	Futures	6671.41	6678.86	6671.12	6675.88	1117.0
2017-07-06 21:00:00	NQ	Futures	6676.18	6680.64	6672.61	6679.16	1259.0
2017-07-06 22:00:00	NQ	Futures	6679.16	6686.6	6678.86	6680.64	1864.0
2017-07-06 23:00:00	NQ	Futures	6680.35	6682.13	6678.56	6680.05	472.0
2017-07-06 00:00:00	YM	Futures	23306.6	23313.1	23305.5	23309.8	267.0
2017-07-06 01:00:00	YM	Futures	23310.9	23318.5	23305.5	23317.5	986.0
2017-07-06 02:00:00	YM	Futures	23315.3	23318.5	23308.8	23310.9	1075.0
2017-07-06 03:00:00	YM	Futures	23310.9	23317.5	23293.5	23300.0	3126.0

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

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