PREVIEW / futures_1hour / 2010-05-21

all futures 1-hour files

  file:    by_date/futures_1hour/2010/2010-05-21.parquet
  size:    40 KB
  rows:    1,118

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-05-21 00:00:00	ES	Futures	1050.79	1054.45	1049.81	1050.79	10353.0
2010-05-21 01:00:00	ES	Futures	1050.54	1054.21	1047.61	1052.99	10362.0
2010-05-21 02:00:00	ES	Futures	1052.99	1055.68	1050.3	1053.48	29284.0
2010-05-21 03:00:00	ES	Futures	1053.48	1056.41	1046.39	1050.3	67263.0
2010-05-21 04:00:00	ES	Futures	1050.06	1053.72	1048.83	1050.06	38005.0
2010-05-21 05:00:00	ES	Futures	1050.06	1053.97	1047.12	1048.83	38839.0
2010-05-21 06:00:00	ES	Futures	1048.83	1050.79	1040.28	1042.48	68897.0
2010-05-21 07:00:00	ES	Futures	1042.72	1044.68	1033.92	1039.79	127514.0
2010-05-21 08:00:00	ES	Futures	1039.54	1041.26	1034.41	1038.57	144388.0
2010-05-21 09:00:00	ES	Futures	1038.57	1051.77	1027.81	1048.34	782233.0
2010-05-21 10:00:00	ES	Futures	1048.1	1055.43	1042.48	1048.34	616636.0
2010-05-21 11:00:00	ES	Futures	1048.1	1064.48	1047.61	1061.05	483110.0
2010-05-21 12:00:00	ES	Futures	1061.3	1063.01	1055.68	1056.41	289278.0
2010-05-21 13:00:00	ES	Futures	1056.41	1059.34	1052.74	1058.12	222757.0
2010-05-21 14:00:00	ES	Futures	1058.37	1059.83	1047.12	1051.28	272114.0
2010-05-21 15:00:00	ES	Futures	1051.03	1062.52	1044.19	1061.54	545935.0
2010-05-21 16:00:00	ES	Futures	1061.54	1061.79	1058.61	1060.32	150366.0
2010-05-21 00:00:00	NQ	Futures	2073.91	2080.5	2072.19	2073.05	984.0
2010-05-21 01:00:00	NQ	Futures	2073.34	2076.77	2067.9	2074.77	891.0
2010-05-21 02:00:00	NQ	Futures	2074.77	2080.5	2071.05	2076.49	2587.0
2010-05-21 03:00:00	NQ	Futures	2076.77	2081.93	2062.46	2069.33	6037.0
2010-05-21 04:00:00	NQ	Futures	2069.61	2076.2	2067.04	2068.76	2794.0
2010-05-21 05:00:00	NQ	Futures	2068.76	2075.91	2063.31	2067.04	2129.0
2010-05-21 06:00:00	NQ	Futures	2066.75	2070.76	2051.86	2056.16	3975.0
2010-05-21 07:00:00	NQ	Futures	2056.44	2060.16	2035.54	2048.71	11437.0
2010-05-21 08:00:00	NQ	Futures	2049.0	2051.0	2037.25	2046.7	13901.0
2010-05-21 09:00:00	NQ	Futures	2046.7	2077.92	2022.36	2065.89	110405.0
2010-05-21 10:00:00	NQ	Futures	2065.61	2077.92	2054.44	2067.61	89729.0
2010-05-21 11:00:00	NQ	Futures	2067.32	2100.83	2066.46	2092.81	60453.0
2010-05-21 12:00:00	NQ	Futures	2092.52	2099.68	2081.93	2084.51	41998.0
2010-05-21 13:00:00	NQ	Futures	2084.51	2088.23	2075.91	2085.65	33393.0
2010-05-21 14:00:00	NQ	Futures	2085.65	2088.8	2062.17	2067.9	39669.0
2010-05-21 15:00:00	NQ	Futures	2068.18	2086.22	2056.73	2084.79	66171.0
2010-05-21 16:00:00	NQ	Futures	2085.08	2086.8	2081.36	2082.22	15110.0
2010-05-21 00:00:00	YM	Futures	9497.3	9525.5	9488.8	9491.7	883.0
2010-05-21 01:00:00	YM	Futures	9492.6	9519.0	9468.1	9510.5	1226.0
2010-05-21 02:00:00	YM	Futures	9511.4	9530.2	9490.7	9516.1	2424.0
2010-05-21 03:00:00	YM	Futures	9516.1	9535.9	9462.5	9489.8	4954.0
2010-05-21 04:00:00	YM	Futures	9489.8	9511.4	9476.6	9483.2	3234.0
2010-05-21 05:00:00	YM	Futures	9483.2	9511.4	9456.8	9472.8	3266.0
2010-05-21 06:00:00	YM	Futures	9472.8	9484.1	9409.8	9428.6	3998.0
2010-05-21 07:00:00	YM	Futures	9425.8	9441.8	9363.7	9403.2	6098.0
2010-05-21 08:00:00	YM	Futures	9403.2	9414.5	9361.8	9390.0	8553.0
2010-05-21 09:00:00	YM	Futures	9390.0	9479.4	9302.5	9448.4	46302.0
2010-05-21 10:00:00	YM	Futures	9448.4	9499.2	9402.3	9454.0	36878.0
2010-05-21 11:00:00	YM	Futures	9454.0	9577.3	9451.2	9555.7	31018.0
2010-05-21 12:00:00	YM	Futures	9554.7	9566.9	9506.7	9517.1	15909.0
2010-05-21 13:00:00	YM	Futures	9516.1	9542.5	9488.8	9534.9	12234.0
2010-05-21 14:00:00	YM	Futures	9535.9	9548.1	9446.5	9480.4	19482.0
2010-05-21 15:00:00	YM	Futures	9480.4	9581.1	9422.0	9578.2	31112.0

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

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