PREVIEW / futures_1hour / 2020-05-07

all futures 1-hour files

  file:    by_date/futures_1hour/2020/2020-05-07.parquet
  size:    62 KB
  rows:    1,873

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-07 00:00:00	ES	Futures	3128.05	3133.81	3125.3	3131.34	17215.0
2020-05-07 01:00:00	ES	Futures	3131.34	3132.16	3125.85	3129.42	7639.0
2020-05-07 02:00:00	ES	Futures	3129.7	3140.4	3128.87	3135.46	13037.0
2020-05-07 03:00:00	ES	Futures	3135.46	3156.04	3133.26	3146.16	34635.0
2020-05-07 04:00:00	ES	Futures	3146.16	3151.37	3142.59	3149.73	19563.0
2020-05-07 05:00:00	ES	Futures	3150.0	3159.33	3148.36	3156.31	26330.0
2020-05-07 06:00:00	ES	Futures	3156.04	3160.16	3150.55	3152.75	27049.0
2020-05-07 07:00:00	ES	Futures	3152.75	3162.9	3148.9	3161.25	28793.0
2020-05-07 08:00:00	ES	Futures	3161.53	3162.08	3151.92	3157.69	43355.0
2020-05-07 09:00:00	ES	Futures	3157.41	3168.66	3153.02	3164.55	172343.0
2020-05-07 10:00:00	ES	Futures	3164.82	3165.64	3148.9	3153.29	194036.0
2020-05-07 11:00:00	ES	Futures	3153.57	3176.89	3152.75	3173.88	173668.0
2020-05-07 12:00:00	ES	Futures	3173.88	3177.72	3166.47	3171.68	106640.0
2020-05-07 13:00:00	ES	Futures	3171.68	3175.25	3163.45	3167.02	84307.0
2020-05-07 14:00:00	ES	Futures	3167.02	3168.94	3153.84	3158.51	112564.0
2020-05-07 15:00:00	ES	Futures	3158.51	3162.9	3147.81	3154.67	262843.0
2020-05-07 16:00:00	ES	Futures	3154.67	3166.47	3152.75	3164.27	51955.0
2020-05-07 18:00:00	ES	Futures	3163.45	3170.58	3160.98	3170.31	6752.0
2020-05-07 19:00:00	ES	Futures	3170.31	3175.52	3164.82	3174.97	11677.0
2020-05-07 20:00:00	ES	Futures	3175.25	3190.07	3174.97	3188.69	27165.0
2020-05-07 21:00:00	ES	Futures	3188.69	3191.71	3185.68	3187.6	16869.0
2020-05-07 22:00:00	ES	Futures	3187.6	3199.12	3187.05	3196.65	17216.0
2020-05-07 23:00:00	ES	Futures	3196.38	3200.22	3195.55	3198.57	8028.0
2020-05-07 00:00:00	NQ	Futures	10309.91	10318.2	10300.2	10308.2	3449.0
2020-05-07 01:00:00	NQ	Futures	10309.06	10310.77	10287.63	10297.63	3327.0
2020-05-07 02:00:00	NQ	Futures	10298.2	10331.91	10297.63	10319.91	4989.0
2020-05-07 03:00:00	NQ	Futures	10319.63	10379.32	10312.77	10356.19	13575.0
2020-05-07 04:00:00	NQ	Futures	10355.9	10377.04	10349.9	10369.61	6443.0
2020-05-07 05:00:00	NQ	Futures	10369.61	10397.89	10367.33	10390.75	7246.0
2020-05-07 06:00:00	NQ	Futures	10391.32	10397.32	10370.47	10373.04	6723.0
2020-05-07 07:00:00	NQ	Futures	10372.75	10396.75	10353.62	10389.61	7972.0
2020-05-07 08:00:00	NQ	Futures	10389.61	10393.89	10361.9	10385.89	13136.0
2020-05-07 09:00:00	NQ	Futures	10385.32	10407.6	10349.33	10379.04	54062.0
2020-05-07 10:00:00	NQ	Futures	10379.04	10386.46	10317.63	10336.19	55815.0
2020-05-07 11:00:00	NQ	Futures	10336.19	10409.6	10336.19	10392.18	40885.0
2020-05-07 12:00:00	NQ	Futures	10393.03	10415.6	10387.89	10413.03	27057.0
2020-05-07 13:00:00	NQ	Futures	10412.17	10427.03	10392.75	10407.6	21129.0
2020-05-07 14:00:00	NQ	Futures	10407.6	10409.32	10370.75	10392.75	24467.0
2020-05-07 15:00:00	NQ	Futures	10392.46	10409.32	10357.62	10386.75	52027.0
2020-05-07 16:00:00	NQ	Futures	10387.32	10425.03	10381.04	10418.17	9506.0
2020-05-07 18:00:00	NQ	Futures	10414.46	10435.02	10401.03	10433.88	3020.0
2020-05-07 19:00:00	NQ	Futures	10435.02	10447.02	10414.17	10444.74	4087.0
2020-05-07 20:00:00	NQ	Futures	10445.02	10493.87	10445.02	10489.58	8848.0
2020-05-07 21:00:00	NQ	Futures	10490.15	10507.29	10483.3	10489.01	7824.0
2020-05-07 22:00:00	NQ	Futures	10489.87	10530.14	10489.58	10514.15	7314.0
2020-05-07 23:00:00	NQ	Futures	10513.86	10525.86	10513.29	10520.72	3411.0
2020-05-07 00:00:00	YM	Futures	25891.1	25939.3	25871.4	25915.2	2086.0
2020-05-07 01:00:00	YM	Futures	25919.6	25922.9	25859.4	25887.8	1766.0
2020-05-07 02:00:00	YM	Futures	25888.9	25962.3	25884.5	25927.3	3145.0
2020-05-07 03:00:00	YM	Futures	25924.0	26104.7	25909.7	26020.4	7314.0

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

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