PREVIEW / futures_1hour / 2013-05-24

all futures 1-hour files

  file:    by_date/futures_1hour/2013/2013-05-24.parquet
  size:    42 KB
  rows:    1,249

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-24 00:00:00	ES	Futures	1700.06	1700.57	1694.9	1696.45	17069.0
2013-05-24 01:00:00	ES	Futures	1696.45	1702.37	1695.94	1701.34	14157.0
2013-05-24 02:00:00	ES	Futures	1701.6	1702.12	1698.77	1701.34	10148.0
2013-05-24 03:00:00	ES	Futures	1701.6	1702.12	1697.22	1697.48	23101.0
2013-05-24 04:00:00	ES	Futures	1697.48	1702.63	1697.22	1700.06	24332.0
2013-05-24 05:00:00	ES	Futures	1700.06	1700.31	1693.87	1694.13	29300.0
2013-05-24 06:00:00	ES	Futures	1694.13	1695.42	1690.78	1691.81	29301.0
2013-05-24 07:00:00	ES	Futures	1691.81	1692.84	1688.47	1692.33	57534.0
2013-05-24 08:00:00	ES	Futures	1692.33	1697.48	1690.78	1691.56	83035.0
2013-05-24 09:00:00	ES	Futures	1691.56	1692.07	1686.4	1687.43	308080.0
2013-05-24 10:00:00	ES	Futures	1687.43	1690.53	1684.09	1690.01	339099.0
2013-05-24 11:00:00	ES	Futures	1690.27	1693.36	1687.69	1692.59	220155.0
2013-05-24 12:00:00	ES	Futures	1692.59	1693.87	1689.75	1691.81	137169.0
2013-05-24 13:00:00	ES	Futures	1691.81	1696.19	1691.56	1695.16	135991.0
2013-05-24 14:00:00	ES	Futures	1695.42	1698.0	1693.87	1696.19	132831.0
2013-05-24 15:00:00	ES	Futures	1696.19	1698.25	1692.59	1697.74	214076.0
2013-05-24 16:00:00	ES	Futures	1698.0	1701.09	1697.22	1700.06	110485.0
2013-05-24 17:00:00	ES	Futures	1699.8	1700.31	1699.8	1700.06	1037.0
2013-05-24 00:00:00	NQ	Futures	3494.18	3495.64	3482.81	3485.72	2627.0
2013-05-24 01:00:00	NQ	Futures	3485.72	3495.93	3483.39	3494.77	2052.0
2013-05-24 02:00:00	NQ	Futures	3494.77	3496.22	3489.81	3495.64	1075.0
2013-05-24 03:00:00	NQ	Futures	3495.35	3496.22	3484.56	3485.72	3011.0
2013-05-24 04:00:00	NQ	Futures	3485.72	3499.43	3485.14	3494.18	2906.0
2013-05-24 05:00:00	NQ	Futures	3494.47	3495.93	3481.06	3481.93	2899.0
2013-05-24 06:00:00	NQ	Futures	3481.93	3483.68	3471.72	3473.47	4356.0
2013-05-24 07:00:00	NQ	Futures	3473.47	3475.81	3467.35	3475.22	5420.0
2013-05-24 08:00:00	NQ	Futures	3475.22	3483.39	3472.89	3473.47	8043.0
2013-05-24 09:00:00	NQ	Futures	3473.47	3476.68	3462.97	3466.77	32254.0
2013-05-24 10:00:00	NQ	Futures	3466.47	3474.06	3457.43	3474.06	36229.0
2013-05-24 11:00:00	NQ	Futures	3474.06	3479.31	3468.22	3478.72	23683.0
2013-05-24 12:00:00	NQ	Futures	3478.72	3481.64	3473.47	3478.72	16563.0
2013-05-24 13:00:00	NQ	Futures	3478.43	3484.85	3477.85	3482.52	11792.0
2013-05-24 14:00:00	NQ	Futures	3482.52	3488.35	3480.47	3482.52	12373.0
2013-05-24 15:00:00	NQ	Futures	3482.52	3489.52	3474.93	3489.52	26155.0
2013-05-24 16:00:00	NQ	Futures	3489.52	3493.89	3488.35	3491.85	7053.0
2013-05-24 17:00:00	NQ	Futures	3491.85	3492.14	3490.97	3491.85	92.0
2013-05-24 00:00:00	YM	Futures	15462.4	15470.5	15426.0	15436.1	2954.0
2013-05-24 01:00:00	YM	Futures	15436.1	15479.6	15434.1	15476.6	2338.0
2013-05-24 02:00:00	YM	Futures	15475.5	15481.6	15457.4	15475.5	1148.0
2013-05-24 03:00:00	YM	Futures	15473.5	15479.6	15443.2	15444.2	1829.0
2013-05-24 04:00:00	YM	Futures	15444.2	15484.6	15442.2	15463.4	2353.0
2013-05-24 05:00:00	YM	Futures	15465.4	15466.4	15419.9	15421.0	2169.0
2013-05-24 06:00:00	YM	Futures	15419.9	15430.1	15398.7	15402.8	2899.0
2013-05-24 07:00:00	YM	Futures	15402.8	15413.9	15382.5	15408.8	4131.0
2013-05-24 08:00:00	YM	Futures	15408.8	15454.3	15403.8	15408.8	7590.0
2013-05-24 09:00:00	YM	Futures	15408.8	15413.9	15366.4	15375.5	24724.0
2013-05-24 10:00:00	YM	Futures	15375.5	15401.7	15347.2	15400.7	30742.0
2013-05-24 11:00:00	YM	Futures	15400.7	15422.0	15375.5	15413.9	21837.0
2013-05-24 12:00:00	YM	Futures	15413.9	15424.0	15393.7	15410.8	10761.0
2013-05-24 13:00:00	YM	Futures	15409.8	15447.2	15407.8	15439.2	11811.0

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

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