PREVIEW / futures_1hour / 2014-11-25

all futures 1-hour files

  file:    by_date/futures_1hour/2014/2014-11-25.parquet
  size:    48 KB
  rows:    1,512

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
2014-11-25 00:00:00	ES	Futures	2163.59	2164.37	2163.33	2163.85	2609.0
2014-11-25 01:00:00	ES	Futures	2163.59	2165.42	2163.59	2165.42	2455.0
2014-11-25 02:00:00	ES	Futures	2165.42	2165.68	2163.85	2164.11	5371.0
2014-11-25 03:00:00	ES	Futures	2164.11	2167.52	2163.59	2166.73	14377.0
2014-11-25 04:00:00	ES	Futures	2166.73	2169.35	2166.73	2168.57	13929.0
2014-11-25 05:00:00	ES	Futures	2168.3	2169.88	2168.3	2168.3	11677.0
2014-11-25 06:00:00	ES	Futures	2168.3	2169.09	2167.78	2168.04	11816.0
2014-11-25 07:00:00	ES	Futures	2168.04	2169.35	2167.78	2168.57	15354.0
2014-11-25 08:00:00	ES	Futures	2168.57	2172.23	2168.57	2170.4	34768.0
2014-11-25 09:00:00	ES	Futures	2170.4	2172.23	2166.99	2168.83	123189.0
2014-11-25 10:00:00	ES	Futures	2168.57	2168.83	2163.33	2164.11	187796.0
2014-11-25 11:00:00	ES	Futures	2163.85	2165.95	2161.49	2165.42	123853.0
2014-11-25 12:00:00	ES	Futures	2165.42	2169.61	2164.64	2167.78	75799.0
2014-11-25 13:00:00	ES	Futures	2167.52	2169.09	2166.73	2168.57	40501.0
2014-11-25 14:00:00	ES	Futures	2168.57	2169.09	2164.64	2165.95	66648.0
2014-11-25 15:00:00	ES	Futures	2165.68	2168.83	2164.64	2165.68	139959.0
2014-11-25 16:00:00	ES	Futures	2165.95	2167.78	2165.42	2167.26	80340.0
2014-11-25 17:00:00	ES	Futures	2167.26	2167.78	2166.99	2167.26	1062.0
2014-11-25 18:00:00	ES	Futures	2167.26	2167.78	2166.73	2167.26	2983.0
2014-11-25 19:00:00	ES	Futures	2167.52	2168.04	2166.99	2167.52	2411.0
2014-11-25 20:00:00	ES	Futures	2167.52	2168.04	2167.26	2167.78	1729.0
2014-11-25 21:00:00	ES	Futures	2167.78	2169.61	2167.26	2169.35	3259.0
2014-11-25 22:00:00	ES	Futures	2169.35	2170.4	2169.09	2170.14	2190.0
2014-11-25 23:00:00	ES	Futures	2170.14	2170.4	2169.61	2169.61	1661.0
2014-11-25 00:00:00	NQ	Futures	5013.91	5015.67	5013.33	5013.62	383.0
2014-11-25 01:00:00	NQ	Futures	5013.62	5018.02	5013.62	5018.02	348.0
2014-11-25 02:00:00	NQ	Futures	5018.02	5018.89	5015.09	5015.38	850.0
2014-11-25 03:00:00	NQ	Futures	5015.09	5022.41	5013.91	5021.24	1632.0
2014-11-25 04:00:00	NQ	Futures	5021.53	5027.39	5020.65	5025.63	2248.0
2014-11-25 05:00:00	NQ	Futures	5025.93	5029.44	5025.63	5027.39	1476.0
2014-11-25 06:00:00	NQ	Futures	5027.39	5029.15	5025.93	5026.51	1492.0
2014-11-25 07:00:00	NQ	Futures	5026.51	5030.32	5025.93	5029.15	2447.0
2014-11-25 08:00:00	NQ	Futures	5028.86	5032.67	5025.63	5029.74	5347.0
2014-11-25 09:00:00	NQ	Futures	5029.74	5043.51	5026.22	5033.84	36210.0
2014-11-25 10:00:00	NQ	Futures	5033.84	5037.94	5015.38	5028.56	37041.0
2014-11-25 11:00:00	NQ	Futures	5028.56	5033.55	5022.41	5030.62	18501.0
2014-11-25 12:00:00	NQ	Futures	5030.91	5032.96	5024.17	5025.93	12804.0
2014-11-25 13:00:00	NQ	Futures	5025.63	5035.6	5025.05	5032.37	8567.0
2014-11-25 14:00:00	NQ	Futures	5032.37	5034.13	5023.88	5027.1	10794.0
2014-11-25 15:00:00	NQ	Futures	5026.81	5034.13	5025.93	5027.98	19281.0
2014-11-25 16:00:00	NQ	Futures	5028.27	5033.84	5027.1	5032.67	4923.0
2014-11-25 17:00:00	NQ	Futures	5032.96	5033.84	5032.08	5033.84	349.0
2014-11-25 18:00:00	NQ	Futures	5032.67	5033.25	5030.91	5032.37	602.0
2014-11-25 19:00:00	NQ	Futures	5032.37	5034.13	5031.79	5032.96	491.0
2014-11-25 20:00:00	NQ	Futures	5032.96	5033.84	5032.37	5033.25	356.0
2014-11-25 21:00:00	NQ	Futures	5033.25	5037.94	5032.96	5037.65	552.0
2014-11-25 22:00:00	NQ	Futures	5037.65	5040.58	5036.77	5039.7	457.0
2014-11-25 23:00:00	NQ	Futures	5039.99	5041.46	5039.11	5039.41	488.0
2014-11-25 00:00:00	YM	Futures	18480.8	18488.0	18479.7	18483.9	431.0
2014-11-25 01:00:00	YM	Futures	18481.8	18495.3	18481.8	18495.3	432.0

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

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