PREVIEW / futures_1hour / 2018-04-02

all futures 1-hour files

  file:    by_date/futures_1hour/2018/2018-04-02.parquet
  size:    45 KB
  rows:    1,315

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-02 00:00:00	ES	Futures	2879.45	2880.0	2875.9	2879.18	3857.0
2018-04-02 01:00:00	ES	Futures	2879.18	2881.64	2876.45	2877.27	3399.0
2018-04-02 02:00:00	ES	Futures	2877.0	2877.54	2873.45	2874.81	3745.0
2018-04-02 03:00:00	ES	Futures	2874.54	2877.0	2873.18	2876.72	3159.0
2018-04-02 04:00:00	ES	Futures	2877.0	2878.36	2875.36	2875.36	3070.0
2018-04-02 05:00:00	ES	Futures	2875.36	2878.09	2874.81	2877.82	3060.0
2018-04-02 06:00:00	ES	Futures	2877.82	2879.73	2876.45	2876.72	5561.0
2018-04-02 07:00:00	ES	Futures	2876.72	2877.0	2869.36	2872.36	15400.0
2018-04-02 08:00:00	ES	Futures	2872.36	2877.27	2870.99	2876.18	23958.0
2018-04-02 09:00:00	ES	Futures	2875.9	2879.73	2861.44	2864.44	162607.0
2018-04-02 10:00:00	ES	Futures	2864.44	2865.53	2837.7	2838.52	284349.0
2018-04-02 11:00:00	ES	Futures	2838.24	2838.79	2807.95	2816.14	385501.0
2018-04-02 12:00:00	ES	Futures	2815.87	2825.42	2804.13	2817.23	267136.0
2018-04-02 13:00:00	ES	Futures	2817.23	2820.78	2793.76	2793.76	215660.0
2018-04-02 14:00:00	ES	Futures	2793.76	2803.58	2785.85	2801.95	322567.0
2018-04-02 15:00:00	ES	Futures	2801.67	2821.87	2794.31	2816.14	472619.0
2018-04-02 16:00:00	ES	Futures	2815.87	2819.96	2809.32	2819.41	95127.0
2018-04-02 18:00:00	ES	Futures	2817.78	2820.78	2814.5	2815.59	13816.0
2018-04-02 19:00:00	ES	Futures	2815.59	2821.05	2813.95	2820.23	8771.0
2018-04-02 20:00:00	ES	Futures	2820.5	2822.96	2818.05	2822.42	13846.0
2018-04-02 21:00:00	ES	Futures	2822.42	2826.24	2820.5	2821.6	12885.0
2018-04-02 22:00:00	ES	Futures	2821.32	2822.42	2818.59	2821.6	12097.0
2018-04-02 23:00:00	ES	Futures	2821.6	2822.42	2819.96	2821.87	4361.0
2018-04-02 00:00:00	NQ	Futures	7761.27	7762.74	7751.51	7758.61	1286.0
2018-04-02 01:00:00	NQ	Futures	7758.01	7764.22	7752.4	7755.35	1408.0
2018-04-02 02:00:00	NQ	Futures	7754.47	7754.47	7734.67	7740.58	2208.0
2018-04-02 03:00:00	NQ	Futures	7739.99	7749.74	7729.05	7742.06	2834.0
2018-04-02 04:00:00	NQ	Futures	7742.06	7750.92	7737.33	7739.99	1625.0
2018-04-02 05:00:00	NQ	Futures	7739.99	7750.92	7737.92	7748.85	1274.0
2018-04-02 06:00:00	NQ	Futures	7749.44	7760.08	7745.01	7745.6	2695.0
2018-04-02 07:00:00	NQ	Futures	7745.6	7745.6	7716.05	7729.64	6140.0
2018-04-02 08:00:00	NQ	Futures	7729.64	7744.72	7720.78	7742.06	6190.0
2018-04-02 09:00:00	NQ	Futures	7741.17	7766.88	7679.7	7693.0	61116.0
2018-04-02 10:00:00	NQ	Futures	7692.7	7693.88	7617.93	7620.59	98557.0
2018-04-02 11:00:00	NQ	Futures	7620.59	7623.25	7525.73	7555.87	116788.0
2018-04-02 12:00:00	NQ	Futures	7555.87	7613.5	7533.11	7583.35	75482.0
2018-04-02 13:00:00	NQ	Futures	7583.35	7594.88	7507.4	7507.4	66177.0
2018-04-02 14:00:00	NQ	Futures	7507.4	7534.3	7478.74	7530.16	84953.0
2018-04-02 15:00:00	NQ	Futures	7530.16	7585.72	7496.76	7565.03	95196.0
2018-04-02 16:00:00	NQ	Futures	7565.33	7582.17	7554.39	7580.1	13437.0
2018-04-02 18:00:00	NQ	Futures	7572.42	7583.35	7560.3	7565.62	2892.0
2018-04-02 19:00:00	NQ	Futures	7565.03	7582.76	7558.83	7580.4	2429.0
2018-04-02 20:00:00	NQ	Futures	7580.99	7594.29	7572.12	7590.15	4069.0
2018-04-02 21:00:00	NQ	Futures	7590.15	7604.63	7579.81	7582.76	3816.0
2018-04-02 22:00:00	NQ	Futures	7582.47	7587.49	7569.76	7577.74	4994.0
2018-04-02 23:00:00	NQ	Futures	7577.74	7584.83	7573.9	7583.65	1982.0
2018-04-02 00:00:00	YM	Futures	26171.0	26177.5	26143.8	26162.3	2142.0
2018-04-02 01:00:00	YM	Futures	26162.3	26175.3	26138.4	26143.8	1524.0
2018-04-02 02:00:00	YM	Futures	26142.8	26143.8	26114.5	26125.4	1862.0
2018-04-02 03:00:00	YM	Futures	26125.4	26143.8	26108.0	26131.9	1609.0

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

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