PREVIEW / futures_1hour / 2015-07-27

all futures 1-hour files

  file:    by_date/futures_1hour/2015/2015-07-27.parquet
  size:    51 KB
  rows:    1,564

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
2015-07-27 00:00:00	ES	Futures	2212.52	2213.32	2211.46	2211.72	2982.0
2015-07-27 01:00:00	ES	Futures	2211.72	2213.85	2211.19	2213.85	2959.0
2015-07-27 02:00:00	ES	Futures	2213.59	2215.72	2211.19	2211.72	13090.0
2015-07-27 03:00:00	ES	Futures	2211.72	2213.59	2206.4	2206.67	36700.0
2015-07-27 04:00:00	ES	Futures	2206.4	2212.26	2206.13	2211.99	20751.0
2015-07-27 05:00:00	ES	Futures	2211.72	2212.26	2205.33	2206.4	16406.0
2015-07-27 06:00:00	ES	Futures	2206.13	2206.67	2203.2	2203.47	24255.0
2015-07-27 07:00:00	ES	Futures	2203.47	2203.74	2198.68	2201.07	53798.0
2015-07-27 08:00:00	ES	Futures	2201.07	2201.87	2198.41	2200.28	47091.0
2015-07-27 09:00:00	ES	Futures	2200.28	2201.34	2190.16	2197.08	278902.0
2015-07-27 10:00:00	ES	Futures	2196.81	2204.0	2191.49	2199.48	314241.0
2015-07-27 11:00:00	ES	Futures	2199.74	2203.2	2195.22	2198.68	212204.0
2015-07-27 12:00:00	ES	Futures	2198.94	2199.48	2193.89	2194.95	98064.0
2015-07-27 13:00:00	ES	Futures	2195.22	2197.35	2192.29	2196.28	139182.0
2015-07-27 14:00:00	ES	Futures	2196.02	2199.21	2194.42	2195.75	152141.0
2015-07-27 15:00:00	ES	Futures	2195.75	2196.02	2190.16	2195.48	236873.0
2015-07-27 16:00:00	ES	Futures	2195.22	2199.48	2194.95	2198.68	98599.0
2015-07-27 17:00:00	ES	Futures	2198.68	2199.48	2198.41	2198.94	1616.0
2015-07-27 18:00:00	ES	Futures	2199.74	2200.81	2198.68	2200.01	4999.0
2015-07-27 19:00:00	ES	Futures	2200.01	2201.07	2199.48	2200.01	2711.0
2015-07-27 20:00:00	ES	Futures	2200.28	2200.54	2198.15	2198.15	4522.0
2015-07-27 21:00:00	ES	Futures	2197.88	2201.61	2197.08	2198.41	11235.0
2015-07-27 22:00:00	ES	Futures	2198.41	2205.07	2198.15	2204.54	10902.0
2015-07-27 23:00:00	ES	Futures	2204.54	2206.13	2203.2	2205.87	6960.0
2015-07-27 00:00:00	NQ	Futures	5395.2	5397.57	5392.24	5393.13	731.0
2015-07-27 01:00:00	NQ	Futures	5393.42	5399.34	5392.83	5398.75	666.0
2015-07-27 02:00:00	NQ	Futures	5398.45	5402.3	5390.17	5391.35	1503.0
2015-07-27 03:00:00	NQ	Futures	5391.65	5395.79	5374.49	5375.38	4091.0
2015-07-27 04:00:00	NQ	Futures	5375.68	5389.28	5374.49	5387.8	2638.0
2015-07-27 05:00:00	NQ	Futures	5387.51	5388.99	5372.42	5373.9	2324.0
2015-07-27 06:00:00	NQ	Futures	5373.9	5375.68	5367.39	5367.99	5669.0
2015-07-27 07:00:00	NQ	Futures	5368.28	5368.58	5354.97	5360.59	9455.0
2015-07-27 08:00:00	NQ	Futures	5360.89	5363.25	5354.08	5362.96	9057.0
2015-07-27 09:00:00	NQ	Futures	5362.96	5365.32	5332.79	5360.89	49842.0
2015-07-27 10:00:00	NQ	Futures	5361.18	5377.75	5343.14	5364.44	46868.0
2015-07-27 11:00:00	NQ	Futures	5364.73	5373.9	5344.03	5353.2	33415.0
2015-07-27 12:00:00	NQ	Futures	5352.9	5355.56	5338.7	5341.96	14376.0
2015-07-27 13:00:00	NQ	Futures	5342.25	5347.58	5332.2	5344.32	23672.0
2015-07-27 14:00:00	NQ	Futures	5344.03	5351.13	5337.52	5340.77	27226.0
2015-07-27 15:00:00	NQ	Futures	5340.77	5343.73	5328.35	5340.77	43962.0
2015-07-27 16:00:00	NQ	Futures	5340.77	5351.42	5339.29	5347.28	7436.0
2015-07-27 17:00:00	NQ	Futures	5347.58	5348.76	5346.99	5347.28	144.0
2015-07-27 18:00:00	NQ	Futures	5349.35	5352.01	5346.99	5349.94	755.0
2015-07-27 19:00:00	NQ	Futures	5349.94	5351.72	5348.76	5349.06	487.0
2015-07-27 20:00:00	NQ	Futures	5349.06	5350.24	5345.8	5346.1	391.0
2015-07-27 21:00:00	NQ	Futures	5346.1	5354.68	5341.96	5346.69	1432.0
2015-07-27 22:00:00	NQ	Futures	5346.1	5366.21	5345.51	5365.03	1842.0
2015-07-27 23:00:00	NQ	Futures	5364.44	5368.28	5361.77	5367.69	1120.0
2015-07-27 00:00:00	YM	Futures	18453.5	18460.8	18448.2	18451.4	404.0
2015-07-27 01:00:00	YM	Futures	18452.4	18468.2	18448.2	18466.1	399.0

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

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