PREVIEW / futures_1hour / 2017-08-03

all futures 1-hour files

  file:    by_date/futures_1hour/2017/2017-08-03.parquet
  size:    52 KB
  rows:    1,610

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
2017-08-03 00:00:00	ES	Futures	2702.78	2702.78	2701.41	2701.69	1369.0
2017-08-03 01:00:00	ES	Futures	2701.96	2702.51	2701.41	2702.51	3345.0
2017-08-03 02:00:00	ES	Futures	2702.51	2703.05	2701.41	2701.41	7305.0
2017-08-03 03:00:00	ES	Futures	2701.41	2701.96	2698.13	2698.68	29826.0
2017-08-03 04:00:00	ES	Futures	2698.68	2701.96	2698.68	2701.96	20965.0
2017-08-03 05:00:00	ES	Futures	2701.69	2703.6	2701.14	2701.69	15946.0
2017-08-03 06:00:00	ES	Futures	2701.69	2704.42	2701.41	2703.6	12792.0
2017-08-03 07:00:00	ES	Futures	2703.87	2704.15	2701.41	2703.33	17384.0
2017-08-03 08:00:00	ES	Futures	2703.6	2705.51	2702.78	2704.97	14862.0
2017-08-03 09:00:00	ES	Futures	2705.24	2705.24	2699.22	2700.04	117718.0
2017-08-03 10:00:00	ES	Futures	2700.04	2703.6	2698.68	2702.78	179122.0
2017-08-03 11:00:00	ES	Futures	2702.78	2703.6	2699.22	2699.77	100354.0
2017-08-03 12:00:00	ES	Futures	2699.5	2701.69	2698.95	2700.59	78750.0
2017-08-03 13:00:00	ES	Futures	2700.59	2702.23	2697.86	2701.41	87414.0
2017-08-03 14:00:00	ES	Futures	2701.14	2702.23	2699.77	2700.04	56603.0
2017-08-03 15:00:00	ES	Futures	2700.32	2702.78	2696.22	2700.04	195772.0
2017-08-03 16:00:00	ES	Futures	2700.32	2703.87	2699.5	2701.41	112926.0
2017-08-03 18:00:00	ES	Futures	2701.41	2701.96	2700.32	2700.87	4782.0
2017-08-03 19:00:00	ES	Futures	2701.14	2701.14	2698.68	2699.5	3504.0
2017-08-03 20:00:00	ES	Futures	2699.22	2700.87	2698.13	2700.59	5368.0
2017-08-03 21:00:00	ES	Futures	2700.87	2701.14	2699.77	2700.59	3611.0
2017-08-03 22:00:00	ES	Futures	2700.59	2701.41	2700.32	2701.41	1764.0
2017-08-03 23:00:00	ES	Futures	2701.41	2701.41	2700.87	2701.14	2399.0
2017-08-03 00:00:00	NQ	Futures	7040.03	7040.63	7036.76	7038.84	489.0
2017-08-03 01:00:00	NQ	Futures	7038.54	7040.33	7034.97	7040.03	605.0
2017-08-03 02:00:00	NQ	Futures	7040.03	7042.11	7037.35	7037.35	1187.0
2017-08-03 03:00:00	NQ	Futures	7037.35	7037.65	7024.25	7026.63	3974.0
2017-08-03 04:00:00	NQ	Futures	7026.33	7037.35	7025.74	7036.46	2547.0
2017-08-03 05:00:00	NQ	Futures	7036.46	7044.2	7035.56	7039.14	2226.0
2017-08-03 06:00:00	NQ	Futures	7039.43	7050.75	7038.84	7045.39	6090.0
2017-08-03 07:00:00	NQ	Futures	7045.39	7048.67	7042.41	7047.77	5769.0
2017-08-03 08:00:00	NQ	Futures	7047.47	7056.11	7045.09	7052.83	3800.0
2017-08-03 09:00:00	NQ	Futures	7052.83	7054.32	7012.64	7019.49	49028.0
2017-08-03 10:00:00	NQ	Futures	7019.19	7031.99	6999.83	7029.61	63113.0
2017-08-03 11:00:00	NQ	Futures	7029.91	7036.76	7015.91	7017.1	29593.0
2017-08-03 12:00:00	NQ	Futures	7017.1	7029.91	7013.83	7023.36	20020.0
2017-08-03 13:00:00	NQ	Futures	7023.06	7023.65	7006.98	7021.27	21678.0
2017-08-03 14:00:00	NQ	Futures	7021.27	7026.93	7017.4	7021.57	16829.0
2017-08-03 15:00:00	NQ	Futures	7021.57	7028.72	7002.51	7014.42	45322.0
2017-08-03 16:00:00	NQ	Futures	7014.72	7019.19	7011.74	7013.23	7023.0
2017-08-03 18:00:00	NQ	Futures	7013.83	7016.81	7006.68	7011.74	1246.0
2017-08-03 19:00:00	NQ	Futures	7012.04	7012.04	7006.09	7009.36	703.0
2017-08-03 20:00:00	NQ	Futures	7009.36	7015.02	7004.3	7013.83	1088.0
2017-08-03 21:00:00	NQ	Futures	7013.83	7014.72	7009.66	7013.23	980.0
2017-08-03 22:00:00	NQ	Futures	7013.53	7017.1	7010.85	7015.91	600.0
2017-08-03 23:00:00	NQ	Futures	7015.61	7015.91	7012.94	7013.83	367.0
2017-08-03 00:00:00	YM	Futures	23885.6	23887.8	23881.3	23885.6	214.0
2017-08-03 01:00:00	YM	Futures	23884.6	23890.0	23882.4	23890.0	445.0
2017-08-03 02:00:00	YM	Futures	23888.9	23893.3	23885.6	23885.6	1261.0
2017-08-03 03:00:00	YM	Futures	23886.7	23891.1	23868.2	23872.6	2884.0

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

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