PREVIEW / futures_1hour / 2010-03-26

all futures 1-hour files

  file:    by_date/futures_1hour/2010/2010-03-26.parquet
  size:    37 KB
  rows:    1,099

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
2010-03-26 00:00:00	ES	Futures	1137.32	1137.8	1136.34	1137.32	4277.0
2010-03-26 01:00:00	ES	Futures	1137.32	1138.05	1136.58	1137.8	5048.0
2010-03-26 02:00:00	ES	Futures	1137.8	1138.78	1137.56	1138.29	4255.0
2010-03-26 03:00:00	ES	Futures	1138.29	1139.52	1137.56	1139.52	17449.0
2010-03-26 04:00:00	ES	Futures	1139.52	1140.98	1137.56	1138.05	32863.0
2010-03-26 05:00:00	ES	Futures	1137.8	1140.74	1137.8	1139.52	20254.0
2010-03-26 06:00:00	ES	Futures	1139.52	1140.0	1138.29	1138.78	12507.0
2010-03-26 07:00:00	ES	Futures	1138.78	1140.74	1138.54	1140.0	18845.0
2010-03-26 08:00:00	ES	Futures	1140.0	1142.2	1138.78	1139.52	56648.0
2010-03-26 09:00:00	ES	Futures	1139.52	1140.74	1136.34	1139.52	232489.0
2010-03-26 10:00:00	ES	Futures	1139.52	1143.67	1139.52	1141.23	334802.0
2010-03-26 11:00:00	ES	Futures	1141.23	1142.69	1140.49	1140.74	158268.0
2010-03-26 12:00:00	ES	Futures	1140.49	1141.72	1133.4	1134.63	325687.0
2010-03-26 13:00:00	ES	Futures	1134.87	1135.6	1130.72	1133.89	294517.0
2010-03-26 14:00:00	ES	Futures	1133.65	1137.8	1131.94	1135.12	264518.0
2010-03-26 15:00:00	ES	Futures	1135.12	1136.58	1133.65	1135.85	250676.0
2010-03-26 16:00:00	ES	Futures	1136.09	1137.8	1135.85	1137.32	74805.0
2010-03-26 00:00:00	NQ	Futures	2234.28	2235.14	2233.13	2234.57	229.0
2010-03-26 01:00:00	NQ	Futures	2234.57	2235.14	2233.71	2235.14	362.0
2010-03-26 02:00:00	NQ	Futures	2235.14	2236.57	2234.57	2236.57	354.0
2010-03-26 03:00:00	NQ	Futures	2236.0	2239.15	2235.71	2238.86	955.0
2010-03-26 04:00:00	NQ	Futures	2239.15	2240.87	2235.71	2236.57	1674.0
2010-03-26 05:00:00	NQ	Futures	2236.57	2239.72	2236.57	2237.72	851.0
2010-03-26 06:00:00	NQ	Futures	2238.29	2239.15	2236.57	2237.14	661.0
2010-03-26 07:00:00	NQ	Futures	2237.14	2243.16	2237.14	2242.01	2302.0
2010-03-26 08:00:00	NQ	Futures	2241.72	2244.3	2237.72	2239.15	4996.0
2010-03-26 09:00:00	NQ	Futures	2239.15	2246.31	2236.0	2240.87	34534.0
2010-03-26 10:00:00	NQ	Futures	2241.15	2248.6	2239.15	2240.29	45761.0
2010-03-26 11:00:00	NQ	Futures	2240.29	2245.16	2239.72	2240.58	25078.0
2010-03-26 12:00:00	NQ	Futures	2240.58	2242.87	2225.69	2227.12	46137.0
2010-03-26 13:00:00	NQ	Futures	2227.12	2229.12	2221.39	2224.54	41242.0
2010-03-26 14:00:00	NQ	Futures	2224.54	2233.99	2221.39	2229.98	36582.0
2010-03-26 15:00:00	NQ	Futures	2230.27	2234.85	2227.12	2233.42	35064.0
2010-03-26 16:00:00	NQ	Futures	2233.71	2235.14	2232.27	2234.57	7597.0
2010-03-26 00:00:00	YM	Futures	10160.7	10165.4	10157.9	10163.5	257.0
2010-03-26 01:00:00	YM	Futures	10163.5	10170.1	10158.8	10165.4	335.0
2010-03-26 02:00:00	YM	Futures	10167.3	10177.6	10167.3	10172.0	574.0
2010-03-26 03:00:00	YM	Futures	10171.1	10178.6	10165.4	10177.6	1031.0
2010-03-26 04:00:00	YM	Futures	10177.6	10188.0	10166.3	10170.1	1578.0
2010-03-26 05:00:00	YM	Futures	10171.1	10187.0	10171.1	10180.5	744.0
2010-03-26 06:00:00	YM	Futures	10179.5	10183.3	10172.0	10173.9	525.0
2010-03-26 07:00:00	YM	Futures	10172.9	10185.2	10172.9	10181.4	321.0
2010-03-26 08:00:00	YM	Futures	10182.3	10198.3	10170.1	10174.8	2624.0
2010-03-26 09:00:00	YM	Futures	10174.8	10185.2	10151.3	10174.8	15539.0
2010-03-26 10:00:00	YM	Futures	10175.8	10203.0	10175.8	10190.8	22054.0
2010-03-26 11:00:00	YM	Futures	10190.8	10206.8	10185.2	10188.0	10833.0
2010-03-26 12:00:00	YM	Futures	10188.0	10195.5	10139.1	10148.5	20766.0
2010-03-26 13:00:00	YM	Futures	10148.5	10159.8	10118.4	10146.6	17594.0
2010-03-26 14:00:00	YM	Futures	10146.6	10171.1	10130.6	10147.5	14320.0
2010-03-26 15:00:00	YM	Futures	10147.5	10157.9	10135.3	10150.4	14379.0

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

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