PREVIEW / futures_1hour / 2018-08-29

all futures 1-hour files

  file:    by_date/futures_1hour/2018/2018-08-29.parquet
  size:    53 KB
  rows:    1,677

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-08-29 00:00:00	ES	Futures	3165.51	3165.51	3164.42	3165.24	1514.0
2018-08-29 01:00:00	ES	Futures	3165.24	3166.06	3163.61	3163.88	6345.0
2018-08-29 02:00:00	ES	Futures	3164.15	3164.42	3163.06	3163.88	6309.0
2018-08-29 03:00:00	ES	Futures	3164.15	3165.24	3161.7	3162.52	12679.0
2018-08-29 04:00:00	ES	Futures	3162.24	3163.61	3161.7	3161.7	9392.0
2018-08-29 05:00:00	ES	Futures	3161.7	3163.33	3159.79	3161.15	10327.0
2018-08-29 06:00:00	ES	Futures	3161.15	3161.15	3159.25	3159.79	9245.0
2018-08-29 07:00:00	ES	Futures	3160.06	3162.52	3159.79	3161.97	8269.0
2018-08-29 08:00:00	ES	Futures	3161.97	3162.52	3157.88	3159.25	30114.0
2018-08-29 09:00:00	ES	Futures	3159.25	3163.61	3159.25	3162.52	155496.0
2018-08-29 10:00:00	ES	Futures	3162.79	3170.96	3160.06	3170.42	179532.0
2018-08-29 11:00:00	ES	Futures	3170.15	3178.05	3169.06	3176.68	168913.0
2018-08-29 12:00:00	ES	Futures	3176.68	3178.32	3175.05	3176.96	78213.0
2018-08-29 13:00:00	ES	Futures	3176.96	3178.05	3172.87	3173.41	77437.0
2018-08-29 14:00:00	ES	Futures	3173.41	3176.14	3172.87	3175.32	61780.0
2018-08-29 15:00:00	ES	Futures	3175.32	3179.68	3175.32	3176.41	166246.0
2018-08-29 16:00:00	ES	Futures	3176.41	3177.5	3175.32	3177.5	59393.0
2018-08-29 18:00:00	ES	Futures	3177.77	3178.32	3176.68	3177.77	4077.0
2018-08-29 19:00:00	ES	Futures	3177.77	3178.05	3176.41	3176.41	1921.0
2018-08-29 20:00:00	ES	Futures	3176.41	3176.68	3175.32	3176.41	4962.0
2018-08-29 21:00:00	ES	Futures	3176.68	3177.23	3172.87	3173.69	9283.0
2018-08-29 22:00:00	ES	Futures	3173.96	3174.78	3173.69	3173.69	4049.0
2018-08-29 23:00:00	ES	Futures	3173.96	3174.5	3173.14	3173.96	4472.0
2018-08-29 00:00:00	NQ	Futures	8947.07	8950.31	8946.48	8949.43	1283.0
2018-08-29 01:00:00	NQ	Futures	8949.13	8949.72	8942.36	8946.48	2739.0
2018-08-29 02:00:00	NQ	Futures	8946.48	8947.37	8943.25	8945.31	1703.0
2018-08-29 03:00:00	NQ	Futures	8945.31	8949.13	8941.48	8942.95	3059.0
2018-08-29 04:00:00	NQ	Futures	8942.95	8947.96	8941.18	8942.95	2689.0
2018-08-29 05:00:00	NQ	Futures	8942.95	8948.55	8937.95	8941.77	3067.0
2018-08-29 06:00:00	NQ	Futures	8941.77	8941.77	8935.59	8936.77	3976.0
2018-08-29 07:00:00	NQ	Futures	8936.77	8942.07	8935.3	8941.18	2562.0
2018-08-29 08:00:00	NQ	Futures	8940.89	8944.72	8928.52	8932.35	7178.0
2018-08-29 09:00:00	NQ	Futures	8932.35	8966.5	8930.88	8959.44	61059.0
2018-08-29 10:00:00	NQ	Futures	8959.73	9001.54	8953.55	8995.36	58621.0
2018-08-29 11:00:00	NQ	Futures	8995.36	9020.38	8991.82	9012.14	45218.0
2018-08-29 12:00:00	NQ	Futures	9012.14	9018.32	9005.66	9017.14	25586.0
2018-08-29 13:00:00	NQ	Futures	9016.85	9017.44	9008.31	9010.37	15605.0
2018-08-29 14:00:00	NQ	Futures	9010.37	9020.38	9010.08	9019.5	17894.0
2018-08-29 15:00:00	NQ	Futures	9019.5	9035.4	9018.91	9029.51	37202.0
2018-08-29 16:00:00	NQ	Futures	9029.51	9038.05	9025.68	9035.69	9096.0
2018-08-29 18:00:00	NQ	Futures	9035.99	9038.05	9032.16	9035.1	1762.0
2018-08-29 19:00:00	NQ	Futures	9035.1	9035.4	9031.57	9031.87	1236.0
2018-08-29 20:00:00	NQ	Futures	9031.87	9032.16	9026.27	9030.39	2151.0
2018-08-29 21:00:00	NQ	Futures	9030.69	9034.22	9018.62	9022.44	4204.0
2018-08-29 22:00:00	NQ	Futures	9022.74	9025.68	9019.79	9021.56	1946.0
2018-08-29 23:00:00	NQ	Futures	9021.56	9024.8	9018.62	9021.56	2334.0
2018-08-29 00:00:00	YM	Futures	28426.5	28426.5	28414.6	28420.0	478.0
2018-08-29 01:00:00	YM	Futures	28418.9	28422.2	28399.3	28408.0	1535.0
2018-08-29 02:00:00	YM	Futures	28408.0	28408.0	28390.6	28400.4	1200.0
2018-08-29 03:00:00	YM	Futures	28400.4	28413.5	28380.9	28390.6	2554.0

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

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