PREVIEW / futures_1hour / 2009-12-21

all futures 1-hour files

  file:    by_date/futures_1hour/2009/2009-12-21.parquet
  size:    44 KB
  rows:    1,308

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-12-21 00:00:00	ES	Futures	1070.83	1070.83	1068.64	1069.61	4588.0
2009-12-21 01:00:00	ES	Futures	1069.37	1070.34	1068.64	1069.85	2874.0
2009-12-21 02:00:00	ES	Futures	1069.85	1070.58	1068.64	1068.64	3680.0
2009-12-21 03:00:00	ES	Futures	1068.88	1070.83	1068.15	1070.34	18439.0
2009-12-21 04:00:00	ES	Futures	1070.34	1070.83	1069.12	1070.34	6265.0
2009-12-21 05:00:00	ES	Futures	1070.1	1070.83	1069.12	1070.83	5608.0
2009-12-21 06:00:00	ES	Futures	1070.83	1072.77	1070.34	1071.8	15309.0
2009-12-21 07:00:00	ES	Futures	1071.8	1074.47	1071.8	1074.23	20408.0
2009-12-21 08:00:00	ES	Futures	1074.23	1074.23	1072.77	1073.01	21196.0
2009-12-21 09:00:00	ES	Futures	1073.26	1079.58	1072.77	1077.88	225075.0
2009-12-21 10:00:00	ES	Futures	1078.12	1082.02	1077.88	1079.58	222586.0
2009-12-21 11:00:00	ES	Futures	1079.83	1081.53	1079.1	1080.8	101368.0
2009-12-21 12:00:00	ES	Futures	1081.04	1083.23	1080.07	1080.8	116365.0
2009-12-21 13:00:00	ES	Futures	1080.8	1081.04	1079.1	1080.31	66067.0
2009-12-21 14:00:00	ES	Futures	1080.56	1081.53	1079.58	1080.07	54616.0
2009-12-21 15:00:00	ES	Futures	1080.31	1080.31	1077.64	1079.34	177571.0
2009-12-21 16:00:00	ES	Futures	1079.34	1079.58	1077.39	1077.88	73716.0
2009-12-21 17:00:00	ES	Futures	1078.12	1078.37	1077.88	1078.12	745.0
2009-12-21 18:00:00	ES	Futures	1078.12	1080.07	1078.12	1080.07	4207.0
2009-12-21 19:00:00	ES	Futures	1079.83	1080.07	1079.1	1079.58	1866.0
2009-12-21 20:00:00	ES	Futures	1079.83	1081.04	1079.34	1080.8	3468.0
2009-12-21 21:00:00	ES	Futures	1080.8	1081.04	1079.58	1080.56	2145.0
2009-12-21 22:00:00	ES	Futures	1080.56	1081.04	1079.83	1080.8	1331.0
2009-12-21 23:00:00	ES	Futures	1080.8	1081.77	1080.07	1080.8	3026.0
2009-12-21 00:00:00	NQ	Futures	2070.81	2070.81	2066.53	2069.1	393.0
2009-12-21 01:00:00	NQ	Futures	2068.81	2070.24	2067.1	2069.67	367.0
2009-12-21 02:00:00	NQ	Futures	2069.67	2070.24	2066.24	2067.1	478.0
2009-12-21 03:00:00	NQ	Futures	2066.81	2070.81	2064.53	2069.95	2734.0
2009-12-21 04:00:00	NQ	Futures	2069.38	2070.81	2067.1	2070.24	1542.0
2009-12-21 05:00:00	NQ	Futures	2069.67	2071.1	2069.1	2071.1	702.0
2009-12-21 06:00:00	NQ	Futures	2071.38	2073.1	2070.24	2071.95	1283.0
2009-12-21 07:00:00	NQ	Futures	2071.95	2078.24	2071.95	2077.95	2209.0
2009-12-21 08:00:00	NQ	Futures	2077.67	2077.67	2073.38	2074.24	2408.0
2009-12-21 09:00:00	NQ	Futures	2073.95	2085.95	2071.1	2084.52	46524.0
2009-12-21 10:00:00	NQ	Futures	2084.52	2092.23	2083.09	2087.95	43924.0
2009-12-21 11:00:00	NQ	Futures	2087.66	2092.23	2087.38	2089.66	20659.0
2009-12-21 12:00:00	NQ	Futures	2089.38	2095.09	2086.52	2089.95	23388.0
2009-12-21 13:00:00	NQ	Futures	2089.66	2090.23	2085.38	2089.38	14170.0
2009-12-21 14:00:00	NQ	Futures	2089.38	2092.52	2087.66	2090.81	11944.0
2009-12-21 15:00:00	NQ	Futures	2090.52	2090.52	2083.66	2087.38	33109.0
2009-12-21 16:00:00	NQ	Futures	2087.38	2088.52	2084.52	2085.38	11113.0
2009-12-21 17:00:00	NQ	Futures	2085.95	2087.38	2085.95	2086.24	40.0
2009-12-21 18:00:00	NQ	Futures	2086.24	2087.09	2086.24	2087.09	108.0
2009-12-21 19:00:00	NQ	Futures	2087.09	2088.23	2087.09	2088.23	186.0
2009-12-21 20:00:00	NQ	Futures	2088.52	2092.8	2087.95	2091.38	384.0
2009-12-21 21:00:00	NQ	Futures	2091.38	2091.95	2089.95	2091.38	212.0
2009-12-21 22:00:00	NQ	Futures	2091.09	2091.66	2089.95	2091.09	99.0
2009-12-21 23:00:00	NQ	Futures	2091.38	2093.66	2088.81	2089.95	152.0
2009-12-21 00:00:00	YM	Futures	9629.5	9629.5	9612.7	9621.1	167.0
2009-12-21 01:00:00	YM	Futures	9615.5	9626.7	9612.7	9622.0	88.0

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

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