PREVIEW / futures_1hour / 2018-03-29

all futures 1-hour files

  file:    by_date/futures_1hour/2018/2018-03-29.parquet
  size:    47 KB
  rows:    1,382

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-29 00:00:00	ES	Futures	2844.25	2845.61	2841.25	2841.79	3316.0
2018-03-29 01:00:00	ES	Futures	2841.79	2849.16	2839.88	2848.61	7147.0
2018-03-29 02:00:00	ES	Futures	2848.61	2853.8	2845.34	2853.8	14457.0
2018-03-29 03:00:00	ES	Futures	2853.53	2853.8	2845.89	2852.16	20438.0
2018-03-29 04:00:00	ES	Futures	2851.89	2855.44	2847.25	2854.35	12896.0
2018-03-29 05:00:00	ES	Futures	2854.07	2860.08	2851.62	2859.8	19004.0
2018-03-29 06:00:00	ES	Futures	2859.8	2859.8	2855.44	2855.44	12982.0
2018-03-29 07:00:00	ES	Futures	2855.71	2860.9	2855.16	2859.26	15500.0
2018-03-29 08:00:00	ES	Futures	2858.98	2859.53	2852.43	2857.07	29745.0
2018-03-29 09:00:00	ES	Futures	2856.8	2864.17	2848.34	2851.34	211031.0
2018-03-29 10:00:00	ES	Futures	2851.34	2875.9	2849.43	2875.63	282736.0
2018-03-29 11:00:00	ES	Futures	2875.63	2884.09	2868.81	2877.27	261225.0
2018-03-29 12:00:00	ES	Futures	2877.27	2878.63	2867.72	2875.63	125135.0
2018-03-29 13:00:00	ES	Futures	2875.9	2887.91	2869.9	2884.64	134659.0
2018-03-29 14:00:00	ES	Futures	2884.37	2898.56	2881.09	2893.92	185652.0
2018-03-29 15:00:00	ES	Futures	2893.64	2903.2	2882.73	2883.82	437616.0
2018-03-29 16:00:00	ES	Futures	2883.82	2885.46	2875.9	2879.18	129717.0
2018-03-29 00:00:00	NQ	Futures	7665.51	7670.83	7657.24	7659.01	2146.0
2018-03-29 01:00:00	NQ	Futures	7659.01	7682.65	7655.46	7682.06	4069.0
2018-03-29 02:00:00	NQ	Futures	7681.77	7707.18	7670.54	7705.11	7902.0
2018-03-29 03:00:00	NQ	Futures	7704.82	7704.82	7680.29	7695.36	6495.0
2018-03-29 04:00:00	NQ	Futures	7695.07	7704.23	7679.4	7701.86	4636.0
2018-03-29 05:00:00	NQ	Futures	7700.68	7727.57	7688.86	7723.44	6599.0
2018-03-29 06:00:00	NQ	Futures	7722.85	7723.73	7698.32	7699.2	5526.0
2018-03-29 07:00:00	NQ	Futures	7699.79	7731.71	7699.2	7720.19	7116.0
2018-03-29 08:00:00	NQ	Futures	7719.6	7721.07	7687.09	7703.34	16489.0
2018-03-29 09:00:00	NQ	Futures	7703.64	7714.28	7617.34	7633.6	76908.0
2018-03-29 10:00:00	NQ	Futures	7633.6	7759.49	7625.32	7758.9	106107.0
2018-03-29 11:00:00	NQ	Futures	7759.2	7774.86	7714.57	7743.24	85893.0
2018-03-29 12:00:00	NQ	Futures	7743.53	7762.74	7706.0	7754.47	42170.0
2018-03-29 13:00:00	NQ	Futures	7753.88	7821.85	7723.73	7807.96	53398.0
2018-03-29 14:00:00	NQ	Futures	7807.37	7854.36	7790.82	7840.17	64197.0
2018-03-29 15:00:00	NQ	Futures	7839.88	7865.59	7785.5	7789.64	104307.0
2018-03-29 16:00:00	NQ	Futures	7789.64	7791.7	7759.49	7767.18	20009.0
2018-03-29 00:00:00	YM	Futures	25888.6	25900.6	25874.5	25877.8	1953.0
2018-03-29 01:00:00	YM	Futures	25876.7	25942.9	25860.4	25937.5	3156.0
2018-03-29 02:00:00	YM	Futures	25937.5	25974.4	25911.4	25970.1	4726.0
2018-03-29 03:00:00	YM	Futures	25970.1	25971.2	25911.4	25952.7	4790.0
2018-03-29 04:00:00	YM	Futures	25952.7	25975.5	25919.0	25966.8	2960.0
2018-03-29 05:00:00	YM	Futures	25963.6	26011.3	25945.1	26008.1	3379.0
2018-03-29 06:00:00	YM	Futures	26008.1	26014.6	25982.0	25982.0	2743.0
2018-03-29 07:00:00	YM	Futures	25984.2	26029.8	25979.8	26013.5	3883.0
2018-03-29 08:00:00	YM	Futures	26011.3	26025.5	25958.1	25999.4	6722.0
2018-03-29 09:00:00	YM	Futures	26000.5	26088.4	25967.9	25992.9	29025.0
2018-03-29 10:00:00	YM	Futures	25992.9	26142.8	25958.1	26142.8	45333.0
2018-03-29 11:00:00	YM	Futures	26140.6	26236.1	26109.1	26188.4	37458.0
2018-03-29 12:00:00	YM	Futures	26188.4	26200.3	26092.8	26136.2	20888.0
2018-03-29 13:00:00	YM	Futures	26137.3	26263.3	26085.2	26235.1	21546.0
2018-03-29 14:00:00	YM	Futures	26235.1	26337.1	26200.3	26299.1	32068.0
2018-03-29 15:00:00	YM	Futures	26299.1	26377.3	26206.8	26211.2	47718.0

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

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