PREVIEW / futures_1hour / 2010-04-15

all futures 1-hour files

  file:    by_date/futures_1hour/2010/2010-04-15.parquet
  size:    46 KB
  rows:    1,386

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-15 00:00:00	ES	Futures	1177.89	1178.13	1177.16	1177.65	2652.0
2010-04-15 01:00:00	ES	Futures	1177.65	1178.13	1177.4	1177.4	1863.0
2010-04-15 02:00:00	ES	Futures	1177.65	1178.38	1177.4	1178.13	6168.0
2010-04-15 03:00:00	ES	Futures	1178.38	1178.38	1176.91	1177.89	18865.0
2010-04-15 04:00:00	ES	Futures	1177.89	1178.38	1175.93	1176.42	16384.0
2010-04-15 05:00:00	ES	Futures	1176.18	1176.91	1174.22	1175.45	26045.0
2010-04-15 06:00:00	ES	Futures	1175.2	1177.4	1175.2	1177.16	14867.0
2010-04-15 07:00:00	ES	Futures	1176.91	1177.4	1176.42	1177.16	17992.0
2010-04-15 08:00:00	ES	Futures	1177.16	1178.38	1175.69	1177.4	59005.0
2010-04-15 09:00:00	ES	Futures	1177.4	1179.36	1176.67	1178.87	167284.0
2010-04-15 10:00:00	ES	Futures	1178.62	1183.02	1177.89	1182.78	301232.0
2010-04-15 11:00:00	ES	Futures	1183.02	1183.51	1178.38	1179.36	295895.0
2010-04-15 12:00:00	ES	Futures	1179.36	1180.58	1177.65	1180.33	157435.0
2010-04-15 13:00:00	ES	Futures	1180.33	1182.78	1179.85	1182.05	121305.0
2010-04-15 14:00:00	ES	Futures	1182.05	1183.27	1181.56	1183.27	109364.0
2010-04-15 15:00:00	ES	Futures	1183.27	1183.27	1179.11	1181.07	244778.0
2010-04-15 16:00:00	ES	Futures	1181.31	1181.8	1179.11	1179.36	157419.0
2010-04-15 17:00:00	ES	Futures	1179.36	1179.85	1179.11	1179.11	2627.0
2010-04-15 18:00:00	ES	Futures	1179.36	1179.85	1179.11	1179.36	1504.0
2010-04-15 19:00:00	ES	Futures	1179.36	1179.6	1178.13	1178.62	3597.0
2010-04-15 20:00:00	ES	Futures	1178.38	1178.38	1176.67	1176.67	7741.0
2010-04-15 21:00:00	ES	Futures	1176.91	1177.4	1175.93	1176.18	8833.0
2010-04-15 22:00:00	ES	Futures	1175.93	1176.42	1174.47	1174.96	16960.0
2010-04-15 23:00:00	ES	Futures	1174.96	1176.18	1174.96	1174.96	5545.0
2010-04-15 00:00:00	NQ	Futures	2318.19	2319.05	2317.33	2317.9	215.0
2010-04-15 01:00:00	NQ	Futures	2318.19	2318.47	2317.61	2317.9	140.0
2010-04-15 02:00:00	NQ	Futures	2318.19	2319.33	2317.9	2319.33	253.0
2010-04-15 03:00:00	NQ	Futures	2319.33	2319.62	2316.75	2317.9	1830.0
2010-04-15 04:00:00	NQ	Futures	2318.19	2318.19	2313.32	2313.89	1324.0
2010-04-15 05:00:00	NQ	Futures	2313.89	2314.46	2311.31	2313.03	1293.0
2010-04-15 06:00:00	NQ	Futures	2313.03	2316.47	2312.75	2316.18	699.0
2010-04-15 07:00:00	NQ	Futures	2315.9	2316.47	2314.75	2315.9	1018.0
2010-04-15 08:00:00	NQ	Futures	2315.61	2318.76	2313.32	2317.61	5677.0
2010-04-15 09:00:00	NQ	Futures	2317.61	2325.06	2316.47	2323.63	33744.0
2010-04-15 10:00:00	NQ	Futures	2323.91	2332.22	2321.05	2331.65	47941.0
2010-04-15 11:00:00	NQ	Futures	2331.36	2334.22	2324.77	2326.2	37334.0
2010-04-15 12:00:00	NQ	Futures	2326.49	2329.64	2324.49	2329.07	25626.0
2010-04-15 13:00:00	NQ	Futures	2329.07	2332.5	2327.35	2330.5	16124.0
2010-04-15 14:00:00	NQ	Futures	2330.5	2333.94	2329.93	2333.94	17032.0
2010-04-15 15:00:00	NQ	Futures	2333.94	2334.22	2327.92	2331.07	41229.0
2010-04-15 16:00:00	NQ	Futures	2331.07	2331.93	2323.63	2323.91	20107.0
2010-04-15 17:00:00	NQ	Futures	2324.2	2325.92	2323.34	2323.91	379.0
2010-04-15 18:00:00	NQ	Futures	2323.34	2325.06	2323.05	2325.06	345.0
2010-04-15 19:00:00	NQ	Futures	2325.06	2325.35	2323.05	2323.63	225.0
2010-04-15 20:00:00	NQ	Futures	2323.34	2323.91	2321.34	2321.34	901.0
2010-04-15 21:00:00	NQ	Futures	2321.05	2322.2	2318.76	2319.9	682.0
2010-04-15 22:00:00	NQ	Futures	2319.9	2320.76	2316.75	2318.19	594.0
2010-04-15 23:00:00	NQ	Futures	2318.19	2321.91	2318.19	2319.62	549.0
2010-04-15 00:00:00	YM	Futures	10400.7	10401.6	10397.8	10398.8	143.0
2010-04-15 01:00:00	YM	Futures	10397.8	10403.5	10397.8	10399.7	335.0

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

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