PREVIEW / futures_1hour / 2017-03-16

all futures 1-hour files

  file:    by_date/futures_1hour/2017/2017-03-16.parquet
  size:    53 KB
  rows:    1,647

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
2017-03-16 00:00:00	ES	Futures	2605.51	2605.78	2603.87	2604.15	3425.0
2017-03-16 01:00:00	ES	Futures	2604.15	2605.51	2604.15	2605.24	3723.0
2017-03-16 02:00:00	ES	Futures	2604.96	2606.6	2604.96	2606.06	3600.0
2017-03-16 03:00:00	ES	Futures	2606.06	2609.88	2606.06	2609.33	17211.0
2017-03-16 04:00:00	ES	Futures	2609.61	2609.61	2605.78	2606.6	21018.0
2017-03-16 05:00:00	ES	Futures	2606.6	2608.52	2606.06	2607.15	14689.0
2017-03-16 06:00:00	ES	Futures	2607.15	2608.24	2606.06	2607.42	11001.0
2017-03-16 07:00:00	ES	Futures	2607.42	2607.97	2605.78	2606.33	17905.0
2017-03-16 08:00:00	ES	Futures	2606.06	2606.6	2603.33	2605.51	47966.0
2017-03-16 09:00:00	ES	Futures	2605.24	2606.33	2601.96	2603.05	163958.0
2017-03-16 10:00:00	ES	Futures	2603.05	2605.24	2597.86	2599.77	217961.0
2017-03-16 11:00:00	ES	Futures	2599.77	2600.32	2593.49	2597.32	222557.0
2017-03-16 12:00:00	ES	Futures	2597.32	2600.32	2595.4	2599.77	114019.0
2017-03-16 13:00:00	ES	Futures	2599.77	2600.05	2596.22	2598.41	88163.0
2017-03-16 14:00:00	ES	Futures	2598.41	2599.77	2594.31	2594.86	85759.0
2017-03-16 15:00:00	ES	Futures	2595.13	2598.41	2593.22	2597.86	230612.0
2017-03-16 16:00:00	ES	Futures	2597.59	2601.14	2597.04	2599.77	80350.0
2017-03-16 18:00:00	ES	Futures	2599.5	2600.05	2598.14	2599.23	5238.0
2017-03-16 19:00:00	ES	Futures	2599.23	2599.5	2597.59	2598.68	3182.0
2017-03-16 20:00:00	ES	Futures	2598.68	2600.32	2598.68	2600.05	3900.0
2017-03-16 21:00:00	ES	Futures	2600.05	2600.32	2598.96	2598.96	3807.0
2017-03-16 22:00:00	ES	Futures	2598.96	2599.23	2598.14	2599.23	2316.0
2017-03-16 23:00:00	ES	Futures	2598.96	2599.23	2598.68	2598.96	1419.0
2017-03-16 00:00:00	NQ	Futures	6476.8	6476.8	6472.92	6473.52	657.0
2017-03-16 01:00:00	NQ	Futures	6473.82	6476.8	6473.52	6476.2	702.0
2017-03-16 02:00:00	NQ	Futures	6475.9	6479.18	6475.31	6478.29	1182.0
2017-03-16 03:00:00	NQ	Futures	6477.99	6487.53	6477.69	6485.74	4179.0
2017-03-16 04:00:00	NQ	Futures	6485.74	6486.04	6478.59	6480.67	3800.0
2017-03-16 05:00:00	NQ	Futures	6480.38	6484.55	6479.78	6482.76	2481.0
2017-03-16 06:00:00	NQ	Futures	6482.46	6483.36	6479.48	6480.67	2517.0
2017-03-16 07:00:00	NQ	Futures	6480.67	6482.46	6478.29	6478.88	2250.0
2017-03-16 08:00:00	NQ	Futures	6478.59	6478.59	6470.83	6475.9	6528.0
2017-03-16 09:00:00	NQ	Futures	6475.61	6479.18	6462.19	6465.77	27802.0
2017-03-16 10:00:00	NQ	Futures	6465.77	6469.34	6453.54	6457.72	26244.0
2017-03-16 11:00:00	NQ	Futures	6458.01	6458.61	6442.51	6453.24	25735.0
2017-03-16 12:00:00	NQ	Futures	6453.24	6460.4	6450.86	6457.12	13480.0
2017-03-16 13:00:00	NQ	Futures	6457.42	6457.72	6448.77	6452.35	11398.0
2017-03-16 14:00:00	NQ	Futures	6452.05	6457.12	6445.79	6447.58	11367.0
2017-03-16 15:00:00	NQ	Futures	6447.28	6457.72	6443.7	6456.52	20707.0
2017-03-16 16:00:00	NQ	Futures	6456.52	6461.89	6455.33	6458.91	5746.0
2017-03-16 18:00:00	NQ	Futures	6458.61	6458.61	6455.63	6458.01	578.0
2017-03-16 19:00:00	NQ	Futures	6457.72	6458.01	6455.03	6456.52	326.0
2017-03-16 20:00:00	NQ	Futures	6456.52	6461.0	6456.52	6460.7	790.0
2017-03-16 21:00:00	NQ	Futures	6461.0	6461.0	6458.01	6458.61	716.0
2017-03-16 22:00:00	NQ	Futures	6458.61	6460.1	6456.82	6459.8	640.0
2017-03-16 23:00:00	NQ	Futures	6459.8	6460.7	6458.91	6460.4	306.0
2017-03-16 00:00:00	YM	Futures	22750.9	22752.0	22737.8	22738.9	484.0
2017-03-16 01:00:00	YM	Futures	22741.1	22747.6	22738.9	22745.5	594.0
2017-03-16 02:00:00	YM	Futures	22744.4	22756.3	22743.3	22753.1	796.0
2017-03-16 03:00:00	YM	Futures	22753.1	22802.0	22753.1	22798.7	4776.0

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

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