PREVIEW / futures_1hour / 2017-12-15

all futures 1-hour files

  file:    by_date/futures_1hour/2017/2017-12-15.parquet
  size:    45 KB
  rows:    1,337

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
2017-12-15 00:00:00	ES	Futures	2907.12	2908.21	2906.84	2907.12	4712.0
2017-12-15 01:00:00	ES	Futures	2906.84	2908.21	2906.3	2908.21	3223.0
2017-12-15 02:00:00	ES	Futures	2908.21	2909.03	2907.39	2907.94	9817.0
2017-12-15 03:00:00	ES	Futures	2907.94	2908.76	2906.84	2908.48	15928.0
2017-12-15 04:00:00	ES	Futures	2908.21	2909.3	2906.84	2907.39	11056.0
2017-12-15 05:00:00	ES	Futures	2907.39	2908.76	2906.57	2907.94	11810.0
2017-12-15 06:00:00	ES	Futures	2907.94	2909.3	2907.12	2909.3	13367.0
2017-12-15 07:00:00	ES	Futures	2909.03	2912.04	2908.48	2911.22	20358.0
2017-12-15 08:00:00	ES	Futures	2910.94	2913.95	2910.67	2912.31	27756.0
2017-12-15 09:00:00	ES	Futures	2912.04	2918.05	2909.85	2915.59	218679.0
2017-12-15 10:00:00	ES	Futures	2915.86	2925.16	2915.59	2920.24	189814.0
2017-12-15 11:00:00	ES	Futures	2920.51	2928.16	2920.24	2926.8	143831.0
2017-12-15 12:00:00	ES	Futures	2926.8	2928.98	2925.7	2928.16	72689.0
2017-12-15 13:00:00	ES	Futures	2928.16	2930.35	2926.8	2930.08	56963.0
2017-12-15 14:00:00	ES	Futures	2930.08	2932.54	2929.53	2930.62	98133.0
2017-12-15 15:00:00	ES	Futures	2930.62	2933.08	2923.79	2927.34	280261.0
2017-12-15 16:00:00	ES	Futures	2927.07	2933.63	2926.52	2933.36	130437.0
2017-12-15 00:00:00	NQ	Futures	7612.98	7616.54	7610.61	7611.5	1055.0
2017-12-15 01:00:00	NQ	Futures	7611.2	7615.06	7608.83	7614.76	721.0
2017-12-15 02:00:00	NQ	Futures	7615.06	7622.18	7615.06	7617.13	2562.0
2017-12-15 03:00:00	NQ	Futures	7617.43	7621.58	7615.06	7619.51	1967.0
2017-12-15 04:00:00	NQ	Futures	7619.51	7622.47	7615.65	7617.13	1711.0
2017-12-15 05:00:00	NQ	Futures	7616.84	7622.47	7615.65	7621.29	1561.0
2017-12-15 06:00:00	NQ	Futures	7620.99	7624.25	7617.13	7620.69	2200.0
2017-12-15 07:00:00	NQ	Futures	7620.69	7627.22	7617.73	7626.03	2939.0
2017-12-15 08:00:00	NQ	Futures	7626.03	7628.7	7621.88	7623.66	4499.0
2017-12-15 09:00:00	NQ	Futures	7623.36	7637.3	7617.13	7626.33	46211.0
2017-12-15 10:00:00	NQ	Futures	7626.03	7650.35	7624.25	7645.01	42064.0
2017-12-15 11:00:00	NQ	Futures	7644.72	7671.71	7644.72	7671.41	34926.0
2017-12-15 12:00:00	NQ	Futures	7671.11	7684.76	7670.52	7681.2	25305.0
2017-12-15 13:00:00	NQ	Futures	7681.49	7689.8	7677.05	7687.43	16528.0
2017-12-15 14:00:00	NQ	Futures	7687.43	7693.06	7685.35	7688.32	20623.0
2017-12-15 15:00:00	NQ	Futures	7688.32	7700.48	7680.31	7689.8	48696.0
2017-12-15 16:00:00	NQ	Futures	7689.5	7714.71	7686.54	7711.45	19461.0
2017-12-15 00:00:00	YM	Futures	26737.3	26744.9	26724.2	26725.3	1214.0
2017-12-15 01:00:00	YM	Futures	26724.2	26737.3	26716.6	26737.3	887.0
2017-12-15 02:00:00	YM	Futures	26736.2	26749.2	26726.4	26728.6	2113.0
2017-12-15 03:00:00	YM	Futures	26729.6	26739.4	26720.9	26736.2	1633.0
2017-12-15 04:00:00	YM	Futures	26737.3	26749.2	26726.4	26728.6	1021.0
2017-12-15 05:00:00	YM	Futures	26730.7	26743.8	26726.4	26734.0	974.0
2017-12-15 06:00:00	YM	Futures	26735.1	26762.3	26734.0	26761.2	1526.0
2017-12-15 07:00:00	YM	Futures	26761.2	26780.7	26754.6	26776.4	2284.0
2017-12-15 08:00:00	YM	Futures	26776.4	26794.9	26768.8	26780.7	3953.0
2017-12-15 09:00:00	YM	Futures	26780.7	26822.0	26761.2	26765.5	19637.0
2017-12-15 10:00:00	YM	Futures	26765.5	26829.6	26765.5	26784.0	18346.0
2017-12-15 11:00:00	YM	Futures	26784.0	26840.5	26776.4	26823.1	13214.0
2017-12-15 12:00:00	YM	Futures	26822.0	26834.0	26811.2	26820.9	5664.0
2017-12-15 13:00:00	YM	Futures	26820.9	26829.6	26806.8	26828.6	4811.0
2017-12-15 14:00:00	YM	Futures	26828.6	26840.5	26818.8	26829.6	7338.0
2017-12-15 15:00:00	YM	Futures	26828.6	26854.6	26775.3	26803.6	17520.0

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

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