PREVIEW / stock_1hour / 2018-10-30

all stock 1-hour files

  file:    by_date/stock_1hour/2018/2018-10-30.parquet
  size:    1.1 MB
  rows:    49,466
  symbols: 2,760

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-30 04:00:00	AAPL	Stock	53.2775	53.6925	53.2775	53.45	43992.0
2018-10-30 05:00:00	AAPL	Stock	53.375	53.375	53.0625	53.2325	77504.0
2018-10-30 06:00:00	AAPL	Stock	53.2075	53.375	53.2025	53.22	34532.0
2018-10-30 07:00:00	AAPL	Stock	53.22	53.4	53.0725	53.3	341716.0
2018-10-30 08:00:00	AAPL	Stock	53.3125	53.4625	52.8	52.875	1143664.0
2018-10-30 09:00:00	AAPL	Stock	52.8875	53.795	52.3175	53.7125	22316640.0
2018-10-30 10:00:00	AAPL	Stock	53.7125	53.7425	52.8325	53.0212	21055512.0
2018-10-30 11:00:00	AAPL	Stock	53.0312	53.625	52.937	53.2175	13847516.0
2018-10-30 12:00:00	AAPL	Stock	53.2275	53.515	53.0625	53.1115	8806112.0
2018-10-30 13:00:00	AAPL	Stock	53.1075	53.265	52.7125	53.2368	12233860.0
2018-10-30 14:00:00	AAPL	Stock	53.2328	53.3375	52.8638	53.24	9870680.0
2018-10-30 15:00:00	AAPL	Stock	53.2475	53.4325	53.025	53.3325	19052532.0
2018-10-30 16:00:00	AAPL	Stock	53.3325	53.625	53.125	53.6	13998288.0
2018-10-30 17:00:00	AAPL	Stock	53.5975	53.7	53.25	53.675	636700.0
2018-10-30 18:00:00	AAPL	Stock	53.675	53.7	53.575	53.595	183064.0
2018-10-30 19:00:00	AAPL	Stock	53.5875	53.7375	53.545	53.725	87740.0
2018-10-30 04:00:00	MSFT	Stock	104.5	104.5	104.5	104.5	1200.0
2018-10-30 05:00:00	MSFT	Stock	104.5	104.5	103.83	104.34	2779.0
2018-10-30 06:00:00	MSFT	Stock	104.1	104.29	104.05	104.2	3790.0
2018-10-30 07:00:00	MSFT	Stock	104.05	104.57	103.85	104.5	41302.0
2018-10-30 08:00:00	MSFT	Stock	104.3	104.88	103.65	103.8	184620.0
2018-10-30 09:00:00	MSFT	Stock	103.93	104.38	102.61	104.02	5566884.0
2018-10-30 10:00:00	MSFT	Stock	104.025	104.21	101.65	102.31	9739089.0
2018-10-30 11:00:00	MSFT	Stock	102.33	103.33	101.67	102.39	7489792.0
2018-10-30 12:00:00	MSFT	Stock	102.4	102.65	101.13	101.2	5575932.0
2018-10-30 13:00:00	MSFT	Stock	101.2	101.71	100.11	101.63	9292777.0
2018-10-30 14:00:00	MSFT	Stock	101.63	102.98	101.15	102.82	6827286.0
2018-10-30 15:00:00	MSFT	Stock	102.82	104.02	102.55	103.75	10707328.0
2018-10-30 16:00:00	MSFT	Stock	103.75	104.0	103.25	103.95	4660568.0
2018-10-30 17:00:00	MSFT	Stock	103.93	103.97	103.06	103.8	42779.0
2018-10-30 18:00:00	MSFT	Stock	103.97	104.0	103.6	103.73	18864.0
2018-10-30 19:00:00	MSFT	Stock	103.72	103.94	103.6	103.89	20160.0
2018-10-30 04:00:00	NVDA	Stock	4.64	4.757	4.64	4.7262	163680.0
2018-10-30 05:00:00	NVDA	Stock	4.7252	4.8223	4.7138	4.775	612520.0
2018-10-30 06:00:00	NVDA	Stock	4.7638	4.77	4.7438	4.7438	126280.0
2018-10-30 07:00:00	NVDA	Stock	4.7252	4.7375	4.6832	4.7165	885520.0
2018-10-30 08:00:00	NVDA	Stock	4.7346	4.7428	4.6742	4.6882	2857080.0
2018-10-30 09:00:00	NVDA	Stock	4.6878	4.9342	4.625	4.8798	125078040.0
2018-10-30 10:00:00	NVDA	Stock	4.885	4.8968	4.727	4.7348	128945600.0
2018-10-30 11:00:00	NVDA	Stock	4.7392	4.8988	4.7288	4.825	85750000.0
2018-10-30 12:00:00	NVDA	Stock	4.828	4.9298	4.8112	4.8709	69793520.0
2018-10-30 13:00:00	NVDA	Stock	4.8713	4.8893	4.8138	4.8853	55355160.0
2018-10-30 14:00:00	NVDA	Stock	4.8875	4.9122	4.83	4.9002	54515200.0
2018-10-30 15:00:00	NVDA	Stock	4.903	5.085	4.8795	5.0753	177319760.0
2018-10-30 16:00:00	NVDA	Stock	5.075	5.0795	4.979	5.051	25714080.0
2018-10-30 17:00:00	NVDA	Stock	5.0593	5.0662	5.0065	5.0662	1382640.0
2018-10-30 18:00:00	NVDA	Stock	5.072	5.0868	5.0538	5.0625	891840.0
2018-10-30 19:00:00	NVDA	Stock	5.07	5.08	5.0625	5.0703	765280.0
2018-10-30 04:00:00	AMZN	Stock	77.4	77.6	77.15	77.15	47640.0
2018-10-30 05:00:00	AMZN	Stock	77.0145	77.0145	76.2435	76.375	85400.0

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

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