PREVIEW / futures_1hour / 2010-04-02

all futures 1-hour files

  file:    by_date/futures_1hour/2010/2010-04-02.parquet
  size:    14 KB
  rows:    263

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-04-02 00:00:00	ES	Futures	1145.14	1145.63	1144.89	1145.38	854.0
2010-04-02 01:00:00	ES	Futures	1145.38	1145.87	1145.38	1145.87	641.0
2010-04-02 02:00:00	ES	Futures	1145.87	1146.85	1145.63	1146.85	1917.0
2010-04-02 03:00:00	ES	Futures	1146.6	1146.85	1146.36	1146.6	279.0
2010-04-02 04:00:00	ES	Futures	1146.85	1146.85	1146.11	1146.11	253.0
2010-04-02 05:00:00	ES	Futures	1146.36	1146.85	1146.36	1146.36	586.0
2010-04-02 06:00:00	ES	Futures	1146.36	1146.85	1146.11	1146.36	1076.0
2010-04-02 07:00:00	ES	Futures	1146.36	1146.6	1145.63	1146.11	1795.0
2010-04-02 08:00:00	ES	Futures	1146.11	1152.47	1144.16	1150.27	62999.0
2010-04-02 09:00:00	ES	Futures	1150.27	1152.23	1150.03	1151.74	16287.0
2010-04-02 00:00:00	NQ	Futures	2236.0	2236.86	2235.71	2236.0	120.0
2010-04-02 01:00:00	NQ	Futures	2236.28	2236.57	2235.42	2235.71	62.0
2010-04-02 02:00:00	NQ	Futures	2236.28	2237.43	2236.0	2237.43	104.0
2010-04-02 03:00:00	NQ	Futures	2237.14	2238.29	2237.14	2238.29	72.0
2010-04-02 04:00:00	NQ	Futures	2238.0	2238.29	2237.72	2238.0	103.0
2010-04-02 05:00:00	NQ	Futures	2237.72	2238.29	2237.72	2238.0	23.0
2010-04-02 06:00:00	NQ	Futures	2238.0	2238.86	2237.72	2238.29	33.0
2010-04-02 07:00:00	NQ	Futures	2238.0	2238.0	2236.0	2236.57	261.0
2010-04-02 08:00:00	NQ	Futures	2236.86	2248.02	2232.27	2245.16	3830.0
2010-04-02 09:00:00	NQ	Futures	2245.16	2247.45	2244.59	2246.88	832.0
2010-04-02 00:00:00	YM	Futures	10208.7	10209.6	10206.8	10208.7	46.0
2010-04-02 01:00:00	YM	Futures	10209.6	10212.5	10209.6	10209.6	101.0
2010-04-02 02:00:00	YM	Futures	10211.5	10220.0	10209.6	10220.0	47.0
2010-04-02 03:00:00	YM	Futures	10217.2	10218.1	10213.4	10213.4	8.0
2010-04-02 04:00:00	YM	Futures	10214.3	10219.0	10210.6	10215.3	43.0
2010-04-02 05:00:00	YM	Futures	10218.1	10219.0	10217.2	10217.2	40.0
2010-04-02 06:00:00	YM	Futures	10213.4	10220.0	10213.4	10214.3	45.0
2010-04-02 07:00:00	YM	Futures	10218.1	10220.0	10211.5	10216.2	219.0
2010-04-02 08:00:00	YM	Futures	10213.4	10253.9	10195.5	10243.5	1887.0
2010-04-02 09:00:00	YM	Futures	10241.6	10254.8	10239.7	10252.9	723.0
2010-04-02 00:00:00	ZN	Futures	95.406824	95.406824	95.368281	95.368281	1269.0
2010-04-02 01:00:00	ZN	Futures	95.381129	95.393976	95.368281	95.381129	934.0
2010-04-02 02:00:00	ZN	Futures	95.381129	95.381129	95.342586	95.342586	1236.0
2010-04-02 03:00:00	ZN	Futures	95.342586	95.355433	95.329738	95.342586	791.0
2010-04-02 04:00:00	ZN	Futures	95.342586	95.342586	95.329738	95.342586	320.0
2010-04-02 05:00:00	ZN	Futures	95.342586	95.342586	95.31689	95.31689	1313.0
2010-04-02 06:00:00	ZN	Futures	95.304043	95.329738	95.304043	95.329738	1196.0
2010-04-02 07:00:00	ZN	Futures	95.329738	95.393976	95.31689	95.368281	9306.0
2010-04-02 08:00:00	ZN	Futures	95.368281	95.638082	95.008546	95.034241	155745.0
2010-04-02 09:00:00	ZN	Futures	95.021394	95.111327	94.892917	94.892917	82295.0
2010-04-02 10:00:00	ZN	Futures	94.905765	94.957155	94.815831	94.841526	56863.0
2010-04-02 11:00:00	ZN	Futures	94.841526	94.867222	94.815831	94.828679	10334.0

> showing 42 of 263 rows — these rows as CSV

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