PREVIEW / futures_1hour / 2012-09-20

all futures 1-hour files

  file:    by_date/futures_1hour/2012/2012-09-20.parquet
  size:    49 KB
  rows:    1,472

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
2012-09-20 00:00:00	ES	Futures	1481.43	1481.43	1479.13	1480.16	8345.0
2012-09-20 01:00:00	ES	Futures	1480.41	1481.18	1479.9	1480.41	6124.0
2012-09-20 02:00:00	ES	Futures	1480.41	1480.92	1477.6	1477.6	16366.0
2012-09-20 03:00:00	ES	Futures	1477.86	1479.65	1476.84	1478.62	45852.0
2012-09-20 04:00:00	ES	Futures	1478.62	1481.43	1477.6	1480.67	23735.0
2012-09-20 05:00:00	ES	Futures	1480.67	1480.92	1478.11	1479.9	26156.0
2012-09-20 06:00:00	ES	Futures	1480.16	1481.69	1479.9	1480.92	13280.0
2012-09-20 07:00:00	ES	Futures	1480.67	1481.94	1479.9	1480.67	22696.0
2012-09-20 08:00:00	ES	Futures	1480.67	1481.18	1477.6	1479.13	51453.0
2012-09-20 09:00:00	ES	Futures	1479.13	1480.41	1475.05	1476.07	222060.0
2012-09-20 10:00:00	ES	Futures	1476.32	1482.97	1475.81	1482.71	278109.0
2012-09-20 11:00:00	ES	Futures	1482.71	1483.99	1480.67	1483.22	189627.0
2012-09-20 12:00:00	ES	Futures	1483.48	1484.5	1480.16	1481.43	113292.0
2012-09-20 13:00:00	ES	Futures	1481.18	1484.24	1480.41	1482.71	85321.0
2012-09-20 14:00:00	ES	Futures	1482.97	1485.01	1482.2	1483.99	102621.0
2012-09-20 15:00:00	ES	Futures	1483.99	1486.8	1483.22	1485.78	236328.0
2012-09-20 16:00:00	ES	Futures	1485.78	1487.31	1484.76	1486.8	79822.0
2012-09-20 17:00:00	ES	Futures	1486.8	1487.57	1486.29	1486.8	3942.0
2012-09-20 18:00:00	ES	Futures	1487.31	1488.33	1486.8	1487.05	5968.0
2012-09-20 19:00:00	ES	Futures	1487.05	1487.57	1486.8	1487.31	1374.0
2012-09-20 20:00:00	ES	Futures	1487.31	1489.61	1487.31	1489.35	7871.0
2012-09-20 21:00:00	ES	Futures	1489.35	1489.35	1487.82	1489.1	4289.0
2012-09-20 22:00:00	ES	Futures	1488.84	1490.12	1488.84	1489.1	4620.0
2012-09-20 23:00:00	ES	Futures	1489.35	1489.35	1487.82	1488.33	3321.0
2012-09-20 00:00:00	NQ	Futures	3311.12	3311.99	3307.63	3309.96	644.0
2012-09-20 01:00:00	NQ	Futures	3309.37	3311.99	3309.08	3309.67	439.0
2012-09-20 02:00:00	NQ	Futures	3309.37	3309.67	3302.11	3302.11	1800.0
2012-09-20 03:00:00	NQ	Futures	3302.11	3305.6	3299.79	3302.98	4698.0
2012-09-20 04:00:00	NQ	Futures	3302.69	3308.79	3300.95	3307.92	1306.0
2012-09-20 05:00:00	NQ	Futures	3307.63	3308.21	3302.69	3306.76	1026.0
2012-09-20 06:00:00	NQ	Futures	3306.76	3311.41	3306.47	3309.67	1055.0
2012-09-20 07:00:00	NQ	Futures	3309.37	3311.99	3307.34	3309.08	2571.0
2012-09-20 08:00:00	NQ	Futures	3309.08	3310.25	3300.37	3306.47	5872.0
2012-09-20 09:00:00	NQ	Futures	3306.47	3310.54	3297.75	3299.2	29828.0
2012-09-20 10:00:00	NQ	Futures	3299.2	3315.77	3298.33	3314.02	36295.0
2012-09-20 11:00:00	NQ	Futures	3314.31	3316.93	3310.25	3314.02	30814.0
2012-09-20 12:00:00	NQ	Futures	3314.31	3315.77	3306.47	3309.37	14183.0
2012-09-20 13:00:00	NQ	Futures	3309.67	3316.64	3308.21	3313.73	11123.0
2012-09-20 14:00:00	NQ	Futures	3313.44	3318.38	3311.99	3316.93	12901.0
2012-09-20 15:00:00	NQ	Futures	3316.93	3321.58	3312.57	3318.96	24187.0
2012-09-20 16:00:00	NQ	Futures	3318.96	3320.71	3316.06	3319.25	11139.0
2012-09-20 17:00:00	NQ	Futures	3319.25	3319.84	3317.8	3318.96	605.0
2012-09-20 18:00:00	NQ	Futures	3317.8	3321.29	3317.8	3319.54	406.0
2012-09-20 19:00:00	NQ	Futures	3319.54	3320.71	3319.25	3320.42	118.0
2012-09-20 20:00:00	NQ	Futures	3320.71	3325.65	3320.42	3325.36	644.0
2012-09-20 21:00:00	NQ	Futures	3325.36	3325.36	3322.16	3325.07	529.0
2012-09-20 22:00:00	NQ	Futures	3325.07	3326.52	3324.19	3325.36	552.0
2012-09-20 23:00:00	NQ	Futures	3325.65	3325.65	3322.45	3323.61	452.0
2012-09-20 00:00:00	YM	Futures	13473.9	13475.9	13460.9	13469.9	707.0
2012-09-20 01:00:00	YM	Futures	13466.9	13476.9	13462.9	13471.9	870.0

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

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