PREVIEW / futures_1hour / 2013-01-11

all futures 1-hour files

  file:    by_date/futures_1hour/2013/2013-01-11.parquet
  size:    43 KB
  rows:    1,263

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
2013-01-11 00:00:00	ES	Futures	1505.93	1506.19	1505.42	1505.93	3448.0
2013-01-11 01:00:00	ES	Futures	1506.19	1506.19	1504.65	1505.42	3633.0
2013-01-11 02:00:00	ES	Futures	1505.42	1506.19	1504.65	1505.16	8807.0
2013-01-11 03:00:00	ES	Futures	1505.42	1506.7	1504.65	1505.16	24223.0
2013-01-11 04:00:00	ES	Futures	1505.16	1505.68	1503.88	1504.39	14946.0
2013-01-11 05:00:00	ES	Futures	1504.39	1505.93	1503.37	1505.42	28041.0
2013-01-11 06:00:00	ES	Futures	1505.42	1505.68	1503.88	1504.65	32685.0
2013-01-11 07:00:00	ES	Futures	1504.65	1506.45	1504.14	1505.42	22502.0
2013-01-11 08:00:00	ES	Futures	1505.68	1506.96	1504.39	1505.42	41399.0
2013-01-11 09:00:00	ES	Futures	1505.16	1506.19	1501.83	1502.08	194048.0
2013-01-11 10:00:00	ES	Futures	1501.83	1503.62	1500.8	1503.11	167996.0
2013-01-11 11:00:00	ES	Futures	1503.11	1504.65	1501.31	1504.14	111763.0
2013-01-11 12:00:00	ES	Futures	1504.14	1504.65	1502.34	1503.11	60161.0
2013-01-11 13:00:00	ES	Futures	1503.37	1504.39	1501.57	1502.34	77185.0
2013-01-11 14:00:00	ES	Futures	1502.34	1504.91	1502.08	1504.14	63284.0
2013-01-11 15:00:00	ES	Futures	1504.14	1506.45	1502.6	1506.19	165232.0
2013-01-11 16:00:00	ES	Futures	1506.19	1506.45	1504.91	1505.68	63761.0
2013-01-11 17:00:00	ES	Futures	1505.42	1506.19	1505.42	1506.19	836.0
2013-01-11 00:00:00	NQ	Futures	3187.79	3188.37	3186.04	3186.92	345.0
2013-01-11 01:00:00	NQ	Futures	3186.92	3187.21	3184.3	3186.33	311.0
2013-01-11 02:00:00	NQ	Futures	3186.33	3188.37	3184.3	3186.04	735.0
2013-01-11 03:00:00	NQ	Futures	3186.04	3188.08	3184.3	3184.88	1817.0
2013-01-11 04:00:00	NQ	Futures	3185.17	3187.79	3183.13	3183.71	1930.0
2013-01-11 05:00:00	NQ	Futures	3183.71	3188.37	3181.68	3187.79	2520.0
2013-01-11 06:00:00	NQ	Futures	3188.08	3188.66	3185.17	3186.04	2879.0
2013-01-11 07:00:00	NQ	Futures	3186.04	3189.53	3185.46	3186.92	2674.0
2013-01-11 08:00:00	NQ	Futures	3187.21	3189.24	3184.88	3186.33	4235.0
2013-01-11 09:00:00	NQ	Futures	3186.33	3194.77	3184.0	3184.59	28506.0
2013-01-11 10:00:00	NQ	Futures	3184.88	3187.5	3181.68	3185.17	22805.0
2013-01-11 11:00:00	NQ	Futures	3185.46	3189.24	3181.09	3188.66	14680.0
2013-01-11 12:00:00	NQ	Futures	3188.66	3189.53	3184.88	3186.92	8924.0
2013-01-11 13:00:00	NQ	Futures	3187.21	3192.45	3185.17	3188.08	12345.0
2013-01-11 14:00:00	NQ	Futures	3188.08	3193.61	3186.92	3191.57	9633.0
2013-01-11 15:00:00	NQ	Futures	3191.57	3194.48	3186.92	3193.61	18480.0
2013-01-11 16:00:00	NQ	Futures	3193.32	3195.36	3191.28	3192.45	4489.0
2013-01-11 17:00:00	NQ	Futures	3192.74	3194.19	3192.45	3193.9	64.0
2013-01-11 00:00:00	YM	Futures	13487.8	13489.8	13483.8	13487.8	233.0
2013-01-11 01:00:00	YM	Futures	13486.8	13487.8	13474.7	13480.7	500.0
2013-01-11 02:00:00	YM	Futures	13481.7	13490.8	13477.7	13484.8	861.0
2013-01-11 03:00:00	YM	Futures	13484.8	13494.8	13478.7	13481.7	1616.0
2013-01-11 04:00:00	YM	Futures	13482.7	13486.8	13472.7	13474.7	1081.0
2013-01-11 05:00:00	YM	Futures	13474.7	13483.8	13467.7	13480.7	1617.0
2013-01-11 06:00:00	YM	Futures	13481.7	13483.8	13471.7	13476.7	1760.0
2013-01-11 07:00:00	YM	Futures	13477.7	13485.8	13472.7	13477.7	1464.0
2013-01-11 08:00:00	YM	Futures	13477.7	13491.8	13471.7	13480.7	3256.0
2013-01-11 09:00:00	YM	Futures	13480.7	13486.8	13457.6	13462.6	14619.0
2013-01-11 10:00:00	YM	Futures	13463.6	13484.8	13460.6	13479.7	12532.0
2013-01-11 11:00:00	YM	Futures	13479.7	13503.9	13476.7	13499.8	9212.0
2013-01-11 12:00:00	YM	Futures	13499.8	13502.9	13487.8	13494.8	5272.0
2013-01-11 13:00:00	YM	Futures	13495.8	13498.8	13476.7	13480.7	5589.0

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

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