PREVIEW / futures_1hour / 2018-08-10

all futures 1-hour files

  file:    by_date/futures_1hour/2018/2018-08-10.parquet
  size:    49 KB
  rows:    1,405

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-10 00:00:00	ES	Futures	3106.12	3106.39	3104.21	3104.75	2508.0
2018-08-10 01:00:00	ES	Futures	3105.03	3105.03	3097.67	3098.76	20454.0
2018-08-10 02:00:00	ES	Futures	3098.76	3099.85	3095.49	3095.49	20274.0
2018-08-10 03:00:00	ES	Futures	3095.49	3099.85	3094.13	3095.49	28901.0
2018-08-10 04:00:00	ES	Futures	3095.49	3098.21	3094.67	3096.03	17454.0
2018-08-10 05:00:00	ES	Futures	3096.03	3099.3	3091.68	3092.49	21765.0
2018-08-10 06:00:00	ES	Futures	3092.76	3097.94	3092.22	3097.4	18904.0
2018-08-10 07:00:00	ES	Futures	3097.67	3097.94	3094.94	3095.22	20048.0
2018-08-10 08:00:00	ES	Futures	3095.22	3099.3	3093.04	3094.67	48743.0
2018-08-10 09:00:00	ES	Futures	3094.67	3096.85	3088.68	3089.77	209999.0
2018-08-10 10:00:00	ES	Futures	3089.5	3094.94	3086.5	3094.4	190916.0
2018-08-10 11:00:00	ES	Futures	3094.13	3098.49	3091.13	3094.67	117293.0
2018-08-10 12:00:00	ES	Futures	3094.67	3095.22	3091.4	3093.04	67182.0
2018-08-10 13:00:00	ES	Futures	3093.04	3093.31	3083.77	3084.59	95099.0
2018-08-10 14:00:00	ES	Futures	3084.32	3087.59	3080.23	3082.96	119448.0
2018-08-10 15:00:00	ES	Futures	3082.96	3093.58	3079.96	3088.41	255464.0
2018-08-10 16:00:00	ES	Futures	3088.41	3094.67	3088.13	3094.4	75498.0
2018-08-10 00:00:00	NQ	Futures	8787.2	8787.79	8781.02	8783.38	987.0
2018-08-10 01:00:00	NQ	Futures	8783.38	8783.97	8750.4	8758.35	6379.0
2018-08-10 02:00:00	NQ	Futures	8758.35	8763.95	8753.05	8753.05	4674.0
2018-08-10 03:00:00	NQ	Futures	8753.35	8769.54	8748.64	8758.35	7266.0
2018-08-10 04:00:00	NQ	Futures	8758.06	8766.01	8755.41	8761.59	3769.0
2018-08-10 05:00:00	NQ	Futures	8761.59	8769.54	8744.81	8746.87	5086.0
2018-08-10 06:00:00	NQ	Futures	8746.57	8761.3	8743.34	8760.12	4601.0
2018-08-10 07:00:00	NQ	Futures	8760.71	8763.06	8751.58	8752.46	3821.0
2018-08-10 08:00:00	NQ	Futures	8752.17	8763.65	8743.92	8750.99	10786.0
2018-08-10 09:00:00	NQ	Futures	8750.99	8769.83	8735.98	8738.92	65056.0
2018-08-10 10:00:00	NQ	Futures	8738.63	8767.77	8729.2	8749.81	70961.0
2018-08-10 11:00:00	NQ	Futures	8749.81	8765.42	8743.63	8756.88	38870.0
2018-08-10 12:00:00	NQ	Futures	8756.58	8763.65	8746.87	8757.17	23158.0
2018-08-10 13:00:00	NQ	Futures	8756.88	8757.17	8715.95	8720.67	28748.0
2018-08-10 14:00:00	NQ	Futures	8720.67	8728.32	8703.88	8714.78	37000.0
2018-08-10 15:00:00	NQ	Futures	8715.07	8745.99	8708.01	8735.98	54921.0
2018-08-10 16:00:00	NQ	Futures	8735.68	8753.64	8735.09	8752.76	10546.0
2018-08-10 00:00:00	YM	Futures	27688.4	27690.5	27669.9	27677.5	813.0
2018-08-10 01:00:00	YM	Futures	27677.5	27679.7	27603.6	27612.3	4480.0
2018-08-10 02:00:00	YM	Futures	27612.3	27617.7	27581.8	27582.9	3366.0
2018-08-10 03:00:00	YM	Futures	27581.8	27631.8	27572.0	27593.8	5249.0
2018-08-10 04:00:00	YM	Futures	27594.9	27619.9	27587.2	27601.4	2955.0
2018-08-10 05:00:00	YM	Futures	27601.4	27627.5	27565.5	27574.2	3258.0
2018-08-10 06:00:00	YM	Futures	27574.2	27615.5	27573.1	27611.2	2497.0
2018-08-10 07:00:00	YM	Futures	27611.2	27614.4	27589.4	27591.6	2507.0
2018-08-10 08:00:00	YM	Futures	27590.5	27614.4	27562.2	27565.5	6741.0
2018-08-10 09:00:00	YM	Futures	27565.5	27577.5	27482.9	27484.0	29201.0
2018-08-10 10:00:00	YM	Futures	27484.0	27520.9	27457.9	27517.7	23397.0
2018-08-10 11:00:00	YM	Futures	27517.7	27577.5	27495.9	27534.0	17535.0
2018-08-10 12:00:00	YM	Futures	27534.0	27547.0	27511.1	27526.4	8551.0
2018-08-10 13:00:00	YM	Futures	27526.4	27532.9	27438.3	27445.9	11807.0
2018-08-10 14:00:00	YM	Futures	27445.9	27476.4	27412.2	27449.2	15164.0
2018-08-10 15:00:00	YM	Futures	27450.3	27554.6	27419.8	27517.7	25834.0

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

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