PREVIEW / futures_1hour / 2019-06-14

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-06-14.parquet
  size:    48 KB
  rows:    1,443

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-14 00:00:00	ES	Futures	3140.99	3142.34	3139.91	3141.8	2596.0
2019-06-14 01:00:00	ES	Futures	3141.8	3141.8	3139.37	3139.91	4466.0
2019-06-14 02:00:00	ES	Futures	3139.91	3139.91	3132.33	3133.68	11390.0
2019-06-14 03:00:00	ES	Futures	3133.41	3136.93	3130.16	3133.14	15966.0
2019-06-14 04:00:00	ES	Futures	3133.41	3134.49	3128.54	3130.7	13156.0
2019-06-14 05:00:00	ES	Futures	3130.7	3132.6	3127.73	3129.62	10713.0
2019-06-14 06:00:00	ES	Futures	3129.89	3130.7	3124.75	3128.27	12384.0
2019-06-14 07:00:00	ES	Futures	3128.27	3132.6	3128.0	3132.06	10997.0
2019-06-14 08:00:00	ES	Futures	3132.06	3133.68	3129.89	3131.79	21559.0
2019-06-14 09:00:00	ES	Futures	3131.79	3135.58	3123.12	3125.83	127139.0
2019-06-14 10:00:00	ES	Futures	3125.83	3132.6	3123.67	3130.97	123648.0
2019-06-14 11:00:00	ES	Futures	3130.97	3132.6	3123.4	3128.81	85491.0
2019-06-14 12:00:00	ES	Futures	3128.81	3129.89	3125.83	3129.08	42008.0
2019-06-14 13:00:00	ES	Futures	3129.08	3130.16	3126.64	3127.18	30600.0
2019-06-14 14:00:00	ES	Futures	3126.91	3132.33	3126.91	3131.79	37591.0
2019-06-14 15:00:00	ES	Futures	3131.52	3139.91	3131.52	3132.33	115305.0
2019-06-14 16:00:00	ES	Futures	3132.33	3136.39	3132.06	3136.12	35622.0
2019-06-14 00:00:00	NQ	Futures	8750.99	8756.79	8746.92	8753.89	761.0
2019-06-14 01:00:00	NQ	Futures	8753.6	8753.89	8741.7	8744.6	1261.0
2019-06-14 02:00:00	NQ	Futures	8744.02	8744.6	8713.27	8718.2	3177.0
2019-06-14 03:00:00	NQ	Futures	8717.91	8729.52	8706.01	8717.33	4006.0
2019-06-14 04:00:00	NQ	Futures	8718.49	8722.26	8696.73	8704.56	3061.0
2019-06-14 05:00:00	NQ	Futures	8704.56	8710.66	8691.22	8697.02	2662.0
2019-06-14 06:00:00	NQ	Futures	8697.31	8699.92	8678.45	8689.77	3416.0
2019-06-14 07:00:00	NQ	Futures	8690.06	8710.37	8688.03	8708.34	2962.0
2019-06-14 08:00:00	NQ	Futures	8708.34	8710.66	8692.96	8707.46	6127.0
2019-06-14 09:00:00	NQ	Futures	8707.17	8716.17	8683.38	8694.41	32258.0
2019-06-14 10:00:00	NQ	Futures	8694.7	8728.65	8687.44	8715.59	38228.0
2019-06-14 11:00:00	NQ	Futures	8715.59	8723.42	8685.7	8707.17	32209.0
2019-06-14 12:00:00	NQ	Futures	8707.46	8715.88	8700.21	8713.56	12203.0
2019-06-14 13:00:00	NQ	Futures	8713.56	8715.01	8704.85	8705.14	8520.0
2019-06-14 14:00:00	NQ	Futures	8705.14	8720.81	8703.4	8719.36	10896.0
2019-06-14 15:00:00	NQ	Futures	8719.36	8740.25	8712.11	8714.72	28130.0
2019-06-14 16:00:00	NQ	Futures	8715.01	8718.78	8708.34	8717.04	6895.0
2019-06-14 00:00:00	YM	Futures	28444.7	28461.0	28439.2	28450.1	664.0
2019-06-14 01:00:00	YM	Futures	28450.1	28455.5	28438.1	28444.7	826.0
2019-06-14 02:00:00	YM	Futures	28443.6	28444.7	28367.4	28384.8	2805.0
2019-06-14 03:00:00	YM	Futures	28383.8	28408.8	28355.5	28379.4	3768.0
2019-06-14 04:00:00	YM	Futures	28379.4	28389.2	28339.2	28358.7	2409.0
2019-06-14 05:00:00	YM	Futures	28359.8	28383.8	28343.5	28362.0	2375.0
2019-06-14 06:00:00	YM	Futures	28363.1	28370.7	28308.7	28335.9	3463.0
2019-06-14 07:00:00	YM	Futures	28335.9	28380.5	28330.5	28375.1	3288.0
2019-06-14 08:00:00	YM	Futures	28375.1	28388.1	28352.2	28364.2	3437.0
2019-06-14 09:00:00	YM	Futures	28363.1	28396.8	28283.7	28305.5	16993.0
2019-06-14 10:00:00	YM	Futures	28305.5	28396.8	28290.2	28381.6	16499.0
2019-06-14 11:00:00	YM	Futures	28381.6	28392.5	28303.3	28372.9	11227.0
2019-06-14 12:00:00	YM	Futures	28368.5	28391.4	28350.0	28374.0	5672.0
2019-06-14 13:00:00	YM	Futures	28374.0	28387.0	28358.7	28359.8	4015.0
2019-06-14 14:00:00	YM	Futures	28359.8	28409.9	28357.7	28402.2	5566.0
2019-06-14 15:00:00	YM	Futures	28401.2	28472.9	28394.6	28400.1	13109.0

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

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