PREVIEW / futures_1hour / 2020-05-13

all futures 1-hour files

  file:    by_date/futures_1hour/2020/2020-05-13.parquet
  size:    61 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-13 00:00:00	ES	Futures	3132.44	3138.2	3129.15	3137.65	9631.0
2020-05-13 01:00:00	ES	Futures	3137.93	3139.3	3123.38	3130.24	16599.0
2020-05-13 02:00:00	ES	Futures	3130.52	3144.79	3128.6	3143.14	19663.0
2020-05-13 03:00:00	ES	Futures	3143.42	3143.96	3123.93	3131.89	43130.0
2020-05-13 04:00:00	ES	Futures	3132.16	3142.04	3126.4	3129.97	28936.0
2020-05-13 05:00:00	ES	Futures	3129.97	3149.18	3126.95	3146.16	38542.0
2020-05-13 06:00:00	ES	Futures	3146.16	3153.84	3145.34	3150.28	30593.0
2020-05-13 07:00:00	ES	Futures	3150.28	3157.69	3145.61	3154.39	25669.0
2020-05-13 08:00:00	ES	Futures	3154.12	3156.31	3143.96	3145.89	51862.0
2020-05-13 09:00:00	ES	Futures	3145.61	3145.89	3109.39	3123.11	299292.0
2020-05-13 10:00:00	ES	Futures	3123.11	3148.9	3120.09	3122.29	281311.0
2020-05-13 11:00:00	ES	Futures	3122.29	3129.15	3082.77	3090.18	328517.0
2020-05-13 12:00:00	ES	Futures	3090.18	3094.57	3065.48	3088.53	335532.0
2020-05-13 13:00:00	ES	Futures	3088.26	3092.37	3074.26	3078.11	174998.0
2020-05-13 14:00:00	ES	Futures	3078.11	3089.91	3066.03	3066.03	196643.0
2020-05-13 15:00:00	ES	Futures	3066.03	3092.92	3058.07	3087.98	423421.0
2020-05-13 16:00:00	ES	Futures	3087.98	3095.12	3083.32	3094.3	80000.0
2020-05-13 18:00:00	ES	Futures	3095.67	3100.33	3090.45	3096.77	13104.0
2020-05-13 19:00:00	ES	Futures	3097.04	3100.88	3089.91	3091.83	10736.0
2020-05-13 20:00:00	ES	Futures	3091.83	3091.83	3077.01	3088.26	28789.0
2020-05-13 21:00:00	ES	Futures	3088.26	3092.92	3077.83	3082.5	27087.0
2020-05-13 22:00:00	ES	Futures	3082.5	3087.16	3071.24	3086.61	21345.0
2020-05-13 23:00:00	ES	Futures	3086.89	3090.45	3082.77	3087.44	13203.0
2020-05-13 00:00:00	NQ	Futures	10382.18	10404.17	10371.04	10401.6	3842.0
2020-05-13 01:00:00	NQ	Futures	10401.89	10413.32	10362.76	10381.04	6482.0
2020-05-13 02:00:00	NQ	Futures	10379.32	10430.17	10374.18	10424.17	8977.0
2020-05-13 03:00:00	NQ	Futures	10424.74	10426.17	10366.76	10392.46	13285.0
2020-05-13 04:00:00	NQ	Futures	10391.89	10427.31	10373.04	10391.32	10524.0
2020-05-13 05:00:00	NQ	Futures	10390.46	10452.16	10383.04	10438.74	10879.0
2020-05-13 06:00:00	NQ	Futures	10438.45	10465.87	10435.31	10454.45	9510.0
2020-05-13 07:00:00	NQ	Futures	10454.16	10476.44	10436.45	10468.44	8241.0
2020-05-13 08:00:00	NQ	Futures	10467.59	10474.73	10440.45	10442.45	18511.0
2020-05-13 09:00:00	NQ	Futures	10442.16	10444.74	10331.91	10412.17	92461.0
2020-05-13 10:00:00	NQ	Futures	10412.17	10514.72	10406.75	10413.89	83553.0
2020-05-13 11:00:00	NQ	Futures	10414.17	10447.02	10256.78	10277.92	93187.0
2020-05-13 12:00:00	NQ	Futures	10277.92	10289.63	10152.81	10258.21	94354.0
2020-05-13 13:00:00	NQ	Futures	10257.64	10263.35	10182.8	10202.51	54595.0
2020-05-13 14:00:00	NQ	Futures	10202.8	10258.5	10169.95	10171.09	50986.0
2020-05-13 15:00:00	NQ	Futures	10170.81	10287.35	10143.96	10272.49	82900.0
2020-05-13 16:00:00	NQ	Futures	10272.49	10307.34	10259.93	10297.63	12167.0
2020-05-13 18:00:00	NQ	Futures	10297.63	10318.2	10287.92	10312.77	4034.0
2020-05-13 19:00:00	NQ	Futures	10313.06	10327.05	10291.63	10296.2	4032.0
2020-05-13 20:00:00	NQ	Futures	10296.49	10296.49	10242.79	10282.21	10146.0
2020-05-13 21:00:00	NQ	Futures	10281.92	10302.2	10246.5	10254.21	9432.0
2020-05-13 22:00:00	NQ	Futures	10253.64	10274.21	10218.22	10273.07	7497.0
2020-05-13 23:00:00	NQ	Futures	10273.07	10290.49	10263.93	10283.35	5526.0
2020-05-13 00:00:00	YM	Futures	25863.7	25913.0	25834.2	25908.6	1909.0
2020-05-13 01:00:00	YM	Futures	25908.6	25919.6	25786.0	25839.6	3481.0
2020-05-13 02:00:00	YM	Futures	25836.3	25964.5	25828.7	25949.2	4698.0
2020-05-13 03:00:00	YM	Futures	25950.3	25953.5	25792.5	25850.6	7641.0

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

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