PREVIEW / futures_1hour / 2013-01-23

all futures 1-hour files

  file:    by_date/futures_1hour/2013/2013-01-23.parquet
  size:    50 KB
  rows:    1,569

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-01-23 00:00:00	ES	Futures	1526.72	1526.97	1525.43	1525.69	8534.0
2013-01-23 01:00:00	ES	Futures	1525.69	1526.72	1525.18	1526.2	5991.0
2013-01-23 02:00:00	ES	Futures	1526.2	1526.46	1525.43	1525.69	8925.0
2013-01-23 03:00:00	ES	Futures	1525.69	1526.97	1524.41	1524.66	28245.0
2013-01-23 04:00:00	ES	Futures	1524.66	1527.49	1524.15	1526.97	24361.0
2013-01-23 05:00:00	ES	Futures	1526.72	1527.49	1526.46	1527.23	12656.0
2013-01-23 06:00:00	ES	Futures	1527.23	1527.49	1526.2	1526.72	10869.0
2013-01-23 07:00:00	ES	Futures	1526.97	1528.26	1526.72	1526.72	26878.0
2013-01-23 08:00:00	ES	Futures	1526.72	1527.23	1525.43	1525.95	32572.0
2013-01-23 09:00:00	ES	Futures	1526.2	1527.74	1525.18	1526.46	145895.0
2013-01-23 10:00:00	ES	Futures	1526.46	1528.77	1523.64	1525.18	220450.0
2013-01-23 11:00:00	ES	Futures	1525.18	1526.97	1524.41	1526.2	151511.0
2013-01-23 12:00:00	ES	Futures	1525.95	1527.49	1525.43	1527.23	82313.0
2013-01-23 13:00:00	ES	Futures	1527.49	1528.51	1527.23	1528.26	65223.0
2013-01-23 14:00:00	ES	Futures	1528.51	1530.31	1527.49	1529.8	74191.0
2013-01-23 15:00:00	ES	Futures	1530.05	1530.31	1527.49	1529.03	163321.0
2013-01-23 16:00:00	ES	Futures	1529.03	1530.31	1524.15	1524.66	93747.0
2013-01-23 17:00:00	ES	Futures	1524.66	1524.92	1523.64	1524.41	3889.0
2013-01-23 18:00:00	ES	Futures	1522.35	1524.15	1521.84	1523.64	16614.0
2013-01-23 19:00:00	ES	Futures	1523.89	1524.15	1522.61	1523.12	8787.0
2013-01-23 20:00:00	ES	Futures	1523.12	1524.15	1522.61	1522.61	5902.0
2013-01-23 21:00:00	ES	Futures	1522.61	1526.2	1522.61	1524.92	12368.0
2013-01-23 22:00:00	ES	Futures	1524.92	1525.69	1523.64	1524.66	5856.0
2013-01-23 23:00:00	ES	Futures	1524.41	1524.92	1523.12	1523.38	3959.0
2013-01-23 00:00:00	NQ	Futures	3205.25	3205.83	3204.09	3204.09	462.0
2013-01-23 01:00:00	NQ	Futures	3204.38	3206.13	3203.51	3206.13	460.0
2013-01-23 02:00:00	NQ	Futures	3206.13	3206.42	3203.51	3203.8	1101.0
2013-01-23 03:00:00	NQ	Futures	3203.8	3204.96	3200.01	3200.6	2680.0
2013-01-23 04:00:00	NQ	Futures	3200.3	3207.0	3199.14	3204.38	2834.0
2013-01-23 05:00:00	NQ	Futures	3204.38	3207.0	3203.8	3207.0	1068.0
2013-01-23 06:00:00	NQ	Futures	3207.0	3207.29	3204.67	3205.83	1248.0
2013-01-23 07:00:00	NQ	Futures	3205.83	3208.45	3204.67	3204.96	2158.0
2013-01-23 08:00:00	NQ	Futures	3204.96	3208.45	3202.34	3206.71	3855.0
2013-01-23 09:00:00	NQ	Futures	3207.0	3211.37	3202.05	3209.91	26202.0
2013-01-23 10:00:00	NQ	Futures	3209.62	3218.06	3204.38	3208.16	33795.0
2013-01-23 11:00:00	NQ	Futures	3208.16	3211.66	3204.96	3206.71	17061.0
2013-01-23 12:00:00	NQ	Futures	3206.71	3209.33	3203.51	3209.04	13441.0
2013-01-23 13:00:00	NQ	Futures	3209.04	3211.95	3207.58	3209.91	11021.0
2013-01-23 14:00:00	NQ	Futures	3209.62	3214.28	3206.42	3213.11	11864.0
2013-01-23 15:00:00	NQ	Futures	3213.4	3214.86	3207.87	3207.87	24271.0
2013-01-23 16:00:00	NQ	Futures	3208.16	3223.59	3179.64	3180.8	30337.0
2013-01-23 17:00:00	NQ	Futures	3180.51	3180.8	3176.73	3178.47	2494.0
2013-01-23 18:00:00	NQ	Futures	3162.47	3162.76	3152.57	3159.85	6733.0
2013-01-23 19:00:00	NQ	Futures	3159.85	3161.88	3158.68	3160.72	1912.0
2013-01-23 20:00:00	NQ	Futures	3161.01	3163.63	3160.72	3161.3	1286.0
2013-01-23 21:00:00	NQ	Futures	3161.3	3166.83	3161.3	3164.21	1574.0
2013-01-23 22:00:00	NQ	Futures	3163.92	3164.79	3159.55	3163.05	1394.0
2013-01-23 23:00:00	NQ	Futures	3163.05	3163.34	3161.01	3161.59	509.0
2013-01-23 00:00:00	YM	Futures	13766.4	13768.5	13757.4	13759.4	322.0
2013-01-23 01:00:00	YM	Futures	13759.4	13770.5	13758.4	13770.5	534.0

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

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