PREVIEW / futures_1hour / 2018-03-27

all futures 1-hour files

  file:    by_date/futures_1hour/2018/2018-03-27.parquet
  size:    56 KB
  rows:    1,690

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-03-27 00:00:00	ES	Futures	2915.75	2918.21	2912.75	2913.57	4457.0
2018-03-27 01:00:00	ES	Futures	2913.57	2917.66	2912.2	2916.57	5011.0
2018-03-27 02:00:00	ES	Futures	2916.57	2922.85	2914.66	2922.03	16484.0
2018-03-27 03:00:00	ES	Futures	2922.03	2923.94	2915.48	2917.93	24350.0
2018-03-27 04:00:00	ES	Futures	2917.93	2920.93	2913.29	2920.12	18726.0
2018-03-27 05:00:00	ES	Futures	2920.12	2925.3	2919.02	2925.03	13169.0
2018-03-27 06:00:00	ES	Futures	2925.03	2925.03	2917.11	2917.66	15229.0
2018-03-27 07:00:00	ES	Futures	2917.66	2921.75	2916.3	2918.21	17171.0
2018-03-27 08:00:00	ES	Futures	2917.93	2919.02	2911.66	2912.2	30763.0
2018-03-27 09:00:00	ES	Futures	2912.2	2915.75	2899.65	2908.65	213409.0
2018-03-27 10:00:00	ES	Futures	2908.65	2913.02	2895.55	2902.92	285414.0
2018-03-27 11:00:00	ES	Futures	2903.2	2920.66	2897.74	2918.75	217474.0
2018-03-27 12:00:00	ES	Futures	2918.48	2921.21	2904.83	2911.66	192403.0
2018-03-27 13:00:00	ES	Futures	2911.66	2918.21	2892.83	2899.92	192671.0
2018-03-27 14:00:00	ES	Futures	2899.92	2902.92	2878.91	2880.0	269441.0
2018-03-27 15:00:00	ES	Futures	2880.0	2881.09	2833.88	2852.71	687324.0
2018-03-27 16:00:00	ES	Futures	2852.71	2859.26	2849.43	2852.16	104173.0
2018-03-27 18:00:00	ES	Futures	2852.16	2855.16	2846.98	2854.07	13067.0
2018-03-27 19:00:00	ES	Futures	2854.35	2857.07	2848.34	2855.44	10582.0
2018-03-27 20:00:00	ES	Futures	2855.44	2863.35	2855.16	2857.89	13980.0
2018-03-27 21:00:00	ES	Futures	2857.89	2864.44	2852.16	2863.08	18951.0
2018-03-27 22:00:00	ES	Futures	2863.08	2863.35	2856.8	2858.98	7850.0
2018-03-27 23:00:00	ES	Futures	2858.98	2860.08	2852.98	2855.71	6758.0
2018-03-27 00:00:00	NQ	Futures	8050.3	8055.62	8036.7	8040.25	2906.0
2018-03-27 01:00:00	NQ	Futures	8039.66	8054.73	8037.0	8051.77	2366.0
2018-03-27 02:00:00	NQ	Futures	8052.07	8080.74	8044.38	8076.3	5968.0
2018-03-27 03:00:00	NQ	Futures	8076.01	8092.26	8065.66	8073.94	8581.0
2018-03-27 04:00:00	NQ	Futures	8073.94	8079.85	8053.84	8077.19	6246.0
2018-03-27 05:00:00	NQ	Futures	8077.19	8096.69	8071.57	8095.81	5692.0
2018-03-27 06:00:00	NQ	Futures	8095.81	8096.1	8067.73	8072.16	5620.0
2018-03-27 07:00:00	NQ	Futures	8072.46	8089.6	8070.1	8076.89	7384.0
2018-03-27 08:00:00	NQ	Futures	8077.19	8080.14	8053.84	8055.32	10103.0
2018-03-27 09:00:00	NQ	Futures	8055.32	8061.82	8008.33	8040.25	75159.0
2018-03-27 10:00:00	NQ	Futures	8040.25	8052.96	7990.3	7997.99	95700.0
2018-03-27 11:00:00	NQ	Futures	7997.99	8042.02	7976.41	8026.06	69697.0
2018-03-27 12:00:00	NQ	Futures	8026.06	8032.86	7944.2	7972.87	70068.0
2018-03-27 13:00:00	NQ	Futures	7973.16	7989.42	7893.66	7913.76	70633.0
2018-03-27 14:00:00	NQ	Futures	7913.76	7913.76	7828.65	7833.37	92358.0
2018-03-27 15:00:00	NQ	Futures	7832.78	7835.74	7672.01	7735.55	154669.0
2018-03-27 16:00:00	NQ	Futures	7736.14	7760.97	7732.6	7745.6	15871.0
2018-03-27 18:00:00	NQ	Futures	7743.24	7746.49	7722.85	7743.53	4534.0
2018-03-27 19:00:00	NQ	Futures	7744.72	7747.08	7725.8	7742.94	3408.0
2018-03-27 20:00:00	NQ	Futures	7742.65	7771.31	7742.06	7752.69	7333.0
2018-03-27 21:00:00	NQ	Futures	7752.99	7781.07	7735.55	7779.29	9400.0
2018-03-27 22:00:00	NQ	Futures	7779.0	7780.47	7755.35	7760.67	4245.0
2018-03-27 23:00:00	NQ	Futures	7760.67	7765.7	7740.28	7747.67	3665.0
2018-03-27 00:00:00	YM	Futures	26414.3	26429.5	26378.4	26383.8	2298.0
2018-03-27 01:00:00	YM	Futures	26381.7	26420.8	26370.8	26408.8	2149.0
2018-03-27 02:00:00	YM	Futures	26409.9	26490.3	26394.7	26478.3	6816.0
2018-03-27 03:00:00	YM	Futures	26477.2	26483.8	26401.2	26418.6	6740.0

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

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