PREVIEW / futures_1hour / 2019-03-20

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-03-20.parquet
  size:    57 KB
  rows:    1,738

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-03-20 00:00:00	ES	Futures	3073.49	3074.03	3071.86	3072.13	2016.0
2019-03-20 01:00:00	ES	Futures	3072.4	3076.2	3072.4	3076.2	6236.0
2019-03-20 02:00:00	ES	Futures	3076.2	3077.55	3075.38	3076.2	5074.0
2019-03-20 03:00:00	ES	Futures	3076.47	3079.18	3075.93	3078.37	6781.0
2019-03-20 04:00:00	ES	Futures	3078.37	3082.43	3077.82	3081.62	15517.0
2019-03-20 05:00:00	ES	Futures	3081.62	3081.89	3077.28	3077.82	12144.0
2019-03-20 06:00:00	ES	Futures	3077.82	3078.64	3073.76	3074.3	15565.0
2019-03-20 07:00:00	ES	Futures	3074.57	3077.01	3072.94	3077.01	15590.0
2019-03-20 08:00:00	ES	Futures	3077.01	3078.91	3072.4	3072.4	26173.0
2019-03-20 09:00:00	ES	Futures	3072.4	3076.47	3065.08	3066.17	182356.0
2019-03-20 10:00:00	ES	Futures	3066.17	3071.59	3063.73	3069.96	168409.0
2019-03-20 11:00:00	ES	Futures	3069.69	3072.13	3059.12	3060.2	136247.0
2019-03-20 12:00:00	ES	Futures	3059.93	3065.08	3055.05	3061.56	177634.0
2019-03-20 13:00:00	ES	Futures	3061.56	3065.35	3060.47	3065.08	69513.0
2019-03-20 14:00:00	ES	Futures	3065.08	3089.75	3064.81	3085.96	372522.0
2019-03-20 15:00:00	ES	Futures	3086.23	3088.4	3066.98	3068.34	307657.0
2019-03-20 16:00:00	ES	Futures	3068.34	3068.88	3061.29	3061.56	72363.0
2019-03-20 18:00:00	ES	Futures	3062.1	3065.62	3061.02	3064.54	6472.0
2019-03-20 19:00:00	ES	Futures	3064.54	3068.61	3064.54	3067.79	6471.0
2019-03-20 20:00:00	ES	Futures	3067.52	3074.57	3067.25	3074.3	13357.0
2019-03-20 21:00:00	ES	Futures	3074.3	3075.38	3071.05	3071.59	10339.0
2019-03-20 22:00:00	ES	Futures	3071.59	3072.94	3069.15	3069.42	6375.0
2019-03-20 23:00:00	ES	Futures	3069.42	3069.96	3066.71	3067.79	6946.0
2019-03-20 00:00:00	NQ	Futures	8582.12	8583.28	8576.0	8577.75	1086.0
2019-03-20 01:00:00	NQ	Futures	8578.33	8588.81	8578.33	8587.36	2518.0
2019-03-20 02:00:00	NQ	Futures	8587.36	8592.31	8585.61	8588.52	1894.0
2019-03-20 03:00:00	NQ	Futures	8588.23	8598.13	8587.65	8595.51	2501.0
2019-03-20 04:00:00	NQ	Futures	8595.51	8609.19	8594.34	8608.32	5271.0
2019-03-20 05:00:00	NQ	Futures	8607.74	8608.03	8594.93	8597.55	4078.0
2019-03-20 06:00:00	NQ	Futures	8597.84	8600.17	8587.07	8589.98	4160.0
2019-03-20 07:00:00	NQ	Futures	8589.98	8597.55	8582.41	8597.26	5867.0
2019-03-20 08:00:00	NQ	Futures	8597.26	8603.08	8585.03	8585.32	8441.0
2019-03-20 09:00:00	NQ	Futures	8585.32	8600.17	8570.76	8578.91	65129.0
2019-03-20 10:00:00	NQ	Futures	8578.91	8606.28	8577.46	8602.5	69511.0
2019-03-20 11:00:00	NQ	Futures	8602.79	8608.32	8567.56	8571.05	48519.0
2019-03-20 12:00:00	NQ	Futures	8570.76	8592.02	8559.41	8582.7	61095.0
2019-03-20 13:00:00	NQ	Futures	8582.12	8592.02	8575.42	8591.43	25764.0
2019-03-20 14:00:00	NQ	Futures	8591.72	8685.77	8590.56	8669.17	118338.0
2019-03-20 15:00:00	NQ	Futures	8669.17	8677.32	8621.13	8633.65	77766.0
2019-03-20 16:00:00	NQ	Futures	8633.94	8635.98	8615.89	8618.22	14440.0
2019-03-20 18:00:00	NQ	Futures	8618.8	8632.19	8618.8	8629.57	3190.0
2019-03-20 19:00:00	NQ	Futures	8629.87	8642.09	8629.87	8639.18	2522.0
2019-03-20 20:00:00	NQ	Futures	8639.18	8663.93	8639.18	8662.18	5603.0
2019-03-20 21:00:00	NQ	Futures	8662.18	8664.8	8653.45	8656.94	4447.0
2019-03-20 22:00:00	NQ	Futures	8656.94	8661.89	8651.99	8652.87	2787.0
2019-03-20 23:00:00	NQ	Futures	8652.28	8654.32	8644.13	8647.92	2756.0
2019-03-20 00:00:00	YM	Futures	28153.2	28164.1	28136.9	28141.2	713.0
2019-03-20 01:00:00	YM	Futures	28143.4	28182.5	28141.2	28182.5	1523.0
2019-03-20 02:00:00	YM	Futures	28182.5	28201.0	28176.0	28184.7	1559.0
2019-03-20 03:00:00	YM	Futures	28182.5	28207.6	28180.4	28197.8	1895.0

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

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