PREVIEW / futures_1hour / 2018-08-02

all futures 1-hour files

  file:    by_date/futures_1hour/2018/2018-08-02.parquet
  size:    55 KB
  rows:    1,702

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-02 00:00:00	ES	Futures	3060.07	3061.43	3056.8	3060.34	8320.0
2018-08-02 01:00:00	ES	Futures	3060.34	3061.98	3057.34	3058.16	12981.0
2018-08-02 02:00:00	ES	Futures	3058.16	3058.71	3053.26	3054.89	13929.0
2018-08-02 03:00:00	ES	Futures	3054.89	3055.44	3051.35	3053.26	28223.0
2018-08-02 04:00:00	ES	Futures	3052.98	3055.98	3049.44	3049.99	19469.0
2018-08-02 05:00:00	ES	Futures	3049.99	3050.53	3042.63	3045.63	35079.0
2018-08-02 06:00:00	ES	Futures	3045.36	3046.45	3041.81	3044.81	27532.0
2018-08-02 07:00:00	ES	Futures	3044.81	3047.81	3043.99	3046.45	23706.0
2018-08-02 08:00:00	ES	Futures	3046.45	3050.26	3043.45	3048.9	33269.0
2018-08-02 09:00:00	ES	Futures	3048.9	3055.98	3046.17	3055.16	148850.0
2018-08-02 10:00:00	ES	Futures	3054.89	3065.25	3054.62	3058.71	199139.0
2018-08-02 11:00:00	ES	Futures	3058.71	3069.88	3057.89	3068.79	130037.0
2018-08-02 12:00:00	ES	Futures	3068.79	3076.96	3066.34	3075.6	129883.0
2018-08-02 13:00:00	ES	Futures	3075.6	3081.87	3075.33	3081.32	83400.0
2018-08-02 14:00:00	ES	Futures	3081.59	3082.96	3077.78	3080.23	69012.0
2018-08-02 15:00:00	ES	Futures	3080.23	3083.77	3077.23	3081.05	151751.0
2018-08-02 16:00:00	ES	Futures	3081.05	3085.68	3080.78	3084.86	58381.0
2018-08-02 18:00:00	ES	Futures	3085.14	3085.14	3082.96	3083.77	4019.0
2018-08-02 19:00:00	ES	Futures	3083.77	3084.05	3082.68	3083.23	3009.0
2018-08-02 20:00:00	ES	Futures	3083.5	3084.86	3082.41	3082.96	4902.0
2018-08-02 21:00:00	ES	Futures	3083.23	3084.05	3080.5	3082.41	8197.0
2018-08-02 22:00:00	ES	Futures	3082.41	3082.41	3079.96	3080.5	5647.0
2018-08-02 23:00:00	ES	Futures	3080.5	3082.14	3080.5	3080.78	3079.0
2018-08-02 00:00:00	NQ	Futures	8551.96	8556.67	8540.19	8553.73	2737.0
2018-08-02 01:00:00	NQ	Futures	8553.73	8558.74	8544.31	8552.55	2921.0
2018-08-02 02:00:00	NQ	Futures	8552.26	8553.44	8533.42	8539.01	3966.0
2018-08-02 03:00:00	NQ	Futures	8539.01	8542.25	8522.82	8528.41	7574.0
2018-08-02 04:00:00	NQ	Futures	8529.0	8536.36	8520.76	8522.23	4176.0
2018-08-02 05:00:00	NQ	Futures	8522.23	8522.82	8497.79	8506.92	7439.0
2018-08-02 06:00:00	NQ	Futures	8506.92	8512.51	8498.38	8507.21	4684.0
2018-08-02 07:00:00	NQ	Futures	8507.51	8512.81	8502.5	8504.56	7269.0
2018-08-02 08:00:00	NQ	Futures	8504.27	8517.22	8496.02	8510.45	9993.0
2018-08-02 09:00:00	NQ	Futures	8510.16	8559.91	8501.62	8555.5	65951.0
2018-08-02 10:00:00	NQ	Futures	8554.91	8612.61	8554.91	8588.18	80221.0
2018-08-02 11:00:00	NQ	Futures	8588.18	8643.53	8577.58	8630.87	64856.0
2018-08-02 12:00:00	NQ	Futures	8631.16	8667.38	8621.74	8656.78	48996.0
2018-08-02 13:00:00	NQ	Futures	8656.78	8694.17	8656.48	8688.87	36380.0
2018-08-02 14:00:00	NQ	Futures	8688.87	8697.7	8678.27	8685.92	26027.0
2018-08-02 15:00:00	NQ	Futures	8686.22	8703.29	8677.39	8692.11	39502.0
2018-08-02 16:00:00	NQ	Futures	8692.11	8709.18	8691.52	8706.24	10252.0
2018-08-02 18:00:00	NQ	Futures	8705.36	8709.18	8697.41	8700.65	1420.0
2018-08-02 19:00:00	NQ	Futures	8700.35	8702.71	8697.7	8701.53	844.0
2018-08-02 20:00:00	NQ	Futures	8701.53	8706.83	8697.7	8702.71	2249.0
2018-08-02 21:00:00	NQ	Futures	8702.71	8705.65	8692.7	8701.23	2902.0
2018-08-02 22:00:00	NQ	Futures	8701.23	8701.23	8691.81	8692.99	1693.0
2018-08-02 23:00:00	NQ	Futures	8692.7	8699.76	8692.11	8697.41	1407.0
2018-08-02 00:00:00	YM	Futures	27454.6	27457.9	27413.3	27444.8	2482.0
2018-08-02 01:00:00	YM	Futures	27445.9	27457.9	27410.0	27425.3	2478.0
2018-08-02 02:00:00	YM	Futures	27426.3	27429.6	27382.9	27395.9	2702.0
2018-08-02 03:00:00	YM	Futures	27397.0	27403.5	27369.8	27379.6	4223.0

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

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