PREVIEW / futures_1hour / 2008-06-20

all futures 1-hour files

  file:    by_date/futures_1hour/2008/2008-06-20.parquet
  size:    36 KB
  rows:    982

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
2008-06-20 00:00:00	ES	Futures	1244.82	1245.75	1244.12	1244.82	859.0
2008-06-20 01:00:00	ES	Futures	1245.05	1245.51	1243.65	1244.35	991.0
2008-06-20 02:00:00	ES	Futures	1244.12	1246.21	1243.65	1244.58	4312.0
2008-06-20 03:00:00	ES	Futures	1244.58	1247.14	1243.65	1243.89	14412.0
2008-06-20 04:00:00	ES	Futures	1243.65	1244.82	1243.19	1244.58	8366.0
2008-06-20 05:00:00	ES	Futures	1244.58	1245.75	1244.35	1244.58	8355.0
2008-06-20 06:00:00	ES	Futures	1244.58	1245.51	1240.63	1240.63	16051.0
2008-06-20 07:00:00	ES	Futures	1240.63	1241.33	1237.15	1238.31	62830.0
2008-06-20 08:00:00	ES	Futures	1238.08	1241.1	1237.61	1239.24	58540.0
2008-06-20 09:00:00	ES	Futures	1239.24	1242.03	1234.82	1236.45	378307.0
2008-06-20 10:00:00	ES	Futures	1236.45	1236.68	1230.17	1234.13	429187.0
2008-06-20 11:00:00	ES	Futures	1234.13	1239.47	1233.2	1235.98	259071.0
2008-06-20 12:00:00	ES	Futures	1235.98	1236.45	1233.2	1234.13	110277.0
2008-06-20 13:00:00	ES	Futures	1234.36	1237.15	1227.85	1228.78	225335.0
2008-06-20 14:00:00	ES	Futures	1228.78	1229.71	1222.74	1223.43	248017.0
2008-06-20 15:00:00	ES	Futures	1223.43	1229.94	1222.74	1226.22	350723.0
2008-06-20 16:00:00	ES	Futures	1226.22	1227.39	1225.29	1225.76	106621.0
2008-06-20 00:00:00	NQ	Futures	2236.81	2236.81	2234.0	2235.12	228.0
2008-06-20 01:00:00	NQ	Futures	2236.25	2236.81	2234.0	2235.68	67.0
2008-06-20 02:00:00	NQ	Futures	2236.25	2237.93	2233.43	2234.0	372.0
2008-06-20 03:00:00	NQ	Futures	2234.0	2236.81	2231.46	2232.03	2619.0
2008-06-20 04:00:00	NQ	Futures	2232.03	2233.43	2229.78	2232.31	813.0
2008-06-20 05:00:00	NQ	Futures	2232.31	2235.68	2231.18	2234.84	634.0
2008-06-20 06:00:00	NQ	Futures	2234.56	2235.4	2227.24	2227.24	1424.0
2008-06-20 07:00:00	NQ	Futures	2227.24	2228.65	2221.34	2225.56	6084.0
2008-06-20 08:00:00	NQ	Futures	2225.28	2227.24	2221.62	2223.03	8878.0
2008-06-20 09:00:00	NQ	Futures	2222.46	2227.24	2203.34	2205.02	67515.0
2008-06-20 10:00:00	NQ	Futures	2205.02	2206.15	2181.96	2191.24	123476.0
2008-06-20 11:00:00	NQ	Futures	2191.24	2197.71	2185.61	2193.77	62055.0
2008-06-20 12:00:00	NQ	Futures	2193.77	2194.9	2185.61	2187.02	37785.0
2008-06-20 13:00:00	NQ	Futures	2187.02	2193.77	2177.18	2182.52	65811.0
2008-06-20 14:00:00	NQ	Futures	2182.8	2183.93	2171.83	2173.24	61666.0
2008-06-20 15:00:00	NQ	Futures	2173.24	2184.77	2168.74	2179.99	77918.0
2008-06-20 16:00:00	NQ	Futures	2179.71	2187.58	2178.3	2183.64	19720.0
2008-06-20 00:00:00	YM	Futures	10931.9	10936.5	10923.8	10930.1	87.0
2008-06-20 01:00:00	YM	Futures	10928.3	10932.8	10921.9	10923.8	124.0
2008-06-20 02:00:00	YM	Futures	10923.8	10937.4	10919.2	10927.4	440.0
2008-06-20 03:00:00	YM	Futures	10927.4	10946.5	10920.1	10922.8	669.0
2008-06-20 04:00:00	YM	Futures	10921.9	10928.3	10916.5	10928.3	627.0
2008-06-20 05:00:00	YM	Futures	10927.4	10935.6	10926.5	10931.0	573.0
2008-06-20 06:00:00	YM	Futures	10929.2	10933.8	10892.9	10892.9	1001.0
2008-06-20 07:00:00	YM	Futures	10892.9	10900.1	10863.8	10875.6	2936.0
2008-06-20 08:00:00	YM	Futures	10875.6	10892.9	10871.0	10882.9	2311.0
2008-06-20 09:00:00	YM	Futures	10881.0	10908.3	10828.3	10839.2	29956.0
2008-06-20 10:00:00	YM	Futures	10840.1	10840.1	10792.9	10828.3	35816.0
2008-06-20 11:00:00	YM	Futures	10828.3	10867.4	10821.1	10845.6	25453.0
2008-06-20 12:00:00	YM	Futures	10846.5	10852.0	10825.6	10840.1	11810.0
2008-06-20 13:00:00	YM	Futures	10840.1	10862.9	10783.8	10786.5	24112.0
2008-06-20 14:00:00	YM	Futures	10785.6	10792.9	10741.1	10746.5	27065.0
2008-06-20 15:00:00	YM	Futures	10746.5	10796.5	10739.3	10763.8	30689.0

> showing 50 of 982 rows — these rows as CSV

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