PREVIEW / futures_1hour / 2017-06-14

all futures 1-hour files

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

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-14 00:00:00	ES	Futures	2662.87	2664.24	2662.32	2663.96	3471.0
2017-06-14 01:00:00	ES	Futures	2663.69	2663.96	2662.87	2662.87	2472.0
2017-06-14 02:00:00	ES	Futures	2663.14	2664.51	2662.6	2663.96	4977.0
2017-06-14 03:00:00	ES	Futures	2664.24	2666.7	2663.96	2665.6	12095.0
2017-06-14 04:00:00	ES	Futures	2665.88	2667.52	2665.33	2666.15	11233.0
2017-06-14 05:00:00	ES	Futures	2665.88	2668.61	2665.88	2667.24	11610.0
2017-06-14 06:00:00	ES	Futures	2667.52	2668.88	2666.97	2668.61	8854.0
2017-06-14 07:00:00	ES	Futures	2668.34	2670.25	2667.52	2668.61	19238.0
2017-06-14 08:00:00	ES	Futures	2668.34	2671.34	2665.88	2669.16	45576.0
2017-06-14 09:00:00	ES	Futures	2669.16	2670.8	2663.69	2666.15	168009.0
2017-06-14 10:00:00	ES	Futures	2666.15	2666.97	2659.32	2661.23	214182.0
2017-06-14 11:00:00	ES	Futures	2661.5	2663.96	2660.41	2663.69	123907.0
2017-06-14 12:00:00	ES	Futures	2663.69	2665.33	2661.23	2663.42	70485.0
2017-06-14 13:00:00	ES	Futures	2663.69	2665.88	2662.32	2663.69	54872.0
2017-06-14 14:00:00	ES	Futures	2663.69	2668.61	2655.22	2656.86	240785.0
2017-06-14 15:00:00	ES	Futures	2657.13	2664.78	2652.21	2662.87	300178.0
2017-06-14 16:00:00	ES	Futures	2663.14	2664.24	2660.96	2661.78	59405.0
2017-06-14 18:00:00	ES	Futures	2660.96	2661.78	2654.4	2656.31	11045.0
2017-06-14 19:00:00	ES	Futures	2656.31	2657.13	2653.85	2656.58	8764.0
2017-06-14 20:00:00	ES	Futures	2656.86	2660.14	2655.76	2657.13	10033.0
2017-06-14 21:00:00	ES	Futures	2657.4	2657.95	2654.4	2656.04	12169.0
2017-06-14 22:00:00	ES	Futures	2656.04	2656.04	2653.85	2654.94	6931.0
2017-06-14 23:00:00	ES	Futures	2655.22	2656.31	2654.94	2655.76	3791.0
2017-06-14 00:00:00	NQ	Futures	6846.79	6853.04	6845.0	6852.15	946.0
2017-06-14 01:00:00	NQ	Futures	6851.85	6853.04	6847.39	6847.68	762.0
2017-06-14 02:00:00	NQ	Futures	6847.68	6855.42	6847.39	6853.64	994.0
2017-06-14 03:00:00	NQ	Futures	6853.94	6861.98	6853.94	6860.49	2465.0
2017-06-14 04:00:00	NQ	Futures	6860.49	6869.12	6860.19	6865.85	2177.0
2017-06-14 05:00:00	NQ	Futures	6865.55	6875.37	6863.46	6870.31	2304.0
2017-06-14 06:00:00	NQ	Futures	6870.61	6875.08	6868.53	6873.89	1343.0
2017-06-14 07:00:00	NQ	Futures	6873.59	6880.44	6869.72	6873.59	3291.0
2017-06-14 08:00:00	NQ	Futures	6873.59	6889.67	6864.95	6880.14	11543.0
2017-06-14 09:00:00	NQ	Futures	6880.14	6894.73	6857.51	6876.27	49297.0
2017-06-14 10:00:00	NQ	Futures	6876.56	6882.22	6854.53	6867.04	52599.0
2017-06-14 11:00:00	NQ	Futures	6867.04	6881.92	6860.78	6881.63	23685.0
2017-06-14 12:00:00	NQ	Futures	6881.63	6883.12	6861.68	6867.04	22570.0
2017-06-14 13:00:00	NQ	Futures	6867.04	6875.37	6859.3	6865.55	14907.0
2017-06-14 14:00:00	NQ	Futures	6864.36	6884.01	6803.02	6814.04	83647.0
2017-06-14 15:00:00	NQ	Futures	6814.33	6833.09	6773.25	6828.92	96521.0
2017-06-14 16:00:00	NQ	Futures	6828.92	6834.58	6822.97	6824.16	8845.0
2017-06-14 18:00:00	NQ	Futures	6824.46	6827.44	6794.68	6801.83	4159.0
2017-06-14 19:00:00	NQ	Futures	6801.83	6804.81	6794.98	6802.72	3500.0
2017-06-14 20:00:00	NQ	Futures	6802.72	6811.06	6800.64	6801.53	2859.0
2017-06-14 21:00:00	NQ	Futures	6802.13	6803.02	6782.77	6790.51	5110.0
2017-06-14 22:00:00	NQ	Futures	6790.51	6793.49	6780.99	6789.92	2552.0
2017-06-14 23:00:00	NQ	Futures	6789.62	6793.49	6788.43	6793.19	927.0
2017-06-14 00:00:00	YM	Futures	23146.6	23161.8	23144.4	23158.5	967.0
2017-06-14 01:00:00	YM	Futures	23158.5	23160.7	23148.7	23149.8	679.0
2017-06-14 02:00:00	YM	Futures	23149.8	23162.9	23149.8	23159.6	1329.0
2017-06-14 03:00:00	YM	Futures	23160.7	23182.5	23159.6	23176.0	2610.0

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

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