PREVIEW / futures_1hour / 2017-11-06

all futures 1-hour files

  file:    by_date/futures_1hour/2017/2017-11-06.parquet
  size:    52 KB
  rows:    1,652

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-11-06 00:00:00	ES	Futures	2821.21	2822.58	2820.94	2820.94	4914.0
2017-11-06 01:00:00	ES	Futures	2821.21	2823.67	2820.94	2823.67	4751.0
2017-11-06 02:00:00	ES	Futures	2823.4	2825.04	2822.03	2822.58	8998.0
2017-11-06 03:00:00	ES	Futures	2822.85	2825.31	2822.3	2824.49	13740.0
2017-11-06 04:00:00	ES	Futures	2824.49	2825.04	2822.3	2825.04	12948.0
2017-11-06 05:00:00	ES	Futures	2824.77	2824.77	2823.12	2823.4	7122.0
2017-11-06 06:00:00	ES	Futures	2823.12	2825.31	2823.12	2825.31	9037.0
2017-11-06 07:00:00	ES	Futures	2825.31	2826.41	2824.77	2825.31	9554.0
2017-11-06 08:00:00	ES	Futures	2825.31	2826.41	2824.49	2826.13	14467.0
2017-11-06 09:00:00	ES	Futures	2826.41	2829.69	2825.59	2829.42	103896.0
2017-11-06 10:00:00	ES	Futures	2829.69	2831.61	2828.05	2829.69	133969.0
2017-11-06 11:00:00	ES	Futures	2829.96	2831.88	2828.87	2829.42	92198.0
2017-11-06 12:00:00	ES	Futures	2829.14	2832.15	2828.87	2831.61	48183.0
2017-11-06 13:00:00	ES	Futures	2831.88	2832.97	2831.06	2832.43	61598.0
2017-11-06 14:00:00	ES	Futures	2832.43	2833.52	2831.33	2833.25	36552.0
2017-11-06 15:00:00	ES	Futures	2833.25	2834.07	2831.61	2831.88	125429.0
2017-11-06 16:00:00	ES	Futures	2831.88	2832.97	2830.51	2832.43	80633.0
2017-11-06 18:00:00	ES	Futures	2831.61	2832.43	2831.33	2832.15	4934.0
2017-11-06 19:00:00	ES	Futures	2831.88	2832.97	2831.61	2832.97	3943.0
2017-11-06 20:00:00	ES	Futures	2832.97	2834.89	2832.43	2834.07	7615.0
2017-11-06 21:00:00	ES	Futures	2834.07	2834.61	2832.7	2832.97	4545.0
2017-11-06 22:00:00	ES	Futures	2832.97	2835.16	2832.97	2834.89	4178.0
2017-11-06 23:00:00	ES	Futures	2834.89	2836.53	2834.34	2836.26	6700.0
2017-11-06 00:00:00	NQ	Futures	7470.21	7475.26	7469.91	7471.1	1164.0
2017-11-06 01:00:00	NQ	Futures	7471.1	7480.62	7471.1	7480.62	1165.0
2017-11-06 02:00:00	NQ	Futures	7480.32	7486.86	7476.16	7478.54	2423.0
2017-11-06 03:00:00	NQ	Futures	7478.83	7484.19	7478.24	7481.51	1620.0
2017-11-06 04:00:00	NQ	Futures	7481.51	7485.38	7476.75	7484.19	2250.0
2017-11-06 05:00:00	NQ	Futures	7484.19	7484.48	7478.24	7478.83	1473.0
2017-11-06 06:00:00	NQ	Futures	7478.54	7486.27	7477.05	7485.97	1850.0
2017-11-06 07:00:00	NQ	Futures	7486.27	7490.73	7484.48	7487.76	2877.0
2017-11-06 08:00:00	NQ	Futures	7487.76	7488.65	7483.0	7488.65	3914.0
2017-11-06 09:00:00	NQ	Futures	7488.35	7505.3	7479.43	7504.11	39480.0
2017-11-06 10:00:00	NQ	Futures	7504.41	7513.63	7495.79	7504.71	37329.0
2017-11-06 11:00:00	NQ	Futures	7504.71	7506.49	7487.76	7494.0	26744.0
2017-11-06 12:00:00	NQ	Futures	7494.0	7505.3	7492.81	7503.52	13806.0
2017-11-06 13:00:00	NQ	Futures	7503.52	7510.66	7501.14	7509.77	14121.0
2017-11-06 14:00:00	NQ	Futures	7509.47	7512.14	7504.41	7511.55	10776.0
2017-11-06 15:00:00	NQ	Futures	7511.55	7515.71	7507.98	7511.25	23936.0
2017-11-06 16:00:00	NQ	Futures	7510.95	7512.74	7505.9	7510.36	7929.0
2017-11-06 18:00:00	NQ	Futures	7508.58	7511.25	7505.9	7508.87	1276.0
2017-11-06 19:00:00	NQ	Futures	7508.58	7511.25	7507.68	7510.95	875.0
2017-11-06 20:00:00	NQ	Futures	7510.95	7521.07	7510.66	7518.99	2455.0
2017-11-06 21:00:00	NQ	Futures	7519.28	7521.66	7514.82	7515.12	1525.0
2017-11-06 22:00:00	NQ	Futures	7515.12	7523.74	7514.52	7521.36	1300.0
2017-11-06 23:00:00	NQ	Futures	7521.36	7527.31	7519.88	7525.23	1602.0
2017-11-06 00:00:00	YM	Futures	25487.7	25497.5	25485.5	25486.6	910.0
2017-11-06 01:00:00	YM	Futures	25488.8	25509.5	25488.8	25508.4	1131.0
2017-11-06 02:00:00	YM	Futures	25509.5	25523.6	25497.5	25505.1	1730.0
2017-11-06 03:00:00	YM	Futures	25506.2	25521.4	25505.1	25513.8	1376.0

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

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