PREVIEW / futures_1hour / 2018-04-13

all futures 1-hour files

  file:    by_date/futures_1hour/2018/2018-04-13.parquet
  size:    46 KB
  rows:    1,368

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-04-13 00:00:00	ES	Futures	2899.65	2901.83	2899.1	2901.01	1685.0
2018-04-13 01:00:00	ES	Futures	2901.29	2904.83	2900.74	2904.56	4436.0
2018-04-13 02:00:00	ES	Futures	2904.56	2912.47	2904.56	2911.93	11198.0
2018-04-13 03:00:00	ES	Futures	2912.2	2912.2	2905.92	2910.84	11442.0
2018-04-13 04:00:00	ES	Futures	2910.56	2911.11	2908.38	2910.84	7303.0
2018-04-13 05:00:00	ES	Futures	2910.84	2914.66	2909.75	2914.11	7518.0
2018-04-13 06:00:00	ES	Futures	2914.11	2917.66	2911.38	2916.57	14713.0
2018-04-13 07:00:00	ES	Futures	2916.84	2918.21	2913.57	2916.84	18434.0
2018-04-13 08:00:00	ES	Futures	2917.11	2925.57	2915.75	2923.94	42477.0
2018-04-13 09:00:00	ES	Futures	2924.21	2926.12	2914.66	2915.2	160820.0
2018-04-13 10:00:00	ES	Futures	2915.2	2917.39	2898.28	2898.56	308812.0
2018-04-13 11:00:00	ES	Futures	2898.56	2907.84	2893.92	2907.02	195646.0
2018-04-13 12:00:00	ES	Futures	2907.02	2910.02	2901.01	2904.83	130472.0
2018-04-13 13:00:00	ES	Futures	2904.56	2912.47	2904.56	2909.47	105153.0
2018-04-13 14:00:00	ES	Futures	2909.47	2911.11	2900.74	2901.83	144960.0
2018-04-13 15:00:00	ES	Futures	2901.56	2902.65	2887.09	2899.65	365032.0
2018-04-13 16:00:00	ES	Futures	2899.65	2902.92	2898.28	2902.92	66117.0
2018-04-13 00:00:00	NQ	Futures	7861.45	7866.47	7858.79	7865.88	1260.0
2018-04-13 01:00:00	NQ	Futures	7866.18	7872.98	7863.81	7870.91	1897.0
2018-04-13 02:00:00	NQ	Futures	7870.61	7886.57	7870.32	7880.66	5402.0
2018-04-13 03:00:00	NQ	Futures	7880.96	7881.25	7860.27	7874.45	5041.0
2018-04-13 04:00:00	NQ	Futures	7874.16	7876.82	7867.95	7876.52	2292.0
2018-04-13 05:00:00	NQ	Futures	7875.93	7885.98	7873.27	7885.39	2284.0
2018-04-13 06:00:00	NQ	Futures	7885.39	7899.87	7878.89	7896.62	3767.0
2018-04-13 07:00:00	NQ	Futures	7896.91	7899.87	7887.16	7898.39	5628.0
2018-04-13 08:00:00	NQ	Futures	7898.69	7926.17	7895.44	7923.51	10066.0
2018-04-13 09:00:00	NQ	Futures	7923.81	7935.63	7891.89	7895.73	52330.0
2018-04-13 10:00:00	NQ	Futures	7895.73	7903.12	7836.92	7852.29	90871.0
2018-04-13 11:00:00	NQ	Futures	7852.29	7876.52	7832.19	7868.25	50716.0
2018-04-13 12:00:00	NQ	Futures	7868.25	7878.3	7852.29	7870.91	36968.0
2018-04-13 13:00:00	NQ	Futures	7870.91	7891.3	7867.66	7884.21	40556.0
2018-04-13 14:00:00	NQ	Futures	7883.91	7889.53	7854.36	7858.5	46066.0
2018-04-13 15:00:00	NQ	Futures	7857.9	7858.79	7809.44	7843.72	79364.0
2018-04-13 16:00:00	NQ	Futures	7843.72	7853.47	7840.47	7851.99	8771.0
2018-04-13 00:00:00	YM	Futures	26492.5	26508.7	26489.2	26504.4	699.0
2018-04-13 01:00:00	YM	Futures	26505.5	26541.3	26504.4	26540.2	1769.0
2018-04-13 02:00:00	YM	Futures	26540.2	26610.8	26540.2	26606.5	3385.0
2018-04-13 03:00:00	YM	Futures	26607.6	26608.7	26550.0	26592.4	3428.0
2018-04-13 04:00:00	YM	Futures	26592.4	26596.7	26572.8	26593.5	1731.0
2018-04-13 05:00:00	YM	Futures	26593.5	26627.1	26582.6	26626.0	1781.0
2018-04-13 06:00:00	YM	Futures	26627.1	26648.8	26594.5	26635.8	3403.0
2018-04-13 07:00:00	YM	Futures	26635.8	26653.2	26613.0	26648.8	3068.0
2018-04-13 08:00:00	YM	Futures	26649.9	26733.5	26633.6	26723.8	7491.0
2018-04-13 09:00:00	YM	Futures	26724.9	26745.5	26598.9	26603.2	29951.0
2018-04-13 10:00:00	YM	Futures	26601.1	26624.9	26437.1	26437.1	51773.0
2018-04-13 11:00:00	YM	Futures	26437.1	26512.0	26390.4	26504.4	30748.0
2018-04-13 12:00:00	YM	Futures	26504.4	26535.9	26436.0	26466.4	24706.0
2018-04-13 13:00:00	YM	Futures	26466.4	26534.8	26463.1	26504.4	21583.0
2018-04-13 14:00:00	YM	Futures	26504.4	26523.9	26429.5	26438.1	21574.0
2018-04-13 15:00:00	YM	Futures	26439.2	26443.6	26288.3	26422.9	49772.0

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

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