PREVIEW / futures_1hour / 2013-02-19

all futures 1-hour files

  file:    by_date/futures_1hour/2013/2013-02-19.parquet
  size:    48 KB
  rows:    1,494

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-02-19 00:00:00	ES	Futures	1557.76	1558.28	1557.51	1558.28	3034.0
2013-02-19 01:00:00	ES	Futures	1558.02	1558.28	1556.99	1557.51	2957.0
2013-02-19 02:00:00	ES	Futures	1557.25	1557.76	1555.2	1555.46	11551.0
2013-02-19 03:00:00	ES	Futures	1555.46	1558.53	1555.46	1557.76	33261.0
2013-02-19 04:00:00	ES	Futures	1557.76	1559.82	1556.99	1559.05	21688.0
2013-02-19 05:00:00	ES	Futures	1559.05	1559.82	1558.53	1559.56	20355.0
2013-02-19 06:00:00	ES	Futures	1559.3	1559.56	1558.02	1558.28	13935.0
2013-02-19 07:00:00	ES	Futures	1558.53	1560.84	1558.28	1559.3	40668.0
2013-02-19 08:00:00	ES	Futures	1559.05	1560.84	1559.05	1559.82	20785.0
2013-02-19 09:00:00	ES	Futures	1560.07	1564.95	1559.05	1564.44	247781.0
2013-02-19 10:00:00	ES	Futures	1564.44	1565.21	1562.64	1563.15	220272.0
2013-02-19 11:00:00	ES	Futures	1563.41	1566.23	1562.64	1565.98	159603.0
2013-02-19 12:00:00	ES	Futures	1565.98	1565.98	1564.18	1565.72	96221.0
2013-02-19 13:00:00	ES	Futures	1565.72	1566.23	1565.21	1565.72	56534.0
2013-02-19 14:00:00	ES	Futures	1565.72	1568.54	1565.72	1567.26	135207.0
2013-02-19 15:00:00	ES	Futures	1567.26	1569.05	1566.23	1568.54	179474.0
2013-02-19 16:00:00	ES	Futures	1568.28	1569.31	1567.26	1568.54	101384.0
2013-02-19 17:00:00	ES	Futures	1568.54	1569.31	1568.54	1569.31	1226.0
2013-02-19 18:00:00	ES	Futures	1569.05	1569.05	1568.28	1569.05	4541.0
2013-02-19 19:00:00	ES	Futures	1569.05	1569.31	1568.54	1568.8	4842.0
2013-02-19 20:00:00	ES	Futures	1568.8	1569.57	1568.54	1569.05	4899.0
2013-02-19 21:00:00	ES	Futures	1569.05	1569.05	1568.28	1569.05	3841.0
2013-02-19 22:00:00	ES	Futures	1568.8	1569.31	1568.8	1569.31	1650.0
2013-02-19 23:00:00	ES	Futures	1569.31	1569.82	1569.05	1569.57	2408.0
2013-02-19 00:00:00	NQ	Futures	3217.19	3217.77	3216.6	3217.77	134.0
2013-02-19 01:00:00	NQ	Futures	3217.48	3217.77	3215.73	3215.73	225.0
2013-02-19 02:00:00	NQ	Futures	3216.31	3217.19	3213.69	3213.98	579.0
2013-02-19 03:00:00	NQ	Futures	3213.98	3220.39	3213.69	3219.22	2590.0
2013-02-19 04:00:00	NQ	Futures	3219.52	3221.26	3217.77	3219.22	2343.0
2013-02-19 05:00:00	NQ	Futures	3218.93	3220.97	3218.64	3219.81	1342.0
2013-02-19 06:00:00	NQ	Futures	3219.81	3219.81	3217.19	3217.19	870.0
2013-02-19 07:00:00	NQ	Futures	3217.19	3222.72	3216.9	3222.43	3231.0
2013-02-19 08:00:00	NQ	Futures	3222.43	3224.75	3222.13	3223.59	2722.0
2013-02-19 09:00:00	NQ	Futures	3223.59	3233.49	3220.97	3229.99	27701.0
2013-02-19 10:00:00	NQ	Futures	3229.99	3233.2	3223.01	3225.34	26431.0
2013-02-19 11:00:00	NQ	Futures	3225.34	3230.58	3223.01	3229.99	15856.0
2013-02-19 12:00:00	NQ	Futures	3229.99	3230.58	3225.34	3230.28	10993.0
2013-02-19 13:00:00	NQ	Futures	3230.28	3231.74	3224.75	3226.79	8890.0
2013-02-19 14:00:00	NQ	Futures	3226.5	3237.56	3226.5	3235.52	19815.0
2013-02-19 15:00:00	NQ	Futures	3235.52	3240.47	3232.61	3239.31	23182.0
2013-02-19 16:00:00	NQ	Futures	3239.02	3243.67	3236.98	3241.64	5866.0
2013-02-19 17:00:00	NQ	Futures	3241.35	3243.38	3241.05	3243.09	239.0
2013-02-19 18:00:00	NQ	Futures	3241.93	3242.51	3239.31	3240.76	577.0
2013-02-19 19:00:00	NQ	Futures	3240.76	3241.93	3240.47	3241.35	252.0
2013-02-19 20:00:00	NQ	Futures	3241.05	3242.8	3240.47	3241.93	299.0
2013-02-19 21:00:00	NQ	Futures	3241.64	3242.51	3241.05	3242.51	237.0
2013-02-19 22:00:00	NQ	Futures	3242.51	3243.67	3242.22	3243.38	284.0
2013-02-19 23:00:00	NQ	Futures	3243.38	3244.26	3243.38	3244.26	256.0
2013-02-19 00:00:00	YM	Futures	14038.1	14041.1	14037.1	14040.1	168.0
2013-02-19 01:00:00	YM	Futures	14040.1	14040.1	14032.0	14034.0	176.0

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

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