PREVIEW / futures_1hour / 2019-10-03

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-10-03.parquet
  size:    59 KB
  rows:    1,849

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
2019-10-03 00:00:00	ES	Futures	3137.88	3138.7	3135.71	3136.79	6360.0
2019-10-03 01:00:00	ES	Futures	3136.79	3138.97	3135.71	3137.34	6101.0
2019-10-03 02:00:00	ES	Futures	3137.07	3142.77	3130.55	3141.96	20973.0
2019-10-03 03:00:00	ES	Futures	3141.96	3144.94	3137.88	3141.41	32657.0
2019-10-03 04:00:00	ES	Futures	3141.41	3144.94	3136.52	3140.33	32338.0
2019-10-03 05:00:00	ES	Futures	3140.33	3143.04	3138.15	3141.96	18474.0
2019-10-03 06:00:00	ES	Futures	3142.23	3143.31	3134.62	3135.16	27141.0
2019-10-03 07:00:00	ES	Futures	3135.16	3138.15	3127.02	3129.73	33509.0
2019-10-03 08:00:00	ES	Futures	3129.46	3135.71	3129.19	3131.91	42275.0
2019-10-03 09:00:00	ES	Futures	3131.91	3141.68	3130.28	3140.33	187229.0
2019-10-03 10:00:00	ES	Futures	3140.33	3140.33	3102.03	3129.73	574833.0
2019-10-03 11:00:00	ES	Futures	3129.46	3152.28	3126.47	3137.34	309651.0
2019-10-03 12:00:00	ES	Futures	3137.34	3154.18	3137.34	3153.09	145804.0
2019-10-03 13:00:00	ES	Futures	3153.09	3159.34	3149.29	3158.53	105270.0
2019-10-03 14:00:00	ES	Futures	3158.53	3161.24	3154.45	3155.27	99544.0
2019-10-03 15:00:00	ES	Futures	3155.54	3163.14	3148.47	3162.87	190502.0
2019-10-03 16:00:00	ES	Futures	3162.87	3164.5	3162.33	3163.14	59556.0
2019-10-03 18:00:00	ES	Futures	3163.41	3164.23	3160.43	3160.43	6781.0
2019-10-03 19:00:00	ES	Futures	3160.7	3161.78	3157.98	3158.53	5192.0
2019-10-03 20:00:00	ES	Futures	3158.25	3161.51	3157.17	3159.07	9552.0
2019-10-03 21:00:00	ES	Futures	3159.07	3160.97	3156.62	3159.07	8513.0
2019-10-03 22:00:00	ES	Futures	3159.34	3161.24	3157.98	3158.53	6626.0
2019-10-03 23:00:00	ES	Futures	3158.25	3160.15	3157.44	3159.34	5029.0
2019-10-03 00:00:00	NQ	Futures	8790.01	8791.17	8778.97	8784.78	3561.0
2019-10-03 01:00:00	NQ	Futures	8784.49	8790.88	8779.84	8785.36	2352.0
2019-10-03 02:00:00	NQ	Futures	8784.78	8809.18	8764.15	8807.15	8406.0
2019-10-03 03:00:00	NQ	Futures	8807.73	8816.73	8790.59	8807.15	11485.0
2019-10-03 04:00:00	NQ	Futures	8807.44	8816.15	8790.01	8802.21	9564.0
2019-10-03 05:00:00	NQ	Futures	8801.92	8812.37	8796.11	8810.05	4817.0
2019-10-03 06:00:00	NQ	Futures	8810.05	8813.83	8787.39	8791.17	7200.0
2019-10-03 07:00:00	NQ	Futures	8791.17	8799.59	8764.73	8774.61	9788.0
2019-10-03 08:00:00	NQ	Futures	8774.03	8791.75	8773.16	8778.1	17057.0
2019-10-03 09:00:00	NQ	Futures	8778.39	8813.54	8772.0	8799.3	58684.0
2019-10-03 10:00:00	NQ	Futures	8798.43	8798.43	8684.85	8774.03	149603.0
2019-10-03 11:00:00	NQ	Futures	8774.03	8853.62	8764.15	8813.83	90029.0
2019-10-03 12:00:00	NQ	Futures	8813.83	8874.54	8813.54	8868.15	53158.0
2019-10-03 13:00:00	NQ	Futures	8868.44	8894.29	8859.43	8886.16	40373.0
2019-10-03 14:00:00	NQ	Futures	8886.16	8891.97	8872.51	8876.28	29627.0
2019-10-03 15:00:00	NQ	Futures	8876.28	8893.42	8856.53	8891.68	44830.0
2019-10-03 16:00:00	NQ	Futures	8891.39	8902.43	8890.23	8899.23	11430.0
2019-10-03 18:00:00	NQ	Futures	8896.91	8898.94	8887.61	8888.19	1746.0
2019-10-03 19:00:00	NQ	Futures	8887.61	8891.68	8879.77	8881.51	1466.0
2019-10-03 20:00:00	NQ	Futures	8881.51	8891.1	8878.32	8884.42	3455.0
2019-10-03 21:00:00	NQ	Futures	8884.71	8890.81	8875.41	8884.42	3534.0
2019-10-03 22:00:00	NQ	Futures	8884.71	8889.36	8880.35	8881.22	1962.0
2019-10-03 23:00:00	NQ	Futures	8880.64	8887.03	8878.03	8884.13	1706.0
2019-10-03 00:00:00	YM	Futures	28352.7	28360.3	28326.5	28340.7	1316.0
2019-10-03 01:00:00	YM	Futures	28345.0	28362.5	28333.1	28345.0	1115.0
2019-10-03 02:00:00	YM	Futures	28344.0	28391.8	28281.9	28388.6	4979.0
2019-10-03 03:00:00	YM	Futures	28387.5	28412.5	28350.5	28379.9	5842.0

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

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