PREVIEW / futures_1hour / 2017-08-07

all futures 1-hour files

  file:    by_date/futures_1hour/2017/2017-08-07.parquet
  size:    49 KB
  rows:    1,583

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-08-07 00:00:00	ES	Futures	2707.97	2708.25	2707.7	2707.97	818.0
2017-08-07 01:00:00	ES	Futures	2707.97	2708.25	2707.43	2707.43	3250.0
2017-08-07 02:00:00	ES	Futures	2707.43	2708.25	2706.88	2707.43	5784.0
2017-08-07 03:00:00	ES	Futures	2707.43	2708.52	2706.88	2707.43	16593.0
2017-08-07 04:00:00	ES	Futures	2707.15	2707.7	2706.33	2706.88	10785.0
2017-08-07 05:00:00	ES	Futures	2706.88	2706.88	2704.69	2704.97	10946.0
2017-08-07 06:00:00	ES	Futures	2704.97	2706.06	2704.69	2705.79	10766.0
2017-08-07 07:00:00	ES	Futures	2705.79	2705.79	2704.15	2704.42	8374.0
2017-08-07 08:00:00	ES	Futures	2704.15	2706.06	2703.87	2705.24	12921.0
2017-08-07 09:00:00	ES	Futures	2705.24	2706.61	2703.87	2706.06	83804.0
2017-08-07 10:00:00	ES	Futures	2706.06	2706.88	2703.87	2704.97	83871.0
2017-08-07 11:00:00	ES	Futures	2704.97	2707.15	2704.42	2706.61	61817.0
2017-08-07 12:00:00	ES	Futures	2706.88	2707.97	2706.61	2707.7	32333.0
2017-08-07 13:00:00	ES	Futures	2707.7	2708.25	2706.33	2707.43	33812.0
2017-08-07 14:00:00	ES	Futures	2707.43	2708.52	2706.88	2707.7	22484.0
2017-08-07 15:00:00	ES	Futures	2707.97	2709.61	2707.15	2709.07	105224.0
2017-08-07 16:00:00	ES	Futures	2709.07	2709.61	2708.25	2709.07	56019.0
2017-08-07 18:00:00	ES	Futures	2708.79	2708.79	2706.61	2707.15	5618.0
2017-08-07 19:00:00	ES	Futures	2707.43	2707.97	2707.15	2707.97	860.0
2017-08-07 20:00:00	ES	Futures	2707.97	2708.25	2706.61	2706.88	2797.0
2017-08-07 21:00:00	ES	Futures	2706.88	2707.15	2704.69	2705.51	6082.0
2017-08-07 22:00:00	ES	Futures	2705.51	2706.06	2704.42	2705.79	4184.0
2017-08-07 23:00:00	ES	Futures	2705.51	2706.06	2705.51	2705.79	1322.0
2017-08-07 00:00:00	NQ	Futures	7051.34	7051.64	7048.96	7051.05	358.0
2017-08-07 01:00:00	NQ	Futures	7051.05	7052.54	7045.09	7046.88	785.0
2017-08-07 02:00:00	NQ	Futures	7046.88	7049.86	7045.39	7048.07	1033.0
2017-08-07 03:00:00	NQ	Futures	7047.77	7050.15	7042.41	7044.2	1688.0
2017-08-07 04:00:00	NQ	Futures	7044.2	7044.5	7039.73	7040.63	1297.0
2017-08-07 05:00:00	NQ	Futures	7040.92	7040.92	7027.52	7027.52	2538.0
2017-08-07 06:00:00	NQ	Futures	7027.52	7036.16	7027.52	7032.88	3519.0
2017-08-07 07:00:00	NQ	Futures	7033.18	7034.67	7026.63	7032.59	1860.0
2017-08-07 08:00:00	NQ	Futures	7031.99	7039.73	7031.69	7034.67	2511.0
2017-08-07 09:00:00	NQ	Futures	7034.67	7043.9	7027.52	7043.01	30253.0
2017-08-07 10:00:00	NQ	Futures	7043.01	7052.24	7038.54	7049.56	32339.0
2017-08-07 11:00:00	NQ	Futures	7049.26	7061.47	7045.99	7057.9	23310.0
2017-08-07 12:00:00	NQ	Futures	7058.19	7060.87	7052.83	7059.68	10566.0
2017-08-07 13:00:00	NQ	Futures	7059.68	7060.28	7053.13	7056.41	8385.0
2017-08-07 14:00:00	NQ	Futures	7056.41	7061.47	7054.62	7059.68	6720.0
2017-08-07 15:00:00	NQ	Futures	7059.68	7069.51	7058.19	7065.93	24126.0
2017-08-07 16:00:00	NQ	Futures	7066.23	7071.89	7065.93	7071.0	5964.0
2017-08-07 18:00:00	NQ	Futures	7068.61	7069.51	7063.85	7065.34	967.0
2017-08-07 19:00:00	NQ	Futures	7065.93	7068.61	7065.04	7068.32	347.0
2017-08-07 20:00:00	NQ	Futures	7068.32	7068.61	7061.77	7063.85	738.0
2017-08-07 21:00:00	NQ	Futures	7063.55	7064.15	7057.9	7060.58	1132.0
2017-08-07 22:00:00	NQ	Futures	7060.28	7061.77	7058.79	7060.87	738.0
2017-08-07 23:00:00	NQ	Futures	7060.87	7063.26	7060.28	7060.28	422.0
2017-08-07 00:00:00	YM	Futures	24027.1	24027.1	24019.5	24020.6	395.0
2017-08-07 01:00:00	YM	Futures	24021.7	24022.8	24014.1	24017.4	829.0
2017-08-07 02:00:00	YM	Futures	24016.3	24019.5	24004.3	24010.8	1198.0
2017-08-07 03:00:00	YM	Futures	24010.8	24019.5	24008.6	24010.8	1474.0

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

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