PREVIEW / futures_1hour / 2018-09-20

all futures 1-hour files

  file:    by_date/futures_1hour/2018/2018-09-20.parquet
  size:    55 KB
  rows:    1,689

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-09-20 00:00:00	ES	Futures	3170.68	3172.32	3170.41	3171.5	1652.0
2018-09-20 01:00:00	ES	Futures	3171.5	3171.77	3169.87	3170.96	4244.0
2018-09-20 02:00:00	ES	Futures	3170.68	3171.77	3169.6	3171.5	5099.0
2018-09-20 03:00:00	ES	Futures	3171.23	3174.49	3170.96	3172.86	10904.0
2018-09-20 04:00:00	ES	Futures	3172.86	3173.68	3170.68	3171.77	10298.0
2018-09-20 05:00:00	ES	Futures	3172.04	3175.58	3171.23	3174.22	9711.0
2018-09-20 06:00:00	ES	Futures	3174.22	3175.31	3172.86	3173.95	12295.0
2018-09-20 07:00:00	ES	Futures	3174.22	3179.93	3173.95	3179.93	31562.0
2018-09-20 08:00:00	ES	Futures	3179.66	3185.37	3179.66	3184.28	52343.0
2018-09-20 09:00:00	ES	Futures	3184.28	3188.91	3183.2	3185.92	223930.0
2018-09-20 10:00:00	ES	Futures	3185.64	3191.08	3185.37	3188.36	176338.0
2018-09-20 11:00:00	ES	Futures	3188.64	3194.35	3188.36	3194.08	157242.0
2018-09-20 12:00:00	ES	Futures	3194.35	3195.71	3192.44	3195.16	90478.0
2018-09-20 13:00:00	ES	Futures	3195.16	3197.07	3192.99	3194.35	69593.0
2018-09-20 14:00:00	ES	Futures	3194.08	3197.07	3193.26	3196.52	67442.0
2018-09-20 15:00:00	ES	Futures	3196.52	3199.52	3194.35	3195.16	227641.0
2018-09-20 16:00:00	ES	Futures	3195.44	3199.52	3194.89	3198.97	67601.0
2018-09-20 18:00:00	ES	Futures	3198.16	3198.97	3196.52	3198.16	4656.0
2018-09-20 19:00:00	ES	Futures	3197.88	3199.79	3197.07	3199.24	3318.0
2018-09-20 20:00:00	ES	Futures	3199.24	3201.15	3198.43	3199.52	6639.0
2018-09-20 21:00:00	ES	Futures	3199.52	3199.79	3197.88	3198.7	6125.0
2018-09-20 22:00:00	ES	Futures	3198.97	3199.79	3197.88	3199.79	3738.0
2018-09-20 23:00:00	ES	Futures	3199.52	3200.6	3199.24	3200.06	4174.0
2018-09-20 00:00:00	NQ	Futures	8824.06	8829.34	8822.6	8826.41	741.0
2018-09-20 01:00:00	NQ	Futures	8826.7	8827.0	8818.78	8820.54	2068.0
2018-09-20 02:00:00	NQ	Futures	8820.25	8822.6	8815.85	8819.96	1749.0
2018-09-20 03:00:00	NQ	Futures	8819.66	8831.4	8818.49	8824.36	2716.0
2018-09-20 04:00:00	NQ	Futures	8824.06	8832.86	8820.84	8827.58	3989.0
2018-09-20 05:00:00	NQ	Futures	8827.58	8847.23	8825.24	8841.07	4411.0
2018-09-20 06:00:00	NQ	Futures	8841.07	8844.59	8835.5	8839.61	3914.0
2018-09-20 07:00:00	NQ	Futures	8839.61	8864.54	8839.61	8863.95	12316.0
2018-09-20 08:00:00	NQ	Futures	8863.95	8888.89	8863.66	8884.49	14411.0
2018-09-20 09:00:00	NQ	Futures	8884.49	8900.91	8861.31	8895.92	79365.0
2018-09-20 10:00:00	NQ	Futures	8895.63	8927.9	8894.75	8901.5	69623.0
2018-09-20 11:00:00	NQ	Futures	8901.79	8929.36	8899.15	8916.46	46009.0
2018-09-20 12:00:00	NQ	Futures	8917.04	8924.67	8902.38	8920.86	28848.0
2018-09-20 13:00:00	NQ	Futures	8920.86	8924.96	8909.42	8920.86	19706.0
2018-09-20 14:00:00	NQ	Futures	8920.86	8923.79	8910.0	8922.32	19278.0
2018-09-20 15:00:00	NQ	Futures	8922.62	8932.59	8915.87	8917.92	42995.0
2018-09-20 16:00:00	NQ	Futures	8917.92	8936.4	8913.23	8932.3	12731.0
2018-09-20 18:00:00	NQ	Futures	8927.31	8927.31	8915.58	8922.91	2212.0
2018-09-20 19:00:00	NQ	Futures	8923.2	8930.24	8918.51	8928.48	1364.0
2018-09-20 20:00:00	NQ	Futures	8928.19	8934.94	8924.08	8930.24	1852.0
2018-09-20 21:00:00	NQ	Futures	8930.24	8930.24	8923.2	8927.02	2612.0
2018-09-20 22:00:00	NQ	Futures	8927.02	8930.83	8924.96	8930.24	1036.0
2018-09-20 23:00:00	NQ	Futures	8930.24	8936.99	8929.36	8936.4	1883.0
2018-09-20 00:00:00	YM	Futures	28758.9	28773.0	28756.7	28764.3	595.0
2018-09-20 01:00:00	YM	Futures	28764.3	28765.4	28745.9	28756.7	1387.0
2018-09-20 02:00:00	YM	Futures	28755.6	28766.5	28745.9	28763.2	1395.0
2018-09-20 03:00:00	YM	Futures	28762.2	28787.1	28756.7	28773.0	2727.0

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

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