PREVIEW / futures_1hour / 2021-05-07

all futures 1-hour files

  file:    by_date/futures_1hour/2021/2021-05-07.parquet
  size:    55 KB
  rows:    1,601

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
2021-05-07 00:00:00	ES	Futures	4718.6	4721.13	4716.91	4720.28	2667.0
2021-05-07 01:00:00	ES	Futures	4720.28	4720.28	4717.47	4718.6	5107.0
2021-05-07 02:00:00	ES	Futures	4718.6	4719.72	4715.51	4717.76	7445.0
2021-05-07 03:00:00	ES	Futures	4717.47	4718.32	4711.01	4714.67	18284.0
2021-05-07 04:00:00	ES	Futures	4714.67	4720.28	4713.82	4720.0	10330.0
2021-05-07 05:00:00	ES	Futures	4720.0	4723.38	4717.76	4723.09	8584.0
2021-05-07 06:00:00	ES	Futures	4723.09	4727.87	4722.25	4725.06	15918.0
2021-05-07 07:00:00	ES	Futures	4724.78	4726.19	4721.97	4726.19	12757.0
2021-05-07 08:00:00	ES	Futures	4726.19	4736.02	4715.51	4728.71	119420.0
2021-05-07 09:00:00	ES	Futures	4728.71	4741.08	4715.23	4735.18	315778.0
2021-05-07 10:00:00	ES	Futures	4735.18	4754.84	4734.33	4749.22	281193.0
2021-05-07 11:00:00	ES	Futures	4748.94	4756.53	4747.54	4753.16	142159.0
2021-05-07 12:00:00	ES	Futures	4753.16	4753.72	4743.04	4748.38	109880.0
2021-05-07 13:00:00	ES	Futures	4748.38	4748.66	4741.08	4743.61	98545.0
2021-05-07 14:00:00	ES	Futures	4743.89	4750.35	4738.27	4748.38	118150.0
2021-05-07 15:00:00	ES	Futures	4748.66	4755.97	4746.7	4747.82	233076.0
2021-05-07 16:00:00	ES	Futures	4747.82	4753.16	4746.98	4750.35	59548.0
2021-05-07 00:00:00	NQ	Futures	15784.44	15801.52	15773.44	15798.05	1711.0
2021-05-07 01:00:00	NQ	Futures	15797.76	15797.76	15776.05	15782.41	2823.0
2021-05-07 02:00:00	NQ	Futures	15782.41	15787.91	15757.52	15764.47	3882.0
2021-05-07 03:00:00	NQ	Futures	15763.89	15777.2	15734.94	15752.6	7084.0
2021-05-07 04:00:00	NQ	Futures	15752.02	15778.94	15746.52	15773.73	4894.0
2021-05-07 05:00:00	NQ	Futures	15773.73	15788.49	15760.7	15787.34	4356.0
2021-05-07 06:00:00	NQ	Futures	15787.34	15804.99	15779.52	15795.44	5721.0
2021-05-07 07:00:00	NQ	Futures	15795.44	15797.76	15778.07	15785.31	4757.0
2021-05-07 08:00:00	NQ	Futures	15785.02	16000.98	15768.52	15942.79	54693.0
2021-05-07 09:00:00	NQ	Futures	15942.79	15962.77	15819.76	15891.26	112388.0
2021-05-07 10:00:00	NQ	Futures	15891.55	15992.3	15862.89	15946.56	77698.0
2021-05-07 11:00:00	NQ	Futures	15946.56	15981.88	15938.74	15968.27	46169.0
2021-05-07 12:00:00	NQ	Futures	15968.56	15970.01	15885.76	15910.37	42926.0
2021-05-07 13:00:00	NQ	Futures	15910.66	15912.11	15842.34	15842.92	41920.0
2021-05-07 14:00:00	NQ	Futures	15842.63	15892.71	15820.63	15887.21	39743.0
2021-05-07 15:00:00	NQ	Futures	15887.5	15919.64	15866.95	15871.87	59532.0
2021-05-07 16:00:00	NQ	Futures	15872.16	15892.42	15870.42	15882.29	9249.0
2021-05-07 00:00:00	YM	Futures	38376.6	38390.0	38366.6	38388.9	507.0
2021-05-07 01:00:00	YM	Futures	38387.8	38396.7	38374.4	38383.3	1163.0
2021-05-07 02:00:00	YM	Futures	38382.2	38398.9	38368.8	38396.7	1613.0
2021-05-07 03:00:00	YM	Futures	38395.5	38402.2	38339.9	38363.2	3648.0
2021-05-07 04:00:00	YM	Futures	38364.4	38403.3	38358.8	38397.8	2030.0
2021-05-07 05:00:00	YM	Futures	38398.9	38430.1	38393.3	38426.7	1756.0
2021-05-07 06:00:00	YM	Futures	38425.6	38479.1	38420.1	38459.0	4335.0
2021-05-07 07:00:00	YM	Futures	38457.9	38491.3	38445.7	38491.3	3041.0
2021-05-07 08:00:00	YM	Futures	38491.3	38493.6	38286.4	38341.0	22783.0
2021-05-07 09:00:00	YM	Futures	38339.9	38503.6	38277.5	38451.2	35809.0
2021-05-07 10:00:00	YM	Futures	38452.4	38574.9	38452.4	38545.9	21392.0
2021-05-07 11:00:00	YM	Futures	38543.7	38582.7	38522.5	38551.5	11865.0
2021-05-07 12:00:00	YM	Futures	38552.6	38573.8	38522.5	38563.7	8029.0
2021-05-07 13:00:00	YM	Futures	38564.8	38578.2	38539.2	38571.5	5941.0
2021-05-07 14:00:00	YM	Futures	38571.5	38636.1	38534.8	38611.6	14948.0
2021-05-07 15:00:00	YM	Futures	38611.6	38676.2	38598.3	38625.0	15572.0

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

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