PREVIEW / futures_1hour / 2019-07-01

all futures 1-hour files

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

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-01 00:00:00	ES	Futures	3215.71	3218.14	3215.16	3217.6	7192.0
2019-07-01 01:00:00	ES	Futures	3217.6	3224.91	3217.06	3224.37	16496.0
2019-07-01 02:00:00	ES	Futures	3224.37	3225.45	3221.93	3224.1	14346.0
2019-07-01 03:00:00	ES	Futures	3223.83	3227.35	3222.74	3223.01	31546.0
2019-07-01 04:00:00	ES	Futures	3223.29	3224.37	3221.93	3222.2	21878.0
2019-07-01 05:00:00	ES	Futures	3221.93	3223.83	3219.77	3222.47	15749.0
2019-07-01 06:00:00	ES	Futures	3222.47	3226.26	3222.2	3223.56	12647.0
2019-07-01 07:00:00	ES	Futures	3223.56	3224.91	3221.66	3223.83	15114.0
2019-07-01 08:00:00	ES	Futures	3224.1	3226.8	3223.29	3224.1	27550.0
2019-07-01 09:00:00	ES	Futures	3223.83	3228.7	3218.95	3220.58	212203.0
2019-07-01 10:00:00	ES	Futures	3220.85	3224.64	3213.0	3215.98	206506.0
2019-07-01 11:00:00	ES	Futures	3215.98	3218.14	3210.83	3212.46	127136.0
2019-07-01 12:00:00	ES	Futures	3212.73	3214.35	3203.79	3204.61	99404.0
2019-07-01 13:00:00	ES	Futures	3204.61	3207.86	3202.17	3206.5	116570.0
2019-07-01 14:00:00	ES	Futures	3206.23	3206.77	3200.28	3200.82	84800.0
2019-07-01 15:00:00	ES	Futures	3201.09	3215.98	3200.55	3214.08	231388.0
2019-07-01 16:00:00	ES	Futures	3214.08	3214.89	3211.64	3213.81	61805.0
2019-07-01 18:00:00	ES	Futures	3213.81	3214.89	3204.88	3208.94	11816.0
2019-07-01 19:00:00	ES	Futures	3209.21	3209.75	3207.31	3209.48	4673.0
2019-07-01 20:00:00	ES	Futures	3209.21	3214.08	3209.21	3213.27	10932.0
2019-07-01 21:00:00	ES	Futures	3213.27	3216.79	3212.19	3215.71	10030.0
2019-07-01 22:00:00	ES	Futures	3215.98	3216.52	3213.54	3215.71	5661.0
2019-07-01 23:00:00	ES	Futures	3215.43	3217.06	3214.08	3216.79	3605.0
2019-07-01 00:00:00	NQ	Futures	9045.48	9053.6	9043.74	9049.25	2872.0
2019-07-01 01:00:00	NQ	Futures	9049.25	9080.01	9047.51	9077.98	6732.0
2019-07-01 02:00:00	NQ	Futures	9077.98	9084.94	9068.98	9078.27	5837.0
2019-07-01 03:00:00	NQ	Futures	9078.27	9090.16	9074.79	9077.11	7431.0
2019-07-01 04:00:00	NQ	Futures	9077.4	9084.94	9073.33	9078.56	5183.0
2019-07-01 05:00:00	NQ	Futures	9078.56	9085.52	9072.17	9082.62	4067.0
2019-07-01 06:00:00	NQ	Futures	9082.33	9092.77	9080.3	9085.52	3874.0
2019-07-01 07:00:00	NQ	Futures	9085.52	9091.32	9078.85	9088.13	4114.0
2019-07-01 08:00:00	NQ	Futures	9088.13	9099.74	9086.1	9088.13	8379.0
2019-07-01 09:00:00	NQ	Futures	9088.13	9110.18	9072.75	9080.01	63290.0
2019-07-01 10:00:00	NQ	Futures	9081.17	9102.35	9045.19	9059.12	66386.0
2019-07-01 11:00:00	NQ	Futures	9059.41	9065.79	9044.61	9051.86	36523.0
2019-07-01 12:00:00	NQ	Futures	9052.15	9057.96	9012.11	9015.31	33931.0
2019-07-01 13:00:00	NQ	Futures	9015.6	9030.97	9012.4	9028.94	30436.0
2019-07-01 14:00:00	NQ	Futures	9028.94	9030.1	9004.86	9009.5	26934.0
2019-07-01 15:00:00	NQ	Futures	9009.21	9051.57	9007.47	9044.61	49863.0
2019-07-01 16:00:00	NQ	Futures	9044.32	9048.67	9037.36	9043.45	9478.0
2019-07-01 18:00:00	NQ	Futures	9043.74	9046.35	9013.56	9025.75	3726.0
2019-07-01 19:00:00	NQ	Futures	9025.75	9029.23	9019.66	9026.33	2150.0
2019-07-01 20:00:00	NQ	Futures	9026.33	9039.97	9024.3	9032.13	5022.0
2019-07-01 21:00:00	NQ	Futures	9032.42	9046.06	9028.36	9042.29	5005.0
2019-07-01 22:00:00	NQ	Futures	9042.58	9045.19	9034.46	9041.13	3756.0
2019-07-01 23:00:00	NQ	Futures	9040.84	9047.22	9035.62	9046.35	1437.0
2019-07-01 00:00:00	YM	Futures	29153.7	29171.1	29147.2	29165.7	1847.0
2019-07-01 01:00:00	YM	Futures	29165.7	29219.0	29162.4	29212.4	3918.0
2019-07-01 02:00:00	YM	Futures	29213.5	29230.9	29196.1	29219.0	3578.0
2019-07-01 03:00:00	YM	Futures	29219.0	29249.4	29210.3	29214.6	5731.0

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

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