PREVIEW / futures_1hour / 2010-07-19

all futures 1-hour files

  file:    by_date/futures_1hour/2010/2010-07-19.parquet
  size:    45 KB
  rows:    1,336

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-07-19 00:00:00	ES	Futures	1044.58	1045.32	1044.34	1044.83	1124.0
2010-07-19 01:00:00	ES	Futures	1044.83	1046.3	1044.58	1046.05	4502.0
2010-07-19 02:00:00	ES	Futures	1045.81	1046.79	1043.35	1043.6	12959.0
2010-07-19 03:00:00	ES	Futures	1043.6	1045.81	1042.62	1045.07	38237.0
2010-07-19 04:00:00	ES	Futures	1045.07	1048.26	1044.09	1048.02	27074.0
2010-07-19 05:00:00	ES	Futures	1048.02	1049.24	1046.05	1047.28	20868.0
2010-07-19 06:00:00	ES	Futures	1047.28	1049.49	1047.28	1048.51	18689.0
2010-07-19 07:00:00	ES	Futures	1048.75	1049.24	1046.54	1047.28	19973.0
2010-07-19 08:00:00	ES	Futures	1047.03	1047.77	1045.32	1046.3	37170.0
2010-07-19 09:00:00	ES	Futures	1046.3	1049.49	1045.07	1047.28	208516.0
2010-07-19 10:00:00	ES	Futures	1047.03	1047.77	1037.46	1039.92	374356.0
2010-07-19 11:00:00	ES	Futures	1040.16	1044.09	1039.18	1043.6	172154.0
2010-07-19 12:00:00	ES	Futures	1043.6	1047.03	1040.65	1044.83	145419.0
2010-07-19 13:00:00	ES	Futures	1045.07	1045.32	1041.39	1042.13	97708.0
2010-07-19 14:00:00	ES	Futures	1041.88	1049.73	1041.88	1047.77	157417.0
2010-07-19 15:00:00	ES	Futures	1047.77	1051.21	1044.83	1048.51	269044.0
2010-07-19 16:00:00	ES	Futures	1048.26	1048.75	1040.16	1040.41	107068.0
2010-07-19 17:00:00	ES	Futures	1040.41	1040.9	1040.16	1040.16	3246.0
2010-07-19 18:00:00	ES	Futures	1039.67	1040.16	1038.94	1039.43	5928.0
2010-07-19 19:00:00	ES	Futures	1039.43	1041.88	1038.94	1041.39	4685.0
2010-07-19 20:00:00	ES	Futures	1041.64	1044.09	1040.9	1042.86	10033.0
2010-07-19 21:00:00	ES	Futures	1042.62	1044.09	1042.13	1042.62	6424.0
2010-07-19 22:00:00	ES	Futures	1042.37	1046.3	1042.13	1044.58	9787.0
2010-07-19 23:00:00	ES	Futures	1044.83	1046.79	1043.84	1046.05	6552.0
2010-07-19 00:00:00	NQ	Futures	2067.86	2068.43	2067.57	2068.43	52.0
2010-07-19 01:00:00	NQ	Futures	2068.72	2071.87	2068.43	2070.44	158.0
2010-07-19 02:00:00	NQ	Futures	2070.73	2072.16	2066.14	2066.43	884.0
2010-07-19 03:00:00	NQ	Futures	2066.71	2071.3	2065.28	2069.87	3300.0
2010-07-19 04:00:00	NQ	Futures	2069.87	2074.45	2067.57	2073.88	2506.0
2010-07-19 05:00:00	NQ	Futures	2074.16	2076.74	2071.3	2073.88	2222.0
2010-07-19 06:00:00	NQ	Futures	2074.45	2078.46	2073.88	2077.03	1487.0
2010-07-19 07:00:00	NQ	Futures	2077.03	2078.46	2071.3	2072.45	2240.0
2010-07-19 08:00:00	NQ	Futures	2072.45	2074.16	2067.86	2070.44	5586.0
2010-07-19 09:00:00	NQ	Futures	2070.73	2084.19	2069.29	2076.74	45642.0
2010-07-19 10:00:00	NQ	Futures	2076.74	2080.47	2054.68	2060.12	63600.0
2010-07-19 11:00:00	NQ	Futures	2060.12	2073.02	2059.26	2071.3	36193.0
2010-07-19 12:00:00	NQ	Futures	2071.01	2075.88	2062.42	2071.3	27117.0
2010-07-19 13:00:00	NQ	Futures	2071.01	2071.59	2063.85	2065.85	18026.0
2010-07-19 14:00:00	NQ	Futures	2065.85	2083.05	2065.57	2079.32	27121.0
2010-07-19 15:00:00	NQ	Futures	2079.04	2087.63	2075.02	2083.05	48750.0
2010-07-19 16:00:00	NQ	Futures	2083.05	2085.91	2060.41	2060.41	14645.0
2010-07-19 17:00:00	NQ	Futures	2060.7	2061.84	2059.55	2060.12	680.0
2010-07-19 18:00:00	NQ	Futures	2059.55	2060.7	2058.12	2060.12	332.0
2010-07-19 19:00:00	NQ	Futures	2059.26	2063.56	2058.69	2063.28	682.0
2010-07-19 20:00:00	NQ	Futures	2063.28	2067.86	2061.84	2065.57	723.0
2010-07-19 21:00:00	NQ	Futures	2065.85	2067.86	2064.14	2064.14	601.0
2010-07-19 22:00:00	NQ	Futures	2064.14	2071.3	2063.85	2069.87	968.0
2010-07-19 23:00:00	NQ	Futures	2069.87	2073.02	2067.86	2071.59	651.0
2010-07-19 00:00:00	YM	Futures	9531.4	9535.2	9530.4	9532.3	140.0
2010-07-19 01:00:00	YM	Futures	9533.3	9547.5	9532.3	9543.7	331.0

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

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