PREVIEW / futures_1hour / 2017-06-13

all futures 1-hour files

  file:    by_date/futures_1hour/2017/2017-06-13.parquet
  size:    49 KB
  rows:    1,596

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-13 00:00:00	ES	Futures	2656.86	2657.68	2656.59	2656.86	381.0
2017-06-13 01:00:00	ES	Futures	2657.13	2657.41	2656.86	2657.41	589.0
2017-06-13 02:00:00	ES	Futures	2657.13	2659.32	2656.32	2657.95	3311.0
2017-06-13 03:00:00	ES	Futures	2657.95	2661.23	2657.41	2659.59	7160.0
2017-06-13 04:00:00	ES	Futures	2659.32	2660.14	2658.5	2659.59	4131.0
2017-06-13 05:00:00	ES	Futures	2659.32	2659.59	2657.13	2658.23	3325.0
2017-06-13 06:00:00	ES	Futures	2658.23	2658.5	2657.41	2657.95	2335.0
2017-06-13 07:00:00	ES	Futures	2657.68	2657.95	2657.13	2657.41	2839.0
2017-06-13 08:00:00	ES	Futures	2657.41	2659.87	2657.13	2659.59	5007.0
2017-06-13 09:00:00	ES	Futures	2659.59	2663.69	2659.32	2661.23	41236.0
2017-06-13 10:00:00	ES	Futures	2661.23	2662.32	2656.86	2656.86	34449.0
2017-06-13 11:00:00	ES	Futures	2656.86	2663.14	2656.04	2662.32	26863.0
2017-06-13 12:00:00	ES	Futures	2662.05	2664.78	2660.96	2664.51	14609.0
2017-06-13 13:00:00	ES	Futures	2664.51	2665.88	2662.05	2664.24	12789.0
2017-06-13 14:00:00	ES	Futures	2663.96	2666.42	2663.14	2664.24	16958.0
2017-06-13 15:00:00	ES	Futures	2663.96	2667.51	2663.14	2666.15	44191.0
2017-06-13 16:00:00	ES	Futures	2666.15	2666.97	2664.78	2666.15	13578.0
2017-06-13 18:00:00	ES	Futures	2666.15	2666.42	2665.88	2665.88	821.0
2017-06-13 19:00:00	ES	Futures	2666.15	2666.15	2665.6	2665.88	555.0
2017-06-13 20:00:00	ES	Futures	2665.6	2666.15	2665.06	2665.06	1229.0
2017-06-13 21:00:00	ES	Futures	2665.06	2665.06	2664.24	2664.24	1047.0
2017-06-13 22:00:00	ES	Futures	2664.51	2665.06	2662.87	2663.69	989.0
2017-06-13 23:00:00	ES	Futures	2663.42	2664.24	2662.87	2662.87	536.0
2017-06-13 00:00:00	NQ	Futures	6823.24	6830.39	6822.64	6827.11	653.0
2017-06-13 01:00:00	NQ	Futures	6827.41	6829.8	6827.11	6829.5	232.0
2017-06-13 02:00:00	NQ	Futures	6828.9	6832.48	6827.71	6829.2	512.0
2017-06-13 03:00:00	NQ	Futures	6829.5	6834.86	6827.11	6828.3	1170.0
2017-06-13 04:00:00	NQ	Futures	6828.3	6829.8	6824.73	6827.11	718.0
2017-06-13 05:00:00	NQ	Futures	6827.11	6828.3	6818.76	6823.53	549.0
2017-06-13 06:00:00	NQ	Futures	6823.53	6826.52	6822.94	6825.03	236.0
2017-06-13 07:00:00	NQ	Futures	6825.03	6831.88	6820.85	6831.88	678.0
2017-06-13 08:00:00	NQ	Futures	6831.29	6840.53	6831.29	6836.95	1336.0
2017-06-13 09:00:00	NQ	Futures	6837.25	6868.85	6836.06	6857.22	17844.0
2017-06-13 10:00:00	NQ	Futures	6857.22	6858.12	6814.29	6816.08	19268.0
2017-06-13 11:00:00	NQ	Futures	6815.78	6846.79	6807.14	6846.49	12953.0
2017-06-13 12:00:00	NQ	Futures	6846.19	6856.33	6838.44	6855.14	5977.0
2017-06-13 13:00:00	NQ	Futures	6854.84	6856.03	6837.85	6848.58	4198.0
2017-06-13 14:00:00	NQ	Futures	6847.98	6854.24	6843.51	6852.16	3470.0
2017-06-13 15:00:00	NQ	Futures	6852.16	6869.45	6850.07	6859.31	7066.0
2017-06-13 16:00:00	NQ	Futures	6859.01	6862.89	6855.44	6861.99	1593.0
2017-06-13 18:00:00	NQ	Futures	6859.91	6863.49	6859.91	6860.8	176.0
2017-06-13 19:00:00	NQ	Futures	6861.1	6861.99	6859.61	6861.99	50.0
2017-06-13 20:00:00	NQ	Futures	6861.99	6862.29	6859.61	6860.8	173.0
2017-06-13 21:00:00	NQ	Futures	6860.8	6860.8	6851.86	6851.86	368.0
2017-06-13 22:00:00	NQ	Futures	6852.45	6855.14	6845.0	6848.58	391.0
2017-06-13 23:00:00	NQ	Futures	6847.68	6851.26	6845.9	6846.79	212.0
2017-06-13 00:00:00	YM	Futures	23082.3	23086.7	23081.3	23083.4	236.0
2017-06-13 01:00:00	YM	Futures	23083.4	23085.6	23081.3	23082.3	494.0
2017-06-13 02:00:00	YM	Futures	23082.3	23099.8	23080.2	23091.1	1908.0
2017-06-13 03:00:00	YM	Futures	23091.1	23118.3	23085.6	23107.4	2996.0

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

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