PREVIEW / stock_1hour / 2018-10-25

all stock 1-hour files

  file:    by_date/stock_1hour/2018/2018-10-25.parquet
  size:    1.1 MB
  rows:    50,975
  symbols: 2,762

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-25 04:00:00	AAPL	Stock	54.625	54.6925	54.5	54.6725	25408.0
2018-10-25 05:00:00	AAPL	Stock	54.675	55.0	54.6475	54.9875	38544.0
2018-10-25 06:00:00	AAPL	Stock	54.9875	54.9875	54.7025	54.8	59852.0
2018-10-25 07:00:00	AAPL	Stock	54.7325	54.805	54.515	54.555	303728.0
2018-10-25 08:00:00	AAPL	Stock	54.715	54.7775	54.395	54.395	690544.0
2018-10-25 09:00:00	AAPL	Stock	54.375	54.81	54.1875	54.5825	15349448.0
2018-10-25 10:00:00	AAPL	Stock	54.59	54.9925	54.58	54.785	14294624.0
2018-10-25 11:00:00	AAPL	Stock	54.79	55.08	54.5975	54.8725	10510864.0
2018-10-25 12:00:00	AAPL	Stock	54.8678	54.9175	54.65	54.835	6660684.0
2018-10-25 13:00:00	AAPL	Stock	54.8388	54.9225	54.545	54.8325	6603520.0
2018-10-25 14:00:00	AAPL	Stock	54.83	55.2425	54.7375	55.134	9797916.0
2018-10-25 15:00:00	AAPL	Stock	55.135	55.345	54.9175	54.9625	16350712.0
2018-10-25 16:00:00	AAPL	Stock	54.95	54.95	54.25	54.3125	13415828.0
2018-10-25 17:00:00	AAPL	Stock	54.3125	54.3725	53.8125	54.2	644660.0
2018-10-25 18:00:00	AAPL	Stock	54.185	55.1125	53.9175	54.9575	1982480.0
2018-10-25 19:00:00	AAPL	Stock	54.845	55.1975	54.75	54.75	684856.0
2018-10-25 04:00:00	MSFT	Stock	104.75	106.34	104.75	106.34	14274.0
2018-10-25 05:00:00	MSFT	Stock	106.32	107.36	106.28	107.3	16313.0
2018-10-25 06:00:00	MSFT	Stock	107.36	107.36	105.56	105.92	38064.0
2018-10-25 07:00:00	MSFT	Stock	106.0	106.0	104.69	105.15	108306.0
2018-10-25 08:00:00	MSFT	Stock	105.9	106.22	104.7	105.32	346335.0
2018-10-25 09:00:00	MSFT	Stock	105.32	108.97	104.83	108.43	13744780.0
2018-10-25 10:00:00	MSFT	Stock	108.41	109.27	107.2	108.125	9894263.0
2018-10-25 11:00:00	MSFT	Stock	108.12	108.72	107.55	107.72	5107319.0
2018-10-25 12:00:00	MSFT	Stock	107.73	108.1	106.94	107.7	4138423.0
2018-10-25 13:00:00	MSFT	Stock	107.7	108.23	107.37	107.91	3401033.0
2018-10-25 14:00:00	MSFT	Stock	107.91	109.04	107.75	108.759	4118931.0
2018-10-25 15:00:00	MSFT	Stock	108.76	109.15	108.26	108.3	8712554.0
2018-10-25 16:00:00	MSFT	Stock	108.3	108.78	104.69	107.0	6007157.0
2018-10-25 17:00:00	MSFT	Stock	106.87	106.87	106.01	106.68	81590.0
2018-10-25 18:00:00	MSFT	Stock	106.72	106.95	106.04	106.76	29524.0
2018-10-25 19:00:00	MSFT	Stock	106.83	106.99	106.2	106.63	19331.0
2018-10-25 04:00:00	NVDA	Stock	4.8835	4.922	4.872	4.9072	295000.0
2018-10-25 05:00:00	NVDA	Stock	4.9118	4.9575	4.9075	4.95	211960.0
2018-10-25 06:00:00	NVDA	Stock	4.9695	4.9695	4.92	4.925	156160.0
2018-10-25 07:00:00	NVDA	Stock	4.925	4.925	4.8378	4.8828	961720.0
2018-10-25 08:00:00	NVDA	Stock	4.8351	4.925	4.8316	4.857	3270040.0
2018-10-25 09:00:00	NVDA	Stock	4.8612	4.9805	4.8421	4.9684	195915440.0
2018-10-25 10:00:00	NVDA	Stock	4.9678	5.0248	4.8625	4.8832	160737000.0
2018-10-25 11:00:00	NVDA	Stock	4.8832	5.1133	4.8655	5.0864	133878800.0
2018-10-25 12:00:00	NVDA	Stock	5.0852	5.1363	5.0388	5.07	104151160.0
2018-10-25 13:00:00	NVDA	Stock	5.0728	5.1678	5.053	5.142	61328560.0
2018-10-25 14:00:00	NVDA	Stock	5.1429	5.2438	5.129	5.2213	90371440.0
2018-10-25 15:00:00	NVDA	Stock	5.221	5.2348	5.1775	5.1973	89960640.0
2018-10-25 16:00:00	NVDA	Stock	5.196	5.196	4.872	5.075	3849680.0
2018-10-25 17:00:00	NVDA	Stock	5.085	5.085	5.0	5.0425	2206760.0
2018-10-25 18:00:00	NVDA	Stock	5.0242	5.0744	4.988	5.065	1452920.0
2018-10-25 19:00:00	NVDA	Stock	5.0813	5.1	5.0502	5.0502	728200.0
2018-10-25 04:00:00	AMZN	Stock	84.995	85.201	84.995	85.126	27440.0
2018-10-25 05:00:00	AMZN	Stock	85.25	85.375	85.23	85.375	27100.0

> showing 50 of 50,975 rows — these rows as CSV

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