PREVIEW / futures_1hour / 2017-07-19

all futures 1-hour files

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

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-19 00:00:00	ES	Futures	2689.66	2689.93	2689.11	2689.66	2041.0
2017-07-19 01:00:00	ES	Futures	2689.66	2690.2	2689.38	2689.38	2546.0
2017-07-19 02:00:00	ES	Futures	2689.66	2689.93	2688.84	2689.11	5080.0
2017-07-19 03:00:00	ES	Futures	2689.38	2689.66	2688.02	2689.11	18278.0
2017-07-19 04:00:00	ES	Futures	2689.38	2689.66	2687.74	2689.38	11849.0
2017-07-19 05:00:00	ES	Futures	2689.11	2689.66	2688.56	2689.11	12509.0
2017-07-19 06:00:00	ES	Futures	2689.38	2689.38	2688.02	2688.29	5348.0
2017-07-19 07:00:00	ES	Futures	2688.29	2689.11	2687.74	2688.56	10750.0
2017-07-19 08:00:00	ES	Futures	2688.56	2691.02	2688.29	2690.2	19927.0
2017-07-19 09:00:00	ES	Futures	2690.2	2695.12	2689.38	2694.85	137922.0
2017-07-19 10:00:00	ES	Futures	2694.85	2696.49	2692.12	2694.58	153935.0
2017-07-19 11:00:00	ES	Futures	2694.58	2697.31	2694.03	2696.49	91855.0
2017-07-19 12:00:00	ES	Futures	2696.49	2697.86	2696.49	2697.04	68406.0
2017-07-19 13:00:00	ES	Futures	2697.04	2699.5	2696.76	2698.68	59200.0
2017-07-19 14:00:00	ES	Futures	2698.95	2700.04	2698.4	2699.22	76482.0
2017-07-19 15:00:00	ES	Futures	2699.5	2701.69	2699.22	2701.41	161403.0
2017-07-19 16:00:00	ES	Futures	2701.69	2702.78	2700.87	2701.96	82778.0
2017-07-19 18:00:00	ES	Futures	2701.69	2701.96	2700.32	2700.59	4336.0
2017-07-19 19:00:00	ES	Futures	2700.59	2701.41	2699.77	2701.41	2752.0
2017-07-19 20:00:00	ES	Futures	2701.14	2701.41	2700.59	2701.14	2094.0
2017-07-19 21:00:00	ES	Futures	2701.14	2701.41	2700.32	2701.14	4189.0
2017-07-19 22:00:00	ES	Futures	2701.14	2701.14	2700.04	2700.59	1547.0
2017-07-19 23:00:00	ES	Futures	2700.32	2701.69	2700.32	2700.87	2437.0
2017-07-19 00:00:00	NQ	Futures	7029.01	7031.4	7025.74	7029.01	841.0
2017-07-19 01:00:00	NQ	Futures	7029.31	7031.4	7026.33	7026.93	641.0
2017-07-19 02:00:00	NQ	Futures	7027.23	7029.61	7023.95	7026.33	1185.0
2017-07-19 03:00:00	NQ	Futures	7026.33	7027.82	7023.36	7024.85	2123.0
2017-07-19 04:00:00	NQ	Futures	7024.85	7026.33	7020.97	7025.44	2026.0
2017-07-19 05:00:00	NQ	Futures	7025.44	7028.72	7022.46	7026.93	1479.0
2017-07-19 06:00:00	NQ	Futures	7026.93	7027.52	7021.27	7023.36	2314.0
2017-07-19 07:00:00	NQ	Futures	7023.36	7024.25	7018.0	7019.78	2688.0
2017-07-19 08:00:00	NQ	Futures	7019.78	7029.91	7017.7	7028.12	4146.0
2017-07-19 09:00:00	NQ	Futures	7027.82	7042.71	7022.46	7036.76	47246.0
2017-07-19 10:00:00	NQ	Futures	7036.46	7041.22	7022.76	7032.59	42268.0
2017-07-19 11:00:00	NQ	Futures	7032.88	7047.77	7031.99	7046.88	27687.0
2017-07-19 12:00:00	NQ	Futures	7047.18	7054.92	7045.39	7048.37	19167.0
2017-07-19 13:00:00	NQ	Futures	7048.07	7056.7	7047.77	7048.96	17055.0
2017-07-19 14:00:00	NQ	Futures	7048.96	7055.51	7047.77	7049.86	14651.0
2017-07-19 15:00:00	NQ	Futures	7049.86	7053.13	7041.82	7045.99	29812.0
2017-07-19 16:00:00	NQ	Futures	7045.99	7050.75	7044.2	7050.15	7211.0
2017-07-19 18:00:00	NQ	Futures	7050.15	7050.75	7045.99	7048.37	811.0
2017-07-19 19:00:00	NQ	Futures	7048.67	7052.24	7046.88	7052.24	462.0
2017-07-19 20:00:00	NQ	Futures	7051.94	7053.13	7049.56	7052.24	591.0
2017-07-19 21:00:00	NQ	Futures	7052.24	7053.13	7050.15	7051.34	760.0
2017-07-19 22:00:00	NQ	Futures	7051.05	7051.34	7048.07	7048.67	525.0
2017-07-19 23:00:00	NQ	Futures	7048.37	7053.73	7048.07	7050.75	659.0
2017-07-19 00:00:00	YM	Futures	23425.2	23427.4	23420.9	23424.1	334.0
2017-07-19 01:00:00	YM	Futures	23424.1	23429.6	23423.0	23425.2	425.0
2017-07-19 02:00:00	YM	Futures	23425.2	23432.8	23420.9	23425.2	1110.0
2017-07-19 03:00:00	YM	Futures	23425.2	23429.6	23414.3	23423.0	2139.0

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

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