PREVIEW / futures_1hour / 2013-03-05

all futures 1-hour files

  file:    by_date/futures_1hour/2013/2013-03-05.parquet
  size:    49 KB
  rows:    1,542

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-03-05 00:00:00	ES	Futures	1565.72	1565.98	1564.69	1565.21	3854.0
2013-03-05 01:00:00	ES	Futures	1565.46	1566.75	1565.21	1566.49	4274.0
2013-03-05 02:00:00	ES	Futures	1566.75	1566.75	1565.46	1566.49	9250.0
2013-03-05 03:00:00	ES	Futures	1566.75	1569.31	1566.49	1568.8	43603.0
2013-03-05 04:00:00	ES	Futures	1568.8	1570.59	1568.54	1570.08	40356.0
2013-03-05 05:00:00	ES	Futures	1570.08	1570.59	1568.8	1569.57	23010.0
2013-03-05 06:00:00	ES	Futures	1569.57	1570.08	1568.03	1569.57	17794.0
2013-03-05 07:00:00	ES	Futures	1569.31	1570.34	1568.8	1569.57	30480.0
2013-03-05 08:00:00	ES	Futures	1569.57	1573.16	1569.31	1572.39	78575.0
2013-03-05 09:00:00	ES	Futures	1572.65	1577.01	1571.88	1575.73	328216.0
2013-03-05 10:00:00	ES	Futures	1575.73	1581.88	1575.21	1580.6	465515.0
2013-03-05 11:00:00	ES	Futures	1580.34	1582.4	1578.8	1581.11	255498.0
2013-03-05 12:00:00	ES	Futures	1581.11	1581.88	1579.32	1580.34	101795.0
2013-03-05 13:00:00	ES	Futures	1580.6	1583.42	1579.32	1580.09	139859.0
2013-03-05 14:00:00	ES	Futures	1579.83	1580.86	1577.78	1579.57	149561.0
2013-03-05 15:00:00	ES	Futures	1579.57	1581.63	1576.75	1579.06	270696.0
2013-03-05 16:00:00	ES	Futures	1579.32	1579.83	1577.01	1579.32	104216.0
2013-03-05 17:00:00	ES	Futures	1579.32	1580.34	1579.32	1579.83	3534.0
2013-03-05 18:00:00	ES	Futures	1579.57	1580.09	1579.06	1579.57	6115.0
2013-03-05 19:00:00	ES	Futures	1579.57	1579.57	1577.78	1578.8	7086.0
2013-03-05 20:00:00	ES	Futures	1579.06	1579.57	1578.29	1578.8	3175.0
2013-03-05 21:00:00	ES	Futures	1578.8	1578.8	1577.52	1578.8	4860.0
2013-03-05 22:00:00	ES	Futures	1578.8	1579.06	1578.29	1578.55	2278.0
2013-03-05 23:00:00	ES	Futures	1578.55	1579.06	1578.29	1578.29	2429.0
2013-03-05 00:00:00	NQ	Futures	3216.6	3216.9	3215.15	3216.02	199.0
2013-03-05 01:00:00	NQ	Futures	3216.02	3217.48	3215.73	3216.6	187.0
2013-03-05 02:00:00	NQ	Futures	3216.6	3221.55	3215.15	3219.52	1292.0
2013-03-05 03:00:00	NQ	Futures	3219.52	3222.43	3218.35	3220.97	3102.0
2013-03-05 04:00:00	NQ	Futures	3220.97	3226.5	3220.68	3225.34	3473.0
2013-03-05 05:00:00	NQ	Futures	3225.63	3225.63	3221.26	3223.01	1383.0
2013-03-05 06:00:00	NQ	Futures	3222.72	3223.59	3220.68	3223.3	1292.0
2013-03-05 07:00:00	NQ	Futures	3223.3	3227.37	3223.01	3226.21	3251.0
2013-03-05 08:00:00	NQ	Futures	3226.21	3231.45	3225.92	3229.99	5397.0
2013-03-05 09:00:00	NQ	Futures	3229.99	3247.46	3229.12	3240.76	54011.0
2013-03-05 10:00:00	NQ	Futures	3240.76	3258.52	3240.18	3251.82	50131.0
2013-03-05 11:00:00	NQ	Futures	3252.11	3264.05	3250.08	3261.43	30882.0
2013-03-05 12:00:00	NQ	Futures	3261.72	3264.34	3255.61	3257.06	14935.0
2013-03-05 13:00:00	NQ	Futures	3257.06	3263.76	3252.99	3254.15	15169.0
2013-03-05 14:00:00	NQ	Futures	3254.15	3257.94	3248.91	3251.82	13930.0
2013-03-05 15:00:00	NQ	Futures	3251.82	3261.72	3247.75	3259.68	33167.0
2013-03-05 16:00:00	NQ	Futures	3259.39	3260.26	3254.73	3259.39	7094.0
2013-03-05 17:00:00	NQ	Futures	3259.68	3261.43	3259.1	3261.14	303.0
2013-03-05 18:00:00	NQ	Futures	3260.85	3261.14	3259.97	3260.56	270.0
2013-03-05 19:00:00	NQ	Futures	3259.97	3260.26	3256.48	3259.68	686.0
2013-03-05 20:00:00	NQ	Futures	3259.39	3260.56	3258.23	3259.39	368.0
2013-03-05 21:00:00	NQ	Futures	3259.1	3259.1	3257.35	3258.81	326.0
2013-03-05 22:00:00	NQ	Futures	3258.81	3258.81	3257.65	3257.65	340.0
2013-03-05 23:00:00	NQ	Futures	3257.65	3258.52	3257.65	3257.94	100.0
2013-03-05 00:00:00	YM	Futures	14206.1	14206.1	14198.0	14201.0	352.0
2013-03-05 01:00:00	YM	Futures	14202.1	14209.1	14202.1	14208.1	370.0

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

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