PREVIEW / futures_1hour / 2018-07-30

all futures 1-hour files

  file:    by_date/futures_1hour/2018/2018-07-30.parquet
  size:    52 KB
  rows:    1,645

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
2018-07-30 00:00:00	ES	Futures	3062.25	3062.79	3060.89	3062.25	2192.0
2018-07-30 01:00:00	ES	Futures	3062.52	3062.52	3060.07	3061.43	6185.0
2018-07-30 02:00:00	ES	Futures	3061.43	3064.7	3061.43	3064.7	5411.0
2018-07-30 03:00:00	ES	Futures	3064.7	3067.43	3063.34	3066.34	15327.0
2018-07-30 04:00:00	ES	Futures	3066.06	3067.7	3065.25	3067.15	16180.0
2018-07-30 05:00:00	ES	Futures	3067.15	3069.33	3066.88	3068.52	15137.0
2018-07-30 06:00:00	ES	Futures	3068.79	3069.33	3067.7	3069.06	8239.0
2018-07-30 07:00:00	ES	Futures	3069.33	3070.42	3067.7	3069.06	11115.0
2018-07-30 08:00:00	ES	Futures	3069.33	3072.06	3069.06	3070.7	15445.0
2018-07-30 09:00:00	ES	Futures	3070.97	3075.33	3065.52	3067.15	160042.0
2018-07-30 10:00:00	ES	Futures	3067.15	3069.88	3062.79	3063.34	180330.0
2018-07-30 11:00:00	ES	Futures	3063.34	3065.52	3059.52	3061.98	108481.0
2018-07-30 12:00:00	ES	Futures	3061.7	3061.98	3049.72	3054.35	145404.0
2018-07-30 13:00:00	ES	Futures	3054.07	3062.25	3049.99	3061.98	91100.0
2018-07-30 14:00:00	ES	Futures	3062.25	3063.88	3056.53	3058.16	93079.0
2018-07-30 15:00:00	ES	Futures	3058.43	3059.8	3052.17	3055.71	181623.0
2018-07-30 16:00:00	ES	Futures	3055.71	3058.98	3053.8	3057.34	58048.0
2018-07-30 18:00:00	ES	Futures	3057.62	3059.52	3057.07	3059.25	2830.0
2018-07-30 19:00:00	ES	Futures	3059.25	3059.25	3057.34	3058.16	1871.0
2018-07-30 20:00:00	ES	Futures	3058.43	3058.71	3054.62	3058.43	8155.0
2018-07-30 21:00:00	ES	Futures	3058.43	3059.52	3056.25	3057.89	6248.0
2018-07-30 22:00:00	ES	Futures	3057.89	3059.25	3055.71	3058.16	4452.0
2018-07-30 23:00:00	ES	Futures	3057.89	3058.71	3056.53	3057.34	2253.0
2018-07-30 00:00:00	NQ	Futures	8560.8	8562.86	8551.08	8555.2	1961.0
2018-07-30 01:00:00	NQ	Futures	8555.5	8559.32	8539.3	8554.61	3503.0
2018-07-30 02:00:00	NQ	Futures	8555.2	8569.92	8554.32	8569.92	2689.0
2018-07-30 03:00:00	NQ	Futures	8570.22	8582.58	8562.86	8576.99	4678.0
2018-07-30 04:00:00	NQ	Futures	8577.28	8592.0	8572.57	8589.65	4690.0
2018-07-30 05:00:00	NQ	Futures	8589.65	8595.83	8581.41	8584.94	4470.0
2018-07-30 06:00:00	NQ	Futures	8585.53	8589.65	8579.34	8586.41	3346.0
2018-07-30 07:00:00	NQ	Futures	8586.71	8590.24	8570.51	8581.41	6148.0
2018-07-30 08:00:00	NQ	Futures	8581.99	8605.55	8581.41	8591.71	8690.0
2018-07-30 09:00:00	NQ	Futures	8592.0	8607.9	8491.9	8506.62	97468.0
2018-07-30 10:00:00	NQ	Futures	8506.62	8538.13	8498.09	8502.8	88100.0
2018-07-30 11:00:00	NQ	Futures	8502.8	8517.81	8481.6	8508.1	61042.0
2018-07-30 12:00:00	NQ	Futures	8508.1	8508.39	8440.09	8465.11	61556.0
2018-07-30 13:00:00	NQ	Futures	8465.11	8504.86	8451.27	8502.21	40694.0
2018-07-30 14:00:00	NQ	Futures	8502.21	8512.51	8483.95	8489.55	31341.0
2018-07-30 15:00:00	NQ	Futures	8489.84	8498.67	8472.47	8483.66	48643.0
2018-07-30 16:00:00	NQ	Futures	8483.66	8493.37	8477.77	8488.66	8458.0
2018-07-30 18:00:00	NQ	Futures	8491.02	8497.5	8486.6	8496.61	1426.0
2018-07-30 19:00:00	NQ	Futures	8496.32	8497.2	8487.78	8491.9	964.0
2018-07-30 20:00:00	NQ	Futures	8492.49	8493.37	8468.64	8487.49	4280.0
2018-07-30 21:00:00	NQ	Futures	8487.49	8491.02	8479.54	8485.43	2168.0
2018-07-30 22:00:00	NQ	Futures	8485.43	8489.55	8474.24	8483.07	2232.0
2018-07-30 23:00:00	NQ	Futures	8483.07	8485.43	8476.0	8477.48	1075.0
2018-07-30 00:00:00	YM	Futures	27582.9	27587.2	27573.1	27584.0	514.0
2018-07-30 01:00:00	YM	Futures	27582.9	27585.1	27563.3	27573.1	1332.0
2018-07-30 02:00:00	YM	Futures	27575.3	27601.4	27575.3	27600.3	1215.0
2018-07-30 03:00:00	YM	Futures	27600.3	27622.0	27589.4	27605.7	2390.0

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

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