PREVIEW / futures_1hour / 2018-03-09

all futures 1-hour files

  file:    by_date/futures_1hour/2018/2018-03-09.parquet
  size:    46 KB
  rows:    1,353

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-03-09 00:00:00	ES	Futures	2993.49	2994.31	2991.03	2993.49	3046.0
2018-03-09 01:00:00	ES	Futures	2993.49	2995.68	2992.67	2993.76	1879.0
2018-03-09 02:00:00	ES	Futures	2993.76	2993.76	2990.48	2992.12	4045.0
2018-03-09 03:00:00	ES	Futures	2992.4	2996.5	2990.48	2995.13	8405.0
2018-03-09 04:00:00	ES	Futures	2994.86	2995.68	2992.12	2994.31	4192.0
2018-03-09 05:00:00	ES	Futures	2994.58	2997.86	2992.4	2997.86	4900.0
2018-03-09 06:00:00	ES	Futures	2997.59	2997.86	2992.67	2993.49	5321.0
2018-03-09 07:00:00	ES	Futures	2993.22	2997.04	2992.94	2995.13	5334.0
2018-03-09 08:00:00	ES	Futures	2995.13	3016.17	2984.74	3012.89	95207.0
2018-03-09 09:00:00	ES	Futures	3012.89	3016.72	3008.25	3014.53	109742.0
2018-03-09 10:00:00	ES	Futures	3014.53	3028.2	3012.62	3023.83	107682.0
2018-03-09 11:00:00	ES	Futures	3023.83	3028.47	3022.73	3027.93	50329.0
2018-03-09 12:00:00	ES	Futures	3027.93	3035.58	3027.65	3031.48	69269.0
2018-03-09 13:00:00	ES	Futures	3031.48	3038.04	3031.48	3036.95	47842.0
2018-03-09 14:00:00	ES	Futures	3036.95	3040.5	3034.76	3039.68	60729.0
2018-03-09 15:00:00	ES	Futures	3039.68	3047.06	3037.22	3046.51	168185.0
2018-03-09 16:00:00	ES	Futures	3046.24	3046.79	3041.32	3043.23	67749.0
2018-03-09 00:00:00	NQ	Futures	8274.09	8275.87	8267.86	8273.5	1117.0
2018-03-09 01:00:00	NQ	Futures	8273.79	8279.13	8271.12	8273.2	811.0
2018-03-09 02:00:00	NQ	Futures	8272.9	8273.5	8265.79	8269.94	1513.0
2018-03-09 03:00:00	NQ	Futures	8270.53	8279.43	8265.79	8275.87	2108.0
2018-03-09 04:00:00	NQ	Futures	8276.17	8277.65	8267.56	8273.2	1897.0
2018-03-09 05:00:00	NQ	Futures	8273.5	8284.77	8269.34	8284.17	1776.0
2018-03-09 06:00:00	NQ	Futures	8284.17	8284.77	8272.31	8273.5	1180.0
2018-03-09 07:00:00	NQ	Futures	8273.2	8281.21	8272.61	8278.24	1331.0
2018-03-09 08:00:00	NQ	Futures	8277.65	8346.16	8260.74	8331.93	18653.0
2018-03-09 09:00:00	NQ	Futures	8331.63	8338.45	8314.43	8331.63	25991.0
2018-03-09 10:00:00	NQ	Futures	8331.63	8371.97	8328.66	8361.88	30789.0
2018-03-09 11:00:00	NQ	Futures	8362.18	8379.68	8359.81	8377.01	15346.0
2018-03-09 12:00:00	NQ	Futures	8377.01	8396.29	8376.71	8385.61	13301.0
2018-03-09 13:00:00	NQ	Futures	8385.61	8400.14	8385.61	8397.77	8359.0
2018-03-09 14:00:00	NQ	Futures	8397.77	8408.74	8391.24	8404.89	10901.0
2018-03-09 15:00:00	NQ	Futures	8404.59	8426.24	8401.03	8425.35	19264.0
2018-03-09 16:00:00	NQ	Futures	8425.35	8427.73	8417.05	8419.42	4866.0
2018-03-09 00:00:00	YM	Futures	27059.0	27070.9	27039.4	27061.1	1453.0
2018-03-09 01:00:00	YM	Futures	27065.5	27094.8	27057.9	27065.5	1237.0
2018-03-09 02:00:00	YM	Futures	27064.4	27067.7	27032.9	27049.2	1528.0
2018-03-09 03:00:00	YM	Futures	27049.2	27079.6	27028.5	27068.8	2175.0
2018-03-09 04:00:00	YM	Futures	27068.8	27074.2	27043.8	27062.2	1187.0
2018-03-09 05:00:00	YM	Futures	27063.3	27097.0	27047.0	27097.0	1478.0
2018-03-09 06:00:00	YM	Futures	27095.9	27097.0	27050.3	27057.9	1252.0
2018-03-09 07:00:00	YM	Futures	27056.8	27085.1	27054.6	27072.0	990.0
2018-03-09 08:00:00	YM	Futures	27070.9	27274.2	26999.2	27247.0	12579.0
2018-03-09 09:00:00	YM	Futures	27245.9	27279.6	27190.5	27244.8	19343.0
2018-03-09 10:00:00	YM	Futures	27243.7	27367.6	27218.7	27335.0	15663.0
2018-03-09 11:00:00	YM	Futures	27336.1	27388.3	27324.2	27366.6	8147.0
2018-03-09 12:00:00	YM	Futures	27366.6	27447.0	27364.4	27416.6	7925.0
2018-03-09 13:00:00	YM	Futures	27417.6	27485.0	27417.6	27469.8	6578.0
2018-03-09 14:00:00	YM	Futures	27469.8	27503.5	27440.5	27469.8	6619.0
2018-03-09 15:00:00	YM	Futures	27470.9	27542.6	27449.2	27541.5	13831.0

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

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