PREVIEW / futures_1hour / 2010-01-29

all futures 1-hour files

  file:    by_date/futures_1hour/2010/2010-01-29.parquet
  size:    40 KB
  rows:    1,133

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-01-29 00:00:00	ES	Futures	1046.26	1047.47	1043.34	1043.82	11406.0
2010-01-29 01:00:00	ES	Futures	1044.07	1045.77	1041.63	1045.04	11016.0
2010-01-29 02:00:00	ES	Futures	1044.8	1051.61	1044.8	1050.88	20271.0
2010-01-29 03:00:00	ES	Futures	1050.63	1053.55	1050.15	1052.34	39683.0
2010-01-29 04:00:00	ES	Futures	1052.58	1053.07	1049.18	1049.66	18554.0
2010-01-29 05:00:00	ES	Futures	1049.42	1052.58	1047.72	1051.61	22045.0
2010-01-29 06:00:00	ES	Futures	1051.61	1054.53	1050.88	1052.34	23320.0
2010-01-29 07:00:00	ES	Futures	1052.34	1054.53	1051.85	1053.8	27951.0
2010-01-29 08:00:00	ES	Futures	1053.8	1059.39	1053.31	1057.2	143137.0
2010-01-29 09:00:00	ES	Futures	1057.45	1061.09	1053.31	1059.15	325568.0
2010-01-29 10:00:00	ES	Futures	1059.15	1063.77	1056.23	1058.66	414377.0
2010-01-29 11:00:00	ES	Futures	1058.91	1059.39	1050.15	1050.15	386782.0
2010-01-29 12:00:00	ES	Futures	1050.39	1054.77	1048.69	1054.53	212633.0
2010-01-29 13:00:00	ES	Futures	1054.53	1055.26	1048.2	1049.9	196777.0
2010-01-29 14:00:00	ES	Futures	1050.15	1052.09	1042.85	1045.53	344841.0
2010-01-29 15:00:00	ES	Futures	1045.77	1046.26	1038.72	1040.66	616091.0
2010-01-29 16:00:00	ES	Futures	1040.66	1041.15	1037.74	1039.93	162384.0
2010-01-29 00:00:00	NQ	Futures	2017.97	2020.54	2013.11	2013.69	800.0
2010-01-29 01:00:00	NQ	Futures	2014.26	2019.11	2011.4	2017.11	930.0
2010-01-29 02:00:00	NQ	Futures	2017.4	2029.11	2017.11	2028.82	1908.0
2010-01-29 03:00:00	NQ	Futures	2028.54	2031.97	2026.82	2029.11	4333.0
2010-01-29 04:00:00	NQ	Futures	2029.11	2030.25	2022.83	2022.83	2742.0
2010-01-29 05:00:00	NQ	Futures	2022.83	2026.82	2019.11	2024.82	2745.0
2010-01-29 06:00:00	NQ	Futures	2024.54	2029.97	2023.4	2025.97	3162.0
2010-01-29 07:00:00	NQ	Futures	2025.68	2031.97	2025.11	2030.54	2020.0
2010-01-29 08:00:00	NQ	Futures	2030.25	2043.96	2028.54	2043.39	17513.0
2010-01-29 09:00:00	NQ	Futures	2043.39	2044.25	2032.25	2037.11	60912.0
2010-01-29 10:00:00	NQ	Futures	2037.11	2041.39	2023.11	2027.11	66857.0
2010-01-29 11:00:00	NQ	Futures	2027.11	2027.97	2006.83	2007.69	92248.0
2010-01-29 12:00:00	NQ	Futures	2007.69	2014.54	2002.83	2013.11	43920.0
2010-01-29 13:00:00	NQ	Futures	2012.83	2015.11	1996.26	1998.83	42629.0
2010-01-29 14:00:00	NQ	Futures	1998.83	2001.97	1980.84	1985.69	69210.0
2010-01-29 15:00:00	NQ	Futures	1985.41	1994.26	1978.55	1986.27	95130.0
2010-01-29 16:00:00	NQ	Futures	1986.55	1987.69	1981.98	1986.55	19292.0
2010-01-29 00:00:00	YM	Futures	9387.1	9397.4	9367.5	9369.3	669.0
2010-01-29 01:00:00	YM	Futures	9369.3	9383.4	9360.9	9376.8	1488.0
2010-01-29 02:00:00	YM	Futures	9378.7	9426.4	9377.8	9420.8	1424.0
2010-01-29 03:00:00	YM	Futures	9420.8	9441.4	9417.1	9433.9	2964.0
2010-01-29 04:00:00	YM	Futures	9434.9	9438.6	9410.5	9415.2	1117.0
2010-01-29 05:00:00	YM	Futures	9414.3	9436.7	9400.2	9428.3	1363.0
2010-01-29 06:00:00	YM	Futures	9430.2	9451.7	9425.5	9435.8	1135.0
2010-01-29 07:00:00	YM	Futures	9434.9	9455.4	9431.1	9448.9	1278.0
2010-01-29 08:00:00	YM	Futures	9448.9	9487.3	9445.1	9477.9	5206.0
2010-01-29 09:00:00	YM	Futures	9477.9	9502.2	9440.5	9490.1	24992.0
2010-01-29 10:00:00	YM	Futures	9491.0	9537.8	9466.7	9500.4	27310.0
2010-01-29 11:00:00	YM	Futures	9499.4	9505.0	9430.2	9430.2	29076.0
2010-01-29 12:00:00	YM	Futures	9431.1	9474.2	9415.2	9473.2	16764.0
2010-01-29 13:00:00	YM	Futures	9473.2	9479.8	9422.7	9436.7	12194.0
2010-01-29 14:00:00	YM	Futures	9437.7	9455.4	9386.2	9408.7	20749.0
2010-01-29 15:00:00	YM	Futures	9407.7	9417.1	9356.2	9368.4	33528.0

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

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