PREVIEW / futures_1hour / 2012-01-29

all futures 1-hour files

  file:    by_date/futures_1hour/2012/2012-01-29.parquet
  size:    14 KB
  rows:    266

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
2012-01-29 18:00:00	ES	Futures	1324.45	1324.95	1321.43	1322.18	7983.0
2012-01-29 19:00:00	ES	Futures	1321.93	1322.18	1315.38	1318.4	15469.0
2012-01-29 20:00:00	ES	Futures	1318.65	1318.65	1313.87	1315.63	14450.0
2012-01-29 21:00:00	ES	Futures	1315.63	1316.39	1314.62	1316.13	5782.0
2012-01-29 22:00:00	ES	Futures	1316.13	1317.9	1315.88	1316.89	3444.0
2012-01-29 23:00:00	ES	Futures	1316.64	1316.89	1314.62	1315.63	2878.0
2012-01-29 18:00:00	NQ	Futures	2841.78	2842.35	2836.0	2836.87	692.0
2012-01-29 19:00:00	NQ	Futures	2836.58	2837.15	2825.03	2828.2	1106.0
2012-01-29 20:00:00	NQ	Futures	2828.49	2828.49	2816.07	2821.27	1334.0
2012-01-29 21:00:00	NQ	Futures	2821.27	2823.58	2819.83	2823.29	391.0
2012-01-29 22:00:00	NQ	Futures	2823.0	2825.6	2822.43	2824.45	250.0
2012-01-29 23:00:00	NQ	Futures	2823.58	2824.45	2820.4	2821.85	163.0
2012-01-29 18:00:00	YM	Futures	12513.1	12527.0	12492.3	12493.3	675.0
2012-01-29 19:00:00	YM	Futures	12495.2	12497.2	12443.7	12469.5	831.0
2012-01-29 20:00:00	YM	Futures	12467.5	12467.5	12430.8	12444.7	644.0
2012-01-29 21:00:00	YM	Futures	12444.7	12449.7	12436.8	12447.7	416.0
2012-01-29 22:00:00	YM	Futures	12447.7	12460.6	12446.7	12452.6	330.0
2012-01-29 23:00:00	YM	Futures	12454.6	12454.6	12436.8	12443.7	253.0
2012-01-29 00:00:00	CL	Futures	166.91	166.91	166.91	166.91	1.0
2012-01-29 18:00:00	CL	Futures	168.61	168.7	167.53	167.8	1248.0
2012-01-29 19:00:00	CL	Futures	167.79	167.9	167.6	167.68	729.0
2012-01-29 20:00:00	CL	Futures	167.7	167.7	167.04	167.25	1845.0
2012-01-29 21:00:00	CL	Futures	167.23	167.4	166.79	166.99	1781.0
2012-01-29 22:00:00	CL	Futures	167.01	167.23	166.96	167.11	642.0
2012-01-29 23:00:00	CL	Futures	167.09	167.18	166.81	166.91	771.0
2012-01-29 18:00:00	GC	Futures	2414.5	2418.9	2412.4	2415.7	1101.0
2012-01-29 19:00:00	GC	Futures	2416.0	2416.4	2410.2	2410.9	1376.0
2012-01-29 20:00:00	GC	Futures	2410.9	2411.7	2407.4	2410.7	2591.0
2012-01-29 21:00:00	GC	Futures	2410.9	2411.6	2407.3	2409.9	1738.0
2012-01-29 22:00:00	GC	Futures	2409.9	2413.9	2409.6	2411.7	1237.0
2012-01-29 23:00:00	GC	Futures	2411.7	2411.8	2406.6	2409.1	1309.0
2012-01-29 18:00:00	ZN	Futures	114.983503	115.065342	114.969863	115.051702	5854.0
2012-01-29 19:00:00	ZN	Futures	115.038062	115.078981	114.997143	115.010782	14875.0
2012-01-29 20:00:00	ZN	Futures	115.010782	115.078981	115.010782	115.051702	8898.0
2012-01-29 21:00:00	ZN	Futures	115.051702	115.133541	115.038062	115.078981	9194.0
2012-01-29 22:00:00	ZN	Futures	115.092621	115.106261	115.065342	115.092621	4519.0
2012-01-29 23:00:00	ZN	Futures	115.092621	115.119901	115.092621	115.092621	1079.0

> showing 37 of 266 rows — these rows as CSV

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