PREVIEW / futures_30min / 2018-04-29

all futures 30-min files

  file:    by_date/futures_30min/2018/2018-04-29.parquet
  size:    19 KB
  rows:    516

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
2018-04-29 18:30:00	ES	Futures	2915.2	2924.76	2914.93	2920.39	6120.0
2018-04-29 19:00:00	ES	Futures	2920.39	2920.66	2918.21	2918.48	1295.0
2018-04-29 19:30:00	ES	Futures	2918.21	2918.75	2914.66	2917.93	4722.0
2018-04-29 20:00:00	ES	Futures	2918.21	2919.84	2917.66	2918.75	2126.0
2018-04-29 20:30:00	ES	Futures	2919.02	2919.57	2917.39	2919.02	1618.0
2018-04-29 21:00:00	ES	Futures	2918.75	2920.39	2917.66	2920.12	1897.0
2018-04-29 21:30:00	ES	Futures	2919.84	2923.12	2919.3	2922.85	3377.0
2018-04-29 22:00:00	ES	Futures	2922.57	2923.39	2921.75	2923.12	1979.0
2018-04-29 22:30:00	ES	Futures	2923.12	2923.94	2922.3	2922.3	1641.0
2018-04-29 23:00:00	ES	Futures	2922.3	2923.12	2921.75	2922.57	1014.0
2018-04-29 23:30:00	ES	Futures	2922.57	2923.12	2922.03	2922.57	806.0
2018-04-29 18:30:00	NQ	Futures	7882.43	7911.99	7880.36	7900.46	2012.0
2018-04-29 19:00:00	NQ	Futures	7900.17	7902.53	7892.48	7894.85	554.0
2018-04-29 19:30:00	NQ	Futures	7894.25	7896.03	7883.32	7892.19	769.0
2018-04-29 20:00:00	NQ	Futures	7892.48	7901.64	7891.3	7899.28	636.0
2018-04-29 20:30:00	NQ	Futures	7899.28	7902.82	7892.48	7899.57	826.0
2018-04-29 21:00:00	NQ	Futures	7899.28	7906.08	7896.03	7903.71	843.0
2018-04-29 21:30:00	NQ	Futures	7903.42	7919.67	7903.12	7918.78	1794.0
2018-04-29 22:00:00	NQ	Futures	7918.78	7919.97	7914.35	7918.49	1303.0
2018-04-29 22:30:00	NQ	Futures	7918.78	7923.81	7914.94	7916.42	894.0
2018-04-29 23:00:00	NQ	Futures	7916.71	7916.71	7912.87	7916.12	613.0
2018-04-29 23:30:00	NQ	Futures	7916.42	7917.6	7914.94	7916.42	308.0
2018-04-29 18:30:00	YM	Futures	26367.6	26463.1	26361.0	26416.4	1791.0
2018-04-29 19:00:00	YM	Futures	26413.2	26416.4	26392.5	26398.0	328.0
2018-04-29 19:30:00	YM	Futures	26398.0	26400.1	26374.1	26396.9	606.0
2018-04-29 20:00:00	YM	Futures	26395.8	26407.7	26391.5	26398.0	457.0
2018-04-29 20:30:00	YM	Futures	26399.1	26406.7	26384.9	26400.1	504.0
2018-04-29 21:00:00	YM	Futures	26399.1	26413.2	26387.1	26405.6	637.0
2018-04-29 21:30:00	YM	Futures	26404.5	26438.1	26400.1	26437.1	870.0
2018-04-29 22:00:00	YM	Futures	26437.1	26439.2	26427.3	26434.9	630.0
2018-04-29 22:30:00	YM	Futures	26437.1	26442.5	26427.3	26431.6	528.0
2018-04-29 23:00:00	YM	Futures	26431.6	26438.1	26420.8	26427.3	675.0
2018-04-29 23:30:00	YM	Futures	26428.4	26434.9	26419.7	26430.5	744.0
2018-04-29 18:30:00	CL	Futures	60.91	60.96	60.79	60.8	2791.0
2018-04-29 19:00:00	CL	Futures	60.8	60.86	60.75	60.76	1049.0
2018-04-29 19:30:00	CL	Futures	60.76	60.8	60.73	60.78	887.0
2018-04-29 20:00:00	CL	Futures	60.78	60.82	60.75	60.76	1522.0
2018-04-29 20:30:00	CL	Futures	60.76	60.81	60.75	60.8	1304.0
2018-04-29 21:00:00	CL	Futures	60.8	60.85	60.71	60.73	4723.0
2018-04-29 21:30:00	CL	Futures	60.72	60.74	60.67	60.74	2996.0
2018-04-29 22:00:00	CL	Futures	60.74	60.74	60.69	60.71	1116.0
2018-04-29 22:30:00	CL	Futures	60.71	60.73	60.66	60.67	882.0
2018-04-29 23:00:00	CL	Futures	60.67	60.71	60.62	60.67	2485.0
2018-04-29 23:30:00	CL	Futures	60.68	60.69	60.64	60.64	1354.0
2018-04-29 18:30:00	GC	Futures	1744.4	1745.5	1743.7	1744.4	1328.0
2018-04-29 19:00:00	GC	Futures	1744.3	1745.0	1744.2	1744.7	476.0
2018-04-29 19:30:00	GC	Futures	1744.6	1745.4	1744.6	1745.0	630.0
2018-04-29 20:00:00	GC	Futures	1744.8	1746.9	1744.6	1746.4	1963.0
2018-04-29 20:30:00	GC	Futures	1746.5	1746.9	1746.0	1746.2	910.0
2018-04-29 21:00:00	GC	Futures	1746.3	1746.5	1745.0	1746.2	1488.0

> showing 50 of 516 rows — these rows as CSV

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