PREVIEW / futures_1hour / 2010-08-19

all futures 1-hour files

  file:    by_date/futures_1hour/2010/2010-08-19.parquet
  size:    46 KB
  rows:    1,358

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-08-19 00:00:00	ES	Futures	1067.65	1069.61	1067.16	1069.36	3943.0
2010-08-19 01:00:00	ES	Futures	1069.12	1070.84	1068.14	1070.84	6790.0
2010-08-19 02:00:00	ES	Futures	1070.59	1071.82	1070.59	1071.33	11826.0
2010-08-19 03:00:00	ES	Futures	1071.08	1072.8	1064.95	1066.91	47746.0
2010-08-19 04:00:00	ES	Futures	1066.91	1068.38	1065.19	1067.89	24618.0
2010-08-19 05:00:00	ES	Futures	1067.89	1068.87	1067.4	1068.63	10488.0
2010-08-19 06:00:00	ES	Futures	1068.63	1073.29	1068.63	1072.06	31197.0
2010-08-19 07:00:00	ES	Futures	1072.06	1072.55	1070.59	1072.06	19543.0
2010-08-19 08:00:00	ES	Futures	1072.06	1074.76	1063.23	1066.42	174724.0
2010-08-19 09:00:00	ES	Futures	1066.42	1069.36	1062.98	1064.21	265188.0
2010-08-19 10:00:00	ES	Futures	1064.46	1064.46	1053.66	1056.6	567161.0
2010-08-19 11:00:00	ES	Futures	1056.6	1056.85	1048.75	1050.72	343941.0
2010-08-19 12:00:00	ES	Futures	1050.96	1053.66	1049.73	1052.92	168510.0
2010-08-19 13:00:00	ES	Futures	1052.92	1054.15	1050.47	1050.72	104621.0
2010-08-19 14:00:00	ES	Futures	1050.72	1054.89	1049.49	1053.17	175246.0
2010-08-19 15:00:00	ES	Futures	1052.92	1058.08	1051.94	1053.91	327302.0
2010-08-19 16:00:00	ES	Futures	1053.91	1053.91	1050.72	1052.43	104387.0
2010-08-19 17:00:00	ES	Futures	1052.43	1052.92	1051.7	1052.19	1322.0
2010-08-19 18:00:00	ES	Futures	1052.43	1053.17	1051.94	1052.43	2384.0
2010-08-19 19:00:00	ES	Futures	1052.43	1053.41	1052.19	1052.92	2238.0
2010-08-19 20:00:00	ES	Futures	1053.17	1053.91	1051.94	1052.92	5575.0
2010-08-19 21:00:00	ES	Futures	1052.92	1054.64	1052.43	1052.92	6243.0
2010-08-19 22:00:00	ES	Futures	1052.68	1053.66	1051.21	1052.19	4015.0
2010-08-19 23:00:00	ES	Futures	1051.94	1052.43	1050.96	1051.45	2464.0
2010-08-19 00:00:00	NQ	Futures	2107.41	2111.13	2107.12	2110.27	212.0
2010-08-19 01:00:00	NQ	Futures	2110.27	2112.85	2108.84	2112.85	320.0
2010-08-19 02:00:00	NQ	Futures	2113.14	2116.86	2113.14	2115.43	1023.0
2010-08-19 03:00:00	NQ	Futures	2115.43	2118.87	2103.11	2106.26	3474.0
2010-08-19 04:00:00	NQ	Futures	2106.26	2108.84	2103.68	2108.27	1662.0
2010-08-19 05:00:00	NQ	Futures	2108.27	2110.27	2107.41	2109.7	941.0
2010-08-19 06:00:00	NQ	Futures	2109.99	2117.72	2109.99	2116.0	2389.0
2010-08-19 07:00:00	NQ	Futures	2116.0	2116.86	2113.14	2116.29	2235.0
2010-08-19 08:00:00	NQ	Futures	2116.58	2121.16	2101.39	2109.13	16023.0
2010-08-19 09:00:00	NQ	Futures	2108.84	2117.15	2104.83	2106.55	44036.0
2010-08-19 10:00:00	NQ	Futures	2106.83	2106.83	2088.21	2092.22	85156.0
2010-08-19 11:00:00	NQ	Futures	2092.22	2093.08	2075.02	2079.61	56548.0
2010-08-19 12:00:00	NQ	Futures	2079.9	2086.77	2076.74	2085.91	30419.0
2010-08-19 13:00:00	NQ	Futures	2085.91	2089.07	2082.19	2083.05	18560.0
2010-08-19 14:00:00	NQ	Futures	2083.05	2091.07	2080.18	2087.92	23756.0
2010-08-19 15:00:00	NQ	Futures	2087.92	2097.95	2085.63	2089.64	48734.0
2010-08-19 16:00:00	NQ	Futures	2089.35	2089.64	2085.63	2088.49	7868.0
2010-08-19 17:00:00	NQ	Futures	2088.78	2089.64	2087.63	2088.49	261.0
2010-08-19 18:00:00	NQ	Futures	2088.21	2089.93	2088.21	2088.49	141.0
2010-08-19 19:00:00	NQ	Futures	2088.78	2089.93	2087.63	2089.35	170.0
2010-08-19 20:00:00	NQ	Futures	2089.07	2090.5	2087.06	2088.78	407.0
2010-08-19 21:00:00	NQ	Futures	2088.78	2091.07	2087.92	2087.92	311.0
2010-08-19 22:00:00	NQ	Futures	2088.21	2089.64	2085.05	2087.35	317.0
2010-08-19 23:00:00	NQ	Futures	2086.77	2087.92	2085.34	2085.63	206.0
2010-08-19 00:00:00	YM	Futures	9808.7	9824.8	9805.9	9822.0	432.0
2010-08-19 01:00:00	YM	Futures	9821.0	9833.3	9814.4	9832.4	304.0

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

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