PREVIEW / futures_1hour / 2013-07-03

all futures 1-hour files

  file:    by_date/futures_1hour/2013/2013-07-03.parquet
  size:    48 KB
  rows:    1,398

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-03 00:00:00	ES	Futures	1659.8	1660.05	1657.99	1660.05	2904.0
2013-07-03 01:00:00	ES	Futures	1659.8	1661.09	1658.24	1658.5	4779.0
2013-07-03 02:00:00	ES	Futures	1658.5	1660.05	1654.88	1656.18	16157.0
2013-07-03 03:00:00	ES	Futures	1655.92	1656.43	1648.42	1648.68	51154.0
2013-07-03 04:00:00	ES	Futures	1648.94	1652.82	1648.16	1651.78	31734.0
2013-07-03 05:00:00	ES	Futures	1651.78	1654.37	1650.49	1653.07	19978.0
2013-07-03 06:00:00	ES	Futures	1653.07	1654.37	1651.26	1651.78	19631.0
2013-07-03 07:00:00	ES	Futures	1651.78	1654.37	1651.52	1653.59	23960.0
2013-07-03 08:00:00	ES	Futures	1653.85	1659.8	1651.26	1656.18	68648.0
2013-07-03 09:00:00	ES	Futures	1656.18	1658.76	1651.52	1655.66	173565.0
2013-07-03 10:00:00	ES	Futures	1655.92	1659.02	1652.56	1656.69	190328.0
2013-07-03 11:00:00	ES	Futures	1656.95	1666.0	1656.69	1665.74	172793.0
2013-07-03 12:00:00	ES	Futures	1665.74	1667.81	1662.9	1663.16	166278.0
2013-07-03 13:00:00	ES	Futures	1663.16	1664.97	1662.64	1664.71	54012.0
2013-07-03 18:00:00	ES	Futures	1663.67	1664.71	1663.16	1664.45	1454.0
2013-07-03 19:00:00	ES	Futures	1664.45	1665.22	1664.45	1664.97	1349.0
2013-07-03 20:00:00	ES	Futures	1664.71	1665.74	1664.19	1664.45	2836.0
2013-07-03 21:00:00	ES	Futures	1664.45	1665.48	1663.67	1664.45	1954.0
2013-07-03 22:00:00	ES	Futures	1664.19	1665.22	1663.93	1665.22	1312.0
2013-07-03 23:00:00	ES	Futures	1665.22	1665.74	1664.71	1665.48	2672.0
2013-07-03 00:00:00	NQ	Futures	3411.85	3412.44	3408.05	3410.98	263.0
2013-07-03 01:00:00	NQ	Futures	3411.85	3414.19	3409.81	3409.81	445.0
2013-07-03 02:00:00	NQ	Futures	3410.1	3413.31	3403.67	3403.96	1176.0
2013-07-03 03:00:00	NQ	Futures	3403.96	3404.55	3387.01	3387.89	8061.0
2013-07-03 04:00:00	NQ	Futures	3387.6	3395.49	3386.43	3393.15	3293.0
2013-07-03 05:00:00	NQ	Futures	3393.44	3400.16	3391.98	3397.83	3478.0
2013-07-03 06:00:00	NQ	Futures	3398.12	3399.0	3392.86	3395.78	2524.0
2013-07-03 07:00:00	NQ	Futures	3395.78	3400.46	3394.9	3399.29	2812.0
2013-07-03 08:00:00	NQ	Futures	3399.29	3413.02	3394.32	3409.52	11619.0
2013-07-03 09:00:00	NQ	Futures	3409.52	3421.79	3401.63	3416.53	29072.0
2013-07-03 10:00:00	NQ	Futures	3416.24	3428.22	3408.64	3423.84	33799.0
2013-07-03 11:00:00	NQ	Futures	3424.13	3440.49	3421.79	3440.49	21545.0
2013-07-03 12:00:00	NQ	Futures	3440.49	3447.21	3430.85	3431.14	26059.0
2013-07-03 13:00:00	NQ	Futures	3431.14	3436.11	3430.26	3432.6	4429.0
2013-07-03 18:00:00	NQ	Futures	3434.06	3434.06	3429.68	3433.19	234.0
2013-07-03 19:00:00	NQ	Futures	3433.48	3438.45	3433.48	3437.57	261.0
2013-07-03 20:00:00	NQ	Futures	3437.28	3439.32	3436.99	3438.45	642.0
2013-07-03 21:00:00	NQ	Futures	3438.15	3440.2	3437.28	3438.74	809.0
2013-07-03 22:00:00	NQ	Futures	3438.74	3441.08	3437.86	3441.08	336.0
2013-07-03 23:00:00	NQ	Futures	3440.79	3442.54	3439.91	3440.79	308.0
2013-07-03 00:00:00	YM	Futures	15079.8	15080.8	15066.6	15079.8	338.0
2013-07-03 01:00:00	YM	Futures	15078.8	15091.0	15071.7	15071.7	820.0
2013-07-03 02:00:00	YM	Futures	15072.7	15083.9	15044.3	15052.4	1563.0
2013-07-03 03:00:00	YM	Futures	15051.4	15053.4	14984.3	14987.4	6371.0
2013-07-03 04:00:00	YM	Futures	14987.4	15017.9	14982.3	15007.7	3732.0
2013-07-03 05:00:00	YM	Futures	15007.7	15031.1	14997.5	15019.9	2194.0
2013-07-03 06:00:00	YM	Futures	15021.9	15029.0	15005.7	15011.8	2021.0
2013-07-03 07:00:00	YM	Futures	15010.8	15031.1	15007.7	15025.0	1994.0
2013-07-03 08:00:00	YM	Futures	15026.0	15077.8	15003.6	15050.4	7381.0
2013-07-03 09:00:00	YM	Futures	15052.4	15096.1	15014.8	15072.7	18190.0

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

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