PREVIEW / futures_1hour / 2008-06-18

all futures 1-hour files

  file:    by_date/futures_1hour/2008/2008-06-18.parquet
  size:    42 KB
  rows:    1,210

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-18 00:00:00	ES	Futures	1258.3	1259.69	1258.3	1259.46	1734.0
2008-06-18 01:00:00	ES	Futures	1259.46	1259.92	1259.23	1259.23	952.0
2008-06-18 02:00:00	ES	Futures	1259.46	1260.16	1258.76	1259.23	2825.0
2008-06-18 03:00:00	ES	Futures	1259.46	1259.92	1258.3	1258.53	8398.0
2008-06-18 04:00:00	ES	Futures	1258.53	1258.76	1255.97	1258.76	10282.0
2008-06-18 05:00:00	ES	Futures	1258.53	1259.46	1256.21	1256.67	6843.0
2008-06-18 06:00:00	ES	Futures	1256.67	1256.67	1252.49	1254.11	15086.0
2008-06-18 07:00:00	ES	Futures	1254.11	1254.11	1247.84	1248.77	30146.0
2008-06-18 08:00:00	ES	Futures	1248.77	1250.39	1246.91	1249.93	45585.0
2008-06-18 09:00:00	ES	Futures	1249.93	1253.65	1248.07	1248.54	252076.0
2008-06-18 10:00:00	ES	Futures	1248.54	1250.86	1242.49	1244.35	398792.0
2008-06-18 11:00:00	ES	Futures	1244.58	1253.18	1243.89	1251.09	282644.0
2008-06-18 12:00:00	ES	Futures	1250.86	1251.56	1245.75	1246.91	136681.0
2008-06-18 13:00:00	ES	Futures	1247.14	1247.14	1241.1	1244.58	218779.0
2008-06-18 14:00:00	ES	Futures	1244.35	1248.07	1240.63	1246.91	258451.0
2008-06-18 15:00:00	ES	Futures	1246.91	1251.79	1243.89	1246.21	303436.0
2008-06-18 16:00:00	ES	Futures	1246.44	1246.68	1243.89	1243.89	70133.0
2008-06-18 17:00:00	ES	Futures	1244.12	1244.12	1243.19	1243.42	1373.0
2008-06-18 18:00:00	ES	Futures	1243.65	1243.89	1242.96	1243.65	1422.0
2008-06-18 19:00:00	ES	Futures	1243.42	1244.35	1242.49	1243.65	1766.0
2008-06-18 20:00:00	ES	Futures	1243.89	1244.82	1243.65	1244.35	1118.0
2008-06-18 21:00:00	ES	Futures	1244.58	1245.05	1243.89	1244.12	1242.0
2008-06-18 22:00:00	ES	Futures	1244.35	1245.05	1243.65	1243.65	887.0
2008-06-18 23:00:00	ES	Futures	1243.89	1244.58	1242.96	1243.42	1172.0
2008-06-18 00:00:00	NQ	Futures	2234.28	2237.93	2234.28	2237.93	174.0
2008-06-18 01:00:00	NQ	Futures	2237.37	2238.21	2237.09	2237.37	63.0
2008-06-18 02:00:00	NQ	Futures	2237.37	2237.93	2235.96	2237.37	325.0
2008-06-18 03:00:00	NQ	Futures	2237.37	2238.78	2235.12	2236.25	1036.0
2008-06-18 04:00:00	NQ	Futures	2236.25	2236.53	2231.46	2235.4	1163.0
2008-06-18 05:00:00	NQ	Futures	2235.68	2238.78	2232.59	2233.71	870.0
2008-06-18 06:00:00	NQ	Futures	2233.71	2234.0	2226.12	2230.34	1603.0
2008-06-18 07:00:00	NQ	Futures	2230.34	2230.34	2217.4	2219.93	2845.0
2008-06-18 08:00:00	NQ	Futures	2220.49	2222.18	2213.46	2219.65	7244.0
2008-06-18 09:00:00	NQ	Futures	2219.93	2222.46	2210.09	2210.93	51708.0
2008-06-18 10:00:00	NQ	Futures	2211.21	2217.12	2196.87	2199.96	84604.0
2008-06-18 11:00:00	NQ	Futures	2199.96	2226.12	2198.55	2222.46	66463.0
2008-06-18 12:00:00	NQ	Futures	2222.46	2223.31	2207.27	2210.65	33669.0
2008-06-18 13:00:00	NQ	Futures	2210.37	2210.93	2199.4	2206.99	41349.0
2008-06-18 14:00:00	NQ	Futures	2206.71	2212.62	2198.83	2209.52	40570.0
2008-06-18 15:00:00	NQ	Futures	2209.8	2220.21	2204.74	2205.3	66222.0
2008-06-18 16:00:00	NQ	Futures	2205.3	2208.68	2202.49	2203.34	10429.0
2008-06-18 17:00:00	NQ	Futures	2203.34	2203.34	2200.52	2201.08	605.0
2008-06-18 18:00:00	NQ	Futures	2201.08	2202.49	2199.4	2201.37	711.0
2008-06-18 19:00:00	NQ	Futures	2201.37	2203.62	2200.8	2201.65	222.0
2008-06-18 20:00:00	NQ	Futures	2203.9	2205.3	2203.05	2204.74	115.0
2008-06-18 21:00:00	NQ	Futures	2205.3	2205.87	2204.18	2204.74	64.0
2008-06-18 22:00:00	NQ	Futures	2204.74	2204.74	2203.05	2203.34	33.0
2008-06-18 23:00:00	NQ	Futures	2203.34	2203.34	2196.58	2199.68	583.0
2008-06-18 00:00:00	YM	Futures	11071.0	11085.5	11071.0	11082.8	393.0
2008-06-18 01:00:00	YM	Futures	11082.8	11085.5	11078.3	11078.3	187.0

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

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