PREVIEW / futures_1hour / 2010-04-30

all futures 1-hour files

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

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-30 00:00:00	ES	Futures	1177.4	1178.13	1176.18	1176.67	4163.0
2010-04-30 01:00:00	ES	Futures	1176.42	1176.67	1175.2	1175.2	3098.0
2010-04-30 02:00:00	ES	Futures	1175.2	1177.89	1174.96	1177.89	5441.0
2010-04-30 03:00:00	ES	Futures	1177.65	1180.33	1177.16	1180.09	34715.0
2010-04-30 04:00:00	ES	Futures	1180.33	1181.07	1179.11	1180.82	23005.0
2010-04-30 05:00:00	ES	Futures	1180.58	1180.82	1177.65	1179.6	18055.0
2010-04-30 06:00:00	ES	Futures	1179.36	1180.33	1176.67	1177.4	20563.0
2010-04-30 07:00:00	ES	Futures	1177.65	1180.33	1176.42	1180.09	28507.0
2010-04-30 08:00:00	ES	Futures	1180.09	1180.33	1176.91	1176.91	71373.0
2010-04-30 09:00:00	ES	Futures	1177.16	1178.62	1173.73	1173.73	254272.0
2010-04-30 10:00:00	ES	Futures	1173.73	1175.69	1166.89	1173.98	590514.0
2010-04-30 11:00:00	ES	Futures	1173.73	1175.2	1171.54	1173.49	233289.0
2010-04-30 12:00:00	ES	Futures	1173.49	1173.73	1162.0	1163.22	397959.0
2010-04-30 13:00:00	ES	Futures	1163.22	1167.87	1161.76	1165.18	209778.0
2010-04-30 14:00:00	ES	Futures	1165.18	1167.14	1160.29	1161.76	220759.0
2010-04-30 15:00:00	ES	Futures	1161.51	1163.71	1156.38	1157.11	577657.0
2010-04-30 16:00:00	ES	Futures	1157.11	1160.29	1156.87	1159.31	162034.0
2010-04-30 00:00:00	NQ	Futures	2336.23	2340.52	2335.65	2336.51	978.0
2010-04-30 01:00:00	NQ	Futures	2336.8	2336.8	2334.22	2334.51	162.0
2010-04-30 02:00:00	NQ	Futures	2334.22	2338.23	2334.22	2338.23	383.0
2010-04-30 03:00:00	NQ	Futures	2338.23	2341.96	2337.37	2341.67	1757.0
2010-04-30 04:00:00	NQ	Futures	2341.96	2344.82	2340.81	2343.39	1655.0
2010-04-30 05:00:00	NQ	Futures	2343.67	2344.25	2339.38	2342.24	2145.0
2010-04-30 06:00:00	NQ	Futures	2341.96	2343.1	2335.94	2338.23	1677.0
2010-04-30 07:00:00	NQ	Futures	2337.37	2343.39	2336.23	2343.1	1619.0
2010-04-30 08:00:00	NQ	Futures	2343.1	2344.25	2338.23	2338.52	4263.0
2010-04-30 09:00:00	NQ	Futures	2338.52	2339.95	2328.21	2328.5	33956.0
2010-04-30 10:00:00	NQ	Futures	2328.5	2329.35	2317.33	2325.35	66663.0
2010-04-30 11:00:00	NQ	Futures	2325.35	2327.64	2317.61	2320.76	32134.0
2010-04-30 12:00:00	NQ	Futures	2320.76	2321.62	2295.85	2297.85	47914.0
2010-04-30 13:00:00	NQ	Futures	2298.14	2307.88	2296.99	2301.58	32460.0
2010-04-30 14:00:00	NQ	Futures	2301.58	2304.44	2294.99	2297.28	30258.0
2010-04-30 15:00:00	NQ	Futures	2296.99	2303.01	2288.69	2291.27	64744.0
2010-04-30 16:00:00	NQ	Futures	2291.27	2296.14	2289.26	2295.56	15055.0
2010-04-30 00:00:00	YM	Futures	10475.0	10480.6	10466.5	10468.4	391.0
2010-04-30 01:00:00	YM	Futures	10467.5	10468.4	10456.2	10457.1	274.0
2010-04-30 02:00:00	YM	Futures	10456.2	10476.9	10454.3	10476.9	497.0
2010-04-30 03:00:00	YM	Futures	10476.9	10495.7	10472.2	10492.9	2310.0
2010-04-30 04:00:00	YM	Futures	10492.9	10499.5	10483.5	10493.8	1320.0
2010-04-30 05:00:00	YM	Futures	10494.7	10494.7	10472.2	10485.3	917.0
2010-04-30 06:00:00	YM	Futures	10487.2	10490.0	10468.4	10474.0	1364.0
2010-04-30 07:00:00	YM	Futures	10472.2	10494.7	10466.5	10493.8	1826.0
2010-04-30 08:00:00	YM	Futures	10494.7	10496.6	10473.1	10473.1	3066.0
2010-04-30 09:00:00	YM	Futures	10472.2	10490.0	10452.4	10452.4	15813.0
2010-04-30 10:00:00	YM	Futures	10452.4	10470.3	10401.6	10459.0	36361.0
2010-04-30 11:00:00	YM	Futures	10459.0	10463.7	10439.2	10450.5	12494.0
2010-04-30 12:00:00	YM	Futures	10451.5	10455.2	10356.4	10364.0	23252.0
2010-04-30 13:00:00	YM	Futures	10364.9	10402.5	10354.5	10385.6	13384.0
2010-04-30 14:00:00	YM	Futures	10384.7	10399.7	10350.8	10364.0	13762.0
2010-04-30 15:00:00	YM	Futures	10363.0	10378.1	10305.6	10313.1	28981.0

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

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