PREVIEW / futures_1hour / 2018-08-17

all futures 1-hour files

  file:    by_date/futures_1hour/2018/2018-08-17.parquet
  size:    47 KB
  rows:    1,402

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-08-17 00:00:00	ES	Futures	3101.76	3102.57	3099.3	3099.85	3262.0
2018-08-17 01:00:00	ES	Futures	3099.85	3100.39	3098.76	3099.03	4968.0
2018-08-17 02:00:00	ES	Futures	3099.03	3101.76	3099.03	3101.21	7211.0
2018-08-17 03:00:00	ES	Futures	3101.21	3102.3	3099.58	3101.48	7791.0
2018-08-17 04:00:00	ES	Futures	3101.48	3103.39	3100.12	3100.94	7359.0
2018-08-17 05:00:00	ES	Futures	3100.94	3100.94	3093.85	3094.67	17475.0
2018-08-17 06:00:00	ES	Futures	3094.67	3097.4	3092.76	3096.85	16982.0
2018-08-17 07:00:00	ES	Futures	3096.85	3099.03	3094.94	3095.22	11677.0
2018-08-17 08:00:00	ES	Futures	3095.22	3097.12	3089.77	3095.22	39662.0
2018-08-17 09:00:00	ES	Futures	3095.22	3099.85	3091.95	3095.76	160845.0
2018-08-17 10:00:00	ES	Futures	3095.76	3096.85	3089.77	3095.22	170678.0
2018-08-17 11:00:00	ES	Futures	3095.22	3104.21	3093.04	3103.39	127746.0
2018-08-17 12:00:00	ES	Futures	3103.39	3103.66	3097.67	3097.94	72380.0
2018-08-17 13:00:00	ES	Futures	3097.67	3102.57	3096.58	3101.48	55321.0
2018-08-17 14:00:00	ES	Futures	3101.48	3113.74	3101.21	3112.65	197784.0
2018-08-17 15:00:00	ES	Futures	3112.93	3113.2	3106.39	3108.02	161150.0
2018-08-17 16:00:00	ES	Futures	3108.02	3110.2	3106.39	3109.66	62407.0
2018-08-17 00:00:00	NQ	Futures	8702.41	8707.42	8694.17	8696.23	1469.0
2018-08-17 01:00:00	NQ	Futures	8696.82	8698.58	8689.16	8690.34	1699.0
2018-08-17 02:00:00	NQ	Futures	8690.34	8700.65	8689.16	8697.7	2551.0
2018-08-17 03:00:00	NQ	Futures	8698.0	8705.06	8694.46	8702.12	2634.0
2018-08-17 04:00:00	NQ	Futures	8702.41	8708.3	8698.58	8702.71	3011.0
2018-08-17 05:00:00	NQ	Futures	8703.0	8703.29	8678.56	8682.1	5531.0
2018-08-17 06:00:00	NQ	Futures	8681.51	8689.75	8672.68	8687.99	5439.0
2018-08-17 07:00:00	NQ	Futures	8687.99	8694.17	8682.1	8683.57	3285.0
2018-08-17 08:00:00	NQ	Futures	8683.57	8684.75	8663.84	8677.09	9618.0
2018-08-17 09:00:00	NQ	Futures	8677.09	8693.87	8654.72	8664.14	61547.0
2018-08-17 10:00:00	NQ	Futures	8664.14	8670.91	8622.62	8642.35	71199.0
2018-08-17 11:00:00	NQ	Futures	8642.64	8687.4	8632.63	8684.16	46366.0
2018-08-17 12:00:00	NQ	Futures	8684.16	8685.63	8653.83	8657.66	26009.0
2018-08-17 13:00:00	NQ	Futures	8657.07	8677.09	8655.3	8673.56	16905.0
2018-08-17 14:00:00	NQ	Futures	8673.56	8723.02	8671.2	8716.54	48004.0
2018-08-17 15:00:00	NQ	Futures	8716.54	8718.9	8697.41	8701.53	37327.0
2018-08-17 16:00:00	NQ	Futures	8701.53	8705.36	8698.0	8703.59	8778.0
2018-08-17 00:00:00	YM	Futures	27867.7	27876.4	27843.8	27847.1	811.0
2018-08-17 01:00:00	YM	Futures	27848.2	27854.7	27829.7	27844.9	1577.0
2018-08-17 02:00:00	YM	Futures	27844.9	27863.4	27837.3	27853.6	1758.0
2018-08-17 03:00:00	YM	Futures	27854.7	27861.2	27827.5	27843.8	1920.0
2018-08-17 04:00:00	YM	Futures	27843.8	27869.9	27836.2	27843.8	2038.0
2018-08-17 05:00:00	YM	Futures	27844.9	27846.0	27772.1	27781.8	4660.0
2018-08-17 06:00:00	YM	Futures	27780.8	27800.3	27761.2	27789.5	3815.0
2018-08-17 07:00:00	YM	Futures	27790.5	27822.1	27767.7	27769.9	2817.0
2018-08-17 08:00:00	YM	Futures	27769.9	27786.2	27728.6	27766.6	7356.0
2018-08-17 09:00:00	YM	Futures	27767.7	27814.5	27742.7	27791.6	17796.0
2018-08-17 10:00:00	YM	Futures	27791.6	27825.3	27746.0	27810.1	17713.0
2018-08-17 11:00:00	YM	Futures	27811.2	27908.0	27789.5	27902.5	17897.0
2018-08-17 12:00:00	YM	Futures	27903.6	27906.9	27838.4	27841.6	10230.0
2018-08-17 13:00:00	YM	Futures	27840.5	27863.4	27819.9	27854.7	7926.0
2018-08-17 14:00:00	YM	Futures	27854.7	27973.2	27850.3	27961.2	21561.0
2018-08-17 15:00:00	YM	Futures	27961.2	27966.7	27897.1	27909.0	13941.0

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

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