PREVIEW / futures_1hour / 2018-10-15

all futures 1-hour files

  file:    by_date/futures_1hour/2018/2018-10-15.parquet
  size:    55 KB
  rows:    1,706

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-10-15 00:00:00	ES	Futures	3005.31	3007.48	3003.95	3006.12	5352.0
2018-10-15 01:00:00	ES	Futures	3005.85	3006.12	2997.96	2998.51	9641.0
2018-10-15 02:00:00	ES	Futures	2998.51	3001.5	2994.16	3000.41	15333.0
2018-10-15 03:00:00	ES	Futures	3000.14	3002.86	2994.16	2997.15	24536.0
2018-10-15 04:00:00	ES	Futures	2997.15	2999.32	2986.81	2988.44	30044.0
2018-10-15 05:00:00	ES	Futures	2988.72	3000.96	2987.9	2998.78	24419.0
2018-10-15 06:00:00	ES	Futures	2998.51	3002.04	2995.79	2997.69	22702.0
2018-10-15 07:00:00	ES	Futures	2997.42	3011.56	2996.88	3009.12	36470.0
2018-10-15 08:00:00	ES	Futures	3009.39	3012.38	3006.12	3009.12	37662.0
2018-10-15 09:00:00	ES	Futures	3009.12	3013.47	3002.32	3003.95	203584.0
2018-10-15 10:00:00	ES	Futures	3003.95	3008.57	2993.34	3007.21	206894.0
2018-10-15 11:00:00	ES	Futures	3007.21	3018.91	3002.04	3003.4	191278.0
2018-10-15 12:00:00	ES	Futures	3003.4	3012.38	2996.6	3008.84	127551.0
2018-10-15 13:00:00	ES	Futures	3009.12	3021.08	3008.03	3017.82	123615.0
2018-10-15 14:00:00	ES	Futures	3018.09	3023.26	3004.76	3019.45	154506.0
2018-10-15 15:00:00	ES	Futures	3019.72	3021.9	2994.7	2995.24	301614.0
2018-10-15 16:00:00	ES	Futures	2994.97	2997.42	2986.81	2988.72	103802.0
2018-10-15 18:00:00	ES	Futures	2989.26	2993.61	2987.08	2992.25	14331.0
2018-10-15 19:00:00	ES	Futures	2991.98	2998.24	2991.16	2997.69	12368.0
2018-10-15 20:00:00	ES	Futures	2997.69	3000.41	2996.88	2997.42	17675.0
2018-10-15 21:00:00	ES	Futures	2997.69	3003.4	2997.15	3003.13	16578.0
2018-10-15 22:00:00	ES	Futures	3003.13	3004.49	2999.87	3000.41	10426.0
2018-10-15 23:00:00	ES	Futures	3000.41	3000.41	2995.24	2997.96	8473.0
2018-10-15 00:00:00	NQ	Futures	8384.68	8391.42	8377.35	8384.97	2188.0
2018-10-15 01:00:00	NQ	Futures	8384.68	8384.97	8359.45	8361.21	3661.0
2018-10-15 02:00:00	NQ	Futures	8361.51	8367.08	8335.4	8355.35	8798.0
2018-10-15 03:00:00	NQ	Futures	8354.76	8366.49	8329.54	8341.56	11281.0
2018-10-15 04:00:00	NQ	Futures	8340.97	8352.12	8307.24	8319.56	10032.0
2018-10-15 05:00:00	NQ	Futures	8318.98	8354.76	8316.04	8347.13	8234.0
2018-10-15 06:00:00	NQ	Futures	8347.43	8359.16	8341.27	8345.37	5489.0
2018-10-15 07:00:00	NQ	Futures	8344.49	8403.45	8344.2	8398.17	16823.0
2018-10-15 08:00:00	NQ	Futures	8398.17	8414.6	8385.56	8394.65	19140.0
2018-10-15 09:00:00	NQ	Futures	8394.36	8402.28	8331.3	8338.04	83361.0
2018-10-15 10:00:00	NQ	Futures	8338.63	8346.84	8284.07	8342.73	97014.0
2018-10-15 11:00:00	NQ	Futures	8343.32	8397.88	8327.78	8332.76	76792.0
2018-10-15 12:00:00	NQ	Futures	8332.76	8377.93	8312.52	8362.97	55645.0
2018-10-15 13:00:00	NQ	Futures	8363.27	8403.45	8346.84	8387.32	47923.0
2018-10-15 14:00:00	NQ	Futures	8388.2	8398.17	8334.81	8386.73	53637.0
2018-10-15 15:00:00	NQ	Futures	8387.02	8403.16	8310.47	8312.23	79289.0
2018-10-15 16:00:00	NQ	Futures	8311.94	8317.8	8291.4	8294.63	18684.0
2018-10-15 18:00:00	NQ	Futures	8292.87	8315.75	8287.3	8310.47	5275.0
2018-10-15 19:00:00	NQ	Futures	8310.18	8331.88	8304.31	8329.54	4483.0
2018-10-15 20:00:00	NQ	Futures	8330.12	8343.32	8329.24	8333.93	7426.0
2018-10-15 21:00:00	NQ	Futures	8333.93	8360.92	8333.35	8359.45	8375.0
2018-10-15 22:00:00	NQ	Futures	8359.75	8363.56	8341.27	8343.91	4892.0
2018-10-15 23:00:00	NQ	Futures	8344.2	8345.37	8321.62	8332.17	5880.0
2018-10-15 00:00:00	YM	Futures	27451.8	27475.7	27439.9	27455.1	1720.0
2018-10-15 01:00:00	YM	Futures	27454.0	27455.1	27387.7	27397.5	2951.0
2018-10-15 02:00:00	YM	Futures	27396.4	27413.8	27345.3	27407.3	4519.0
2018-10-15 03:00:00	YM	Futures	27405.1	27433.4	27354.0	27382.3	8577.0

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

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