PREVIEW / futures_1hour / 2020-07-06

all futures 1-hour files

  file:    by_date/futures_1hour/2020/2020-07-06.parquet
  size:    58 KB
  rows:    1,840

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-07-06 00:00:00	ES	Futures	3535.22	3539.69	3532.43	3536.06	11686.0
2020-07-06 01:00:00	ES	Futures	3536.06	3539.97	3531.87	3537.18	11191.0
2020-07-06 02:00:00	ES	Futures	3537.18	3539.69	3529.92	3533.83	18265.0
2020-07-06 03:00:00	ES	Futures	3533.83	3542.76	3531.31	3538.29	35407.0
2020-07-06 04:00:00	ES	Futures	3538.02	3542.2	3533.83	3534.66	27475.0
2020-07-06 05:00:00	ES	Futures	3534.94	3536.9	3527.12	3534.66	21144.0
2020-07-06 06:00:00	ES	Futures	3534.94	3543.88	3533.55	3536.06	20446.0
2020-07-06 07:00:00	ES	Futures	3536.06	3539.41	3531.59	3537.46	17848.0
2020-07-06 08:00:00	ES	Futures	3537.46	3542.2	3536.9	3541.09	24659.0
2020-07-06 09:00:00	ES	Futures	3541.37	3541.37	3527.96	3537.74	142420.0
2020-07-06 10:00:00	ES	Futures	3537.74	3545.83	3524.05	3539.69	227869.0
2020-07-06 11:00:00	ES	Futures	3539.69	3543.32	3534.11	3534.39	104652.0
2020-07-06 12:00:00	ES	Futures	3534.39	3536.06	3529.08	3534.66	71260.0
2020-07-06 13:00:00	ES	Futures	3534.66	3536.9	3529.64	3536.34	62660.0
2020-07-06 14:00:00	ES	Futures	3536.34	3536.62	3524.33	3529.36	94339.0
2020-07-06 15:00:00	ES	Futures	3529.08	3541.92	3525.17	3539.97	186718.0
2020-07-06 16:00:00	ES	Futures	3539.69	3545.28	3537.18	3539.13	53731.0
2020-07-06 18:00:00	ES	Futures	3540.81	3545.0	3537.18	3543.04	5993.0
2020-07-06 19:00:00	ES	Futures	3543.32	3551.14	3543.04	3548.63	10832.0
2020-07-06 20:00:00	ES	Futures	3548.35	3556.45	3544.44	3554.21	15643.0
2020-07-06 21:00:00	ES	Futures	3553.93	3555.33	3530.76	3531.59	30637.0
2020-07-06 22:00:00	ES	Futures	3531.87	3537.18	3527.68	3532.99	18446.0
2020-07-06 23:00:00	ES	Futures	3533.27	3538.29	3532.71	3535.78	8050.0
2020-07-06 00:00:00	NQ	Futures	12135.96	12150.99	12120.34	12131.62	3821.0
2020-07-06 01:00:00	NQ	Futures	12131.33	12141.45	12115.71	12129.88	4574.0
2020-07-06 02:00:00	NQ	Futures	12129.88	12136.82	12111.66	12124.1	6344.0
2020-07-06 03:00:00	NQ	Futures	12124.39	12149.84	12121.21	12131.04	9893.0
2020-07-06 04:00:00	NQ	Futures	12130.46	12138.85	12117.16	12124.1	6419.0
2020-07-06 05:00:00	NQ	Futures	12123.52	12126.41	12102.7	12117.45	6283.0
2020-07-06 06:00:00	NQ	Futures	12118.03	12136.24	12112.82	12121.5	5280.0
2020-07-06 07:00:00	NQ	Futures	12121.5	12126.7	12113.69	12122.36	5235.0
2020-07-06 08:00:00	NQ	Futures	12122.36	12137.11	12119.76	12133.64	6077.0
2020-07-06 09:00:00	NQ	Futures	12133.35	12168.34	12106.46	12168.05	48597.0
2020-07-06 10:00:00	NQ	Futures	12168.05	12231.96	12157.64	12230.52	63343.0
2020-07-06 11:00:00	NQ	Futures	12230.23	12277.94	12227.91	12250.47	42465.0
2020-07-06 12:00:00	NQ	Futures	12250.47	12255.1	12211.43	12242.66	35826.0
2020-07-06 13:00:00	NQ	Futures	12242.95	12245.27	12201.31	12219.82	31221.0
2020-07-06 14:00:00	NQ	Futures	12220.11	12221.55	12166.61	12207.67	41144.0
2020-07-06 15:00:00	NQ	Futures	12207.67	12257.99	12176.44	12251.34	51713.0
2020-07-06 16:00:00	NQ	Futures	12251.34	12265.8	12246.71	12258.57	10705.0
2020-07-06 18:00:00	NQ	Futures	12261.17	12288.35	12253.07	12282.28	2715.0
2020-07-06 19:00:00	NQ	Futures	12283.15	12317.85	12282.57	12307.44	4912.0
2020-07-06 20:00:00	NQ	Futures	12307.15	12335.78	12293.85	12329.99	7402.0
2020-07-06 21:00:00	NQ	Futures	12329.71	12335.78	12248.16	12251.63	14416.0
2020-07-06 22:00:00	NQ	Futures	12251.34	12278.81	12244.98	12258.28	8838.0
2020-07-06 23:00:00	NQ	Futures	12257.7	12279.39	12257.7	12275.63	5058.0
2020-07-06 00:00:00	YM	Futures	28749.7	28793.7	28725.4	28755.2	2607.0
2020-07-06 01:00:00	YM	Futures	28755.2	28791.5	28717.7	28766.2	3344.0
2020-07-06 02:00:00	YM	Futures	28766.2	28789.3	28694.6	28745.3	4873.0
2020-07-06 03:00:00	YM	Futures	28745.3	28843.3	28723.2	28812.4	10095.0

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

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