PREVIEW / futures_1hour / 2013-05-30

all futures 1-hour files

  file:    by_date/futures_1hour/2013/2013-05-30.parquet
  size:    51 KB
  rows:    1,534

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-05-30 00:00:00	ES	Futures	1697.48	1698.51	1697.22	1697.74	3156.0
2013-05-30 01:00:00	ES	Futures	1698.0	1698.0	1692.59	1693.87	17420.0
2013-05-30 02:00:00	ES	Futures	1693.87	1694.13	1690.78	1692.33	19524.0
2013-05-30 03:00:00	ES	Futures	1692.59	1697.74	1691.56	1696.45	28263.0
2013-05-30 04:00:00	ES	Futures	1696.45	1697.22	1692.33	1692.84	15508.0
2013-05-30 05:00:00	ES	Futures	1693.1	1696.45	1692.33	1694.39	13886.0
2013-05-30 06:00:00	ES	Futures	1694.39	1700.83	1693.1	1700.06	42539.0
2013-05-30 07:00:00	ES	Futures	1700.06	1704.95	1699.8	1701.6	52275.0
2013-05-30 08:00:00	ES	Futures	1701.6	1704.95	1699.28	1700.06	73162.0
2013-05-30 09:00:00	ES	Futures	1700.06	1708.3	1696.71	1706.75	312328.0
2013-05-30 10:00:00	ES	Futures	1706.75	1708.81	1702.89	1707.01	302787.0
2013-05-30 11:00:00	ES	Futures	1706.75	1707.78	1702.63	1707.78	161896.0
2013-05-30 12:00:00	ES	Futures	1707.53	1709.59	1704.69	1707.01	140597.0
2013-05-30 13:00:00	ES	Futures	1706.75	1709.59	1705.21	1708.56	115613.0
2013-05-30 14:00:00	ES	Futures	1708.56	1711.13	1707.27	1710.36	127890.0
2013-05-30 15:00:00	ES	Futures	1710.36	1710.36	1702.63	1703.15	226444.0
2013-05-30 16:00:00	ES	Futures	1702.89	1704.18	1702.89	1703.92	76306.0
2013-05-30 17:00:00	ES	Futures	1703.92	1704.18	1703.66	1703.92	2111.0
2013-05-30 18:00:00	ES	Futures	1703.92	1704.18	1700.83	1702.63	6656.0
2013-05-30 19:00:00	ES	Futures	1702.63	1703.41	1702.12	1703.41	2067.0
2013-05-30 20:00:00	ES	Futures	1703.15	1706.24	1703.15	1705.72	8558.0
2013-05-30 21:00:00	ES	Futures	1705.72	1706.24	1704.44	1704.44	3852.0
2013-05-30 22:00:00	ES	Futures	1704.44	1704.69	1703.66	1704.18	2784.0
2013-05-30 23:00:00	ES	Futures	1704.18	1704.95	1703.92	1704.44	3103.0
2013-05-30 00:00:00	NQ	Futures	3491.56	3494.77	3491.27	3493.6	644.0
2013-05-30 01:00:00	NQ	Futures	3493.6	3493.89	3482.81	3484.56	2467.0
2013-05-30 02:00:00	NQ	Futures	3484.27	3485.72	3478.72	3482.81	2041.0
2013-05-30 03:00:00	NQ	Futures	3482.81	3492.43	3481.06	3489.81	3796.0
2013-05-30 04:00:00	NQ	Futures	3489.52	3491.85	3482.52	3483.68	2222.0
2013-05-30 05:00:00	NQ	Futures	3483.97	3490.68	3482.81	3486.89	2057.0
2013-05-30 06:00:00	NQ	Futures	3486.6	3500.31	3484.85	3497.97	5654.0
2013-05-30 07:00:00	NQ	Futures	3497.97	3508.18	3497.97	3501.47	4777.0
2013-05-30 08:00:00	NQ	Futures	3501.47	3506.43	3495.93	3497.68	7368.0
2013-05-30 09:00:00	NQ	Futures	3497.68	3517.52	3492.43	3516.06	38220.0
2013-05-30 10:00:00	NQ	Futures	3515.77	3519.85	3508.18	3519.85	34438.0
2013-05-30 11:00:00	NQ	Futures	3519.85	3522.47	3513.72	3521.31	21664.0
2013-05-30 12:00:00	NQ	Futures	3521.31	3525.39	3516.35	3521.31	15529.0
2013-05-30 13:00:00	NQ	Futures	3521.31	3528.02	3518.39	3526.27	12707.0
2013-05-30 14:00:00	NQ	Futures	3525.97	3529.77	3523.64	3528.89	17793.0
2013-05-30 15:00:00	NQ	Futures	3528.6	3529.18	3512.85	3513.14	30022.0
2013-05-30 16:00:00	NQ	Futures	3513.14	3514.31	3510.52	3511.97	6496.0
2013-05-30 17:00:00	NQ	Futures	3511.68	3511.97	3511.1	3511.68	212.0
2013-05-30 18:00:00	NQ	Futures	3512.85	3512.85	3505.85	3509.06	971.0
2013-05-30 19:00:00	NQ	Futures	3509.06	3511.39	3508.47	3511.1	250.0
2013-05-30 20:00:00	NQ	Futures	3510.81	3516.35	3510.52	3515.18	968.0
2013-05-30 21:00:00	NQ	Futures	3515.77	3516.64	3513.14	3513.72	480.0
2013-05-30 22:00:00	NQ	Futures	3513.43	3513.72	3512.27	3513.14	367.0
2013-05-30 23:00:00	NQ	Futures	3513.14	3514.89	3512.27	3513.14	517.0
2013-05-30 00:00:00	YM	Futures	15457.4	15467.5	15455.3	15461.4	653.0
2013-05-30 01:00:00	YM	Futures	15461.4	15463.4	15419.9	15427.0	1911.0

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

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