PREVIEW / futures_1hour / 2010-10-18

all futures 1-hour files

  file:    by_date/futures_1hour/2010/2010-10-18.parquet
  size:    47 KB
  rows:    1,403

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-10-18 00:00:00	ES	Futures	1152.29	1152.78	1151.3	1152.78	3107.0
2010-10-18 01:00:00	ES	Futures	1152.54	1152.78	1150.07	1150.32	7769.0
2010-10-18 02:00:00	ES	Futures	1150.32	1152.78	1149.58	1151.3	13142.0
2010-10-18 03:00:00	ES	Futures	1151.3	1151.8	1149.33	1149.82	27137.0
2010-10-18 04:00:00	ES	Futures	1150.07	1152.29	1148.35	1151.3	24242.0
2010-10-18 05:00:00	ES	Futures	1151.3	1154.75	1151.06	1153.77	19137.0
2010-10-18 06:00:00	ES	Futures	1153.52	1155.49	1152.78	1154.51	14973.0
2010-10-18 07:00:00	ES	Futures	1154.51	1154.75	1152.78	1153.27	15501.0
2010-10-18 08:00:00	ES	Futures	1153.52	1156.97	1151.55	1156.73	61363.0
2010-10-18 09:00:00	ES	Futures	1156.73	1159.93	1153.77	1158.94	213588.0
2010-10-18 10:00:00	ES	Futures	1158.94	1161.65	1157.46	1161.16	258938.0
2010-10-18 11:00:00	ES	Futures	1161.16	1161.41	1156.97	1158.94	145559.0
2010-10-18 12:00:00	ES	Futures	1159.19	1159.93	1157.96	1158.45	67609.0
2010-10-18 13:00:00	ES	Futures	1158.45	1160.18	1158.45	1159.19	63945.0
2010-10-18 14:00:00	ES	Futures	1159.44	1162.39	1158.7	1162.15	121828.0
2010-10-18 15:00:00	ES	Futures	1161.9	1165.6	1161.9	1164.12	262968.0
2010-10-18 16:00:00	ES	Futures	1164.12	1165.35	1154.75	1155.49	141048.0
2010-10-18 17:00:00	ES	Futures	1155.49	1157.96	1155.0	1155.99	13154.0
2010-10-18 18:00:00	ES	Futures	1156.23	1156.97	1154.75	1155.99	10513.0
2010-10-18 19:00:00	ES	Futures	1155.99	1157.46	1155.99	1157.22	5013.0
2010-10-18 20:00:00	ES	Futures	1157.22	1159.44	1157.22	1158.2	12331.0
2010-10-18 21:00:00	ES	Futures	1157.96	1158.2	1155.99	1156.23	8483.0
2010-10-18 22:00:00	ES	Futures	1156.23	1157.46	1155.74	1156.97	4634.0
2010-10-18 23:00:00	ES	Futures	1157.22	1157.46	1155.25	1155.25	3285.0
2010-10-18 00:00:00	NQ	Futures	2394.49	2395.92	2391.91	2395.92	157.0
2010-10-18 01:00:00	NQ	Futures	2395.92	2395.92	2391.62	2392.19	788.0
2010-10-18 02:00:00	NQ	Futures	2392.19	2397.93	2391.62	2395.35	1388.0
2010-10-18 03:00:00	NQ	Futures	2395.06	2396.5	2392.19	2393.34	2239.0
2010-10-18 04:00:00	NQ	Futures	2393.34	2397.07	2390.18	2395.92	1907.0
2010-10-18 05:00:00	NQ	Futures	2395.92	2401.37	2395.64	2400.23	1686.0
2010-10-18 06:00:00	NQ	Futures	2400.23	2402.81	2398.5	2399.65	1687.0
2010-10-18 07:00:00	NQ	Futures	2399.37	2401.09	2398.5	2399.08	1078.0
2010-10-18 08:00:00	NQ	Futures	2399.37	2408.83	2396.78	2406.25	7536.0
2010-10-18 09:00:00	NQ	Futures	2406.25	2409.69	2396.5	2407.69	43162.0
2010-10-18 10:00:00	NQ	Futures	2407.69	2410.84	2402.23	2406.83	40663.0
2010-10-18 11:00:00	NQ	Futures	2407.11	2407.69	2397.93	2401.95	28916.0
2010-10-18 12:00:00	NQ	Futures	2401.95	2403.38	2397.93	2398.5	20446.0
2010-10-18 13:00:00	NQ	Futures	2398.5	2402.23	2398.22	2399.37	19509.0
2010-10-18 14:00:00	NQ	Futures	2399.37	2406.25	2398.79	2404.82	26005.0
2010-10-18 15:00:00	NQ	Futures	2404.82	2413.42	2404.82	2412.85	42935.0
2010-10-18 16:00:00	NQ	Futures	2412.85	2415.43	2360.92	2364.94	34966.0
2010-10-18 17:00:00	NQ	Futures	2364.94	2374.41	2364.08	2370.1	5410.0
2010-10-18 18:00:00	NQ	Futures	2370.68	2371.54	2367.81	2370.1	1063.0
2010-10-18 19:00:00	NQ	Futures	2369.81	2372.68	2369.81	2370.96	548.0
2010-10-18 20:00:00	NQ	Futures	2370.96	2374.98	2370.68	2372.68	912.0
2010-10-18 21:00:00	NQ	Futures	2372.11	2372.4	2369.53	2370.39	753.0
2010-10-18 22:00:00	NQ	Futures	2370.68	2375.55	2370.1	2373.83	745.0
2010-10-18 23:00:00	NQ	Futures	2374.12	2374.12	2369.81	2370.68	404.0
2010-10-18 00:00:00	YM	Futures	10451.5	10453.4	10444.9	10453.4	71.0
2010-10-18 01:00:00	YM	Futures	10455.3	10455.3	10435.3	10437.3	323.0

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

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