PREVIEW / futures_1hour / 2018-12-03

all futures 1-hour files

  file:    by_date/futures_1hour/2018/2018-12-03.parquet
  size:    57 KB
  rows:    1,725

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-12-03 00:00:00	ES	Futures	3053.18	3055.63	3051.0	3054.27	7570.0
2018-12-03 01:00:00	ES	Futures	3054.27	3055.9	3052.36	3055.9	5840.0
2018-12-03 02:00:00	ES	Futures	3055.9	3060.52	3054.54	3060.25	22928.0
2018-12-03 03:00:00	ES	Futures	3059.98	3061.61	3056.44	3057.26	30170.0
2018-12-03 04:00:00	ES	Futures	3057.26	3059.44	3053.45	3056.44	23137.0
2018-12-03 05:00:00	ES	Futures	3056.44	3057.53	3051.82	3052.64	14920.0
2018-12-03 06:00:00	ES	Futures	3052.64	3053.18	3046.38	3048.01	20635.0
2018-12-03 07:00:00	ES	Futures	3048.01	3048.01	3041.21	3043.66	33302.0
2018-12-03 08:00:00	ES	Futures	3043.93	3047.74	3042.3	3044.75	39296.0
2018-12-03 09:00:00	ES	Futures	3044.75	3049.1	3029.79	3033.05	265050.0
2018-12-03 10:00:00	ES	Futures	3033.05	3042.03	3023.26	3024.89	316101.0
2018-12-03 11:00:00	ES	Futures	3024.89	3030.6	3017.55	3019.45	212781.0
2018-12-03 12:00:00	ES	Futures	3019.72	3034.14	3019.45	3028.7	127607.0
2018-12-03 13:00:00	ES	Futures	3028.43	3036.04	3022.99	3026.52	116386.0
2018-12-03 14:00:00	ES	Futures	3026.52	3033.32	3019.18	3029.79	140578.0
2018-12-03 15:00:00	ES	Futures	3030.06	3039.31	3025.71	3036.32	248033.0
2018-12-03 16:00:00	ES	Futures	3036.59	3040.4	3033.32	3035.23	86636.0
2018-12-03 18:00:00	ES	Futures	3035.23	3036.04	3030.6	3031.15	7943.0
2018-12-03 19:00:00	ES	Futures	3031.42	3032.78	3027.34	3027.88	8570.0
2018-12-03 20:00:00	ES	Futures	3027.88	3030.6	3026.25	3028.43	11708.0
2018-12-03 21:00:00	ES	Futures	3028.16	3029.52	3026.25	3027.07	7497.0
2018-12-03 22:00:00	ES	Futures	3026.8	3027.34	3022.17	3024.08	7988.0
2018-12-03 23:00:00	ES	Futures	3024.08	3024.62	3017.82	3021.08	8493.0
2018-12-03 00:00:00	NQ	Futures	8333.05	8338.92	8324.26	8332.76	3455.0
2018-12-03 01:00:00	NQ	Futures	8332.47	8349.48	8326.02	8348.6	3878.0
2018-12-03 02:00:00	NQ	Futures	8348.89	8365.03	8347.43	8361.8	9480.0
2018-12-03 03:00:00	NQ	Futures	8361.51	8375.88	8357.99	8362.97	10497.0
2018-12-03 04:00:00	NQ	Futures	8363.27	8372.07	8355.05	8367.96	6541.0
2018-12-03 05:00:00	NQ	Futures	8368.55	8370.01	8349.77	8353.59	4889.0
2018-12-03 06:00:00	NQ	Futures	8353.0	8353.59	8334.81	8338.63	6081.0
2018-12-03 07:00:00	NQ	Futures	8338.63	8339.21	8323.08	8333.64	9050.0
2018-12-03 08:00:00	NQ	Futures	8333.64	8340.39	8310.18	8318.68	17651.0
2018-12-03 09:00:00	NQ	Futures	8318.68	8339.21	8252.98	8270.29	83200.0
2018-12-03 10:00:00	NQ	Futures	8270.58	8330.12	8258.26	8262.37	98702.0
2018-12-03 11:00:00	NQ	Futures	8262.66	8291.4	8243.01	8247.99	65825.0
2018-12-03 12:00:00	NQ	Futures	8248.29	8287.3	8247.41	8270.58	47474.0
2018-12-03 13:00:00	NQ	Futures	8270.58	8290.52	8239.49	8253.27	48673.0
2018-12-03 14:00:00	NQ	Futures	8253.57	8278.21	8230.69	8265.59	38745.0
2018-12-03 15:00:00	NQ	Futures	8265.89	8294.04	8248.58	8289.94	56911.0
2018-12-03 16:00:00	NQ	Futures	8289.94	8292.58	8272.34	8277.03	12679.0
2018-12-03 18:00:00	NQ	Futures	8277.62	8277.62	8262.37	8265.89	3043.0
2018-12-03 19:00:00	NQ	Futures	8265.89	8271.46	8253.57	8255.33	3885.0
2018-12-03 20:00:00	NQ	Futures	8255.03	8261.49	8245.65	8253.86	4710.0
2018-12-03 21:00:00	NQ	Futures	8253.86	8258.26	8248.58	8253.27	3720.0
2018-12-03 22:00:00	NQ	Futures	8253.27	8253.86	8235.38	8241.54	3127.0
2018-12-03 23:00:00	NQ	Futures	8240.95	8243.89	8218.37	8227.46	4404.0
2018-12-03 00:00:00	YM	Futures	28264.5	28296.0	28251.5	28280.8	2323.0
2018-12-03 01:00:00	YM	Futures	28279.7	28291.7	28255.8	28290.6	2234.0
2018-12-03 02:00:00	YM	Futures	28290.6	28344.9	28275.4	28339.5	6582.0
2018-12-03 03:00:00	YM	Futures	28339.5	28342.8	28301.5	28304.7	5937.0

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

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