PREVIEW / stock_1hour / 2019-05-08

all stock 1-hour files

  file:    by_date/stock_1hour/2019/2019-05-08.parquet
  size:    1.1 MB
  rows:    49,459
  symbols: 2,590

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-05-08 04:00:00	AAPL	Stock	50.7625	51.0675	50.7625	50.935	48756.0
2019-05-08 05:00:00	AAPL	Stock	50.875	50.935	50.6025	50.63	51596.0
2019-05-08 06:00:00	AAPL	Stock	50.6075	50.6275	50.4875	50.6275	79956.0
2019-05-08 07:00:00	AAPL	Stock	50.625	50.6625	50.175	50.3	412124.0
2019-05-08 08:00:00	AAPL	Stock	50.5475	50.675	50.2125	50.5525	1129688.0
2019-05-08 09:00:00	AAPL	Stock	50.5525	51.19	50.4025	51.1815	18715780.0
2019-05-08 10:00:00	AAPL	Stock	51.175	51.245	50.7425	51.215	15337540.0
2019-05-08 11:00:00	AAPL	Stock	51.2138	51.335	50.88	50.88	14867176.0
2019-05-08 12:00:00	AAPL	Stock	50.885	51.0805	50.7525	51.06	8634724.0
2019-05-08 13:00:00	AAPL	Stock	51.065	51.13	50.98	51.0775	5040256.0
2019-05-08 14:00:00	AAPL	Stock	51.0825	51.162	50.99	51.0952	4839964.0
2019-05-08 15:00:00	AAPL	Stock	51.0975	51.2125	50.635	50.725	12762292.0
2019-05-08 16:00:00	AAPL	Stock	50.725	50.875	50.725	50.78	9586748.0
2019-05-08 17:00:00	AAPL	Stock	50.78	50.8125	50.725	50.7475	28368.0
2019-05-08 18:00:00	AAPL	Stock	50.7475	50.7775	50.7375	50.775	46020.0
2019-05-08 19:00:00	AAPL	Stock	50.7775	50.8	50.75	50.775	37676.0
2019-05-08 04:00:00	MSFT	Stock	125.8	126.4	125.8	125.88	2950.0
2019-05-08 05:00:00	MSFT	Stock	126.12	126.12	125.5	125.5	2257.0
2019-05-08 06:00:00	MSFT	Stock	125.25	125.8	125.25	125.8	575.0
2019-05-08 07:00:00	MSFT	Stock	125.25	125.25	124.6	124.92	29755.0
2019-05-08 08:00:00	MSFT	Stock	124.6	125.89	124.6	125.15	52621.0
2019-05-08 09:00:00	MSFT	Stock	125.1	125.84	124.75	125.33	3507146.0
2019-05-08 10:00:00	MSFT	Stock	125.33	125.88	124.985	125.86	3434624.0
2019-05-08 11:00:00	MSFT	Stock	125.86	126.18	125.29	125.53	3214817.0
2019-05-08 12:00:00	MSFT	Stock	125.54	126.21	125.34	126.18	1478144.0
2019-05-08 13:00:00	MSFT	Stock	126.19	126.31	125.92	126.18	1253523.0
2019-05-08 14:00:00	MSFT	Stock	126.19	126.21	125.79	126.01	1242023.0
2019-05-08 15:00:00	MSFT	Stock	126.02	126.37	125.43	125.44	4132912.0
2019-05-08 16:00:00	MSFT	Stock	125.47	125.73	125.38	125.55	4063362.0
2019-05-08 17:00:00	MSFT	Stock	125.58	125.64	125.51	125.52	4383.0
2019-05-08 18:00:00	MSFT	Stock	125.52	125.6	125.21	125.31	5457.0
2019-05-08 19:00:00	MSFT	Stock	125.43	125.58	125.41	125.5	8418.0
2019-05-08 04:00:00	NVDA	Stock	4.3748	4.3748	4.3685	4.3685	30440.0
2019-05-08 05:00:00	NVDA	Stock	4.3468	4.3468	4.3208	4.3208	90800.0
2019-05-08 06:00:00	NVDA	Stock	4.3125	4.3125	4.2875	4.2875	188360.0
2019-05-08 07:00:00	NVDA	Stock	4.289	4.3	4.2625	4.275	1036080.0
2019-05-08 08:00:00	NVDA	Stock	4.3	4.3385	4.2565	4.3162	5811360.0
2019-05-08 09:00:00	NVDA	Stock	4.3128	4.4032	4.288	4.3813	79159440.0
2019-05-08 10:00:00	NVDA	Stock	4.3818	4.4152	4.3648	4.4142	70726600.0
2019-05-08 11:00:00	NVDA	Stock	4.414	4.4288	4.3875	4.3968	62206240.0
2019-05-08 12:00:00	NVDA	Stock	4.3982	4.4045	4.3752	4.3922	36213000.0
2019-05-08 13:00:00	NVDA	Stock	4.3928	4.4012	4.3738	4.3903	25231680.0
2019-05-08 14:00:00	NVDA	Stock	4.3905	4.3992	4.373	4.3897	23851080.0
2019-05-08 15:00:00	NVDA	Stock	4.3905	4.4055	4.3455	4.347	55583760.0
2019-05-08 16:00:00	NVDA	Stock	4.348	4.36	4.3452	4.3512	20930000.0
2019-05-08 17:00:00	NVDA	Stock	4.3525	4.3572	4.3438	4.348	239440.0
2019-05-08 18:00:00	NVDA	Stock	4.3525	4.3525	4.344	4.35	105400.0
2019-05-08 19:00:00	NVDA	Stock	4.3525	4.355	4.345	4.3508	176640.0
2019-05-08 04:00:00	AMZN	Stock	96.3815	96.3815	96.0505	96.0505	4000.0
2019-05-08 05:00:00	AMZN	Stock	96.321	96.321	95.8475	95.8475	13160.0

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

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