PREVIEW / stock_1hour / 2019-08-15

all stock 1-hour files

  file:    by_date/stock_1hour/2019/2019-08-15.parquet
  size:    1.1 MB
  rows:    51,167
  symbols: 2,556

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-08-15 04:00:00	AAPL	Stock	50.9175	51.05	50.825	50.9	27032.0
2019-08-15 05:00:00	AAPL	Stock	50.9	50.9	50.13	50.2	30104.0
2019-08-15 06:00:00	AAPL	Stock	50.1925	50.25	49.7825	50.005	75824.0
2019-08-15 07:00:00	AAPL	Stock	50.05	50.9625	49.9075	50.875	780732.0
2019-08-15 08:00:00	AAPL	Stock	50.0202	51.2025	49.9625	51.075	725112.0
2019-08-15 09:00:00	AAPL	Stock	51.07	51.285	50.51	50.8875	17498072.0
2019-08-15 10:00:00	AAPL	Stock	50.8775	50.9375	50.4175	50.52	14659780.0
2019-08-15 11:00:00	AAPL	Stock	50.5175	50.5502	50.1325	50.54	12383684.0
2019-08-15 12:00:00	AAPL	Stock	50.545	50.675	50.4575	50.5425	8302336.0
2019-08-15 13:00:00	AAPL	Stock	50.54	50.6575	49.9175	50.0525	9046300.0
2019-08-15 14:00:00	AAPL	Stock	50.0525	50.285	49.97	50.1775	9045972.0
2019-08-15 15:00:00	AAPL	Stock	50.1875	50.625	50.1875	50.435	12756528.0
2019-08-15 16:00:00	AAPL	Stock	50.435	50.523	50.4125	50.475	7914040.0
2019-08-15 17:00:00	AAPL	Stock	50.435	50.575	50.435	50.525	2348136.0
2019-08-15 18:00:00	AAPL	Stock	50.5375	50.65	50.435	50.625	40372.0
2019-08-15 19:00:00	AAPL	Stock	50.58	50.67	50.58	50.6275	53092.0
2019-08-15 04:00:00	MSFT	Stock	134.52	134.7	134.38	134.7	1765.0
2019-08-15 05:00:00	MSFT	Stock	134.7	134.7	132.34	133.07	3604.0
2019-08-15 06:00:00	MSFT	Stock	133.0	133.0	132.31	132.74	41981.0
2019-08-15 07:00:00	MSFT	Stock	132.69	134.55	132.56	134.54	35375.0
2019-08-15 08:00:00	MSFT	Stock	132.8	135.11	132.57	134.96	85881.0
2019-08-15 09:00:00	MSFT	Stock	134.79	135.09	132.25	133.77	3845336.0
2019-08-15 10:00:00	MSFT	Stock	133.76	134.06	133.04	133.13	3090373.0
2019-08-15 11:00:00	MSFT	Stock	133.13	133.725	132.6	133.67	2954115.0
2019-08-15 12:00:00	MSFT	Stock	133.68	134.1	133.38	133.55	1877306.0
2019-08-15 13:00:00	MSFT	Stock	133.551	133.85	132.45	132.67	1844180.0
2019-08-15 14:00:00	MSFT	Stock	132.69	133.52	132.45	133.43	2276564.0
2019-08-15 15:00:00	MSFT	Stock	133.45	134.18	133.43	133.691	3564622.0
2019-08-15 16:00:00	MSFT	Stock	133.68	133.89	133.41	133.85	3333924.0
2019-08-15 17:00:00	MSFT	Stock	133.85	133.98	133.683	133.9	29659.0
2019-08-15 18:00:00	MSFT	Stock	133.81	134.05	133.81	134.05	3106.0
2019-08-15 19:00:00	MSFT	Stock	134.05	134.25	134.0	134.25	6731.0
2019-08-15 04:00:00	NVDA	Stock	3.7712	3.7895	3.769	3.7895	101080.0
2019-08-15 05:00:00	NVDA	Stock	3.7618	3.7618	3.703	3.7142	94000.0
2019-08-15 06:00:00	NVDA	Stock	3.725	3.725	3.675	3.6892	217120.0
2019-08-15 07:00:00	NVDA	Stock	3.6965	3.775	3.6965	3.7625	1583520.0
2019-08-15 08:00:00	NVDA	Stock	3.6881	3.79	3.6878	3.78	2792320.0
2019-08-15 09:00:00	NVDA	Stock	3.7778	3.7928	3.7438	3.7678	60686920.0
2019-08-15 10:00:00	NVDA	Stock	3.769	3.7725	3.7155	3.7205	51827600.0
2019-08-15 11:00:00	NVDA	Stock	3.7215	3.7242	3.6903	3.7076	51912840.0
2019-08-15 12:00:00	NVDA	Stock	3.708	3.7528	3.7042	3.712	32195040.0
2019-08-15 13:00:00	NVDA	Stock	3.7112	3.74	3.6915	3.6915	41325600.0
2019-08-15 14:00:00	NVDA	Stock	3.6925	3.7125	3.6849	3.7096	62496160.0
2019-08-15 15:00:00	NVDA	Stock	3.71	3.7408	3.71	3.72	94583960.0
2019-08-15 16:00:00	NVDA	Stock	3.7193	3.995	3.6775	3.9448	93404320.0
2019-08-15 17:00:00	NVDA	Stock	3.9452	3.9628	3.91	3.94	28797080.0
2019-08-15 18:00:00	NVDA	Stock	3.9435	3.9448	3.7193	3.91	9450840.0
2019-08-15 19:00:00	NVDA	Stock	3.911	3.9438	3.9098	3.9272	4652400.0
2019-08-15 04:00:00	AMZN	Stock	88.75	89.15	88.75	89.15	31740.0
2019-08-15 05:00:00	AMZN	Stock	88.4345	88.4345	87.665	87.75	20680.0

> showing 50 of 51,167 rows — these rows as CSV

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