PREVIEW / futures_1hour / 2019-01-24

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-01-24.parquet
  size:    56 KB
  rows:    1,778

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-01-24 00:00:00	ES	Futures	2864.95	2867.12	2863.59	2866.85	5427.0
2019-01-24 01:00:00	ES	Futures	2866.58	2866.85	2864.13	2864.4	2661.0
2019-01-24 02:00:00	ES	Futures	2864.4	2866.3	2861.96	2864.95	8383.0
2019-01-24 03:00:00	ES	Futures	2864.67	2868.75	2860.06	2867.39	18276.0
2019-01-24 04:00:00	ES	Futures	2867.39	2872.55	2865.49	2872.01	14368.0
2019-01-24 05:00:00	ES	Futures	2871.74	2872.55	2868.2	2869.56	14031.0
2019-01-24 06:00:00	ES	Futures	2869.56	2873.91	2867.93	2869.02	16717.0
2019-01-24 07:00:00	ES	Futures	2869.02	2873.36	2868.75	2869.56	12808.0
2019-01-24 08:00:00	ES	Futures	2869.56	2873.36	2860.6	2862.5	76290.0
2019-01-24 09:00:00	ES	Futures	2862.5	2869.02	2857.07	2862.23	182428.0
2019-01-24 10:00:00	ES	Futures	2861.96	2876.08	2859.24	2867.66	188313.0
2019-01-24 11:00:00	ES	Futures	2867.39	2873.64	2859.51	2871.74	164148.0
2019-01-24 12:00:00	ES	Futures	2871.74	2872.01	2858.7	2861.14	80316.0
2019-01-24 13:00:00	ES	Futures	2861.14	2862.23	2852.72	2860.06	113752.0
2019-01-24 14:00:00	ES	Futures	2860.06	2866.03	2856.8	2864.4	99158.0
2019-01-24 15:00:00	ES	Futures	2864.13	2870.92	2863.04	2869.56	128755.0
2019-01-24 16:00:00	ES	Futures	2869.56	2869.83	2860.87	2864.67	61624.0
2019-01-24 18:00:00	ES	Futures	2863.86	2866.03	2861.96	2866.03	5645.0
2019-01-24 19:00:00	ES	Futures	2866.03	2869.29	2864.95	2867.39	9332.0
2019-01-24 20:00:00	ES	Futures	2867.39	2870.38	2863.59	2867.12	11552.0
2019-01-24 21:00:00	ES	Futures	2866.85	2872.82	2866.85	2870.92	9635.0
2019-01-24 22:00:00	ES	Futures	2870.92	2880.7	2870.38	2878.8	16400.0
2019-01-24 23:00:00	ES	Futures	2879.07	2880.15	2876.62	2877.98	5952.0
2019-01-24 00:00:00	NQ	Futures	7798.53	7808.76	7793.57	7807.59	2992.0
2019-01-24 01:00:00	NQ	Futures	7807.3	7807.88	7798.24	7799.7	1694.0
2019-01-24 02:00:00	NQ	Futures	7799.99	7805.55	7789.48	7799.7	3825.0
2019-01-24 03:00:00	NQ	Futures	7799.99	7814.6	7784.8	7810.81	7413.0
2019-01-24 04:00:00	NQ	Futures	7810.51	7829.8	7804.67	7828.04	6762.0
2019-01-24 05:00:00	NQ	Futures	7828.34	7830.38	7817.82	7821.03	5175.0
2019-01-24 06:00:00	NQ	Futures	7821.62	7838.27	7818.99	7822.49	6532.0
2019-01-24 07:00:00	NQ	Futures	7822.49	7835.06	7822.49	7824.54	4567.0
2019-01-24 08:00:00	NQ	Futures	7824.25	7836.23	7796.49	7802.62	23179.0
2019-01-24 09:00:00	NQ	Futures	7802.62	7842.65	7798.83	7816.06	69248.0
2019-01-24 10:00:00	NQ	Futures	7815.77	7852.3	7799.7	7809.93	80557.0
2019-01-24 11:00:00	NQ	Futures	7810.22	7842.36	7785.68	7838.56	56492.0
2019-01-24 12:00:00	NQ	Futures	7839.15	7839.73	7802.33	7810.51	28387.0
2019-01-24 13:00:00	NQ	Futures	7810.22	7814.31	7786.85	7811.39	38182.0
2019-01-24 14:00:00	NQ	Futures	7811.39	7828.92	7802.33	7823.66	33639.0
2019-01-24 15:00:00	NQ	Futures	7823.66	7847.33	7819.86	7840.02	29821.0
2019-01-24 16:00:00	NQ	Futures	7840.61	7841.78	7799.12	7813.14	17404.0
2019-01-24 18:00:00	NQ	Futures	7812.56	7816.36	7803.5	7815.19	2434.0
2019-01-24 19:00:00	NQ	Futures	7815.48	7828.04	7811.68	7822.79	4453.0
2019-01-24 20:00:00	NQ	Futures	7822.49	7833.89	7809.93	7824.54	5927.0
2019-01-24 21:00:00	NQ	Futures	7824.54	7843.53	7824.54	7837.39	4687.0
2019-01-24 22:00:00	NQ	Futures	7837.69	7888.82	7835.35	7869.24	9453.0
2019-01-24 23:00:00	NQ	Futures	7869.54	7872.75	7863.69	7867.49	2746.0
2019-01-24 00:00:00	YM	Futures	26640.0	26665.0	26622.6	26659.5	2078.0
2019-01-24 01:00:00	YM	Futures	26656.3	26656.3	26630.2	26637.8	1135.0
2019-01-24 02:00:00	YM	Futures	26638.9	26645.4	26610.7	26633.5	3188.0
2019-01-24 03:00:00	YM	Futures	26633.5	26668.2	26590.0	26657.4	6327.0

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

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