PREVIEW / futures_1hour / 2019-05-02

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-05-02.parquet
  size:    55 KB
  rows:    1,772

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-05-02 00:00:00	ES	Futures	3173.25	3173.25	3171.63	3171.9	3763.0
2019-05-02 01:00:00	ES	Futures	3171.9	3172.17	3170.27	3170.81	5072.0
2019-05-02 02:00:00	ES	Futures	3170.81	3176.51	3170.81	3175.15	14633.0
2019-05-02 03:00:00	ES	Futures	3175.42	3178.13	3173.25	3175.42	19094.0
2019-05-02 04:00:00	ES	Futures	3175.15	3178.67	3173.25	3176.51	17166.0
2019-05-02 05:00:00	ES	Futures	3176.51	3179.76	3176.23	3179.22	14785.0
2019-05-02 06:00:00	ES	Futures	3179.22	3179.22	3175.15	3176.23	15606.0
2019-05-02 07:00:00	ES	Futures	3176.23	3177.05	3171.63	3174.07	23473.0
2019-05-02 08:00:00	ES	Futures	3173.79	3174.61	3167.56	3169.73	46063.0
2019-05-02 09:00:00	ES	Futures	3169.73	3176.23	3165.66	3174.61	192498.0
2019-05-02 10:00:00	ES	Futures	3174.61	3180.3	3168.37	3168.64	188802.0
2019-05-02 11:00:00	ES	Futures	3168.91	3172.44	3145.87	3151.02	386240.0
2019-05-02 12:00:00	ES	Futures	3151.02	3159.7	3148.04	3156.71	212017.0
2019-05-02 13:00:00	ES	Futures	3156.44	3165.93	3151.84	3161.59	182570.0
2019-05-02 14:00:00	ES	Futures	3161.59	3167.02	3155.36	3159.43	156513.0
2019-05-02 15:00:00	ES	Futures	3159.15	3165.66	3158.34	3165.12	206340.0
2019-05-02 16:00:00	ES	Futures	3165.12	3166.2	3161.05	3165.39	51663.0
2019-05-02 18:00:00	ES	Futures	3164.85	3168.1	3164.31	3166.2	5123.0
2019-05-02 19:00:00	ES	Futures	3166.2	3167.29	3165.39	3165.66	3238.0
2019-05-02 20:00:00	ES	Futures	3165.66	3167.56	3163.76	3167.29	5427.0
2019-05-02 21:00:00	ES	Futures	3167.29	3167.29	3162.68	3166.47	7555.0
2019-05-02 22:00:00	ES	Futures	3166.47	3169.46	3165.39	3169.19	5580.0
2019-05-02 23:00:00	ES	Futures	3169.19	3172.98	3168.91	3169.19	10325.0
2019-05-02 00:00:00	NQ	Futures	9046.8	9048.84	9040.4	9044.18	2021.0
2019-05-02 01:00:00	NQ	Futures	9043.89	9046.51	9038.36	9040.1	2793.0
2019-05-02 02:00:00	NQ	Futures	9039.81	9051.46	9039.52	9049.13	3981.0
2019-05-02 03:00:00	NQ	Futures	9049.42	9059.32	9044.18	9052.04	5675.0
2019-05-02 04:00:00	NQ	Futures	9051.46	9060.78	9045.35	9058.16	5421.0
2019-05-02 05:00:00	NQ	Futures	9057.86	9069.51	9056.7	9068.35	4424.0
2019-05-02 06:00:00	NQ	Futures	9068.64	9069.22	9057.28	9062.52	3870.0
2019-05-02 07:00:00	NQ	Futures	9062.23	9062.81	9045.35	9057.57	8343.0
2019-05-02 08:00:00	NQ	Futures	9057.86	9060.19	9035.45	9043.02	19173.0
2019-05-02 09:00:00	NQ	Futures	9042.72	9068.06	9030.2	9059.32	66615.0
2019-05-02 10:00:00	NQ	Futures	9059.9	9089.89	9043.02	9045.05	77776.0
2019-05-02 11:00:00	NQ	Futures	9045.35	9061.65	8946.93	8962.66	127215.0
2019-05-02 12:00:00	NQ	Futures	8962.95	8998.76	8955.38	8976.34	71879.0
2019-05-02 13:00:00	NQ	Futures	8976.05	9015.65	8959.45	8998.47	52963.0
2019-05-02 14:00:00	NQ	Futures	8998.76	9021.18	8979.83	8994.1	48141.0
2019-05-02 15:00:00	NQ	Futures	8994.1	9014.19	8988.86	9010.12	53468.0
2019-05-02 16:00:00	NQ	Futures	9010.12	9014.19	8995.56	9014.19	12428.0
2019-05-02 18:00:00	NQ	Futures	9013.03	9019.72	9008.08	9016.52	1685.0
2019-05-02 19:00:00	NQ	Futures	9016.23	9021.18	9013.9	9017.98	1626.0
2019-05-02 20:00:00	NQ	Futures	9017.69	9025.55	9011.86	9023.8	3525.0
2019-05-02 21:00:00	NQ	Futures	9023.22	9024.67	9009.82	9022.34	3754.0
2019-05-02 22:00:00	NQ	Futures	9022.63	9034.86	9019.14	9033.41	2799.0
2019-05-02 23:00:00	NQ	Futures	9033.41	9045.35	9032.83	9039.23	4548.0
2019-05-02 00:00:00	YM	Futures	28729.6	28730.7	28711.2	28711.2	760.0
2019-05-02 01:00:00	YM	Futures	28710.1	28715.5	28693.7	28700.3	1185.0
2019-05-02 02:00:00	YM	Futures	28699.2	28753.6	28695.9	28743.8	3171.0
2019-05-02 03:00:00	YM	Futures	28743.8	28771.0	28718.8	28741.6	2982.0

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

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