PREVIEW / futures_1hour / 2013-01-16

all futures 1-hour files

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

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-16 00:00:00	ES	Futures	1503.88	1504.14	1500.8	1502.08	11057.0
2013-01-16 01:00:00	ES	Futures	1502.08	1502.85	1500.54	1502.34	6800.0
2013-01-16 02:00:00	ES	Futures	1502.34	1502.6	1500.29	1500.54	10488.0
2013-01-16 03:00:00	ES	Futures	1500.54	1501.83	1499.26	1499.77	23060.0
2013-01-16 04:00:00	ES	Futures	1499.77	1500.03	1498.49	1499.01	17037.0
2013-01-16 05:00:00	ES	Futures	1499.01	1500.8	1498.75	1500.8	15038.0
2013-01-16 06:00:00	ES	Futures	1500.8	1503.11	1500.29	1501.57	30434.0
2013-01-16 07:00:00	ES	Futures	1501.83	1502.34	1498.49	1498.75	53657.0
2013-01-16 08:00:00	ES	Futures	1498.75	1502.34	1498.75	1500.29	48825.0
2013-01-16 09:00:00	ES	Futures	1500.03	1503.37	1500.03	1502.85	174754.0
2013-01-16 10:00:00	ES	Futures	1502.85	1505.16	1502.6	1503.11	160056.0
2013-01-16 11:00:00	ES	Futures	1503.11	1506.7	1502.85	1505.16	152183.0
2013-01-16 12:00:00	ES	Futures	1505.42	1505.93	1503.62	1504.65	99671.0
2013-01-16 13:00:00	ES	Futures	1504.91	1507.47	1503.88	1506.7	100246.0
2013-01-16 14:00:00	ES	Futures	1506.7	1507.73	1505.42	1507.22	65936.0
2013-01-16 15:00:00	ES	Futures	1507.47	1507.47	1504.91	1505.42	158337.0
2013-01-16 16:00:00	ES	Futures	1505.16	1505.42	1503.11	1503.11	68693.0
2013-01-16 17:00:00	ES	Futures	1503.11	1503.88	1503.11	1503.11	1772.0
2013-01-16 18:00:00	ES	Futures	1503.62	1503.62	1501.57	1502.34	5309.0
2013-01-16 19:00:00	ES	Futures	1502.34	1504.91	1502.08	1504.65	9800.0
2013-01-16 20:00:00	ES	Futures	1504.91	1505.68	1504.65	1505.42	7130.0
2013-01-16 21:00:00	ES	Futures	1505.42	1505.42	1503.11	1503.62	4180.0
2013-01-16 22:00:00	ES	Futures	1503.62	1503.88	1499.77	1500.54	16220.0
2013-01-16 23:00:00	ES	Futures	1500.54	1501.06	1499.01	1500.8	8761.0
2013-01-16 00:00:00	NQ	Futures	3165.96	3165.96	3159.55	3161.59	1363.0
2013-01-16 01:00:00	NQ	Futures	3161.01	3163.34	3158.39	3163.05	994.0
2013-01-16 02:00:00	NQ	Futures	3163.05	3163.05	3157.81	3158.39	1156.0
2013-01-16 03:00:00	NQ	Futures	3158.39	3161.88	3156.94	3158.1	3089.0
2013-01-16 04:00:00	NQ	Futures	3157.81	3157.81	3155.77	3156.35	1768.0
2013-01-16 05:00:00	NQ	Futures	3156.35	3160.14	3155.77	3159.85	1649.0
2013-01-16 06:00:00	NQ	Futures	3159.85	3165.09	3159.26	3162.17	3185.0
2013-01-16 07:00:00	NQ	Futures	3162.47	3163.34	3156.94	3158.97	6517.0
2013-01-16 08:00:00	NQ	Futures	3159.26	3165.38	3158.97	3161.59	6310.0
2013-01-16 09:00:00	NQ	Futures	3161.3	3173.24	3161.3	3171.49	30021.0
2013-01-16 10:00:00	NQ	Futures	3171.49	3181.09	3168.87	3171.49	31688.0
2013-01-16 11:00:00	NQ	Futures	3171.49	3180.22	3171.49	3176.44	15814.0
2013-01-16 12:00:00	NQ	Futures	3176.44	3178.47	3171.2	3172.65	12344.0
2013-01-16 13:00:00	NQ	Futures	3172.94	3181.68	3172.36	3180.22	14946.0
2013-01-16 14:00:00	NQ	Futures	3180.22	3187.21	3177.89	3185.75	17249.0
2013-01-16 15:00:00	NQ	Futures	3185.75	3186.04	3175.56	3175.85	22979.0
2013-01-16 16:00:00	NQ	Futures	3175.85	3177.31	3173.82	3174.11	6679.0
2013-01-16 17:00:00	NQ	Futures	3173.82	3174.69	3173.53	3174.4	123.0
2013-01-16 18:00:00	NQ	Futures	3174.11	3174.98	3170.91	3172.36	592.0
2013-01-16 19:00:00	NQ	Futures	3172.36	3175.85	3171.49	3175.85	829.0
2013-01-16 20:00:00	NQ	Futures	3175.85	3177.31	3175.27	3176.73	664.0
2013-01-16 21:00:00	NQ	Futures	3176.73	3177.31	3172.94	3173.82	476.0
2013-01-16 22:00:00	NQ	Futures	3173.53	3174.11	3165.09	3167.12	1620.0
2013-01-16 23:00:00	NQ	Futures	3167.12	3168.0	3162.76	3166.54	657.0
2013-01-16 00:00:00	YM	Futures	13538.1	13539.1	13515.9	13522.0	959.0
2013-01-16 01:00:00	YM	Futures	13521.0	13525.0	13512.9	13524.0	741.0

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

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