PREVIEW / futures_1hour / 2011-11-30

all futures 1-hour files

  file:    by_date/futures_1hour/2011/2011-11-30.parquet
  size:    50 KB
  rows:    1,485

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-11-30 00:00:00	ES	Futures	1192.35	1195.36	1191.85	1192.1	10131.0
2011-11-30 01:00:00	ES	Futures	1191.85	1192.86	1189.09	1189.35	9552.0
2011-11-30 02:00:00	ES	Futures	1189.6	1191.35	1186.59	1190.1	19967.0
2011-11-30 03:00:00	ES	Futures	1190.1	1194.86	1189.09	1193.36	32735.0
2011-11-30 04:00:00	ES	Futures	1193.61	1195.87	1191.85	1193.61	22834.0
2011-11-30 05:00:00	ES	Futures	1193.86	1197.62	1192.86	1195.36	24930.0
2011-11-30 06:00:00	ES	Futures	1195.36	1211.91	1194.61	1209.16	111421.0
2011-11-30 07:00:00	ES	Futures	1209.41	1210.16	1205.9	1209.16	56966.0
2011-11-30 08:00:00	ES	Futures	1209.16	1238.24	1208.9	1235.99	414969.0
2011-11-30 09:00:00	ES	Futures	1235.99	1239.25	1230.22	1238.24	450546.0
2011-11-30 10:00:00	ES	Futures	1238.49	1243.51	1235.48	1243.26	488552.0
2011-11-30 11:00:00	ES	Futures	1243.01	1243.26	1238.24	1239.5	323460.0
2011-11-30 12:00:00	ES	Futures	1239.75	1240.75	1237.99	1239.5	147490.0
2011-11-30 13:00:00	ES	Futures	1239.5	1241.0	1236.24	1236.99	134776.0
2011-11-30 14:00:00	ES	Futures	1236.74	1240.0	1236.24	1239.0	153043.0
2011-11-30 15:00:00	ES	Futures	1238.74	1250.53	1237.99	1249.28	573670.0
2011-11-30 16:00:00	ES	Futures	1249.03	1249.78	1246.52	1248.02	218923.0
2011-11-30 17:00:00	ES	Futures	1248.02	1249.28	1247.77	1249.03	3644.0
2011-11-30 18:00:00	ES	Futures	1248.52	1248.78	1246.52	1247.02	9817.0
2011-11-30 19:00:00	ES	Futures	1247.02	1247.52	1245.26	1246.52	11987.0
2011-11-30 20:00:00	ES	Futures	1246.52	1249.53	1245.26	1246.02	15055.0
2011-11-30 21:00:00	ES	Futures	1246.02	1247.02	1245.01	1246.02	6023.0
2011-11-30 22:00:00	ES	Futures	1246.02	1248.02	1245.52	1247.77	6167.0
2011-11-30 23:00:00	ES	Futures	1247.77	1253.29	1247.77	1251.28	11620.0
2011-11-30 00:00:00	NQ	Futures	2540.41	2545.89	2540.12	2540.7	597.0
2011-11-30 01:00:00	NQ	Futures	2540.7	2542.43	2537.24	2537.53	414.0
2011-11-30 02:00:00	NQ	Futures	2537.81	2539.83	2532.91	2537.24	1514.0
2011-11-30 03:00:00	NQ	Futures	2537.24	2547.33	2534.93	2544.45	2369.0
2011-11-30 04:00:00	NQ	Futures	2544.16	2550.79	2542.14	2545.02	1768.0
2011-11-30 05:00:00	NQ	Futures	2545.02	2553.38	2544.16	2548.77	1852.0
2011-11-30 06:00:00	NQ	Futures	2548.48	2580.2	2547.91	2572.41	7272.0
2011-11-30 07:00:00	NQ	Futures	2572.99	2575.01	2565.78	2568.09	3975.0
2011-11-30 08:00:00	NQ	Futures	2567.8	2623.16	2567.22	2622.29	32659.0
2011-11-30 09:00:00	NQ	Futures	2622.58	2626.33	2611.05	2622.87	53444.0
2011-11-30 10:00:00	NQ	Futures	2623.45	2642.19	2620.56	2641.32	53282.0
2011-11-30 11:00:00	NQ	Futures	2641.32	2641.61	2632.67	2635.27	30655.0
2011-11-30 12:00:00	NQ	Futures	2635.27	2637.57	2632.67	2634.69	15640.0
2011-11-30 13:00:00	NQ	Futures	2634.69	2637.0	2623.45	2624.31	17474.0
2011-11-30 14:00:00	NQ	Futures	2624.31	2631.81	2622.29	2627.19	16953.0
2011-11-30 15:00:00	NQ	Futures	2626.91	2647.67	2624.31	2644.78	37805.0
2011-11-30 16:00:00	NQ	Futures	2645.07	2648.53	2642.19	2647.67	14553.0
2011-11-30 17:00:00	NQ	Futures	2647.09	2649.68	2646.51	2647.95	265.0
2011-11-30 18:00:00	NQ	Futures	2646.8	2647.09	2644.78	2646.22	515.0
2011-11-30 19:00:00	NQ	Futures	2646.22	2646.8	2643.34	2645.07	606.0
2011-11-30 20:00:00	NQ	Futures	2645.07	2649.68	2643.92	2644.49	844.0
2011-11-30 21:00:00	NQ	Futures	2644.78	2647.67	2643.34	2645.65	670.0
2011-11-30 22:00:00	NQ	Futures	2645.65	2648.82	2644.78	2648.53	343.0
2011-11-30 23:00:00	NQ	Futures	2648.53	2659.2	2648.24	2656.6	1049.0
2011-11-30 00:00:00	YM	Futures	11325.4	11349.0	11321.5	11321.5	630.0
2011-11-30 01:00:00	YM	Futures	11320.5	11326.4	11296.8	11298.8	727.0

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

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