PREVIEW / futures_1hour / 2008-02-19

all futures 1-hour files

  file:    by_date/futures_1hour/2008/2008-02-19.parquet
  size:    33 KB
  rows:    897

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-02-19 00:00:00	ES	Futures	1272.33	1273.27	1271.63	1271.87	1449.0
2008-02-19 01:00:00	ES	Futures	1271.63	1273.03	1271.4	1272.1	1226.0
2008-02-19 02:00:00	ES	Futures	1271.87	1272.57	1269.54	1271.17	6235.0
2008-02-19 03:00:00	ES	Futures	1271.4	1273.73	1267.44	1268.6	19250.0
2008-02-19 04:00:00	ES	Futures	1268.6	1268.6	1264.17	1265.8	20446.0
2008-02-19 05:00:00	ES	Futures	1265.57	1268.14	1265.11	1267.67	12274.0
2008-02-19 06:00:00	ES	Futures	1267.44	1271.63	1265.57	1270.93	25071.0
2008-02-19 07:00:00	ES	Futures	1270.7	1273.73	1268.6	1272.8	30380.0
2008-02-19 08:00:00	ES	Futures	1272.8	1277.46	1272.57	1273.97	53435.0
2008-02-19 09:00:00	ES	Futures	1273.97	1276.3	1269.54	1270.0	172096.0
2008-02-19 10:00:00	ES	Futures	1270.0	1272.57	1265.34	1267.44	228956.0
2008-02-19 11:00:00	ES	Futures	1267.67	1268.6	1262.54	1267.44	163346.0
2008-02-19 12:00:00	ES	Futures	1267.44	1270.0	1265.11	1265.57	107826.0
2008-02-19 13:00:00	ES	Futures	1265.57	1272.33	1265.57	1267.9	144189.0
2008-02-19 14:00:00	ES	Futures	1267.9	1270.93	1257.64	1258.11	213369.0
2008-02-19 15:00:00	ES	Futures	1257.88	1261.84	1254.61	1258.58	290592.0
2008-02-19 16:00:00	ES	Futures	1258.34	1264.41	1258.34	1262.07	83916.0
2008-02-19 17:00:00	ES	Futures	1262.31	1262.54	1261.61	1261.84	2464.0
2008-02-19 18:00:00	ES	Futures	1261.84	1262.31	1260.68	1261.84	4201.0
2008-02-19 19:00:00	ES	Futures	1261.84	1262.07	1259.98	1260.44	2764.0
2008-02-19 20:00:00	ES	Futures	1260.68	1261.14	1259.28	1259.98	2584.0
2008-02-19 21:00:00	ES	Futures	1259.74	1260.91	1259.04	1260.44	2082.0
2008-02-19 22:00:00	ES	Futures	1260.21	1260.91	1257.64	1258.34	2270.0
2008-02-19 23:00:00	ES	Futures	1258.58	1258.58	1256.25	1256.71	5562.0
2008-02-19 00:00:00	NQ	Futures	2058.15	2059.57	2056.16	2056.16	132.0
2008-02-19 01:00:00	NQ	Futures	2056.16	2058.15	2055.88	2056.16	153.0
2008-02-19 02:00:00	NQ	Futures	2056.16	2057.3	2052.76	2055.03	599.0
2008-02-19 03:00:00	NQ	Futures	2055.31	2058.72	2049.92	2051.05	1786.0
2008-02-19 04:00:00	NQ	Futures	2050.77	2050.77	2043.39	2044.53	2232.0
2008-02-19 05:00:00	NQ	Futures	2044.81	2049.64	2044.24	2047.65	774.0
2008-02-19 06:00:00	NQ	Futures	2047.36	2055.6	2045.95	2054.46	1672.0
2008-02-19 07:00:00	NQ	Futures	2054.74	2056.73	2048.22	2053.61	5465.0
2008-02-19 08:00:00	NQ	Futures	2053.33	2061.56	2052.19	2053.33	10796.0
2008-02-19 09:00:00	NQ	Futures	2053.04	2059.29	2043.11	2044.24	39622.0
2008-02-19 10:00:00	NQ	Futures	2044.24	2048.5	2036.86	2039.42	50187.0
2008-02-19 11:00:00	NQ	Futures	2039.7	2041.4	2033.17	2040.84	33562.0
2008-02-19 12:00:00	NQ	Futures	2041.12	2046.51	2036.58	2037.15	24800.0
2008-02-19 13:00:00	NQ	Futures	2037.43	2048.22	2034.59	2036.29	33302.0
2008-02-19 14:00:00	NQ	Futures	2036.01	2036.86	2007.63	2007.91	60694.0
2008-02-19 15:00:00	NQ	Futures	2007.63	2011.88	2000.53	2009.05	70017.0
2008-02-19 16:00:00	NQ	Futures	2009.33	2023.52	2008.19	2020.4	17733.0
2008-02-19 17:00:00	NQ	Futures	2020.97	2022.1	2020.68	2021.25	190.0
2008-02-19 18:00:00	NQ	Futures	2022.1	2022.39	2020.4	2021.82	270.0
2008-02-19 19:00:00	NQ	Futures	2021.53	2021.82	2019.26	2020.12	286.0
2008-02-19 20:00:00	NQ	Futures	2020.12	2021.25	2018.41	2018.41	410.0
2008-02-19 21:00:00	NQ	Futures	2019.26	2020.12	2018.13	2018.41	241.0
2008-02-19 22:00:00	NQ	Futures	2019.83	2022.39	2016.43	2017.56	247.0
2008-02-19 23:00:00	NQ	Futures	2016.99	2019.55	2015.57	2016.14	225.0
2008-02-19 00:00:00	YM	Futures	11329.0	11329.9	11317.2	11317.2	76.0
2008-02-19 01:00:00	YM	Futures	11317.2	11336.2	11313.5	11324.4	160.0

> showing 50 of 897 rows — these rows as CSV

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