PREVIEW / futures_1hour / 2012-03-30

all futures 1-hour files

  file:    by_date/futures_1hour/2012/2012-03-30.parquet
  size:    41 KB
  rows:    1,202

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-03-30 00:00:00	ES	Futures	1418.23	1418.48	1417.47	1418.23	2478.0
2012-03-30 01:00:00	ES	Futures	1418.23	1418.74	1417.22	1417.72	3852.0
2012-03-30 02:00:00	ES	Futures	1417.47	1420.0	1417.22	1418.99	9892.0
2012-03-30 03:00:00	ES	Futures	1418.99	1421.01	1418.23	1420.0	31347.0
2012-03-30 04:00:00	ES	Futures	1419.75	1420.51	1417.22	1420.0	21599.0
2012-03-30 05:00:00	ES	Futures	1420.0	1422.78	1418.74	1422.53	25730.0
2012-03-30 06:00:00	ES	Futures	1422.78	1422.78	1420.76	1421.52	19187.0
2012-03-30 07:00:00	ES	Futures	1421.52	1422.78	1421.01	1422.03	21737.0
2012-03-30 08:00:00	ES	Futures	1422.28	1423.04	1419.75	1420.76	45930.0
2012-03-30 09:00:00	ES	Futures	1420.51	1422.03	1417.98	1417.98	201728.0
2012-03-30 10:00:00	ES	Futures	1417.98	1419.5	1412.41	1415.19	270493.0
2012-03-30 11:00:00	ES	Futures	1415.19	1420.76	1414.94	1419.75	221881.0
2012-03-30 12:00:00	ES	Futures	1419.75	1421.52	1418.74	1420.0	135550.0
2012-03-30 13:00:00	ES	Futures	1419.75	1421.52	1419.5	1421.01	68423.0
2012-03-30 14:00:00	ES	Futures	1421.27	1422.78	1420.25	1420.51	95701.0
2012-03-30 15:00:00	ES	Futures	1420.51	1421.77	1418.48	1419.5	267135.0
2012-03-30 16:00:00	ES	Futures	1419.5	1421.52	1418.23	1420.76	131770.0
2012-03-30 00:00:00	NQ	Futures	3197.11	3197.69	3195.09	3196.82	236.0
2012-03-30 01:00:00	NQ	Futures	3196.24	3198.27	3195.09	3195.38	278.0
2012-03-30 02:00:00	NQ	Futures	3195.38	3200.58	3194.22	3199.43	853.0
2012-03-30 03:00:00	NQ	Futures	3199.43	3204.34	3198.85	3202.03	3489.0
2012-03-30 04:00:00	NQ	Futures	3202.03	3203.76	3196.24	3202.9	2008.0
2012-03-30 05:00:00	NQ	Futures	3202.9	3208.1	3200.58	3207.81	2150.0
2012-03-30 06:00:00	NQ	Futures	3207.81	3207.81	3203.76	3205.5	1230.0
2012-03-30 07:00:00	NQ	Futures	3205.5	3208.1	3204.92	3206.66	1685.0
2012-03-30 08:00:00	NQ	Futures	3206.37	3207.81	3200.58	3202.32	4866.0
2012-03-30 09:00:00	NQ	Futures	3202.32	3204.92	3187.57	3187.86	34233.0
2012-03-30 10:00:00	NQ	Futures	3187.86	3191.91	3169.93	3180.34	52206.0
2012-03-30 11:00:00	NQ	Futures	3180.34	3192.2	3180.05	3189.3	29288.0
2012-03-30 12:00:00	NQ	Futures	3189.59	3191.33	3183.81	3187.57	13990.0
2012-03-30 13:00:00	NQ	Futures	3187.28	3192.77	3187.28	3191.04	9137.0
2012-03-30 14:00:00	NQ	Futures	3191.33	3192.77	3184.1	3184.97	12344.0
2012-03-30 15:00:00	NQ	Futures	3184.68	3189.3	3181.78	3182.36	28322.0
2012-03-30 16:00:00	NQ	Futures	3182.65	3188.15	3180.05	3185.54	8428.0
2012-03-30 00:00:00	YM	Futures	13064.5	13064.5	13056.5	13060.5	264.0
2012-03-30 01:00:00	YM	Futures	13061.5	13067.5	13054.5	13056.5	300.0
2012-03-30 02:00:00	YM	Futures	13055.5	13077.4	13052.5	13069.5	694.0
2012-03-30 03:00:00	YM	Futures	13068.5	13085.4	13063.5	13076.4	2103.0
2012-03-30 04:00:00	YM	Futures	13076.4	13078.4	13054.5	13073.4	1790.0
2012-03-30 05:00:00	YM	Futures	13073.4	13093.4	13064.5	13089.4	2083.0
2012-03-30 06:00:00	YM	Futures	13089.4	13089.4	13076.4	13080.4	1048.0
2012-03-30 07:00:00	YM	Futures	13080.4	13092.4	13078.4	13088.4	1073.0
2012-03-30 08:00:00	YM	Futures	13088.4	13093.4	13070.5	13078.4	2085.0
2012-03-30 09:00:00	YM	Futures	13078.4	13088.4	13052.5	13060.5	12687.0
2012-03-30 10:00:00	YM	Futures	13060.5	13071.5	13031.6	13051.5	14975.0
2012-03-30 11:00:00	YM	Futures	13050.5	13089.4	13048.5	13084.4	13507.0
2012-03-30 12:00:00	YM	Futures	13084.4	13098.4	13076.4	13084.4	8372.0
2012-03-30 13:00:00	YM	Futures	13085.4	13093.4	13081.4	13090.4	4137.0
2012-03-30 14:00:00	YM	Futures	13091.4	13109.3	13090.4	13094.4	5793.0
2012-03-30 15:00:00	YM	Futures	13094.4	13103.3	13077.4	13099.3	11293.0

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

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