PREVIEW / futures_1hour / 2019-08-01

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-08-01.parquet
  size:    64 KB
  rows:    1,904

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-08-01 00:00:00	ES	Futures	3231.95	3232.22	3227.62	3227.89	6861.0
2019-08-01 01:00:00	ES	Futures	3227.89	3228.97	3225.45	3226.53	10366.0
2019-08-01 02:00:00	ES	Futures	3226.26	3228.97	3219.77	3220.31	20284.0
2019-08-01 03:00:00	ES	Futures	3220.58	3231.14	3219.5	3230.05	39201.0
2019-08-01 04:00:00	ES	Futures	3229.78	3231.68	3225.45	3229.78	25840.0
2019-08-01 05:00:00	ES	Futures	3229.78	3237.09	3229.24	3236.01	35981.0
2019-08-01 06:00:00	ES	Futures	3236.28	3237.09	3233.03	3233.03	21385.0
2019-08-01 07:00:00	ES	Futures	3233.3	3235.74	3230.05	3231.95	25505.0
2019-08-01 08:00:00	ES	Futures	3231.95	3232.76	3227.35	3230.05	37491.0
2019-08-01 09:00:00	ES	Futures	3229.78	3241.42	3224.37	3239.8	272689.0
2019-08-01 10:00:00	ES	Futures	3239.53	3257.66	3236.28	3256.85	302938.0
2019-08-01 11:00:00	ES	Futures	3256.85	3263.89	3254.15	3259.02	206756.0
2019-08-01 12:00:00	ES	Futures	3259.02	3261.18	3255.23	3258.48	98000.0
2019-08-01 13:00:00	ES	Futures	3258.75	3259.56	3201.63	3214.89	536606.0
2019-08-01 14:00:00	ES	Futures	3214.89	3216.52	3188.36	3201.9	432627.0
2019-08-01 15:00:00	ES	Futures	3201.9	3210.29	3192.97	3198.65	403754.0
2019-08-01 16:00:00	ES	Futures	3198.65	3207.04	3191.34	3192.97	102918.0
2019-08-01 18:00:00	ES	Futures	3194.59	3196.49	3185.66	3189.18	17906.0
2019-08-01 19:00:00	ES	Futures	3189.18	3192.15	3188.64	3189.72	9721.0
2019-08-01 20:00:00	ES	Futures	3189.72	3195.67	3182.14	3183.22	32302.0
2019-08-01 21:00:00	ES	Futures	3183.49	3193.51	3183.22	3191.88	24482.0
2019-08-01 22:00:00	ES	Futures	3191.88	3193.24	3183.76	3186.74	20649.0
2019-08-01 23:00:00	ES	Futures	3186.74	3189.72	3183.76	3188.36	11485.0
2019-08-01 00:00:00	NQ	Futures	9139.49	9140.07	9129.04	9129.91	2090.0
2019-08-01 01:00:00	NQ	Futures	9130.2	9133.97	9118.02	9120.92	3028.0
2019-08-01 02:00:00	NQ	Futures	9121.21	9129.04	9100.03	9101.48	6015.0
2019-08-01 03:00:00	NQ	Futures	9102.06	9138.04	9097.13	9132.81	11250.0
2019-08-01 04:00:00	NQ	Futures	9132.81	9138.62	9118.6	9130.49	9988.0
2019-08-01 05:00:00	NQ	Futures	9130.78	9161.25	9129.62	9158.64	11181.0
2019-08-01 06:00:00	NQ	Futures	9158.93	9162.99	9149.93	9150.22	6473.0
2019-08-01 07:00:00	NQ	Futures	9150.51	9158.35	9138.33	9143.26	8677.0
2019-08-01 08:00:00	NQ	Futures	9143.26	9147.03	9128.17	9141.23	11623.0
2019-08-01 09:00:00	NQ	Futures	9140.94	9208.54	9122.66	9202.45	82692.0
2019-08-01 10:00:00	NQ	Futures	9201.58	9281.37	9198.97	9278.76	101397.0
2019-08-01 11:00:00	NQ	Futures	9278.76	9301.39	9270.63	9280.79	69530.0
2019-08-01 12:00:00	NQ	Futures	9281.08	9291.81	9269.47	9279.34	28398.0
2019-08-01 13:00:00	NQ	Futures	9279.34	9283.98	9082.91	9131.36	148994.0
2019-08-01 14:00:00	NQ	Futures	9131.36	9139.2	9025.46	9075.95	120626.0
2019-08-01 15:00:00	NQ	Futures	9075.95	9107.57	9048.09	9068.11	87671.0
2019-08-01 16:00:00	NQ	Futures	9067.82	9092.77	9038.23	9042.0	18292.0
2019-08-01 18:00:00	NQ	Futures	9048.96	9059.41	9022.27	9035.04	8087.0
2019-08-01 19:00:00	NQ	Futures	9035.33	9045.19	9033.0	9035.62	4772.0
2019-08-01 20:00:00	NQ	Futures	9035.91	9058.25	9006.02	9010.95	12309.0
2019-08-01 21:00:00	NQ	Futures	9011.53	9046.93	9011.24	9039.39	13385.0
2019-08-01 22:00:00	NQ	Futures	9039.39	9044.32	9011.82	9024.59	6850.0
2019-08-01 23:00:00	NQ	Futures	9024.3	9034.17	9012.11	9027.78	3438.0
2019-08-01 00:00:00	YM	Futures	29230.9	29234.2	29195.0	29199.4	1643.0
2019-08-01 01:00:00	YM	Futures	29200.5	29211.3	29177.6	29185.2	1548.0
2019-08-01 02:00:00	YM	Futures	29185.2	29207.0	29130.9	29136.3	3469.0
2019-08-01 03:00:00	YM	Futures	29137.4	29226.6	29125.4	29215.7	6049.0

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

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