PREVIEW / futures_1hour / 2018-06-22

all futures 1-hour files

  file:    by_date/futures_1hour/2018/2018-06-22.parquet
  size:    46 KB
  rows:    1,372

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
2018-06-22 00:00:00	ES	Futures	3005.3	3006.67	3005.03	3006.39	3172.0
2018-06-22 01:00:00	ES	Futures	3006.67	3008.85	3005.3	3006.67	5378.0
2018-06-22 02:00:00	ES	Futures	3006.67	3009.66	3005.3	3009.66	9725.0
2018-06-22 03:00:00	ES	Futures	3009.66	3013.48	3008.57	3010.75	19053.0
2018-06-22 04:00:00	ES	Futures	3010.75	3014.84	3009.12	3013.2	16066.0
2018-06-22 05:00:00	ES	Futures	3013.48	3015.11	3012.66	3012.93	12354.0
2018-06-22 06:00:00	ES	Futures	3012.66	3014.29	3011.57	3013.75	7938.0
2018-06-22 07:00:00	ES	Futures	3013.48	3015.11	3011.57	3015.11	11158.0
2018-06-22 08:00:00	ES	Futures	3014.84	3017.02	3014.29	3015.11	21070.0
2018-06-22 09:00:00	ES	Futures	3015.11	3017.29	3008.57	3010.75	129678.0
2018-06-22 10:00:00	ES	Futures	3010.48	3015.11	3004.76	3010.75	215153.0
2018-06-22 11:00:00	ES	Futures	3010.75	3014.02	3007.48	3012.11	82980.0
2018-06-22 12:00:00	ES	Futures	3011.84	3015.38	3010.75	3012.11	53096.0
2018-06-22 13:00:00	ES	Futures	3012.39	3015.66	3012.11	3014.57	48091.0
2018-06-22 14:00:00	ES	Futures	3014.57	3015.93	3010.21	3014.02	70487.0
2018-06-22 15:00:00	ES	Futures	3014.02	3014.29	3002.85	3005.58	235075.0
2018-06-22 16:00:00	ES	Futures	3005.58	3009.94	3004.21	3004.21	96792.0
2018-06-22 00:00:00	NQ	Futures	8525.47	8529.0	8523.99	8527.82	1236.0
2018-06-22 01:00:00	NQ	Futures	8527.53	8533.71	8522.82	8527.82	2575.0
2018-06-22 02:00:00	NQ	Futures	8527.53	8541.07	8524.29	8539.89	3567.0
2018-06-22 03:00:00	NQ	Futures	8539.6	8552.55	8536.07	8546.08	6206.0
2018-06-22 04:00:00	NQ	Futures	8546.08	8557.56	8541.36	8554.02	4827.0
2018-06-22 05:00:00	NQ	Futures	8554.02	8561.68	8551.08	8552.85	3670.0
2018-06-22 06:00:00	NQ	Futures	8552.55	8557.85	8549.02	8554.91	2426.0
2018-06-22 07:00:00	NQ	Futures	8554.61	8558.15	8546.37	8556.67	3485.0
2018-06-22 08:00:00	NQ	Futures	8556.97	8566.39	8554.91	8558.15	6328.0
2018-06-22 09:00:00	NQ	Futures	8558.44	8560.8	8496.61	8503.39	63181.0
2018-06-22 10:00:00	NQ	Futures	8503.09	8522.52	8477.18	8503.39	75855.0
2018-06-22 11:00:00	NQ	Futures	8503.68	8521.34	8495.14	8513.4	33893.0
2018-06-22 12:00:00	NQ	Futures	8513.4	8527.82	8510.45	8521.64	18848.0
2018-06-22 13:00:00	NQ	Futures	8522.52	8537.83	8521.05	8533.42	18087.0
2018-06-22 14:00:00	NQ	Futures	8533.42	8536.07	8515.46	8529.59	18750.0
2018-06-22 15:00:00	NQ	Futures	8529.88	8531.35	8493.67	8500.15	32268.0
2018-06-22 16:00:00	NQ	Futures	8499.85	8513.4	8498.67	8501.62	11167.0
2018-06-22 00:00:00	YM	Futures	26650.1	26661.0	26644.7	26658.8	1137.0
2018-06-22 01:00:00	YM	Futures	26658.8	26689.3	26654.5	26666.4	1879.0
2018-06-22 02:00:00	YM	Futures	26666.4	26683.8	26644.7	26680.6	2829.0
2018-06-22 03:00:00	YM	Futures	26679.5	26721.9	26670.8	26695.8	4135.0
2018-06-22 04:00:00	YM	Futures	26696.9	26731.7	26684.9	26720.8	3034.0
2018-06-22 05:00:00	YM	Futures	26719.7	26737.1	26712.1	26715.4	2232.0
2018-06-22 06:00:00	YM	Futures	26715.4	26730.6	26695.8	26725.1	2406.0
2018-06-22 07:00:00	YM	Futures	26726.2	26732.8	26711.0	26729.5	2019.0
2018-06-22 08:00:00	YM	Futures	26729.5	26754.5	26724.1	26741.5	3815.0
2018-06-22 09:00:00	YM	Futures	26742.5	26794.7	26701.2	26775.2	25988.0
2018-06-22 10:00:00	YM	Futures	26775.2	26800.2	26698.0	26744.7	32543.0
2018-06-22 11:00:00	YM	Futures	26745.8	26783.9	26714.3	26773.0	13892.0
2018-06-22 12:00:00	YM	Futures	26773.0	26811.0	26763.2	26775.2	10767.0
2018-06-22 13:00:00	YM	Futures	26775.2	26807.8	26766.5	26803.4	8367.0
2018-06-22 14:00:00	YM	Futures	26803.4	26813.2	26761.0	26794.7	9268.0
2018-06-22 15:00:00	YM	Futures	26794.7	26808.9	26701.2	26721.9	15969.0

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

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