PREVIEW / futures_1hour / 2019-07-10

all futures 1-hour files

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

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-10 00:00:00	ES	Futures	3229.24	3229.51	3227.35	3227.62	2986.0
2019-07-10 01:00:00	ES	Futures	3227.62	3228.97	3226.53	3227.08	5583.0
2019-07-10 02:00:00	ES	Futures	3227.08	3227.08	3220.85	3222.2	13208.0
2019-07-10 03:00:00	ES	Futures	3221.93	3224.37	3220.31	3224.1	22008.0
2019-07-10 04:00:00	ES	Futures	3224.1	3226.53	3222.74	3224.37	16203.0
2019-07-10 05:00:00	ES	Futures	3224.1	3226.53	3220.04	3221.93	18143.0
2019-07-10 06:00:00	ES	Futures	3221.66	3221.66	3217.33	3220.58	19643.0
2019-07-10 07:00:00	ES	Futures	3220.85	3223.01	3220.85	3221.66	15999.0
2019-07-10 08:00:00	ES	Futures	3221.66	3244.4	3221.12	3242.51	100462.0
2019-07-10 09:00:00	ES	Futures	3242.51	3256.58	3240.88	3253.87	250519.0
2019-07-10 10:00:00	ES	Futures	3253.87	3254.69	3241.69	3241.96	239838.0
2019-07-10 11:00:00	ES	Futures	3242.23	3246.02	3236.01	3245.21	200793.0
2019-07-10 12:00:00	ES	Futures	3245.48	3246.84	3241.69	3246.84	87220.0
2019-07-10 13:00:00	ES	Futures	3246.84	3250.36	3246.02	3248.73	55089.0
2019-07-10 14:00:00	ES	Futures	3248.73	3252.52	3241.69	3244.4	101637.0
2019-07-10 15:00:00	ES	Futures	3244.4	3246.84	3241.42	3244.94	149660.0
2019-07-10 16:00:00	ES	Futures	3245.21	3246.57	3244.13	3244.4	46491.0
2019-07-10 18:00:00	ES	Futures	3244.13	3248.46	3243.32	3246.84	4874.0
2019-07-10 19:00:00	ES	Futures	3247.11	3247.38	3244.67	3245.75	2970.0
2019-07-10 20:00:00	ES	Futures	3245.75	3249.54	3244.67	3247.92	10360.0
2019-07-10 21:00:00	ES	Futures	3247.92	3251.98	3247.11	3251.98	11013.0
2019-07-10 22:00:00	ES	Futures	3251.98	3253.6	3250.9	3252.79	8690.0
2019-07-10 23:00:00	ES	Futures	3252.79	3255.77	3251.98	3254.42	9370.0
2019-07-10 00:00:00	NQ	Futures	9110.76	9111.05	9103.22	9104.09	1787.0
2019-07-10 01:00:00	NQ	Futures	9104.38	9111.63	9101.19	9103.51	2393.0
2019-07-10 02:00:00	NQ	Futures	9103.22	9103.22	9077.4	9082.62	6413.0
2019-07-10 03:00:00	NQ	Futures	9082.62	9091.61	9075.66	9089.29	6684.0
2019-07-10 04:00:00	NQ	Futures	9089.29	9099.16	9083.49	9091.61	5815.0
2019-07-10 05:00:00	NQ	Futures	9091.32	9098.87	9073.04	9080.3	6214.0
2019-07-10 06:00:00	NQ	Futures	9080.01	9080.01	9065.5	9078.56	5110.0
2019-07-10 07:00:00	NQ	Futures	9078.56	9091.03	9078.56	9085.81	5411.0
2019-07-10 08:00:00	NQ	Futures	9085.52	9182.14	9083.78	9171.11	32388.0
2019-07-10 09:00:00	NQ	Futures	9171.11	9225.95	9153.99	9220.44	85631.0
2019-07-10 10:00:00	NQ	Futures	9220.15	9225.37	9166.18	9168.5	72365.0
2019-07-10 11:00:00	NQ	Futures	9168.5	9192.58	9147.32	9189.39	58011.0
2019-07-10 12:00:00	NQ	Futures	9189.39	9196.06	9177.21	9189.97	26894.0
2019-07-10 13:00:00	NQ	Futures	9189.97	9209.12	9187.65	9202.45	21633.0
2019-07-10 14:00:00	NQ	Futures	9201.87	9212.02	9172.56	9186.2	34813.0
2019-07-10 15:00:00	NQ	Futures	9186.2	9206.8	9179.24	9200.13	40803.0
2019-07-10 16:00:00	NQ	Futures	9200.71	9204.77	9197.23	9197.52	7240.0
2019-07-10 18:00:00	NQ	Futures	9196.64	9208.54	9191.71	9205.64	1963.0
2019-07-10 19:00:00	NQ	Futures	9205.35	9206.8	9197.52	9200.71	1616.0
2019-07-10 20:00:00	NQ	Futures	9200.71	9216.66	9196.64	9210.28	4103.0
2019-07-10 21:00:00	NQ	Futures	9210.28	9224.79	9206.8	9223.92	4765.0
2019-07-10 22:00:00	NQ	Futures	9223.92	9233.78	9221.89	9228.27	4838.0
2019-07-10 23:00:00	NQ	Futures	9227.98	9236.97	9223.63	9233.78	2979.0
2019-07-10 00:00:00	YM	Futures	29115.6	29122.2	29102.6	29105.9	982.0
2019-07-10 01:00:00	YM	Futures	29106.9	29116.7	29097.2	29100.4	1188.0
2019-07-10 02:00:00	YM	Futures	29100.4	29100.4	29043.9	29055.8	3395.0
2019-07-10 03:00:00	YM	Futures	29054.7	29080.8	29038.4	29076.5	5672.0

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

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