PREVIEW / futures_1hour / 2008-05-19

all futures 1-hour files

  file:    by_date/futures_1hour/2008/2008-05-19.parquet
  size:    40 KB
  rows:    1,169

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
2008-05-19 00:00:00	ES	Futures	1327.21	1327.91	1326.74	1326.74	623.0
2008-05-19 01:00:00	ES	Futures	1326.98	1327.21	1326.28	1327.21	1048.0
2008-05-19 02:00:00	ES	Futures	1326.98	1327.21	1326.28	1327.21	1459.0
2008-05-19 03:00:00	ES	Futures	1326.98	1327.21	1325.35	1326.98	5022.0
2008-05-19 04:00:00	ES	Futures	1327.21	1327.67	1325.58	1325.58	6214.0
2008-05-19 05:00:00	ES	Futures	1325.58	1327.91	1325.11	1327.67	4507.0
2008-05-19 06:00:00	ES	Futures	1327.67	1328.61	1327.44	1327.67	4904.0
2008-05-19 07:00:00	ES	Futures	1327.67	1328.14	1326.98	1327.91	6150.0
2008-05-19 08:00:00	ES	Futures	1327.91	1328.84	1327.44	1328.14	25840.0
2008-05-19 09:00:00	ES	Futures	1327.91	1331.4	1325.81	1330.93	172070.0
2008-05-19 10:00:00	ES	Futures	1330.93	1336.29	1330.24	1334.89	299441.0
2008-05-19 11:00:00	ES	Futures	1334.66	1340.71	1333.96	1339.08	265364.0
2008-05-19 12:00:00	ES	Futures	1339.32	1341.18	1338.39	1339.08	147441.0
2008-05-19 13:00:00	ES	Futures	1339.08	1342.11	1336.76	1336.99	177236.0
2008-05-19 14:00:00	ES	Futures	1336.99	1337.22	1329.07	1332.8	315419.0
2008-05-19 15:00:00	ES	Futures	1332.56	1333.73	1324.18	1329.07	276722.0
2008-05-19 16:00:00	ES	Futures	1329.07	1332.1	1328.61	1330.47	66321.0
2008-05-19 17:00:00	ES	Futures	1330.47	1331.17	1330.47	1330.93	750.0
2008-05-19 18:00:00	ES	Futures	1330.93	1330.93	1330.24	1330.24	1030.0
2008-05-19 19:00:00	ES	Futures	1330.47	1330.7	1330.24	1330.47	472.0
2008-05-19 20:00:00	ES	Futures	1330.47	1331.17	1330.24	1330.47	1589.0
2008-05-19 21:00:00	ES	Futures	1330.7	1330.7	1329.77	1330.0	2100.0
2008-05-19 22:00:00	ES	Futures	1329.77	1330.47	1329.77	1329.77	2702.0
2008-05-19 23:00:00	ES	Futures	1330.0	1330.0	1328.84	1329.07	1712.0
2008-05-19 00:00:00	NQ	Futures	2300.81	2302.79	2300.81	2301.94	85.0
2008-05-19 01:00:00	NQ	Futures	2300.53	2302.79	2300.53	2301.94	143.0
2008-05-19 02:00:00	NQ	Futures	2301.94	2302.22	2299.4	2301.94	185.0
2008-05-19 03:00:00	NQ	Futures	2300.81	2301.94	2299.11	2301.94	514.0
2008-05-19 04:00:00	NQ	Futures	2301.94	2303.07	2299.4	2299.68	512.0
2008-05-19 05:00:00	NQ	Futures	2299.68	2302.79	2299.11	2302.51	414.0
2008-05-19 06:00:00	NQ	Futures	2302.79	2303.64	2301.94	2303.36	338.0
2008-05-19 07:00:00	NQ	Futures	2303.07	2303.92	2301.94	2303.36	489.0
2008-05-19 08:00:00	NQ	Futures	2303.36	2306.18	2303.07	2305.9	1825.0
2008-05-19 09:00:00	NQ	Futures	2305.62	2311.28	2297.42	2310.71	34331.0
2008-05-19 10:00:00	NQ	Futures	2310.99	2319.19	2307.88	2311.28	53067.0
2008-05-19 11:00:00	NQ	Futures	2310.99	2322.59	2308.45	2317.5	45050.0
2008-05-19 12:00:00	NQ	Futures	2317.5	2320.61	2315.52	2316.65	26495.0
2008-05-19 13:00:00	NQ	Futures	2316.93	2324.0	2306.18	2307.03	36797.0
2008-05-19 14:00:00	NQ	Futures	2307.03	2307.6	2283.84	2297.42	80882.0
2008-05-19 15:00:00	NQ	Futures	2297.42	2297.7	2271.96	2284.97	74361.0
2008-05-19 16:00:00	NQ	Futures	2285.26	2292.61	2284.69	2290.35	8082.0
2008-05-19 17:00:00	NQ	Futures	2289.78	2291.48	2289.78	2291.48	35.0
2008-05-19 18:00:00	NQ	Futures	2290.63	2292.04	2289.5	2290.06	180.0
2008-05-19 19:00:00	NQ	Futures	2290.06	2290.91	2289.21	2289.78	150.0
2008-05-19 20:00:00	NQ	Futures	2289.5	2290.91	2289.21	2290.91	146.0
2008-05-19 21:00:00	NQ	Futures	2290.06	2290.06	2288.65	2288.93	47.0
2008-05-19 22:00:00	NQ	Futures	2288.93	2289.5	2287.8	2288.08	160.0
2008-05-19 23:00:00	NQ	Futures	2288.08	2288.08	2286.39	2287.8	427.0
2008-05-19 00:00:00	YM	Futures	11789.8	11795.2	11789.8	11789.8	61.0
2008-05-19 01:00:00	YM	Futures	11789.8	11791.6	11786.1	11788.8	59.0

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

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