PREVIEW / futures_30min / 2019-04-26

all futures 30-min files

  file:    by_date/futures_30min/2019/2019-04-26.parquet
  size:    74 KB
  rows:    2,701

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-04-26 00:00:00	ES	Futures	3169.19	3170.0	3169.19	3169.73	975.0
2019-04-26 00:30:00	ES	Futures	3169.46	3170.81	3169.46	3170.81	1075.0
2019-04-26 01:00:00	ES	Futures	3170.81	3172.98	3169.73	3172.71	4172.0
2019-04-26 01:30:00	ES	Futures	3172.44	3172.98	3171.08	3171.35	3384.0
2019-04-26 02:00:00	ES	Futures	3171.35	3172.44	3169.19	3169.46	4750.0
2019-04-26 02:30:00	ES	Futures	3169.73	3171.08	3169.46	3170.81	2739.0
2019-04-26 03:00:00	ES	Futures	3170.81	3171.35	3166.75	3167.02	8440.0
2019-04-26 03:30:00	ES	Futures	3167.02	3170.54	3166.75	3169.73	6639.0
2019-04-26 04:00:00	ES	Futures	3169.73	3170.81	3168.64	3170.81	5948.0
2019-04-26 04:30:00	ES	Futures	3170.81	3171.08	3168.91	3169.19	5066.0
2019-04-26 05:00:00	ES	Futures	3169.19	3169.46	3168.1	3168.37	3700.0
2019-04-26 05:30:00	ES	Futures	3168.37	3171.35	3168.1	3171.35	5138.0
2019-04-26 06:00:00	ES	Futures	3171.08	3172.98	3170.54	3172.71	6901.0
2019-04-26 06:30:00	ES	Futures	3172.71	3173.52	3171.08	3172.17	4653.0
2019-04-26 07:00:00	ES	Futures	3171.9	3173.52	3170.54	3171.08	4794.0
2019-04-26 07:30:00	ES	Futures	3171.35	3171.63	3168.64	3169.19	5907.0
2019-04-26 08:00:00	ES	Futures	3168.91	3172.71	3166.75	3171.35	13849.0
2019-04-26 08:30:00	ES	Futures	3171.35	3179.49	3171.35	3175.69	48242.0
2019-04-26 09:00:00	ES	Futures	3175.69	3180.3	3175.15	3175.15	31280.0
2019-04-26 09:30:00	ES	Futures	3175.15	3176.78	3166.47	3168.64	188893.0
2019-04-26 10:00:00	ES	Futures	3168.64	3175.96	3165.66	3175.69	128712.0
2019-04-26 10:30:00	ES	Futures	3175.69	3177.05	3173.25	3174.61	80269.0
2019-04-26 11:00:00	ES	Futures	3174.88	3181.11	3172.44	3180.84	81638.0
2019-04-26 11:30:00	ES	Futures	3180.84	3182.47	3178.67	3179.49	56570.0
2019-04-26 12:00:00	ES	Futures	3179.49	3181.39	3178.4	3179.76	33145.0
2019-04-26 12:30:00	ES	Futures	3179.49	3181.93	3178.67	3179.49	22535.0
2019-04-26 13:00:00	ES	Futures	3179.76	3179.76	3177.05	3179.22	28765.0
2019-04-26 13:30:00	ES	Futures	3179.22	3179.76	3177.05	3179.22	23466.0
2019-04-26 14:00:00	ES	Futures	3179.22	3181.66	3175.69	3181.11	40067.0
2019-04-26 14:30:00	ES	Futures	3181.11	3181.93	3180.03	3181.11	30259.0
2019-04-26 15:00:00	ES	Futures	3181.39	3186.27	3181.39	3183.83	59036.0
2019-04-26 15:30:00	ES	Futures	3183.55	3190.6	3183.01	3190.06	137256.0
2019-04-26 16:00:00	ES	Futures	3189.79	3191.14	3188.98	3190.33	63511.0
2019-04-26 16:30:00	ES	Futures	3189.25	3190.87	3187.08	3187.08	7963.0
2019-04-26 00:00:00	NQ	Futures	9077.66	9080.57	9077.08	9078.25	505.0
2019-04-26 00:30:00	NQ	Futures	9077.95	9081.74	9077.95	9081.16	602.0
2019-04-26 01:00:00	NQ	Futures	9081.16	9091.93	9077.66	9091.06	2719.0
2019-04-26 01:30:00	NQ	Futures	9091.06	9094.84	9088.14	9088.73	1600.0
2019-04-26 02:00:00	NQ	Futures	9088.73	9093.09	9082.03	9082.61	2484.0
2019-04-26 02:30:00	NQ	Futures	9082.9	9089.6	9082.9	9088.14	1286.0
2019-04-26 03:00:00	NQ	Futures	9088.14	9089.89	9078.83	9080.87	4249.0
2019-04-26 03:30:00	NQ	Futures	9080.87	9096.88	9080.87	9093.97	4097.0
2019-04-26 04:00:00	NQ	Futures	9093.97	9096.3	9084.36	9095.13	3919.0
2019-04-26 04:30:00	NQ	Futures	9095.13	9095.42	9087.27	9087.85	2228.0
2019-04-26 05:00:00	NQ	Futures	9088.14	9089.6	9082.32	9085.52	2174.0
2019-04-26 05:30:00	NQ	Futures	9085.23	9093.97	9085.23	9092.22	2125.0
2019-04-26 06:00:00	NQ	Futures	9092.22	9098.63	9090.77	9097.75	1821.0
2019-04-26 06:30:00	NQ	Futures	9097.75	9100.37	9092.22	9094.84	1802.0
2019-04-26 07:00:00	NQ	Futures	9094.84	9100.08	9087.56	9091.64	2329.0
2019-04-26 07:30:00	NQ	Futures	9091.35	9092.8	9081.16	9083.78	1905.0

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

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