PREVIEW / futures_1hour / 2010-11-04

all futures 1-hour files

  file:    by_date/futures_1hour/2010/2010-11-04.parquet
  size:    48 KB
  rows:    1,449

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-11-04 00:00:00	ES	Futures	1179.89	1180.63	1179.15	1179.4	5062.0
2010-11-04 01:00:00	ES	Futures	1179.4	1179.89	1178.42	1179.4	5111.0
2010-11-04 02:00:00	ES	Futures	1179.15	1180.14	1178.91	1180.14	2830.0
2010-11-04 03:00:00	ES	Futures	1180.14	1181.62	1179.4	1181.37	18054.0
2010-11-04 04:00:00	ES	Futures	1181.37	1187.29	1181.37	1186.8	75615.0
2010-11-04 05:00:00	ES	Futures	1187.04	1188.27	1186.3	1187.29	32599.0
2010-11-04 06:00:00	ES	Futures	1187.29	1188.77	1187.04	1187.78	26120.0
2010-11-04 07:00:00	ES	Futures	1187.78	1188.52	1187.04	1188.27	39962.0
2010-11-04 08:00:00	ES	Futures	1188.52	1192.22	1187.78	1191.23	113771.0
2010-11-04 09:00:00	ES	Futures	1191.23	1193.45	1189.51	1192.22	266477.0
2010-11-04 10:00:00	ES	Futures	1192.22	1196.65	1189.75	1195.92	362360.0
2010-11-04 11:00:00	ES	Futures	1196.16	1197.89	1194.44	1194.93	295642.0
2010-11-04 12:00:00	ES	Futures	1194.93	1196.9	1193.94	1196.41	165063.0
2010-11-04 13:00:00	ES	Futures	1196.41	1197.39	1194.93	1195.18	128263.0
2010-11-04 14:00:00	ES	Futures	1195.42	1198.38	1194.44	1196.65	154022.0
2010-11-04 15:00:00	ES	Futures	1196.65	1201.58	1196.41	1200.6	451499.0
2010-11-04 16:00:00	ES	Futures	1200.6	1201.58	1199.86	1200.35	115523.0
2010-11-04 17:00:00	ES	Futures	1200.35	1200.85	1199.86	1200.35	3201.0
2010-11-04 18:00:00	ES	Futures	1200.35	1200.85	1200.11	1200.11	2995.0
2010-11-04 19:00:00	ES	Futures	1200.11	1200.85	1200.11	1200.85	2934.0
2010-11-04 20:00:00	ES	Futures	1200.6	1200.85	1199.37	1199.61	6274.0
2010-11-04 21:00:00	ES	Futures	1199.61	1200.6	1199.37	1199.86	3989.0
2010-11-04 22:00:00	ES	Futures	1199.86	1200.35	1199.37	1199.61	3466.0
2010-11-04 23:00:00	ES	Futures	1199.61	1200.11	1199.12	1199.61	3913.0
2010-11-04 00:00:00	NQ	Futures	2484.29	2485.44	2483.71	2483.71	191.0
2010-11-04 01:00:00	NQ	Futures	2483.71	2484.29	2481.99	2482.85	130.0
2010-11-04 02:00:00	NQ	Futures	2483.43	2484.86	2482.57	2484.86	177.0
2010-11-04 03:00:00	NQ	Futures	2484.86	2486.01	2482.28	2486.01	900.0
2010-11-04 04:00:00	NQ	Futures	2485.72	2495.76	2485.72	2494.62	3538.0
2010-11-04 05:00:00	NQ	Futures	2494.62	2497.77	2493.76	2496.05	1961.0
2010-11-04 06:00:00	NQ	Futures	2496.05	2498.35	2496.05	2497.2	1696.0
2010-11-04 07:00:00	NQ	Futures	2497.2	2500.93	2496.63	2500.93	2625.0
2010-11-04 08:00:00	NQ	Futures	2500.93	2506.38	2499.21	2505.52	9625.0
2010-11-04 09:00:00	NQ	Futures	2505.52	2510.11	2502.08	2504.09	49884.0
2010-11-04 10:00:00	NQ	Futures	2504.37	2512.12	2497.49	2510.97	57799.0
2010-11-04 11:00:00	NQ	Futures	2510.97	2514.41	2504.95	2505.52	38918.0
2010-11-04 12:00:00	NQ	Futures	2505.23	2508.96	2503.51	2506.95	29311.0
2010-11-04 13:00:00	NQ	Futures	2507.24	2510.4	2502.36	2502.36	31582.0
2010-11-04 14:00:00	NQ	Futures	2502.36	2509.25	2500.64	2504.37	27443.0
2010-11-04 15:00:00	NQ	Futures	2504.37	2508.1	2500.64	2504.95	55611.0
2010-11-04 16:00:00	NQ	Futures	2505.23	2508.39	2503.51	2504.66	10270.0
2010-11-04 17:00:00	NQ	Futures	2504.66	2505.81	2503.8	2505.23	220.0
2010-11-04 18:00:00	NQ	Futures	2504.95	2506.09	2503.51	2504.66	146.0
2010-11-04 19:00:00	NQ	Futures	2504.37	2505.81	2503.8	2504.95	121.0
2010-11-04 20:00:00	NQ	Futures	2504.66	2505.52	2503.22	2503.8	456.0
2010-11-04 21:00:00	NQ	Futures	2504.09	2505.52	2503.51	2503.8	268.0
2010-11-04 22:00:00	NQ	Futures	2504.37	2504.66	2502.94	2503.22	272.0
2010-11-04 23:00:00	NQ	Futures	2503.22	2503.22	2500.64	2501.79	778.0
2010-11-04 00:00:00	YM	Futures	10647.8	10649.7	10639.2	10642.1	125.0
2010-11-04 01:00:00	YM	Futures	10642.1	10644.9	10634.4	10639.2	117.0

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

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