PREVIEW / futures_1hour / 2019-04-01

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-04-01.parquet
  size:    56 KB
  rows:    1,771

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-04-01 00:00:00	ES	Futures	3098.7	3098.7	3096.26	3097.07	5229.0
2019-04-01 01:00:00	ES	Futures	3097.34	3098.43	3096.53	3098.16	5616.0
2019-04-01 02:00:00	ES	Futures	3098.43	3098.97	3095.45	3097.61	9350.0
2019-04-01 03:00:00	ES	Futures	3097.61	3100.87	3095.72	3100.6	18493.0
2019-04-01 04:00:00	ES	Futures	3100.6	3102.77	3098.43	3100.87	18816.0
2019-04-01 05:00:00	ES	Futures	3100.6	3101.41	3097.07	3097.34	15062.0
2019-04-01 06:00:00	ES	Futures	3097.34	3099.51	3095.45	3095.72	11977.0
2019-04-01 07:00:00	ES	Futures	3095.45	3099.51	3095.45	3099.24	12536.0
2019-04-01 08:00:00	ES	Futures	3099.24	3100.87	3094.63	3098.16	32168.0
2019-04-01 09:00:00	ES	Futures	3098.43	3102.22	3097.07	3098.16	177969.0
2019-04-01 10:00:00	ES	Futures	3098.43	3105.21	3098.43	3102.22	206942.0
2019-04-01 11:00:00	ES	Futures	3102.22	3106.29	3100.6	3104.12	125126.0
2019-04-01 12:00:00	ES	Futures	3104.39	3107.65	3101.41	3107.65	76522.0
2019-04-01 13:00:00	ES	Futures	3107.65	3109.27	3104.93	3109.27	71443.0
2019-04-01 14:00:00	ES	Futures	3109.0	3112.25	3108.46	3110.09	86083.0
2019-04-01 15:00:00	ES	Futures	3109.81	3116.05	3106.83	3113.34	193201.0
2019-04-01 16:00:00	ES	Futures	3113.07	3114.42	3108.46	3112.8	74282.0
2019-04-01 18:00:00	ES	Futures	3110.63	3111.98	3109.54	3110.63	5762.0
2019-04-01 19:00:00	ES	Futures	3110.9	3114.42	3109.81	3114.15	5597.0
2019-04-01 20:00:00	ES	Futures	3114.15	3114.42	3111.17	3111.44	8752.0
2019-04-01 21:00:00	ES	Futures	3111.17	3112.25	3109.27	3110.63	7440.0
2019-04-01 22:00:00	ES	Futures	3110.63	3110.9	3108.19	3109.0	6138.0
2019-04-01 23:00:00	ES	Futures	3109.0	3110.63	3106.83	3108.46	5763.0
2019-04-01 00:00:00	NQ	Futures	8712.55	8712.55	8703.53	8704.98	2567.0
2019-04-01 01:00:00	NQ	Futures	8704.98	8709.35	8703.53	8707.31	2407.0
2019-04-01 02:00:00	NQ	Futures	8707.02	8708.77	8698.87	8703.82	5110.0
2019-04-01 03:00:00	NQ	Futures	8703.82	8715.76	8699.16	8715.76	8712.0
2019-04-01 04:00:00	NQ	Futures	8715.76	8720.12	8706.44	8713.72	8367.0
2019-04-01 05:00:00	NQ	Futures	8713.43	8716.05	8699.45	8701.49	7508.0
2019-04-01 06:00:00	NQ	Futures	8701.2	8705.57	8694.5	8695.96	6741.0
2019-04-01 07:00:00	NQ	Futures	8695.38	8703.82	8694.5	8700.91	5903.0
2019-04-01 08:00:00	NQ	Futures	8700.62	8707.6	8688.68	8695.08	12370.0
2019-04-01 09:00:00	NQ	Futures	8695.08	8714.88	8682.86	8691.01	66695.0
2019-04-01 10:00:00	NQ	Futures	8691.3	8707.6	8670.63	8693.92	69609.0
2019-04-01 11:00:00	NQ	Futures	8693.92	8717.21	8691.59	8706.15	45549.0
2019-04-01 12:00:00	NQ	Futures	8706.15	8725.36	8695.38	8723.91	27983.0
2019-04-01 13:00:00	NQ	Futures	8724.2	8732.06	8714.01	8730.61	23912.0
2019-04-01 14:00:00	NQ	Futures	8730.61	8736.43	8725.95	8733.81	23795.0
2019-04-01 15:00:00	NQ	Futures	8733.52	8742.25	8722.45	8736.14	40590.0
2019-04-01 16:00:00	NQ	Futures	8735.85	8740.8	8720.41	8731.77	16259.0
2019-04-01 18:00:00	NQ	Futures	8729.15	8732.06	8724.2	8729.73	2179.0
2019-04-01 19:00:00	NQ	Futures	8730.02	8742.54	8726.53	8740.5	2965.0
2019-04-01 20:00:00	NQ	Futures	8740.8	8741.09	8732.35	8733.23	4031.0
2019-04-01 21:00:00	NQ	Futures	8732.64	8736.14	8725.95	8729.73	3572.0
2019-04-01 22:00:00	NQ	Futures	8730.02	8731.19	8719.83	8722.45	3113.0
2019-04-01 23:00:00	NQ	Futures	8722.74	8727.4	8715.76	8720.41	2728.0
2019-04-01 00:00:00	YM	Futures	28393.6	28393.6	28369.6	28384.9	1321.0
2019-04-01 01:00:00	YM	Futures	28384.9	28397.9	28375.1	28387.0	1397.0
2019-04-01 02:00:00	YM	Futures	28388.1	28392.5	28364.2	28388.1	2206.0
2019-04-01 03:00:00	YM	Futures	28388.1	28419.7	28374.0	28419.7	3051.0

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

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