PREVIEW / futures_1hour / 2012-10-05

all futures 1-hour files

  file:    by_date/futures_1hour/2012/2012-10-05.parquet
  size:    41 KB
  rows:    1,184

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-10-05 00:00:00	ES	Futures	1488.84	1489.61	1488.59	1489.35	2272.0
2012-10-05 01:00:00	ES	Futures	1489.1	1489.61	1488.84	1489.1	2336.0
2012-10-05 02:00:00	ES	Futures	1488.84	1489.35	1487.82	1488.08	3817.0
2012-10-05 03:00:00	ES	Futures	1488.08	1489.35	1487.31	1487.57	22359.0
2012-10-05 04:00:00	ES	Futures	1487.57	1488.33	1486.29	1487.05	19052.0
2012-10-05 05:00:00	ES	Futures	1487.05	1489.1	1486.54	1488.33	16466.0
2012-10-05 06:00:00	ES	Futures	1488.33	1489.61	1488.08	1489.1	13455.0
2012-10-05 07:00:00	ES	Futures	1489.1	1491.4	1488.59	1490.63	26608.0
2012-10-05 08:00:00	ES	Futures	1490.63	1496.0	1488.08	1493.95	159451.0
2012-10-05 09:00:00	ES	Futures	1494.21	1496.51	1492.93	1495.48	229814.0
2012-10-05 10:00:00	ES	Futures	1495.48	1498.04	1493.7	1494.97	257013.0
2012-10-05 11:00:00	ES	Futures	1494.97	1495.48	1491.91	1493.44	194413.0
2012-10-05 12:00:00	ES	Futures	1493.19	1494.46	1491.4	1493.44	96797.0
2012-10-05 13:00:00	ES	Futures	1493.7	1494.21	1489.86	1490.89	86631.0
2012-10-05 14:00:00	ES	Futures	1490.63	1491.65	1485.27	1485.78	132473.0
2012-10-05 15:00:00	ES	Futures	1485.78	1487.82	1482.97	1487.57	311568.0
2012-10-05 16:00:00	ES	Futures	1487.82	1488.08	1486.29	1487.31	79714.0
2012-10-05 00:00:00	NQ	Futures	3283.51	3284.68	3282.93	3284.09	161.0
2012-10-05 01:00:00	NQ	Futures	3284.09	3284.68	3282.64	3282.93	155.0
2012-10-05 02:00:00	NQ	Futures	3283.22	3284.09	3281.77	3281.77	380.0
2012-10-05 03:00:00	NQ	Futures	3282.06	3284.68	3280.9	3282.06	1360.0
2012-10-05 04:00:00	NQ	Futures	3281.77	3283.51	3280.03	3281.77	956.0
2012-10-05 05:00:00	NQ	Futures	3281.77	3286.42	3281.19	3284.97	1111.0
2012-10-05 06:00:00	NQ	Futures	3284.38	3287.29	3284.09	3286.42	944.0
2012-10-05 07:00:00	NQ	Futures	3286.71	3290.2	3285.84	3288.45	1736.0
2012-10-05 08:00:00	NQ	Futures	3288.16	3300.95	3285.55	3296.3	14534.0
2012-10-05 09:00:00	NQ	Futures	3296.3	3299.79	3289.32	3295.72	30475.0
2012-10-05 10:00:00	NQ	Futures	3295.72	3301.82	3285.55	3287.0	34592.0
2012-10-05 11:00:00	NQ	Futures	3286.71	3288.74	3277.12	3279.15	22972.0
2012-10-05 12:00:00	NQ	Futures	3279.15	3281.48	3271.02	3280.61	18041.0
2012-10-05 13:00:00	NQ	Futures	3280.32	3283.22	3272.76	3275.38	15296.0
2012-10-05 14:00:00	NQ	Futures	3275.38	3277.7	3261.14	3262.01	22547.0
2012-10-05 15:00:00	NQ	Futures	3261.72	3265.5	3254.16	3261.43	36591.0
2012-10-05 16:00:00	NQ	Futures	3261.43	3264.04	3258.81	3259.4	6281.0
2012-10-05 00:00:00	YM	Futures	13512.0	13516.0	13510.0	13514.0	258.0
2012-10-05 01:00:00	YM	Futures	13513.0	13517.0	13510.0	13512.0	581.0
2012-10-05 02:00:00	YM	Futures	13513.0	13514.0	13503.9	13506.0	590.0
2012-10-05 03:00:00	YM	Futures	13506.0	13516.0	13500.9	13506.0	1689.0
2012-10-05 04:00:00	YM	Futures	13505.0	13511.0	13495.9	13497.9	2383.0
2012-10-05 05:00:00	YM	Futures	13498.9	13523.0	13495.9	13518.0	1906.0
2012-10-05 06:00:00	YM	Futures	13518.0	13528.0	13516.0	13526.0	978.0
2012-10-05 07:00:00	YM	Futures	13527.0	13542.0	13522.0	13534.0	1643.0
2012-10-05 08:00:00	YM	Futures	13533.0	13563.0	13518.0	13555.0	10119.0
2012-10-05 09:00:00	YM	Futures	13557.0	13587.0	13555.0	13578.0	16725.0
2012-10-05 10:00:00	YM	Futures	13578.0	13606.0	13566.0	13582.0	18627.0
2012-10-05 11:00:00	YM	Futures	13583.0	13586.0	13557.0	13571.0	10321.0
2012-10-05 12:00:00	YM	Futures	13572.0	13583.0	13562.0	13576.0	6144.0
2012-10-05 13:00:00	YM	Futures	13576.0	13580.0	13552.0	13561.0	6712.0
2012-10-05 14:00:00	YM	Futures	13559.0	13567.0	13526.0	13528.0	8878.0
2012-10-05 15:00:00	YM	Futures	13528.0	13553.0	13508.0	13552.0	17012.0

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

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