PREVIEW / futures_1hour / 2017-06-09

all futures 1-hour files

  file:    by_date/futures_1hour/2017/2017-06-09.parquet
  size:    46 KB
  rows:    1,361

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-06-09 00:00:00	ES	Futures	2660.41	2660.41	2659.05	2659.87	2364.0
2017-06-09 01:00:00	ES	Futures	2659.87	2660.14	2659.05	2659.59	1580.0
2017-06-09 02:00:00	ES	Futures	2659.87	2660.69	2658.77	2659.32	5467.0
2017-06-09 03:00:00	ES	Futures	2659.32	2663.96	2658.77	2659.32	19733.0
2017-06-09 04:00:00	ES	Futures	2659.32	2662.32	2658.77	2661.23	6834.0
2017-06-09 05:00:00	ES	Futures	2661.51	2662.6	2660.96	2661.23	3448.0
2017-06-09 06:00:00	ES	Futures	2661.51	2662.32	2659.59	2660.14	4586.0
2017-06-09 07:00:00	ES	Futures	2660.41	2662.32	2659.05	2662.05	11828.0
2017-06-09 08:00:00	ES	Futures	2662.05	2662.6	2660.14	2660.69	11415.0
2017-06-09 09:00:00	ES	Futures	2660.96	2667.79	2660.14	2666.15	64930.0
2017-06-09 10:00:00	ES	Futures	2666.42	2672.16	2665.33	2669.97	99688.0
2017-06-09 11:00:00	ES	Futures	2669.97	2671.88	2668.33	2668.33	60396.0
2017-06-09 12:00:00	ES	Futures	2668.61	2669.7	2660.41	2663.96	93652.0
2017-06-09 13:00:00	ES	Futures	2663.96	2665.33	2653.04	2653.04	103340.0
2017-06-09 14:00:00	ES	Futures	2653.04	2658.23	2638.29	2644.02	185377.0
2017-06-09 15:00:00	ES	Futures	2644.02	2656.59	2643.75	2654.95	182031.0
2017-06-09 16:00:00	ES	Futures	2654.68	2656.86	2653.31	2655.77	43871.0
2017-06-09 00:00:00	NQ	Futures	7017.62	7019.11	7014.34	7017.03	520.0
2017-06-09 01:00:00	NQ	Futures	7017.03	7019.41	7014.94	7018.82	552.0
2017-06-09 02:00:00	NQ	Futures	7018.82	7020.31	7015.24	7018.82	832.0
2017-06-09 03:00:00	NQ	Futures	7019.11	7030.74	7017.03	7019.41	2487.0
2017-06-09 04:00:00	NQ	Futures	7019.41	7027.46	7016.73	7024.48	1311.0
2017-06-09 05:00:00	NQ	Futures	7023.59	7027.46	7023.29	7025.08	925.0
2017-06-09 06:00:00	NQ	Futures	7025.08	7027.46	7018.22	7019.41	1085.0
2017-06-09 07:00:00	NQ	Futures	7019.11	7026.27	7017.03	7024.48	2054.0
2017-06-09 08:00:00	NQ	Futures	7024.18	7025.08	7020.01	7022.1	1572.0
2017-06-09 09:00:00	NQ	Futures	7022.1	7029.55	7010.47	7020.9	19724.0
2017-06-09 10:00:00	NQ	Futures	7021.2	7034.62	7018.22	7021.8	17659.0
2017-06-09 11:00:00	NQ	Futures	7022.1	7024.48	6991.39	6991.39	22366.0
2017-06-09 12:00:00	NQ	Futures	6991.69	6991.98	6929.97	6943.39	39413.0
2017-06-09 13:00:00	NQ	Futures	6943.69	6946.67	6861.99	6861.99	41454.0
2017-06-09 14:00:00	NQ	Futures	6861.99	6883.16	6750.19	6808.93	55991.0
2017-06-09 15:00:00	NQ	Futures	6809.22	6861.99	6806.84	6841.12	75409.0
2017-06-09 16:00:00	NQ	Futures	6841.12	6852.75	6838.44	6842.02	7855.0
2017-06-09 00:00:00	YM	Futures	23035.6	23035.6	23025.8	23032.4	269.0
2017-06-09 01:00:00	YM	Futures	23032.4	23033.5	23023.7	23030.2	396.0
2017-06-09 02:00:00	YM	Futures	23029.1	23033.5	23019.3	23023.7	670.0
2017-06-09 03:00:00	YM	Futures	23024.8	23076.9	23018.2	23030.2	4199.0
2017-06-09 04:00:00	YM	Futures	23028.0	23058.4	23022.6	23050.8	1210.0
2017-06-09 05:00:00	YM	Futures	23049.8	23058.4	23049.8	23050.8	277.0
2017-06-09 06:00:00	YM	Futures	23051.9	23056.3	23033.5	23037.8	567.0
2017-06-09 07:00:00	YM	Futures	23038.9	23057.4	23031.3	23054.1	1342.0
2017-06-09 08:00:00	YM	Futures	23055.2	23058.4	23042.1	23043.2	897.0
2017-06-09 09:00:00	YM	Futures	23043.2	23094.3	23042.1	23085.6	8521.0
2017-06-09 10:00:00	YM	Futures	23086.7	23149.7	23079.1	23122.6	11624.0
2017-06-09 11:00:00	YM	Futures	23122.6	23142.1	23109.5	23117.1	7292.0
2017-06-09 12:00:00	YM	Futures	23118.2	23130.2	23067.1	23107.4	9146.0
2017-06-09 13:00:00	YM	Futures	23107.4	23121.5	23065.0	23068.2	7014.0
2017-06-09 14:00:00	YM	Futures	23068.2	23100.8	22987.8	23008.5	14094.0
2017-06-09 15:00:00	YM	Futures	23008.5	23110.6	23006.3	23101.9	14971.0

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

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