PREVIEW / futures_1hour / 2017-12-01

all futures 1-hour files

  file:    by_date/futures_1hour/2017/2017-12-01.parquet
  size:    47 KB
  rows:    1,370

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
2017-12-01 00:00:00	ES	Futures	2890.69	2890.97	2889.87	2890.42	3689.0
2017-12-01 01:00:00	ES	Futures	2890.42	2892.34	2887.41	2892.34	8759.0
2017-12-01 02:00:00	ES	Futures	2892.34	2894.52	2891.51	2894.25	13018.0
2017-12-01 03:00:00	ES	Futures	2894.25	2895.07	2887.96	2889.05	35486.0
2017-12-01 04:00:00	ES	Futures	2889.05	2891.51	2886.86	2890.69	37908.0
2017-12-01 05:00:00	ES	Futures	2890.69	2891.51	2879.2	2881.39	50541.0
2017-12-01 06:00:00	ES	Futures	2881.39	2887.14	2880.57	2884.13	40773.0
2017-12-01 07:00:00	ES	Futures	2883.85	2889.33	2883.58	2888.51	37700.0
2017-12-01 08:00:00	ES	Futures	2888.51	2896.44	2888.23	2893.43	68936.0
2017-12-01 09:00:00	ES	Futures	2893.16	2898.35	2891.79	2894.8	209542.0
2017-12-01 10:00:00	ES	Futures	2894.52	2900.54	2892.06	2898.35	227953.0
2017-12-01 11:00:00	ES	Futures	2898.35	2899.17	2850.48	2876.74	804771.0
2017-12-01 12:00:00	ES	Futures	2876.74	2883.58	2872.64	2882.76	260026.0
2017-12-01 13:00:00	ES	Futures	2882.49	2888.78	2880.57	2885.77	110614.0
2017-12-01 14:00:00	ES	Futures	2885.77	2888.23	2882.21	2884.4	104010.0
2017-12-01 15:00:00	ES	Futures	2884.4	2892.06	2881.39	2890.97	256806.0
2017-12-01 16:00:00	ES	Futures	2890.69	2893.98	2889.87	2891.79	106732.0
2017-12-01 00:00:00	NQ	Futures	7562.71	7563.3	7558.24	7560.03	1176.0
2017-12-01 01:00:00	NQ	Futures	7560.03	7563.89	7552.59	7563.0	1812.0
2017-12-01 02:00:00	NQ	Futures	7562.71	7574.01	7560.03	7573.71	3614.0
2017-12-01 03:00:00	NQ	Futures	7573.71	7575.49	7544.27	7547.24	5369.0
2017-12-01 04:00:00	NQ	Futures	7547.54	7549.02	7535.34	7546.05	6043.0
2017-12-01 05:00:00	NQ	Futures	7546.35	7546.64	7506.79	7513.04	6575.0
2017-12-01 06:00:00	NQ	Futures	7512.74	7530.58	7508.28	7521.07	6295.0
2017-12-01 07:00:00	NQ	Futures	7521.36	7535.34	7518.99	7531.48	6946.0
2017-12-01 08:00:00	NQ	Futures	7531.48	7553.49	7530.88	7539.51	14039.0
2017-12-01 09:00:00	NQ	Futures	7539.8	7561.22	7520.77	7542.18	71057.0
2017-12-01 10:00:00	NQ	Futures	7541.89	7576.98	7537.42	7565.08	65197.0
2017-12-01 11:00:00	NQ	Futures	7564.79	7570.74	7430.65	7500.55	209759.0
2017-12-01 12:00:00	NQ	Futures	7500.25	7525.23	7478.24	7522.55	84575.0
2017-12-01 13:00:00	NQ	Futures	7522.55	7538.02	7511.55	7525.53	29345.0
2017-12-01 14:00:00	NQ	Futures	7525.53	7539.21	7516.61	7524.64	22598.0
2017-12-01 15:00:00	NQ	Futures	7524.64	7547.83	7513.63	7542.18	39763.0
2017-12-01 16:00:00	NQ	Futures	7541.89	7551.4	7540.99	7548.13	9140.0
2017-12-01 00:00:00	YM	Futures	26390.5	26394.8	26379.6	26385.0	988.0
2017-12-01 01:00:00	YM	Futures	26385.0	26402.4	26366.6	26402.4	2514.0
2017-12-01 02:00:00	YM	Futures	26401.4	26428.6	26399.2	26418.8	2660.0
2017-12-01 03:00:00	YM	Futures	26419.9	26426.4	26356.8	26365.5	5168.0
2017-12-01 04:00:00	YM	Futures	26364.4	26382.9	26340.5	26373.1	4249.0
2017-12-01 05:00:00	YM	Futures	26373.1	26380.7	26269.8	26289.3	6735.0
2017-12-01 06:00:00	YM	Futures	26289.3	26349.2	26285.0	26307.8	6375.0
2017-12-01 07:00:00	YM	Futures	26307.8	26355.7	26306.7	26341.5	6507.0
2017-12-01 08:00:00	YM	Futures	26341.5	26418.8	26340.5	26386.1	11427.0
2017-12-01 09:00:00	YM	Futures	26385.0	26446.0	26344.8	26368.7	28506.0
2017-12-01 10:00:00	YM	Futures	26367.6	26457.9	26325.2	26441.6	31806.0
2017-12-01 11:00:00	YM	Futures	26441.6	26446.0	26021.8	26253.4	114785.0
2017-12-01 12:00:00	YM	Futures	26252.3	26313.3	26219.7	26292.6	43465.0
2017-12-01 13:00:00	YM	Futures	26291.5	26338.3	26268.7	26315.4	23207.0
2017-12-01 14:00:00	YM	Futures	26314.3	26331.7	26289.3	26303.5	15214.0
2017-12-01 15:00:00	YM	Futures	26303.5	26376.3	26278.5	26354.6	19165.0

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

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