PREVIEW / stock_1hour / 2019-06-10

all stock 1-hour files

  file:    by_date/stock_1hour/2019/2019-06-10.parquet
  size:    1.1 MB
  rows:    49,982
  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-10 04:00:00	AAPL	Stock	47.8025	47.8625	47.7975	47.8625	3384.0
2019-06-10 05:00:00	AAPL	Stock	47.8475	47.8475	47.65	47.65	24400.0
2019-06-10 06:00:00	AAPL	Stock	47.635	47.7625	47.6	47.75	45188.0
2019-06-10 07:00:00	AAPL	Stock	47.75	48.4375	47.75	48.3125	318948.0
2019-06-10 08:00:00	AAPL	Stock	47.8	48.3375	47.8	48.1875	642180.0
2019-06-10 09:00:00	AAPL	Stock	48.1875	48.29	47.9025	48.1825	16565412.0
2019-06-10 10:00:00	AAPL	Stock	48.1825	48.5075	48.14	48.3608	15680772.0
2019-06-10 11:00:00	AAPL	Stock	48.3575	48.8425	48.3375	48.7825	13909332.0
2019-06-10 12:00:00	AAPL	Stock	48.78	48.8258	48.3775	48.405	10684072.0
2019-06-10 13:00:00	AAPL	Stock	48.405	48.5375	48.175	48.225	6806076.0
2019-06-10 14:00:00	AAPL	Stock	48.22	48.325	48.01	48.321	8708232.0
2019-06-10 15:00:00	AAPL	Stock	48.325	48.4125	48.115	48.13	12628444.0
2019-06-10 16:00:00	AAPL	Stock	48.145	48.4102	48.1325	48.1875	6886704.0
2019-06-10 17:00:00	AAPL	Stock	48.2125	48.225	48.1725	48.22	23016.0
2019-06-10 18:00:00	AAPL	Stock	48.2	48.2325	48.175	48.2325	32348.0
2019-06-10 19:00:00	AAPL	Stock	48.2075	48.245	48.185	48.19	27616.0
2019-06-10 04:00:00	MSFT	Stock	132.09	132.25	132.05	132.15	1493.0
2019-06-10 05:00:00	MSFT	Stock	132.2	132.98	132.2	132.8	6867.0
2019-06-10 06:00:00	MSFT	Stock	132.67	132.67	132.39	132.49	4625.0
2019-06-10 07:00:00	MSFT	Stock	132.25	133.43	132.0	133.07	49873.0
2019-06-10 08:00:00	MSFT	Stock	132.25	133.23	132.2	132.8	76401.0
2019-06-10 09:00:00	MSFT	Stock	132.82	133.06	131.94	132.75	3730781.0
2019-06-10 10:00:00	MSFT	Stock	132.748	133.86	132.55	133.43	4173977.0
2019-06-10 11:00:00	MSFT	Stock	133.43	134.08	133.37	133.85	2471209.0
2019-06-10 12:00:00	MSFT	Stock	133.848	133.88	133.08	133.305	2369168.0
2019-06-10 13:00:00	MSFT	Stock	133.31	133.69	133.2	133.46	1835844.0
2019-06-10 14:00:00	MSFT	Stock	133.45	133.47	132.76	133.04	2435728.0
2019-06-10 15:00:00	MSFT	Stock	133.03	133.13	132.465	132.6	3886834.0
2019-06-10 16:00:00	MSFT	Stock	132.6	132.85	132.51	132.78	1886729.0
2019-06-10 17:00:00	MSFT	Stock	132.79	132.84	132.75	132.84	3158.0
2019-06-10 18:00:00	MSFT	Stock	132.75	132.79	132.61	132.64	6283.0
2019-06-10 19:00:00	MSFT	Stock	132.69	132.73	132.6	132.6	8828.0
2019-06-10 04:00:00	NVDA	Stock	3.6668	3.6668	3.6585	3.6585	40000.0
2019-06-10 05:00:00	NVDA	Stock	3.67	3.67	3.6675	3.6675	18920.0
2019-06-10 06:00:00	NVDA	Stock	3.6628	3.6628	3.6625	3.6625	20000.0
2019-06-10 07:00:00	NVDA	Stock	3.67	3.7093	3.6638	3.7093	907120.0
2019-06-10 08:00:00	NVDA	Stock	3.6739	3.712	3.6638	3.685	2831680.0
2019-06-10 09:00:00	NVDA	Stock	3.685	3.7748	3.685	3.726	80268880.0
2019-06-10 10:00:00	NVDA	Stock	3.727	3.76	3.7208	3.747	65690480.0
2019-06-10 11:00:00	NVDA	Stock	3.747	3.7742	3.7465	3.7712	48820880.0
2019-06-10 12:00:00	NVDA	Stock	3.7718	3.7798	3.7415	3.7465	49718680.0
2019-06-10 13:00:00	NVDA	Stock	3.747	3.7525	3.7275	3.738	26650480.0
2019-06-10 14:00:00	NVDA	Stock	3.7375	3.741	3.7102	3.7386	30921160.0
2019-06-10 15:00:00	NVDA	Stock	3.738	3.7445	3.7051	3.7112	55441800.0
2019-06-10 16:00:00	NVDA	Stock	3.7108	3.7384	3.707	3.711	18854720.0
2019-06-10 17:00:00	NVDA	Stock	3.7125	3.715	3.7088	3.713	169000.0
2019-06-10 18:00:00	NVDA	Stock	3.714	3.717	3.7088	3.717	327880.0
2019-06-10 19:00:00	NVDA	Stock	3.7155	3.7155	3.7105	3.7138	164120.0
2019-06-10 07:00:00	AMZN	Stock	90.75	90.9875	90.75	90.95	237000.0
2019-06-10 08:00:00	AMZN	Stock	90.875	91.017	90.67	90.944	514840.0

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

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