PREVIEW / futures_1hour / 2019-01-16

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-01-16.parquet
  size:    56 KB
  rows:    1,780

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-01-16 00:00:00	ES	Futures	2837.24	2839.15	2835.61	2838.33	6401.0
2019-01-16 01:00:00	ES	Futures	2838.33	2838.6	2836.16	2837.79	4057.0
2019-01-16 02:00:00	ES	Futures	2837.52	2842.95	2837.52	2840.23	13073.0
2019-01-16 03:00:00	ES	Futures	2839.96	2841.59	2837.52	2839.69	14318.0
2019-01-16 04:00:00	ES	Futures	2839.96	2841.05	2834.8	2836.97	12837.0
2019-01-16 05:00:00	ES	Futures	2836.7	2839.69	2834.53	2835.07	9982.0
2019-01-16 06:00:00	ES	Futures	2835.07	2835.61	2832.63	2835.61	12435.0
2019-01-16 07:00:00	ES	Futures	2835.89	2838.6	2832.08	2837.24	23665.0
2019-01-16 08:00:00	ES	Futures	2837.24	2839.42	2835.89	2838.33	17197.0
2019-01-16 09:00:00	ES	Futures	2838.33	2850.55	2838.06	2847.29	196482.0
2019-01-16 10:00:00	ES	Futures	2847.02	2850.55	2838.06	2844.85	182346.0
2019-01-16 11:00:00	ES	Futures	2844.85	2849.47	2838.87	2842.68	154525.0
2019-01-16 12:00:00	ES	Futures	2842.95	2847.84	2839.69	2846.48	107012.0
2019-01-16 13:00:00	ES	Futures	2846.75	2848.38	2843.49	2847.02	58077.0
2019-01-16 14:00:00	ES	Futures	2847.02	2853.0	2847.02	2847.84	104687.0
2019-01-16 15:00:00	ES	Futures	2848.11	2851.91	2841.05	2842.4	225389.0
2019-01-16 16:00:00	ES	Futures	2842.13	2842.95	2838.06	2840.77	64101.0
2019-01-16 18:00:00	ES	Futures	2840.23	2841.86	2836.97	2837.24	9270.0
2019-01-16 19:00:00	ES	Futures	2836.97	2838.33	2834.26	2836.97	11125.0
2019-01-16 20:00:00	ES	Futures	2836.97	2839.96	2829.1	2830.73	21481.0
2019-01-16 21:00:00	ES	Futures	2831.0	2833.98	2828.01	2833.44	17439.0
2019-01-16 22:00:00	ES	Futures	2833.44	2834.26	2830.73	2832.9	8695.0
2019-01-16 23:00:00	ES	Futures	2832.9	2833.44	2831.0	2831.0	4487.0
2019-01-16 00:00:00	NQ	Futures	7816.06	7820.45	7806.71	7817.53	3120.0
2019-01-16 01:00:00	NQ	Futures	7817.53	7818.69	7807.59	7811.39	2154.0
2019-01-16 02:00:00	NQ	Futures	7810.81	7828.92	7808.76	7812.27	6648.0
2019-01-16 03:00:00	NQ	Futures	7811.97	7817.53	7804.08	7811.97	5924.0
2019-01-16 04:00:00	NQ	Futures	7812.27	7817.53	7798.53	7804.96	4822.0
2019-01-16 05:00:00	NQ	Futures	7804.38	7812.27	7800.29	7802.04	3667.0
2019-01-16 06:00:00	NQ	Futures	7802.33	7807.88	7796.49	7807.88	4097.0
2019-01-16 07:00:00	NQ	Futures	7807.88	7819.28	7799.99	7813.73	9077.0
2019-01-16 08:00:00	NQ	Futures	7813.73	7818.69	7809.05	7814.31	10112.0
2019-01-16 09:00:00	NQ	Futures	7814.02	7874.21	7813.43	7856.68	66071.0
2019-01-16 10:00:00	NQ	Futures	7856.97	7868.37	7806.42	7821.91	68302.0
2019-01-16 11:00:00	NQ	Futures	7821.91	7848.5	7802.62	7814.31	57742.0
2019-01-16 12:00:00	NQ	Futures	7814.31	7832.72	7802.62	7826.0	45717.0
2019-01-16 13:00:00	NQ	Futures	7826.0	7826.29	7812.85	7818.69	28188.0
2019-01-16 14:00:00	NQ	Futures	7818.4	7838.86	7818.4	7822.79	35636.0
2019-01-16 15:00:00	NQ	Futures	7823.08	7833.89	7803.5	7807.59	48956.0
2019-01-16 16:00:00	NQ	Futures	7807.3	7810.22	7788.89	7797.36	11250.0
2019-01-16 18:00:00	NQ	Futures	7795.61	7802.04	7783.34	7783.92	3320.0
2019-01-16 19:00:00	NQ	Futures	7783.92	7788.89	7776.62	7785.97	4834.0
2019-01-16 20:00:00	NQ	Futures	7785.97	7793.86	7762.89	7769.9	7445.0
2019-01-16 21:00:00	NQ	Futures	7770.19	7779.54	7761.13	7779.54	5638.0
2019-01-16 22:00:00	NQ	Futures	7779.83	7783.05	7772.82	7779.83	4145.0
2019-01-16 23:00:00	NQ	Futures	7780.13	7782.76	7771.94	7773.41	2333.0
2019-01-16 00:00:00	YM	Futures	26101.5	26122.1	26084.1	26115.6	1551.0
2019-01-16 01:00:00	YM	Futures	26114.5	26117.8	26097.1	26110.2	999.0
2019-01-16 02:00:00	YM	Futures	26109.1	26160.1	26109.1	26142.7	3934.0
2019-01-16 03:00:00	YM	Futures	26140.6	26155.8	26115.6	26133.0	4052.0

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

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