PREVIEW / futures_1hour / 2013-07-10

all futures 1-hour files

  file:    by_date/futures_1hour/2013/2013-07-10.parquet
  size:    52 KB
  rows:    1,547

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-10 00:00:00	ES	Futures	1700.38	1700.64	1699.09	1699.34	1845.0
2013-07-10 01:00:00	ES	Futures	1699.6	1700.12	1698.05	1699.6	6592.0
2013-07-10 02:00:00	ES	Futures	1699.6	1700.9	1699.09	1700.38	6656.0
2013-07-10 03:00:00	ES	Futures	1700.64	1703.22	1700.12	1700.64	22422.0
2013-07-10 04:00:00	ES	Futures	1700.64	1701.41	1697.02	1698.31	30685.0
2013-07-10 05:00:00	ES	Futures	1698.05	1700.12	1697.79	1699.6	13704.0
2013-07-10 06:00:00	ES	Futures	1699.34	1700.64	1698.05	1698.31	14902.0
2013-07-10 07:00:00	ES	Futures	1698.31	1701.15	1697.79	1700.64	17774.0
2013-07-10 08:00:00	ES	Futures	1700.64	1702.45	1699.34	1701.67	31397.0
2013-07-10 09:00:00	ES	Futures	1701.41	1703.74	1699.34	1703.22	137080.0
2013-07-10 10:00:00	ES	Futures	1703.22	1704.26	1698.83	1700.38	180301.0
2013-07-10 11:00:00	ES	Futures	1700.12	1701.93	1698.05	1699.6	121412.0
2013-07-10 12:00:00	ES	Futures	1699.34	1701.67	1698.57	1700.64	59545.0
2013-07-10 13:00:00	ES	Futures	1700.9	1702.19	1699.6	1700.9	59450.0
2013-07-10 14:00:00	ES	Futures	1700.38	1709.17	1697.28	1700.12	403632.0
2013-07-10 15:00:00	ES	Futures	1699.86	1704.0	1697.79	1702.96	210810.0
2013-07-10 16:00:00	ES	Futures	1702.71	1710.72	1702.19	1710.2	90612.0
2013-07-10 17:00:00	ES	Futures	1709.94	1715.11	1709.68	1712.27	21042.0
2013-07-10 18:00:00	ES	Futures	1714.6	1720.28	1713.82	1719.25	35742.0
2013-07-10 19:00:00	ES	Futures	1719.25	1719.25	1716.92	1718.47	11700.0
2013-07-10 20:00:00	ES	Futures	1718.21	1720.28	1716.92	1719.25	13138.0
2013-07-10 21:00:00	ES	Futures	1719.51	1720.28	1718.21	1718.47	6864.0
2013-07-10 22:00:00	ES	Futures	1718.73	1720.54	1718.47	1719.77	7170.0
2013-07-10 23:00:00	ES	Futures	1719.77	1723.13	1719.77	1721.58	12473.0
2013-07-10 00:00:00	NQ	Futures	3476.44	3477.02	3474.1	3474.98	285.0
2013-07-10 01:00:00	NQ	Futures	3474.98	3477.02	3473.52	3476.44	765.0
2013-07-10 02:00:00	NQ	Futures	3476.44	3478.78	3475.85	3478.48	499.0
2013-07-10 03:00:00	NQ	Futures	3478.48	3484.91	3478.48	3480.24	2971.0
2013-07-10 04:00:00	NQ	Futures	3480.53	3480.82	3471.18	3473.81	3288.0
2013-07-10 05:00:00	NQ	Futures	3473.52	3477.31	3472.05	3475.56	2165.0
2013-07-10 06:00:00	NQ	Futures	3475.27	3477.31	3470.59	3471.76	2034.0
2013-07-10 07:00:00	NQ	Futures	3471.47	3477.02	3471.18	3476.15	2927.0
2013-07-10 08:00:00	NQ	Futures	3476.44	3479.65	3474.68	3477.9	6648.0
2013-07-10 09:00:00	NQ	Futures	3477.9	3492.51	3472.93	3491.93	25150.0
2013-07-10 10:00:00	NQ	Futures	3491.93	3493.97	3483.74	3487.54	24743.0
2013-07-10 11:00:00	NQ	Futures	3487.84	3492.8	3482.87	3487.84	15194.0
2013-07-10 12:00:00	NQ	Futures	3488.13	3494.85	3486.67	3491.34	8671.0
2013-07-10 13:00:00	NQ	Futures	3491.34	3494.56	3488.42	3493.1	9002.0
2013-07-10 14:00:00	NQ	Futures	3493.39	3506.83	3487.84	3495.14	54194.0
2013-07-10 15:00:00	NQ	Futures	3495.14	3505.95	3492.51	3501.28	28755.0
2013-07-10 16:00:00	NQ	Futures	3500.99	3514.14	3499.82	3513.26	6339.0
2013-07-10 17:00:00	NQ	Futures	3512.97	3523.2	3511.8	3518.52	2043.0
2013-07-10 18:00:00	NQ	Futures	3520.27	3530.79	3520.27	3529.92	2433.0
2013-07-10 19:00:00	NQ	Futures	3529.92	3529.92	3525.53	3526.99	868.0
2013-07-10 20:00:00	NQ	Futures	3526.99	3531.96	3525.53	3530.5	1289.0
2013-07-10 21:00:00	NQ	Futures	3530.5	3532.25	3529.33	3529.92	937.0
2013-07-10 22:00:00	NQ	Futures	3529.62	3533.42	3529.62	3532.25	780.0
2013-07-10 23:00:00	NQ	Futures	3532.25	3538.1	3531.96	3535.18	1328.0
2013-07-10 00:00:00	YM	Futures	15460.7	15462.7	15454.6	15457.7	697.0
2013-07-10 01:00:00	YM	Futures	15457.7	15460.7	15442.4	15458.7	1446.0

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

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