PREVIEW / futures_1hour / 2019-01-22

all futures 1-hour files

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

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-22 00:00:00	ES	Futures	2882.33	2882.6	2879.88	2880.97	5810.0
2019-01-22 01:00:00	ES	Futures	2880.97	2880.97	2878.52	2880.15	4095.0
2019-01-22 02:00:00	ES	Futures	2879.88	2883.14	2878.25	2881.24	9745.0
2019-01-22 03:00:00	ES	Futures	2881.24	2885.59	2879.88	2884.23	13366.0
2019-01-22 04:00:00	ES	Futures	2884.23	2887.76	2884.23	2884.77	10459.0
2019-01-22 05:00:00	ES	Futures	2885.04	2886.13	2881.24	2881.24	7307.0
2019-01-22 06:00:00	ES	Futures	2881.51	2881.51	2877.71	2881.24	12285.0
2019-01-22 07:00:00	ES	Futures	2881.51	2886.4	2881.24	2883.68	22050.0
2019-01-22 08:00:00	ES	Futures	2883.68	2885.86	2880.7	2882.6	23288.0
2019-01-22 09:00:00	ES	Futures	2882.6	2885.86	2874.99	2878.8	196743.0
2019-01-22 10:00:00	ES	Futures	2878.8	2879.07	2869.29	2872.01	222892.0
2019-01-22 11:00:00	ES	Futures	2872.01	2876.62	2861.96	2862.5	169863.0
2019-01-22 12:00:00	ES	Futures	2862.5	2866.85	2860.06	2862.77	123206.0
2019-01-22 13:00:00	ES	Futures	2862.77	2862.77	2849.74	2858.16	191517.0
2019-01-22 14:00:00	ES	Futures	2858.16	2858.7	2844.03	2849.19	159898.0
2019-01-22 15:00:00	ES	Futures	2849.19	2863.59	2842.4	2863.59	347352.0
2019-01-22 16:00:00	ES	Futures	2863.59	2866.3	2857.88	2859.79	116284.0
2019-01-22 18:00:00	ES	Futures	2857.88	2860.06	2854.35	2857.88	11631.0
2019-01-22 19:00:00	ES	Futures	2857.88	2862.23	2856.8	2859.51	9582.0
2019-01-22 20:00:00	ES	Futures	2859.79	2870.11	2857.88	2869.02	14076.0
2019-01-22 21:00:00	ES	Futures	2869.02	2869.29	2865.49	2866.58	8239.0
2019-01-22 22:00:00	ES	Futures	2866.3	2868.2	2865.22	2865.76	6473.0
2019-01-22 23:00:00	ES	Futures	2865.76	2866.03	2862.77	2865.22	5941.0
2019-01-22 00:00:00	NQ	Futures	7870.41	7870.7	7857.26	7864.28	4198.0
2019-01-22 01:00:00	NQ	Futures	7864.28	7864.86	7855.51	7860.19	2634.0
2019-01-22 02:00:00	NQ	Futures	7860.48	7871.29	7857.26	7866.32	5291.0
2019-01-22 03:00:00	NQ	Futures	7866.32	7881.81	7862.81	7877.13	5989.0
2019-01-22 04:00:00	NQ	Futures	7877.13	7888.24	7877.13	7878.59	5293.0
2019-01-22 05:00:00	NQ	Futures	7878.3	7881.81	7865.74	7866.32	3846.0
2019-01-22 06:00:00	NQ	Futures	7866.61	7870.12	7855.8	7869.54	5741.0
2019-01-22 07:00:00	NQ	Futures	7869.54	7881.81	7869.54	7876.26	7254.0
2019-01-22 08:00:00	NQ	Futures	7876.55	7887.36	7874.21	7878.59	11824.0
2019-01-22 09:00:00	NQ	Futures	7878.3	7887.65	7848.21	7866.61	69941.0
2019-01-22 10:00:00	NQ	Futures	7866.91	7866.91	7838.86	7846.74	76318.0
2019-01-22 11:00:00	NQ	Futures	7846.45	7857.26	7809.05	7811.1	59417.0
2019-01-22 12:00:00	NQ	Futures	7810.81	7826.88	7800.58	7809.93	57427.0
2019-01-22 13:00:00	NQ	Futures	7809.93	7809.93	7766.39	7788.31	61727.0
2019-01-22 14:00:00	NQ	Futures	7788.01	7791.23	7735.42	7748.28	61943.0
2019-01-22 15:00:00	NQ	Futures	7747.69	7790.64	7727.24	7790.64	85255.0
2019-01-22 16:00:00	NQ	Futures	7790.64	7800.29	7769.61	7776.91	19152.0
2019-01-22 18:00:00	NQ	Futures	7774.57	7780.71	7760.55	7776.62	3714.0
2019-01-22 19:00:00	NQ	Futures	7776.33	7790.35	7774.87	7782.76	5166.0
2019-01-22 20:00:00	NQ	Futures	7783.05	7812.85	7777.2	7809.64	7226.0
2019-01-22 21:00:00	NQ	Futures	7809.34	7810.81	7798.83	7800.58	3824.0
2019-01-22 22:00:00	NQ	Futures	7800.29	7807.3	7795.61	7798.24	3568.0
2019-01-22 23:00:00	NQ	Futures	7797.66	7801.75	7792.69	7800.58	3829.0
2019-01-22 00:00:00	YM	Futures	26616.1	26617.2	26590.0	26609.6	1995.0
2019-01-22 01:00:00	YM	Futures	26610.7	26610.7	26582.4	26603.1	1309.0
2019-01-22 02:00:00	YM	Futures	26604.2	26634.6	26582.4	26612.8	3374.0
2019-01-22 03:00:00	YM	Futures	26613.9	26654.1	26604.2	26641.1	4092.0

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

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