PREVIEW / futures_1hour / 2017-07-25

all futures 1-hour files

  file:    by_date/futures_1hour/2017/2017-07-25.parquet
  size:    53 KB
  rows:    1,618

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-07-25 00:00:00	ES	Futures	2698.4	2699.22	2698.13	2698.95	1541.0
2017-07-25 01:00:00	ES	Futures	2698.95	2698.95	2698.4	2698.68	1330.0
2017-07-25 02:00:00	ES	Futures	2698.4	2698.68	2697.04	2697.04	4951.0
2017-07-25 03:00:00	ES	Futures	2697.04	2699.5	2697.04	2698.68	19865.0
2017-07-25 04:00:00	ES	Futures	2698.4	2700.59	2698.4	2699.5	14513.0
2017-07-25 05:00:00	ES	Futures	2699.5	2702.23	2699.22	2701.41	15574.0
2017-07-25 06:00:00	ES	Futures	2701.14	2703.6	2701.14	2703.33	13479.0
2017-07-25 07:00:00	ES	Futures	2703.05	2705.79	2703.05	2705.24	27905.0
2017-07-25 08:00:00	ES	Futures	2705.24	2706.88	2705.24	2706.06	27809.0
2017-07-25 09:00:00	ES	Futures	2706.06	2709.61	2704.69	2706.61	170498.0
2017-07-25 10:00:00	ES	Futures	2706.61	2707.97	2703.33	2706.06	169058.0
2017-07-25 11:00:00	ES	Futures	2706.06	2709.89	2705.79	2709.34	113883.0
2017-07-25 12:00:00	ES	Futures	2709.07	2710.16	2707.97	2708.79	80241.0
2017-07-25 13:00:00	ES	Futures	2708.79	2709.89	2708.25	2708.52	63909.0
2017-07-25 14:00:00	ES	Futures	2708.79	2709.07	2706.61	2707.97	91980.0
2017-07-25 15:00:00	ES	Futures	2707.7	2708.52	2704.69	2705.51	173769.0
2017-07-25 16:00:00	ES	Futures	2705.51	2706.88	2704.15	2706.61	63603.0
2017-07-25 18:00:00	ES	Futures	2706.33	2706.61	2704.97	2706.06	4005.0
2017-07-25 19:00:00	ES	Futures	2706.06	2706.33	2705.24	2706.33	2177.0
2017-07-25 20:00:00	ES	Futures	2706.33	2706.88	2705.24	2705.51	4316.0
2017-07-25 21:00:00	ES	Futures	2705.51	2706.33	2704.42	2704.42	4130.0
2017-07-25 22:00:00	ES	Futures	2704.69	2704.97	2702.78	2703.87	5196.0
2017-07-25 23:00:00	ES	Futures	2703.87	2704.15	2703.6	2703.87	1918.0
2017-07-25 00:00:00	NQ	Futures	7062.66	7065.93	7061.77	7063.55	547.0
2017-07-25 01:00:00	NQ	Futures	7063.26	7064.45	7061.47	7062.36	630.0
2017-07-25 02:00:00	NQ	Futures	7062.66	7062.66	7056.41	7057.3	1545.0
2017-07-25 03:00:00	NQ	Futures	7057.0	7065.04	7056.41	7061.47	1855.0
2017-07-25 04:00:00	NQ	Futures	7061.77	7067.72	7060.87	7065.04	1877.0
2017-07-25 05:00:00	NQ	Futures	7064.74	7070.4	7062.06	7065.64	2287.0
2017-07-25 06:00:00	NQ	Futures	7065.64	7073.08	7065.04	7069.21	1836.0
2017-07-25 07:00:00	NQ	Futures	7069.21	7075.76	7068.91	7070.1	2939.0
2017-07-25 08:00:00	NQ	Futures	7070.1	7077.84	7058.19	7061.77	7563.0
2017-07-25 09:00:00	NQ	Futures	7061.17	7068.02	7045.69	7067.42	50846.0
2017-07-25 10:00:00	NQ	Futures	7067.42	7071.0	7051.05	7052.83	45371.0
2017-07-25 11:00:00	NQ	Futures	7053.13	7072.19	7053.13	7069.21	26913.0
2017-07-25 12:00:00	NQ	Futures	7068.91	7070.7	7061.47	7068.61	17467.0
2017-07-25 13:00:00	NQ	Futures	7068.61	7081.42	7066.53	7078.74	17102.0
2017-07-25 14:00:00	NQ	Futures	7078.74	7082.01	7068.91	7072.49	17540.0
2017-07-25 15:00:00	NQ	Futures	7072.49	7073.97	7060.28	7065.64	27124.0
2017-07-25 16:00:00	NQ	Futures	7065.64	7070.7	7064.15	7068.02	7275.0
2017-07-25 18:00:00	NQ	Futures	7067.13	7068.61	7063.26	7068.02	713.0
2017-07-25 19:00:00	NQ	Futures	7068.32	7070.4	7065.34	7069.51	674.0
2017-07-25 20:00:00	NQ	Futures	7069.81	7070.1	7063.55	7064.45	874.0
2017-07-25 21:00:00	NQ	Futures	7064.45	7068.61	7063.26	7064.45	984.0
2017-07-25 22:00:00	NQ	Futures	7064.45	7066.53	7059.09	7061.77	899.0
2017-07-25 23:00:00	NQ	Futures	7061.47	7067.13	7061.17	7061.47	649.0
2017-07-25 00:00:00	YM	Futures	23393.7	23399.1	23391.5	23396.9	236.0
2017-07-25 01:00:00	YM	Futures	23396.9	23399.1	23393.7	23395.8	232.0
2017-07-25 02:00:00	YM	Futures	23395.8	23395.8	23387.1	23388.2	967.0
2017-07-25 03:00:00	YM	Futures	23388.2	23401.3	23388.2	23393.7	1981.0

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

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