PREVIEW / futures_30min / 2013-07-09

all futures 30-min files

  file:    by_date/futures_30min/2013/2013-07-09.parquet
  size:    76 KB
  rows:    2,836

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-09 00:00:00	ES	Futures	1697.02	1697.54	1696.76	1697.02	1565.0
2013-07-09 00:30:00	ES	Futures	1697.02	1698.05	1696.76	1698.05	2541.0
2013-07-09 01:00:00	ES	Futures	1698.05	1698.83	1697.79	1698.57	2605.0
2013-07-09 01:30:00	ES	Futures	1698.57	1699.34	1697.28	1697.79	2183.0
2013-07-09 02:00:00	ES	Futures	1697.79	1699.34	1697.28	1697.54	3828.0
2013-07-09 02:30:00	ES	Futures	1697.54	1698.57	1696.76	1697.79	3325.0
2013-07-09 03:00:00	ES	Futures	1697.79	1700.12	1697.02	1699.09	14770.0
2013-07-09 03:30:00	ES	Futures	1699.34	1700.12	1698.57	1699.34	9040.0
2013-07-09 04:00:00	ES	Futures	1699.6	1700.9	1699.34	1700.12	9032.0
2013-07-09 04:30:00	ES	Futures	1700.12	1700.38	1698.31	1699.09	6233.0
2013-07-09 05:00:00	ES	Futures	1698.83	1699.34	1698.31	1698.83	3225.0
2013-07-09 05:30:00	ES	Futures	1698.57	1699.34	1697.54	1698.05	5899.0
2013-07-09 06:00:00	ES	Futures	1697.79	1698.31	1696.5	1697.02	7924.0
2013-07-09 06:30:00	ES	Futures	1697.28	1698.05	1694.69	1695.98	15751.0
2013-07-09 07:00:00	ES	Futures	1695.98	1697.54	1695.98	1697.54	8728.0
2013-07-09 07:30:00	ES	Futures	1697.28	1698.57	1697.02	1697.54	9143.0
2013-07-09 08:00:00	ES	Futures	1697.79	1698.05	1696.24	1697.79	11341.0
2013-07-09 08:30:00	ES	Futures	1697.79	1700.64	1697.54	1700.12	20948.0
2013-07-09 09:00:00	ES	Futures	1700.12	1702.45	1699.6	1700.9	39369.0
2013-07-09 09:30:00	ES	Futures	1701.15	1702.71	1698.05	1698.83	144844.0
2013-07-09 10:00:00	ES	Futures	1699.09	1699.09	1694.17	1694.95	152531.0
2013-07-09 10:30:00	ES	Futures	1694.95	1699.34	1693.92	1699.09	101007.0
2013-07-09 11:00:00	ES	Futures	1699.09	1700.9	1698.83	1700.64	82018.0
2013-07-09 11:30:00	ES	Futures	1700.38	1702.19	1699.6	1700.12	72223.0
2013-07-09 12:00:00	ES	Futures	1700.12	1701.93	1699.86	1701.67	38180.0
2013-07-09 12:30:00	ES	Futures	1701.67	1703.74	1701.15	1703.48	58395.0
2013-07-09 13:00:00	ES	Futures	1703.22	1704.26	1702.19	1702.19	38139.0
2013-07-09 13:30:00	ES	Futures	1702.45	1703.48	1700.64	1702.96	55624.0
2013-07-09 14:00:00	ES	Futures	1702.96	1705.03	1702.45	1704.26	45374.0
2013-07-09 14:30:00	ES	Futures	1704.26	1704.51	1701.67	1702.19	37369.0
2013-07-09 15:00:00	ES	Futures	1701.93	1704.77	1701.93	1704.0	49509.0
2013-07-09 15:30:00	ES	Futures	1703.74	1705.03	1701.15	1702.19	103150.0
2013-07-09 16:00:00	ES	Futures	1702.19	1702.96	1700.9	1701.41	70660.0
2013-07-09 16:30:00	ES	Futures	1701.67	1701.93	1701.15	1701.93	5869.0
2013-07-09 17:00:00	ES	Futures	1701.93	1702.96	1701.67	1702.96	3862.0
2013-07-09 18:00:00	ES	Futures	1702.96	1703.48	1702.71	1703.22	1887.0
2013-07-09 18:30:00	ES	Futures	1702.96	1703.22	1702.45	1702.71	728.0
2013-07-09 19:00:00	ES	Futures	1702.96	1702.96	1702.45	1702.96	382.0
2013-07-09 19:30:00	ES	Futures	1702.71	1703.22	1702.19	1702.71	872.0
2013-07-09 20:00:00	ES	Futures	1702.71	1702.96	1701.93	1702.19	1360.0
2013-07-09 20:30:00	ES	Futures	1701.93	1703.22	1701.93	1702.19	1853.0
2013-07-09 21:00:00	ES	Futures	1702.19	1703.22	1701.93	1702.96	1485.0
2013-07-09 21:30:00	ES	Futures	1702.96	1704.26	1702.71	1703.48	2764.0
2013-07-09 22:00:00	ES	Futures	1703.22	1703.22	1699.86	1699.86	8920.0
2013-07-09 22:30:00	ES	Futures	1700.12	1700.64	1699.34	1700.38	3085.0
2013-07-09 23:00:00	ES	Futures	1700.38	1700.64	1699.6	1700.38	1227.0
2013-07-09 23:30:00	ES	Futures	1700.12	1700.38	1699.09	1700.12	2141.0
2013-07-09 00:00:00	NQ	Futures	3470.01	3470.59	3469.72	3470.01	244.0
2013-07-09 00:30:00	NQ	Futures	3470.3	3471.47	3470.01	3471.47	137.0
2013-07-09 01:00:00	NQ	Futures	3471.47	3474.1	3471.47	3473.22	319.0

> showing 50 of 2,836 rows — these rows as CSV

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