PREVIEW / futures_1hour / 2013-06-12

all futures 1-hour files

  file:    by_date/futures_1hour/2013/2013-06-12.parquet
  size:    48 KB
  rows:    1,450

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-06-12 00:00:00	ES	Futures	1678.93	1679.97	1678.42	1679.71	3149.0
2013-06-12 01:00:00	ES	Futures	1679.71	1681.25	1679.45	1680.48	7090.0
2013-06-12 02:00:00	ES	Futures	1680.22	1681.25	1678.16	1680.22	7688.0
2013-06-12 03:00:00	ES	Futures	1680.22	1685.37	1680.22	1683.57	31728.0
2013-06-12 04:00:00	ES	Futures	1683.57	1684.34	1679.97	1683.06	23420.0
2013-06-12 05:00:00	ES	Futures	1682.8	1685.12	1682.54	1683.06	24517.0
2013-06-12 06:00:00	ES	Futures	1683.06	1686.66	1683.06	1686.15	24699.0
2013-06-12 07:00:00	ES	Futures	1686.15	1686.4	1683.83	1685.63	24468.0
2013-06-12 08:00:00	ES	Futures	1685.63	1686.15	1683.06	1685.37	49918.0
2013-06-12 09:00:00	ES	Futures	1685.12	1687.95	1681.0	1682.03	298335.0
2013-06-12 10:00:00	ES	Futures	1682.28	1682.28	1673.01	1674.04	442943.0
2013-06-12 11:00:00	ES	Futures	1674.04	1676.1	1665.28	1667.09	323051.0
2013-06-12 12:00:00	ES	Futures	1667.09	1668.63	1662.96	1668.37	209142.0
2013-06-12 13:00:00	ES	Futures	1668.12	1671.46	1665.54	1669.4	163256.0
2013-06-12 14:00:00	ES	Futures	1669.4	1669.4	1660.9	1663.22	198522.0
2013-06-12 15:00:00	ES	Futures	1663.22	1664.25	1658.84	1660.65	314370.0
2013-06-12 16:00:00	ES	Futures	1660.9	1661.42	1658.33	1659.87	101916.0
2013-06-12 17:00:00	ES	Futures	1659.87	1659.87	1658.59	1658.59	1932.0
2013-06-12 18:00:00	ES	Futures	1659.62	1660.9	1658.84	1658.84	6685.0
2013-06-12 19:00:00	ES	Futures	1658.84	1660.39	1658.59	1659.36	3847.0
2013-06-12 20:00:00	ES	Futures	1659.62	1660.13	1657.81	1658.59	5723.0
2013-06-12 21:00:00	ES	Futures	1658.59	1659.1	1650.6	1651.12	30602.0
2013-06-12 22:00:00	ES	Futures	1650.86	1653.18	1649.83	1652.66	17475.0
2013-06-12 23:00:00	ES	Futures	1652.66	1653.43	1651.12	1653.18	7417.0
2013-06-12 00:00:00	NQ	Futures	3463.56	3466.18	3462.68	3466.18	402.0
2013-06-12 01:00:00	NQ	Futures	3466.47	3468.22	3465.02	3467.35	851.0
2013-06-12 02:00:00	NQ	Futures	3467.64	3468.52	3462.97	3466.77	901.0
2013-06-12 03:00:00	NQ	Futures	3466.47	3475.81	3466.47	3470.85	4038.0
2013-06-12 04:00:00	NQ	Futures	3470.85	3473.18	3462.1	3470.56	3058.0
2013-06-12 05:00:00	NQ	Futures	3470.27	3476.1	3466.47	3466.77	2985.0
2013-06-12 06:00:00	NQ	Futures	3466.77	3474.93	3466.77	3473.47	2642.0
2013-06-12 07:00:00	NQ	Futures	3473.47	3474.93	3469.97	3472.89	1924.0
2013-06-12 08:00:00	NQ	Futures	3472.6	3474.06	3467.35	3472.31	3809.0
2013-06-12 09:00:00	NQ	Futures	3472.31	3475.81	3457.43	3459.18	37774.0
2013-06-12 10:00:00	NQ	Futures	3459.18	3459.47	3443.14	3444.6	60485.0
2013-06-12 11:00:00	NQ	Futures	3444.89	3449.85	3426.81	3430.31	38358.0
2013-06-12 12:00:00	NQ	Futures	3430.31	3433.22	3419.81	3432.35	31897.0
2013-06-12 13:00:00	NQ	Futures	3432.35	3438.47	3427.97	3433.22	23906.0
2013-06-12 14:00:00	NQ	Futures	3433.52	3434.1	3416.31	3419.52	32540.0
2013-06-12 15:00:00	NQ	Futures	3419.52	3420.1	3407.85	3413.1	40507.0
2013-06-12 16:00:00	NQ	Futures	3413.39	3414.85	3406.1	3409.89	6948.0
2013-06-12 17:00:00	NQ	Futures	3409.6	3409.6	3407.85	3407.85	162.0
2013-06-12 18:00:00	NQ	Futures	3409.89	3411.35	3407.56	3408.72	513.0
2013-06-12 19:00:00	NQ	Futures	3408.43	3410.47	3407.56	3409.02	280.0
2013-06-12 20:00:00	NQ	Futures	3409.02	3410.18	3406.1	3408.14	844.0
2013-06-12 21:00:00	NQ	Futures	3408.14	3408.43	3392.39	3393.27	3176.0
2013-06-12 22:00:00	NQ	Futures	3393.27	3396.77	3391.81	3395.6	1206.0
2013-06-12 23:00:00	NQ	Futures	3395.31	3397.35	3392.68	3396.47	606.0
2013-06-12 00:00:00	YM	Futures	15312.4	15321.6	15312.4	15321.6	10.0
2013-06-12 01:00:00	YM	Futures	15326.6	15336.8	15326.6	15334.8	9.0

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

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