PREVIEW / futures_1hour / 2018-08-13

all futures 1-hour files

  file:    by_date/futures_1hour/2018/2018-08-13.parquet
  size:    56 KB
  rows:    1,716

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
2018-08-13 00:00:00	ES	Futures	3077.23	3077.78	3073.96	3075.33	7836.0
2018-08-13 01:00:00	ES	Futures	3075.6	3081.05	3075.05	3078.87	12141.0
2018-08-13 02:00:00	ES	Futures	3078.87	3086.23	3078.87	3080.5	21001.0
2018-08-13 03:00:00	ES	Futures	3080.5	3082.41	3076.14	3077.51	25018.0
2018-08-13 04:00:00	ES	Futures	3077.23	3084.59	3076.96	3084.32	18241.0
2018-08-13 05:00:00	ES	Futures	3084.32	3085.68	3080.78	3081.32	17877.0
2018-08-13 06:00:00	ES	Futures	3081.05	3085.14	3079.96	3082.41	13839.0
2018-08-13 07:00:00	ES	Futures	3082.14	3090.86	3082.14	3089.5	27764.0
2018-08-13 08:00:00	ES	Futures	3089.77	3093.04	3086.5	3090.04	38715.0
2018-08-13 09:00:00	ES	Futures	3090.04	3096.85	3089.22	3096.31	111748.0
2018-08-13 10:00:00	ES	Futures	3096.58	3099.3	3094.67	3095.22	115162.0
2018-08-13 11:00:00	ES	Futures	3095.49	3096.85	3080.23	3080.23	154825.0
2018-08-13 12:00:00	ES	Futures	3080.23	3083.77	3076.42	3077.78	130365.0
2018-08-13 13:00:00	ES	Futures	3077.51	3084.32	3073.42	3080.5	125508.0
2018-08-13 14:00:00	ES	Futures	3080.78	3088.13	3079.96	3081.05	114378.0
2018-08-13 15:00:00	ES	Futures	3081.05	3084.59	3075.05	3076.42	188354.0
2018-08-13 16:00:00	ES	Futures	3076.69	3081.05	3076.42	3080.23	68253.0
2018-08-13 18:00:00	ES	Futures	3080.78	3083.23	3079.69	3082.41	4776.0
2018-08-13 19:00:00	ES	Futures	3082.68	3082.96	3080.78	3081.05	2697.0
2018-08-13 20:00:00	ES	Futures	3081.05	3085.14	3081.05	3084.86	10151.0
2018-08-13 21:00:00	ES	Futures	3085.14	3085.95	3082.14	3082.96	8680.0
2018-08-13 22:00:00	ES	Futures	3082.68	3084.86	3080.5	3083.77	8733.0
2018-08-13 23:00:00	ES	Futures	3083.77	3086.23	3081.87	3085.68	7074.0
2018-08-13 00:00:00	NQ	Futures	8701.53	8703.88	8689.16	8696.52	2795.0
2018-08-13 01:00:00	NQ	Futures	8696.82	8712.72	8693.87	8707.12	3545.0
2018-08-13 02:00:00	NQ	Futures	8707.12	8727.73	8706.53	8709.48	5390.0
2018-08-13 03:00:00	NQ	Futures	8709.48	8717.43	8695.64	8699.17	4844.0
2018-08-13 04:00:00	NQ	Futures	8698.58	8721.55	8697.7	8720.67	3921.0
2018-08-13 05:00:00	NQ	Futures	8720.67	8724.49	8711.24	8712.72	3127.0
2018-08-13 06:00:00	NQ	Futures	8712.42	8724.49	8707.12	8716.84	3526.0
2018-08-13 07:00:00	NQ	Futures	8716.84	8755.7	8716.84	8752.46	7790.0
2018-08-13 08:00:00	NQ	Futures	8752.76	8766.3	8742.45	8751.87	10673.0
2018-08-13 09:00:00	NQ	Futures	8752.17	8786.32	8746.87	8783.97	47400.0
2018-08-13 10:00:00	NQ	Futures	8783.97	8807.81	8779.25	8792.8	49114.0
2018-08-13 11:00:00	NQ	Futures	8793.09	8796.63	8738.04	8740.1	58638.0
2018-08-13 12:00:00	NQ	Futures	8740.1	8758.65	8728.03	8738.92	41408.0
2018-08-13 13:00:00	NQ	Futures	8739.21	8756.0	8722.14	8745.99	37995.0
2018-08-13 14:00:00	NQ	Futures	8746.28	8768.07	8738.63	8741.27	31557.0
2018-08-13 15:00:00	NQ	Futures	8741.27	8752.76	8722.14	8727.44	40639.0
2018-08-13 16:00:00	NQ	Futures	8727.44	8740.1	8726.26	8736.56	8670.0
2018-08-13 18:00:00	NQ	Futures	8738.92	8749.22	8737.15	8746.57	1086.0
2018-08-13 19:00:00	NQ	Futures	8746.57	8750.11	8741.57	8743.04	1084.0
2018-08-13 20:00:00	NQ	Futures	8742.75	8759.53	8742.45	8758.65	3163.0
2018-08-13 21:00:00	NQ	Futures	8758.65	8761.3	8749.81	8752.17	2144.0
2018-08-13 22:00:00	NQ	Futures	8751.58	8758.06	8744.81	8754.23	2071.0
2018-08-13 23:00:00	NQ	Futures	8754.23	8761.88	8746.87	8760.71	2010.0
2018-08-13 00:00:00	YM	Futures	27386.1	27390.5	27355.7	27370.9	1617.0
2018-08-13 01:00:00	YM	Futures	27370.9	27422.0	27365.5	27395.9	2587.0
2018-08-13 02:00:00	YM	Futures	27394.8	27475.3	27393.7	27416.6	4627.0
2018-08-13 03:00:00	YM	Futures	27416.6	27441.6	27382.9	27399.2	4759.0

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

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