PREVIEW / futures_1hour / 2010-01-22

all futures 1-hour files

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

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-22 00:00:00	ES	Futures	1082.02	1082.74	1081.04	1081.77	5773.0
2010-01-22 01:00:00	ES	Futures	1081.77	1084.2	1081.53	1082.74	7713.0
2010-01-22 02:00:00	ES	Futures	1082.99	1083.96	1082.02	1083.23	16895.0
2010-01-22 03:00:00	ES	Futures	1082.99	1085.66	1082.02	1084.69	40256.0
2010-01-22 04:00:00	ES	Futures	1084.45	1085.42	1083.23	1084.2	23176.0
2010-01-22 05:00:00	ES	Futures	1084.45	1084.93	1081.04	1081.53	19480.0
2010-01-22 06:00:00	ES	Futures	1081.77	1082.99	1074.96	1076.91	71036.0
2010-01-22 07:00:00	ES	Futures	1076.66	1080.07	1076.66	1078.85	57394.0
2010-01-22 08:00:00	ES	Futures	1079.1	1080.8	1076.42	1076.66	72987.0
2010-01-22 09:00:00	ES	Futures	1076.42	1081.77	1075.69	1078.85	422743.0
2010-01-22 10:00:00	ES	Futures	1078.61	1079.83	1071.31	1079.1	594659.0
2010-01-22 11:00:00	ES	Futures	1078.85	1081.53	1076.42	1077.64	326490.0
2010-01-22 12:00:00	ES	Futures	1077.39	1080.07	1075.69	1076.42	217659.0
2010-01-22 13:00:00	ES	Futures	1076.42	1076.91	1071.55	1073.01	249900.0
2010-01-22 14:00:00	ES	Futures	1073.01	1074.47	1066.2	1066.2	374094.0
2010-01-22 15:00:00	ES	Futures	1066.45	1068.64	1056.96	1058.42	784546.0
2010-01-22 16:00:00	ES	Futures	1058.42	1062.31	1057.69	1062.07	203103.0
2010-01-22 00:00:00	NQ	Futures	2104.52	2106.23	2103.94	2105.09	557.0
2010-01-22 01:00:00	NQ	Futures	2105.09	2110.51	2104.8	2107.66	634.0
2010-01-22 02:00:00	NQ	Futures	2107.37	2110.23	2106.23	2108.51	982.0
2010-01-22 03:00:00	NQ	Futures	2109.09	2112.8	2107.66	2109.94	4797.0
2010-01-22 04:00:00	NQ	Futures	2109.66	2111.66	2107.66	2110.8	2225.0
2010-01-22 05:00:00	NQ	Futures	2110.51	2111.37	2105.94	2106.51	2937.0
2010-01-22 06:00:00	NQ	Futures	2106.51	2109.09	2097.09	2100.23	6134.0
2010-01-22 07:00:00	NQ	Futures	2100.52	2105.94	2099.95	2104.23	3609.0
2010-01-22 08:00:00	NQ	Futures	2104.23	2109.37	2102.52	2104.52	7977.0
2010-01-22 09:00:00	NQ	Futures	2104.8	2110.8	2097.66	2103.66	61522.0
2010-01-22 10:00:00	NQ	Futures	2103.94	2103.94	2083.95	2092.8	86528.0
2010-01-22 11:00:00	NQ	Futures	2092.52	2101.37	2090.52	2093.38	53641.0
2010-01-22 12:00:00	NQ	Futures	2093.09	2096.52	2089.95	2091.09	32380.0
2010-01-22 13:00:00	NQ	Futures	2091.09	2091.66	2081.95	2085.66	39161.0
2010-01-22 14:00:00	NQ	Futures	2085.66	2087.95	2062.81	2064.81	72778.0
2010-01-22 15:00:00	NQ	Futures	2064.81	2070.53	2044.53	2049.67	126650.0
2010-01-22 16:00:00	NQ	Futures	2049.96	2055.39	2046.53	2053.1	20282.0
2010-01-22 00:00:00	YM	Futures	9680.0	9683.8	9673.5	9677.2	311.0
2010-01-22 01:00:00	YM	Futures	9677.2	9695.9	9675.4	9684.7	567.0
2010-01-22 02:00:00	YM	Futures	9685.7	9694.1	9681.0	9691.3	978.0
2010-01-22 03:00:00	YM	Futures	9690.3	9709.0	9681.9	9698.8	2312.0
2010-01-22 04:00:00	YM	Futures	9698.8	9703.4	9685.7	9696.9	1177.0
2010-01-22 05:00:00	YM	Futures	9696.9	9698.8	9669.7	9672.5	1317.0
2010-01-22 06:00:00	YM	Futures	9675.4	9684.7	9615.5	9628.6	5602.0
2010-01-22 07:00:00	YM	Futures	9629.5	9656.6	9629.5	9648.2	2018.0
2010-01-22 08:00:00	YM	Futures	9648.2	9666.9	9627.6	9627.6	4350.0
2010-01-22 09:00:00	YM	Futures	9628.6	9666.0	9607.0	9650.1	30798.0
2010-01-22 10:00:00	YM	Futures	9651.0	9668.8	9593.0	9658.5	33479.0
2010-01-22 11:00:00	YM	Futures	9657.6	9680.0	9634.2	9641.7	19943.0
2010-01-22 12:00:00	YM	Futures	9641.7	9658.5	9625.8	9631.4	12676.0
2010-01-22 13:00:00	YM	Futures	9631.4	9635.1	9584.6	9596.7	14372.0
2010-01-22 14:00:00	YM	Futures	9596.7	9608.9	9541.5	9541.5	24526.0
2010-01-22 15:00:00	YM	Futures	9542.5	9563.1	9462.0	9471.3	48303.0

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

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