PREVIEW / futures_1hour / 2017-05-25

all futures 1-hour files

  file:    by_date/futures_1hour/2017/2017-05-25.parquet
  size:    51 KB
  rows:    1,625

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-25 00:00:00	ES	Futures	2632.28	2632.28	2631.73	2631.73	2402.0
2017-05-25 01:00:00	ES	Futures	2632.01	2635.28	2631.73	2634.74	7411.0
2017-05-25 02:00:00	ES	Futures	2634.46	2635.83	2633.37	2634.19	12892.0
2017-05-25 03:00:00	ES	Futures	2633.92	2634.19	2629.82	2631.19	24884.0
2017-05-25 04:00:00	ES	Futures	2631.19	2631.46	2628.18	2630.91	27905.0
2017-05-25 05:00:00	ES	Futures	2630.91	2633.64	2630.64	2632.55	15041.0
2017-05-25 06:00:00	ES	Futures	2632.83	2633.1	2630.91	2631.73	11170.0
2017-05-25 07:00:00	ES	Futures	2631.46	2632.01	2629.27	2630.37	14409.0
2017-05-25 08:00:00	ES	Futures	2630.37	2632.01	2629.0	2631.46	22480.0
2017-05-25 09:00:00	ES	Futures	2631.46	2635.01	2628.73	2633.92	141056.0
2017-05-25 10:00:00	ES	Futures	2633.92	2638.01	2633.1	2636.65	170277.0
2017-05-25 11:00:00	ES	Futures	2636.38	2640.2	2633.92	2634.19	211732.0
2017-05-25 12:00:00	ES	Futures	2634.19	2639.11	2633.37	2639.11	131507.0
2017-05-25 13:00:00	ES	Futures	2638.83	2639.11	2635.56	2638.01	76249.0
2017-05-25 14:00:00	ES	Futures	2638.29	2640.2	2636.92	2638.83	82993.0
2017-05-25 15:00:00	ES	Futures	2638.83	2641.57	2636.1	2637.2	225975.0
2017-05-25 16:00:00	ES	Futures	2637.2	2637.47	2635.28	2636.92	74013.0
2017-05-25 18:00:00	ES	Futures	2636.38	2637.47	2634.46	2635.56	5358.0
2017-05-25 19:00:00	ES	Futures	2635.56	2636.65	2635.01	2636.38	3146.0
2017-05-25 20:00:00	ES	Futures	2636.38	2636.65	2634.74	2635.28	4828.0
2017-05-25 21:00:00	ES	Futures	2635.28	2637.2	2635.28	2636.1	4133.0
2017-05-25 22:00:00	ES	Futures	2636.1	2636.1	2633.64	2634.46	7086.0
2017-05-25 23:00:00	ES	Futures	2634.46	2635.28	2634.19	2635.28	2222.0
2017-05-25 00:00:00	NQ	Futures	6859.01	6859.31	6857.52	6857.52	432.0
2017-05-25 01:00:00	NQ	Futures	6857.82	6867.96	6857.82	6864.68	1830.0
2017-05-25 02:00:00	NQ	Futures	6864.68	6866.17	6860.8	6864.38	2261.0
2017-05-25 03:00:00	NQ	Futures	6864.08	6865.27	6852.45	6855.73	4150.0
2017-05-25 04:00:00	NQ	Futures	6855.73	6856.63	6846.19	6853.94	5478.0
2017-05-25 05:00:00	NQ	Futures	6853.94	6860.8	6853.94	6858.72	2642.0
2017-05-25 06:00:00	NQ	Futures	6858.72	6862.29	6856.33	6858.42	2052.0
2017-05-25 07:00:00	NQ	Futures	6858.42	6859.61	6854.24	6856.93	2992.0
2017-05-25 08:00:00	NQ	Futures	6856.63	6864.38	6854.24	6863.19	6021.0
2017-05-25 09:00:00	NQ	Futures	6863.49	6863.49	6846.49	6859.91	32497.0
2017-05-25 10:00:00	NQ	Futures	6859.91	6881.37	6857.22	6878.99	35429.0
2017-05-25 11:00:00	NQ	Futures	6878.69	6892.11	6877.8	6884.95	32449.0
2017-05-25 12:00:00	NQ	Futures	6884.95	6903.14	6881.97	6902.84	23974.0
2017-05-25 13:00:00	NQ	Futures	6902.84	6903.14	6895.68	6902.24	15896.0
2017-05-25 14:00:00	NQ	Futures	6902.24	6911.49	6901.65	6907.91	18424.0
2017-05-25 15:00:00	NQ	Futures	6908.21	6908.21	6890.62	6893.3	32885.0
2017-05-25 16:00:00	NQ	Futures	6893.3	6898.67	6892.11	6896.88	5508.0
2017-05-25 18:00:00	NQ	Futures	6894.49	6898.67	6892.11	6894.19	1336.0
2017-05-25 19:00:00	NQ	Futures	6894.49	6898.07	6893.6	6897.47	726.0
2017-05-25 20:00:00	NQ	Futures	6897.18	6897.77	6894.19	6896.58	948.0
2017-05-25 21:00:00	NQ	Futures	6896.58	6902.84	6895.39	6899.56	2178.0
2017-05-25 22:00:00	NQ	Futures	6899.56	6899.56	6893.3	6894.79	2519.0
2017-05-25 23:00:00	NQ	Futures	6894.79	6898.67	6894.79	6898.37	532.0
2017-05-25 00:00:00	YM	Futures	22885.6	22887.8	22882.4	22883.5	535.0
2017-05-25 01:00:00	YM	Futures	22883.5	22915.0	22883.5	22906.3	1774.0
2017-05-25 02:00:00	YM	Futures	22905.2	22916.1	22896.5	22903.0	2278.0
2017-05-25 03:00:00	YM	Futures	22903.0	22907.4	22873.7	22884.6	3808.0

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

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