PREVIEW / futures_1hour / 2018-10-29

all futures 1-hour files

  file:    by_date/futures_1hour/2018/2018-10-29.parquet
  size:    58 KB
  rows:    1,733

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-29 00:00:00	ES	Futures	2900.86	2905.21	2900.86	2901.4	6782.0
2018-10-29 01:00:00	ES	Futures	2901.4	2906.03	2895.69	2897.05	10764.0
2018-10-29 02:00:00	ES	Futures	2897.32	2898.14	2894.06	2895.69	10612.0
2018-10-29 03:00:00	ES	Futures	2895.42	2901.95	2894.33	2900.86	14881.0
2018-10-29 04:00:00	ES	Futures	2900.59	2904.94	2896.51	2899.5	26319.0
2018-10-29 05:00:00	ES	Futures	2899.5	2917.72	2896.51	2916.36	39573.0
2018-10-29 06:00:00	ES	Futures	2916.09	2929.15	2914.19	2927.24	47432.0
2018-10-29 07:00:00	ES	Futures	2927.24	2938.4	2926.16	2928.06	45628.0
2018-10-29 08:00:00	ES	Futures	2928.33	2935.68	2928.06	2935.13	36404.0
2018-10-29 09:00:00	ES	Futures	2935.13	2935.13	2923.44	2931.6	230021.0
2018-10-29 10:00:00	ES	Futures	2931.87	2945.2	2926.16	2933.23	266195.0
2018-10-29 11:00:00	ES	Futures	2933.23	2936.22	2914.19	2914.46	215835.0
2018-10-29 12:00:00	ES	Futures	2914.46	2916.36	2900.86	2905.76	281892.0
2018-10-29 13:00:00	ES	Futures	2905.76	2919.63	2905.48	2909.84	239303.0
2018-10-29 14:00:00	ES	Futures	2909.84	2910.11	2879.92	2883.18	330430.0
2018-10-29 15:00:00	ES	Futures	2883.45	2884.27	2832.05	2875.57	715820.0
2018-10-29 16:00:00	ES	Futures	2874.75	2878.56	2869.31	2871.76	97663.0
2018-10-29 18:00:00	ES	Futures	2871.21	2874.21	2868.22	2871.49	10707.0
2018-10-29 19:00:00	ES	Futures	2871.49	2876.93	2871.21	2874.48	9346.0
2018-10-29 20:00:00	ES	Futures	2874.21	2888.62	2870.13	2885.9	22221.0
2018-10-29 21:00:00	ES	Futures	2885.9	2890.53	2879.37	2884.81	25144.0
2018-10-29 22:00:00	ES	Futures	2884.81	2891.89	2880.73	2888.89	17827.0
2018-10-29 23:00:00	ES	Futures	2889.17	2892.7	2888.08	2890.53	8066.0
2018-10-29 00:00:00	NQ	Futures	8101.63	8119.82	8101.34	8106.62	2300.0
2018-10-29 01:00:00	NQ	Futures	8105.44	8125.1	8091.07	8096.94	4463.0
2018-10-29 02:00:00	NQ	Futures	8097.23	8097.23	8076.41	8080.51	3460.0
2018-10-29 03:00:00	NQ	Futures	8080.22	8111.02	8075.23	8103.98	5730.0
2018-10-29 04:00:00	NQ	Futures	8103.98	8116.59	8085.2	8096.35	10152.0
2018-10-29 05:00:00	NQ	Futures	8096.06	8166.45	8087.26	8161.47	17029.0
2018-10-29 06:00:00	NQ	Futures	8160.88	8177.31	8149.73	8169.97	18212.0
2018-10-29 07:00:00	NQ	Futures	8169.68	8202.82	8163.52	8169.39	24522.0
2018-10-29 08:00:00	NQ	Futures	8169.68	8190.21	8169.09	8184.93	15586.0
2018-10-29 09:00:00	NQ	Futures	8184.64	8186.1	8120.11	8147.09	84746.0
2018-10-29 10:00:00	NQ	Futures	8147.39	8192.56	8108.67	8116.3	82963.0
2018-10-29 11:00:00	NQ	Futures	8116.88	8131.84	8039.74	8040.91	90180.0
2018-10-29 12:00:00	NQ	Futures	8041.21	8047.07	7962.31	7995.16	109224.0
2018-10-29 13:00:00	NQ	Futures	7996.33	8047.95	7993.4	8009.53	74164.0
2018-10-29 14:00:00	NQ	Futures	8008.94	8011.0	7892.2	7907.46	105199.0
2018-10-29 15:00:00	NQ	Futures	7908.04	7911.56	7720.61	7896.31	188302.0
2018-10-29 16:00:00	NQ	Futures	7897.19	7910.1	7869.62	7886.63	26024.0
2018-10-29 18:00:00	NQ	Futures	7883.4	7883.7	7863.46	7874.02	3371.0
2018-10-29 19:00:00	NQ	Futures	7874.9	7901.59	7874.02	7894.26	3591.0
2018-10-29 20:00:00	NQ	Futures	7893.38	7945.59	7878.71	7933.85	18394.0
2018-10-29 21:00:00	NQ	Futures	7933.85	7947.64	7908.34	7920.95	15444.0
2018-10-29 22:00:00	NQ	Futures	7921.24	7945.29	7905.11	7933.56	9964.0
2018-10-29 23:00:00	NQ	Futures	7933.85	7945.0	7926.23	7934.44	3013.0
2018-10-29 00:00:00	YM	Futures	26859.7	26897.7	26859.7	26867.3	2508.0
2018-10-29 01:00:00	YM	Futures	26865.1	26904.2	26804.3	26813.0	3646.0
2018-10-29 02:00:00	YM	Futures	26817.3	26836.9	26785.8	26811.9	3113.0
2018-10-29 03:00:00	YM	Futures	26810.8	26872.7	26802.1	26865.1	3880.0

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

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