PREVIEW / futures_1hour / 2019-12-12

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-12-12.parquet
  size:    59 KB
  rows:    1,790

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-12-12 00:00:00	ES	Futures	3418.48	3418.75	3417.12	3417.12	5136.0
2019-12-12 01:00:00	ES	Futures	3417.39	3419.83	3416.85	3419.29	6127.0
2019-12-12 02:00:00	ES	Futures	3419.02	3419.83	3417.39	3418.2	8473.0
2019-12-12 03:00:00	ES	Futures	3418.2	3421.46	3417.66	3420.92	20824.0
2019-12-12 04:00:00	ES	Futures	3420.65	3423.37	3418.75	3421.46	16305.0
2019-12-12 05:00:00	ES	Futures	3421.74	3422.55	3416.3	3417.39	19529.0
2019-12-12 06:00:00	ES	Futures	3417.39	3419.02	3416.3	3418.75	9465.0
2019-12-12 07:00:00	ES	Futures	3418.48	3418.75	3414.4	3414.94	13601.0
2019-12-12 08:00:00	ES	Futures	3414.94	3415.76	3408.7	3413.31	52842.0
2019-12-12 09:00:00	ES	Futures	3413.04	3439.93	3410.33	3439.66	367332.0
2019-12-12 10:00:00	ES	Futures	3439.66	3452.43	3438.58	3445.1	359150.0
2019-12-12 11:00:00	ES	Futures	3445.1	3445.64	3426.08	3432.33	216461.0
2019-12-12 12:00:00	ES	Futures	3432.33	3434.5	3422.82	3430.16	172711.0
2019-12-12 13:00:00	ES	Futures	3430.43	3436.13	3429.88	3432.6	78764.0
2019-12-12 14:00:00	ES	Futures	3432.6	3444.82	3427.71	3438.03	205263.0
2019-12-12 15:00:00	ES	Futures	3438.03	3448.63	3436.95	3442.38	235091.0
2019-12-12 16:00:00	ES	Futures	3442.38	3445.1	3437.49	3444.01	79679.0
2019-12-12 18:00:00	ES	Futures	3450.53	3458.13	3449.17	3455.96	19551.0
2019-12-12 19:00:00	ES	Futures	3455.96	3457.05	3450.8	3456.78	16391.0
2019-12-12 20:00:00	ES	Futures	3456.78	3458.41	3455.15	3456.23	12080.0
2019-12-12 21:00:00	ES	Futures	3456.5	3457.59	3455.15	3456.23	8052.0
2019-12-12 22:00:00	ES	Futures	3455.96	3460.31	3454.6	3454.87	11203.0
2019-12-12 23:00:00	ES	Futures	3454.87	3455.69	3454.6	3455.15	2316.0
2019-12-12 00:00:00	NQ	Futures	9775.94	9776.52	9773.32	9773.32	1209.0
2019-12-12 01:00:00	NQ	Futures	9773.32	9781.46	9772.16	9780.59	2439.0
2019-12-12 02:00:00	NQ	Futures	9780.29	9782.04	9775.36	9778.55	3565.0
2019-12-12 03:00:00	NQ	Futures	9778.55	9791.33	9776.52	9788.43	8898.0
2019-12-12 04:00:00	NQ	Futures	9788.43	9795.4	9781.46	9790.75	5728.0
2019-12-12 05:00:00	NQ	Futures	9791.04	9794.24	9773.32	9777.97	7337.0
2019-12-12 06:00:00	NQ	Futures	9777.68	9782.91	9774.49	9781.17	4855.0
2019-12-12 07:00:00	NQ	Futures	9780.88	9782.04	9762.87	9764.03	8338.0
2019-12-12 08:00:00	NQ	Futures	9764.32	9766.35	9740.79	9755.89	26065.0
2019-12-12 09:00:00	NQ	Futures	9755.89	9835.78	9738.46	9834.04	94730.0
2019-12-12 10:00:00	NQ	Futures	9834.04	9873.25	9834.04	9853.79	89219.0
2019-12-12 11:00:00	NQ	Futures	9854.08	9855.82	9779.42	9797.43	66481.0
2019-12-12 12:00:00	NQ	Futures	9797.14	9803.24	9763.16	9791.91	49356.0
2019-12-12 13:00:00	NQ	Futures	9791.91	9814.86	9791.33	9807.02	25103.0
2019-12-12 14:00:00	NQ	Futures	9807.02	9838.1	9782.33	9813.41	59664.0
2019-12-12 15:00:00	NQ	Futures	9813.41	9853.21	9807.31	9838.39	51226.0
2019-12-12 16:00:00	NQ	Futures	9838.1	9847.11	9823.0	9844.49	11522.0
2019-12-12 18:00:00	NQ	Futures	9859.31	9886.03	9858.44	9879.64	5367.0
2019-12-12 19:00:00	NQ	Futures	9878.77	9887.78	9867.73	9887.49	9060.0
2019-12-12 20:00:00	NQ	Futures	9887.2	9894.17	9881.97	9887.49	6898.0
2019-12-12 21:00:00	NQ	Futures	9887.49	9890.97	9880.22	9884.58	3693.0
2019-12-12 22:00:00	NQ	Futures	9884.58	9898.82	9881.68	9884.0	3446.0
2019-12-12 23:00:00	NQ	Futures	9884.0	9888.94	9882.84	9885.16	1180.0
2019-12-12 00:00:00	YM	Futures	30418.4	30418.4	30410.8	30410.8	67.0
2019-12-12 01:00:00	YM	Futures	30409.7	30430.4	30409.7	30424.9	108.0
2019-12-12 02:00:00	YM	Futures	30420.6	30427.1	30412.9	30414.0	202.0
2019-12-12 03:00:00	YM	Futures	30427.1	30448.9	30417.3	30443.4	186.0

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

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