PREVIEW / stock_1hour / 2018-10-05

all stock 1-hour files

  file:    by_date/stock_1hour/2018/2018-10-05.parquet
  size:    1.1 MB
  rows:    49,252
  symbols: 2,773

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
2018-10-05 04:00:00	AAPL	Stock	56.7675	56.9125	56.7675	56.85	11396.0
2018-10-05 05:00:00	AAPL	Stock	56.7775	56.87	56.775	56.785	11132.0
2018-10-05 06:00:00	AAPL	Stock	56.85	56.9125	56.7875	56.91	6812.0
2018-10-05 07:00:00	AAPL	Stock	56.91	57.025	56.8625	56.9025	94864.0
2018-10-05 08:00:00	AAPL	Stock	57.05	57.125	56.745	56.975	993084.0
2018-10-05 09:00:00	AAPL	Stock	56.97	57.1225	56.4175	56.529	12322920.0
2018-10-05 10:00:00	AAPL	Stock	56.525	56.685	56.32	56.5085	13394604.0
2018-10-05 11:00:00	AAPL	Stock	56.5075	56.515	55.8875	55.9755	15816412.0
2018-10-05 12:00:00	AAPL	Stock	55.98	56.195	55.6825	55.72	11749664.0
2018-10-05 13:00:00	AAPL	Stock	55.715	55.875	55.145	55.8172	20610012.0
2018-10-05 14:00:00	AAPL	Stock	55.816	56.3	55.75	56.235	12795488.0
2018-10-05 15:00:00	AAPL	Stock	56.235	56.345	55.9525	56.065	16786376.0
2018-10-05 16:00:00	AAPL	Stock	56.1175	56.1875	55.975	56.135	7827496.0
2018-10-05 17:00:00	AAPL	Stock	56.1025	56.1225	56.07	56.0725	37132.0
2018-10-05 18:00:00	AAPL	Stock	56.085	56.1	56.0375	56.0375	48896.0
2018-10-05 19:00:00	AAPL	Stock	56.0625	56.0625	55.9875	55.9975	39896.0
2018-10-05 04:00:00	MSFT	Stock	113.0	113.0	112.99	112.99	231.0
2018-10-05 05:00:00	MSFT	Stock	112.77	112.77	112.77	112.77	120.0
2018-10-05 06:00:00	MSFT	Stock	112.79	112.8	112.7	112.8	2324.0
2018-10-05 07:00:00	MSFT	Stock	112.93	112.98	112.74	112.74	3985.0
2018-10-05 08:00:00	MSFT	Stock	112.95	113.33	112.05	112.79	66915.0
2018-10-05 09:00:00	MSFT	Stock	112.76	113.17	111.95	112.09	3466703.0
2018-10-05 10:00:00	MSFT	Stock	112.085	112.6	111.86	112.34	3423505.0
2018-10-05 11:00:00	MSFT	Stock	112.35	112.36	111.38	111.48	3472267.0
2018-10-05 12:00:00	MSFT	Stock	111.5	111.82	111.04	111.13	2481438.0
2018-10-05 13:00:00	MSFT	Stock	111.12	111.84	110.64	111.8	2601583.0
2018-10-05 14:00:00	MSFT	Stock	111.8	112.57	111.79	112.38	2930426.0
2018-10-05 15:00:00	MSFT	Stock	112.38	112.75	112.01	112.12	4723910.0
2018-10-05 16:00:00	MSFT	Stock	112.2	112.35	112.01	112.35	2832955.0
2018-10-05 17:00:00	MSFT	Stock	112.45	112.5	112.27	112.27	15712.0
2018-10-05 18:00:00	MSFT	Stock	112.3	112.3	112.3	112.3	495.0
2018-10-05 19:00:00	MSFT	Stock	112.3	112.37	112.29	112.37	3415.0
2018-10-05 04:00:00	NVDA	Stock	6.95	6.95	6.95	6.95	8000.0
2018-10-05 05:00:00	NVDA	Stock	6.9588	6.9588	6.9588	6.9588	4000.0
2018-10-05 06:00:00	NVDA	Stock	6.9653	6.9653	6.9588	6.9588	12000.0
2018-10-05 07:00:00	NVDA	Stock	6.9738	6.983	6.9638	6.965	133640.0
2018-10-05 08:00:00	NVDA	Stock	6.975	6.9945	6.927	6.963	1342880.0
2018-10-05 09:00:00	NVDA	Stock	6.975	7.02	6.9098	6.9198	30548640.0
2018-10-05 10:00:00	NVDA	Stock	6.9198	6.939	6.8625	6.8842	34243720.0
2018-10-05 11:00:00	NVDA	Stock	6.883	6.8855	6.7603	6.7632	45008480.0
2018-10-05 12:00:00	NVDA	Stock	6.765	6.7895	6.7234	6.7379	36479440.0
2018-10-05 13:00:00	NVDA	Stock	6.7362	6.7422	6.6885	6.7295	47982800.0
2018-10-05 14:00:00	NVDA	Stock	6.73	6.81	6.7192	6.784	50692240.0
2018-10-05 15:00:00	NVDA	Stock	6.7848	6.8137	6.7325	6.7465	72437560.0
2018-10-05 16:00:00	NVDA	Stock	6.7465	6.7939	6.7412	6.7478	6488800.0
2018-10-05 17:00:00	NVDA	Stock	6.7575	6.7585	6.7482	6.7535	195440.0
2018-10-05 18:00:00	NVDA	Stock	6.7532	6.7535	6.739	6.7425	125680.0
2018-10-05 19:00:00	NVDA	Stock	6.7493	6.7498	6.7338	6.7425	342280.0
2018-10-05 04:00:00	AMZN	Stock	95.2	95.2	95.2	95.2	2000.0
2018-10-05 05:00:00	AMZN	Stock	95.25	95.25	95.0505	95.0505	6000.0

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

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