PREVIEW / futures_1hour / 2019-03-27

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-03-27.parquet
  size:    58 KB
  rows:    1,770

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
2019-03-27 00:00:00	ES	Futures	3062.37	3066.17	3062.37	3065.35	7133.0
2019-03-27 01:00:00	ES	Futures	3065.35	3068.34	3064.81	3068.06	7640.0
2019-03-27 02:00:00	ES	Futures	3068.06	3070.78	3067.52	3069.42	7211.0
2019-03-27 03:00:00	ES	Futures	3069.42	3070.5	3067.25	3069.96	7015.0
2019-03-27 04:00:00	ES	Futures	3069.96	3070.5	3063.46	3063.73	15309.0
2019-03-27 05:00:00	ES	Futures	3063.46	3068.34	3058.58	3059.66	16075.0
2019-03-27 06:00:00	ES	Futures	3059.39	3059.66	3052.88	3053.15	24125.0
2019-03-27 07:00:00	ES	Futures	3053.42	3058.3	3051.53	3057.22	19014.0
2019-03-27 08:00:00	ES	Futures	3057.22	3063.46	3053.15	3062.1	40702.0
2019-03-27 09:00:00	ES	Futures	3062.37	3069.42	3056.14	3057.76	210211.0
2019-03-27 10:00:00	ES	Futures	3057.76	3067.25	3047.73	3051.53	254357.0
2019-03-27 11:00:00	ES	Futures	3051.53	3054.24	3027.4	3032.01	300271.0
2019-03-27 12:00:00	ES	Futures	3032.01	3042.85	3029.3	3038.79	165636.0
2019-03-27 13:00:00	ES	Futures	3038.79	3050.44	3035.53	3047.73	139086.0
2019-03-27 14:00:00	ES	Futures	3047.46	3052.34	3043.67	3046.65	129002.0
2019-03-27 15:00:00	ES	Futures	3046.92	3053.97	3043.39	3047.19	211507.0
2019-03-27 16:00:00	ES	Futures	3046.92	3049.09	3043.94	3044.21	58018.0
2019-03-27 18:00:00	ES	Futures	3043.94	3045.02	3040.41	3042.31	6413.0
2019-03-27 19:00:00	ES	Futures	3042.31	3043.94	3040.14	3043.12	5966.0
2019-03-27 20:00:00	ES	Futures	3043.39	3043.39	3031.47	3035.26	27174.0
2019-03-27 21:00:00	ES	Futures	3035.26	3035.53	3030.92	3033.63	13008.0
2019-03-27 22:00:00	ES	Futures	3033.36	3041.77	3032.82	3040.95	13864.0
2019-03-27 23:00:00	ES	Futures	3040.95	3042.58	3039.06	3042.04	6215.0
2019-03-27 00:00:00	NQ	Futures	8596.96	8608.61	8595.8	8606.28	2988.0
2019-03-27 01:00:00	NQ	Futures	8605.99	8615.02	8604.53	8614.14	3025.0
2019-03-27 02:00:00	NQ	Futures	8614.43	8621.42	8612.69	8616.47	3511.0
2019-03-27 03:00:00	NQ	Futures	8616.47	8622.59	8610.94	8620.84	4365.0
2019-03-27 04:00:00	NQ	Futures	8620.55	8622.0	8601.33	8604.53	7763.0
2019-03-27 05:00:00	NQ	Futures	8604.83	8618.8	8590.27	8593.47	7689.0
2019-03-27 06:00:00	NQ	Futures	8593.47	8593.76	8577.46	8579.2	10488.0
2019-03-27 07:00:00	NQ	Futures	8579.2	8592.89	8571.05	8589.1	8201.0
2019-03-27 08:00:00	NQ	Futures	8589.69	8605.7	8577.46	8601.04	15382.0
2019-03-27 09:00:00	NQ	Futures	8601.04	8623.75	8576.29	8581.24	79606.0
2019-03-27 10:00:00	NQ	Futures	8581.53	8613.85	8552.71	8568.72	91406.0
2019-03-27 11:00:00	NQ	Futures	8568.72	8577.17	8473.81	8488.07	103857.0
2019-03-27 12:00:00	NQ	Futures	8487.78	8526.8	8480.79	8510.49	62979.0
2019-03-27 13:00:00	NQ	Futures	8510.49	8553.29	8500.88	8541.94	51260.0
2019-03-27 14:00:00	NQ	Futures	8542.23	8557.37	8520.39	8534.95	44746.0
2019-03-27 15:00:00	NQ	Futures	8535.53	8559.7	8523.3	8542.81	55220.0
2019-03-27 16:00:00	NQ	Futures	8542.81	8547.18	8527.96	8528.54	11025.0
2019-03-27 18:00:00	NQ	Futures	8529.13	8533.2	8519.52	8525.92	2926.0
2019-03-27 19:00:00	NQ	Futures	8525.63	8530.58	8516.9	8525.34	2885.0
2019-03-27 20:00:00	NQ	Futures	8525.05	8526.8	8493.02	8504.38	10325.0
2019-03-27 21:00:00	NQ	Futures	8504.67	8506.12	8489.53	8499.14	5914.0
2019-03-27 22:00:00	NQ	Futures	8498.85	8525.63	8495.93	8522.14	6963.0
2019-03-27 23:00:00	NQ	Futures	8521.56	8528.54	8516.02	8526.5	3357.0
2019-03-27 00:00:00	YM	Futures	27917.2	27958.5	27916.1	27948.7	1590.0
2019-03-27 01:00:00	YM	Futures	27948.7	27970.4	27936.7	27969.4	1524.0
2019-03-27 02:00:00	YM	Futures	27969.4	27985.7	27960.7	27973.7	1431.0
2019-03-27 03:00:00	YM	Futures	27979.2	27988.9	27956.3	27983.5	1818.0

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

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