PREVIEW / futures_1hour / 2017-07-10

all futures 1-hour files

  file:    by_date/futures_1hour/2017/2017-07-10.parquet
  size:    50 KB
  rows:    1,596

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-07-10 00:00:00	ES	Futures	2655.49	2655.76	2654.12	2654.4	3335.0
2017-07-10 01:00:00	ES	Futures	2654.12	2654.94	2652.76	2653.58	4671.0
2017-07-10 02:00:00	ES	Futures	2653.58	2654.4	2652.48	2653.03	7923.0
2017-07-10 03:00:00	ES	Futures	2653.03	2654.12	2651.66	2652.76	16718.0
2017-07-10 04:00:00	ES	Futures	2652.76	2654.12	2651.66	2652.76	10063.0
2017-07-10 05:00:00	ES	Futures	2652.76	2652.76	2650.3	2651.94	9246.0
2017-07-10 06:00:00	ES	Futures	2651.66	2653.3	2651.66	2651.94	9114.0
2017-07-10 07:00:00	ES	Futures	2651.94	2651.94	2648.93	2649.48	15505.0
2017-07-10 08:00:00	ES	Futures	2649.75	2650.84	2648.11	2648.66	13761.0
2017-07-10 09:00:00	ES	Futures	2648.38	2650.3	2645.1	2646.2	132197.0
2017-07-10 10:00:00	ES	Futures	2645.92	2653.03	2645.65	2653.03	118939.0
2017-07-10 11:00:00	ES	Futures	2653.03	2654.12	2651.66	2653.85	90584.0
2017-07-10 12:00:00	ES	Futures	2653.85	2655.49	2653.3	2654.94	77583.0
2017-07-10 13:00:00	ES	Futures	2655.22	2656.04	2653.85	2655.49	48566.0
2017-07-10 14:00:00	ES	Futures	2655.49	2656.04	2653.85	2654.12	42980.0
2017-07-10 15:00:00	ES	Futures	2654.12	2656.86	2651.66	2651.94	165686.0
2017-07-10 16:00:00	ES	Futures	2651.66	2652.48	2650.02	2650.02	54923.0
2017-07-10 18:00:00	ES	Futures	2650.02	2650.3	2648.66	2650.3	3730.0
2017-07-10 19:00:00	ES	Futures	2650.02	2650.84	2649.75	2650.84	1943.0
2017-07-10 20:00:00	ES	Futures	2650.57	2651.39	2650.3	2651.39	3498.0
2017-07-10 21:00:00	ES	Futures	2651.39	2652.21	2650.57	2651.39	4897.0
2017-07-10 22:00:00	ES	Futures	2651.66	2652.48	2651.39	2652.21	2320.0
2017-07-10 23:00:00	ES	Futures	2652.21	2653.3	2651.94	2652.48	2449.0
2017-07-10 00:00:00	NQ	Futures	6765.8	6767.59	6761.34	6762.23	808.0
2017-07-10 01:00:00	NQ	Futures	6761.93	6764.61	6758.36	6762.23	802.0
2017-07-10 02:00:00	NQ	Futures	6762.53	6764.91	6758.95	6761.93	1177.0
2017-07-10 03:00:00	NQ	Futures	6762.23	6766.69	6759.25	6763.72	2266.0
2017-07-10 04:00:00	NQ	Futures	6763.42	6765.8	6759.25	6761.04	1391.0
2017-07-10 05:00:00	NQ	Futures	6761.63	6762.23	6753.3	6756.87	1742.0
2017-07-10 06:00:00	NQ	Futures	6756.57	6763.42	6755.98	6760.14	2546.0
2017-07-10 07:00:00	NQ	Futures	6759.85	6760.74	6744.36	6750.62	4565.0
2017-07-10 08:00:00	NQ	Futures	6750.32	6758.36	6739.3	6741.98	6869.0
2017-07-10 09:00:00	NQ	Futures	6741.98	6766.1	6729.18	6734.24	47528.0
2017-07-10 10:00:00	NQ	Futures	6734.24	6771.46	6732.75	6770.27	42835.0
2017-07-10 11:00:00	NQ	Futures	6770.27	6774.14	6765.21	6773.54	22743.0
2017-07-10 12:00:00	NQ	Futures	6773.25	6782.18	6772.95	6780.39	19842.0
2017-07-10 13:00:00	NQ	Futures	6780.39	6792.9	6778.9	6792.0	18624.0
2017-07-10 14:00:00	NQ	Futures	6792.0	6794.68	6785.75	6787.84	15343.0
2017-07-10 15:00:00	NQ	Futures	6788.13	6802.42	6783.37	6785.45	34892.0
2017-07-10 16:00:00	NQ	Futures	6785.75	6787.24	6779.8	6781.28	5922.0
2017-07-10 18:00:00	NQ	Futures	6779.2	6781.58	6774.44	6781.58	866.0
2017-07-10 19:00:00	NQ	Futures	6781.28	6786.64	6779.5	6786.35	632.0
2017-07-10 20:00:00	NQ	Futures	6786.05	6787.84	6783.07	6786.05	777.0
2017-07-10 21:00:00	NQ	Futures	6785.75	6790.51	6784.56	6789.32	1056.0
2017-07-10 22:00:00	NQ	Futures	6789.32	6793.79	6789.03	6789.32	989.0
2017-07-10 23:00:00	NQ	Futures	6789.92	6790.22	6786.94	6787.54	1022.0
2017-07-10 00:00:00	YM	Futures	23289.2	23290.2	23279.4	23281.5	441.0
2017-07-10 01:00:00	YM	Futures	23281.5	23287.0	23275.0	23281.5	626.0
2017-07-10 02:00:00	YM	Futures	23280.5	23284.8	23272.8	23278.3	1100.0
2017-07-10 03:00:00	YM	Futures	23278.3	23283.7	23264.1	23273.9	1928.0

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

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