PREVIEW / futures_1hour / 2017-07-24

all futures 1-hour files

  file:    by_date/futures_1hour/2017/2017-07-24.parquet
  size:    50 KB
  rows:    1,591

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-24 00:00:00	ES	Futures	2696.22	2696.49	2695.94	2696.22	521.0
2017-07-24 01:00:00	ES	Futures	2696.49	2697.86	2696.49	2697.31	2104.0
2017-07-24 02:00:00	ES	Futures	2697.31	2697.58	2696.22	2696.76	5952.0
2017-07-24 03:00:00	ES	Futures	2697.04	2697.86	2694.58	2695.12	27277.0
2017-07-24 04:00:00	ES	Futures	2695.12	2697.58	2694.3	2694.85	23487.0
2017-07-24 05:00:00	ES	Futures	2694.85	2696.22	2693.48	2695.67	18639.0
2017-07-24 06:00:00	ES	Futures	2695.4	2697.31	2694.58	2697.31	12417.0
2017-07-24 07:00:00	ES	Futures	2697.31	2697.86	2696.49	2697.04	10602.0
2017-07-24 08:00:00	ES	Futures	2697.31	2700.59	2696.76	2698.68	21509.0
2017-07-24 09:00:00	ES	Futures	2698.68	2700.04	2694.85	2697.31	117830.0
2017-07-24 10:00:00	ES	Futures	2697.31	2697.58	2694.3	2695.12	115009.0
2017-07-24 11:00:00	ES	Futures	2695.4	2697.04	2693.48	2696.76	95158.0
2017-07-24 12:00:00	ES	Futures	2696.49	2698.4	2696.49	2697.86	46084.0
2017-07-24 13:00:00	ES	Futures	2697.58	2698.4	2696.76	2697.58	39036.0
2017-07-24 14:00:00	ES	Futures	2697.31	2699.77	2697.31	2699.22	53134.0
2017-07-24 15:00:00	ES	Futures	2698.95	2701.14	2698.13	2699.5	151703.0
2017-07-24 16:00:00	ES	Futures	2699.5	2699.77	2696.76	2697.86	79404.0
2017-07-24 18:00:00	ES	Futures	2697.31	2698.68	2696.49	2698.13	3728.0
2017-07-24 19:00:00	ES	Futures	2698.13	2698.13	2697.58	2697.86	447.0
2017-07-24 20:00:00	ES	Futures	2698.13	2698.95	2697.86	2698.4	1786.0
2017-07-24 21:00:00	ES	Futures	2698.4	2699.22	2698.13	2698.13	1981.0
2017-07-24 22:00:00	ES	Futures	2698.4	2698.68	2697.86	2698.4	1601.0
2017-07-24 23:00:00	ES	Futures	2698.4	2698.68	2698.13	2698.4	455.0
2017-07-24 00:00:00	NQ	Futures	7036.16	7040.33	7035.86	7040.03	525.0
2017-07-24 01:00:00	NQ	Futures	7040.03	7043.6	7040.03	7041.52	749.0
2017-07-24 02:00:00	NQ	Futures	7041.22	7041.82	7036.46	7037.65	986.0
2017-07-24 03:00:00	NQ	Futures	7037.65	7042.11	7033.18	7035.56	2494.0
2017-07-24 04:00:00	NQ	Futures	7035.56	7044.5	7035.56	7038.24	2127.0
2017-07-24 05:00:00	NQ	Futures	7038.24	7042.11	7033.48	7041.52	1774.0
2017-07-24 06:00:00	NQ	Futures	7041.52	7044.79	7037.95	7044.5	1237.0
2017-07-24 07:00:00	NQ	Futures	7044.5	7045.39	7040.03	7040.92	1345.0
2017-07-24 08:00:00	NQ	Futures	7040.63	7054.02	7038.24	7048.67	4729.0
2017-07-24 09:00:00	NQ	Futures	7048.67	7058.49	7045.39	7056.41	28083.0
2017-07-24 10:00:00	NQ	Futures	7056.11	7058.79	7048.07	7054.32	24958.0
2017-07-24 11:00:00	NQ	Futures	7054.32	7054.32	7041.82	7053.43	20397.0
2017-07-24 12:00:00	NQ	Futures	7053.43	7065.64	7053.13	7065.34	14318.0
2017-07-24 13:00:00	NQ	Futures	7065.34	7068.32	7062.96	7062.96	11686.0
2017-07-24 14:00:00	NQ	Futures	7062.96	7073.68	7062.36	7073.38	16476.0
2017-07-24 15:00:00	NQ	Futures	7073.38	7088.27	7070.1	7081.12	31290.0
2017-07-24 16:00:00	NQ	Futures	7081.42	7092.14	7055.81	7057.0	17131.0
2017-07-24 18:00:00	NQ	Futures	7057.0	7062.36	7051.64	7060.87	1312.0
2017-07-24 19:00:00	NQ	Futures	7061.47	7061.47	7057.3	7060.28	457.0
2017-07-24 20:00:00	NQ	Futures	7060.58	7064.45	7059.98	7061.47	971.0
2017-07-24 21:00:00	NQ	Futures	7061.77	7064.74	7060.28	7061.47	928.0
2017-07-24 22:00:00	NQ	Futures	7061.47	7063.26	7059.68	7060.87	872.0
2017-07-24 23:00:00	NQ	Futures	7060.58	7062.66	7060.58	7062.36	320.0
2017-07-24 00:00:00	YM	Futures	23406.7	23412.2	23406.7	23412.2	192.0
2017-07-24 01:00:00	YM	Futures	23411.1	23422.0	23411.1	23418.7	515.0
2017-07-24 02:00:00	YM	Futures	23418.7	23418.7	23407.8	23410.0	1015.0
2017-07-24 03:00:00	YM	Futures	23410.0	23418.7	23391.5	23391.5	2950.0

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

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