PREVIEW / futures_30min / 2018-09-13

all futures 30-min files

  file:    by_date/futures_30min/2018/2018-09-13.parquet
  size:    76 KB
  rows:    2,940

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-09-13 00:00:00	ES	Futures	3146.71	3146.99	3145.62	3145.9	1029.0
2018-09-13 00:30:00	ES	Futures	3145.9	3146.17	3145.08	3145.08	912.0
2018-09-13 01:00:00	ES	Futures	3145.08	3145.62	3144.26	3145.62	2522.0
2018-09-13 01:30:00	ES	Futures	3145.62	3145.62	3144.26	3144.26	1438.0
2018-09-13 02:00:00	ES	Futures	3144.53	3146.44	3143.99	3146.44	3443.0
2018-09-13 02:30:00	ES	Futures	3146.44	3147.53	3146.17	3147.26	3009.0
2018-09-13 03:00:00	ES	Futures	3147.26	3150.8	3146.99	3150.53	9908.0
2018-09-13 03:30:00	ES	Futures	3150.53	3151.89	3149.71	3151.62	7272.0
2018-09-13 04:00:00	ES	Futures	3151.62	3151.89	3150.53	3150.8	6695.0
2018-09-13 04:30:00	ES	Futures	3151.07	3151.62	3150.26	3151.07	3202.0
2018-09-13 05:00:00	ES	Futures	3151.35	3152.71	3150.53	3151.35	4965.0
2018-09-13 05:30:00	ES	Futures	3151.07	3151.35	3148.62	3150.26	5448.0
2018-09-13 06:00:00	ES	Futures	3149.98	3151.62	3149.71	3150.8	2832.0
2018-09-13 06:30:00	ES	Futures	3150.8	3154.89	3150.53	3152.71	11735.0
2018-09-13 07:00:00	ES	Futures	3152.71	3155.98	3152.71	3154.89	12900.0
2018-09-13 07:30:00	ES	Futures	3155.16	3156.79	3154.61	3156.25	7304.0
2018-09-13 08:00:00	ES	Futures	3156.25	3157.34	3154.89	3155.16	16030.0
2018-09-13 08:30:00	ES	Futures	3155.16	3160.88	3155.16	3158.16	40410.0
2018-09-13 09:00:00	ES	Futures	3158.16	3160.88	3157.88	3160.34	17398.0
2018-09-13 09:30:00	ES	Futures	3160.34	3167.15	3159.25	3164.42	172094.0
2018-09-13 10:00:00	ES	Futures	3164.7	3168.24	3159.79	3162.24	192987.0
2018-09-13 10:30:00	ES	Futures	3162.24	3163.88	3156.79	3159.79	110609.0
2018-09-13 11:00:00	ES	Futures	3159.79	3163.06	3157.61	3159.25	72539.0
2018-09-13 11:30:00	ES	Futures	3159.25	3165.79	3157.34	3165.79	54114.0
2018-09-13 12:00:00	ES	Futures	3165.79	3167.97	3163.88	3165.24	53621.0
2018-09-13 12:30:00	ES	Futures	3165.51	3166.6	3163.88	3165.24	24501.0
2018-09-13 13:00:00	ES	Futures	3165.24	3165.79	3162.79	3164.15	33051.0
2018-09-13 13:30:00	ES	Futures	3164.15	3165.24	3162.79	3163.61	30441.0
2018-09-13 14:00:00	ES	Futures	3163.33	3166.06	3161.15	3163.61	45527.0
2018-09-13 14:30:00	ES	Futures	3163.61	3166.88	3163.33	3166.6	25027.0
2018-09-13 15:00:00	ES	Futures	3166.88	3167.15	3163.33	3164.15	37524.0
2018-09-13 15:30:00	ES	Futures	3163.88	3166.6	3161.43	3166.33	79394.0
2018-09-13 16:00:00	ES	Futures	3166.33	3167.69	3165.24	3166.33	41335.0
2018-09-13 16:30:00	ES	Futures	3166.33	3167.15	3165.24	3166.06	5906.0
2018-09-13 18:00:00	ES	Futures	3165.79	3166.6	3164.42	3166.06	1783.0
2018-09-13 18:30:00	ES	Futures	3165.79	3166.33	3165.51	3166.06	537.0
2018-09-13 19:00:00	ES	Futures	3166.06	3166.33	3165.24	3165.51	620.0
2018-09-13 19:30:00	ES	Futures	3165.51	3167.15	3165.24	3166.06	991.0
2018-09-13 20:00:00	ES	Futures	3166.33	3168.51	3165.79	3166.33	4526.0
2018-09-13 20:30:00	ES	Futures	3166.06	3167.69	3165.51	3167.42	1872.0
2018-09-13 21:00:00	ES	Futures	3167.15	3167.97	3166.33	3166.6	2170.0
2018-09-13 21:30:00	ES	Futures	3166.33	3166.33	3163.33	3164.7	3608.0
2018-09-13 22:00:00	ES	Futures	3164.97	3167.97	3164.42	3167.42	2353.0
2018-09-13 22:30:00	ES	Futures	3167.42	3167.97	3166.88	3167.15	1115.0
2018-09-13 23:00:00	ES	Futures	3167.15	3167.69	3166.88	3167.15	1195.0
2018-09-13 23:30:00	ES	Futures	3166.88	3167.42	3166.6	3166.6	1038.0
2018-09-13 00:00:00	NQ	Futures	8809.58	8811.05	8802.81	8803.69	987.0
2018-09-13 00:30:00	NQ	Futures	8803.99	8806.05	8799.57	8800.16	1208.0
2018-09-13 01:00:00	NQ	Futures	8800.16	8805.16	8797.21	8804.28	1915.0
2018-09-13 01:30:00	NQ	Futures	8804.28	8804.87	8797.51	8799.86	783.0

> showing 50 of 2,940 rows — these rows as CSV

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