PREVIEW / futures_1hour / 2010-04-22

all futures 1-hour files

  file:    by_date/futures_1hour/2010/2010-04-22.parquet
  size:    47 KB
  rows:    1,391

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-22 00:00:00	ES	Futures	1170.56	1171.05	1170.31	1171.05	2815.0
2010-04-22 01:00:00	ES	Futures	1171.05	1171.54	1170.56	1171.29	3081.0
2010-04-22 02:00:00	ES	Futures	1171.05	1171.78	1170.56	1171.29	5840.0
2010-04-22 03:00:00	ES	Futures	1171.29	1174.71	1171.05	1174.71	24974.0
2010-04-22 04:00:00	ES	Futures	1174.71	1177.16	1174.47	1176.18	27117.0
2010-04-22 05:00:00	ES	Futures	1176.18	1176.18	1167.38	1169.34	74043.0
2010-04-22 06:00:00	ES	Futures	1169.34	1169.34	1165.67	1167.38	50039.0
2010-04-22 07:00:00	ES	Futures	1167.14	1168.85	1165.91	1168.36	35967.0
2010-04-22 08:00:00	ES	Futures	1168.36	1169.09	1166.89	1167.14	56266.0
2010-04-22 09:00:00	ES	Futures	1167.14	1167.38	1159.8	1162.98	372949.0
2010-04-22 10:00:00	ES	Futures	1162.98	1168.6	1161.76	1166.16	540508.0
2010-04-22 11:00:00	ES	Futures	1166.16	1167.62	1162.74	1165.18	250405.0
2010-04-22 12:00:00	ES	Futures	1165.18	1168.11	1164.2	1167.14	138503.0
2010-04-22 13:00:00	ES	Futures	1167.14	1174.71	1166.89	1174.71	346289.0
2010-04-22 14:00:00	ES	Futures	1174.71	1176.67	1173.0	1174.96	225001.0
2010-04-22 15:00:00	ES	Futures	1174.96	1180.09	1174.22	1178.38	289342.0
2010-04-22 16:00:00	ES	Futures	1178.38	1178.38	1173.49	1175.93	190048.0
2010-04-22 17:00:00	ES	Futures	1175.93	1176.18	1174.96	1175.93	2018.0
2010-04-22 18:00:00	ES	Futures	1175.69	1175.69	1174.22	1174.71	4448.0
2010-04-22 19:00:00	ES	Futures	1174.71	1174.96	1173.73	1174.22	5631.0
2010-04-22 20:00:00	ES	Futures	1174.47	1175.69	1173.49	1175.2	8250.0
2010-04-22 21:00:00	ES	Futures	1175.2	1175.69	1174.47	1175.2	3404.0
2010-04-22 22:00:00	ES	Futures	1175.2	1175.93	1174.96	1175.45	3736.0
2010-04-22 23:00:00	ES	Futures	1175.45	1175.45	1172.51	1173.0	8151.0
2010-04-22 00:00:00	NQ	Futures	2315.04	2315.9	2314.75	2315.61	122.0
2010-04-22 01:00:00	NQ	Futures	2315.61	2318.19	2315.61	2317.04	561.0
2010-04-22 02:00:00	NQ	Futures	2316.75	2317.33	2316.18	2317.04	361.0
2010-04-22 03:00:00	NQ	Futures	2316.75	2321.62	2316.75	2321.62	2267.0
2010-04-22 04:00:00	NQ	Futures	2321.91	2325.06	2321.62	2323.34	1643.0
2010-04-22 05:00:00	NQ	Futures	2323.34	2323.34	2309.88	2312.17	4276.0
2010-04-22 06:00:00	NQ	Futures	2312.46	2312.46	2304.44	2306.16	4253.0
2010-04-22 07:00:00	NQ	Futures	2305.87	2308.45	2304.44	2307.88	2285.0
2010-04-22 08:00:00	NQ	Futures	2307.88	2309.31	2304.73	2305.01	5750.0
2010-04-22 09:00:00	NQ	Futures	2305.01	2306.73	2291.55	2299.86	57276.0
2010-04-22 10:00:00	NQ	Futures	2299.57	2317.9	2298.14	2312.75	84063.0
2010-04-22 11:00:00	NQ	Futures	2312.46	2314.46	2302.15	2303.87	42491.0
2010-04-22 12:00:00	NQ	Futures	2303.87	2312.46	2302.72	2310.45	21872.0
2010-04-22 13:00:00	NQ	Futures	2310.45	2329.64	2309.88	2329.64	45017.0
2010-04-22 14:00:00	NQ	Futures	2329.64	2335.65	2326.49	2330.21	36133.0
2010-04-22 15:00:00	NQ	Futures	2330.5	2342.53	2330.21	2339.66	40646.0
2010-04-22 16:00:00	NQ	Futures	2339.95	2341.1	2327.35	2329.93	21994.0
2010-04-22 17:00:00	NQ	Futures	2329.93	2330.21	2328.21	2330.21	514.0
2010-04-22 18:00:00	NQ	Futures	2329.93	2329.93	2328.21	2329.35	305.0
2010-04-22 19:00:00	NQ	Futures	2329.35	2329.64	2328.21	2328.5	152.0
2010-04-22 20:00:00	NQ	Futures	2328.5	2330.21	2327.35	2329.93	296.0
2010-04-22 21:00:00	NQ	Futures	2330.21	2331.07	2328.78	2329.35	178.0
2010-04-22 22:00:00	NQ	Futures	2329.93	2330.79	2329.35	2329.35	237.0
2010-04-22 23:00:00	NQ	Futures	2329.64	2329.64	2325.06	2326.78	377.0
2010-04-22 00:00:00	YM	Futures	10385.6	10390.3	10382.8	10389.4	243.0
2010-04-22 01:00:00	YM	Futures	10389.4	10396.9	10388.4	10395.0	455.0

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

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