PREVIEW / stock_1hour / 2019-06-11

all stock 1-hour files

  file:    by_date/stock_1hour/2019/2019-06-11.parquet
  size:    1.1 MB
  rows:    49,323
  symbols: 2,597

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-06-11 04:00:00	AAPL	Stock	48.4375	48.505	48.4375	48.5	11200.0
2019-06-11 05:00:00	AAPL	Stock	48.5	48.625	48.475	48.6225	41044.0
2019-06-11 06:00:00	AAPL	Stock	48.61	48.725	48.575	48.67	40388.0
2019-06-11 07:00:00	AAPL	Stock	48.6625	48.7375	48.625	48.7075	288272.0
2019-06-11 08:00:00	AAPL	Stock	48.7175	48.8375	48.265	48.6725	365608.0
2019-06-11 09:00:00	AAPL	Stock	48.6925	48.905	48.4775	48.62	14506092.0
2019-06-11 10:00:00	AAPL	Stock	48.6162	49.0	48.5	48.635	20010080.0
2019-06-11 11:00:00	AAPL	Stock	48.635	48.8075	48.54	48.6175	9934572.0
2019-06-11 12:00:00	AAPL	Stock	48.6125	48.6375	48.4	48.44	9518900.0
2019-06-11 13:00:00	AAPL	Stock	48.43	48.635	48.42	48.6025	5737264.0
2019-06-11 14:00:00	AAPL	Stock	48.6025	48.705	48.4725	48.61	6922028.0
2019-06-11 15:00:00	AAPL	Stock	48.61	48.79	48.4975	48.7025	12864608.0
2019-06-11 16:00:00	AAPL	Stock	48.7025	48.71	48.635	48.6625	6555240.0
2019-06-11 17:00:00	AAPL	Stock	48.6675	48.7025	48.665	48.6875	7555908.0
2019-06-11 18:00:00	AAPL	Stock	48.685	48.6875	48.63	48.6375	34208.0
2019-06-11 19:00:00	AAPL	Stock	48.6375	48.675	48.555	48.555	52552.0
2019-06-11 04:00:00	MSFT	Stock	133.22	133.22	133.18	133.18	443.0
2019-06-11 06:00:00	MSFT	Stock	133.4	133.88	133.4	133.55	6987.0
2019-06-11 07:00:00	MSFT	Stock	133.55	133.78	133.47	133.62	30710.0
2019-06-11 08:00:00	MSFT	Stock	133.5	133.84	132.93	133.48	105181.0
2019-06-11 09:00:00	MSFT	Stock	133.65	134.24	132.76	133.475	2853566.0
2019-06-11 10:00:00	MSFT	Stock	133.46	133.7	131.93	132.08	3317561.0
2019-06-11 11:00:00	MSFT	Stock	132.075	132.3	131.41	131.855	2292446.0
2019-06-11 12:00:00	MSFT	Stock	131.86	131.89	131.38	131.5	2169007.0
2019-06-11 13:00:00	MSFT	Stock	131.49	131.78	131.276	131.77	1366431.0
2019-06-11 14:00:00	MSFT	Stock	131.78	132.14	131.46	131.59	1457945.0
2019-06-11 15:00:00	MSFT	Stock	131.58	132.22	131.46	132.1	2544505.0
2019-06-11 16:00:00	MSFT	Stock	132.1	132.1	131.82	132.09	2261639.0
2019-06-11 17:00:00	MSFT	Stock	132.09	132.1	132.01	132.08	2535570.0
2019-06-11 18:00:00	MSFT	Stock	132.05	132.08	131.91	131.91	2074.0
2019-06-11 19:00:00	MSFT	Stock	132.1	132.1	132.01	132.1	6125.0
2019-06-11 04:00:00	NVDA	Stock	3.7348	3.755	3.7348	3.75	88360.0
2019-06-11 05:00:00	NVDA	Stock	3.755	3.755	3.7475	3.7475	34800.0
2019-06-11 06:00:00	NVDA	Stock	3.745	3.7513	3.745	3.7513	170120.0
2019-06-11 07:00:00	NVDA	Stock	3.745	3.7625	3.745	3.76	604360.0
2019-06-11 08:00:00	NVDA	Stock	3.7625	3.771	3.749	3.76	2262920.0
2019-06-11 09:00:00	NVDA	Stock	3.7675	3.785	3.7425	3.758	73331840.0
2019-06-11 10:00:00	NVDA	Stock	3.7595	3.809	3.7595	3.8002	81746680.0
2019-06-11 11:00:00	NVDA	Stock	3.8015	3.8025	3.755	3.76	41527400.0
2019-06-11 12:00:00	NVDA	Stock	3.7595	3.7668	3.729	3.7365	39005040.0
2019-06-11 13:00:00	NVDA	Stock	3.7358	3.7615	3.7348	3.7605	26598960.0
2019-06-11 14:00:00	NVDA	Stock	3.761	3.773	3.7562	3.7708	27544640.0
2019-06-11 15:00:00	NVDA	Stock	3.7698	3.7827	3.7632	3.769	47308560.0
2019-06-11 16:00:00	NVDA	Stock	3.7688	3.774	3.765	3.7688	3575600.0
2019-06-11 17:00:00	NVDA	Stock	3.7705	3.775	3.7662	3.77	721960.0
2019-06-11 18:00:00	NVDA	Stock	3.767	3.7712	3.75	3.7575	201240.0
2019-06-11 19:00:00	NVDA	Stock	3.7625	3.7672	3.7605	3.7612	137240.0
2019-06-11 04:00:00	AMZN	Stock	93.6	93.9805	93.6	93.9805	25160.0
2019-06-11 05:00:00	AMZN	Stock	93.85	93.95	93.85	93.95	26200.0
2019-06-11 06:00:00	AMZN	Stock	94.09	94.187	94.09	94.187	38820.0

> showing 50 of 49,323 rows — these rows as CSV

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