PREVIEW / stock_1hour / 2019-02-13

all stock 1-hour files

  file:    by_date/stock_1hour/2019/2019-02-13.parquet
  size:    1.1 MB
  rows:    49,454
  symbols: 2,659

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-02-13 04:00:00	AAPL	Stock	42.8775	42.945	42.875	42.945	11572.0
2019-02-13 05:00:00	AAPL	Stock	42.8775	42.9125	42.8775	42.895	2080.0
2019-02-13 06:00:00	AAPL	Stock	42.9125	42.915	42.9125	42.915	2000.0
2019-02-13 07:00:00	AAPL	Stock	42.9075	42.9375	42.895	42.9025	64396.0
2019-02-13 08:00:00	AAPL	Stock	42.9175	42.9375	42.8125	42.9125	280028.0
2019-02-13 09:00:00	AAPL	Stock	42.895	43.12	42.77	42.8825	13435276.0
2019-02-13 10:00:00	AAPL	Stock	42.88	42.9625	42.7375	42.8675	13063800.0
2019-02-13 11:00:00	AAPL	Stock	42.87	42.93	42.6425	42.7375	10958916.0
2019-02-13 12:00:00	AAPL	Stock	42.74	42.78	42.6025	42.655	5935100.0
2019-02-13 13:00:00	AAPL	Stock	42.6575	42.7525	42.65	42.6825	4970804.0
2019-02-13 14:00:00	AAPL	Stock	42.6825	42.79	42.64	42.733	7077112.0
2019-02-13 15:00:00	AAPL	Stock	42.7325	42.735	42.48	42.5425	13395704.0
2019-02-13 16:00:00	AAPL	Stock	42.545	42.57	42.5125	42.53	7648520.0
2019-02-13 17:00:00	AAPL	Stock	42.54	42.545	42.5075	42.5075	145736.0
2019-02-13 18:00:00	AAPL	Stock	42.5075	42.535	42.5	42.515	53232.0
2019-02-13 19:00:00	AAPL	Stock	42.5225	42.5475	42.375	42.4125	67956.0
2019-02-13 04:00:00	MSFT	Stock	107.39	107.39	107.15	107.15	1069.0
2019-02-13 05:00:00	MSFT	Stock	107.16	107.16	107.16	107.16	365.0
2019-02-13 06:00:00	MSFT	Stock	107.37	107.4	107.37	107.4	4850.0
2019-02-13 07:00:00	MSFT	Stock	107.3	107.44	107.3	107.3	6069.0
2019-02-13 08:00:00	MSFT	Stock	107.36	107.49	107.24	107.4	15485.0
2019-02-13 09:00:00	MSFT	Stock	107.34	107.78	107.12	107.17	2578299.0
2019-02-13 10:00:00	MSFT	Stock	107.17	107.434	106.95	107.29	2276683.0
2019-02-13 11:00:00	MSFT	Stock	107.29	107.45	106.85	107.1	1891816.0
2019-02-13 12:00:00	MSFT	Stock	107.1	107.196	106.88	106.996	1581093.0
2019-02-13 13:00:00	MSFT	Stock	106.993	107.04	106.91	106.92	1062317.0
2019-02-13 14:00:00	MSFT	Stock	106.92	107.3	106.92	107.121	1491351.0
2019-02-13 15:00:00	MSFT	Stock	107.12	107.28	106.71	106.79	2509121.0
2019-02-13 16:00:00	MSFT	Stock	106.783	106.81	106.6	106.68	1971666.0
2019-02-13 17:00:00	MSFT	Stock	106.68	106.81	106.68	106.78	33567.0
2019-02-13 18:00:00	MSFT	Stock	106.69	106.7	106.61	106.63	6697.0
2019-02-13 19:00:00	MSFT	Stock	106.7	106.75	106.35	106.35	14205.0
2019-02-13 04:00:00	NVDA	Stock	3.8158	3.8158	3.7815	3.7815	55600.0
2019-02-13 07:00:00	NVDA	Stock	3.8	3.8123	3.7938	3.7958	432080.0
2019-02-13 08:00:00	NVDA	Stock	3.8087	3.815	3.7885	3.8102	1846560.0
2019-02-13 09:00:00	NVDA	Stock	3.81	3.8431	3.7952	3.8245	109259400.0
2019-02-13 10:00:00	NVDA	Stock	3.8242	3.8538	3.797	3.8476	97572120.0
2019-02-13 11:00:00	NVDA	Stock	3.8478	3.8522	3.8218	3.844	49746720.0
2019-02-13 12:00:00	NVDA	Stock	3.8445	3.8542	3.8358	3.8438	41534560.0
2019-02-13 13:00:00	NVDA	Stock	3.8436	3.8718	3.8403	3.87	47988160.0
2019-02-13 14:00:00	NVDA	Stock	3.8698	3.8958	3.8618	3.8925	73603760.0
2019-02-13 15:00:00	NVDA	Stock	3.8921	3.893	3.8102	3.8218	121909640.0
2019-02-13 16:00:00	NVDA	Stock	3.822	3.825	3.8083	3.8188	8265160.0
2019-02-13 17:00:00	NVDA	Stock	3.8205	3.8225	3.814	3.8175	652280.0
2019-02-13 18:00:00	NVDA	Stock	3.8188	3.8338	3.816	3.8255	1204440.0
2019-02-13 19:00:00	NVDA	Stock	3.8258	3.8288	3.8158	3.82	871400.0
2019-02-13 06:00:00	AMZN	Stock	82.239	82.325	82.239	82.294	19560.0
2019-02-13 07:00:00	AMZN	Stock	82.255	82.744	82.255	82.4235	530860.0
2019-02-13 08:00:00	AMZN	Stock	82.35	82.7	82.105	82.39	767540.0
2019-02-13 09:00:00	AMZN	Stock	82.374	82.819	82.224	82.6288	15070100.0

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

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