PREVIEW / futures_1hour / 2013-07-04

all futures 1-hour files

  file:    by_date/futures_1hour/2013/2013-07-04.parquet
  size:    35 KB
  rows:    987

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-07-04 00:00:00	ES	Futures	1665.48	1666.77	1664.71	1666.77	1544.0
2013-07-04 01:00:00	ES	Futures	1666.77	1667.29	1664.71	1667.03	2205.0
2013-07-04 02:00:00	ES	Futures	1667.03	1668.84	1666.0	1667.55	7297.0
2013-07-04 03:00:00	ES	Futures	1667.29	1669.88	1666.26	1668.84	17831.0
2013-07-04 04:00:00	ES	Futures	1668.84	1669.36	1667.55	1669.1	8646.0
2013-07-04 05:00:00	ES	Futures	1668.84	1669.62	1668.07	1669.1	5748.0
2013-07-04 06:00:00	ES	Futures	1669.1	1670.91	1668.33	1669.88	8988.0
2013-07-04 07:00:00	ES	Futures	1670.13	1672.72	1669.36	1670.39	13830.0
2013-07-04 08:00:00	ES	Futures	1670.39	1677.11	1670.13	1676.86	38388.0
2013-07-04 09:00:00	ES	Futures	1677.11	1679.7	1675.3	1678.15	38557.0
2013-07-04 10:00:00	ES	Futures	1678.15	1678.92	1676.34	1678.41	14706.0
2013-07-04 11:00:00	ES	Futures	1678.41	1679.44	1676.34	1678.92	10507.0
2013-07-04 18:00:00	ES	Futures	1678.92	1679.18	1676.86	1678.15	2324.0
2013-07-04 19:00:00	ES	Futures	1678.15	1678.67	1677.37	1677.37	1656.0
2013-07-04 20:00:00	ES	Futures	1677.37	1678.41	1677.11	1677.37	2117.0
2013-07-04 21:00:00	ES	Futures	1677.37	1679.7	1677.11	1679.18	4303.0
2013-07-04 22:00:00	ES	Futures	1679.44	1679.44	1677.89	1678.67	2015.0
2013-07-04 23:00:00	ES	Futures	1678.67	1679.44	1678.41	1679.18	3555.0
2013-07-04 00:00:00	NQ	Futures	3440.49	3442.54	3439.91	3442.54	170.0
2013-07-04 01:00:00	NQ	Futures	3442.25	3442.54	3438.74	3441.95	387.0
2013-07-04 02:00:00	NQ	Futures	3441.95	3445.46	3440.2	3443.12	626.0
2013-07-04 03:00:00	NQ	Futures	3443.42	3446.92	3439.32	3444.88	3063.0
2013-07-04 04:00:00	NQ	Futures	3444.58	3446.34	3442.83	3444.88	1122.0
2013-07-04 05:00:00	NQ	Futures	3445.46	3446.34	3444.0	3445.46	897.0
2013-07-04 06:00:00	NQ	Futures	3445.46	3450.14	3445.46	3447.8	738.0
2013-07-04 07:00:00	NQ	Futures	3448.09	3452.77	3447.51	3449.84	1249.0
2013-07-04 08:00:00	NQ	Futures	3450.43	3464.16	3449.55	3463.87	2897.0
2013-07-04 09:00:00	NQ	Futures	3464.16	3468.26	3458.9	3467.38	2901.0
2013-07-04 10:00:00	NQ	Futures	3467.67	3467.67	3462.12	3465.92	1543.0
2013-07-04 11:00:00	NQ	Futures	3465.92	3467.38	3462.7	3467.38	606.0
2013-07-04 18:00:00	NQ	Futures	3467.09	3467.09	3462.7	3463.58	351.0
2013-07-04 19:00:00	NQ	Futures	3463.58	3465.04	3462.99	3464.46	343.0
2013-07-04 20:00:00	NQ	Futures	3463.87	3464.46	3462.7	3462.7	398.0
2013-07-04 21:00:00	NQ	Futures	3462.99	3469.42	3462.99	3467.96	497.0
2013-07-04 22:00:00	NQ	Futures	3468.26	3468.26	3465.04	3465.92	286.0
2013-07-04 23:00:00	NQ	Futures	3465.92	3467.38	3465.63	3467.09	116.0
2013-07-04 00:00:00	YM	Futures	15173.3	15179.4	15166.2	15179.4	290.0
2013-07-04 01:00:00	YM	Futures	15178.3	15185.5	15164.1	15181.4	532.0
2013-07-04 02:00:00	YM	Futures	15180.4	15198.7	15174.3	15187.5	831.0
2013-07-04 03:00:00	YM	Futures	15186.5	15211.9	15180.4	15203.7	2663.0
2013-07-04 04:00:00	YM	Futures	15201.7	15209.8	15188.5	15200.7	825.0
2013-07-04 05:00:00	YM	Futures	15202.7	15207.8	15191.5	15200.7	610.0
2013-07-04 06:00:00	YM	Futures	15198.7	15210.8	15189.5	15202.7	777.0
2013-07-04 07:00:00	YM	Futures	15203.7	15228.1	15200.7	15214.9	1107.0
2013-07-04 08:00:00	YM	Futures	15215.9	15277.9	15210.8	15274.8	3883.0
2013-07-04 09:00:00	YM	Futures	15274.8	15303.3	15252.5	15283.0	3501.0
2013-07-04 10:00:00	YM	Futures	15279.9	15286.0	15263.7	15284.0	828.0
2013-07-04 11:00:00	YM	Futures	15286.0	15286.0	15260.6	15280.9	771.0
2013-07-04 18:00:00	YM	Futures	15288.0	15288.0	15266.7	15272.8	154.0
2013-07-04 19:00:00	YM	Futures	15270.8	15274.8	15265.7	15266.7	170.0

> showing 50 of 987 rows — these rows as CSV

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