PREVIEW / futures_1hour / 2010-09-14

all futures 1-hour files

  file:    by_date/futures_1hour/2010/2010-09-14.parquet
  size:    47 KB
  rows:    1,386

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-09-14 00:00:00	ES	Futures	1100.28	1100.77	1099.54	1099.54	2072.0
2010-09-14 01:00:00	ES	Futures	1099.54	1100.28	1098.56	1099.54	4825.0
2010-09-14 02:00:00	ES	Futures	1099.54	1100.77	1098.8	1100.28	9348.0
2010-09-14 03:00:00	ES	Futures	1100.28	1102.01	1099.05	1099.3	23979.0
2010-09-14 04:00:00	ES	Futures	1099.3	1099.54	1097.57	1099.3	24717.0
2010-09-14 05:00:00	ES	Futures	1099.3	1099.54	1097.08	1097.82	17830.0
2010-09-14 06:00:00	ES	Futures	1097.57	1100.28	1097.57	1098.8	8561.0
2010-09-14 07:00:00	ES	Futures	1098.8	1099.05	1096.58	1098.31	21744.0
2010-09-14 08:00:00	ES	Futures	1098.06	1102.25	1097.82	1097.82	105214.0
2010-09-14 09:00:00	ES	Futures	1097.82	1099.79	1094.61	1097.32	265948.0
2010-09-14 10:00:00	ES	Futures	1097.08	1102.5	1096.09	1101.51	293836.0
2010-09-14 11:00:00	ES	Futures	1101.76	1105.95	1101.02	1105.7	322642.0
2010-09-14 12:00:00	ES	Futures	1105.46	1106.69	1102.5	1103.49	153759.0
2010-09-14 13:00:00	ES	Futures	1103.24	1104.23	1099.79	1101.51	149918.0
2010-09-14 14:00:00	ES	Futures	1101.51	1104.23	1100.77	1103.73	112117.0
2010-09-14 15:00:00	ES	Futures	1103.49	1105.95	1099.79	1100.28	286658.0
2010-09-14 16:00:00	ES	Futures	1100.28	1101.76	1097.32	1097.82	96484.0
2010-09-14 17:00:00	ES	Futures	1097.82	1098.56	1097.57	1098.31	739.0
2010-09-14 18:00:00	ES	Futures	1098.31	1098.56	1096.09	1097.32	6232.0
2010-09-14 19:00:00	ES	Futures	1097.32	1097.82	1097.08	1097.32	1148.0
2010-09-14 20:00:00	ES	Futures	1097.57	1099.3	1097.08	1098.56	4715.0
2010-09-14 21:00:00	ES	Futures	1098.31	1102.01	1096.83	1100.53	18614.0
2010-09-14 22:00:00	ES	Futures	1100.53	1102.01	1099.54	1101.02	8908.0
2010-09-14 23:00:00	ES	Futures	1101.02	1101.51	1100.04	1101.27	5744.0
2010-09-14 00:00:00	NQ	Futures	2199.11	2199.39	2197.67	2197.67	128.0
2010-09-14 01:00:00	NQ	Futures	2197.96	2198.25	2195.38	2197.1	359.0
2010-09-14 02:00:00	NQ	Futures	2197.39	2198.53	2195.38	2198.25	824.0
2010-09-14 03:00:00	NQ	Futures	2198.25	2201.98	2196.53	2197.39	2354.0
2010-09-14 04:00:00	NQ	Futures	2197.1	2197.67	2194.23	2197.1	1823.0
2010-09-14 05:00:00	NQ	Futures	2196.24	2197.39	2193.66	2195.09	1494.0
2010-09-14 06:00:00	NQ	Futures	2195.09	2200.26	2195.09	2196.81	1227.0
2010-09-14 07:00:00	NQ	Futures	2196.53	2196.81	2191.65	2193.94	3415.0
2010-09-14 08:00:00	NQ	Futures	2193.94	2203.12	2193.94	2193.94	8306.0
2010-09-14 09:00:00	NQ	Futures	2194.23	2202.26	2192.8	2199.68	42874.0
2010-09-14 10:00:00	NQ	Futures	2199.97	2210.58	2196.53	2208.86	49705.0
2010-09-14 11:00:00	NQ	Futures	2208.86	2219.48	2208.29	2218.33	54662.0
2010-09-14 12:00:00	NQ	Futures	2218.62	2221.77	2212.59	2216.32	32357.0
2010-09-14 13:00:00	NQ	Futures	2216.03	2217.76	2208.0	2212.88	32347.0
2010-09-14 14:00:00	NQ	Futures	2212.88	2218.04	2210.3	2216.03	25247.0
2010-09-14 15:00:00	NQ	Futures	2216.03	2219.76	2209.72	2210.3	50475.0
2010-09-14 16:00:00	NQ	Futures	2210.3	2212.59	2202.84	2204.27	10747.0
2010-09-14 17:00:00	NQ	Futures	2204.27	2205.71	2203.99	2205.42	69.0
2010-09-14 18:00:00	NQ	Futures	2204.56	2205.71	2201.98	2204.27	409.0
2010-09-14 19:00:00	NQ	Futures	2204.27	2204.56	2203.12	2204.27	141.0
2010-09-14 20:00:00	NQ	Futures	2203.99	2207.14	2203.7	2205.99	297.0
2010-09-14 21:00:00	NQ	Futures	2205.71	2212.88	2202.26	2210.58	1381.0
2010-09-14 22:00:00	NQ	Futures	2210.58	2212.88	2207.71	2210.87	577.0
2010-09-14 23:00:00	NQ	Futures	2210.87	2212.02	2208.29	2211.16	279.0
2010-09-14 00:00:00	YM	Futures	9969.5	9973.4	9965.7	9967.6	76.0
2010-09-14 01:00:00	YM	Futures	9966.7	9969.5	9958.1	9966.7	272.0

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

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