PREVIEW / futures_1hour / 2019-01-28

all futures 1-hour files

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

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-28 00:00:00	ES	Futures	2888.57	2888.85	2881.78	2882.87	7771.0
2019-01-28 01:00:00	ES	Futures	2882.6	2883.68	2880.15	2880.97	5655.0
2019-01-28 02:00:00	ES	Futures	2880.7	2883.41	2880.7	2883.14	5567.0
2019-01-28 03:00:00	ES	Futures	2882.87	2883.68	2876.35	2878.25	19326.0
2019-01-28 04:00:00	ES	Futures	2877.98	2881.51	2877.44	2880.7	10635.0
2019-01-28 05:00:00	ES	Futures	2880.7	2882.06	2878.25	2879.34	9959.0
2019-01-28 06:00:00	ES	Futures	2879.34	2882.06	2878.25	2880.15	9578.0
2019-01-28 07:00:00	ES	Futures	2879.88	2883.41	2877.17	2878.52	23110.0
2019-01-28 08:00:00	ES	Futures	2878.8	2880.15	2874.45	2876.62	24622.0
2019-01-28 09:00:00	ES	Futures	2876.62	2876.9	2854.63	2858.97	257354.0
2019-01-28 10:00:00	ES	Futures	2858.7	2867.66	2853.27	2858.43	218732.0
2019-01-28 11:00:00	ES	Futures	2858.43	2864.13	2850.55	2851.09	183073.0
2019-01-28 12:00:00	ES	Futures	2851.09	2860.33	2848.65	2855.71	114306.0
2019-01-28 13:00:00	ES	Futures	2855.71	2867.39	2854.08	2864.67	109727.0
2019-01-28 14:00:00	ES	Futures	2864.67	2870.11	2859.79	2867.66	99394.0
2019-01-28 15:00:00	ES	Futures	2867.39	2871.46	2863.04	2870.92	166571.0
2019-01-28 16:00:00	ES	Futures	2870.65	2871.46	2867.93	2868.75	52456.0
2019-01-28 18:00:00	ES	Futures	2868.2	2869.02	2863.04	2863.04	7309.0
2019-01-28 19:00:00	ES	Futures	2863.04	2863.86	2856.53	2856.53	14103.0
2019-01-28 20:00:00	ES	Futures	2856.53	2860.87	2855.44	2859.24	14669.0
2019-01-28 21:00:00	ES	Futures	2859.24	2860.06	2856.8	2858.16	6711.0
2019-01-28 22:00:00	ES	Futures	2858.16	2861.41	2858.16	2860.06	6573.0
2019-01-28 23:00:00	ES	Futures	2860.06	2862.23	2859.24	2861.69	5498.0
2019-01-28 00:00:00	NQ	Futures	7918.92	7919.21	7896.12	7899.63	3670.0
2019-01-28 01:00:00	NQ	Futures	7899.34	7904.31	7894.96	7898.17	3124.0
2019-01-28 02:00:00	NQ	Futures	7897.88	7906.94	7896.71	7903.43	3342.0
2019-01-28 03:00:00	NQ	Futures	7903.43	7905.18	7881.22	7886.77	7811.0
2019-01-28 04:00:00	NQ	Futures	7886.48	7897.88	7884.44	7895.54	4252.0
2019-01-28 05:00:00	NQ	Futures	7895.54	7900.51	7889.7	7893.2	3435.0
2019-01-28 06:00:00	NQ	Futures	7892.91	7900.8	7887.65	7891.16	3871.0
2019-01-28 07:00:00	NQ	Futures	7891.16	7905.18	7887.94	7890.87	7568.0
2019-01-28 08:00:00	NQ	Futures	7890.57	7894.66	7879.76	7891.16	7695.0
2019-01-28 09:00:00	NQ	Futures	7891.45	7893.2	7774.57	7799.12	101556.0
2019-01-28 10:00:00	NQ	Futures	7798.83	7826.0	7781.29	7798.53	88392.0
2019-01-28 11:00:00	NQ	Futures	7798.83	7819.28	7775.74	7778.08	58829.0
2019-01-28 12:00:00	NQ	Futures	7778.08	7806.42	7770.19	7789.77	44137.0
2019-01-28 13:00:00	NQ	Futures	7789.77	7826.88	7784.51	7816.65	35220.0
2019-01-28 14:00:00	NQ	Futures	7816.65	7834.76	7802.62	7825.41	34312.0
2019-01-28 15:00:00	NQ	Futures	7825.41	7836.52	7814.31	7835.64	44006.0
2019-01-28 16:00:00	NQ	Futures	7835.64	7839.44	7825.12	7829.21	8714.0
2019-01-28 18:00:00	NQ	Futures	7825.12	7827.75	7807.88	7808.18	2923.0
2019-01-28 19:00:00	NQ	Futures	7808.18	7810.51	7789.77	7790.06	6176.0
2019-01-28 20:00:00	NQ	Futures	7790.35	7803.21	7785.09	7795.9	6416.0
2019-01-28 21:00:00	NQ	Futures	7795.61	7798.83	7785.38	7789.77	3246.0
2019-01-28 22:00:00	NQ	Futures	7790.06	7800.58	7790.06	7794.73	2831.0
2019-01-28 23:00:00	NQ	Futures	7795.03	7801.75	7792.69	7801.75	2610.0
2019-01-28 00:00:00	YM	Futures	26784.4	26785.5	26717.1	26727.9	2693.0
2019-01-28 01:00:00	YM	Futures	26726.8	26735.5	26704.0	26710.6	2089.0
2019-01-28 02:00:00	YM	Futures	26710.6	26738.8	26709.5	26732.3	1980.0
2019-01-28 03:00:00	YM	Futures	26733.4	26736.6	26662.8	26680.2	5881.0

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

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