PREVIEW / futures_1hour / 2014-08-21

all futures 1-hour files

  file:    by_date/futures_1hour/2014/2014-08-21.parquet
  size:    48 KB
  rows:    1,547

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
2014-08-21 00:00:00	ES	Futures	2068.23	2068.23	2066.93	2067.19	1946.0
2014-08-21 01:00:00	ES	Futures	2067.45	2067.97	2067.19	2067.71	2180.0
2014-08-21 02:00:00	ES	Futures	2067.71	2068.23	2066.93	2067.19	5413.0
2014-08-21 03:00:00	ES	Futures	2067.19	2071.36	2064.84	2070.84	33865.0
2014-08-21 04:00:00	ES	Futures	2070.84	2071.62	2069.28	2070.84	19706.0
2014-08-21 05:00:00	ES	Futures	2070.58	2071.88	2068.75	2071.36	16652.0
2014-08-21 06:00:00	ES	Futures	2071.36	2072.14	2070.84	2071.36	11244.0
2014-08-21 07:00:00	ES	Futures	2071.36	2072.14	2070.32	2071.36	12191.0
2014-08-21 08:00:00	ES	Futures	2071.36	2072.14	2070.06	2071.1	17291.0
2014-08-21 09:00:00	ES	Futures	2070.84	2073.18	2068.23	2072.14	116021.0
2014-08-21 10:00:00	ES	Futures	2072.14	2074.23	2067.71	2073.18	192576.0
2014-08-21 11:00:00	ES	Futures	2073.18	2074.49	2071.88	2071.88	79595.0
2014-08-21 12:00:00	ES	Futures	2071.88	2073.71	2071.88	2072.92	54242.0
2014-08-21 13:00:00	ES	Futures	2072.66	2075.27	2072.66	2074.49	57430.0
2014-08-21 14:00:00	ES	Futures	2074.49	2075.79	2073.71	2075.53	42171.0
2014-08-21 15:00:00	ES	Futures	2075.53	2076.57	2073.18	2073.44	95039.0
2014-08-21 16:00:00	ES	Futures	2073.44	2074.75	2073.18	2074.49	55151.0
2014-08-21 17:00:00	ES	Futures	2074.23	2074.75	2074.23	2074.23	2366.0
2014-08-21 18:00:00	ES	Futures	2074.23	2074.75	2073.97	2073.97	1982.0
2014-08-21 19:00:00	ES	Futures	2073.97	2074.75	2073.97	2074.75	565.0
2014-08-21 20:00:00	ES	Futures	2074.75	2074.75	2073.71	2074.49	2537.0
2014-08-21 21:00:00	ES	Futures	2074.75	2075.53	2074.23	2074.49	2783.0
2014-08-21 22:00:00	ES	Futures	2074.49	2075.79	2073.97	2075.79	2339.0
2014-08-21 23:00:00	ES	Futures	2075.53	2076.05	2075.01	2075.01	1517.0
2014-08-21 00:00:00	NQ	Futures	4716.62	4716.62	4714.29	4715.45	264.0
2014-08-21 01:00:00	NQ	Futures	4715.45	4716.62	4715.16	4716.04	315.0
2014-08-21 02:00:00	NQ	Futures	4716.62	4718.37	4716.04	4716.91	730.0
2014-08-21 03:00:00	NQ	Futures	4716.91	4724.21	4710.49	4723.05	5161.0
2014-08-21 04:00:00	NQ	Futures	4723.05	4724.8	4720.42	4722.75	3145.0
2014-08-21 05:00:00	NQ	Futures	4722.46	4724.8	4718.67	4724.51	2337.0
2014-08-21 06:00:00	NQ	Futures	4724.21	4725.97	4723.34	4724.21	1933.0
2014-08-21 07:00:00	NQ	Futures	4724.51	4726.55	4722.17	4724.51	2296.0
2014-08-21 08:00:00	NQ	Futures	4724.21	4725.97	4722.17	4724.21	3703.0
2014-08-21 09:00:00	NQ	Futures	4724.21	4727.72	4717.79	4724.8	21343.0
2014-08-21 10:00:00	NQ	Futures	4724.51	4728.59	4712.24	4724.21	37840.0
2014-08-21 11:00:00	NQ	Futures	4724.21	4727.13	4719.25	4719.54	14599.0
2014-08-21 12:00:00	NQ	Futures	4719.54	4723.63	4718.08	4720.71	9429.0
2014-08-21 13:00:00	NQ	Futures	4721.0	4727.43	4721.0	4722.17	9660.0
2014-08-21 14:00:00	NQ	Futures	4722.17	4728.3	4721.0	4727.13	9643.0
2014-08-21 15:00:00	NQ	Futures	4727.13	4728.59	4723.92	4726.55	11729.0
2014-08-21 16:00:00	NQ	Futures	4726.26	4729.18	4725.97	4729.18	6156.0
2014-08-21 17:00:00	NQ	Futures	4729.18	4729.47	4728.01	4728.01	348.0
2014-08-21 18:00:00	NQ	Futures	4728.01	4728.89	4726.84	4728.01	124.0
2014-08-21 19:00:00	NQ	Futures	4728.01	4729.18	4727.43	4728.59	326.0
2014-08-21 20:00:00	NQ	Futures	4728.59	4728.59	4726.84	4728.59	390.0
2014-08-21 21:00:00	NQ	Futures	4728.59	4731.22	4728.59	4729.47	617.0
2014-08-21 22:00:00	NQ	Futures	4729.18	4732.97	4728.89	4732.39	631.0
2014-08-21 23:00:00	NQ	Futures	4732.68	4733.56	4731.22	4731.51	386.0
2014-08-21 00:00:00	YM	Futures	17535.9	17536.9	17529.7	17530.7	314.0
2014-08-21 01:00:00	YM	Futures	17531.8	17535.9	17530.7	17535.9	368.0

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

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