PREVIEW / futures_1hour / 2019-06-21

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-06-21.parquet
  size:    51 KB
  rows:    1,511

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
2019-06-21 00:00:00	ES	Futures	3196.49	3197.03	3194.05	3194.59	7382.0
2019-06-21 01:00:00	ES	Futures	3194.86	3195.4	3191.88	3195.13	12831.0
2019-06-21 02:00:00	ES	Futures	3195.13	3201.09	3194.32	3200.28	15370.0
2019-06-21 03:00:00	ES	Futures	3200.28	3205.15	3198.65	3202.98	30340.0
2019-06-21 04:00:00	ES	Futures	3202.98	3202.98	3198.38	3198.65	21897.0
2019-06-21 05:00:00	ES	Futures	3198.92	3203.25	3196.76	3199.73	30229.0
2019-06-21 06:00:00	ES	Futures	3199.73	3202.44	3196.21	3199.73	28050.0
2019-06-21 07:00:00	ES	Futures	3199.73	3202.44	3197.03	3198.11	21465.0
2019-06-21 08:00:00	ES	Futures	3198.11	3200.82	3195.67	3197.03	54348.0
2019-06-21 09:00:00	ES	Futures	3197.03	3202.71	3194.86	3198.92	223050.0
2019-06-21 10:00:00	ES	Futures	3198.92	3206.5	3196.76	3203.79	184839.0
2019-06-21 11:00:00	ES	Futures	3203.79	3215.16	3202.44	3204.07	226078.0
2019-06-21 12:00:00	ES	Futures	3204.34	3205.96	3200.28	3203.25	98271.0
2019-06-21 13:00:00	ES	Futures	3203.52	3204.61	3200.28	3204.61	55745.0
2019-06-21 14:00:00	ES	Futures	3204.34	3206.23	3201.36	3204.34	61801.0
2019-06-21 15:00:00	ES	Futures	3204.61	3208.67	3198.38	3199.73	223814.0
2019-06-21 16:00:00	ES	Futures	3199.46	3202.98	3192.42	3192.42	87498.0
2019-06-21 00:00:00	NQ	Futures	8985.42	8988.32	8975.27	8977.01	2311.0
2019-06-21 01:00:00	NQ	Futures	8977.59	8978.46	8966.56	8977.01	4185.0
2019-06-21 02:00:00	NQ	Futures	8977.01	9000.22	8972.95	8996.45	5987.0
2019-06-21 03:00:00	NQ	Futures	8996.74	9015.6	8989.19	9007.76	7953.0
2019-06-21 04:00:00	NQ	Futures	9007.47	9008.05	8989.19	8991.22	5896.0
2019-06-21 05:00:00	NQ	Futures	8991.22	9007.47	8986.58	8996.74	5516.0
2019-06-21 06:00:00	NQ	Futures	8997.03	8999.93	8982.52	8993.25	6409.0
2019-06-21 07:00:00	NQ	Futures	8993.55	8999.06	8982.81	8986.87	5071.0
2019-06-21 08:00:00	NQ	Futures	8986.87	8993.84	8974.98	8987.45	11506.0
2019-06-21 09:00:00	NQ	Futures	8986.87	9007.76	8979.33	8999.64	61089.0
2019-06-21 10:00:00	NQ	Futures	8999.35	9036.78	8995.0	9021.98	56315.0
2019-06-21 11:00:00	NQ	Futures	9021.98	9056.51	9005.15	9010.37	63255.0
2019-06-21 12:00:00	NQ	Futures	9010.37	9017.92	8995.87	9012.11	29423.0
2019-06-21 13:00:00	NQ	Futures	9012.11	9019.37	9006.31	9013.86	17544.0
2019-06-21 14:00:00	NQ	Futures	9013.56	9019.08	9000.51	9012.69	17473.0
2019-06-21 15:00:00	NQ	Futures	9012.4	9027.49	8997.03	9000.8	36840.0
2019-06-21 16:00:00	NQ	Futures	9000.8	9012.4	8989.77	8990.64	14159.0
2019-06-21 00:00:00	YM	Futures	29053.7	29058.0	29038.4	29043.9	1325.0
2019-06-21 01:00:00	YM	Futures	29043.9	29053.7	29018.9	29048.2	2786.0
2019-06-21 02:00:00	YM	Futures	29047.1	29093.9	29041.7	29088.5	3318.0
2019-06-21 03:00:00	YM	Futures	29088.5	29135.2	29075.4	29113.5	5202.0
2019-06-21 04:00:00	YM	Futures	29112.4	29116.7	29077.6	29077.6	4012.0
2019-06-21 05:00:00	YM	Futures	29078.7	29118.9	29056.9	29080.8	4920.0
2019-06-21 06:00:00	YM	Futures	29081.9	29106.9	29056.9	29087.4	3942.0
2019-06-21 07:00:00	YM	Futures	29087.4	29106.9	29062.4	29067.8	2906.0
2019-06-21 08:00:00	YM	Futures	29068.9	29092.8	29048.2	29063.4	7396.0
2019-06-21 09:00:00	YM	Futures	29062.4	29127.6	29041.7	29100.4	27361.0
2019-06-21 10:00:00	YM	Futures	29100.4	29179.8	29086.3	29161.3	27654.0
2019-06-21 11:00:00	YM	Futures	29161.3	29277.7	29160.2	29175.5	35604.0
2019-06-21 12:00:00	YM	Futures	29175.5	29185.2	29128.7	29161.3	16757.0
2019-06-21 13:00:00	YM	Futures	29160.2	29170.0	29129.8	29159.1	9680.0
2019-06-21 14:00:00	YM	Futures	29160.2	29172.2	29128.7	29150.4	10024.0
2019-06-21 15:00:00	YM	Futures	29151.5	29185.2	29053.7	29070.0	20606.0

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

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