PREVIEW / stock_1hour / 2019-06-03

all stock 1-hour files

  file:    by_date/stock_1hour/2019/2019-06-03.parquet
  size:    1.1 MB
  rows:    50,393
  symbols: 2,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
2019-06-03 04:00:00	AAPL	Stock	43.425	43.55	43.35	43.525	93572.0
2019-06-03 05:00:00	AAPL	Stock	43.5525	43.6625	43.55	43.655	37340.0
2019-06-03 06:00:00	AAPL	Stock	43.655	43.6975	43.5825	43.625	51224.0
2019-06-03 07:00:00	AAPL	Stock	43.65	43.8875	43.65	43.775	101316.0
2019-06-03 08:00:00	AAPL	Stock	43.8875	44.08	43.61	44.08	354260.0
2019-06-03 09:00:00	AAPL	Stock	44.08	44.48	43.86	44.255	16813564.0
2019-06-03 10:00:00	AAPL	Stock	44.25	44.32	43.9665	44.3	16062056.0
2019-06-03 11:00:00	AAPL	Stock	44.2975	44.365	44.105	44.1618	8962840.0
2019-06-03 12:00:00	AAPL	Stock	44.16	44.1975	43.795	43.9125	9818820.0
2019-06-03 13:00:00	AAPL	Stock	43.915	44.2888	42.5675	43.3825	37583004.0
2019-06-03 14:00:00	AAPL	Stock	43.385	43.55	42.985	43.0775	14850876.0
2019-06-03 15:00:00	AAPL	Stock	43.075	43.4225	42.8675	43.32	24030992.0
2019-06-03 16:00:00	AAPL	Stock	43.325	43.415	43.25	43.4125	10736880.0
2019-06-03 17:00:00	AAPL	Stock	43.425	43.5	43.335	43.38	59460.0
2019-06-03 18:00:00	AAPL	Stock	43.475	43.49	43.325	43.4775	33340.0
2019-06-03 19:00:00	AAPL	Stock	43.475	43.54	43.4525	43.525	55456.0
2019-06-03 04:00:00	MSFT	Stock	122.15	122.88	122.15	122.85	3425.0
2019-06-03 05:00:00	MSFT	Stock	122.9	123.08	122.8	123.08	1050.0
2019-06-03 06:00:00	MSFT	Stock	123.0	123.22	123.0	123.17	3495.0
2019-06-03 07:00:00	MSFT	Stock	123.11	123.55	123.11	123.3	5739.0
2019-06-03 08:00:00	MSFT	Stock	123.35	123.55	123.12	123.5	44476.0
2019-06-03 09:00:00	MSFT	Stock	123.543	124.37	121.9	121.933	3480626.0
2019-06-03 10:00:00	MSFT	Stock	121.92	122.86	121.47	122.81	3788821.0
2019-06-03 11:00:00	MSFT	Stock	122.8	122.93	121.93	122.075	2549124.0
2019-06-03 12:00:00	MSFT	Stock	122.07	122.19	120.97	121.025	3569978.0
2019-06-03 13:00:00	MSFT	Stock	121.02	121.56	120.24	120.63	4112435.0
2019-06-03 14:00:00	MSFT	Stock	120.63	120.81	119.62	119.75	3465066.0
2019-06-03 15:00:00	MSFT	Stock	119.76	120.09	119.01	119.88	7847994.0
2019-06-03 16:00:00	MSFT	Stock	120.0	120.49	119.84	120.1	4054938.0
2019-06-03 17:00:00	MSFT	Stock	120.2	120.45	120.15	120.34	24237.0
2019-06-03 18:00:00	MSFT	Stock	120.41	120.47	119.84	120.32	18656.0
2019-06-03 19:00:00	MSFT	Stock	120.22	120.22	120.12	120.15	3591.0
2019-06-03 04:00:00	NVDA	Stock	3.3615	3.364	3.3388	3.364	137600.0
2019-06-03 05:00:00	NVDA	Stock	3.3678	3.3763	3.3678	3.3763	26480.0
2019-06-03 06:00:00	NVDA	Stock	3.3688	3.3763	3.3638	3.365	75080.0
2019-06-03 07:00:00	NVDA	Stock	3.3798	3.3975	3.3752	3.3938	476360.0
2019-06-03 08:00:00	NVDA	Stock	3.3925	3.415	3.375	3.4138	1847800.0
2019-06-03 09:00:00	NVDA	Stock	3.4125	3.4368	3.388	3.4215	76620120.0
2019-06-03 10:00:00	NVDA	Stock	3.4178	3.432	3.3865	3.4035	64034440.0
2019-06-03 11:00:00	NVDA	Stock	3.4035	3.407	3.37	3.3749	55863560.0
2019-06-03 12:00:00	NVDA	Stock	3.3742	3.3787	3.342	3.353	47627200.0
2019-06-03 13:00:00	NVDA	Stock	3.3535	3.3805	3.3375	3.3661	35114080.0
2019-06-03 14:00:00	NVDA	Stock	3.3672	3.3724	3.33	3.3331	30808240.0
2019-06-03 15:00:00	NVDA	Stock	3.3335	3.3455	3.315	3.3445	82641280.0
2019-06-03 16:00:00	NVDA	Stock	3.3445	3.3623	3.3292	3.3623	4214920.0
2019-06-03 17:00:00	NVDA	Stock	3.36	3.3632	3.3562	3.3609	435880.0
2019-06-03 18:00:00	NVDA	Stock	3.3625	3.3625	3.3565	3.3565	86480.0
2019-06-03 19:00:00	NVDA	Stock	3.3562	3.3605	3.35	3.35	386280.0
2019-06-03 04:00:00	AMZN	Stock	87.425	87.75	87.425	87.75	138940.0
2019-06-03 05:00:00	AMZN	Stock	87.85	87.95	87.85	87.95	59820.0

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

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