PREVIEW / futures_1hour / 2019-05-15

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-05-15.parquet
  size:    60 KB
  rows:    1,863

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-05-15 00:00:00	ES	Futures	3084.06	3084.6	3082.7	3084.06	2836.0
2019-05-15 01:00:00	ES	Futures	3084.33	3087.58	3083.79	3086.5	18879.0
2019-05-15 02:00:00	ES	Futures	3086.77	3088.94	3084.06	3087.31	21340.0
2019-05-15 03:00:00	ES	Futures	3087.58	3087.85	3073.76	3075.93	44831.0
2019-05-15 04:00:00	ES	Futures	3075.66	3079.45	3072.4	3076.74	20284.0
2019-05-15 05:00:00	ES	Futures	3076.74	3081.35	3069.42	3070.78	26818.0
2019-05-15 06:00:00	ES	Futures	3070.78	3073.22	3066.44	3072.13	24359.0
2019-05-15 07:00:00	ES	Futures	3071.86	3073.76	3067.52	3068.06	26065.0
2019-05-15 08:00:00	ES	Futures	3068.06	3068.88	3055.32	3058.58	82779.0
2019-05-15 09:00:00	ES	Futures	3058.85	3065.9	3052.61	3063.18	280007.0
2019-05-15 10:00:00	ES	Futures	3063.18	3088.13	3056.95	3085.14	369894.0
2019-05-15 11:00:00	ES	Futures	3085.14	3095.99	3080.26	3094.9	162241.0
2019-05-15 12:00:00	ES	Futures	3094.9	3099.24	3089.75	3091.92	109297.0
2019-05-15 13:00:00	ES	Futures	3091.92	3098.7	3089.75	3097.61	110033.0
2019-05-15 14:00:00	ES	Futures	3097.61	3101.41	3095.99	3096.26	80636.0
2019-05-15 15:00:00	ES	Futures	3096.26	3101.41	3092.46	3093.82	163307.0
2019-05-15 16:00:00	ES	Futures	3093.55	3098.16	3092.46	3095.45	58030.0
2019-05-15 18:00:00	ES	Futures	3094.36	3095.45	3091.65	3093.55	7087.0
2019-05-15 19:00:00	ES	Futures	3093.82	3094.09	3091.38	3093.01	4117.0
2019-05-15 20:00:00	ES	Futures	3092.73	3093.01	3088.13	3089.21	10712.0
2019-05-15 21:00:00	ES	Futures	3089.21	3089.48	3080.26	3084.33	34758.0
2019-05-15 22:00:00	ES	Futures	3084.6	3093.82	3082.43	3088.94	17475.0
2019-05-15 23:00:00	ES	Futures	3088.94	3092.19	3086.23	3086.77	19335.0
2019-05-15 00:00:00	NQ	Futures	8667.13	8669.75	8663.93	8667.42	1384.0
2019-05-15 01:00:00	NQ	Futures	8667.72	8682.27	8665.39	8679.36	5147.0
2019-05-15 02:00:00	NQ	Futures	8679.36	8684.6	8671.5	8680.24	4839.0
2019-05-15 03:00:00	NQ	Futures	8680.53	8680.82	8631.61	8638.02	12690.0
2019-05-15 04:00:00	NQ	Futures	8638.02	8654.03	8629.57	8643.84	7854.0
2019-05-15 05:00:00	NQ	Futures	8643.84	8660.73	8622.59	8625.21	10295.0
2019-05-15 06:00:00	NQ	Futures	8625.21	8635.4	8610.07	8625.5	9916.0
2019-05-15 07:00:00	NQ	Futures	8624.62	8635.11	8610.94	8612.4	9189.0
2019-05-15 08:00:00	NQ	Futures	8612.98	8615.31	8571.63	8585.03	23161.0
2019-05-15 09:00:00	NQ	Futures	8585.03	8632.19	8564.36	8628.12	90135.0
2019-05-15 10:00:00	NQ	Futures	8627.54	8722.16	8625.21	8710.81	109580.0
2019-05-15 11:00:00	NQ	Futures	8710.81	8750.4	8694.5	8740.5	58656.0
2019-05-15 12:00:00	NQ	Futures	8740.5	8759.14	8719.25	8725.66	39846.0
2019-05-15 13:00:00	NQ	Futures	8725.36	8769.04	8722.74	8764.38	35099.0
2019-05-15 14:00:00	NQ	Futures	8764.38	8779.52	8758.27	8761.76	27887.0
2019-05-15 15:00:00	NQ	Futures	8761.47	8776.61	8750.11	8753.9	41072.0
2019-05-15 16:00:00	NQ	Futures	8753.9	8775.44	8749.82	8766.13	14267.0
2019-05-15 18:00:00	NQ	Futures	8762.92	8767.0	8755.06	8760.89	2779.0
2019-05-15 19:00:00	NQ	Futures	8760.89	8761.47	8752.73	8755.64	1892.0
2019-05-15 20:00:00	NQ	Futures	8755.94	8755.94	8739.05	8743.71	5602.0
2019-05-15 21:00:00	NQ	Futures	8744.0	8744.87	8703.82	8718.38	14134.0
2019-05-15 22:00:00	NQ	Futures	8718.96	8749.24	8712.55	8734.68	7589.0
2019-05-15 23:00:00	NQ	Futures	8734.97	8744.58	8725.36	8729.15	4945.0
2019-05-15 00:00:00	YM	Futures	27850.8	27857.3	27839.9	27851.9	962.0
2019-05-15 01:00:00	YM	Futures	27853.0	27882.3	27848.6	27869.3	4445.0
2019-05-15 02:00:00	YM	Futures	27868.2	27896.5	27851.9	27873.6	4910.0
2019-05-15 03:00:00	YM	Futures	27874.7	27875.8	27756.2	27773.6	8428.0

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

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