PREVIEW / futures_1hour / 2012-01-26

all futures 1-hour files

  file:    by_date/futures_1hour/2012/2012-01-26.parquet
  size:    50 KB
  rows:    1,498

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-26 00:00:00	ES	Futures	1330.24	1330.24	1328.98	1328.98	2703.0
2012-01-26 01:00:00	ES	Futures	1328.98	1330.5	1328.98	1329.74	3109.0
2012-01-26 02:00:00	ES	Futures	1329.74	1330.75	1329.24	1329.24	6400.0
2012-01-26 03:00:00	ES	Futures	1329.24	1330.5	1326.21	1327.47	33874.0
2012-01-26 04:00:00	ES	Futures	1327.47	1333.52	1327.22	1333.27	31566.0
2012-01-26 05:00:00	ES	Futures	1333.02	1335.54	1333.02	1333.52	33127.0
2012-01-26 06:00:00	ES	Futures	1333.52	1335.03	1332.51	1334.78	21479.0
2012-01-26 07:00:00	ES	Futures	1334.78	1336.29	1333.77	1335.03	25946.0
2012-01-26 08:00:00	ES	Futures	1335.28	1338.06	1334.53	1338.06	60904.0
2012-01-26 09:00:00	ES	Futures	1337.8	1340.32	1335.03	1339.32	214654.0
2012-01-26 10:00:00	ES	Futures	1339.32	1339.57	1328.73	1328.98	389460.0
2012-01-26 11:00:00	ES	Futures	1328.98	1331.76	1328.48	1329.49	258085.0
2012-01-26 12:00:00	ES	Futures	1329.49	1330.24	1326.72	1329.74	176505.0
2012-01-26 13:00:00	ES	Futures	1329.74	1330.75	1324.7	1326.21	141535.0
2012-01-26 14:00:00	ES	Futures	1326.21	1326.97	1322.69	1323.44	169305.0
2012-01-26 15:00:00	ES	Futures	1323.44	1325.46	1319.66	1324.95	333738.0
2012-01-26 16:00:00	ES	Futures	1324.95	1327.22	1324.45	1326.72	66400.0
2012-01-26 17:00:00	ES	Futures	1326.72	1326.97	1326.21	1326.72	1341.0
2012-01-26 18:00:00	ES	Futures	1326.46	1327.22	1324.95	1325.2	5499.0
2012-01-26 19:00:00	ES	Futures	1325.2	1325.46	1322.94	1323.94	8482.0
2012-01-26 20:00:00	ES	Futures	1323.94	1324.7	1323.69	1324.2	3202.0
2012-01-26 21:00:00	ES	Futures	1324.45	1325.2	1323.94	1324.7	4758.0
2012-01-26 22:00:00	ES	Futures	1324.7	1325.46	1323.44	1323.69	3224.0
2012-01-26 23:00:00	ES	Futures	1323.94	1324.45	1321.17	1321.93	8578.0
2012-01-26 00:00:00	NQ	Futures	2840.04	2841.2	2838.6	2838.89	102.0
2012-01-26 01:00:00	NQ	Futures	2839.18	2840.33	2838.02	2839.18	151.0
2012-01-26 02:00:00	NQ	Futures	2839.47	2841.2	2837.44	2838.89	424.0
2012-01-26 03:00:00	NQ	Futures	2838.89	2840.04	2831.67	2833.98	2412.0
2012-01-26 04:00:00	NQ	Futures	2833.11	2846.69	2832.82	2844.37	2751.0
2012-01-26 05:00:00	NQ	Futures	2844.66	2850.15	2844.66	2845.53	2532.0
2012-01-26 06:00:00	NQ	Futures	2845.53	2847.55	2841.78	2846.97	1686.0
2012-01-26 07:00:00	NQ	Futures	2846.69	2848.71	2844.66	2847.55	1546.0
2012-01-26 08:00:00	NQ	Futures	2847.55	2855.06	2845.82	2854.77	7883.0
2012-01-26 09:00:00	NQ	Futures	2854.48	2860.26	2846.4	2858.24	27148.0
2012-01-26 10:00:00	NQ	Futures	2858.24	2859.68	2836.0	2836.29	35646.0
2012-01-26 11:00:00	NQ	Futures	2836.29	2844.66	2835.13	2838.02	20083.0
2012-01-26 12:00:00	NQ	Futures	2838.31	2840.04	2832.82	2839.18	13925.0
2012-01-26 13:00:00	NQ	Futures	2839.18	2841.49	2830.51	2835.13	12806.0
2012-01-26 14:00:00	NQ	Futures	2834.84	2836.0	2826.76	2827.34	16949.0
2012-01-26 15:00:00	NQ	Futures	2827.05	2833.11	2819.54	2832.82	32726.0
2012-01-26 16:00:00	NQ	Futures	2832.53	2836.0	2832.53	2833.11	6575.0
2012-01-26 17:00:00	NQ	Futures	2833.11	2834.27	2833.11	2834.27	106.0
2012-01-26 18:00:00	NQ	Futures	2833.69	2834.56	2831.09	2831.38	247.0
2012-01-26 19:00:00	NQ	Futures	2831.38	2831.67	2828.49	2829.65	393.0
2012-01-26 20:00:00	NQ	Futures	2829.65	2831.67	2829.36	2831.09	134.0
2012-01-26 21:00:00	NQ	Futures	2831.09	2834.84	2830.22	2833.4	357.0
2012-01-26 22:00:00	NQ	Futures	2833.98	2834.84	2831.38	2831.96	144.0
2012-01-26 23:00:00	NQ	Futures	2831.67	2832.53	2827.34	2828.2	372.0
2012-01-26 00:00:00	YM	Futures	12572.6	12574.5	12564.6	12568.6	140.0
2012-01-26 01:00:00	YM	Futures	12567.6	12577.5	12566.6	12575.5	105.0

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

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