PREVIEW / futures_1hour / 2018-09-18

all futures 1-hour files

  file:    by_date/futures_1hour/2018/2018-09-18.parquet
  size:    54 KB
  rows:    1,667

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-09-18 00:00:00	ES	Futures	3148.92	3149.2	3146.75	3147.84	2965.0
2018-09-18 01:00:00	ES	Futures	3147.84	3149.47	3147.02	3149.2	3784.0
2018-09-18 02:00:00	ES	Futures	3149.2	3154.91	3149.2	3154.09	13257.0
2018-09-18 03:00:00	ES	Futures	3153.82	3156.0	3150.28	3154.64	27800.0
2018-09-18 04:00:00	ES	Futures	3154.64	3156.54	3153.55	3155.18	11096.0
2018-09-18 05:00:00	ES	Futures	3155.18	3158.44	3154.91	3157.36	16618.0
2018-09-18 06:00:00	ES	Futures	3157.63	3158.17	3156.0	3157.36	9730.0
2018-09-18 07:00:00	ES	Futures	3157.36	3158.44	3154.36	3156.54	15318.0
2018-09-18 08:00:00	ES	Futures	3156.81	3159.53	3154.36	3157.63	28592.0
2018-09-18 09:00:00	ES	Futures	3157.9	3163.34	3150.28	3160.08	210066.0
2018-09-18 10:00:00	ES	Futures	3160.35	3166.33	3156.81	3166.06	200891.0
2018-09-18 11:00:00	ES	Futures	3166.06	3170.68	3164.43	3170.41	130774.0
2018-09-18 12:00:00	ES	Futures	3170.41	3173.13	3167.69	3168.51	95214.0
2018-09-18 13:00:00	ES	Futures	3168.24	3170.96	3166.88	3170.68	48660.0
2018-09-18 14:00:00	ES	Futures	3170.41	3174.49	3169.87	3171.5	72802.0
2018-09-18 15:00:00	ES	Futures	3171.23	3173.13	3166.6	3167.42	173415.0
2018-09-18 16:00:00	ES	Futures	3167.42	3169.6	3166.33	3169.05	57295.0
2018-09-18 18:00:00	ES	Futures	3169.32	3171.77	3168.78	3170.68	4468.0
2018-09-18 19:00:00	ES	Futures	3170.68	3171.23	3168.51	3168.51	2620.0
2018-09-18 20:00:00	ES	Futures	3168.51	3168.51	3164.97	3167.15	8001.0
2018-09-18 21:00:00	ES	Futures	3167.15	3167.96	3165.52	3166.33	5327.0
2018-09-18 22:00:00	ES	Futures	3166.33	3169.32	3165.52	3169.05	6972.0
2018-09-18 23:00:00	ES	Futures	3169.32	3169.87	3166.33	3166.33	5596.0
2018-09-18 00:00:00	NQ	Futures	8745.45	8746.63	8738.71	8743.4	1505.0
2018-09-18 01:00:00	NQ	Futures	8743.69	8749.56	8738.71	8748.68	2039.0
2018-09-18 02:00:00	NQ	Futures	8748.68	8774.49	8748.68	8769.51	7105.0
2018-09-18 03:00:00	NQ	Futures	8769.21	8778.31	8761.0	8770.97	7558.0
2018-09-18 04:00:00	NQ	Futures	8771.56	8781.83	8769.51	8775.08	3960.0
2018-09-18 05:00:00	NQ	Futures	8775.08	8787.11	8775.08	8785.93	6120.0
2018-09-18 06:00:00	NQ	Futures	8785.93	8787.99	8778.31	8783.59	4707.0
2018-09-18 07:00:00	NQ	Futures	8783.59	8785.05	8760.12	8774.49	7973.0
2018-09-18 08:00:00	NQ	Futures	8774.49	8787.4	8766.87	8780.36	8687.0
2018-09-18 09:00:00	NQ	Futures	8780.36	8834.33	8758.65	8825.82	78569.0
2018-09-18 10:00:00	NQ	Futures	8826.12	8854.27	8821.13	8852.22	70869.0
2018-09-18 11:00:00	NQ	Futures	8852.22	8872.17	8843.13	8864.54	44293.0
2018-09-18 12:00:00	NQ	Futures	8864.83	8874.81	8838.14	8844.89	40431.0
2018-09-18 13:00:00	NQ	Futures	8845.18	8856.03	8832.86	8851.93	24534.0
2018-09-18 14:00:00	NQ	Futures	8851.93	8862.78	8842.83	8845.47	23267.0
2018-09-18 15:00:00	NQ	Futures	8845.77	8852.51	8829.05	8831.1	38935.0
2018-09-18 16:00:00	NQ	Futures	8831.1	8834.62	8823.48	8833.74	10128.0
2018-09-18 18:00:00	NQ	Futures	8833.74	8846.35	8832.57	8839.61	2017.0
2018-09-18 19:00:00	NQ	Futures	8839.32	8844.89	8831.4	8831.4	1551.0
2018-09-18 20:00:00	NQ	Futures	8831.1	8833.45	8817.32	8827.29	3899.0
2018-09-18 21:00:00	NQ	Futures	8827.0	8830.22	8821.13	8824.06	1761.0
2018-09-18 22:00:00	NQ	Futures	8824.06	8839.9	8821.72	8839.32	2685.0
2018-09-18 23:00:00	NQ	Futures	8839.61	8843.13	8827.0	8827.88	2223.0
2018-09-18 00:00:00	YM	Futures	28335.2	28339.5	28319.9	28327.6	788.0
2018-09-18 01:00:00	YM	Futures	28326.5	28336.2	28314.5	28334.1	1226.0
2018-09-18 02:00:00	YM	Futures	28334.1	28402.5	28334.1	28391.7	3516.0
2018-09-18 03:00:00	YM	Futures	28390.6	28411.2	28354.7	28391.7	4352.0

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

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