PREVIEW / futures_1hour / 2017-09-13

all futures 1-hour files

  file:    by_date/futures_1hour/2017/2017-09-13.parquet
  size:    51 KB
  rows:    1,600

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-09-13 00:00:00	ES	Futures	2727.38	2727.65	2727.11	2727.11	380.0
2017-09-13 01:00:00	ES	Futures	2727.38	2727.38	2726.29	2726.29	819.0
2017-09-13 02:00:00	ES	Futures	2726.56	2727.11	2724.65	2724.92	4899.0
2017-09-13 03:00:00	ES	Futures	2725.19	2725.74	2723.28	2724.65	5003.0
2017-09-13 04:00:00	ES	Futures	2724.37	2726.29	2724.1	2725.74	2698.0
2017-09-13 05:00:00	ES	Futures	2725.74	2726.56	2724.65	2725.19	3129.0
2017-09-13 06:00:00	ES	Futures	2725.19	2725.47	2724.37	2724.37	2206.0
2017-09-13 07:00:00	ES	Futures	2724.37	2726.56	2724.37	2726.29	2333.0
2017-09-13 08:00:00	ES	Futures	2726.01	2726.29	2723.83	2725.74	6736.0
2017-09-13 09:00:00	ES	Futures	2725.74	2727.65	2723.55	2727.65	25008.0
2017-09-13 10:00:00	ES	Futures	2727.65	2729.02	2726.29	2727.65	16839.0
2017-09-13 11:00:00	ES	Futures	2727.65	2729.29	2725.19	2726.56	11380.0
2017-09-13 12:00:00	ES	Futures	2726.56	2729.57	2726.56	2728.47	9069.0
2017-09-13 13:00:00	ES	Futures	2728.75	2729.02	2726.56	2727.65	13191.0
2017-09-13 14:00:00	ES	Futures	2727.65	2729.29	2727.11	2728.47	6512.0
2017-09-13 15:00:00	ES	Futures	2728.47	2730.66	2727.65	2730.11	24787.0
2017-09-13 16:00:00	ES	Futures	2730.11	2730.39	2728.2	2729.84	12730.0
2017-09-13 18:00:00	ES	Futures	2729.29	2729.57	2726.56	2727.38	1804.0
2017-09-13 19:00:00	ES	Futures	2727.38	2727.65	2726.83	2727.38	677.0
2017-09-13 20:00:00	ES	Futures	2727.38	2728.47	2727.11	2728.47	990.0
2017-09-13 21:00:00	ES	Futures	2728.2	2728.75	2727.93	2728.2	855.0
2017-09-13 22:00:00	ES	Futures	2728.2	2728.2	2726.83	2726.83	975.0
2017-09-13 23:00:00	ES	Futures	2727.11	2727.11	2726.29	2726.83	1034.0
2017-09-13 00:00:00	NQ	Futures	7137.99	7137.99	7136.8	7137.69	74.0
2017-09-13 01:00:00	NQ	Futures	7138.29	7138.88	7134.42	7134.42	162.0
2017-09-13 02:00:00	NQ	Futures	7134.12	7135.31	7130.25	7132.33	257.0
2017-09-13 03:00:00	NQ	Futures	7132.63	7134.72	7125.19	7127.27	486.0
2017-09-13 04:00:00	NQ	Futures	7127.87	7133.52	7126.38	7130.25	605.0
2017-09-13 05:00:00	NQ	Futures	7130.25	7131.74	7126.38	7129.36	592.0
2017-09-13 06:00:00	NQ	Futures	7129.65	7129.95	7124.0	7124.29	498.0
2017-09-13 07:00:00	NQ	Futures	7124.29	7131.44	7124.29	7129.65	396.0
2017-09-13 08:00:00	NQ	Futures	7129.06	7130.25	7122.51	7129.36	945.0
2017-09-13 09:00:00	NQ	Futures	7129.65	7138.88	7116.85	7137.99	7197.0
2017-09-13 10:00:00	NQ	Futures	7138.59	7142.75	7129.06	7134.42	6021.0
2017-09-13 11:00:00	NQ	Futures	7134.72	7140.67	7120.72	7124.89	3839.0
2017-09-13 12:00:00	NQ	Futures	7124.59	7144.54	7124.29	7137.4	3159.0
2017-09-13 13:00:00	NQ	Futures	7137.69	7143.35	7131.44	7140.07	3537.0
2017-09-13 14:00:00	NQ	Futures	7140.37	7143.95	7137.99	7139.18	2339.0
2017-09-13 15:00:00	NQ	Futures	7138.88	7151.39	7134.72	7149.31	5078.0
2017-09-13 16:00:00	NQ	Futures	7149.6	7152.28	7143.95	7149.9	1800.0
2017-09-13 18:00:00	NQ	Futures	7148.11	7149.01	7139.48	7141.27	256.0
2017-09-13 19:00:00	NQ	Futures	7141.56	7143.35	7140.07	7140.37	110.0
2017-09-13 20:00:00	NQ	Futures	7140.37	7144.84	7140.07	7144.54	213.0
2017-09-13 21:00:00	NQ	Futures	7144.24	7146.92	7143.05	7145.73	174.0
2017-09-13 22:00:00	NQ	Futures	7145.43	7145.43	7140.67	7142.16	102.0
2017-09-13 23:00:00	NQ	Futures	7141.86	7141.86	7139.48	7141.56	106.0
2017-09-13 00:00:00	YM	Futures	24012.8	24017.2	24012.8	24015.0	296.0
2017-09-13 01:00:00	YM	Futures	24016.1	24016.1	24009.5	24010.6	508.0
2017-09-13 02:00:00	YM	Futures	24010.6	24013.9	23996.5	24000.8	1308.0
2017-09-13 03:00:00	YM	Futures	24001.9	24007.4	23987.8	23996.5	1709.0

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

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