PREVIEW / stock_1hour / 2019-06-25

all stock 1-hour files

  file:    by_date/stock_1hour/2019/2019-06-25.parquet
  size:    1.1 MB
  rows:    49,951
  symbols: 2,612

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-25 04:00:00	AAPL	Stock	49.5625	49.5625	49.4	49.4	2800.0
2019-06-25 05:00:00	AAPL	Stock	49.395	49.4925	49.395	49.4725	15208.0
2019-06-25 06:00:00	AAPL	Stock	49.4175	49.4725	49.41	49.4725	2796.0
2019-06-25 07:00:00	AAPL	Stock	49.4725	49.615	49.4725	49.5375	40152.0
2019-06-25 08:00:00	AAPL	Stock	49.55	49.6875	49.4725	49.6675	99212.0
2019-06-25 09:00:00	AAPL	Stock	49.6875	49.815	49.5625	49.6275	8039892.0
2019-06-25 10:00:00	AAPL	Stock	49.6325	49.67	49.41	49.5625	10173372.0
2019-06-25 11:00:00	AAPL	Stock	49.5625	49.605	49.4	49.445	6004300.0
2019-06-25 12:00:00	AAPL	Stock	49.4412	49.5225	49.2525	49.3412	5261628.0
2019-06-25 13:00:00	AAPL	Stock	49.3425	49.4425	49.1625	49.315	6113548.0
2019-06-25 14:00:00	AAPL	Stock	49.3138	49.3625	49.0075	49.0675	6443512.0
2019-06-25 15:00:00	AAPL	Stock	49.07	49.105	48.8225	48.8925	14186496.0
2019-06-25 16:00:00	AAPL	Stock	48.8925	49.0	48.8925	48.9875	8098936.0
2019-06-25 17:00:00	AAPL	Stock	49.0	49.0275	48.955	48.9875	37688.0
2019-06-25 18:00:00	AAPL	Stock	48.9875	49.0225	48.9375	48.945	39284.0
2019-06-25 19:00:00	AAPL	Stock	48.965	48.965	48.8925	48.905	44208.0
2019-06-25 04:00:00	MSFT	Stock	137.5	137.5	137.35	137.45	4549.0
2019-06-25 05:00:00	MSFT	Stock	137.3	137.5	137.3	137.5	1438.0
2019-06-25 06:00:00	MSFT	Stock	137.49	137.49	137.2	137.41	2892.0
2019-06-25 07:00:00	MSFT	Stock	137.45	137.54	137.2	137.53	23205.0
2019-06-25 08:00:00	MSFT	Stock	137.35	137.65	137.15	137.37	32244.0
2019-06-25 09:00:00	MSFT	Stock	137.35	137.59	136.06	136.22	3198844.0
2019-06-25 10:00:00	MSFT	Stock	136.23	136.28	134.575	134.655	5160344.0
2019-06-25 11:00:00	MSFT	Stock	134.66	135.21	134.47	134.53	2808541.0
2019-06-25 12:00:00	MSFT	Stock	134.527	134.77	133.71	133.94	3251826.0
2019-06-25 13:00:00	MSFT	Stock	133.94	134.26	133.36	133.835	2837974.0
2019-06-25 14:00:00	MSFT	Stock	133.833	133.91	132.73	133.185	3188367.0
2019-06-25 15:00:00	MSFT	Stock	133.2	133.63	132.9	133.43	5429385.0
2019-06-25 16:00:00	MSFT	Stock	133.43	133.67	133.4	133.66	3051159.0
2019-06-25 17:00:00	MSFT	Stock	133.53	133.69	133.53	133.68	6720.0
2019-06-25 18:00:00	MSFT	Stock	133.7	133.7	133.6	133.65	3743.0
2019-06-25 19:00:00	MSFT	Stock	133.6	133.7	133.3	133.45	18848.0
2019-06-25 06:00:00	NVDA	Stock	3.8298	3.837	3.8202	3.8202	45360.0
2019-06-25 07:00:00	NVDA	Stock	3.821	3.8268	3.82	3.8268	164040.0
2019-06-25 08:00:00	NVDA	Stock	3.821	3.8264	3.8175	3.8215	381520.0
2019-06-25 09:00:00	NVDA	Stock	3.8245	3.8592	3.8075	3.859	39503760.0
2019-06-25 10:00:00	NVDA	Stock	3.86	3.897	3.8585	3.8665	61961360.0
2019-06-25 11:00:00	NVDA	Stock	3.8665	3.876	3.8583	3.8669	22196160.0
2019-06-25 12:00:00	NVDA	Stock	3.8669	3.8745	3.842	3.842	33295840.0
2019-06-25 13:00:00	NVDA	Stock	3.843	3.8538	3.8275	3.8305	24727800.0
2019-06-25 14:00:00	NVDA	Stock	3.831	3.8379	3.7915	3.7982	25667480.0
2019-06-25 15:00:00	NVDA	Stock	3.7982	3.8026	3.7842	3.787	39078720.0
2019-06-25 16:00:00	NVDA	Stock	3.787	3.8395	3.787	3.8355	26652720.0
2019-06-25 17:00:00	NVDA	Stock	3.8448	3.865	3.8325	3.839	5725040.0
2019-06-25 18:00:00	NVDA	Stock	3.8425	3.8462	3.8312	3.8338	579000.0
2019-06-25 19:00:00	NVDA	Stock	3.8312	3.8312	3.8175	3.82	1191560.0
2019-06-25 07:00:00	AMZN	Stock	95.5	95.5685	95.5	95.5685	12600.0
2019-06-25 08:00:00	AMZN	Stock	95.572	95.934	95.503	95.65	61180.0
2019-06-25 09:00:00	AMZN	Stock	95.6972	95.8193	95.211	95.394	4021080.0
2019-06-25 10:00:00	AMZN	Stock	95.3938	95.6	94.279	94.5525	7356400.0

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

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