PREVIEW / futures_1hour / 2020-04-28

all futures 1-hour files

  file:    by_date/futures_1hour/2020/2020-04-28.parquet
  size:    62 KB
  rows:    1,866

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
2020-04-28 00:00:00	ES	Futures	3136.01	3138.2	3129.42	3137.38	8197.0
2020-04-28 01:00:00	ES	Futures	3137.65	3149.45	3135.46	3144.51	8436.0
2020-04-28 02:00:00	ES	Futures	3144.51	3149.18	3140.12	3143.14	7527.0
2020-04-28 03:00:00	ES	Futures	3143.14	3164.27	3141.77	3161.8	26302.0
2020-04-28 04:00:00	ES	Futures	3161.8	3162.62	3153.29	3158.23	23194.0
2020-04-28 05:00:00	ES	Futures	3158.23	3189.52	3157.69	3188.69	50295.0
2020-04-28 06:00:00	ES	Futures	3188.69	3191.99	3183.21	3184.03	33926.0
2020-04-28 07:00:00	ES	Futures	3184.3	3190.89	3181.01	3190.89	32312.0
2020-04-28 08:00:00	ES	Futures	3190.89	3197.48	3186.5	3196.65	47393.0
2020-04-28 09:00:00	ES	Futures	3196.65	3198.02	3174.97	3175.25	185726.0
2020-04-28 10:00:00	ES	Futures	3174.97	3181.01	3133.26	3135.46	269175.0
2020-04-28 11:00:00	ES	Futures	3135.73	3156.59	3132.71	3145.89	182785.0
2020-04-28 12:00:00	ES	Futures	3146.16	3153.84	3133.54	3151.37	146136.0
2020-04-28 13:00:00	ES	Futures	3151.37	3158.78	3147.53	3153.02	100305.0
2020-04-28 14:00:00	ES	Futures	3152.75	3162.62	3148.63	3151.92	133845.0
2020-04-28 15:00:00	ES	Futures	3151.65	3160.43	3130.52	3134.91	218208.0
2020-04-28 16:00:00	ES	Futures	3134.63	3148.08	3132.99	3139.85	60253.0
2020-04-28 18:00:00	ES	Futures	3150.83	3153.57	3140.12	3143.96	10842.0
2020-04-28 19:00:00	ES	Futures	3143.96	3157.14	3140.4	3151.92	8878.0
2020-04-28 20:00:00	ES	Futures	3152.2	3160.98	3151.37	3158.78	10344.0
2020-04-28 21:00:00	ES	Futures	3158.78	3184.85	3158.23	3174.97	24532.0
2020-04-28 22:00:00	ES	Futures	3174.7	3183.21	3172.78	3182.38	10804.0
2020-04-28 23:00:00	ES	Futures	3182.38	3182.66	3174.97	3181.29	5398.0
2020-04-28 00:00:00	NQ	Futures	10050.84	10057.98	10028.56	10057.41	2111.0
2020-04-28 01:00:00	NQ	Futures	10056.26	10100.82	10047.7	10085.69	4508.0
2020-04-28 02:00:00	NQ	Futures	10085.4	10097.4	10069.69	10079.97	3953.0
2020-04-28 03:00:00	NQ	Futures	10079.69	10140.24	10075.12	10133.1	8476.0
2020-04-28 04:00:00	NQ	Futures	10133.1	10139.39	10114.54	10125.39	6462.0
2020-04-28 05:00:00	NQ	Futures	10125.68	10214.51	10122.53	10211.65	12535.0
2020-04-28 06:00:00	NQ	Futures	10211.37	10221.08	10191.94	10196.23	8583.0
2020-04-28 07:00:00	NQ	Futures	10195.37	10204.8	10183.95	10201.94	7509.0
2020-04-28 08:00:00	NQ	Futures	10201.37	10208.23	10177.66	10192.8	10743.0
2020-04-28 09:00:00	NQ	Futures	10192.51	10195.66	10085.4	10089.11	52548.0
2020-04-28 10:00:00	NQ	Futures	10088.54	10099.4	9927.15	9939.44	85674.0
2020-04-28 11:00:00	NQ	Futures	9939.72	9999.99	9932.87	9960.86	48849.0
2020-04-28 12:00:00	NQ	Futures	9961.15	9981.43	9911.73	9974.86	43565.0
2020-04-28 13:00:00	NQ	Futures	9975.14	9997.99	9962.0	9980.28	29487.0
2020-04-28 14:00:00	NQ	Futures	9979.71	10013.7	9956.58	9965.72	30762.0
2020-04-28 15:00:00	NQ	Futures	9966.0	9991.71	9888.31	9902.02	46598.0
2020-04-28 16:00:00	NQ	Futures	9901.73	9966.57	9888.31	9938.87	16429.0
2020-04-28 18:00:00	NQ	Futures	10007.99	10028.27	9978.86	9994.57	5564.0
2020-04-28 19:00:00	NQ	Futures	9995.14	10026.56	9982.28	10017.13	2998.0
2020-04-28 20:00:00	NQ	Futures	10018.56	10047.98	10014.56	10039.7	4210.0
2020-04-28 21:00:00	NQ	Futures	10039.98	10122.82	10039.98	10088.83	7831.0
2020-04-28 22:00:00	NQ	Futures	10088.83	10104.25	10075.12	10100.54	3729.0
2020-04-28 23:00:00	NQ	Futures	10100.82	10101.68	10077.69	10097.97	2664.0
2020-04-28 00:00:00	YM	Futures	26213.1	26225.2	26154.0	26218.6	1714.0
2020-04-28 01:00:00	YM	Futures	26217.5	26308.4	26198.9	26274.5	2229.0
2020-04-28 02:00:00	YM	Futures	26274.5	26317.2	26239.4	26269.0	2093.0
2020-04-28 03:00:00	YM	Futures	26269.0	26457.4	26257.0	26435.5	5344.0

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

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