PREVIEW / futures_1hour / 2019-05-01

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-05-01.parquet
  size:    49 KB
  rows:    1,473

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-05-01 00:00:00	ES	Futures	3209.31	3209.58	3208.77	3209.04	1591.0
2019-05-01 01:00:00	ES	Futures	3208.77	3209.58	3208.5	3209.31	1455.0
2019-05-01 02:00:00	ES	Futures	3209.31	3209.85	3208.5	3208.77	2312.0
2019-05-01 03:00:00	ES	Futures	3208.77	3209.85	3207.95	3209.85	7126.0
2019-05-01 04:00:00	ES	Futures	3209.85	3210.39	3208.5	3208.77	5168.0
2019-05-01 05:00:00	ES	Futures	3209.04	3209.31	3207.41	3207.68	5129.0
2019-05-01 06:00:00	ES	Futures	3207.68	3207.68	3205.24	3205.78	7144.0
2019-05-01 07:00:00	ES	Futures	3205.51	3207.68	3204.43	3206.87	8355.0
2019-05-01 08:00:00	ES	Futures	3206.87	3208.77	3204.7	3205.78	21881.0
2019-05-01 09:00:00	ES	Futures	3205.78	3205.78	3198.74	3200.36	120254.0
2019-05-01 10:00:00	ES	Futures	3200.36	3202.26	3195.75	3199.01	140322.0
2019-05-01 11:00:00	ES	Futures	3199.01	3205.51	3197.65	3202.53	105781.0
2019-05-01 12:00:00	ES	Futures	3202.8	3203.07	3191.96	3196.02	144119.0
2019-05-01 13:00:00	ES	Futures	3196.02	3200.36	3193.86	3199.01	113158.0
2019-05-01 14:00:00	ES	Futures	3199.01	3205.51	3187.35	3193.31	271347.0
2019-05-01 15:00:00	ES	Futures	3193.04	3195.21	3171.35	3171.63	350073.0
2019-05-01 16:00:00	ES	Futures	3171.63	3172.17	3162.14	3163.22	112351.0
2019-05-01 18:00:00	ES	Futures	3162.68	3166.75	3161.59	3166.2	12890.0
2019-05-01 19:00:00	ES	Futures	3166.2	3168.91	3165.93	3167.56	5557.0
2019-05-01 20:00:00	ES	Futures	3167.29	3171.08	3167.02	3171.08	9152.0
2019-05-01 21:00:00	ES	Futures	3170.81	3173.52	3170.0	3171.9	12456.0
2019-05-01 22:00:00	ES	Futures	3171.63	3172.71	3170.0	3171.63	6984.0
2019-05-01 23:00:00	ES	Futures	3171.35	3173.79	3170.81	3172.98	6238.0
2019-05-01 00:00:00	NQ	Futures	9151.33	9151.33	9149.0	9150.16	802.0
2019-05-01 01:00:00	NQ	Futures	9150.45	9152.49	9147.54	9150.16	837.0
2019-05-01 02:00:00	NQ	Futures	9150.16	9151.62	9146.38	9147.25	1137.0
2019-05-01 03:00:00	NQ	Futures	9146.67	9151.62	9140.26	9151.03	3222.0
2019-05-01 04:00:00	NQ	Futures	9150.74	9156.86	9150.45	9152.78	2547.0
2019-05-01 05:00:00	NQ	Futures	9152.78	9153.07	9148.71	9149.29	1598.0
2019-05-01 06:00:00	NQ	Futures	9149.29	9149.87	9142.59	9143.17	1986.0
2019-05-01 07:00:00	NQ	Futures	9143.46	9148.71	9139.1	9142.59	3235.0
2019-05-01 08:00:00	NQ	Futures	9142.3	9151.62	9138.22	9140.55	9206.0
2019-05-01 09:00:00	NQ	Futures	9140.84	9142.59	9120.46	9129.78	52601.0
2019-05-01 10:00:00	NQ	Futures	9129.78	9148.12	9112.89	9133.57	65079.0
2019-05-01 11:00:00	NQ	Futures	9133.57	9161.23	9129.49	9150.74	48179.0
2019-05-01 12:00:00	NQ	Futures	9150.45	9153.07	9114.64	9124.54	45769.0
2019-05-01 13:00:00	NQ	Futures	9124.54	9139.68	9120.75	9137.35	35932.0
2019-05-01 14:00:00	NQ	Futures	9137.06	9162.39	9101.54	9119.59	78203.0
2019-05-01 15:00:00	NQ	Futures	9119.59	9123.37	9040.69	9043.31	89361.0
2019-05-01 16:00:00	NQ	Futures	9043.6	9045.35	9009.53	9012.44	23554.0
2019-05-01 18:00:00	NQ	Futures	9011.57	9022.05	9004.87	9019.72	3967.0
2019-05-01 19:00:00	NQ	Futures	9019.72	9029.62	9019.43	9025.26	2302.0
2019-05-01 20:00:00	NQ	Futures	9024.96	9038.36	9024.67	9037.48	3949.0
2019-05-01 21:00:00	NQ	Futures	9037.77	9046.51	9035.74	9043.02	5771.0
2019-05-01 22:00:00	NQ	Futures	9042.72	9045.64	9036.61	9043.02	2979.0
2019-05-01 23:00:00	NQ	Futures	9043.02	9049.13	9040.98	9046.51	2544.0
2019-05-01 00:00:00	YM	Futures	29012.4	29015.7	29004.8	29012.4	506.0
2019-05-01 01:00:00	YM	Futures	29013.5	29017.9	29005.9	29014.6	427.0
2019-05-01 02:00:00	YM	Futures	29014.6	29025.5	29008.1	29012.4	1048.0
2019-05-01 03:00:00	YM	Futures	29010.3	29023.3	29004.8	29023.3	932.0

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

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