PREVIEW / futures_1hour / 2020-05-18

all futures 1-hour files

  file:    by_date/futures_1hour/2020/2020-05-18.parquet
  size:    63 KB
  rows:    1,875

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
2020-05-18 00:00:00	ES	Futures	3160.16	3162.35	3157.41	3161.53	6936.0
2020-05-18 01:00:00	ES	Futures	3161.53	3162.9	3154.67	3154.94	8436.0
2020-05-18 02:00:00	ES	Futures	3154.94	3167.84	3154.94	3163.17	16119.0
2020-05-18 03:00:00	ES	Futures	3163.45	3172.23	3163.17	3171.41	33281.0
2020-05-18 04:00:00	ES	Futures	3171.41	3179.91	3170.58	3174.15	35914.0
2020-05-18 05:00:00	ES	Futures	3174.15	3175.52	3165.92	3169.21	17592.0
2020-05-18 06:00:00	ES	Futures	3169.49	3177.44	3168.39	3176.89	14823.0
2020-05-18 07:00:00	ES	Futures	3177.17	3200.22	3173.05	3198.57	51483.0
2020-05-18 08:00:00	ES	Futures	3198.57	3220.25	3198.3	3219.15	90245.0
2020-05-18 09:00:00	ES	Futures	3219.15	3225.47	3209.0	3215.31	216794.0
2020-05-18 10:00:00	ES	Futures	3215.31	3231.23	3211.2	3229.58	210502.0
2020-05-18 11:00:00	ES	Futures	3229.58	3241.11	3229.03	3235.34	211447.0
2020-05-18 12:00:00	ES	Futures	3235.07	3237.81	3229.58	3232.6	106404.0
2020-05-18 13:00:00	ES	Futures	3232.87	3243.58	3232.05	3241.38	100215.0
2020-05-18 14:00:00	ES	Futures	3241.38	3246.6	3239.19	3242.21	115331.0
2020-05-18 15:00:00	ES	Futures	3242.48	3254.28	3233.97	3233.97	312633.0
2020-05-18 16:00:00	ES	Futures	3234.25	3237.81	3230.13	3232.05	81429.0
2020-05-18 18:00:00	ES	Futures	3232.6	3242.21	3227.39	3239.74	12025.0
2020-05-18 19:00:00	ES	Futures	3239.74	3240.56	3232.6	3239.46	8473.0
2020-05-18 20:00:00	ES	Futures	3239.46	3241.93	3228.76	3235.34	16886.0
2020-05-18 21:00:00	ES	Futures	3235.34	3235.34	3226.01	3226.56	15565.0
2020-05-18 22:00:00	ES	Futures	3226.84	3232.87	3224.37	3228.76	10428.0
2020-05-18 23:00:00	ES	Futures	3228.76	3229.86	3221.62	3226.84	11906.0
2020-05-18 00:00:00	NQ	Futures	10506.43	10513.86	10494.44	10510.43	3378.0
2020-05-18 01:00:00	NQ	Futures	10510.15	10512.72	10483.01	10485.58	3971.0
2020-05-18 02:00:00	NQ	Futures	10486.44	10523.86	10483.87	10504.15	6578.0
2020-05-18 03:00:00	NQ	Futures	10504.15	10539.28	10504.15	10538.14	8978.0
2020-05-18 04:00:00	NQ	Futures	10537.85	10562.42	10534.43	10546.71	9984.0
2020-05-18 05:00:00	NQ	Futures	10547.85	10552.14	10505.86	10519.86	7843.0
2020-05-18 06:00:00	NQ	Futures	10520.72	10543.0	10506.43	10542.42	6177.0
2020-05-18 07:00:00	NQ	Futures	10542.42	10600.98	10529.0	10597.84	14868.0
2020-05-18 08:00:00	NQ	Futures	10597.84	10620.12	10586.13	10614.12	22070.0
2020-05-18 09:00:00	NQ	Futures	10614.69	10622.4	10553.28	10581.27	60190.0
2020-05-18 10:00:00	NQ	Futures	10581.27	10662.68	10570.42	10661.54	53361.0
2020-05-18 11:00:00	NQ	Futures	10660.68	10677.25	10642.11	10657.25	40373.0
2020-05-18 12:00:00	NQ	Futures	10656.97	10662.97	10632.4	10650.11	24960.0
2020-05-18 13:00:00	NQ	Futures	10650.11	10696.1	10647.83	10676.96	27554.0
2020-05-18 14:00:00	NQ	Futures	10677.25	10690.96	10646.4	10654.68	23438.0
2020-05-18 15:00:00	NQ	Futures	10654.68	10694.39	10637.54	10648.68	41152.0
2020-05-18 16:00:00	NQ	Futures	10648.11	10665.25	10639.54	10645.26	11592.0
2020-05-18 18:00:00	NQ	Futures	10644.4	10681.82	10637.54	10677.82	3702.0
2020-05-18 19:00:00	NQ	Futures	10676.68	10679.25	10653.25	10676.1	2872.0
2020-05-18 20:00:00	NQ	Futures	10676.39	10688.1	10643.54	10668.96	4720.0
2020-05-18 21:00:00	NQ	Futures	10668.11	10670.11	10633.26	10634.69	4992.0
2020-05-18 22:00:00	NQ	Futures	10634.69	10658.97	10627.83	10642.68	3712.0
2020-05-18 23:00:00	NQ	Futures	10642.68	10644.4	10621.26	10640.97	3800.0
2020-05-18 00:00:00	YM	Futures	26058.7	26075.1	26031.3	26068.6	1357.0
2020-05-18 01:00:00	YM	Futures	26068.6	26075.1	26014.9	26017.1	1896.0
2020-05-18 02:00:00	YM	Futures	26017.1	26127.7	26014.9	26089.4	3654.0
2020-05-18 03:00:00	YM	Futures	26090.5	26160.6	26088.3	26143.0	6382.0

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

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