PREVIEW / futures_1hour / 2019-01-25

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-01-25.parquet
  size:    49 KB
  rows:    1,446

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-01-25 00:00:00	ES	Futures	2877.98	2879.88	2876.9	2877.71	4638.0
2019-01-25 01:00:00	ES	Futures	2877.71	2879.07	2874.99	2876.62	5155.0
2019-01-25 02:00:00	ES	Futures	2876.9	2879.34	2875.54	2878.25	7221.0
2019-01-25 03:00:00	ES	Futures	2877.98	2882.06	2873.09	2880.7	23453.0
2019-01-25 04:00:00	ES	Futures	2880.7	2881.78	2875.54	2876.08	13549.0
2019-01-25 05:00:00	ES	Futures	2876.08	2883.68	2875.54	2882.06	13632.0
2019-01-25 06:00:00	ES	Futures	2882.33	2885.59	2881.51	2882.33	20882.0
2019-01-25 07:00:00	ES	Futures	2882.33	2882.6	2879.07	2882.33	20820.0
2019-01-25 08:00:00	ES	Futures	2882.33	2891.29	2881.78	2888.57	39672.0
2019-01-25 09:00:00	ES	Futures	2888.85	2893.46	2885.86	2892.1	164219.0
2019-01-25 10:00:00	ES	Futures	2891.83	2902.15	2891.83	2899.71	213524.0
2019-01-25 11:00:00	ES	Futures	2899.44	2901.07	2893.19	2898.62	118859.0
2019-01-25 12:00:00	ES	Futures	2898.62	2903.24	2889.93	2895.09	151213.0
2019-01-25 13:00:00	ES	Futures	2895.09	2898.35	2892.65	2897.54	74607.0
2019-01-25 14:00:00	ES	Futures	2897.54	2899.17	2889.66	2895.09	108908.0
2019-01-25 15:00:00	ES	Futures	2895.09	2896.18	2886.94	2893.19	220489.0
2019-01-25 16:00:00	ES	Futures	2893.19	2896.18	2889.93	2895.63	66865.0
2019-01-25 00:00:00	NQ	Futures	7867.49	7876.26	7861.65	7867.78	3836.0
2019-01-25 01:00:00	NQ	Futures	7867.49	7871.58	7859.89	7863.4	2204.0
2019-01-25 02:00:00	NQ	Futures	7863.4	7870.41	7857.85	7866.32	3970.0
2019-01-25 03:00:00	NQ	Futures	7866.03	7882.39	7848.79	7877.13	9862.0
2019-01-25 04:00:00	NQ	Futures	7876.55	7879.18	7861.94	7863.69	6428.0
2019-01-25 05:00:00	NQ	Futures	7863.98	7882.98	7860.48	7878.89	5351.0
2019-01-25 06:00:00	NQ	Futures	7878.89	7889.7	7875.09	7877.42	6424.0
2019-01-25 07:00:00	NQ	Futures	7877.42	7880.64	7868.37	7880.05	6252.0
2019-01-25 08:00:00	NQ	Futures	7880.35	7910.44	7878.59	7902.55	14441.0
2019-01-25 09:00:00	NQ	Futures	7902.55	7912.19	7876.26	7910.15	64114.0
2019-01-25 10:00:00	NQ	Futures	7910.15	7937.62	7908.98	7931.77	67892.0
2019-01-25 11:00:00	NQ	Futures	7931.77	7950.76	7920.38	7949.3	41954.0
2019-01-25 12:00:00	NQ	Futures	7949.89	7959.82	7925.93	7940.83	49642.0
2019-01-25 13:00:00	NQ	Futures	7941.12	7952.22	7930.9	7949.6	30823.0
2019-01-25 14:00:00	NQ	Futures	7949.89	7955.73	7921.55	7937.32	40400.0
2019-01-25 15:00:00	NQ	Futures	7937.62	7943.17	7919.79	7939.66	49784.0
2019-01-25 16:00:00	NQ	Futures	7939.66	7944.34	7928.56	7942.0	9536.0
2019-01-25 00:00:00	YM	Futures	26687.8	26705.1	26676.9	26686.7	1720.0
2019-01-25 01:00:00	YM	Futures	26686.7	26700.8	26671.5	26682.3	1876.0
2019-01-25 02:00:00	YM	Futures	26683.4	26707.3	26671.5	26700.8	2503.0
2019-01-25 03:00:00	YM	Futures	26699.7	26737.7	26651.9	26726.8	6222.0
2019-01-25 04:00:00	YM	Futures	26725.8	26734.4	26678.0	26683.4	4610.0
2019-01-25 05:00:00	YM	Futures	26684.5	26748.6	26674.7	26735.5	4024.0
2019-01-25 06:00:00	YM	Futures	26736.6	26769.2	26732.3	26746.4	5006.0
2019-01-25 07:00:00	YM	Futures	26746.4	26748.6	26716.0	26745.3	4052.0
2019-01-25 08:00:00	YM	Futures	26744.2	26826.7	26742.0	26809.4	7353.0
2019-01-25 09:00:00	YM	Futures	26809.4	26863.6	26788.7	26851.7	23279.0
2019-01-25 10:00:00	YM	Futures	26851.7	26958.1	26851.7	26931.0	27919.0
2019-01-25 11:00:00	YM	Futures	26932.0	26945.1	26835.4	26876.7	18518.0
2019-01-25 12:00:00	YM	Futures	26877.8	26913.6	26751.8	26803.9	21063.0
2019-01-25 13:00:00	YM	Futures	26803.9	26852.8	26783.3	26841.9	11536.0
2019-01-25 14:00:00	YM	Futures	26841.9	26862.6	26769.2	26827.8	14728.0
2019-01-25 15:00:00	YM	Futures	26828.9	26835.4	26752.9	26817.0	19907.0

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

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