PREVIEW / futures_1hour / 2019-10-31

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-10-31.parquet
  size:    61 KB
  rows:    1,893

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
2019-10-31 00:00:00	ES	Futures	3311.45	3312.54	3311.18	3312.0	2612.0
2019-10-31 01:00:00	ES	Futures	3312.0	3312.27	3310.64	3311.18	4582.0
2019-10-31 02:00:00	ES	Futures	3310.91	3311.72	3309.82	3310.64	4213.0
2019-10-31 03:00:00	ES	Futures	3310.37	3313.9	3310.37	3313.63	7962.0
2019-10-31 04:00:00	ES	Futures	3313.63	3315.26	3310.91	3313.08	22616.0
2019-10-31 05:00:00	ES	Futures	3312.81	3313.9	3295.97	3299.5	84333.0
2019-10-31 06:00:00	ES	Futures	3299.77	3302.76	3297.87	3302.49	27349.0
2019-10-31 07:00:00	ES	Futures	3302.49	3303.58	3298.14	3301.67	26921.0
2019-10-31 08:00:00	ES	Futures	3301.4	3307.65	3300.04	3305.75	38091.0
2019-10-31 09:00:00	ES	Futures	3305.75	3309.82	3298.41	3298.41	181698.0
2019-10-31 10:00:00	ES	Futures	3298.69	3298.69	3281.57	3292.98	320327.0
2019-10-31 11:00:00	ES	Futures	3292.98	3295.43	3288.09	3291.62	168516.0
2019-10-31 12:00:00	ES	Futures	3291.9	3292.71	3282.66	3286.19	142278.0
2019-10-31 13:00:00	ES	Futures	3286.19	3291.35	3285.11	3288.09	99841.0
2019-10-31 14:00:00	ES	Futures	3287.82	3289.18	3282.39	3287.55	108590.0
2019-10-31 15:00:00	ES	Futures	3287.28	3299.77	3286.19	3298.69	303382.0
2019-10-31 16:00:00	ES	Futures	3298.69	3301.4	3297.33	3298.14	101713.0
2019-10-31 18:00:00	ES	Futures	3298.69	3298.69	3295.43	3295.97	4908.0
2019-10-31 19:00:00	ES	Futures	3295.97	3298.41	3295.7	3296.79	2902.0
2019-10-31 20:00:00	ES	Futures	3297.06	3300.32	3296.79	3299.23	9120.0
2019-10-31 21:00:00	ES	Futures	3299.23	3306.84	3299.23	3305.75	15482.0
2019-10-31 22:00:00	ES	Futures	3305.75	3306.84	3304.93	3306.02	6981.0
2019-10-31 23:00:00	ES	Futures	3306.02	3306.84	3304.66	3305.21	5035.0
2019-10-31 00:00:00	NQ	Futures	9434.61	9438.39	9432.29	9433.45	1234.0
2019-10-31 01:00:00	NQ	Futures	9433.16	9435.77	9431.12	9431.7	1331.0
2019-10-31 02:00:00	NQ	Futures	9431.7	9432.87	9427.06	9428.8	1523.0
2019-10-31 03:00:00	NQ	Futures	9429.09	9450.3	9428.8	9449.42	4714.0
2019-10-31 04:00:00	NQ	Futures	9449.13	9457.27	9438.39	9444.78	8564.0
2019-10-31 05:00:00	NQ	Futures	9445.07	9448.55	9390.45	9402.65	23576.0
2019-10-31 06:00:00	NQ	Futures	9403.24	9412.53	9396.26	9410.79	8408.0
2019-10-31 07:00:00	NQ	Futures	9410.79	9413.11	9395.97	9406.72	7382.0
2019-10-31 08:00:00	NQ	Futures	9406.72	9425.89	9402.95	9421.54	15669.0
2019-10-31 09:00:00	NQ	Futures	9421.83	9432.29	9395.97	9397.43	66704.0
2019-10-31 10:00:00	NQ	Futures	9397.14	9404.11	9349.2	9391.62	81692.0
2019-10-31 11:00:00	NQ	Futures	9391.91	9407.59	9384.06	9386.1	50050.0
2019-10-31 12:00:00	NQ	Futures	9386.1	9390.45	9362.28	9371.28	41005.0
2019-10-31 13:00:00	NQ	Futures	9370.99	9389.29	9368.67	9375.64	26455.0
2019-10-31 14:00:00	NQ	Futures	9375.35	9376.51	9356.76	9375.06	28313.0
2019-10-31 15:00:00	NQ	Futures	9374.77	9403.82	9372.15	9401.49	50539.0
2019-10-31 16:00:00	NQ	Futures	9401.2	9411.08	9398.88	9402.95	12519.0
2019-10-31 18:00:00	NQ	Futures	9405.27	9405.56	9393.94	9395.97	1662.0
2019-10-31 19:00:00	NQ	Futures	9395.68	9403.82	9394.52	9399.46	1092.0
2019-10-31 20:00:00	NQ	Futures	9400.04	9409.92	9399.75	9407.01	2761.0
2019-10-31 21:00:00	NQ	Futures	9407.3	9431.12	9406.72	9428.8	5402.0
2019-10-31 22:00:00	NQ	Futures	9428.51	9437.22	9425.31	9432.58	3436.0
2019-10-31 23:00:00	NQ	Futures	9432.58	9435.19	9428.51	9431.7	1385.0
2019-10-31 00:00:00	YM	Futures	29553.1	29562.9	29550.9	29554.2	527.0
2019-10-31 01:00:00	YM	Futures	29555.3	29557.5	29533.5	29537.9	1485.0
2019-10-31 02:00:00	YM	Futures	29536.8	29545.5	29529.2	29534.6	848.0
2019-10-31 03:00:00	YM	Futures	29534.6	29559.6	29533.5	29558.6	1466.0

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

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