PREVIEW / futures_1hour / 2012-01-19

all futures 1-hour files

  file:    by_date/futures_1hour/2012/2012-01-19.parquet
  size:    48 KB
  rows:    1,501

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-19 00:00:00	ES	Futures	1312.86	1313.11	1312.1	1312.61	3418.0
2012-01-19 01:00:00	ES	Futures	1312.86	1313.36	1312.1	1312.35	2969.0
2012-01-19 02:00:00	ES	Futures	1312.1	1313.11	1310.34	1311.09	11310.0
2012-01-19 03:00:00	ES	Futures	1311.35	1312.35	1309.58	1312.35	24349.0
2012-01-19 04:00:00	ES	Futures	1312.1	1313.11	1310.59	1310.84	22645.0
2012-01-19 05:00:00	ES	Futures	1310.84	1313.87	1309.83	1313.36	19512.0
2012-01-19 06:00:00	ES	Futures	1313.36	1314.62	1312.86	1313.87	19547.0
2012-01-19 07:00:00	ES	Futures	1313.87	1319.16	1313.36	1317.39	59257.0
2012-01-19 08:00:00	ES	Futures	1317.39	1319.66	1316.39	1317.39	76374.0
2012-01-19 09:00:00	ES	Futures	1317.39	1318.65	1315.63	1318.4	159908.0
2012-01-19 10:00:00	ES	Futures	1318.4	1320.17	1313.87	1318.4	301842.0
2012-01-19 11:00:00	ES	Futures	1318.4	1321.43	1317.65	1321.43	280364.0
2012-01-19 12:00:00	ES	Futures	1321.43	1321.43	1318.65	1319.66	163217.0
2012-01-19 13:00:00	ES	Futures	1319.41	1321.93	1319.41	1319.66	140163.0
2012-01-19 14:00:00	ES	Futures	1319.91	1321.43	1317.9	1318.4	159109.0
2012-01-19 15:00:00	ES	Futures	1318.15	1320.92	1317.9	1320.92	230669.0
2012-01-19 16:00:00	ES	Futures	1320.92	1321.43	1316.39	1320.67	122104.0
2012-01-19 17:00:00	ES	Futures	1320.67	1320.92	1319.66	1320.17	3587.0
2012-01-19 18:00:00	ES	Futures	1320.17	1320.67	1319.41	1320.17	4355.0
2012-01-19 19:00:00	ES	Futures	1319.91	1320.17	1319.16	1319.66	4123.0
2012-01-19 20:00:00	ES	Futures	1319.91	1320.42	1319.16	1319.66	4891.0
2012-01-19 21:00:00	ES	Futures	1319.66	1319.91	1318.4	1318.91	4016.0
2012-01-19 22:00:00	ES	Futures	1318.91	1319.41	1317.9	1318.15	3455.0
2012-01-19 23:00:00	ES	Futures	1318.15	1319.41	1317.9	1318.65	2656.0
2012-01-19 00:00:00	NQ	Futures	2798.74	2799.61	2797.3	2798.74	235.0
2012-01-19 01:00:00	NQ	Futures	2799.03	2800.19	2798.46	2798.46	205.0
2012-01-19 02:00:00	NQ	Futures	2798.46	2799.9	2795.28	2796.72	751.0
2012-01-19 03:00:00	NQ	Futures	2796.72	2798.46	2793.84	2798.17	1496.0
2012-01-19 04:00:00	NQ	Futures	2797.88	2800.48	2795.86	2796.72	1953.0
2012-01-19 05:00:00	NQ	Futures	2796.43	2803.08	2794.12	2802.5	1399.0
2012-01-19 06:00:00	NQ	Futures	2802.5	2803.94	2801.34	2803.37	1696.0
2012-01-19 07:00:00	NQ	Futures	2803.08	2809.72	2801.63	2807.41	2853.0
2012-01-19 08:00:00	NQ	Futures	2807.12	2813.18	2806.54	2808.28	6660.0
2012-01-19 09:00:00	NQ	Futures	2807.99	2815.5	2807.12	2814.63	32713.0
2012-01-19 10:00:00	NQ	Futures	2814.92	2818.67	2806.54	2815.21	28736.0
2012-01-19 11:00:00	NQ	Futures	2815.21	2821.56	2814.63	2820.4	17843.0
2012-01-19 12:00:00	NQ	Futures	2820.12	2820.69	2816.07	2817.23	12037.0
2012-01-19 13:00:00	NQ	Futures	2816.94	2820.69	2815.5	2815.78	8897.0
2012-01-19 14:00:00	NQ	Futures	2815.78	2820.12	2810.59	2811.45	16301.0
2012-01-19 15:00:00	NQ	Futures	2811.45	2818.67	2810.87	2816.07	26136.0
2012-01-19 16:00:00	NQ	Futures	2815.78	2816.36	2795.57	2808.28	22704.0
2012-01-19 17:00:00	NQ	Futures	2808.28	2808.28	2804.81	2805.68	574.0
2012-01-19 18:00:00	NQ	Futures	2805.96	2807.41	2803.37	2805.39	548.0
2012-01-19 19:00:00	NQ	Futures	2805.39	2805.39	2803.94	2805.1	279.0
2012-01-19 20:00:00	NQ	Futures	2804.52	2805.68	2803.94	2804.23	189.0
2012-01-19 21:00:00	NQ	Futures	2804.52	2805.1	2801.34	2803.37	459.0
2012-01-19 22:00:00	NQ	Futures	2803.65	2804.52	2801.92	2802.5	187.0
2012-01-19 23:00:00	NQ	Futures	2802.5	2804.81	2802.21	2803.65	183.0
2012-01-19 00:00:00	YM	Futures	12400.1	12401.1	12396.1	12400.1	293.0
2012-01-19 01:00:00	YM	Futures	12400.1	12404.1	12397.1	12397.1	252.0

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

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