PREVIEW / futures_1hour / 2011-05-18

all futures 1-hour files

  file:    by_date/futures_1hour/2011/2011-05-18.parquet
  size:    48 KB
  rows:    1,458

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
2011-05-18 00:00:00	ES	Futures	1322.89	1323.14	1322.4	1322.64	1487.0
2011-05-18 01:00:00	ES	Futures	1322.64	1323.64	1322.64	1323.39	5276.0
2011-05-18 02:00:00	ES	Futures	1323.14	1323.39	1321.65	1322.15	8494.0
2011-05-18 03:00:00	ES	Futures	1322.15	1323.39	1320.91	1321.65	29381.0
2011-05-18 04:00:00	ES	Futures	1321.4	1323.14	1320.66	1321.9	16279.0
2011-05-18 05:00:00	ES	Futures	1321.9	1322.4	1319.66	1320.16	17330.0
2011-05-18 06:00:00	ES	Futures	1320.16	1322.4	1319.91	1320.41	22955.0
2011-05-18 07:00:00	ES	Futures	1320.41	1320.91	1317.68	1319.17	26019.0
2011-05-18 08:00:00	ES	Futures	1318.92	1319.41	1316.43	1319.17	46744.0
2011-05-18 09:00:00	ES	Futures	1319.17	1321.65	1316.18	1319.41	210637.0
2011-05-18 10:00:00	ES	Futures	1319.17	1325.63	1318.92	1324.38	241284.0
2011-05-18 11:00:00	ES	Futures	1324.38	1325.87	1323.14	1324.63	147993.0
2011-05-18 12:00:00	ES	Futures	1324.63	1326.37	1323.39	1325.63	102409.0
2011-05-18 13:00:00	ES	Futures	1325.38	1330.59	1325.38	1329.85	149992.0
2011-05-18 14:00:00	ES	Futures	1329.85	1331.84	1326.37	1327.12	210182.0
2011-05-18 15:00:00	ES	Futures	1326.87	1331.84	1326.62	1330.35	214182.0
2011-05-18 16:00:00	ES	Futures	1330.59	1332.08	1329.6	1331.09	111323.0
2011-05-18 17:00:00	ES	Futures	1331.09	1331.84	1330.84	1331.59	2565.0
2011-05-18 18:00:00	ES	Futures	1331.34	1332.08	1330.84	1331.09	2534.0
2011-05-18 19:00:00	ES	Futures	1330.84	1332.08	1330.59	1331.09	2957.0
2011-05-18 20:00:00	ES	Futures	1331.09	1331.34	1329.85	1330.1	9282.0
2011-05-18 21:00:00	ES	Futures	1330.35	1330.35	1329.35	1329.6	7292.0
2011-05-18 22:00:00	ES	Futures	1329.85	1332.08	1329.35	1331.34	7156.0
2011-05-18 23:00:00	ES	Futures	1331.34	1331.59	1329.85	1330.35	4950.0
2011-05-18 00:00:00	NQ	Futures	2698.75	2698.75	2697.89	2698.17	215.0
2011-05-18 01:00:00	NQ	Futures	2698.17	2699.04	2698.17	2698.75	526.0
2011-05-18 02:00:00	NQ	Futures	2698.75	2699.04	2695.87	2696.74	1018.0
2011-05-18 03:00:00	NQ	Futures	2697.02	2698.75	2694.15	2695.59	3163.0
2011-05-18 04:00:00	NQ	Futures	2695.01	2697.6	2693.29	2695.59	2327.0
2011-05-18 05:00:00	NQ	Futures	2695.87	2696.16	2690.42	2691.85	2149.0
2011-05-18 06:00:00	NQ	Futures	2691.85	2695.3	2689.27	2690.42	3310.0
2011-05-18 07:00:00	NQ	Futures	2690.42	2691.28	2684.96	2687.26	3795.0
2011-05-18 08:00:00	NQ	Futures	2687.26	2688.12	2681.8	2687.26	7328.0
2011-05-18 09:00:00	NQ	Futures	2687.26	2694.15	2683.81	2688.12	44062.0
2011-05-18 10:00:00	NQ	Futures	2688.12	2698.46	2687.26	2695.59	35816.0
2011-05-18 11:00:00	NQ	Futures	2695.59	2700.18	2695.59	2697.31	18341.0
2011-05-18 12:00:00	NQ	Futures	2697.6	2703.63	2694.73	2700.76	15059.0
2011-05-18 13:00:00	NQ	Futures	2700.76	2712.83	2700.47	2711.68	22066.0
2011-05-18 14:00:00	NQ	Futures	2711.68	2718.0	2709.67	2711.68	33122.0
2011-05-18 15:00:00	NQ	Futures	2711.68	2716.56	2710.53	2712.83	25359.0
2011-05-18 16:00:00	NQ	Futures	2712.54	2717.71	2711.96	2717.42	10127.0
2011-05-18 17:00:00	NQ	Futures	2717.42	2719.15	2717.14	2718.86	837.0
2011-05-18 18:00:00	NQ	Futures	2717.71	2719.72	2717.71	2718.29	438.0
2011-05-18 19:00:00	NQ	Futures	2718.29	2719.15	2717.42	2718.0	371.0
2011-05-18 20:00:00	NQ	Futures	2718.0	2718.0	2713.98	2714.84	831.0
2011-05-18 21:00:00	NQ	Futures	2714.55	2715.7	2713.98	2714.55	441.0
2011-05-18 22:00:00	NQ	Futures	2714.84	2719.72	2714.55	2718.29	651.0
2011-05-18 23:00:00	NQ	Futures	2718.57	2718.57	2715.12	2715.99	237.0
2011-05-18 00:00:00	YM	Futures	12029.3	12030.2	12025.4	12027.3	66.0
2011-05-18 01:00:00	YM	Futures	12027.3	12034.1	12027.3	12032.1	155.0

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

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