PREVIEW / futures_1hour / 2019-03-22

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-03-22.parquet
  size:    50 KB
  rows:    1,440

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-03-22 00:00:00	ES	Futures	3098.97	3099.78	3097.89	3098.97	2324.0
2019-03-22 01:00:00	ES	Futures	3099.24	3100.87	3098.97	3099.78	5173.0
2019-03-22 02:00:00	ES	Futures	3099.78	3100.87	3097.61	3100.87	4439.0
2019-03-22 03:00:00	ES	Futures	3100.6	3104.39	3099.78	3103.58	9399.0
2019-03-22 04:00:00	ES	Futures	3103.85	3104.12	3087.58	3088.67	47450.0
2019-03-22 05:00:00	ES	Futures	3088.94	3094.09	3087.58	3090.29	33066.0
2019-03-22 06:00:00	ES	Futures	3090.57	3092.46	3087.58	3090.84	22928.0
2019-03-22 07:00:00	ES	Futures	3090.84	3092.73	3088.67	3090.29	21149.0
2019-03-22 08:00:00	ES	Futures	3090.29	3090.57	3082.16	3088.4	53280.0
2019-03-22 09:00:00	ES	Futures	3088.13	3092.46	3069.69	3071.86	288715.0
2019-03-22 10:00:00	ES	Futures	3071.86	3083.52	3065.9	3066.71	322773.0
2019-03-22 11:00:00	ES	Futures	3066.44	3071.05	3046.65	3046.92	320680.0
2019-03-22 12:00:00	ES	Futures	3046.92	3055.32	3043.39	3053.7	243154.0
2019-03-22 13:00:00	ES	Futures	3053.42	3057.76	3046.92	3048.82	147882.0
2019-03-22 14:00:00	ES	Futures	3048.55	3066.71	3047.73	3063.73	172510.0
2019-03-22 15:00:00	ES	Futures	3063.73	3067.25	3042.04	3042.85	345501.0
2019-03-22 16:00:00	ES	Futures	3042.58	3051.53	3042.58	3044.48	98165.0
2019-03-22 00:00:00	NQ	Futures	8760.01	8762.05	8755.94	8761.18	1709.0
2019-03-22 01:00:00	NQ	Futures	8761.18	8766.42	8757.68	8761.76	2740.0
2019-03-22 02:00:00	NQ	Futures	8761.76	8765.84	8755.94	8765.25	2554.0
2019-03-22 03:00:00	NQ	Futures	8764.96	8778.65	8762.34	8775.44	4804.0
2019-03-22 04:00:00	NQ	Futures	8775.15	8779.52	8732.93	8735.85	16434.0
2019-03-22 05:00:00	NQ	Futures	8735.85	8754.19	8730.61	8743.71	14191.0
2019-03-22 06:00:00	NQ	Futures	8744.29	8748.07	8731.48	8739.05	9829.0
2019-03-22 07:00:00	NQ	Futures	8739.34	8749.82	8737.01	8742.83	6256.0
2019-03-22 08:00:00	NQ	Futures	8743.13	8744.29	8719.54	8735.26	16613.0
2019-03-22 09:00:00	NQ	Futures	8734.68	8750.11	8665.97	8675.29	97621.0
2019-03-22 10:00:00	NQ	Futures	8675.29	8722.45	8661.31	8667.72	93396.0
2019-03-22 11:00:00	NQ	Futures	8667.42	8675.87	8599.0	8599.88	98570.0
2019-03-22 12:00:00	NQ	Futures	8600.17	8628.99	8590.56	8621.13	78085.0
2019-03-22 13:00:00	NQ	Futures	8621.13	8635.4	8585.32	8591.72	55736.0
2019-03-22 14:00:00	NQ	Futures	8591.43	8640.93	8588.52	8633.65	54153.0
2019-03-22 15:00:00	NQ	Futures	8633.94	8644.42	8563.48	8569.6	87027.0
2019-03-22 16:00:00	NQ	Futures	8569.89	8591.72	8569.01	8569.89	18348.0
2019-03-22 00:00:00	YM	Futures	28248.9	28259.8	28243.5	28256.5	600.0
2019-03-22 01:00:00	YM	Futures	28257.6	28267.4	28246.7	28252.2	1361.0
2019-03-22 02:00:00	YM	Futures	28253.2	28257.6	28215.2	28247.8	2213.0
2019-03-22 03:00:00	YM	Futures	28246.7	28276.1	28239.1	28268.5	2754.0
2019-03-22 04:00:00	YM	Futures	28269.6	28280.4	28119.5	28139.0	9676.0
2019-03-22 05:00:00	YM	Futures	28140.1	28184.7	28126.0	28154.3	8446.0
2019-03-22 06:00:00	YM	Futures	28154.3	28179.3	28126.0	28164.1	4838.0
2019-03-22 07:00:00	YM	Futures	28166.2	28185.8	28135.8	28147.7	3626.0
2019-03-22 08:00:00	YM	Futures	28147.7	28148.8	28078.1	28116.2	7567.0
2019-03-22 09:00:00	YM	Futures	28115.1	28181.5	27945.4	27977.0	34186.0
2019-03-22 10:00:00	YM	Futures	27977.0	28093.4	27945.4	27950.9	39114.0
2019-03-22 11:00:00	YM	Futures	27949.8	27994.4	27805.1	27808.4	41751.0
2019-03-22 12:00:00	YM	Futures	27808.4	27868.2	27773.6	27855.2	32762.0
2019-03-22 13:00:00	YM	Futures	27854.1	27900.8	27809.5	27824.7	21214.0
2019-03-22 14:00:00	YM	Futures	27825.8	27997.6	27818.2	27977.0	25625.0
2019-03-22 15:00:00	YM	Futures	27975.9	28005.3	27767.1	27775.8	35653.0

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

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