PREVIEW / futures_1hour / 2012-10-04

all futures 1-hour files

  file:    by_date/futures_1hour/2012/2012-10-04.parquet
  size:    48 KB
  rows:    1,499

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-10-04 00:00:00	ES	Futures	1483.22	1484.5	1481.69	1484.24	6026.0
2012-10-04 01:00:00	ES	Futures	1483.99	1484.24	1480.67	1481.69	5408.0
2012-10-04 02:00:00	ES	Futures	1481.43	1484.76	1481.18	1483.73	11130.0
2012-10-04 03:00:00	ES	Futures	1483.48	1484.76	1482.2	1483.48	24112.0
2012-10-04 04:00:00	ES	Futures	1483.22	1483.48	1478.62	1479.65	33419.0
2012-10-04 05:00:00	ES	Futures	1479.39	1480.92	1478.88	1480.67	13574.0
2012-10-04 06:00:00	ES	Futures	1480.67	1483.73	1480.67	1483.22	17021.0
2012-10-04 07:00:00	ES	Futures	1482.97	1483.48	1481.18	1482.46	24615.0
2012-10-04 08:00:00	ES	Futures	1482.71	1484.5	1481.18	1482.97	67074.0
2012-10-04 09:00:00	ES	Futures	1482.97	1484.76	1480.41	1482.46	156408.0
2012-10-04 10:00:00	ES	Futures	1482.46	1489.61	1481.43	1487.31	311241.0
2012-10-04 11:00:00	ES	Futures	1487.31	1487.82	1482.2	1484.5	250299.0
2012-10-04 12:00:00	ES	Futures	1484.5	1487.57	1483.99	1485.27	119752.0
2012-10-04 13:00:00	ES	Futures	1485.52	1488.84	1485.27	1488.08	78583.0
2012-10-04 14:00:00	ES	Futures	1488.08	1488.33	1485.01	1487.31	129978.0
2012-10-04 15:00:00	ES	Futures	1487.05	1488.59	1485.52	1488.08	177002.0
2012-10-04 16:00:00	ES	Futures	1488.08	1488.59	1487.05	1487.82	88593.0
2012-10-04 17:00:00	ES	Futures	1488.08	1488.33	1487.57	1487.57	1238.0
2012-10-04 18:00:00	ES	Futures	1487.82	1488.59	1487.57	1488.59	1976.0
2012-10-04 19:00:00	ES	Futures	1488.59	1488.59	1488.08	1488.33	1134.0
2012-10-04 20:00:00	ES	Futures	1488.59	1490.38	1488.59	1489.61	6721.0
2012-10-04 21:00:00	ES	Futures	1489.61	1490.38	1489.35	1489.61	4269.0
2012-10-04 22:00:00	ES	Futures	1489.61	1490.12	1489.35	1489.35	1498.0
2012-10-04 23:00:00	ES	Futures	1489.35	1490.12	1488.84	1488.84	2864.0
2012-10-04 00:00:00	NQ	Futures	3282.35	3284.38	3279.15	3283.8	903.0
2012-10-04 01:00:00	NQ	Futures	3283.22	3283.22	3276.83	3278.28	463.0
2012-10-04 02:00:00	NQ	Futures	3278.28	3284.38	3277.7	3283.22	1188.0
2012-10-04 03:00:00	NQ	Futures	3282.93	3285.55	3278.57	3281.77	2141.0
2012-10-04 04:00:00	NQ	Futures	3281.48	3282.06	3268.69	3271.6	2844.0
2012-10-04 05:00:00	NQ	Futures	3271.6	3275.38	3270.15	3275.38	999.0
2012-10-04 06:00:00	NQ	Futures	3275.38	3281.77	3274.8	3279.15	1869.0
2012-10-04 07:00:00	NQ	Futures	3278.86	3280.9	3275.67	3278.57	2261.0
2012-10-04 08:00:00	NQ	Futures	3278.28	3282.35	3273.05	3276.83	7885.0
2012-10-04 09:00:00	NQ	Futures	3276.83	3280.03	3263.46	3269.27	29744.0
2012-10-04 10:00:00	NQ	Futures	3269.27	3285.26	3265.79	3279.15	36205.0
2012-10-04 11:00:00	NQ	Futures	3279.15	3280.61	3266.66	3273.05	25710.0
2012-10-04 12:00:00	NQ	Futures	3273.05	3280.03	3271.02	3273.92	16214.0
2012-10-04 13:00:00	NQ	Futures	3274.21	3280.03	3273.05	3279.15	10060.0
2012-10-04 14:00:00	NQ	Futures	3279.15	3284.09	3272.47	3280.9	18933.0
2012-10-04 15:00:00	NQ	Futures	3281.19	3289.32	3277.7	3280.32	24885.0
2012-10-04 16:00:00	NQ	Futures	3280.32	3281.77	3278.86	3280.32	5516.0
2012-10-04 17:00:00	NQ	Futures	3280.61	3281.48	3279.74	3280.32	62.0
2012-10-04 18:00:00	NQ	Futures	3280.32	3282.06	3280.32	3282.06	91.0
2012-10-04 19:00:00	NQ	Futures	3282.06	3282.35	3281.48	3281.77	116.0
2012-10-04 20:00:00	NQ	Futures	3282.06	3285.26	3282.06	3284.09	441.0
2012-10-04 21:00:00	NQ	Futures	3283.51	3286.42	3283.51	3284.68	408.0
2012-10-04 22:00:00	NQ	Futures	3284.68	3285.55	3284.38	3284.68	80.0
2012-10-04 23:00:00	NQ	Futures	3284.68	3285.55	3283.22	3283.51	395.0
2012-10-04 00:00:00	YM	Futures	13488.9	13494.9	13477.9	13493.9	892.0
2012-10-04 01:00:00	YM	Futures	13493.9	13493.9	13469.9	13474.9	727.0

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

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