PREVIEW / futures_1hour / 2019-09-05

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-09-05.parquet
  size:    59 KB
  rows:    1,851

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-09-05 00:00:00	ES	Futures	3212.73	3213.81	3210.02	3213.81	7806.0
2019-09-05 01:00:00	ES	Futures	3213.81	3216.79	3210.56	3211.37	15729.0
2019-09-05 02:00:00	ES	Futures	3211.37	3211.64	3201.9	3203.52	31855.0
2019-09-05 03:00:00	ES	Futures	3203.52	3203.52	3194.86	3201.36	50762.0
2019-09-05 04:00:00	ES	Futures	3201.36	3206.77	3199.19	3206.5	32551.0
2019-09-05 05:00:00	ES	Futures	3206.23	3210.29	3203.79	3209.48	22169.0
2019-09-05 06:00:00	ES	Futures	3209.48	3212.73	3208.67	3210.83	17360.0
2019-09-05 07:00:00	ES	Futures	3211.1	3211.64	3206.23	3207.58	23805.0
2019-09-05 08:00:00	ES	Futures	3207.31	3213.81	3207.04	3212.46	30730.0
2019-09-05 09:00:00	ES	Futures	3212.46	3222.2	3209.75	3219.77	207265.0
2019-09-05 10:00:00	ES	Futures	3220.04	3233.84	3220.04	3225.18	321768.0
2019-09-05 11:00:00	ES	Futures	3225.45	3229.24	3221.93	3223.56	150092.0
2019-09-05 12:00:00	ES	Futures	3223.83	3226.53	3220.04	3223.29	105946.0
2019-09-05 13:00:00	ES	Futures	3223.29	3224.91	3218.41	3221.93	100539.0
2019-09-05 14:00:00	ES	Futures	3221.66	3224.91	3219.77	3224.37	83187.0
2019-09-05 15:00:00	ES	Futures	3224.64	3228.16	3221.12	3222.74	173096.0
2019-09-05 16:00:00	ES	Futures	3222.74	3222.74	3215.43	3215.98	66880.0
2019-09-05 18:00:00	ES	Futures	3216.79	3220.85	3216.25	3220.58	5421.0
2019-09-05 19:00:00	ES	Futures	3220.58	3224.64	3220.04	3223.56	5666.0
2019-09-05 20:00:00	ES	Futures	3223.56	3227.62	3222.47	3226.26	13413.0
2019-09-05 21:00:00	ES	Futures	3226.26	3228.97	3221.93	3227.08	14437.0
2019-09-05 22:00:00	ES	Futures	3227.35	3227.89	3224.37	3225.99	7680.0
2019-09-05 23:00:00	ES	Futures	3225.72	3227.62	3224.91	3225.18	6568.0
2019-09-05 00:00:00	NQ	Futures	9077.98	9078.56	9065.79	9077.4	4969.0
2019-09-05 01:00:00	NQ	Futures	9077.11	9088.71	9067.24	9067.82	7055.0
2019-09-05 02:00:00	NQ	Futures	9067.53	9071.01	9042.29	9047.8	13750.0
2019-09-05 03:00:00	NQ	Futures	9047.8	9050.41	9016.47	9039.68	17705.0
2019-09-05 04:00:00	NQ	Futures	9039.68	9060.57	9029.52	9059.41	16239.0
2019-09-05 05:00:00	NQ	Futures	9059.12	9072.75	9051.86	9070.72	9298.0
2019-09-05 06:00:00	NQ	Futures	9070.14	9076.24	9066.37	9072.46	5808.0
2019-09-05 07:00:00	NQ	Futures	9072.75	9073.04	9053.89	9056.51	7953.0
2019-09-05 08:00:00	NQ	Futures	9057.09	9075.95	9057.09	9069.56	10305.0
2019-09-05 09:00:00	NQ	Futures	9069.85	9108.44	9057.38	9102.35	61962.0
2019-09-05 10:00:00	NQ	Futures	9102.93	9153.12	9102.93	9123.24	81317.0
2019-09-05 11:00:00	NQ	Futures	9123.24	9135.71	9113.37	9114.24	38843.0
2019-09-05 12:00:00	NQ	Futures	9114.24	9126.43	9107.57	9114.82	29501.0
2019-09-05 13:00:00	NQ	Futures	9115.11	9119.76	9097.42	9112.21	24876.0
2019-09-05 14:00:00	NQ	Futures	9112.21	9127.59	9104.38	9124.98	24900.0
2019-09-05 15:00:00	NQ	Futures	9124.98	9136.59	9119.18	9128.46	38655.0
2019-09-05 16:00:00	NQ	Futures	9128.46	9128.75	9110.47	9110.76	11914.0
2019-09-05 18:00:00	NQ	Futures	9114.53	9126.43	9112.5	9124.98	2797.0
2019-09-05 19:00:00	NQ	Futures	9125.27	9139.49	9123.24	9137.17	3262.0
2019-09-05 20:00:00	NQ	Futures	9137.46	9150.8	9134.26	9143.26	6160.0
2019-09-05 21:00:00	NQ	Futures	9143.26	9150.51	9122.37	9138.91	8793.0
2019-09-05 22:00:00	NQ	Futures	9139.2	9140.65	9128.75	9133.97	4059.0
2019-09-05 23:00:00	NQ	Futures	9133.68	9140.36	9132.81	9134.26	2963.0
2019-09-05 00:00:00	YM	Futures	28976.4	28992.8	28954.7	28990.6	1850.0
2019-09-05 01:00:00	YM	Futures	28990.6	29014.5	28962.3	28966.7	2772.0
2019-09-05 02:00:00	YM	Futures	28965.6	28971.0	28882.9	28899.2	6205.0
2019-09-05 03:00:00	YM	Futures	28898.1	28903.6	28827.5	28884.0	9293.0

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

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