PREVIEW / futures_1hour / 2018-08-09

all futures 1-hour files

  file:    by_date/futures_1hour/2018/2018-08-09.parquet
  size:    54 KB
  rows:    1,684

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-09 00:00:00	ES	Futures	3114.56	3115.11	3113.2	3114.02	1773.0
2018-08-09 01:00:00	ES	Futures	3114.02	3115.11	3114.02	3114.02	2186.0
2018-08-09 02:00:00	ES	Futures	3114.02	3114.83	3112.65	3112.93	3424.0
2018-08-09 03:00:00	ES	Futures	3113.2	3113.2	3110.48	3111.57	9797.0
2018-08-09 04:00:00	ES	Futures	3111.57	3114.56	3111.02	3114.29	9482.0
2018-08-09 05:00:00	ES	Futures	3114.29	3114.83	3112.93	3113.74	7078.0
2018-08-09 06:00:00	ES	Futures	3114.02	3117.01	3112.93	3113.74	11508.0
2018-08-09 07:00:00	ES	Futures	3113.47	3115.65	3112.65	3115.38	10854.0
2018-08-09 08:00:00	ES	Futures	3115.38	3115.92	3114.02	3115.65	9839.0
2018-08-09 09:00:00	ES	Futures	3115.65	3117.01	3112.65	3114.56	89488.0
2018-08-09 10:00:00	ES	Futures	3114.56	3120.01	3114.29	3117.56	79838.0
2018-08-09 11:00:00	ES	Futures	3117.56	3119.47	3111.84	3113.2	84402.0
2018-08-09 12:00:00	ES	Futures	3113.2	3117.83	3112.93	3117.01	56725.0
2018-08-09 13:00:00	ES	Futures	3117.29	3118.92	3115.92	3117.83	37951.0
2018-08-09 14:00:00	ES	Futures	3117.83	3118.1	3115.38	3115.92	39237.0
2018-08-09 15:00:00	ES	Futures	3115.92	3116.47	3108.57	3109.93	152430.0
2018-08-09 16:00:00	ES	Futures	3109.66	3111.57	3106.66	3108.57	52545.0
2018-08-09 18:00:00	ES	Futures	3108.84	3109.11	3105.57	3106.66	6798.0
2018-08-09 19:00:00	ES	Futures	3106.66	3108.3	3106.66	3108.02	2438.0
2018-08-09 20:00:00	ES	Futures	3108.3	3108.57	3104.21	3104.48	5148.0
2018-08-09 21:00:00	ES	Futures	3104.48	3108.02	3104.21	3106.93	7127.0
2018-08-09 22:00:00	ES	Futures	3107.21	3107.21	3104.48	3105.03	4335.0
2018-08-09 23:00:00	ES	Futures	3105.3	3106.39	3104.48	3106.12	2550.0
2018-08-09 00:00:00	NQ	Futures	8802.22	8807.81	8802.22	8805.46	805.0
2018-08-09 01:00:00	NQ	Futures	8805.75	8808.7	8803.4	8803.69	727.0
2018-08-09 02:00:00	NQ	Futures	8804.28	8806.05	8798.98	8800.75	1098.0
2018-08-09 03:00:00	NQ	Futures	8800.75	8801.34	8794.27	8798.69	1822.0
2018-08-09 04:00:00	NQ	Futures	8798.69	8806.34	8796.04	8803.99	1912.0
2018-08-09 05:00:00	NQ	Futures	8803.99	8809.87	8802.51	8805.46	2435.0
2018-08-09 06:00:00	NQ	Futures	8805.46	8816.35	8800.45	8803.4	3116.0
2018-08-09 07:00:00	NQ	Futures	8803.1	8807.81	8798.1	8803.4	4170.0
2018-08-09 08:00:00	NQ	Futures	8803.4	8806.93	8798.98	8804.87	3644.0
2018-08-09 09:00:00	NQ	Futures	8804.87	8819.88	8791.03	8806.05	40933.0
2018-08-09 10:00:00	NQ	Futures	8806.05	8834.9	8804.28	8821.65	40890.0
2018-08-09 11:00:00	NQ	Futures	8821.65	8829.89	8807.52	8813.7	31913.0
2018-08-09 12:00:00	NQ	Futures	8814.0	8830.48	8813.7	8829.01	15815.0
2018-08-09 13:00:00	NQ	Futures	8829.01	8839.02	8821.06	8836.67	20129.0
2018-08-09 14:00:00	NQ	Futures	8836.67	8838.43	8824.89	8828.13	14772.0
2018-08-09 15:00:00	NQ	Futures	8827.83	8829.6	8796.92	8801.93	36327.0
2018-08-09 16:00:00	NQ	Futures	8801.93	8806.05	8792.21	8796.63	6781.0
2018-08-09 18:00:00	NQ	Futures	8799.86	8800.45	8785.73	8789.85	2155.0
2018-08-09 19:00:00	NQ	Futures	8789.56	8793.39	8787.79	8792.5	1236.0
2018-08-09 20:00:00	NQ	Futures	8793.09	8794.86	8779.25	8779.55	2050.0
2018-08-09 21:00:00	NQ	Futures	8779.84	8794.86	8779.84	8790.44	2495.0
2018-08-09 22:00:00	NQ	Futures	8791.33	8791.62	8780.73	8784.85	1517.0
2018-08-09 23:00:00	NQ	Futures	8783.97	8788.68	8782.2	8787.5	870.0
2018-08-09 00:00:00	YM	Futures	27780.8	27789.5	27772.1	27780.8	513.0
2018-08-09 01:00:00	YM	Futures	27780.8	27786.2	27771.0	27773.1	637.0
2018-08-09 02:00:00	YM	Futures	27774.2	27777.5	27753.6	27759.0	1032.0
2018-08-09 03:00:00	YM	Futures	27759.0	27759.0	27727.5	27742.7	1915.0

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

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