PREVIEW / futures_1hour / 2019-07-08

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-07-08.parquet
  size:    57 KB
  rows:    1,846

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-08 00:00:00	ES	Futures	3231.68	3232.22	3229.78	3230.59	5867.0
2019-07-08 01:00:00	ES	Futures	3230.59	3230.59	3225.45	3227.08	10815.0
2019-07-08 02:00:00	ES	Futures	3227.08	3231.14	3226.8	3229.51	13523.0
2019-07-08 03:00:00	ES	Futures	3229.51	3234.93	3229.24	3233.57	22065.0
2019-07-08 04:00:00	ES	Futures	3233.84	3236.28	3233.03	3233.57	14124.0
2019-07-08 05:00:00	ES	Futures	3233.57	3233.84	3229.51	3232.22	16380.0
2019-07-08 06:00:00	ES	Futures	3232.22	3233.03	3229.24	3229.78	10179.0
2019-07-08 07:00:00	ES	Futures	3230.05	3233.57	3229.51	3230.05	12650.0
2019-07-08 08:00:00	ES	Futures	3230.05	3231.95	3228.97	3229.24	18538.0
2019-07-08 09:00:00	ES	Futures	3228.97	3229.78	3221.93	3223.29	148321.0
2019-07-08 10:00:00	ES	Futures	3223.29	3231.95	3222.47	3224.64	161282.0
2019-07-08 11:00:00	ES	Futures	3224.91	3228.7	3222.74	3224.37	90658.0
2019-07-08 12:00:00	ES	Futures	3224.37	3224.91	3220.85	3223.56	65915.0
2019-07-08 13:00:00	ES	Futures	3223.56	3226.26	3222.2	3223.83	52517.0
2019-07-08 14:00:00	ES	Futures	3223.83	3225.72	3219.5	3223.56	75041.0
2019-07-08 15:00:00	ES	Futures	3223.29	3229.24	3222.47	3226.53	156552.0
2019-07-08 16:00:00	ES	Futures	3226.53	3228.16	3223.29	3225.18	48550.0
2019-07-08 18:00:00	ES	Futures	3224.37	3226.26	3223.01	3225.45	3393.0
2019-07-08 19:00:00	ES	Futures	3225.45	3225.99	3221.12	3222.2	4632.0
2019-07-08 20:00:00	ES	Futures	3222.2	3225.18	3221.66	3221.93	8119.0
2019-07-08 21:00:00	ES	Futures	3222.2	3223.01	3218.68	3221.39	12959.0
2019-07-08 22:00:00	ES	Futures	3221.39	3221.66	3217.6	3217.87	8238.0
2019-07-08 23:00:00	ES	Futures	3217.87	3218.14	3210.56	3212.19	20280.0
2019-07-08 00:00:00	NQ	Futures	9086.39	9088.71	9082.33	9085.23	2534.0
2019-07-08 01:00:00	NQ	Futures	9084.94	9085.23	9062.02	9068.4	4412.0
2019-07-08 02:00:00	NQ	Futures	9068.11	9081.17	9067.24	9071.3	4490.0
2019-07-08 03:00:00	NQ	Futures	9071.01	9095.39	9071.01	9089.87	7071.0
2019-07-08 04:00:00	NQ	Futures	9090.16	9103.51	9089.58	9091.03	5220.0
2019-07-08 05:00:00	NQ	Futures	9091.03	9092.19	9073.91	9080.01	5523.0
2019-07-08 06:00:00	NQ	Futures	9080.01	9082.04	9066.66	9068.4	3966.0
2019-07-08 07:00:00	NQ	Futures	9068.4	9082.62	9066.95	9073.91	4534.0
2019-07-08 08:00:00	NQ	Futures	9073.62	9082.62	9071.88	9071.88	5272.0
2019-07-08 09:00:00	NQ	Futures	9071.88	9078.27	9026.33	9028.94	58479.0
2019-07-08 10:00:00	NQ	Futures	9028.65	9057.09	9027.2	9049.83	56802.0
2019-07-08 11:00:00	NQ	Futures	9049.83	9063.47	9035.33	9042.87	39153.0
2019-07-08 12:00:00	NQ	Futures	9042.87	9051.28	9031.26	9050.12	26039.0
2019-07-08 13:00:00	NQ	Futures	9049.83	9056.8	9043.45	9049.54	22402.0
2019-07-08 14:00:00	NQ	Futures	9050.12	9063.18	9037.65	9057.96	25633.0
2019-07-08 15:00:00	NQ	Futures	9057.96	9071.59	9055.06	9064.92	40674.0
2019-07-08 16:00:00	NQ	Futures	9065.21	9066.95	9049.54	9054.18	8838.0
2019-07-08 18:00:00	NQ	Futures	9055.06	9057.96	9047.8	9055.93	1470.0
2019-07-08 19:00:00	NQ	Futures	9055.64	9059.12	9040.26	9044.61	1914.0
2019-07-08 20:00:00	NQ	Futures	9045.19	9054.77	9043.16	9045.48	3046.0
2019-07-08 21:00:00	NQ	Futures	9045.48	9048.09	9029.52	9039.68	4739.0
2019-07-08 22:00:00	NQ	Futures	9039.97	9040.84	9026.91	9029.81	2617.0
2019-07-08 23:00:00	NQ	Futures	9029.52	9029.52	8996.16	9001.96	8528.0
2019-07-08 00:00:00	YM	Futures	29177.6	29183.1	29159.1	29163.5	1260.0
2019-07-08 01:00:00	YM	Futures	29163.5	29163.5	29122.2	29137.4	2246.0
2019-07-08 02:00:00	YM	Futures	29137.4	29167.8	29135.2	29153.7	2841.0
2019-07-08 03:00:00	YM	Futures	29154.8	29204.8	29153.7	29191.8	4472.0

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

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