PREVIEW / futures_1hour / 2018-06-14

all futures 1-hour files

  file:    by_date/futures_1hour/2018/2018-06-14.parquet
  size:    56 KB
  rows:    1,690

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-14 00:00:00	ES	Futures	3029.83	3030.1	3028.46	3029.28	2353.0
2018-06-14 01:00:00	ES	Futures	3029.55	3029.83	3025.19	3025.19	7263.0
2018-06-14 02:00:00	ES	Futures	3024.92	3027.1	3022.47	3022.47	12358.0
2018-06-14 03:00:00	ES	Futures	3022.47	3026.56	3021.38	3025.19	18520.0
2018-06-14 04:00:00	ES	Futures	3025.19	3029.01	3023.56	3027.65	10985.0
2018-06-14 05:00:00	ES	Futures	3027.92	3030.1	3026.56	3027.37	10622.0
2018-06-14 06:00:00	ES	Futures	3027.65	3030.37	3027.1	3028.74	7439.0
2018-06-14 07:00:00	ES	Futures	3028.74	3035.0	3027.92	3033.09	19859.0
2018-06-14 08:00:00	ES	Futures	3033.09	3039.91	3033.09	3037.73	40032.0
2018-06-14 09:00:00	ES	Futures	3037.73	3042.9	3036.64	3038.27	159889.0
2018-06-14 10:00:00	ES	Futures	3038.0	3045.08	3033.64	3033.64	178105.0
2018-06-14 11:00:00	ES	Futures	3033.64	3040.45	3030.92	3039.09	117999.0
2018-06-14 12:00:00	ES	Futures	3039.09	3040.45	3035.27	3035.55	56164.0
2018-06-14 13:00:00	ES	Futures	3035.55	3041.81	3034.73	3038.0	82727.0
2018-06-14 14:00:00	ES	Futures	3038.0	3039.36	3033.91	3034.46	70686.0
2018-06-14 15:00:00	ES	Futures	3034.46	3040.72	3033.09	3038.54	178126.0
2018-06-14 16:00:00	ES	Futures	3038.27	3040.18	3037.73	3038.82	48578.0
2018-06-14 18:00:00	ES	Futures	3037.45	3039.09	3035.27	3036.91	6794.0
2018-06-14 19:00:00	ES	Futures	3036.91	3038.27	3036.36	3038.0	1852.0
2018-06-14 20:00:00	ES	Futures	3038.0	3038.27	3034.18	3034.46	5877.0
2018-06-14 21:00:00	ES	Futures	3034.46	3037.45	3033.64	3037.18	7188.0
2018-06-14 22:00:00	ES	Futures	3037.18	3039.09	3036.64	3038.27	4867.0
2018-06-14 23:00:00	ES	Futures	3038.54	3038.54	3035.55	3037.45	3643.0
2018-06-14 00:00:00	NQ	Futures	8513.69	8515.75	8509.86	8511.33	940.0
2018-06-14 01:00:00	NQ	Futures	8511.33	8512.81	8492.2	8492.49	3456.0
2018-06-14 02:00:00	NQ	Futures	8492.49	8498.97	8486.01	8487.19	3921.0
2018-06-14 03:00:00	NQ	Futures	8486.9	8502.8	8485.43	8497.5	4832.0
2018-06-14 04:00:00	NQ	Futures	8497.79	8506.33	8491.31	8500.15	3088.0
2018-06-14 05:00:00	NQ	Futures	8500.15	8509.86	8495.44	8500.15	3013.0
2018-06-14 06:00:00	NQ	Futures	8500.74	8512.81	8498.97	8508.1	2746.0
2018-06-14 07:00:00	NQ	Futures	8508.1	8538.13	8506.03	8532.53	7526.0
2018-06-14 08:00:00	NQ	Futures	8532.53	8553.14	8532.24	8547.84	12874.0
2018-06-14 09:00:00	NQ	Futures	8547.55	8584.35	8545.49	8567.27	55554.0
2018-06-14 10:00:00	NQ	Futures	8566.98	8608.49	8566.98	8576.4	59390.0
2018-06-14 11:00:00	NQ	Futures	8576.11	8612.03	8563.74	8601.13	39598.0
2018-06-14 12:00:00	NQ	Futures	8601.13	8608.2	8594.36	8596.42	16651.0
2018-06-14 13:00:00	NQ	Futures	8596.42	8621.74	8593.18	8609.67	22250.0
2018-06-14 14:00:00	NQ	Futures	8609.96	8612.91	8584.35	8586.71	19960.0
2018-06-14 15:00:00	NQ	Futures	8586.41	8613.79	8585.82	8608.2	35575.0
2018-06-14 16:00:00	NQ	Futures	8607.61	8613.79	8605.55	8610.85	7713.0
2018-06-14 18:00:00	NQ	Futures	8609.08	8610.26	8599.07	8604.96	1974.0
2018-06-14 19:00:00	NQ	Futures	8605.55	8611.73	8604.66	8609.38	1275.0
2018-06-14 20:00:00	NQ	Futures	8609.67	8610.85	8601.72	8602.31	2424.0
2018-06-14 21:00:00	NQ	Futures	8602.02	8610.55	8599.07	8609.67	1915.0
2018-06-14 22:00:00	NQ	Futures	8609.38	8619.09	8608.79	8614.97	1985.0
2018-06-14 23:00:00	NQ	Futures	8614.97	8615.56	8605.25	8611.14	1334.0
2018-06-14 00:00:00	YM	Futures	27412.2	27416.6	27403.5	27409.0	623.0
2018-06-14 01:00:00	YM	Futures	27407.9	27413.3	27360.0	27361.1	2208.0
2018-06-14 02:00:00	YM	Futures	27361.1	27379.6	27348.1	27354.6	3053.0
2018-06-14 03:00:00	YM	Futures	27354.6	27385.0	27340.5	27372.0	3574.0

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

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