PREVIEW / futures_1hour / 2009-12-31

all futures 1-hour files

  file:    by_date/futures_1hour/2009/2009-12-31.parquet
  size:    32 KB
  rows:    885

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-31 00:00:00	ES	Futures	1092.96	1093.2	1092.72	1093.2	506.0
2009-12-31 01:00:00	ES	Futures	1092.96	1093.69	1092.72	1093.69	755.0
2009-12-31 02:00:00	ES	Futures	1093.45	1093.69	1092.96	1093.45	1573.0
2009-12-31 03:00:00	ES	Futures	1093.45	1094.66	1093.2	1094.18	3949.0
2009-12-31 04:00:00	ES	Futures	1094.42	1094.42	1093.2	1093.45	2318.0
2009-12-31 05:00:00	ES	Futures	1093.45	1094.18	1092.96	1093.45	2765.0
2009-12-31 06:00:00	ES	Futures	1093.45	1094.66	1093.2	1094.42	3273.0
2009-12-31 07:00:00	ES	Futures	1094.18	1094.91	1093.69	1093.93	5300.0
2009-12-31 08:00:00	ES	Futures	1093.93	1094.66	1092.72	1094.42	19428.0
2009-12-31 09:00:00	ES	Futures	1094.18	1094.42	1091.75	1091.75	49988.0
2009-12-31 10:00:00	ES	Futures	1091.75	1091.99	1089.07	1089.8	79397.0
2009-12-31 11:00:00	ES	Futures	1089.56	1089.8	1087.12	1087.85	67724.0
2009-12-31 12:00:00	ES	Futures	1087.85	1088.83	1087.85	1088.58	28484.0
2009-12-31 13:00:00	ES	Futures	1088.58	1088.83	1087.12	1088.34	31222.0
2009-12-31 14:00:00	ES	Futures	1088.34	1088.83	1087.61	1088.58	23567.0
2009-12-31 15:00:00	ES	Futures	1088.58	1089.31	1080.07	1080.07	188160.0
2009-12-31 16:00:00	ES	Futures	1080.31	1083.47	1079.83	1083.23	120239.0
2009-12-31 00:00:00	NQ	Futures	2147.65	2147.93	2147.36	2147.65	88.0
2009-12-31 01:00:00	NQ	Futures	2147.65	2147.93	2147.07	2147.36	59.0
2009-12-31 02:00:00	NQ	Futures	2147.07	2147.36	2144.79	2145.93	129.0
2009-12-31 03:00:00	NQ	Futures	2145.93	2148.5	2145.36	2146.5	230.0
2009-12-31 04:00:00	NQ	Futures	2146.79	2146.79	2144.79	2145.36	147.0
2009-12-31 05:00:00	NQ	Futures	2145.65	2145.65	2143.08	2144.22	324.0
2009-12-31 06:00:00	NQ	Futures	2144.5	2147.07	2144.22	2146.22	482.0
2009-12-31 07:00:00	NQ	Futures	2146.22	2147.07	2145.65	2146.79	271.0
2009-12-31 08:00:00	NQ	Futures	2147.07	2149.64	2145.65	2148.79	2188.0
2009-12-31 09:00:00	NQ	Futures	2148.79	2149.07	2142.79	2144.22	14602.0
2009-12-31 10:00:00	NQ	Futures	2144.22	2144.79	2137.36	2139.36	17106.0
2009-12-31 11:00:00	NQ	Futures	2139.65	2139.93	2134.51	2137.08	12025.0
2009-12-31 12:00:00	NQ	Futures	2137.08	2138.51	2136.79	2137.36	4056.0
2009-12-31 13:00:00	NQ	Futures	2137.36	2137.65	2133.94	2135.65	5268.0
2009-12-31 14:00:00	NQ	Futures	2135.65	2136.51	2134.22	2136.22	4733.0
2009-12-31 15:00:00	NQ	Futures	2136.22	2137.08	2123.65	2124.51	35104.0
2009-12-31 16:00:00	NQ	Futures	2124.51	2133.65	2124.22	2133.08	14916.0
2009-12-31 00:00:00	YM	Futures	9828.8	9830.7	9828.8	9828.8	15.0
2009-12-31 01:00:00	YM	Futures	9830.7	9834.4	9828.8	9832.6	63.0
2009-12-31 02:00:00	YM	Futures	9830.7	9834.4	9829.8	9831.6	77.0
2009-12-31 03:00:00	YM	Futures	9835.4	9839.1	9829.8	9837.3	236.0
2009-12-31 04:00:00	YM	Futures	9837.3	9838.2	9828.8	9828.8	99.0
2009-12-31 05:00:00	YM	Futures	9827.9	9834.4	9822.3	9831.6	285.0
2009-12-31 06:00:00	YM	Futures	9832.6	9834.4	9826.0	9832.6	334.0
2009-12-31 07:00:00	YM	Futures	9831.6	9835.4	9827.9	9828.8	255.0
2009-12-31 08:00:00	YM	Futures	9829.8	9835.4	9821.3	9828.8	1261.0
2009-12-31 09:00:00	YM	Futures	9828.8	9829.8	9803.6	9805.4	4613.0
2009-12-31 10:00:00	YM	Futures	9805.4	9805.4	9780.2	9788.6	6460.0
2009-12-31 11:00:00	YM	Futures	9789.5	9790.5	9756.8	9756.8	6489.0
2009-12-31 12:00:00	YM	Futures	9756.8	9772.7	9756.8	9768.0	2286.0
2009-12-31 13:00:00	YM	Futures	9768.9	9773.6	9758.6	9766.1	2021.0
2009-12-31 14:00:00	YM	Futures	9766.1	9770.8	9760.5	9769.9	1372.0
2009-12-31 15:00:00	YM	Futures	9770.8	9774.6	9695.9	9697.8	9904.0

> showing 50 of 885 rows — these rows as CSV

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