PREVIEW / futures_1hour / 2018-07-16

all futures 1-hour files

  file:    by_date/futures_1hour/2018/2018-07-16.parquet
  size:    53 KB
  rows:    1,649

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-07-16 00:00:00	ES	Futures	3057.89	3057.89	3057.07	3057.62	828.0
2018-07-16 01:00:00	ES	Futures	3057.62	3058.16	3056.53	3057.07	2405.0
2018-07-16 02:00:00	ES	Futures	3056.8	3057.89	3055.71	3057.34	5199.0
2018-07-16 03:00:00	ES	Futures	3057.34	3059.8	3057.07	3059.25	8623.0
2018-07-16 04:00:00	ES	Futures	3059.25	3059.8	3056.53	3058.43	7601.0
2018-07-16 05:00:00	ES	Futures	3058.43	3058.98	3055.98	3056.53	6287.0
2018-07-16 06:00:00	ES	Futures	3056.8	3057.34	3054.07	3055.98	8215.0
2018-07-16 07:00:00	ES	Futures	3055.98	3056.53	3052.17	3054.89	14099.0
2018-07-16 08:00:00	ES	Futures	3054.89	3055.71	3051.89	3053.8	16759.0
2018-07-16 09:00:00	ES	Futures	3053.8	3056.8	3049.72	3052.44	124800.0
2018-07-16 10:00:00	ES	Futures	3052.71	3053.8	3046.45	3046.45	123771.0
2018-07-16 11:00:00	ES	Futures	3046.45	3051.62	3046.17	3050.26	81688.0
2018-07-16 12:00:00	ES	Futures	3050.53	3054.35	3048.08	3053.8	55344.0
2018-07-16 13:00:00	ES	Futures	3054.07	3055.16	3051.62	3052.71	37067.0
2018-07-16 14:00:00	ES	Futures	3052.44	3053.26	3046.45	3047.81	75202.0
2018-07-16 15:00:00	ES	Futures	3047.81	3052.98	3047.26	3052.17	115334.0
2018-07-16 16:00:00	ES	Futures	3051.89	3052.98	3046.17	3047.81	68656.0
2018-07-16 18:00:00	ES	Futures	3046.99	3049.17	3045.36	3048.08	5918.0
2018-07-16 19:00:00	ES	Futures	3047.81	3049.99	3047.54	3049.17	2636.0
2018-07-16 20:00:00	ES	Futures	3048.9	3051.08	3048.35	3049.99	5441.0
2018-07-16 21:00:00	ES	Futures	3049.99	3053.26	3047.54	3048.35	9228.0
2018-07-16 22:00:00	ES	Futures	3048.63	3048.9	3046.72	3047.81	6286.0
2018-07-16 23:00:00	ES	Futures	3047.54	3049.72	3047.54	3049.44	3860.0
2018-07-16 00:00:00	NQ	Futures	8716.84	8717.43	8713.6	8715.66	777.0
2018-07-16 01:00:00	NQ	Futures	8715.95	8718.02	8709.18	8711.24	1548.0
2018-07-16 02:00:00	NQ	Futures	8711.54	8713.89	8707.71	8712.42	1985.0
2018-07-16 03:00:00	NQ	Futures	8712.13	8723.9	8710.95	8721.84	2811.0
2018-07-16 04:00:00	NQ	Futures	8722.43	8725.97	8718.31	8723.9	2373.0
2018-07-16 05:00:00	NQ	Futures	8723.9	8726.26	8718.9	8721.84	2078.0
2018-07-16 06:00:00	NQ	Futures	8721.25	8722.73	8711.83	8717.43	3107.0
2018-07-16 07:00:00	NQ	Futures	8717.43	8718.02	8703.29	8716.25	3757.0
2018-07-16 08:00:00	NQ	Futures	8715.95	8716.54	8703.88	8709.77	5784.0
2018-07-16 09:00:00	NQ	Futures	8709.77	8723.32	8693.87	8713.89	39626.0
2018-07-16 10:00:00	NQ	Futures	8714.19	8721.25	8686.51	8686.51	38328.0
2018-07-16 11:00:00	NQ	Futures	8686.51	8702.71	8685.63	8698.88	25443.0
2018-07-16 12:00:00	NQ	Futures	8698.58	8712.72	8689.16	8704.18	18518.0
2018-07-16 13:00:00	NQ	Futures	8704.18	8706.53	8692.99	8698.0	14817.0
2018-07-16 14:00:00	NQ	Futures	8698.29	8700.65	8671.2	8677.68	22329.0
2018-07-16 15:00:00	NQ	Futures	8677.68	8690.34	8671.2	8686.51	26146.0
2018-07-16 16:00:00	NQ	Futures	8685.92	8687.4	8615.85	8622.33	21951.0
2018-07-16 18:00:00	NQ	Futures	8620.56	8632.63	8617.03	8628.51	3024.0
2018-07-16 19:00:00	NQ	Futures	8628.22	8635.58	8625.86	8631.16	1614.0
2018-07-16 20:00:00	NQ	Futures	8631.46	8634.4	8626.45	8630.87	2372.0
2018-07-16 21:00:00	NQ	Futures	8631.16	8642.94	8619.97	8622.92	4969.0
2018-07-16 22:00:00	NQ	Futures	8622.92	8623.21	8609.96	8618.21	3310.0
2018-07-16 23:00:00	NQ	Futures	8618.21	8626.16	8617.62	8624.1	1587.0
2018-07-16 00:00:00	YM	Futures	27236.1	27239.4	27231.8	27238.3	383.0
2018-07-16 01:00:00	YM	Futures	27238.3	27242.6	27222.0	27230.7	850.0
2018-07-16 02:00:00	YM	Futures	27229.6	27233.9	27216.5	27229.6	1425.0
2018-07-16 03:00:00	YM	Futures	27229.6	27265.5	27223.1	27261.1	2475.0

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

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