PREVIEW / futures_1hour / 2008-07-04

all futures 1-hour files

  file:    by_date/futures_1hour/2008/2008-07-04.parquet
  size:    23 KB
  rows:    611

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-07-04 00:00:00	ES	Futures	1176.49	1176.95	1175.79	1176.72	436.0
2008-07-04 01:00:00	ES	Futures	1176.95	1177.65	1176.25	1176.95	951.0
2008-07-04 02:00:00	ES	Futures	1176.72	1179.97	1176.49	1178.81	1750.0
2008-07-04 03:00:00	ES	Futures	1178.81	1178.81	1173.47	1173.7	7721.0
2008-07-04 04:00:00	ES	Futures	1173.47	1175.32	1172.54	1175.09	4424.0
2008-07-04 05:00:00	ES	Futures	1175.09	1175.79	1173.23	1175.32	3318.0
2008-07-04 06:00:00	ES	Futures	1175.09	1175.32	1173.0	1173.23	2057.0
2008-07-04 07:00:00	ES	Futures	1173.23	1173.47	1170.68	1172.54	5095.0
2008-07-04 08:00:00	ES	Futures	1172.3	1172.54	1169.98	1171.61	3011.0
2008-07-04 09:00:00	ES	Futures	1171.37	1174.39	1170.68	1172.54	5451.0
2008-07-04 10:00:00	ES	Futures	1172.54	1172.77	1169.05	1169.05	8282.0
2008-07-04 11:00:00	ES	Futures	1169.05	1170.21	1168.12	1168.35	6814.0
2008-07-04 00:00:00	NQ	Futures	2048.91	2048.91	2048.34	2048.91	7.0
2008-07-04 01:00:00	NQ	Futures	2051.16	2051.72	2048.91	2050.6	25.0
2008-07-04 02:00:00	NQ	Futures	2050.03	2057.35	2048.34	2057.06	154.0
2008-07-04 03:00:00	NQ	Futures	2055.38	2055.38	2048.06	2052.0	380.0
2008-07-04 04:00:00	NQ	Futures	2051.16	2052.85	2046.09	2052.28	462.0
2008-07-04 05:00:00	NQ	Futures	2051.72	2053.69	2049.47	2051.72	249.0
2008-07-04 06:00:00	NQ	Futures	2052.0	2052.0	2048.34	2048.91	53.0
2008-07-04 07:00:00	NQ	Futures	2048.91	2049.47	2042.16	2048.63	526.0
2008-07-04 08:00:00	NQ	Futures	2047.78	2048.06	2042.72	2044.97	300.0
2008-07-04 09:00:00	NQ	Futures	2045.53	2050.6	2043.28	2047.78	833.0
2008-07-04 10:00:00	NQ	Futures	2046.94	2048.06	2040.75	2041.59	719.0
2008-07-04 11:00:00	NQ	Futures	2041.03	2044.41	2041.03	2042.16	580.0
2008-07-04 00:00:00	YM	Futures	10256.6	10262.1	10252.1	10252.1	52.0
2008-07-04 01:00:00	YM	Futures	10253.0	10259.4	10251.2	10256.6	94.0
2008-07-04 02:00:00	YM	Futures	10256.6	10271.2	10255.7	10268.5	80.0
2008-07-04 03:00:00	YM	Futures	10267.6	10267.6	10243.0	10245.7	307.0
2008-07-04 04:00:00	YM	Futures	10245.7	10257.6	10239.4	10257.6	412.0
2008-07-04 05:00:00	YM	Futures	10255.7	10259.4	10247.6	10257.6	204.0
2008-07-04 06:00:00	YM	Futures	10257.6	10257.6	10242.1	10242.1	165.0
2008-07-04 07:00:00	YM	Futures	10241.2	10242.1	10229.4	10238.5	227.0
2008-07-04 08:00:00	YM	Futures	10236.6	10236.6	10219.4	10230.3	170.0
2008-07-04 09:00:00	YM	Futures	10227.6	10251.2	10224.8	10234.8	413.0
2008-07-04 10:00:00	YM	Futures	10234.8	10239.4	10218.5	10222.1	406.0
2008-07-04 11:00:00	YM	Futures	10220.3	10224.8	10211.2	10212.1	571.0
2008-07-04 00:00:00	CL	Futures	551.27	551.8	550.47	551.72	152.0
2008-07-04 01:00:00	CL	Futures	551.68	551.87	551.23	551.34	162.0
2008-07-04 02:00:00	CL	Futures	551.53	551.64	550.58	551.3	216.0
2008-07-04 03:00:00	CL	Futures	551.38	552.86	551.38	552.71	738.0
2008-07-04 04:00:00	CL	Futures	552.59	552.63	549.33	549.9	1418.0
2008-07-04 05:00:00	CL	Futures	550.09	550.66	548.38	548.53	969.0
2008-07-04 06:00:00	CL	Futures	548.42	548.68	546.03	546.41	2272.0
2008-07-04 07:00:00	CL	Futures	546.41	548.15	546.26	546.52	1088.0
2008-07-04 08:00:00	CL	Futures	546.52	547.09	546.03	546.9	564.0
2008-07-04 09:00:00	CL	Futures	546.94	547.74	546.67	546.79	570.0
2008-07-04 10:00:00	CL	Futures	546.86	548.68	546.75	547.17	802.0
2008-07-04 11:00:00	CL	Futures	547.17	548.23	545.34	547.17	2549.0
2008-07-04 12:00:00	CL	Futures	547.2	547.51	545.91	545.91	459.0
2008-07-04 13:00:00	CL	Futures	545.88	547.62	545.88	547.32	357.0

> showing 50 of 611 rows — these rows as CSV

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