PREVIEW / futures_1hour / 2017-10-26

all futures 1-hour files

  file:    by_date/futures_1hour/2017/2017-10-26.parquet
  size:    55 KB
  rows:    1,667

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-10-26 00:00:00	ES	Futures	2800.15	2800.42	2798.23	2799.6	4848.0
2017-10-26 01:00:00	ES	Futures	2799.33	2799.87	2797.96	2798.5	5589.0
2017-10-26 02:00:00	ES	Futures	2798.5	2799.6	2797.68	2798.78	8638.0
2017-10-26 03:00:00	ES	Futures	2798.78	2800.15	2797.41	2799.33	28730.0
2017-10-26 04:00:00	ES	Futures	2799.33	2799.6	2797.41	2797.68	14408.0
2017-10-26 05:00:00	ES	Futures	2797.68	2798.5	2797.14	2798.5	9501.0
2017-10-26 06:00:00	ES	Futures	2798.23	2801.79	2798.23	2800.97	13029.0
2017-10-26 07:00:00	ES	Futures	2800.97	2804.8	2800.69	2802.88	30700.0
2017-10-26 08:00:00	ES	Futures	2803.16	2804.25	2798.5	2801.51	71779.0
2017-10-26 09:00:00	ES	Futures	2801.79	2805.34	2800.97	2803.43	157768.0
2017-10-26 10:00:00	ES	Futures	2803.43	2805.07	2798.23	2804.52	195374.0
2017-10-26 11:00:00	ES	Futures	2804.52	2806.71	2799.6	2802.06	199919.0
2017-10-26 12:00:00	ES	Futures	2802.06	2804.8	2799.33	2800.69	87655.0
2017-10-26 13:00:00	ES	Futures	2800.69	2803.7	2799.6	2803.43	65192.0
2017-10-26 14:00:00	ES	Futures	2803.16	2804.25	2800.69	2800.69	72132.0
2017-10-26 15:00:00	ES	Futures	2800.69	2802.33	2798.23	2798.5	241198.0
2017-10-26 16:00:00	ES	Futures	2798.78	2804.8	2796.32	2803.7	115440.0
2017-10-26 18:00:00	ES	Futures	2802.88	2803.98	2802.06	2802.88	4498.0
2017-10-26 19:00:00	ES	Futures	2802.88	2802.88	2802.06	2802.88	2357.0
2017-10-26 20:00:00	ES	Futures	2802.88	2802.88	2798.5	2800.69	10563.0
2017-10-26 21:00:00	ES	Futures	2800.42	2803.7	2800.42	2803.16	8822.0
2017-10-26 22:00:00	ES	Futures	2803.16	2806.44	2803.16	2805.62	10492.0
2017-10-26 23:00:00	ES	Futures	2805.62	2805.89	2804.25	2805.07	5271.0
2017-10-26 00:00:00	NQ	Futures	7216.22	7216.81	7211.46	7215.62	771.0
2017-10-26 01:00:00	NQ	Futures	7215.62	7218.0	7209.37	7212.94	1207.0
2017-10-26 02:00:00	NQ	Futures	7212.65	7215.92	7207.29	7210.86	1554.0
2017-10-26 03:00:00	NQ	Futures	7210.56	7217.7	7207.59	7216.81	3004.0
2017-10-26 04:00:00	NQ	Futures	7216.81	7217.4	7209.37	7209.37	2266.0
2017-10-26 05:00:00	NQ	Futures	7209.67	7214.43	7209.08	7214.43	1213.0
2017-10-26 06:00:00	NQ	Futures	7214.43	7221.87	7213.84	7219.49	2221.0
2017-10-26 07:00:00	NQ	Futures	7218.89	7228.41	7215.03	7215.32	7021.0
2017-10-26 08:00:00	NQ	Futures	7215.92	7220.97	7202.24	7204.91	14452.0
2017-10-26 09:00:00	NQ	Futures	7204.62	7212.94	7190.34	7199.86	45573.0
2017-10-26 10:00:00	NQ	Futures	7199.86	7215.32	7179.63	7211.46	62506.0
2017-10-26 11:00:00	NQ	Futures	7211.16	7218.0	7192.42	7200.75	40429.0
2017-10-26 12:00:00	NQ	Futures	7200.45	7207.0	7188.26	7192.42	21901.0
2017-10-26 13:00:00	NQ	Futures	7192.42	7201.05	7187.96	7195.69	17341.0
2017-10-26 14:00:00	NQ	Futures	7195.4	7203.72	7193.02	7195.1	16550.0
2017-10-26 15:00:00	NQ	Futures	7195.1	7198.37	7182.9	7183.5	34228.0
2017-10-26 16:00:00	NQ	Futures	7183.8	7252.5	7182.01	7243.87	36007.0
2017-10-26 18:00:00	NQ	Futures	7247.44	7249.82	7243.28	7244.77	2664.0
2017-10-26 19:00:00	NQ	Futures	7244.77	7245.66	7241.2	7245.66	1466.0
2017-10-26 20:00:00	NQ	Futures	7245.36	7245.36	7231.68	7238.22	2983.0
2017-10-26 21:00:00	NQ	Futures	7238.52	7250.12	7237.33	7248.04	2879.0
2017-10-26 22:00:00	NQ	Futures	7248.04	7258.15	7247.44	7256.37	3509.0
2017-10-26 23:00:00	NQ	Futures	7256.37	7261.42	7254.88	7259.04	2106.0
2017-10-26 00:00:00	YM	Futures	25349.6	25353.9	25337.6	25348.5	733.0
2017-10-26 01:00:00	YM	Futures	25347.4	25351.7	25334.3	25342.0	1090.0
2017-10-26 02:00:00	YM	Futures	25340.9	25350.7	25335.4	25343.0	1115.0
2017-10-26 03:00:00	YM	Futures	25344.1	25358.3	25333.3	25348.5	2124.0

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

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