PREVIEW / futures_1hour / 2010-04-19

all futures 1-hour files

  file:    by_date/futures_1hour/2010/2010-04-19.parquet
  size:    45 KB
  rows:    1,376

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-04-19 00:00:00	ES	Futures	1158.58	1160.05	1158.58	1158.82	4767.0
2010-04-19 01:00:00	ES	Futures	1158.82	1159.56	1158.58	1159.07	4529.0
2010-04-19 02:00:00	ES	Futures	1159.31	1160.29	1157.6	1157.85	19695.0
2010-04-19 03:00:00	ES	Futures	1157.85	1161.51	1156.87	1159.56	45700.0
2010-04-19 04:00:00	ES	Futures	1159.56	1160.05	1156.38	1156.63	31581.0
2010-04-19 05:00:00	ES	Futures	1156.63	1158.09	1156.38	1157.85	24891.0
2010-04-19 06:00:00	ES	Futures	1157.85	1158.58	1157.36	1158.34	13970.0
2010-04-19 07:00:00	ES	Futures	1158.34	1158.34	1155.16	1157.36	34920.0
2010-04-19 08:00:00	ES	Futures	1157.6	1159.31	1156.38	1159.07	70800.0
2010-04-19 09:00:00	ES	Futures	1159.07	1165.42	1158.58	1163.71	312082.0
2010-04-19 10:00:00	ES	Futures	1163.71	1166.65	1160.78	1162.0	347005.0
2010-04-19 11:00:00	ES	Futures	1161.76	1162.74	1154.91	1156.38	332155.0
2010-04-19 12:00:00	ES	Futures	1156.14	1158.34	1153.45	1157.85	271159.0
2010-04-19 13:00:00	ES	Futures	1157.6	1158.58	1155.16	1155.65	140519.0
2010-04-19 14:00:00	ES	Futures	1155.65	1164.45	1154.67	1164.2	292941.0
2010-04-19 15:00:00	ES	Futures	1164.2	1167.87	1163.71	1167.14	333379.0
2010-04-19 16:00:00	ES	Futures	1166.89	1169.82	1166.4	1168.11	142845.0
2010-04-19 17:00:00	ES	Futures	1168.36	1169.09	1168.11	1169.09	1712.0
2010-04-19 18:00:00	ES	Futures	1168.85	1169.58	1168.36	1169.34	2972.0
2010-04-19 19:00:00	ES	Futures	1169.34	1169.58	1168.85	1169.58	3047.0
2010-04-19 20:00:00	ES	Futures	1169.82	1170.31	1169.34	1169.82	5407.0
2010-04-19 21:00:00	ES	Futures	1169.82	1170.07	1167.87	1168.11	6208.0
2010-04-19 22:00:00	ES	Futures	1168.36	1168.85	1167.87	1168.36	2755.0
2010-04-19 23:00:00	ES	Futures	1168.36	1169.34	1168.36	1169.34	1245.0
2010-04-19 00:00:00	NQ	Futures	2294.13	2296.14	2293.84	2293.84	124.0
2010-04-19 01:00:00	NQ	Futures	2294.13	2295.56	2293.84	2294.7	183.0
2010-04-19 02:00:00	NQ	Futures	2294.99	2296.71	2293.27	2293.27	1183.0
2010-04-19 03:00:00	NQ	Futures	2293.27	2301.0	2291.27	2297.28	3472.0
2010-04-19 04:00:00	NQ	Futures	2297.57	2298.14	2292.41	2292.99	2233.0
2010-04-19 05:00:00	NQ	Futures	2293.27	2294.7	2291.55	2294.13	1349.0
2010-04-19 06:00:00	NQ	Futures	2293.84	2295.28	2290.41	2293.27	2137.0
2010-04-19 07:00:00	NQ	Futures	2292.99	2294.13	2290.69	2294.13	2491.0
2010-04-19 08:00:00	NQ	Futures	2293.84	2298.14	2293.27	2297.85	5634.0
2010-04-19 09:00:00	NQ	Futures	2297.57	2309.88	2295.28	2305.59	38259.0
2010-04-19 10:00:00	NQ	Futures	2306.16	2308.74	2292.41	2294.7	50719.0
2010-04-19 11:00:00	NQ	Futures	2294.42	2295.85	2278.67	2280.67	42996.0
2010-04-19 12:00:00	NQ	Futures	2280.67	2283.54	2274.66	2282.1	43637.0
2010-04-19 13:00:00	NQ	Futures	2281.82	2282.68	2276.09	2276.66	27347.0
2010-04-19 14:00:00	NQ	Futures	2276.66	2293.84	2275.23	2293.84	41049.0
2010-04-19 15:00:00	NQ	Futures	2293.84	2304.73	2293.27	2302.44	57504.0
2010-04-19 16:00:00	NQ	Futures	2302.44	2307.02	2301.58	2303.58	14226.0
2010-04-19 17:00:00	NQ	Futures	2303.29	2305.3	2303.29	2305.01	179.0
2010-04-19 18:00:00	NQ	Futures	2304.44	2305.59	2303.58	2305.59	205.0
2010-04-19 19:00:00	NQ	Futures	2305.3	2305.87	2304.73	2305.87	163.0
2010-04-19 20:00:00	NQ	Futures	2306.16	2307.3	2305.59	2306.16	200.0
2010-04-19 21:00:00	NQ	Futures	2306.16	2306.16	2302.44	2302.44	321.0
2010-04-19 22:00:00	NQ	Futures	2302.44	2303.87	2302.44	2303.87	161.0
2010-04-19 23:00:00	NQ	Futures	2303.58	2304.73	2303.29	2304.44	73.0
2010-04-19 00:00:00	YM	Futures	10287.7	10296.2	10285.9	10289.6	485.0
2010-04-19 01:00:00	YM	Futures	10289.6	10295.3	10285.9	10291.5	325.0

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

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