PREVIEW / futures_1hour / 2010-04-23

all futures 1-hour files

  file:    by_date/futures_1hour/2010/2010-04-23.parquet
  size:    39 KB
  rows:    1,117

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-23 00:00:00	ES	Futures	1173.0	1174.22	1172.76	1173.98	3776.0
2010-04-23 01:00:00	ES	Futures	1173.73	1174.71	1173.73	1174.22	2220.0
2010-04-23 02:00:00	ES	Futures	1174.22	1174.96	1172.02	1172.27	14269.0
2010-04-23 03:00:00	ES	Futures	1172.27	1174.47	1170.8	1174.47	36351.0
2010-04-23 04:00:00	ES	Futures	1174.71	1180.09	1174.47	1179.36	41106.0
2010-04-23 05:00:00	ES	Futures	1179.36	1179.85	1177.4	1177.89	28820.0
2010-04-23 06:00:00	ES	Futures	1177.89	1179.11	1175.93	1178.13	20295.0
2010-04-23 07:00:00	ES	Futures	1178.13	1179.85	1177.89	1179.36	21803.0
2010-04-23 08:00:00	ES	Futures	1179.36	1180.09	1176.67	1177.16	87980.0
2010-04-23 09:00:00	ES	Futures	1177.4	1178.62	1174.47	1177.65	243164.0
2010-04-23 10:00:00	ES	Futures	1177.65	1183.27	1176.91	1178.13	418805.0
2010-04-23 11:00:00	ES	Futures	1178.13	1179.6	1174.71	1177.16	224176.0
2010-04-23 12:00:00	ES	Futures	1177.16	1180.82	1177.16	1180.58	95240.0
2010-04-23 13:00:00	ES	Futures	1180.58	1181.56	1179.36	1181.07	106678.0
2010-04-23 14:00:00	ES	Futures	1181.07	1184.49	1180.33	1184.0	134825.0
2010-04-23 15:00:00	ES	Futures	1184.25	1186.69	1183.02	1186.2	223209.0
2010-04-23 16:00:00	ES	Futures	1186.2	1186.45	1184.73	1185.71	103807.0
2010-04-23 00:00:00	NQ	Futures	2327.06	2329.64	2326.2	2329.07	188.0
2010-04-23 01:00:00	NQ	Futures	2329.07	2330.21	2328.78	2329.93	188.0
2010-04-23 02:00:00	NQ	Futures	2329.64	2330.21	2327.06	2327.06	654.0
2010-04-23 03:00:00	NQ	Futures	2327.06	2330.21	2324.49	2329.93	2320.0
2010-04-23 04:00:00	NQ	Futures	2329.93	2338.8	2329.35	2337.66	3477.0
2010-04-23 05:00:00	NQ	Futures	2337.66	2338.52	2334.51	2336.8	1623.0
2010-04-23 06:00:00	NQ	Futures	2336.8	2338.23	2334.51	2335.37	1370.0
2010-04-23 07:00:00	NQ	Futures	2335.37	2338.8	2335.37	2338.52	1523.0
2010-04-23 08:00:00	NQ	Futures	2338.52	2347.11	2338.23	2339.38	13273.0
2010-04-23 09:00:00	NQ	Futures	2339.66	2345.39	2335.65	2343.67	45959.0
2010-04-23 10:00:00	NQ	Futures	2344.25	2351.12	2335.37	2337.95	65848.0
2010-04-23 11:00:00	NQ	Futures	2337.95	2338.8	2330.5	2336.23	40682.0
2010-04-23 12:00:00	NQ	Futures	2336.23	2342.53	2335.08	2342.24	17479.0
2010-04-23 13:00:00	NQ	Futures	2341.96	2341.96	2335.94	2340.52	22103.0
2010-04-23 14:00:00	NQ	Futures	2340.52	2350.26	2338.52	2350.26	27009.0
2010-04-23 15:00:00	NQ	Futures	2349.97	2352.26	2345.11	2349.97	32040.0
2010-04-23 16:00:00	NQ	Futures	2349.97	2351.41	2347.97	2350.55	8935.0
2010-04-23 00:00:00	YM	Futures	10397.8	10406.3	10396.9	10406.3	236.0
2010-04-23 01:00:00	YM	Futures	10404.4	10412.9	10399.7	10409.1	287.0
2010-04-23 02:00:00	YM	Futures	10409.1	10416.6	10391.2	10391.2	1466.0
2010-04-23 03:00:00	YM	Futures	10393.1	10414.8	10385.6	10413.8	2917.0
2010-04-23 04:00:00	YM	Futures	10413.8	10447.7	10408.2	10439.2	2757.0
2010-04-23 05:00:00	YM	Futures	10440.2	10444.9	10427.0	10430.8	1824.0
2010-04-23 06:00:00	YM	Futures	10427.9	10437.3	10411.9	10429.8	1169.0
2010-04-23 07:00:00	YM	Futures	10429.8	10443.0	10429.8	10438.3	993.0
2010-04-23 08:00:00	YM	Futures	10438.3	10444.9	10415.7	10422.3	3228.0
2010-04-23 09:00:00	YM	Futures	10423.2	10434.5	10401.6	10430.8	15326.0
2010-04-23 10:00:00	YM	Futures	10430.8	10475.9	10427.9	10438.3	33871.0
2010-04-23 11:00:00	YM	Futures	10439.2	10443.9	10409.1	10427.0	17863.0
2010-04-23 12:00:00	YM	Futures	10427.0	10453.3	10427.0	10451.5	5166.0
2010-04-23 13:00:00	YM	Futures	10451.5	10458.1	10440.2	10451.5	5530.0
2010-04-23 14:00:00	YM	Futures	10451.5	10472.2	10445.8	10469.3	7695.0
2010-04-23 15:00:00	YM	Futures	10468.4	10494.7	10461.8	10489.1	14341.0

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

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