PREVIEW / futures_1hour / 2018-10-18

all futures 1-hour files

  file:    by_date/futures_1hour/2018/2018-10-18.parquet
  size:    57 KB
  rows:    1,723

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
2018-10-18 00:00:00	ES	Futures	3052.64	3054.27	3051.82	3054.0	3479.0
2018-10-18 01:00:00	ES	Futures	3054.0	3054.81	3050.46	3051.0	5341.0
2018-10-18 02:00:00	ES	Futures	3050.73	3051.82	3046.65	3050.19	11906.0
2018-10-18 03:00:00	ES	Futures	3050.19	3059.98	3049.64	3058.89	21343.0
2018-10-18 04:00:00	ES	Futures	3059.16	3060.25	3055.9	3056.17	17534.0
2018-10-18 05:00:00	ES	Futures	3056.17	3058.89	3052.09	3058.08	15732.0
2018-10-18 06:00:00	ES	Futures	3058.08	3058.35	3051.0	3051.82	16904.0
2018-10-18 07:00:00	ES	Futures	3052.09	3055.08	3048.01	3050.19	16450.0
2018-10-18 08:00:00	ES	Futures	3049.92	3053.45	3047.47	3052.36	23172.0
2018-10-18 09:00:00	ES	Futures	3052.36	3052.91	3037.68	3040.4	195057.0
2018-10-18 10:00:00	ES	Futures	3040.4	3055.08	3036.04	3053.18	261388.0
2018-10-18 11:00:00	ES	Futures	3052.91	3054.27	3011.56	3016.19	383357.0
2018-10-18 12:00:00	ES	Futures	3016.19	3031.69	3012.92	3023.53	234704.0
2018-10-18 13:00:00	ES	Futures	3023.26	3025.71	2999.05	3003.95	273073.0
2018-10-18 14:00:00	ES	Futures	3003.68	3022.17	3002.59	3014.56	210596.0
2018-10-18 15:00:00	ES	Futures	3014.83	3021.9	3005.58	3015.92	332239.0
2018-10-18 16:00:00	ES	Futures	3015.92	3023.26	3014.28	3019.45	87015.0
2018-10-18 18:00:00	ES	Futures	3018.91	3019.72	3015.37	3017.55	7610.0
2018-10-18 19:00:00	ES	Futures	3017.28	3018.91	3014.83	3016.19	4267.0
2018-10-18 20:00:00	ES	Futures	3016.19	3024.08	3015.64	3023.53	13292.0
2018-10-18 21:00:00	ES	Futures	3023.53	3026.25	3021.36	3024.62	16037.0
2018-10-18 22:00:00	ES	Futures	3024.35	3026.8	3018.91	3024.89	15489.0
2018-10-18 23:00:00	ES	Futures	3024.89	3025.44	3021.9	3022.17	4918.0
2018-10-18 00:00:00	NQ	Futures	8537.49	8548.05	8536.03	8546.88	2103.0
2018-10-18 01:00:00	NQ	Futures	8546.88	8552.75	8534.27	8535.73	2240.0
2018-10-18 02:00:00	NQ	Futures	8534.86	8539.84	8524.3	8535.15	3622.0
2018-10-18 03:00:00	NQ	Futures	8535.44	8570.64	8530.75	8564.48	8362.0
2018-10-18 04:00:00	NQ	Futures	8564.19	8568.0	8553.33	8555.39	5826.0
2018-10-18 05:00:00	NQ	Futures	8555.09	8561.55	8538.37	8558.61	5496.0
2018-10-18 06:00:00	NQ	Futures	8558.32	8559.49	8533.68	8536.32	5457.0
2018-10-18 07:00:00	NQ	Futures	8535.44	8546.0	8525.76	8529.28	7760.0
2018-10-18 08:00:00	NQ	Futures	8528.99	8547.76	8520.48	8542.48	9571.0
2018-10-18 09:00:00	NQ	Futures	8542.19	8544.24	8478.83	8487.34	85988.0
2018-10-18 10:00:00	NQ	Futures	8487.34	8511.1	8459.47	8500.83	101455.0
2018-10-18 11:00:00	NQ	Futures	8501.12	8507.87	8360.92	8376.76	120660.0
2018-10-18 12:00:00	NQ	Futures	8377.35	8432.2	8366.79	8395.82	67200.0
2018-10-18 13:00:00	NQ	Futures	8395.53	8401.98	8323.67	8348.6	81364.0
2018-10-18 14:00:00	NQ	Futures	8348.31	8403.45	8344.2	8378.81	62802.0
2018-10-18 15:00:00	NQ	Futures	8378.23	8389.37	8348.89	8367.37	82855.0
2018-10-18 16:00:00	NQ	Futures	8367.37	8397.88	8361.8	8395.82	19992.0
2018-10-18 18:00:00	NQ	Futures	8393.48	8395.53	8376.47	8382.62	2689.0
2018-10-18 19:00:00	NQ	Futures	8382.62	8389.66	8375.88	8379.69	1496.0
2018-10-18 20:00:00	NQ	Futures	8380.28	8409.32	8378.52	8406.09	4280.0
2018-10-18 21:00:00	NQ	Futures	8406.97	8418.12	8396.41	8413.13	4741.0
2018-10-18 22:00:00	NQ	Futures	8412.84	8422.52	8391.13	8417.24	5636.0
2018-10-18 23:00:00	NQ	Futures	8417.82	8420.76	8409.32	8411.37	3315.0
2018-10-18 00:00:00	YM	Futures	27864.7	27879.9	27856.0	27878.8	1107.0
2018-10-18 01:00:00	YM	Futures	27878.8	27883.2	27835.4	27840.8	1468.0
2018-10-18 02:00:00	YM	Futures	27840.8	27852.7	27801.7	27835.4	3744.0
2018-10-18 03:00:00	YM	Futures	27836.4	27933.1	27827.8	27924.5	5319.0

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

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