PREVIEW / futures_1hour / 2019-04-12

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-04-12.parquet
  size:    47 KB
  rows:    1,415

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-04-12 00:00:00	ES	Futures	3138.82	3139.91	3138.55	3139.64	1994.0
2019-04-12 01:00:00	ES	Futures	3139.91	3140.45	3139.36	3139.91	3804.0
2019-04-12 02:00:00	ES	Futures	3139.64	3140.18	3138.28	3138.55	5140.0
2019-04-12 03:00:00	ES	Futures	3138.55	3139.91	3137.2	3139.09	8839.0
2019-04-12 04:00:00	ES	Futures	3139.09	3151.29	3139.09	3150.48	42979.0
2019-04-12 05:00:00	ES	Futures	3150.48	3151.02	3146.96	3147.5	18914.0
2019-04-12 06:00:00	ES	Futures	3147.5	3151.56	3147.5	3150.48	24247.0
2019-04-12 07:00:00	ES	Futures	3150.48	3154.27	3149.94	3151.84	25199.0
2019-04-12 08:00:00	ES	Futures	3151.56	3157.53	3151.29	3155.36	51799.0
2019-04-12 09:00:00	ES	Futures	3155.36	3160.78	3153.73	3158.88	201629.0
2019-04-12 10:00:00	ES	Futures	3159.15	3159.7	3148.85	3151.02	202158.0
2019-04-12 11:00:00	ES	Futures	3151.02	3151.84	3147.5	3151.02	126859.0
2019-04-12 12:00:00	ES	Futures	3150.75	3155.36	3149.4	3155.36	71257.0
2019-04-12 13:00:00	ES	Futures	3155.36	3156.71	3153.73	3154.0	54870.0
2019-04-12 14:00:00	ES	Futures	3154.0	3156.71	3152.92	3153.46	57617.0
2019-04-12 15:00:00	ES	Futures	3153.46	3158.34	3152.92	3157.8	161487.0
2019-04-12 16:00:00	ES	Futures	3157.8	3158.88	3156.44	3157.53	62650.0
2019-04-12 00:00:00	NQ	Futures	8872.69	8877.06	8870.94	8875.89	1072.0
2019-04-12 01:00:00	NQ	Futures	8876.18	8878.22	8874.73	8876.18	1766.0
2019-04-12 02:00:00	NQ	Futures	8875.89	8877.93	8872.11	8872.69	2565.0
2019-04-12 03:00:00	NQ	Futures	8872.4	8882.3	8870.94	8879.39	3794.0
2019-04-12 04:00:00	NQ	Futures	8879.39	8914.32	8879.39	8911.7	12862.0
2019-04-12 05:00:00	NQ	Futures	8912.0	8912.58	8903.26	8904.13	6468.0
2019-04-12 06:00:00	NQ	Futures	8903.84	8911.7	8899.77	8906.17	8249.0
2019-04-12 07:00:00	NQ	Futures	8905.88	8919.57	8902.39	8908.21	9480.0
2019-04-12 08:00:00	NQ	Futures	8908.21	8926.84	8906.75	8912.87	14119.0
2019-04-12 09:00:00	NQ	Futures	8913.16	8916.07	8893.07	8905.59	56909.0
2019-04-12 10:00:00	NQ	Futures	8905.59	8912.0	8885.5	8892.2	61484.0
2019-04-12 11:00:00	NQ	Futures	8892.49	8893.65	8871.52	8890.74	42935.0
2019-04-12 12:00:00	NQ	Futures	8890.45	8898.89	8885.5	8898.31	21598.0
2019-04-12 13:00:00	NQ	Futures	8898.31	8903.26	8891.91	8893.94	19957.0
2019-04-12 14:00:00	NQ	Futures	8894.24	8907.34	8891.91	8901.51	19560.0
2019-04-12 15:00:00	NQ	Futures	8901.81	8909.96	8898.6	8909.67	33160.0
2019-04-12 16:00:00	NQ	Futures	8909.67	8914.03	8907.63	8914.03	9058.0
2019-04-12 00:00:00	YM	Futures	28468.6	28479.5	28465.3	28476.2	430.0
2019-04-12 01:00:00	YM	Futures	28477.3	28487.1	28474.0	28477.3	813.0
2019-04-12 02:00:00	YM	Futures	28477.3	28482.7	28458.8	28468.6	1664.0
2019-04-12 03:00:00	YM	Futures	28469.7	28483.8	28456.6	28478.4	1834.0
2019-04-12 04:00:00	YM	Futures	28479.5	28615.4	28478.4	28613.3	7923.0
2019-04-12 05:00:00	YM	Futures	28613.3	28618.7	28581.7	28595.9	3304.0
2019-04-12 06:00:00	YM	Futures	28594.8	28630.7	28589.3	28605.6	5436.0
2019-04-12 07:00:00	YM	Futures	28604.6	28637.2	28604.6	28623.0	3565.0
2019-04-12 08:00:00	YM	Futures	28622.0	28694.8	28618.7	28682.9	8153.0
2019-04-12 09:00:00	YM	Futures	28681.8	28759.0	28668.7	28722.0	28125.0
2019-04-12 10:00:00	YM	Futures	28723.1	28731.8	28616.5	28649.2	31879.0
2019-04-12 11:00:00	YM	Futures	28649.2	28672.0	28617.6	28662.2	17174.0
2019-04-12 12:00:00	YM	Futures	28662.2	28707.9	28645.9	28706.8	10274.0
2019-04-12 13:00:00	YM	Futures	28707.9	28722.0	28703.5	28710.1	10140.0
2019-04-12 14:00:00	YM	Futures	28710.1	28729.6	28678.5	28687.2	11304.0
2019-04-12 15:00:00	YM	Futures	28688.3	28730.7	28682.9	28726.4	17503.0

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

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