PREVIEW / stock_1hour / 2019-03-22

all stock 1-hour files

  file:    by_date/stock_1hour/2019/2019-03-22.parquet
  size:    1.1 MB
  rows:    50,214
  symbols: 2,627

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-03-22 04:00:00	AAPL	Stock	49.1	49.25	48.88	48.88	66340.0
2019-03-22 05:00:00	AAPL	Stock	48.9425	48.945	48.7875	48.8875	33296.0
2019-03-22 06:00:00	AAPL	Stock	48.8875	48.8875	48.7725	48.7725	23832.0
2019-03-22 07:00:00	AAPL	Stock	48.7975	48.925	48.7975	48.855	202428.0
2019-03-22 08:00:00	AAPL	Stock	48.835	48.9225	48.6325	48.7725	1233872.0
2019-03-22 09:00:00	AAPL	Stock	48.76	49.4225	48.5025	48.6225	33202288.0
2019-03-22 10:00:00	AAPL	Stock	48.6225	49.1225	48.6025	48.705	26528728.0
2019-03-22 11:00:00	AAPL	Stock	48.7075	48.7225	48.2275	48.2375	20086824.0
2019-03-22 12:00:00	AAPL	Stock	48.235	48.415	48.0075	48.19	14862396.0
2019-03-22 13:00:00	AAPL	Stock	48.19	48.36	48.005	48.03	8814808.0
2019-03-22 14:00:00	AAPL	Stock	48.0325	48.3725	48.0125	48.35	9932104.0
2019-03-22 15:00:00	AAPL	Stock	48.3525	48.4125	47.695	47.765	25446908.0
2019-03-22 16:00:00	AAPL	Stock	47.7625	48.5458	47.7375	47.7875	10713764.0
2019-03-22 17:00:00	AAPL	Stock	47.8	47.8125	47.7625	47.8125	201784.0
2019-03-22 18:00:00	AAPL	Stock	47.7875	47.82	47.775	47.79	92004.0
2019-03-22 19:00:00	AAPL	Stock	47.8125	47.82	47.75	47.75	74528.0
2019-03-22 04:00:00	MSFT	Stock	119.92	119.92	119.16	119.16	865.0
2019-03-22 05:00:00	MSFT	Stock	119.95	120.0	119.54	119.7	3985.0
2019-03-22 06:00:00	MSFT	Stock	119.75	119.75	119.6	119.68	1790.0
2019-03-22 07:00:00	MSFT	Stock	119.67	119.95	119.51	119.6	14891.0
2019-03-22 08:00:00	MSFT	Stock	119.628	119.72	119.25	119.5	56817.0
2019-03-22 09:00:00	MSFT	Stock	119.48	119.59	118.24	118.56	3110510.0
2019-03-22 10:00:00	MSFT	Stock	118.57	119.34	118.42	118.66	3315753.0
2019-03-22 11:00:00	MSFT	Stock	118.65	118.8	117.785	117.79	3494087.0
2019-03-22 12:00:00	MSFT	Stock	117.799	118.21	117.615	118.15	3057213.0
2019-03-22 13:00:00	MSFT	Stock	118.15	118.25	117.48	117.57	1996339.0
2019-03-22 14:00:00	MSFT	Stock	117.575	118.43	117.55	118.256	2049132.0
2019-03-22 15:00:00	MSFT	Stock	118.25	118.42	117.04	117.05	6740837.0
2019-03-22 16:00:00	MSFT	Stock	117.05	117.25	116.94	117.08	5029770.0
2019-03-22 17:00:00	MSFT	Stock	117.1	117.1	116.86	116.99	18188.0
2019-03-22 18:00:00	MSFT	Stock	116.99	117.15	116.99	117.04	3153.0
2019-03-22 19:00:00	MSFT	Stock	117.05	117.14	117.05	117.14	870.0
2019-03-22 04:00:00	NVDA	Stock	4.6123	4.625	4.5922	4.5922	91080.0
2019-03-22 05:00:00	NVDA	Stock	4.5925	4.5938	4.5625	4.575	120760.0
2019-03-22 06:00:00	NVDA	Stock	4.5875	4.5875	4.57	4.5748	84840.0
2019-03-22 07:00:00	NVDA	Stock	4.5703	4.587	4.5678	4.5705	1181960.0
2019-03-22 08:00:00	NVDA	Stock	4.5665	4.5898	4.555	4.5805	3111560.0
2019-03-22 09:00:00	NVDA	Stock	4.575	4.62	4.5205	4.5298	125968520.0
2019-03-22 10:00:00	NVDA	Stock	4.5287	4.5695	4.4878	4.5042	144240880.0
2019-03-22 11:00:00	NVDA	Stock	4.5058	4.5058	4.433	4.433	115810520.0
2019-03-22 12:00:00	NVDA	Stock	4.4328	4.4807	4.43	4.4775	86427960.0
2019-03-22 13:00:00	NVDA	Stock	4.4775	4.4895	4.427	4.4311	59074240.0
2019-03-22 14:00:00	NVDA	Stock	4.4305	4.4745	4.4305	4.4687	48019320.0
2019-03-22 15:00:00	NVDA	Stock	4.4685	4.4792	4.4235	4.4375	101244440.0
2019-03-22 16:00:00	NVDA	Stock	4.4375	4.4957	4.4288	4.4375	20744280.0
2019-03-22 17:00:00	NVDA	Stock	4.437	4.4385	4.4288	4.436	866800.0
2019-03-22 18:00:00	NVDA	Stock	4.436	4.4412	4.435	4.4362	197880.0
2019-03-22 19:00:00	NVDA	Stock	4.4412	4.4412	4.4335	4.4405	146480.0
2019-03-22 04:00:00	AMZN	Stock	90.9665	91.15	90.6665	90.6665	26180.0
2019-03-22 06:00:00	AMZN	Stock	90.555	90.555	90.5055	90.5055	18320.0

> showing 50 of 50,214 rows — these rows as CSV

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