PREVIEW / futures_30min / 2012-07-04

all futures 30-min files

  file:    by_date/futures_30min/2012/2012-07-04.parquet
  size:    48 KB
  rows:    1,788

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-07-04 00:00:00	ES	Futures	1391.95	1392.46	1391.69	1392.2	457.0
2012-07-04 00:30:00	ES	Futures	1392.2	1392.71	1391.95	1392.46	478.0
2012-07-04 01:00:00	ES	Futures	1392.2	1393.47	1391.95	1392.96	1153.0
2012-07-04 01:30:00	ES	Futures	1392.96	1393.22	1391.44	1392.2	1590.0
2012-07-04 02:00:00	ES	Futures	1392.2	1392.2	1390.93	1391.18	2303.0
2012-07-04 02:30:00	ES	Futures	1391.44	1391.69	1390.68	1390.68	1697.0
2012-07-04 03:00:00	ES	Futures	1390.68	1391.44	1388.64	1389.66	11423.0
2012-07-04 03:30:00	ES	Futures	1389.66	1389.91	1387.62	1388.13	8467.0
2012-07-04 04:00:00	ES	Futures	1388.39	1388.9	1387.12	1387.62	4010.0
2012-07-04 04:30:00	ES	Futures	1387.37	1390.42	1387.37	1389.4	6970.0
2012-07-04 05:00:00	ES	Futures	1389.66	1390.42	1388.64	1389.91	4040.0
2012-07-04 05:30:00	ES	Futures	1389.91	1390.42	1389.15	1389.91	3417.0
2012-07-04 06:00:00	ES	Futures	1390.17	1390.42	1388.64	1388.9	4709.0
2012-07-04 06:30:00	ES	Futures	1388.9	1390.42	1388.64	1389.66	5369.0
2012-07-04 07:00:00	ES	Futures	1389.66	1389.66	1388.13	1389.4	6767.0
2012-07-04 07:30:00	ES	Futures	1389.15	1390.17	1389.15	1389.66	2972.0
2012-07-04 08:00:00	ES	Futures	1389.66	1389.66	1388.39	1389.15	3132.0
2012-07-04 08:30:00	ES	Futures	1389.15	1389.91	1388.64	1388.9	2594.0
2012-07-04 09:00:00	ES	Futures	1389.15	1389.4	1388.13	1388.64	3243.0
2012-07-04 09:30:00	ES	Futures	1388.64	1390.42	1388.39	1390.42	6015.0
2012-07-04 10:00:00	ES	Futures	1390.42	1390.93	1389.91	1390.42	3736.0
2012-07-04 10:30:00	ES	Futures	1390.42	1390.68	1389.4	1389.91	4313.0
2012-07-04 11:00:00	ES	Futures	1389.91	1391.95	1389.66	1391.44	6747.0
2012-07-04 18:00:00	ES	Futures	1389.4	1389.91	1387.88	1388.39	3506.0
2012-07-04 18:30:00	ES	Futures	1388.39	1388.39	1387.12	1387.88	1954.0
2012-07-04 19:00:00	ES	Futures	1387.62	1388.39	1387.62	1387.88	568.0
2012-07-04 19:30:00	ES	Futures	1388.13	1389.15	1387.62	1388.64	1028.0
2012-07-04 20:00:00	ES	Futures	1388.39	1388.9	1387.88	1388.39	920.0
2012-07-04 20:30:00	ES	Futures	1388.39	1388.64	1387.88	1388.39	1157.0
2012-07-04 21:00:00	ES	Futures	1388.64	1388.9	1387.37	1387.88	1430.0
2012-07-04 21:30:00	ES	Futures	1387.88	1388.39	1386.35	1386.61	2597.0
2012-07-04 22:00:00	ES	Futures	1386.61	1387.12	1385.59	1385.84	3370.0
2012-07-04 22:30:00	ES	Futures	1385.84	1386.1	1385.34	1385.84	2637.0
2012-07-04 23:00:00	ES	Futures	1385.59	1386.35	1385.59	1385.84	1185.0
2012-07-04 23:30:00	ES	Futures	1386.1	1386.35	1385.34	1385.59	1745.0
2012-07-04 00:00:00	NQ	Futures	3063.79	3064.08	3063.21	3063.79	114.0
2012-07-04 00:30:00	NQ	Futures	3064.37	3064.37	3062.92	3063.5	169.0
2012-07-04 01:00:00	NQ	Futures	3063.5	3065.24	3063.21	3064.95	115.0
2012-07-04 01:30:00	NQ	Futures	3065.24	3065.53	3062.92	3063.5	94.0
2012-07-04 02:00:00	NQ	Futures	3063.5	3063.79	3060.9	3061.48	219.0
2012-07-04 02:30:00	NQ	Futures	3061.76	3062.92	3061.19	3061.76	275.0
2012-07-04 03:00:00	NQ	Futures	3062.05	3063.21	3058.58	3059.16	1484.0
2012-07-04 03:30:00	NQ	Futures	3059.16	3060.03	3054.81	3055.97	1032.0
2012-07-04 04:00:00	NQ	Futures	3055.97	3057.13	3053.07	3053.36	844.0
2012-07-04 04:30:00	NQ	Futures	3053.36	3058.29	3052.78	3056.26	853.0
2012-07-04 05:00:00	NQ	Futures	3056.55	3059.74	3054.52	3058.87	783.0
2012-07-04 05:30:00	NQ	Futures	3058.58	3059.74	3057.42	3058.87	446.0
2012-07-04 06:00:00	NQ	Futures	3059.16	3059.45	3054.81	3055.1	731.0
2012-07-04 06:30:00	NQ	Futures	3054.81	3058.29	3054.52	3055.97	714.0
2012-07-04 07:00:00	NQ	Futures	3055.68	3056.26	3052.78	3053.65	803.0

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

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