PREVIEW / futures_1hour / 2017-07-21

all futures 1-hour files

  file:    by_date/futures_1hour/2017/2017-07-21.parquet
  size:    45 KB
  rows:    1,333

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-21 00:00:00	ES	Futures	2702.51	2702.78	2701.69	2701.69	1090.0
2017-07-21 01:00:00	ES	Futures	2701.96	2702.51	2701.69	2702.23	1165.0
2017-07-21 02:00:00	ES	Futures	2702.51	2702.51	2701.69	2702.51	4038.0
2017-07-21 03:00:00	ES	Futures	2702.23	2703.6	2701.96	2703.05	17225.0
2017-07-21 04:00:00	ES	Futures	2703.33	2705.79	2703.05	2705.51	11488.0
2017-07-21 05:00:00	ES	Futures	2705.51	2706.33	2703.05	2703.6	15054.0
2017-07-21 06:00:00	ES	Futures	2703.87	2704.15	2699.77	2700.87	25381.0
2017-07-21 07:00:00	ES	Futures	2700.87	2702.23	2700.32	2701.14	19205.0
2017-07-21 08:00:00	ES	Futures	2701.14	2701.96	2698.68	2698.95	26516.0
2017-07-21 09:00:00	ES	Futures	2698.95	2699.5	2693.21	2694.58	225077.0
2017-07-21 10:00:00	ES	Futures	2694.58	2696.76	2692.66	2693.76	178302.0
2017-07-21 11:00:00	ES	Futures	2693.76	2698.68	2693.48	2698.68	112002.0
2017-07-21 12:00:00	ES	Futures	2698.4	2699.5	2697.04	2698.95	69352.0
2017-07-21 13:00:00	ES	Futures	2699.22	2700.59	2697.58	2698.95	72127.0
2017-07-21 14:00:00	ES	Futures	2698.95	2699.22	2696.76	2698.4	61225.0
2017-07-21 15:00:00	ES	Futures	2698.13	2700.87	2696.22	2700.32	152963.0
2017-07-21 16:00:00	ES	Futures	2700.32	2700.59	2698.95	2700.59	71501.0
2017-07-21 00:00:00	NQ	Futures	7046.28	7048.67	7045.99	7046.28	390.0
2017-07-21 01:00:00	NQ	Futures	7046.58	7049.26	7045.09	7048.96	695.0
2017-07-21 02:00:00	NQ	Futures	7048.96	7048.96	7044.79	7046.28	548.0
2017-07-21 03:00:00	NQ	Futures	7045.99	7053.43	7045.39	7052.83	1723.0
2017-07-21 04:00:00	NQ	Futures	7052.54	7058.49	7051.94	7058.19	1847.0
2017-07-21 05:00:00	NQ	Futures	7058.19	7062.06	7053.13	7054.92	1773.0
2017-07-21 06:00:00	NQ	Futures	7054.62	7055.81	7040.92	7048.07	2954.0
2017-07-21 07:00:00	NQ	Futures	7048.37	7048.67	7042.41	7042.41	3857.0
2017-07-21 08:00:00	NQ	Futures	7042.71	7045.99	7035.86	7038.24	7908.0
2017-07-21 09:00:00	NQ	Futures	7038.54	7040.63	7015.61	7033.48	62102.0
2017-07-21 10:00:00	NQ	Futures	7033.48	7043.6	7028.12	7030.5	44268.0
2017-07-21 11:00:00	NQ	Futures	7030.5	7042.11	7022.76	7041.82	23454.0
2017-07-21 12:00:00	NQ	Futures	7042.11	7048.96	7038.54	7048.67	14105.0
2017-07-21 13:00:00	NQ	Futures	7048.37	7052.54	7038.24	7043.31	16009.0
2017-07-21 14:00:00	NQ	Futures	7043.31	7047.47	7034.97	7044.2	16078.0
2017-07-21 15:00:00	NQ	Futures	7043.9	7051.94	7039.14	7051.94	27008.0
2017-07-21 16:00:00	NQ	Futures	7051.64	7055.22	7048.37	7054.32	6754.0
2017-07-21 00:00:00	YM	Futures	23488.4	23491.6	23485.1	23485.1	193.0
2017-07-21 01:00:00	YM	Futures	23486.2	23489.4	23485.1	23488.4	264.0
2017-07-21 02:00:00	YM	Futures	23488.4	23488.4	23481.8	23482.9	705.0
2017-07-21 03:00:00	YM	Futures	23482.9	23489.4	23470.9	23478.6	2886.0
2017-07-21 04:00:00	YM	Futures	23478.6	23493.8	23477.5	23492.7	1418.0
2017-07-21 05:00:00	YM	Futures	23492.7	23500.3	23474.2	23478.6	1642.0
2017-07-21 06:00:00	YM	Futures	23478.6	23481.8	23450.3	23459.0	2940.0
2017-07-21 07:00:00	YM	Futures	23460.0	23472.0	23459.0	23465.5	1744.0
2017-07-21 08:00:00	YM	Futures	23465.5	23468.8	23436.1	23438.3	3369.0
2017-07-21 09:00:00	YM	Futures	23438.3	23439.4	23363.2	23368.6	24749.0
2017-07-21 10:00:00	YM	Futures	23368.6	23428.5	23349.0	23369.7	21271.0
2017-07-21 11:00:00	YM	Futures	23369.7	23408.9	23366.4	23407.8	9220.0
2017-07-21 12:00:00	YM	Futures	23408.9	23422.0	23393.7	23418.7	5470.0
2017-07-21 13:00:00	YM	Futures	23419.8	23431.7	23411.1	23425.2	5103.0
2017-07-21 14:00:00	YM	Futures	23425.2	23427.4	23410.0	23423.0	4953.0
2017-07-21 15:00:00	YM	Futures	23423.0	23436.1	23403.4	23433.9	7798.0

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

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