PREVIEW / futures_1hour / 2010-06-28

all futures 1-hour files

  file:    by_date/futures_1hour/2010/2010-06-28.parquet
  size:    43 KB
  rows:    1,332

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-28 00:00:00	ES	Futures	1056.6	1057.59	1056.36	1056.85	1880.0
2010-06-28 01:00:00	ES	Futures	1057.09	1057.34	1053.91	1053.91	5087.0
2010-06-28 02:00:00	ES	Futures	1053.91	1055.87	1052.92	1055.62	9451.0
2010-06-28 03:00:00	ES	Futures	1055.62	1056.85	1052.19	1054.64	36725.0
2010-06-28 04:00:00	ES	Futures	1054.64	1059.06	1053.41	1058.32	25933.0
2010-06-28 05:00:00	ES	Futures	1058.32	1059.79	1057.59	1058.32	27430.0
2010-06-28 06:00:00	ES	Futures	1058.32	1059.55	1057.09	1057.09	15208.0
2010-06-28 07:00:00	ES	Futures	1057.34	1059.06	1057.09	1058.32	19185.0
2010-06-28 08:00:00	ES	Futures	1058.08	1058.32	1052.68	1054.64	75168.0
2010-06-28 09:00:00	ES	Futures	1054.64	1056.6	1046.79	1049.0	255939.0
2010-06-28 10:00:00	ES	Futures	1049.0	1055.13	1048.02	1054.89	295832.0
2010-06-28 11:00:00	ES	Futures	1054.89	1058.57	1054.15	1055.38	206258.0
2010-06-28 12:00:00	ES	Futures	1055.38	1055.87	1051.94	1054.64	156950.0
2010-06-28 13:00:00	ES	Futures	1054.64	1054.89	1050.22	1053.41	118072.0
2010-06-28 14:00:00	ES	Futures	1053.66	1056.11	1052.19	1055.62	107477.0
2010-06-28 15:00:00	ES	Futures	1055.62	1056.6	1049.98	1050.22	217287.0
2010-06-28 16:00:00	ES	Futures	1050.22	1052.68	1049.24	1050.47	83797.0
2010-06-28 17:00:00	ES	Futures	1050.47	1051.21	1049.98	1050.96	810.0
2010-06-28 18:00:00	ES	Futures	1050.72	1051.21	1049.49	1050.22	2035.0
2010-06-28 19:00:00	ES	Futures	1050.22	1052.19	1049.98	1052.19	2620.0
2010-06-28 20:00:00	ES	Futures	1051.94	1054.89	1051.45	1054.64	7851.0
2010-06-28 21:00:00	ES	Futures	1054.64	1054.89	1053.41	1053.91	3211.0
2010-06-28 22:00:00	ES	Futures	1053.66	1053.91	1049.49	1050.22	7083.0
2010-06-28 23:00:00	ES	Futures	1050.22	1050.96	1047.77	1047.77	7867.0
2010-06-28 00:00:00	NQ	Futures	2112.28	2114.28	2111.71	2113.14	161.0
2010-06-28 01:00:00	NQ	Futures	2112.85	2113.42	2107.12	2107.12	245.0
2010-06-28 02:00:00	NQ	Futures	2107.41	2111.13	2105.69	2110.27	600.0
2010-06-28 03:00:00	NQ	Futures	2110.27	2112.56	2103.11	2107.69	2618.0
2010-06-28 04:00:00	NQ	Futures	2107.69	2116.0	2105.97	2114.86	1440.0
2010-06-28 05:00:00	NQ	Futures	2114.86	2117.72	2113.71	2115.14	1538.0
2010-06-28 06:00:00	NQ	Futures	2115.14	2117.44	2112.85	2113.14	1888.0
2010-06-28 07:00:00	NQ	Futures	2113.42	2117.15	2113.42	2115.43	2001.0
2010-06-28 08:00:00	NQ	Futures	2115.43	2115.72	2103.68	2107.69	9021.0
2010-06-28 09:00:00	NQ	Futures	2107.41	2112.85	2093.94	2098.52	46298.0
2010-06-28 10:00:00	NQ	Futures	2098.81	2112.28	2087.63	2111.42	67877.0
2010-06-28 11:00:00	NQ	Futures	2111.71	2122.31	2111.42	2115.72	35689.0
2010-06-28 12:00:00	NQ	Futures	2115.72	2116.29	2106.83	2112.56	26714.0
2010-06-28 13:00:00	NQ	Futures	2112.56	2112.85	2102.53	2109.7	18420.0
2010-06-28 14:00:00	NQ	Futures	2109.7	2114.28	2105.97	2112.56	19545.0
2010-06-28 15:00:00	NQ	Futures	2112.56	2116.0	2101.68	2101.68	36437.0
2010-06-28 16:00:00	NQ	Futures	2101.68	2106.55	2099.1	2100.82	9358.0
2010-06-28 17:00:00	NQ	Futures	2100.82	2102.25	2099.96	2101.68	97.0
2010-06-28 18:00:00	NQ	Futures	2101.68	2101.68	2099.1	2100.24	200.0
2010-06-28 19:00:00	NQ	Futures	2099.96	2103.68	2099.67	2103.68	172.0
2010-06-28 20:00:00	NQ	Futures	2103.97	2108.27	2103.11	2107.69	623.0
2010-06-28 21:00:00	NQ	Futures	2107.69	2108.55	2106.26	2107.12	475.0
2010-06-28 22:00:00	NQ	Futures	2106.83	2107.41	2099.1	2100.53	755.0
2010-06-28 23:00:00	NQ	Futures	2100.82	2101.96	2091.36	2095.08	1001.0
2010-06-28 00:00:00	YM	Futures	9574.9	9579.7	9571.1	9575.9	106.0
2010-06-28 01:00:00	YM	Futures	9576.8	9577.8	9552.2	9554.1	226.0

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

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