PREVIEW / futures_1hour / 2010-07-09

all futures 1-hour files

  file:    by_date/futures_1hour/2010/2010-07-09.parquet
  size:    37 KB
  rows:    1,091

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-09 00:00:00	ES	Futures	1048.02	1048.26	1047.53	1048.02	1995.0
2010-07-09 01:00:00	ES	Futures	1048.02	1049.24	1046.79	1047.53	7679.0
2010-07-09 02:00:00	ES	Futures	1047.53	1047.77	1046.54	1047.28	6785.0
2010-07-09 03:00:00	ES	Futures	1047.53	1047.77	1045.56	1045.81	20116.0
2010-07-09 04:00:00	ES	Futures	1045.81	1048.75	1045.56	1046.3	22159.0
2010-07-09 05:00:00	ES	Futures	1046.3	1047.03	1045.07	1046.79	13183.0
2010-07-09 06:00:00	ES	Futures	1047.03	1047.77	1045.56	1045.81	12801.0
2010-07-09 07:00:00	ES	Futures	1046.05	1049.0	1046.05	1046.79	21342.0
2010-07-09 08:00:00	ES	Futures	1046.79	1047.53	1043.6	1045.56	49133.0
2010-07-09 09:00:00	ES	Futures	1045.56	1048.75	1044.58	1046.79	192317.0
2010-07-09 10:00:00	ES	Futures	1046.79	1051.94	1046.54	1048.51	272415.0
2010-07-09 11:00:00	ES	Futures	1048.26	1049.49	1045.81	1047.53	149391.0
2010-07-09 12:00:00	ES	Futures	1047.53	1049.49	1047.03	1048.26	74830.0
2010-07-09 13:00:00	ES	Futures	1048.26	1050.22	1047.53	1049.73	86339.0
2010-07-09 14:00:00	ES	Futures	1049.98	1053.66	1048.02	1052.92	132061.0
2010-07-09 15:00:00	ES	Futures	1053.17	1054.89	1050.72	1054.4	224759.0
2010-07-09 16:00:00	ES	Futures	1054.15	1055.13	1051.7	1051.94	104711.0
2010-07-09 00:00:00	NQ	Futures	2060.12	2060.41	2058.12	2060.12	259.0
2010-07-09 01:00:00	NQ	Futures	2059.55	2062.7	2058.4	2060.12	648.0
2010-07-09 02:00:00	NQ	Futures	2059.84	2060.7	2058.12	2060.41	463.0
2010-07-09 03:00:00	NQ	Futures	2060.41	2060.7	2055.82	2056.4	1384.0
2010-07-09 04:00:00	NQ	Futures	2056.11	2061.27	2055.25	2056.68	1317.0
2010-07-09 05:00:00	NQ	Futures	2056.68	2059.55	2055.25	2059.55	1025.0
2010-07-09 06:00:00	NQ	Futures	2059.26	2059.84	2055.82	2056.68	988.0
2010-07-09 07:00:00	NQ	Futures	2056.97	2062.13	2056.97	2058.12	1607.0
2010-07-09 08:00:00	NQ	Futures	2058.12	2058.69	2050.95	2054.11	5855.0
2010-07-09 09:00:00	NQ	Futures	2054.39	2065.57	2052.96	2061.56	37536.0
2010-07-09 10:00:00	NQ	Futures	2061.56	2071.87	2060.12	2065.28	38505.0
2010-07-09 11:00:00	NQ	Futures	2064.99	2070.15	2061.27	2064.42	20385.0
2010-07-09 12:00:00	NQ	Futures	2064.42	2068.72	2062.7	2064.99	13419.0
2010-07-09 13:00:00	NQ	Futures	2064.99	2068.15	2062.42	2067.0	15212.0
2010-07-09 14:00:00	NQ	Futures	2066.71	2073.59	2063.56	2072.45	18006.0
2010-07-09 15:00:00	NQ	Futures	2072.73	2078.46	2069.01	2077.89	35981.0
2010-07-09 16:00:00	NQ	Futures	2077.89	2080.76	2075.31	2076.74	12933.0
2010-07-09 00:00:00	YM	Futures	9546.5	9550.3	9544.6	9550.3	126.0
2010-07-09 01:00:00	YM	Futures	9548.4	9556.9	9540.8	9545.6	416.0
2010-07-09 02:00:00	YM	Futures	9545.6	9547.5	9539.0	9545.6	485.0
2010-07-09 03:00:00	YM	Futures	9545.6	9549.4	9532.3	9532.3	1479.0
2010-07-09 04:00:00	YM	Futures	9531.4	9553.2	9530.4	9535.2	1158.0
2010-07-09 05:00:00	YM	Futures	9536.1	9540.8	9528.5	9539.9	726.0
2010-07-09 06:00:00	YM	Futures	9539.9	9545.6	9530.4	9532.3	807.0
2010-07-09 07:00:00	YM	Futures	9534.2	9554.1	9534.2	9537.1	985.0
2010-07-09 08:00:00	YM	Futures	9538.0	9541.8	9514.3	9528.5	2929.0
2010-07-09 09:00:00	YM	Futures	9528.5	9557.9	9525.7	9545.6	14570.0
2010-07-09 10:00:00	YM	Futures	9545.6	9587.2	9543.7	9556.9	22082.0
2010-07-09 11:00:00	YM	Futures	9556.9	9562.6	9532.3	9544.6	12242.0
2010-07-09 12:00:00	YM	Futures	9545.6	9559.8	9539.0	9547.5	7458.0
2010-07-09 13:00:00	YM	Futures	9546.5	9560.7	9542.7	9556.9	8032.0
2010-07-09 14:00:00	YM	Futures	9556.9	9589.1	9542.7	9583.4	10568.0
2010-07-09 15:00:00	YM	Futures	9584.4	9606.2	9564.5	9603.3	18017.0

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

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