PREVIEW / futures_30min / 2019-08-29

all futures 30-min files

  file:    by_date/futures_30min/2019/2019-08-29.parquet
  size:    94 KB
  rows:    3,428

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
2019-08-29 00:00:00	ES	Futures	3118.25	3119.06	3118.25	3118.52	1287.0
2019-08-29 00:30:00	ES	Futures	3118.79	3120.96	3118.52	3119.88	2711.0
2019-08-29 01:00:00	ES	Futures	3120.15	3124.75	3119.61	3124.48	5499.0
2019-08-29 01:30:00	ES	Futures	3124.48	3124.48	3119.33	3120.15	6887.0
2019-08-29 02:00:00	ES	Futures	3120.42	3123.12	3120.15	3120.42	5788.0
2019-08-29 02:30:00	ES	Futures	3120.42	3122.31	3119.88	3121.77	4665.0
2019-08-29 03:00:00	ES	Futures	3121.77	3152.09	3118.25	3139.37	70112.0
2019-08-29 03:30:00	ES	Futures	3139.37	3150.47	3138.83	3148.57	27744.0
2019-08-29 04:00:00	ES	Futures	3148.57	3150.19	3144.78	3148.84	21953.0
2019-08-29 04:30:00	ES	Futures	3148.84	3151.82	3147.22	3149.92	18734.0
2019-08-29 05:00:00	ES	Futures	3150.19	3157.5	3149.92	3156.69	24421.0
2019-08-29 05:30:00	ES	Futures	3156.69	3159.13	3153.98	3155.88	17931.0
2019-08-29 06:00:00	ES	Futures	3155.88	3160.48	3155.61	3160.21	16673.0
2019-08-29 06:30:00	ES	Futures	3159.94	3160.75	3157.77	3159.67	15055.0
2019-08-29 07:00:00	ES	Futures	3159.67	3160.48	3156.42	3157.23	14196.0
2019-08-29 07:30:00	ES	Futures	3157.5	3160.48	3155.07	3159.67	19233.0
2019-08-29 08:00:00	ES	Futures	3159.67	3161.56	3158.05	3160.75	31427.0
2019-08-29 08:30:00	ES	Futures	3160.75	3161.02	3156.96	3156.96	14251.0
2019-08-29 09:00:00	ES	Futures	3156.96	3158.59	3154.8	3158.32	24075.0
2019-08-29 09:30:00	ES	Futures	3158.05	3167.79	3157.23	3164.54	178798.0
2019-08-29 10:00:00	ES	Futures	3164.54	3165.35	3156.42	3161.29	104408.0
2019-08-29 10:30:00	ES	Futures	3161.29	3161.84	3145.86	3158.59	151677.0
2019-08-29 11:00:00	ES	Futures	3158.59	3164.27	3156.42	3163.19	62361.0
2019-08-29 11:30:00	ES	Futures	3163.19	3168.87	3162.65	3166.98	58872.0
2019-08-29 12:00:00	ES	Futures	3166.98	3169.14	3164.81	3166.98	42962.0
2019-08-29 12:30:00	ES	Futures	3167.25	3171.04	3166.44	3168.6	45468.0
2019-08-29 13:00:00	ES	Futures	3168.87	3169.96	3167.79	3167.79	30487.0
2019-08-29 13:30:00	ES	Futures	3167.79	3172.39	3166.44	3171.04	39961.0
2019-08-29 14:00:00	ES	Futures	3171.04	3173.48	3167.25	3170.5	57402.0
2019-08-29 14:30:00	ES	Futures	3170.23	3171.58	3167.52	3168.6	34500.0
2019-08-29 15:00:00	ES	Futures	3168.33	3168.87	3163.19	3164.27	42078.0
2019-08-29 15:30:00	ES	Futures	3164.27	3169.96	3163.73	3166.98	119897.0
2019-08-29 16:00:00	ES	Futures	3166.98	3169.96	3165.63	3169.14	53621.0
2019-08-29 16:30:00	ES	Futures	3168.06	3168.33	3165.63	3166.17	7289.0
2019-08-29 18:00:00	ES	Futures	3165.35	3166.71	3163.19	3166.17	3200.0
2019-08-29 18:30:00	ES	Futures	3166.17	3166.44	3165.08	3165.63	1677.0
2019-08-29 19:00:00	ES	Futures	3165.9	3166.17	3162.38	3162.92	8538.0
2019-08-29 19:30:00	ES	Futures	3162.92	3165.9	3162.38	3165.63	6334.0
2019-08-29 20:00:00	ES	Futures	3165.9	3169.14	3164.27	3166.71	6114.0
2019-08-29 20:30:00	ES	Futures	3166.71	3168.06	3165.35	3167.25	3573.0
2019-08-29 21:00:00	ES	Futures	3167.25	3171.04	3166.71	3170.23	7528.0
2019-08-29 21:30:00	ES	Futures	3170.23	3171.31	3168.6	3170.77	7689.0
2019-08-29 22:00:00	ES	Futures	3170.77	3174.56	3170.5	3173.75	6364.0
2019-08-29 22:30:00	ES	Futures	3173.75	3177.27	3173.48	3175.64	8325.0
2019-08-29 23:00:00	ES	Futures	3175.64	3176.18	3173.75	3174.83	4019.0
2019-08-29 23:30:00	ES	Futures	3174.83	3176.45	3174.56	3176.45	2897.0
2019-08-29 00:00:00	NQ	Futures	8777.39	8780.58	8775.65	8778.55	1080.0
2019-08-29 00:30:00	NQ	Futures	8778.26	8789.28	8775.94	8785.8	2655.0
2019-08-29 01:00:00	NQ	Futures	8786.09	8806.11	8784.06	8802.63	3343.0
2019-08-29 01:30:00	NQ	Futures	8802.92	8804.95	8787.54	8789.58	2583.0

> showing 50 of 3,428 rows — these rows as CSV

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