PREVIEW / futures_1hour / 2019-03-13

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-03-13.parquet
  size:    55 KB
  rows:    1,729

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-03-13 00:00:00	ES	Futures	3026.81	3028.17	3026.54	3027.35	838.0
2019-03-13 01:00:00	ES	Futures	3027.35	3031.97	3026.81	3031.7	2402.0
2019-03-13 02:00:00	ES	Futures	3031.7	3031.97	3028.44	3028.98	1774.0
2019-03-13 03:00:00	ES	Futures	3028.71	3030.34	3026.27	3030.34	2606.0
2019-03-13 04:00:00	ES	Futures	3030.07	3035.77	3030.07	3035.77	5410.0
2019-03-13 05:00:00	ES	Futures	3035.77	3036.86	3033.6	3034.69	4449.0
2019-03-13 06:00:00	ES	Futures	3034.69	3038.49	3034.41	3038.22	3909.0
2019-03-13 07:00:00	ES	Futures	3038.22	3040.12	3037.4	3040.12	3445.0
2019-03-13 08:00:00	ES	Futures	3040.12	3042.83	3038.76	3039.3	8177.0
2019-03-13 09:00:00	ES	Futures	3039.57	3049.08	3039.03	3047.99	21861.0
2019-03-13 10:00:00	ES	Futures	3047.99	3054.78	3047.72	3053.7	31835.0
2019-03-13 11:00:00	ES	Futures	3053.43	3061.84	3053.43	3058.86	25724.0
2019-03-13 12:00:00	ES	Futures	3058.86	3061.03	3055.33	3059.13	18046.0
2019-03-13 13:00:00	ES	Futures	3058.86	3061.03	3057.77	3061.03	9944.0
2019-03-13 14:00:00	ES	Futures	3061.03	3064.83	3051.25	3056.68	32638.0
2019-03-13 15:00:00	ES	Futures	3056.68	3058.04	3051.25	3053.7	38240.0
2019-03-13 16:00:00	ES	Futures	3053.7	3059.4	3053.15	3058.59	11073.0
2019-03-13 18:00:00	ES	Futures	3059.13	3061.84	3057.5	3060.76	1165.0
2019-03-13 19:00:00	ES	Futures	3061.03	3061.03	3056.41	3057.77	1425.0
2019-03-13 20:00:00	ES	Futures	3057.77	3059.67	3053.7	3053.97	2397.0
2019-03-13 21:00:00	ES	Futures	3053.97	3055.87	3052.07	3055.6	3358.0
2019-03-13 22:00:00	ES	Futures	3055.6	3056.41	3053.97	3055.33	2365.0
2019-03-13 23:00:00	ES	Futures	3055.33	3056.14	3051.52	3053.15	1799.0
2019-03-13 00:00:00	NQ	Futures	8407.16	8413.88	8406.87	8410.09	300.0
2019-03-13 01:00:00	NQ	Futures	8409.79	8422.07	8406.87	8420.9	837.0
2019-03-13 02:00:00	NQ	Futures	8421.19	8422.07	8411.25	8411.84	486.0
2019-03-13 03:00:00	NQ	Futures	8411.55	8420.6	8405.7	8418.85	920.0
2019-03-13 04:00:00	NQ	Futures	8419.44	8435.8	8418.56	8434.34	966.0
2019-03-13 05:00:00	NQ	Futures	8434.34	8438.43	8427.62	8429.37	680.0
2019-03-13 06:00:00	NQ	Futures	8430.25	8437.55	8429.37	8437.26	547.0
2019-03-13 07:00:00	NQ	Futures	8436.97	8452.45	8434.63	8452.45	1302.0
2019-03-13 08:00:00	NQ	Futures	8452.45	8464.14	8445.44	8446.61	1657.0
2019-03-13 09:00:00	NQ	Futures	8446.61	8481.67	8445.44	8470.86	11765.0
2019-03-13 10:00:00	NQ	Futures	8470.57	8489.85	8458.88	8486.93	11746.0
2019-03-13 11:00:00	NQ	Futures	8487.22	8514.98	8486.64	8503.59	11839.0
2019-03-13 12:00:00	NQ	Futures	8503.59	8510.89	8494.53	8501.83	7005.0
2019-03-13 13:00:00	NQ	Futures	8502.42	8515.86	8498.03	8515.86	3401.0
2019-03-13 14:00:00	NQ	Futures	8516.15	8526.67	8485.76	8502.71	10030.0
2019-03-13 15:00:00	NQ	Futures	8502.71	8506.22	8476.7	8482.26	11989.0
2019-03-13 16:00:00	NQ	Futures	8482.26	8501.54	8479.04	8498.03	2183.0
2019-03-13 18:00:00	NQ	Futures	8500.66	8513.23	8493.07	8508.26	730.0
2019-03-13 19:00:00	NQ	Futures	8508.55	8509.14	8492.19	8497.45	853.0
2019-03-13 20:00:00	NQ	Futures	8497.74	8506.51	8480.8	8482.55	1087.0
2019-03-13 21:00:00	NQ	Futures	8481.09	8491.31	8476.41	8491.31	942.0
2019-03-13 22:00:00	NQ	Futures	8491.31	8495.11	8484.01	8487.52	417.0
2019-03-13 23:00:00	NQ	Futures	8488.68	8491.61	8477.0	8480.21	276.0
2019-03-13 00:00:00	YM	Futures	27759.4	27771.4	27756.2	27762.7	657.0
2019-03-13 01:00:00	YM	Futures	27761.6	27809.5	27754.0	27802.9	1915.0
2019-03-13 02:00:00	YM	Futures	27804.0	27806.2	27762.7	27770.3	1624.0
2019-03-13 03:00:00	YM	Futures	27771.4	27785.5	27748.6	27782.3	1945.0

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

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