PREVIEW / futures_1hour / 2013-05-10

all futures 1-hour files

  file:    by_date/futures_1hour/2013/2013-05-10.parquet
  size:    45 KB
  rows:    1,266

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-05-10 00:00:00	ES	Futures	1677.9	1677.9	1676.36	1676.36	3018.0
2013-05-10 01:00:00	ES	Futures	1676.36	1676.62	1673.78	1675.59	8179.0
2013-05-10 02:00:00	ES	Futures	1675.59	1677.39	1675.33	1675.59	9180.0
2013-05-10 03:00:00	ES	Futures	1675.59	1680.48	1675.33	1679.97	38035.0
2013-05-10 04:00:00	ES	Futures	1679.71	1679.97	1675.07	1675.84	30013.0
2013-05-10 05:00:00	ES	Futures	1675.59	1676.87	1674.3	1676.87	15254.0
2013-05-10 06:00:00	ES	Futures	1676.62	1678.16	1676.1	1677.65	14901.0
2013-05-10 07:00:00	ES	Futures	1677.65	1677.9	1674.3	1675.33	41557.0
2013-05-10 08:00:00	ES	Futures	1675.33	1676.1	1674.04	1675.07	40707.0
2013-05-10 09:00:00	ES	Futures	1674.81	1677.65	1672.24	1676.87	224805.0
2013-05-10 10:00:00	ES	Futures	1677.13	1678.68	1670.43	1673.53	334191.0
2013-05-10 11:00:00	ES	Futures	1673.53	1676.87	1670.69	1670.69	214297.0
2013-05-10 12:00:00	ES	Futures	1670.69	1674.04	1669.4	1672.75	150826.0
2013-05-10 13:00:00	ES	Futures	1672.75	1675.84	1672.75	1673.78	106993.0
2013-05-10 14:00:00	ES	Futures	1674.04	1676.36	1673.78	1675.07	86928.0
2013-05-10 15:00:00	ES	Futures	1675.07	1679.45	1674.81	1679.19	206604.0
2013-05-10 16:00:00	ES	Futures	1679.19	1679.97	1678.42	1678.68	75058.0
2013-05-10 17:00:00	ES	Futures	1678.93	1679.45	1678.68	1678.68	1833.0
2013-05-10 00:00:00	NQ	Futures	3460.35	3460.93	3458.89	3458.89	199.0
2013-05-10 01:00:00	NQ	Futures	3458.6	3458.89	3453.06	3458.02	828.0
2013-05-10 02:00:00	NQ	Futures	3457.72	3461.81	3457.43	3458.02	1178.0
2013-05-10 03:00:00	NQ	Futures	3457.72	3466.47	3457.72	3465.31	3452.0
2013-05-10 04:00:00	NQ	Futures	3465.31	3465.31	3455.1	3456.85	2272.0
2013-05-10 05:00:00	NQ	Futures	3456.85	3457.72	3453.35	3457.72	1309.0
2013-05-10 06:00:00	NQ	Futures	3457.43	3460.35	3456.27	3458.89	1243.0
2013-05-10 07:00:00	NQ	Futures	3459.18	3459.18	3453.35	3456.27	3094.0
2013-05-10 08:00:00	NQ	Futures	3455.97	3458.02	3453.93	3455.68	4031.0
2013-05-10 09:00:00	NQ	Futures	3455.68	3469.68	3451.89	3468.22	32263.0
2013-05-10 10:00:00	NQ	Futures	3468.22	3472.6	3453.06	3460.35	34830.0
2013-05-10 11:00:00	NQ	Futures	3460.64	3467.06	3455.39	3455.68	21249.0
2013-05-10 12:00:00	NQ	Futures	3455.39	3461.22	3453.06	3459.18	13191.0
2013-05-10 13:00:00	NQ	Futures	3459.18	3466.18	3459.18	3462.97	14184.0
2013-05-10 14:00:00	NQ	Futures	3463.27	3468.81	3462.97	3466.47	9053.0
2013-05-10 15:00:00	NQ	Futures	3466.47	3474.06	3465.02	3473.18	18771.0
2013-05-10 16:00:00	NQ	Futures	3472.89	3474.35	3471.43	3473.47	5332.0
2013-05-10 17:00:00	NQ	Futures	3472.6	3475.22	3472.6	3473.18	249.0
2013-05-10 00:00:00	YM	Futures	15242.0	15242.0	15231.9	15231.9	300.0
2013-05-10 01:00:00	YM	Futures	15231.9	15232.9	15212.7	15227.9	622.0
2013-05-10 02:00:00	YM	Futures	15226.9	15240.0	15223.8	15229.9	999.0
2013-05-10 03:00:00	YM	Futures	15228.9	15277.4	15227.9	15268.3	4473.0
2013-05-10 04:00:00	YM	Futures	15270.3	15270.3	15236.0	15240.0	2354.0
2013-05-10 05:00:00	YM	Futures	15240.0	15245.1	15230.9	15245.1	1517.0
2013-05-10 06:00:00	YM	Futures	15245.1	15258.2	15241.0	15255.2	1030.0
2013-05-10 07:00:00	YM	Futures	15255.2	15256.2	15226.9	15237.0	2334.0
2013-05-10 08:00:00	YM	Futures	15237.0	15241.0	15222.8	15224.8	3204.0
2013-05-10 09:00:00	YM	Futures	15224.8	15238.0	15188.4	15227.9	21265.0
2013-05-10 10:00:00	YM	Futures	15227.9	15244.0	15175.3	15201.6	31041.0
2013-05-10 11:00:00	YM	Futures	15201.6	15223.8	15170.2	15173.3	20264.0
2013-05-10 12:00:00	YM	Futures	15173.3	15194.5	15162.2	15185.4	12748.0
2013-05-10 13:00:00	YM	Futures	15184.4	15207.6	15183.4	15193.5	8530.0

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

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