PREVIEW / futures_1hour / 2011-03-04

all futures 1-hour files

  file:    by_date/futures_1hour/2011/2011-03-04.parquet
  size:    40 KB
  rows:    1,161

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-03-04 00:00:00	ES	Futures	1317.05	1318.79	1316.56	1318.04	3264.0
2011-03-04 01:00:00	ES	Futures	1318.04	1318.29	1316.31	1317.05	3251.0
2011-03-04 02:00:00	ES	Futures	1317.05	1317.05	1315.57	1316.06	10567.0
2011-03-04 03:00:00	ES	Futures	1316.31	1316.81	1314.58	1315.82	23021.0
2011-03-04 04:00:00	ES	Futures	1315.82	1318.79	1315.82	1317.8	19170.0
2011-03-04 05:00:00	ES	Futures	1317.8	1319.53	1317.3	1318.54	17832.0
2011-03-04 06:00:00	ES	Futures	1318.29	1319.03	1315.57	1316.31	24906.0
2011-03-04 07:00:00	ES	Futures	1316.06	1319.03	1316.06	1317.55	21128.0
2011-03-04 08:00:00	ES	Futures	1317.55	1320.77	1313.1	1314.58	175524.0
2011-03-04 09:00:00	ES	Futures	1314.58	1317.55	1312.6	1314.33	322105.0
2011-03-04 10:00:00	ES	Futures	1314.58	1315.32	1305.67	1309.88	539644.0
2011-03-04 11:00:00	ES	Futures	1309.88	1310.62	1304.68	1305.18	350096.0
2011-03-04 12:00:00	ES	Futures	1305.43	1305.67	1298.0	1300.23	431919.0
2011-03-04 13:00:00	ES	Futures	1300.23	1302.7	1298.0	1299.73	184707.0
2011-03-04 14:00:00	ES	Futures	1299.98	1302.46	1297.76	1302.46	147655.0
2011-03-04 15:00:00	ES	Futures	1302.46	1307.65	1298.0	1306.66	478093.0
2011-03-04 16:00:00	ES	Futures	1306.41	1308.39	1306.17	1306.41	135574.0
2011-03-04 00:00:00	NQ	Futures	2725.09	2725.95	2721.93	2725.09	490.0
2011-03-04 01:00:00	NQ	Futures	2725.37	2726.52	2723.36	2724.22	357.0
2011-03-04 02:00:00	NQ	Futures	2724.51	2725.66	2723.08	2723.65	510.0
2011-03-04 03:00:00	NQ	Futures	2723.65	2725.09	2720.49	2723.36	2076.0
2011-03-04 04:00:00	NQ	Futures	2723.08	2729.1	2723.08	2726.52	1505.0
2011-03-04 05:00:00	NQ	Futures	2726.81	2730.83	2726.52	2727.38	1076.0
2011-03-04 06:00:00	NQ	Futures	2728.53	2728.53	2721.07	2722.5	1586.0
2011-03-04 07:00:00	NQ	Futures	2722.5	2727.38	2721.07	2725.66	1308.0
2011-03-04 08:00:00	NQ	Futures	2725.95	2730.83	2717.05	2720.21	15680.0
2011-03-04 09:00:00	NQ	Futures	2720.49	2724.51	2711.6	2718.2	44215.0
2011-03-04 10:00:00	NQ	Futures	2718.2	2720.78	2703.85	2716.48	42855.0
2011-03-04 11:00:00	NQ	Futures	2716.48	2717.34	2706.72	2708.15	29862.0
2011-03-04 12:00:00	NQ	Futures	2707.86	2708.73	2691.5	2696.67	49005.0
2011-03-04 13:00:00	NQ	Futures	2696.67	2702.7	2694.37	2698.97	24737.0
2011-03-04 14:00:00	NQ	Futures	2698.97	2702.12	2694.09	2702.12	18814.0
2011-03-04 15:00:00	NQ	Futures	2702.12	2710.16	2694.09	2708.73	52607.0
2011-03-04 16:00:00	NQ	Futures	2708.73	2711.88	2708.44	2711.31	8406.0
2011-03-04 00:00:00	YM	Futures	11738.6	11747.2	11736.7	11739.5	282.0
2011-03-04 01:00:00	YM	Futures	11741.5	11741.5	11729.0	11730.9	201.0
2011-03-04 02:00:00	YM	Futures	11730.9	11735.7	11725.2	11730.9	1156.0
2011-03-04 03:00:00	YM	Futures	11730.9	11732.8	11716.6	11730.0	1984.0
2011-03-04 04:00:00	YM	Futures	11729.0	11750.1	11728.0	11744.3	1166.0
2011-03-04 05:00:00	YM	Futures	11744.3	11757.7	11742.4	11750.1	1282.0
2011-03-04 06:00:00	YM	Futures	11749.1	11753.9	11731.9	11733.8	692.0
2011-03-04 07:00:00	YM	Futures	11734.7	11752.9	11732.8	11746.2	1051.0
2011-03-04 08:00:00	YM	Futures	11745.3	11769.2	11712.7	11724.2	8469.0
2011-03-04 09:00:00	YM	Futures	11723.3	11747.2	11711.8	11722.3	16615.0
2011-03-04 10:00:00	YM	Futures	11722.3	11727.1	11653.3	11682.1	24769.0
2011-03-04 11:00:00	YM	Futures	11683.0	11687.8	11634.2	11639.9	15954.0
2011-03-04 12:00:00	YM	Futures	11639.0	11639.9	11556.6	11576.7	27015.0
2011-03-04 13:00:00	YM	Futures	11576.7	11600.7	11561.4	11574.8	11371.0
2011-03-04 14:00:00	YM	Futures	11575.8	11595.9	11561.4	11594.9	7952.0
2011-03-04 15:00:00	YM	Futures	11595.9	11646.6	11560.4	11640.9	26128.0

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

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