PREVIEW / futures_1hour / 2009-12-30

all futures 1-hour files

  file:    by_date/futures_1hour/2009/2009-12-30.parquet
  size:    42 KB
  rows:    1,293

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-30 00:00:00	ES	Futures	1089.07	1089.56	1088.83	1089.07	1218.0
2009-12-30 01:00:00	ES	Futures	1088.83	1089.8	1088.58	1089.31	1453.0
2009-12-30 02:00:00	ES	Futures	1089.56	1090.53	1089.31	1090.04	1850.0
2009-12-30 03:00:00	ES	Futures	1090.04	1091.26	1089.31	1089.56	9274.0
2009-12-30 04:00:00	ES	Futures	1089.56	1089.8	1082.99	1085.91	21647.0
2009-12-30 05:00:00	ES	Futures	1085.91	1086.15	1083.96	1085.42	7825.0
2009-12-30 06:00:00	ES	Futures	1085.66	1086.15	1083.72	1084.69	5683.0
2009-12-30 07:00:00	ES	Futures	1084.93	1087.61	1084.69	1086.64	7357.0
2009-12-30 08:00:00	ES	Futures	1086.88	1088.1	1086.39	1087.85	8905.0
2009-12-30 09:00:00	ES	Futures	1088.1	1092.23	1086.88	1091.26	120784.0
2009-12-30 10:00:00	ES	Futures	1091.26	1092.23	1088.34	1089.07	100692.0
2009-12-30 11:00:00	ES	Futures	1089.07	1091.02	1087.85	1090.53	70019.0
2009-12-30 12:00:00	ES	Futures	1090.77	1091.5	1089.07	1089.8	42652.0
2009-12-30 13:00:00	ES	Futures	1089.56	1090.77	1088.34	1089.56	28810.0
2009-12-30 14:00:00	ES	Futures	1089.56	1091.26	1089.31	1090.77	24777.0
2009-12-30 15:00:00	ES	Futures	1091.02	1091.99	1089.56	1091.02	88175.0
2009-12-30 16:00:00	ES	Futures	1091.02	1092.72	1090.29	1092.48	43476.0
2009-12-30 17:00:00	ES	Futures	1092.48	1092.72	1091.75	1092.23	870.0
2009-12-30 18:00:00	ES	Futures	1092.23	1092.48	1091.75	1091.99	1125.0
2009-12-30 19:00:00	ES	Futures	1091.99	1092.72	1091.99	1092.23	773.0
2009-12-30 20:00:00	ES	Futures	1092.48	1093.2	1091.99	1092.96	1109.0
2009-12-30 21:00:00	ES	Futures	1092.96	1093.2	1092.48	1092.72	582.0
2009-12-30 22:00:00	ES	Futures	1092.48	1093.45	1092.48	1093.2	1646.0
2009-12-30 23:00:00	ES	Futures	1093.45	1093.45	1092.48	1092.96	983.0
2009-12-30 00:00:00	NQ	Futures	2135.65	2135.65	2134.51	2134.79	60.0
2009-12-30 01:00:00	NQ	Futures	2134.79	2136.22	2134.51	2135.08	82.0
2009-12-30 02:00:00	NQ	Futures	2135.36	2137.08	2134.79	2136.51	218.0
2009-12-30 03:00:00	NQ	Futures	2136.22	2138.51	2134.51	2135.93	1215.0
2009-12-30 04:00:00	NQ	Futures	2135.93	2136.22	2130.51	2131.65	2793.0
2009-12-30 05:00:00	NQ	Futures	2131.65	2131.65	2128.22	2130.51	865.0
2009-12-30 06:00:00	NQ	Futures	2130.51	2131.65	2127.65	2130.22	908.0
2009-12-30 07:00:00	NQ	Futures	2130.22	2134.79	2130.22	2132.79	1102.0
2009-12-30 08:00:00	NQ	Futures	2132.79	2134.51	2131.94	2133.65	979.0
2009-12-30 09:00:00	NQ	Futures	2133.65	2148.22	2132.79	2145.36	30982.0
2009-12-30 10:00:00	NQ	Futures	2145.36	2147.07	2134.51	2136.51	23758.0
2009-12-30 11:00:00	NQ	Futures	2136.22	2141.65	2134.22	2140.22	14628.0
2009-12-30 12:00:00	NQ	Futures	2140.22	2142.5	2139.08	2139.93	11025.0
2009-12-30 13:00:00	NQ	Futures	2139.93	2141.93	2136.79	2139.93	8468.0
2009-12-30 14:00:00	NQ	Futures	2139.93	2143.08	2138.79	2141.93	7159.0
2009-12-30 15:00:00	NQ	Futures	2141.65	2145.36	2139.36	2143.65	17345.0
2009-12-30 16:00:00	NQ	Futures	2143.65	2145.36	2141.93	2145.07	5487.0
2009-12-30 17:00:00	NQ	Futures	2144.79	2145.36	2144.5	2144.79	26.0
2009-12-30 18:00:00	NQ	Futures	2145.07	2147.07	2143.65	2145.93	326.0
2009-12-30 19:00:00	NQ	Futures	2146.22	2146.5	2145.07	2145.36	51.0
2009-12-30 20:00:00	NQ	Futures	2145.65	2147.93	2145.07	2147.36	196.0
2009-12-30 21:00:00	NQ	Futures	2147.65	2147.65	2146.5	2147.07	47.0
2009-12-30 22:00:00	NQ	Futures	2147.07	2150.22	2147.07	2149.36	278.0
2009-12-30 23:00:00	NQ	Futures	2149.36	2149.36	2146.79	2147.65	137.0
2009-12-30 00:00:00	YM	Futures	9794.2	9797.0	9792.3	9795.1	140.0
2009-12-30 01:00:00	YM	Futures	9796.1	9803.6	9793.3	9797.0	147.0

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

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