PREVIEW / futures_1hour / 2010-06-21

all futures 1-hour files

  file:    by_date/futures_1hour/2010/2010-06-21.parquet
  size:    45 KB
  rows:    1,337

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-06-21 00:00:00	ES	Futures	1102.98	1104.94	1101.75	1103.23	5509.0
2010-06-21 01:00:00	ES	Futures	1103.47	1107.15	1103.23	1106.42	9744.0
2010-06-21 02:00:00	ES	Futures	1106.42	1108.62	1106.17	1107.64	16321.0
2010-06-21 03:00:00	ES	Futures	1107.64	1108.13	1105.43	1105.68	36175.0
2010-06-21 04:00:00	ES	Futures	1105.68	1107.15	1103.96	1105.93	27600.0
2010-06-21 05:00:00	ES	Futures	1105.93	1106.42	1104.45	1105.68	13311.0
2010-06-21 06:00:00	ES	Futures	1105.93	1107.4	1105.43	1105.68	16199.0
2010-06-21 07:00:00	ES	Futures	1105.93	1106.91	1104.7	1104.94	21162.0
2010-06-21 08:00:00	ES	Futures	1104.94	1105.43	1102.24	1103.23	52231.0
2010-06-21 09:00:00	ES	Futures	1103.23	1106.66	1100.77	1104.94	259718.0
2010-06-21 10:00:00	ES	Futures	1104.94	1106.17	1099.55	1100.04	279531.0
2010-06-21 11:00:00	ES	Futures	1100.04	1102.49	1099.3	1100.28	177084.0
2010-06-21 12:00:00	ES	Futures	1100.53	1101.02	1095.86	1097.58	173582.0
2010-06-21 13:00:00	ES	Futures	1097.34	1099.05	1093.9	1095.37	186727.0
2010-06-21 14:00:00	ES	Futures	1095.37	1099.05	1092.67	1093.41	182018.0
2010-06-21 15:00:00	ES	Futures	1093.17	1093.9	1082.86	1088.5	508511.0
2010-06-21 16:00:00	ES	Futures	1088.5	1091.2	1088.5	1090.22	102975.0
2010-06-21 17:00:00	ES	Futures	1090.22	1090.71	1089.98	1090.22	1206.0
2010-06-21 18:00:00	ES	Futures	1090.47	1091.2	1090.22	1090.47	3668.0
2010-06-21 19:00:00	ES	Futures	1090.71	1091.45	1090.47	1090.96	2337.0
2010-06-21 20:00:00	ES	Futures	1090.71	1091.2	1089.98	1091.2	5379.0
2010-06-21 21:00:00	ES	Futures	1091.2	1096.36	1089.98	1093.41	29673.0
2010-06-21 22:00:00	ES	Futures	1093.41	1093.66	1090.47	1091.45	7473.0
2010-06-21 23:00:00	ES	Futures	1091.45	1092.67	1090.47	1090.71	3572.0
2010-06-21 00:00:00	NQ	Futures	2214.58	2218.02	2214.01	2215.16	601.0
2010-06-21 01:00:00	NQ	Futures	2215.16	2220.03	2214.58	2218.31	446.0
2010-06-21 02:00:00	NQ	Futures	2219.45	2224.33	2218.88	2223.75	1287.0
2010-06-21 03:00:00	NQ	Futures	2223.75	2224.9	2220.31	2221.75	2518.0
2010-06-21 04:00:00	NQ	Futures	2221.46	2224.04	2219.45	2222.32	1698.0
2010-06-21 05:00:00	NQ	Futures	2222.32	2223.18	2219.74	2220.6	1263.0
2010-06-21 06:00:00	NQ	Futures	2220.89	2224.61	2220.31	2220.31	1105.0
2010-06-21 07:00:00	NQ	Futures	2220.6	2222.03	2217.16	2217.73	1351.0
2010-06-21 08:00:00	NQ	Futures	2217.73	2218.02	2211.72	2215.73	6481.0
2010-06-21 09:00:00	NQ	Futures	2215.73	2221.46	2207.42	2219.74	44769.0
2010-06-21 10:00:00	NQ	Futures	2220.03	2222.32	2201.11	2203.41	44950.0
2010-06-21 11:00:00	NQ	Futures	2203.41	2210.0	2198.53	2200.83	35420.0
2010-06-21 12:00:00	NQ	Futures	2200.54	2202.83	2192.23	2198.25	31461.0
2010-06-21 13:00:00	NQ	Futures	2198.25	2200.83	2188.22	2191.08	21512.0
2010-06-21 14:00:00	NQ	Futures	2191.08	2199.97	2183.63	2183.92	32022.0
2010-06-21 15:00:00	NQ	Futures	2183.92	2185.64	2159.28	2171.88	74991.0
2010-06-21 16:00:00	NQ	Futures	2171.88	2178.76	2171.31	2178.47	16851.0
2010-06-21 17:00:00	NQ	Futures	2178.47	2179.05	2178.19	2178.19	89.0
2010-06-21 18:00:00	NQ	Futures	2179.05	2179.33	2177.62	2178.47	239.0
2010-06-21 19:00:00	NQ	Futures	2179.05	2179.33	2178.19	2178.76	151.0
2010-06-21 20:00:00	NQ	Futures	2178.76	2181.05	2177.04	2180.77	1018.0
2010-06-21 21:00:00	NQ	Futures	2180.77	2189.65	2178.19	2185.07	1788.0
2010-06-21 22:00:00	NQ	Futures	2184.78	2185.64	2178.76	2181.34	788.0
2010-06-21 23:00:00	NQ	Futures	2181.63	2184.21	2180.19	2180.19	413.0
2010-06-21 00:00:00	YM	Futures	9929.0	9937.5	9918.5	9927.1	860.0
2010-06-21 01:00:00	YM	Futures	9928.0	9953.6	9925.2	9947.9	477.0

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

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