PREVIEW / futures_1hour / 2010-06-18

all futures 1-hour files

  file:    by_date/futures_1hour/2010/2010-06-18.parquet
  size:    37 KB
  rows:    1,083

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-18 00:00:00	ES	Futures	1091.94	1091.94	1089.98	1090.22	2452.0
2010-06-18 01:00:00	ES	Futures	1089.98	1090.71	1088.75	1089.98	4654.0
2010-06-18 02:00:00	ES	Futures	1090.22	1091.2	1088.5	1089.24	6650.0
2010-06-18 03:00:00	ES	Futures	1088.99	1092.18	1088.5	1090.47	22362.0
2010-06-18 04:00:00	ES	Futures	1090.47	1092.67	1090.47	1091.69	22891.0
2010-06-18 05:00:00	ES	Futures	1091.69	1093.17	1090.47	1091.45	17371.0
2010-06-18 06:00:00	ES	Futures	1091.69	1091.69	1087.77	1088.99	31110.0
2010-06-18 07:00:00	ES	Futures	1088.99	1091.2	1088.99	1090.22	23002.0
2010-06-18 08:00:00	ES	Futures	1090.22	1092.18	1088.75	1089.73	57842.0
2010-06-18 09:00:00	ES	Futures	1089.98	1093.41	1088.5	1088.99	298255.0
2010-06-18 10:00:00	ES	Futures	1088.99	1096.11	1088.75	1095.37	332694.0
2010-06-18 11:00:00	ES	Futures	1095.13	1096.11	1091.2	1092.18	193850.0
2010-06-18 12:00:00	ES	Futures	1092.18	1094.15	1089.49	1090.96	119357.0
2010-06-18 13:00:00	ES	Futures	1090.96	1093.17	1089.98	1091.45	93502.0
2010-06-18 14:00:00	ES	Futures	1091.2	1093.66	1090.71	1092.43	87077.0
2010-06-18 15:00:00	ES	Futures	1092.43	1092.67	1089.73	1091.69	164468.0
2010-06-18 16:00:00	ES	Futures	1091.94	1092.18	1089.49	1089.73	93283.0
2010-06-18 00:00:00	NQ	Futures	2191.08	2191.08	2187.65	2188.22	162.0
2010-06-18 01:00:00	NQ	Futures	2188.22	2189.36	2185.64	2187.93	359.0
2010-06-18 02:00:00	NQ	Futures	2187.36	2189.08	2184.49	2185.35	602.0
2010-06-18 03:00:00	NQ	Futures	2185.35	2191.94	2185.35	2189.36	1789.0
2010-06-18 04:00:00	NQ	Futures	2189.65	2192.52	2189.65	2191.66	1467.0
2010-06-18 05:00:00	NQ	Futures	2191.66	2194.24	2189.65	2191.37	1167.0
2010-06-18 06:00:00	NQ	Futures	2191.37	2192.23	2184.49	2187.07	1719.0
2010-06-18 07:00:00	NQ	Futures	2187.36	2190.8	2187.07	2188.79	1279.0
2010-06-18 08:00:00	NQ	Futures	2189.08	2192.23	2183.63	2186.79	5419.0
2010-06-18 09:00:00	NQ	Futures	2186.79	2194.52	2185.64	2186.21	46976.0
2010-06-18 10:00:00	NQ	Futures	2186.21	2206.27	2186.21	2204.84	54796.0
2010-06-18 11:00:00	NQ	Futures	2204.84	2206.27	2191.66	2195.1	29572.0
2010-06-18 12:00:00	NQ	Futures	2194.81	2198.25	2183.92	2188.22	24209.0
2010-06-18 13:00:00	NQ	Futures	2188.22	2193.66	2186.79	2189.36	16109.0
2010-06-18 14:00:00	NQ	Futures	2189.36	2195.1	2188.79	2192.23	16787.0
2010-06-18 15:00:00	NQ	Futures	2192.23	2192.52	2185.64	2191.08	30323.0
2010-06-18 16:00:00	NQ	Futures	2191.08	2192.23	2187.65	2187.93	9625.0
2010-06-18 00:00:00	YM	Futures	9820.1	9822.0	9808.7	9810.6	202.0
2010-06-18 01:00:00	YM	Futures	9810.6	9816.3	9802.1	9810.6	321.0
2010-06-18 02:00:00	YM	Futures	9811.6	9818.2	9799.3	9805.0	831.0
2010-06-18 03:00:00	YM	Futures	9804.0	9823.9	9801.2	9815.4	2256.0
2010-06-18 04:00:00	YM	Futures	9815.4	9829.6	9815.4	9823.9	2112.0
2010-06-18 05:00:00	YM	Futures	9823.9	9835.2	9814.4	9824.8	1698.0
2010-06-18 06:00:00	YM	Futures	9824.8	9825.8	9794.5	9804.0	1737.0
2010-06-18 07:00:00	YM	Futures	9803.1	9820.1	9803.1	9809.7	1228.0
2010-06-18 08:00:00	YM	Futures	9809.7	9823.9	9799.3	9804.0	3281.0
2010-06-18 09:00:00	YM	Futures	9805.0	9840.0	9797.4	9810.6	17146.0
2010-06-18 10:00:00	YM	Futures	9811.6	9866.5	9809.7	9861.7	23630.0
2010-06-18 11:00:00	YM	Futures	9861.7	9864.6	9829.6	9834.3	15731.0
2010-06-18 12:00:00	YM	Futures	9834.3	9849.4	9814.4	9826.7	10325.0
2010-06-18 13:00:00	YM	Futures	9825.8	9842.8	9816.3	9826.7	7834.0
2010-06-18 14:00:00	YM	Futures	9825.8	9847.5	9822.9	9840.0	7566.0
2010-06-18 15:00:00	YM	Futures	9840.9	9840.9	9821.0	9832.4	13608.0

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

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