PREVIEW / futures_1hour / 2009-11-01

all futures 1-hour files

  file:    by_date/futures_1hour/2009/2009-11-01.parquet
  size:    13 KB
  rows:    241

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
2009-11-01 18:00:00	ES	Futures	999.16	1002.31	996.5	1002.07	20480.0
2009-11-01 19:00:00	ES	Futures	1002.07	1005.95	1001.34	1004.49	15711.0
2009-11-01 20:00:00	ES	Futures	1004.49	1005.22	1003.04	1004.01	7589.0
2009-11-01 21:00:00	ES	Futures	1004.01	1005.7	1003.28	1004.98	5184.0
2009-11-01 22:00:00	ES	Futures	1004.98	1005.7	1004.74	1005.22	4963.0
2009-11-01 23:00:00	ES	Futures	1005.22	1005.7	1003.52	1004.01	4342.0
2009-11-01 18:00:00	NQ	Futures	1894.83	1898.54	1885.42	1898.54	1367.0
2009-11-01 19:00:00	NQ	Futures	1898.25	1904.81	1896.83	1901.96	1408.0
2009-11-01 20:00:00	NQ	Futures	1902.25	1903.1	1899.39	1901.1	413.0
2009-11-01 21:00:00	NQ	Futures	1901.1	1904.24	1899.96	1902.82	305.0
2009-11-01 22:00:00	NQ	Futures	1902.82	1904.53	1902.82	1903.39	292.0
2009-11-01 23:00:00	NQ	Futures	1903.1	1904.24	1900.82	1901.39	171.0
2009-11-01 18:00:00	YM	Futures	8983.7	9004.2	8926.1	9004.2	859.0
2009-11-01 19:00:00	YM	Futures	9006.0	9032.1	8997.7	9021.9	822.0
2009-11-01 20:00:00	YM	Futures	9020.9	9025.6	9006.0	9014.4	528.0
2009-11-01 21:00:00	YM	Futures	9015.3	9031.2	9010.7	9022.8	389.0
2009-11-01 22:00:00	YM	Futures	9023.7	9029.3	9021.9	9023.7	236.0
2009-11-01 23:00:00	YM	Futures	9024.7	9029.3	9010.7	9016.3	161.0
2009-11-01 18:00:00	CL	Futures	172.1	172.17	171.07	171.45	1548.0
2009-11-01 19:00:00	CL	Futures	171.38	172.05	171.25	171.9	1211.0
2009-11-01 20:00:00	CL	Futures	171.94	172.08	171.7	171.76	676.0
2009-11-01 21:00:00	CL	Futures	171.76	172.75	171.61	172.61	1250.0
2009-11-01 22:00:00	CL	Futures	172.57	173.37	172.57	173.28	1359.0
2009-11-01 23:00:00	CL	Futures	173.28	173.57	173.13	173.26	724.0
2009-11-01 18:00:00	GC	Futures	1472.8	1473.8	1471.1	1473.8	1367.0
2009-11-01 19:00:00	GC	Futures	1473.8	1477.8	1473.1	1475.1	2117.0
2009-11-01 20:00:00	GC	Futures	1475.1	1475.4	1473.7	1474.4	737.0
2009-11-01 21:00:00	GC	Futures	1474.4	1474.8	1473.0	1474.5	795.0
2009-11-01 22:00:00	GC	Futures	1474.7	1475.2	1473.5	1475.1	625.0
2009-11-01 23:00:00	GC	Futures	1475.2	1476.5	1474.5	1475.5	520.0
2009-11-01 18:00:00	ZN	Futures	95.373747	95.41139	95.26082	95.26082	3607.0
2009-11-01 19:00:00	ZN	Futures	95.26082	95.273367	95.198082	95.210629	4258.0
2009-11-01 20:00:00	ZN	Futures	95.210629	95.273367	95.210629	95.223177	2356.0
2009-11-01 21:00:00	ZN	Futures	95.210629	95.26082	95.172987	95.172987	2371.0
2009-11-01 22:00:00	ZN	Futures	95.172987	95.185534	95.160439	95.160439	1829.0
2009-11-01 23:00:00	ZN	Futures	95.172987	95.185534	95.135344	95.172987	1461.0

> showing 36 of 241 rows — these rows as CSV

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