PREVIEW / futures_1hour / 2018-02-02

all futures 1-hour files

  file:    by_date/futures_1hour/2018/2018-02-02.parquet
  size:    50 KB
  rows:    1,418

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-02-02 00:00:00	ES	Futures	3082.87	3083.96	3078.77	3079.86	5113.0
2018-02-02 01:00:00	ES	Futures	3079.86	3082.59	3077.4	3082.59	5344.0
2018-02-02 02:00:00	ES	Futures	3082.32	3084.51	3077.4	3080.41	11189.0
2018-02-02 03:00:00	ES	Futures	3080.41	3081.23	3069.75	3070.84	29878.0
2018-02-02 04:00:00	ES	Futures	3070.84	3072.48	3062.91	3064.01	44369.0
2018-02-02 05:00:00	ES	Futures	3064.01	3065.92	3057.99	3063.19	43161.0
2018-02-02 06:00:00	ES	Futures	3063.46	3067.83	3061.82	3064.01	25148.0
2018-02-02 07:00:00	ES	Futures	3063.73	3068.38	3063.46	3067.83	23406.0
2018-02-02 08:00:00	ES	Futures	3067.83	3072.21	3060.73	3068.11	94116.0
2018-02-02 09:00:00	ES	Futures	3068.38	3069.75	3057.45	3060.73	218500.0
2018-02-02 10:00:00	ES	Futures	3060.45	3063.46	3049.52	3059.91	316851.0
2018-02-02 11:00:00	ES	Futures	3059.63	3062.09	3047.88	3048.15	184365.0
2018-02-02 12:00:00	ES	Futures	3048.43	3057.72	3046.79	3050.89	135110.0
2018-02-02 13:00:00	ES	Futures	3050.61	3051.16	3039.68	3042.41	180580.0
2018-02-02 14:00:00	ES	Futures	3042.69	3042.96	3024.1	3026.83	350535.0
2018-02-02 15:00:00	ES	Futures	3026.56	3032.57	3016.17	3017.54	520398.0
2018-02-02 16:00:00	ES	Futures	3017.54	3021.09	3012.35	3014.53	166098.0
2018-02-02 00:00:00	NQ	Futures	8223.67	8228.71	8216.85	8219.52	1553.0
2018-02-02 01:00:00	NQ	Futures	8220.11	8225.15	8215.96	8224.86	1495.0
2018-02-02 02:00:00	NQ	Futures	8224.86	8233.16	8209.73	8219.52	3493.0
2018-02-02 03:00:00	NQ	Futures	8219.22	8220.41	8181.55	8184.52	6200.0
2018-02-02 04:00:00	NQ	Futures	8184.82	8185.41	8148.63	8151.6	11000.0
2018-02-02 05:00:00	NQ	Futures	8151.6	8156.34	8135.88	8146.85	9018.0
2018-02-02 06:00:00	NQ	Futures	8146.85	8153.38	8120.16	8125.5	9958.0
2018-02-02 07:00:00	NQ	Futures	8125.5	8165.83	8121.34	8164.94	10850.0
2018-02-02 08:00:00	NQ	Futures	8164.94	8177.99	8133.21	8153.08	28183.0
2018-02-02 09:00:00	NQ	Futures	8153.38	8180.96	8109.48	8126.98	87973.0
2018-02-02 10:00:00	NQ	Futures	8127.28	8144.18	8070.92	8134.1	97036.0
2018-02-02 11:00:00	NQ	Futures	8133.5	8145.37	8099.69	8101.18	56725.0
2018-02-02 12:00:00	NQ	Futures	8101.47	8139.44	8091.09	8117.49	42787.0
2018-02-02 13:00:00	NQ	Futures	8117.19	8120.16	8082.49	8099.69	47451.0
2018-02-02 14:00:00	NQ	Futures	8099.69	8102.07	8051.64	8060.25	79561.0
2018-02-02 15:00:00	NQ	Futures	8060.54	8075.37	8021.69	8025.84	97195.0
2018-02-02 16:00:00	NQ	Futures	8025.84	8031.48	8010.71	8011.9	19269.0
2018-02-02 00:00:00	YM	Futures	28376.3	28387.1	28344.7	28353.4	939.0
2018-02-02 01:00:00	YM	Futures	28354.5	28402.4	28338.2	28400.2	1524.0
2018-02-02 02:00:00	YM	Futures	28399.1	28414.3	28343.7	28373.0	2920.0
2018-02-02 03:00:00	YM	Futures	28371.9	28382.8	28274.1	28283.9	7028.0
2018-02-02 04:00:00	YM	Futures	28286.1	28292.6	28195.8	28203.5	11112.0
2018-02-02 05:00:00	YM	Futures	28204.5	28207.8	28110.0	28146.9	11803.0
2018-02-02 06:00:00	YM	Futures	28149.1	28221.9	28138.2	28194.8	5945.0
2018-02-02 07:00:00	YM	Futures	28192.6	28213.2	28170.8	28198.0	6268.0
2018-02-02 08:00:00	YM	Futures	28198.0	28267.6	28158.9	28206.7	19951.0
2018-02-02 09:00:00	YM	Futures	28206.7	28224.1	28135.0	28153.5	35713.0
2018-02-02 10:00:00	YM	Futures	28153.5	28171.9	28036.1	28126.3	42073.0
2018-02-02 11:00:00	YM	Futures	28125.2	28125.2	27985.0	27989.3	26045.0
2018-02-02 12:00:00	YM	Futures	27989.3	28071.9	27961.1	28002.4	22006.0
2018-02-02 13:00:00	YM	Futures	28000.2	28024.1	27925.2	27950.2	28771.0
2018-02-02 14:00:00	YM	Futures	27951.3	27953.5	27770.9	27799.1	47485.0
2018-02-02 15:00:00	YM	Futures	27799.1	27853.5	27665.4	27685.0	54198.0

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

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