PREVIEW / stock_1hour / 2017-05-19

all stock 1-hour files

  file:    by_date/stock_1hour/2017/2017-05-19.parquet
  size:    1.0 MB
  rows:    47,930
  symbols: 3,025

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
2017-05-19 04:00:00	AAPL	Stock	38.1625	38.1625	38.1625	38.1625	620.0
2017-05-19 05:00:00	AAPL	Stock	38.3	38.4375	38.3	38.38	29320.0
2017-05-19 06:00:00	AAPL	Stock	38.35	38.425	38.325	38.3425	46976.0
2017-05-19 07:00:00	AAPL	Stock	38.36	38.385	38.35	38.3525	145480.0
2017-05-19 08:00:00	AAPL	Stock	38.37	38.4875	38.36	38.4575	564456.0
2017-05-19 09:00:00	AAPL	Stock	38.455	38.4575	38.2525	38.315	23928804.0
2017-05-19 10:00:00	AAPL	Stock	38.3205	38.4568	38.26	38.455	14716964.0
2017-05-19 11:00:00	AAPL	Stock	38.4538	38.495	38.3025	38.385	10346196.0
2017-05-19 12:00:00	AAPL	Stock	38.3875	38.435	38.34	38.41	6166396.0
2017-05-19 13:00:00	AAPL	Stock	38.41	38.425	38.3725	38.3925	5242204.0
2017-05-19 14:00:00	AAPL	Stock	38.3925	38.4125	38.315	38.3525	8806844.0
2017-05-19 15:00:00	AAPL	Stock	38.35	38.36	38.1575	38.2625	20667708.0
2017-05-19 16:00:00	AAPL	Stock	38.2425	38.265	38.2	38.235	8609924.0
2017-05-19 17:00:00	AAPL	Stock	38.2475	38.265	38.235	38.265	43212.0
2017-05-19 18:00:00	AAPL	Stock	38.25	38.275	38.2375	38.2375	30972.0
2017-05-19 19:00:00	AAPL	Stock	38.2375	38.2575	38.215	38.215	36564.0
2017-05-19 06:00:00	MSFT	Stock	67.99	67.99	67.93	67.93	307.0
2017-05-19 07:00:00	MSFT	Stock	67.8	67.8	67.75	67.78	8805.0
2017-05-19 08:00:00	MSFT	Stock	67.73	67.89	67.73	67.84	22992.0
2017-05-19 09:00:00	MSFT	Stock	67.8	68.0	67.43	67.94	6344280.0
2017-05-19 10:00:00	MSFT	Stock	67.935	68.095	67.88	67.974	2607934.0
2017-05-19 11:00:00	MSFT	Stock	67.97	68.0	67.83	67.905	1927943.0
2017-05-19 12:00:00	MSFT	Stock	67.9	67.98	67.88	67.915	1450353.0
2017-05-19 13:00:00	MSFT	Stock	67.91	67.92	67.72	67.75	1518678.0
2017-05-19 14:00:00	MSFT	Stock	67.75	67.92	67.69	67.87	1721287.0
2017-05-19 15:00:00	MSFT	Stock	67.87	67.905	67.58	67.69	5148599.0
2017-05-19 16:00:00	MSFT	Stock	67.64	67.928	67.6	67.6	4632340.0
2017-05-19 17:00:00	MSFT	Stock	67.68	67.68	67.5	67.5	1095.0
2017-05-19 18:00:00	MSFT	Stock	67.67	67.67	67.67	67.67	100.0
2017-05-19 19:00:00	MSFT	Stock	67.54	67.54	67.54	67.54	180.0
2017-05-19 04:00:00	NVDA	Stock	3.3625	3.379	3.3625	3.3772	38360.0
2017-05-19 05:00:00	NVDA	Stock	3.3772	3.3862	3.3748	3.3812	237800.0
2017-05-19 06:00:00	NVDA	Stock	3.3712	3.3922	3.371	3.375	313000.0
2017-05-19 07:00:00	NVDA	Stock	3.375	3.4075	3.375	3.4	1942120.0
2017-05-19 08:00:00	NVDA	Stock	3.4	3.418	3.38	3.4135	7134880.0
2017-05-19 09:00:00	NVDA	Stock	3.4135	3.455	3.4062	3.4175	231078520.0
2017-05-19 10:00:00	NVDA	Stock	3.418	3.4555	3.4132	3.428	195753600.0
2017-05-19 11:00:00	NVDA	Stock	3.4276	3.435	3.3925	3.4038	153917400.0
2017-05-19 12:00:00	NVDA	Stock	3.4042	3.4298	3.394	3.4142	104566720.0
2017-05-19 13:00:00	NVDA	Stock	3.4142	3.4242	3.4095	3.418	47538440.0
2017-05-19 14:00:00	NVDA	Stock	3.4178	3.4272	3.41	3.417	61539320.0
2017-05-19 15:00:00	NVDA	Stock	3.417	3.4182	3.3805	3.4002	175146040.0
2017-05-19 16:00:00	NVDA	Stock	3.4	3.4025	3.3948	3.4	14897800.0
2017-05-19 17:00:00	NVDA	Stock	3.4	3.45	3.3878	3.3915	479240.0
2017-05-19 18:00:00	NVDA	Stock	3.3918	3.398	3.39	3.39	212040.0
2017-05-19 19:00:00	NVDA	Stock	3.39	3.3948	3.383	3.3875	596000.0
2017-05-19 05:00:00	AMZN	Stock	48.15	48.15	48.15	48.15	2000.0
2017-05-19 07:00:00	AMZN	Stock	48.125	48.125	48.1245	48.125	18300.0
2017-05-19 08:00:00	AMZN	Stock	48.104	48.2	48.1	48.1725	257520.0
2017-05-19 09:00:00	AMZN	Stock	48.1775	48.4095	48.077	48.221	17416480.0

> showing 50 of 47,930 rows — these rows as CSV

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