PREVIEW / futures_1hour / 2019-07-25

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-07-25.parquet
  size:    60 KB
  rows:    1,862

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-07-25 00:00:00	ES	Futures	3272.55	3273.37	3272.01	3272.82	2823.0
2019-07-25 01:00:00	ES	Futures	3273.09	3274.99	3272.55	3273.64	6558.0
2019-07-25 02:00:00	ES	Futures	3273.91	3275.26	3273.09	3274.72	8738.0
2019-07-25 03:00:00	ES	Futures	3274.45	3274.72	3270.93	3272.55	17861.0
2019-07-25 04:00:00	ES	Futures	3272.55	3273.91	3271.74	3273.91	13315.0
2019-07-25 05:00:00	ES	Futures	3273.91	3273.91	3271.74	3273.37	11257.0
2019-07-25 06:00:00	ES	Futures	3273.09	3273.37	3269.03	3270.66	13899.0
2019-07-25 07:00:00	ES	Futures	3270.39	3277.97	3269.58	3277.97	37725.0
2019-07-25 08:00:00	ES	Futures	3277.7	3278.51	3272.28	3273.91	43961.0
2019-07-25 09:00:00	ES	Futures	3273.91	3273.91	3253.06	3256.31	249006.0
2019-07-25 10:00:00	ES	Futures	3256.31	3265.79	3255.23	3263.08	182367.0
2019-07-25 11:00:00	ES	Futures	3262.81	3265.79	3253.87	3256.31	111632.0
2019-07-25 12:00:00	ES	Futures	3256.31	3257.12	3246.3	3251.44	148874.0
2019-07-25 13:00:00	ES	Futures	3251.17	3257.94	3247.65	3252.25	96329.0
2019-07-25 14:00:00	ES	Futures	3252.25	3259.56	3250.63	3252.79	89206.0
2019-07-25 15:00:00	ES	Futures	3252.52	3257.66	3249.0	3255.77	169964.0
2019-07-25 16:00:00	ES	Futures	3255.5	3258.48	3251.71	3253.87	78871.0
2019-07-25 18:00:00	ES	Futures	3255.5	3257.94	3254.96	3256.31	5580.0
2019-07-25 19:00:00	ES	Futures	3256.31	3258.21	3256.04	3257.94	2558.0
2019-07-25 20:00:00	ES	Futures	3258.21	3260.1	3256.85	3259.02	7077.0
2019-07-25 21:00:00	ES	Futures	3259.02	3263.62	3258.21	3261.73	10987.0
2019-07-25 22:00:00	ES	Futures	3261.73	3263.35	3261.18	3262.81	5676.0
2019-07-25 23:00:00	ES	Futures	3262.81	3263.62	3262.0	3263.08	3894.0
2019-07-25 00:00:00	NQ	Futures	9304.58	9309.8	9302.26	9307.19	1208.0
2019-07-25 01:00:00	NQ	Futures	9307.19	9313.28	9305.74	9308.93	1855.0
2019-07-25 02:00:00	NQ	Futures	9309.51	9314.73	9308.06	9312.41	2120.0
2019-07-25 03:00:00	NQ	Futures	9312.12	9312.7	9295.87	9304.58	5434.0
2019-07-25 04:00:00	NQ	Futures	9304.58	9313.57	9301.97	9312.12	4430.0
2019-07-25 05:00:00	NQ	Futures	9312.7	9312.99	9304.29	9309.8	2900.0
2019-07-25 06:00:00	NQ	Futures	9309.22	9310.38	9292.97	9297.9	4626.0
2019-07-25 07:00:00	NQ	Futures	9297.9	9321.7	9294.42	9320.83	10280.0
2019-07-25 08:00:00	NQ	Futures	9320.54	9324.6	9297.9	9304.87	15079.0
2019-07-25 09:00:00	NQ	Futures	9304.29	9305.16	9221.02	9241.33	89130.0
2019-07-25 10:00:00	NQ	Futures	9241.04	9267.73	9219.86	9256.41	68552.0
2019-07-25 11:00:00	NQ	Futures	9256.12	9265.7	9230.88	9241.33	40997.0
2019-07-25 12:00:00	NQ	Futures	9241.62	9245.1	9205.93	9218.99	42926.0
2019-07-25 13:00:00	NQ	Futures	9218.99	9235.52	9208.54	9215.5	29972.0
2019-07-25 14:00:00	NQ	Futures	9215.79	9242.2	9215.5	9223.34	27964.0
2019-07-25 15:00:00	NQ	Futures	9223.34	9236.97	9211.44	9222.76	44894.0
2019-07-25 16:00:00	NQ	Futures	9222.47	9276.14	9188.52	9263.67	27228.0
2019-07-25 18:00:00	NQ	Futures	9275.27	9282.82	9271.21	9272.37	3977.0
2019-07-25 19:00:00	NQ	Futures	9272.66	9277.3	9270.05	9276.14	1394.0
2019-07-25 20:00:00	NQ	Futures	9276.72	9284.56	9273.53	9280.79	3112.0
2019-07-25 21:00:00	NQ	Futures	9280.79	9301.1	9280.79	9296.45	5475.0
2019-07-25 22:00:00	NQ	Futures	9296.45	9306.32	9294.71	9304.58	3505.0
2019-07-25 23:00:00	NQ	Futures	9304.87	9305.45	9299.94	9304.29	2211.0
2019-07-25 00:00:00	YM	Futures	29670.3	29674.6	29667.0	29670.3	465.0
2019-07-25 01:00:00	YM	Futures	29671.4	29685.5	29668.1	29672.4	1616.0
2019-07-25 02:00:00	YM	Futures	29672.4	29693.1	29668.1	29686.6	1978.0
2019-07-25 03:00:00	YM	Futures	29686.6	29686.6	29658.3	29667.0	3412.0

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

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