PREVIEW / futures_1hour / 2018-11-23

all futures 1-hour files

  file:    by_date/futures_1hour/2018/2018-11-23.parquet
  size:    40 KB
  rows:    1,130

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-11-23 00:00:00	ES	Futures	2872.3	2872.85	2865.23	2867.13	4701.0
2018-11-23 01:00:00	ES	Futures	2867.13	2871.21	2866.59	2869.85	2554.0
2018-11-23 02:00:00	ES	Futures	2869.85	2873.93	2866.32	2872.03	9498.0
2018-11-23 03:00:00	ES	Futures	2872.03	2879.1	2870.13	2875.84	19563.0
2018-11-23 04:00:00	ES	Futures	2875.84	2878.83	2874.21	2878.29	8170.0
2018-11-23 05:00:00	ES	Futures	2878.29	2878.83	2867.13	2868.77	13712.0
2018-11-23 06:00:00	ES	Futures	2869.04	2873.12	2867.41	2867.95	10921.0
2018-11-23 07:00:00	ES	Futures	2868.22	2872.57	2866.59	2871.49	11353.0
2018-11-23 08:00:00	ES	Futures	2871.49	2872.3	2857.07	2861.15	36529.0
2018-11-23 09:00:00	ES	Futures	2861.15	2875.57	2858.16	2872.57	141081.0
2018-11-23 10:00:00	ES	Futures	2872.57	2876.11	2865.23	2873.39	129685.0
2018-11-23 11:00:00	ES	Futures	2873.39	2880.46	2867.95	2868.49	99100.0
2018-11-23 12:00:00	ES	Futures	2868.49	2874.75	2863.05	2864.41	103329.0
2018-11-23 13:00:00	ES	Futures	2864.41	2865.23	2859.79	2859.79	39306.0
2018-11-23 00:00:00	NQ	Futures	7676.62	7677.2	7647.58	7653.45	3025.0
2018-11-23 01:00:00	NQ	Futures	7653.45	7667.53	7651.69	7664.59	2288.0
2018-11-23 02:00:00	NQ	Futures	7665.18	7678.96	7653.15	7676.03	4896.0
2018-11-23 03:00:00	NQ	Futures	7675.74	7702.43	7664.3	7687.76	10487.0
2018-11-23 04:00:00	NQ	Futures	7687.76	7698.32	7681.6	7698.03	4079.0
2018-11-23 05:00:00	NQ	Futures	7697.74	7700.08	7662.54	7671.34	7046.0
2018-11-23 06:00:00	NQ	Futures	7671.63	7689.82	7667.53	7672.8	5874.0
2018-11-23 07:00:00	NQ	Futures	7673.1	7690.4	7669.87	7685.12	5922.0
2018-11-23 08:00:00	NQ	Futures	7685.42	7689.52	7620.3	7651.39	20338.0
2018-11-23 09:00:00	NQ	Futures	7651.69	7745.25	7647.58	7728.83	67727.0
2018-11-23 10:00:00	NQ	Futures	7728.24	7736.45	7690.99	7710.35	48232.0
2018-11-23 11:00:00	NQ	Futures	7710.35	7727.07	7676.91	7679.84	33535.0
2018-11-23 12:00:00	NQ	Futures	7679.84	7700.96	7664.3	7666.94	34800.0
2018-11-23 13:00:00	NQ	Futures	7667.23	7667.53	7651.98	7661.95	7337.0
2018-11-23 00:00:00	YM	Futures	26484.8	26490.3	26425.1	26439.2	1828.0
2018-11-23 01:00:00	YM	Futures	26441.4	26475.0	26434.8	26465.3	1072.0
2018-11-23 02:00:00	YM	Futures	26466.4	26497.9	26434.8	26484.8	3459.0
2018-11-23 03:00:00	YM	Futures	26484.8	26534.8	26463.1	26506.6	5275.0
2018-11-23 04:00:00	YM	Futures	26509.8	26522.9	26491.3	26519.6	2355.0
2018-11-23 05:00:00	YM	Futures	26522.9	26525.0	26420.7	26434.8	3910.0
2018-11-23 06:00:00	YM	Futures	26437.0	26472.9	26415.3	26420.7	3951.0
2018-11-23 07:00:00	YM	Futures	26421.8	26499.0	26415.3	26492.4	3536.0
2018-11-23 08:00:00	YM	Futures	26493.5	26496.8	26359.9	26400.1	8811.0
2018-11-23 09:00:00	YM	Futures	26397.9	26481.6	26364.2	26459.8	21595.0
2018-11-23 10:00:00	YM	Futures	26458.7	26482.7	26379.4	26442.5	18252.0
2018-11-23 11:00:00	YM	Futures	26442.5	26507.6	26417.5	26424.0	12897.0
2018-11-23 12:00:00	YM	Futures	26424.0	26471.8	26365.3	26377.3	12262.0
2018-11-23 13:00:00	YM	Futures	26377.3	26379.4	26343.6	26358.8	2712.0
2018-11-23 00:00:00	CL	Futures	48.96	48.99	48.72	48.77	6924.0
2018-11-23 01:00:00	CL	Futures	48.77	48.87	48.66	48.74	6133.0
2018-11-23 02:00:00	CL	Futures	48.74	49.11	48.73	48.93	13461.0
2018-11-23 03:00:00	CL	Futures	48.94	49.07	48.68	48.79	24098.0
2018-11-23 04:00:00	CL	Futures	48.79	49.03	48.67	48.85	19271.0
2018-11-23 05:00:00	CL	Futures	48.85	48.86	47.42	47.75	56856.0
2018-11-23 06:00:00	CL	Futures	47.75	48.02	47.73	47.86	24530.0
2018-11-23 07:00:00	CL	Futures	47.87	47.98	47.63	47.81	19889.0

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

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