PREVIEW / futures_1hour / 2018-09-17

all futures 1-hour files

  file:    by_date/futures_1hour/2018/2018-09-17.parquet
  size:    53 KB
  rows:    1,644

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-09-17 00:00:00	ES	Futures	3162.8	3163.07	3162.25	3162.25	1314.0
2018-09-17 01:00:00	ES	Futures	3162.25	3162.52	3161.16	3162.25	2248.0
2018-09-17 02:00:00	ES	Futures	3162.25	3163.61	3160.62	3161.44	4247.0
2018-09-17 03:00:00	ES	Futures	3161.44	3163.07	3160.08	3162.25	10094.0
2018-09-17 04:00:00	ES	Futures	3162.25	3167.42	3161.44	3166.88	15573.0
2018-09-17 05:00:00	ES	Futures	3166.88	3167.15	3161.98	3162.52	8021.0
2018-09-17 06:00:00	ES	Futures	3162.52	3163.61	3161.44	3162.8	8191.0
2018-09-17 07:00:00	ES	Futures	3163.07	3165.24	3163.07	3164.7	10112.0
2018-09-17 08:00:00	ES	Futures	3164.7	3165.24	3162.8	3164.43	16058.0
2018-09-17 09:00:00	ES	Futures	3164.43	3166.33	3160.08	3161.98	107694.0
2018-09-17 10:00:00	ES	Futures	3161.98	3162.52	3154.36	3155.18	160384.0
2018-09-17 11:00:00	ES	Futures	3155.18	3160.08	3154.91	3158.72	93554.0
2018-09-17 12:00:00	ES	Futures	3158.99	3161.16	3156.0	3158.72	71350.0
2018-09-17 13:00:00	ES	Futures	3158.72	3159.8	3152.73	3156.54	95188.0
2018-09-17 14:00:00	ES	Futures	3156.54	3158.44	3152.19	3153.82	71022.0
2018-09-17 15:00:00	ES	Futures	3153.82	3154.91	3146.75	3149.74	240912.0
2018-09-17 16:00:00	ES	Futures	3149.74	3153.0	3149.47	3150.83	62442.0
2018-09-17 18:00:00	ES	Futures	3150.28	3151.1	3137.23	3138.04	19035.0
2018-09-17 19:00:00	ES	Futures	3138.04	3141.85	3138.04	3138.59	7885.0
2018-09-17 20:00:00	ES	Futures	3138.59	3142.12	3138.04	3140.76	7467.0
2018-09-17 21:00:00	ES	Futures	3140.49	3144.84	3139.4	3144.3	10549.0
2018-09-17 22:00:00	ES	Futures	3144.3	3146.48	3142.94	3146.48	5419.0
2018-09-17 23:00:00	ES	Futures	3146.48	3149.2	3146.2	3148.65	8780.0
2018-09-17 00:00:00	NQ	Futures	8873.05	8874.22	8867.18	8868.65	1008.0
2018-09-17 01:00:00	NQ	Futures	8868.65	8870.11	8862.49	8867.47	1235.0
2018-09-17 02:00:00	NQ	Futures	8867.18	8873.05	8862.78	8864.83	1755.0
2018-09-17 03:00:00	NQ	Futures	8864.54	8870.99	8858.38	8868.35	2977.0
2018-09-17 04:00:00	NQ	Futures	8868.65	8886.54	8866.01	8884.49	5489.0
2018-09-17 05:00:00	NQ	Futures	8884.49	8887.42	8868.65	8870.41	2867.0
2018-09-17 06:00:00	NQ	Futures	8870.41	8870.99	8864.54	8868.65	2675.0
2018-09-17 07:00:00	NQ	Futures	8868.94	8873.05	8860.43	8864.54	3627.0
2018-09-17 08:00:00	NQ	Futures	8864.54	8868.65	8858.38	8866.3	5369.0
2018-09-17 09:00:00	NQ	Futures	8866.3	8877.45	8821.72	8836.38	58981.0
2018-09-17 10:00:00	NQ	Futures	8836.38	8836.97	8779.77	8789.16	87042.0
2018-09-17 11:00:00	NQ	Futures	8788.57	8815.26	8786.81	8812.04	43304.0
2018-09-17 12:00:00	NQ	Futures	8812.04	8826.12	8805.29	8816.73	30053.0
2018-09-17 13:00:00	NQ	Futures	8816.73	8822.3	8790.33	8810.28	32024.0
2018-09-17 14:00:00	NQ	Futures	8809.98	8816.73	8791.8	8796.49	22547.0
2018-09-17 15:00:00	NQ	Futures	8796.49	8800.3	8750.15	8758.65	55641.0
2018-09-17 16:00:00	NQ	Futures	8758.36	8763.93	8754.25	8758.07	12268.0
2018-09-17 18:00:00	NQ	Futures	8756.6	8757.19	8712.31	8716.71	6247.0
2018-09-17 19:00:00	NQ	Futures	8716.12	8722.87	8708.2	8710.26	3243.0
2018-09-17 20:00:00	NQ	Futures	8710.84	8723.16	8708.79	8720.82	2682.0
2018-09-17 21:00:00	NQ	Futures	8720.52	8738.71	8718.47	8736.07	4891.0
2018-09-17 22:00:00	NQ	Futures	8736.07	8743.11	8728.44	8743.11	3112.0
2018-09-17 23:00:00	NQ	Futures	8742.81	8749.85	8740.47	8745.45	3750.0
2018-09-17 00:00:00	YM	Futures	28415.6	28419.9	28411.2	28411.2	208.0
2018-09-17 01:00:00	YM	Futures	28411.2	28412.3	28397.1	28408.0	505.0
2018-09-17 02:00:00	YM	Futures	28408.0	28423.2	28393.8	28397.1	1162.0
2018-09-17 03:00:00	YM	Futures	28396.0	28413.4	28381.9	28404.7	1935.0

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

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