PREVIEW / stock_1hour / 2019-08-16

all stock 1-hour files

  file:    by_date/stock_1hour/2019/2019-08-16.parquet
  size:    1.1 MB
  rows:    50,014
  symbols: 2,567

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-08-16 04:00:00	AAPL	Stock	50.825	51.1825	50.825	51.175	13124.0
2019-08-16 05:00:00	AAPL	Stock	51.1475	51.165	51.0925	51.155	28900.0
2019-08-16 06:00:00	AAPL	Stock	51.155	51.155	51.0875	51.0875	5692.0
2019-08-16 07:00:00	AAPL	Stock	51.125	51.175	51.065	51.0725	121232.0
2019-08-16 08:00:00	AAPL	Stock	51.125	51.175	50.975	51.0125	421496.0
2019-08-16 09:00:00	AAPL	Stock	51.0125	51.25	50.8325	51.18	15886660.0
2019-08-16 10:00:00	AAPL	Stock	51.1725	51.69	51.1025	51.68	19739144.0
2019-08-16 11:00:00	AAPL	Stock	51.675	51.79	51.455	51.5155	13724168.0
2019-08-16 12:00:00	AAPL	Stock	51.5175	51.5875	51.3725	51.5472	7105888.0
2019-08-16 13:00:00	AAPL	Stock	51.5475	51.785	51.545	51.711	7071884.0
2019-08-16 14:00:00	AAPL	Stock	51.7125	51.7162	51.525	51.5382	6464136.0
2019-08-16 15:00:00	AAPL	Stock	51.535	51.7375	51.5188	51.61	14163940.0
2019-08-16 16:00:00	AAPL	Stock	51.61	51.7	50.435	51.7	9001252.0
2019-08-16 17:00:00	AAPL	Stock	51.7125	51.7125	51.625	51.655	59460.0
2019-08-16 18:00:00	AAPL	Stock	51.625	51.675	51.625	51.67	18804.0
2019-08-16 19:00:00	AAPL	Stock	51.6375	51.675	51.6125	51.6125	26656.0
2019-08-16 04:00:00	MSFT	Stock	135.23	135.29	134.76	135.29	674.0
2019-08-16 05:00:00	MSFT	Stock	135.45	135.48	135.38	135.38	1237.0
2019-08-16 07:00:00	MSFT	Stock	135.51	135.51	134.98	134.98	15530.0
2019-08-16 08:00:00	MSFT	Stock	135.21	135.515	134.92	135.061	71253.0
2019-08-16 09:00:00	MSFT	Stock	135.1	135.45	134.56	134.91	3912298.0
2019-08-16 10:00:00	MSFT	Stock	134.92	136.045	134.72	136.03	3225021.0
2019-08-16 11:00:00	MSFT	Stock	136.025	136.2	135.52	135.85	2233288.0
2019-08-16 12:00:00	MSFT	Stock	135.85	136.24	135.51	135.99	1797309.0
2019-08-16 13:00:00	MSFT	Stock	135.99	136.33	135.9	136.166	1597631.0
2019-08-16 14:00:00	MSFT	Stock	136.17	136.19	135.645	135.84	1274677.0
2019-08-16 15:00:00	MSFT	Stock	135.84	136.46	135.68	136.13	3971349.0
2019-08-16 16:00:00	MSFT	Stock	136.13	136.13	133.68	136.0	3451577.0
2019-08-16 17:00:00	MSFT	Stock	136.11	136.21	136.0	136.09	26976.0
2019-08-16 18:00:00	MSFT	Stock	136.1	136.14	136.08	136.14	1777.0
2019-08-16 19:00:00	MSFT	Stock	136.07	136.14	136.05	136.1	1307.0
2019-08-16 04:00:00	NVDA	Stock	3.9378	3.9475	3.8	3.9092	781800.0
2019-08-16 05:00:00	NVDA	Stock	3.91	3.9312	3.91	3.93	473400.0
2019-08-16 06:00:00	NVDA	Stock	3.9298	3.95	3.9298	3.9482	892720.0
2019-08-16 07:00:00	NVDA	Stock	3.9462	3.95	3.9375	3.9428	3933680.0
2019-08-16 08:00:00	NVDA	Stock	3.9438	3.9625	3.9075	3.9312	8801800.0
2019-08-16 09:00:00	NVDA	Stock	3.9315	4.0385	3.9255	3.9873	298091480.0
2019-08-16 10:00:00	NVDA	Stock	3.9859	3.99	3.9378	3.9778	159997520.0
2019-08-16 11:00:00	NVDA	Stock	3.9788	3.98	3.922	3.9352	100477720.0
2019-08-16 12:00:00	NVDA	Stock	3.936	3.954	3.925	3.942	66097160.0
2019-08-16 13:00:00	NVDA	Stock	3.9425	3.975	3.9425	3.973	58112400.0
2019-08-16 14:00:00	NVDA	Stock	3.9737	4.0024	3.9633	4.0005	83543680.0
2019-08-16 15:00:00	NVDA	Stock	4.0008	4.0198	3.986	3.9873	156306520.0
2019-08-16 16:00:00	NVDA	Stock	3.989	3.995	3.7193	3.9938	30856760.0
2019-08-16 17:00:00	NVDA	Stock	3.9912	3.995	3.9888	3.995	707720.0
2019-08-16 18:00:00	NVDA	Stock	3.9938	3.998	3.9938	3.9962	269720.0
2019-08-16 19:00:00	NVDA	Stock	3.9962	3.9998	3.9913	3.9913	626640.0
2019-08-16 04:00:00	AMZN	Stock	89.3675	90.05	89.3675	90.05	34820.0
2019-08-16 05:00:00	AMZN	Stock	90.19	90.25	90.025	90.044	47580.0
2019-08-16 06:00:00	AMZN	Stock	90.1175	90.1175	90.1175	90.1175	2900.0

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

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