PREVIEW / futures_1hour / 2019-02-22

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-02-22.parquet
  size:    46 KB
  rows:    1,398

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-02-22 00:00:00	ES	Futures	3011.6	3015.13	3009.97	3014.32	6184.0
2019-02-22 01:00:00	ES	Futures	3014.32	3016.49	3013.23	3016.22	6124.0
2019-02-22 02:00:00	ES	Futures	3016.22	3017.03	3013.23	3015.95	7162.0
2019-02-22 03:00:00	ES	Futures	3015.95	3023.01	3015.13	3022.19	20032.0
2019-02-22 04:00:00	ES	Futures	3022.19	3024.64	3020.29	3022.46	15895.0
2019-02-22 05:00:00	ES	Futures	3022.46	3026.81	3021.38	3025.18	13258.0
2019-02-22 06:00:00	ES	Futures	3025.18	3028.44	3024.37	3027.08	14331.0
2019-02-22 07:00:00	ES	Futures	3027.08	3027.62	3024.91	3025.45	13184.0
2019-02-22 08:00:00	ES	Futures	3025.72	3026.54	3020.56	3021.38	28394.0
2019-02-22 09:00:00	ES	Futures	3021.38	3026.0	3018.66	3026.0	140048.0
2019-02-22 10:00:00	ES	Futures	3025.72	3030.07	3023.55	3028.98	187108.0
2019-02-22 11:00:00	ES	Futures	3028.98	3034.96	3027.35	3033.06	125138.0
2019-02-22 12:00:00	ES	Futures	3032.78	3035.77	3030.07	3031.7	70495.0
2019-02-22 13:00:00	ES	Futures	3031.7	3031.97	3027.62	3030.61	65506.0
2019-02-22 14:00:00	ES	Futures	3030.88	3033.33	3021.38	3023.28	136925.0
2019-02-22 15:00:00	ES	Futures	3023.01	3034.14	3022.19	3033.33	192271.0
2019-02-22 16:00:00	ES	Futures	3033.06	3036.86	3030.34	3036.59	54019.0
2019-02-22 00:00:00	NQ	Futures	8211.69	8225.71	8208.77	8223.38	3127.0
2019-02-22 01:00:00	NQ	Futures	8223.08	8233.02	8219.58	8230.97	3060.0
2019-02-22 02:00:00	NQ	Futures	8231.27	8233.02	8219.87	8228.93	3766.0
2019-02-22 03:00:00	NQ	Futures	8228.93	8254.35	8228.93	8250.55	6102.0
2019-02-22 04:00:00	NQ	Futures	8250.84	8258.15	8245.88	8252.01	4453.0
2019-02-22 05:00:00	NQ	Futures	8252.01	8268.37	8247.92	8263.7	4468.0
2019-02-22 06:00:00	NQ	Futures	8263.7	8272.17	8260.78	8270.42	3884.0
2019-02-22 07:00:00	NQ	Futures	8270.13	8273.63	8261.36	8262.53	8202.0
2019-02-22 08:00:00	NQ	Futures	8262.53	8265.45	8240.91	8246.75	10548.0
2019-02-22 09:00:00	NQ	Futures	8246.75	8271.59	8244.71	8271.0	54132.0
2019-02-22 10:00:00	NQ	Futures	8271.0	8285.61	8254.93	8281.81	56138.0
2019-02-22 11:00:00	NQ	Futures	8281.81	8299.64	8275.39	8291.75	38818.0
2019-02-22 12:00:00	NQ	Futures	8291.46	8298.47	8280.65	8284.74	24378.0
2019-02-22 13:00:00	NQ	Futures	8284.74	8286.49	8274.22	8283.86	20182.0
2019-02-22 14:00:00	NQ	Futures	8284.15	8291.46	8249.09	8257.56	44351.0
2019-02-22 15:00:00	NQ	Futures	8257.56	8293.79	8253.18	8292.92	48507.0
2019-02-22 16:00:00	NQ	Futures	8292.63	8299.05	8278.31	8298.76	9425.0
2019-02-22 00:00:00	YM	Futures	28031.9	28064.4	28016.7	28055.7	1858.0
2019-02-22 01:00:00	YM	Futures	28055.7	28085.1	28048.1	28080.7	1650.0
2019-02-22 02:00:00	YM	Futures	28080.7	28087.2	28044.9	28073.1	2565.0
2019-02-22 03:00:00	YM	Futures	28073.1	28140.4	28064.4	28127.4	4553.0
2019-02-22 04:00:00	YM	Futures	28129.6	28157.8	28116.5	28139.3	3835.0
2019-02-22 05:00:00	YM	Futures	28139.3	28182.8	28130.7	28165.4	3639.0
2019-02-22 06:00:00	YM	Futures	28166.5	28194.7	28160.0	28184.9	3323.0
2019-02-22 07:00:00	YM	Futures	28184.9	28200.1	28169.7	28171.9	3306.0
2019-02-22 08:00:00	YM	Futures	28171.9	28182.8	28124.1	28136.1	6444.0
2019-02-22 09:00:00	YM	Futures	28136.1	28188.2	28122.0	28175.2	20749.0
2019-02-22 10:00:00	YM	Futures	28175.2	28226.2	28164.3	28216.4	25704.0
2019-02-22 11:00:00	YM	Futures	28217.5	28271.8	28204.5	28255.5	20564.0
2019-02-22 12:00:00	YM	Futures	28254.4	28276.1	28214.3	28233.8	11275.0
2019-02-22 13:00:00	YM	Futures	28234.9	28237.1	28193.6	28222.9	11136.0
2019-02-22 14:00:00	YM	Futures	28222.9	28246.8	28120.9	28144.8	20161.0
2019-02-22 15:00:00	YM	Futures	28143.7	28255.5	28132.8	28245.7	22920.0

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

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