PREVIEW / futures_1hour / 2018-10-09

all futures 1-hour files

  file:    by_date/futures_1hour/2018/2018-10-09.parquet
  size:    56 KB
  rows:    1,704

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-10-09 00:00:00	ES	Futures	3144.84	3146.2	3143.76	3144.84	5162.0
2018-10-09 01:00:00	ES	Futures	3144.84	3145.66	3142.94	3143.76	5416.0
2018-10-09 02:00:00	ES	Futures	3143.48	3144.03	3141.04	3143.76	7550.0
2018-10-09 03:00:00	ES	Futures	3143.48	3145.66	3141.31	3141.58	17545.0
2018-10-09 04:00:00	ES	Futures	3141.58	3141.85	3138.04	3141.04	15610.0
2018-10-09 05:00:00	ES	Futures	3141.04	3141.04	3132.6	3133.69	25692.0
2018-10-09 06:00:00	ES	Futures	3133.42	3136.68	3131.24	3136.68	25416.0
2018-10-09 07:00:00	ES	Futures	3136.68	3136.96	3127.44	3128.52	40910.0
2018-10-09 08:00:00	ES	Futures	3128.25	3139.4	3127.98	3138.59	43962.0
2018-10-09 09:00:00	ES	Futures	3138.59	3144.3	3132.33	3144.03	253073.0
2018-10-09 10:00:00	ES	Futures	3144.03	3155.18	3140.22	3146.2	332530.0
2018-10-09 11:00:00	ES	Futures	3145.93	3152.46	3140.76	3151.37	212300.0
2018-10-09 12:00:00	ES	Futures	3151.64	3154.09	3136.96	3139.68	161070.0
2018-10-09 13:00:00	ES	Futures	3139.95	3145.39	3135.05	3142.12	128986.0
2018-10-09 14:00:00	ES	Futures	3142.4	3148.11	3138.86	3146.75	130586.0
2018-10-09 15:00:00	ES	Futures	3147.02	3147.84	3138.86	3139.68	216554.0
2018-10-09 16:00:00	ES	Futures	3139.95	3142.94	3138.59	3141.58	62646.0
2018-10-09 18:00:00	ES	Futures	3140.76	3144.3	3140.76	3144.03	4200.0
2018-10-09 19:00:00	ES	Futures	3144.03	3145.12	3142.67	3143.21	3212.0
2018-10-09 20:00:00	ES	Futures	3143.48	3144.57	3140.22	3144.57	8348.0
2018-10-09 21:00:00	ES	Futures	3144.3	3145.66	3141.31	3144.03	7425.0
2018-10-09 22:00:00	ES	Futures	3144.03	3144.84	3136.68	3137.5	8953.0
2018-10-09 23:00:00	ES	Futures	3137.5	3138.86	3135.32	3137.77	7796.0
2018-10-09 00:00:00	NQ	Futures	8667.73	8674.77	8664.5	8669.78	1439.0
2018-10-09 01:00:00	NQ	Futures	8669.78	8673.3	8662.74	8666.55	1544.0
2018-10-09 02:00:00	NQ	Futures	8666.55	8666.85	8654.82	8666.55	2970.0
2018-10-09 03:00:00	NQ	Futures	8666.26	8670.95	8655.41	8657.46	5635.0
2018-10-09 04:00:00	NQ	Futures	8657.17	8658.34	8639.57	8653.35	7789.0
2018-10-09 05:00:00	NQ	Futures	8653.35	8653.35	8627.54	8631.06	7821.0
2018-10-09 06:00:00	NQ	Futures	8631.36	8642.79	8622.56	8642.79	7546.0
2018-10-09 07:00:00	NQ	Futures	8642.79	8643.67	8608.18	8612.88	12771.0
2018-10-09 08:00:00	NQ	Futures	8612.58	8660.1	8610.82	8656.29	17321.0
2018-10-09 09:00:00	NQ	Futures	8656.29	8698.23	8637.22	8694.42	102596.0
2018-10-09 10:00:00	NQ	Futures	8695.0	8747.51	8662.74	8713.78	103372.0
2018-10-09 11:00:00	NQ	Futures	8713.48	8731.67	8683.57	8721.99	69759.0
2018-10-09 12:00:00	NQ	Futures	8722.28	8731.67	8664.21	8670.37	63892.0
2018-10-09 13:00:00	NQ	Futures	8670.66	8690.6	8646.61	8673.59	52668.0
2018-10-09 14:00:00	NQ	Futures	8673.59	8699.4	8657.17	8693.83	46618.0
2018-10-09 15:00:00	NQ	Futures	8694.12	8698.23	8667.14	8676.53	48963.0
2018-10-09 16:00:00	NQ	Futures	8676.53	8683.27	8662.45	8675.94	12201.0
2018-10-09 18:00:00	NQ	Futures	8675.94	8688.84	8674.18	8687.97	1565.0
2018-10-09 19:00:00	NQ	Futures	8687.97	8691.48	8684.74	8685.62	1324.0
2018-10-09 20:00:00	NQ	Futures	8685.62	8689.14	8671.54	8687.97	3113.0
2018-10-09 21:00:00	NQ	Futures	8687.67	8694.71	8676.53	8688.55	3457.0
2018-10-09 22:00:00	NQ	Futures	8689.14	8692.36	8663.03	8665.38	4292.0
2018-10-09 23:00:00	NQ	Futures	8665.09	8672.13	8658.63	8670.07	3043.0
2018-10-09 00:00:00	YM	Futures	28818.7	28829.5	28805.6	28818.7	1093.0
2018-10-09 01:00:00	YM	Futures	28817.6	28820.8	28793.7	28804.5	1194.0
2018-10-09 02:00:00	YM	Futures	28804.5	28808.9	28768.7	28801.3	1980.0
2018-10-09 03:00:00	YM	Futures	28801.3	28819.7	28776.3	28782.8	3980.0

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

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