PREVIEW / stock_1hour / 2018-05-11

all stock 1-hour files

  file:    by_date/stock_1hour/2018/2018-05-11.parquet
  size:    1.1 MB
  rows:    48,915
  symbols: 2,852

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-05-11 04:00:00	AAPL	Stock	47.4	47.4	47.35	47.35	10128.0
2018-05-11 05:00:00	AAPL	Stock	47.35	47.375	47.275	47.2775	27720.0
2018-05-11 06:00:00	AAPL	Stock	47.3625	47.4125	47.3625	47.375	114092.0
2018-05-11 07:00:00	AAPL	Stock	47.35	47.4725	47.35	47.4375	206508.0
2018-05-11 08:00:00	AAPL	Stock	47.4125	47.45	47.3275	47.355	351932.0
2018-05-11 09:00:00	AAPL	Stock	47.36	47.515	47.15	47.3812	14771960.0
2018-05-11 10:00:00	AAPL	Stock	47.3825	47.3975	47.245	47.31	11820796.0
2018-05-11 11:00:00	AAPL	Stock	47.31	47.3125	47.1075	47.25	9980388.0
2018-05-11 12:00:00	AAPL	Stock	47.2512	47.275	47.0625	47.1375	7274288.0
2018-05-11 13:00:00	AAPL	Stock	47.1375	47.21	47.1	47.16	5083172.0
2018-05-11 14:00:00	AAPL	Stock	47.1622	47.1725	46.8625	46.9175	10186712.0
2018-05-11 15:00:00	AAPL	Stock	46.915	47.1825	46.9125	47.1475	14120948.0
2018-05-11 16:00:00	AAPL	Stock	47.1475	47.175	47.1275	47.1575	14133188.0
2018-05-11 17:00:00	AAPL	Stock	47.1425	47.175	47.14	47.15	54908.0
2018-05-11 18:00:00	AAPL	Stock	47.15	47.1625	47.14	47.1625	19660.0
2018-05-11 19:00:00	AAPL	Stock	47.155	47.1625	47.1375	47.1375	108220.0
2018-05-11 04:00:00	MSFT	Stock	97.92	97.92	97.92	97.92	136.0
2018-05-11 06:00:00	MSFT	Stock	97.93	98.0	97.93	98.0	1500.0
2018-05-11 07:00:00	MSFT	Stock	97.89	98.12	97.87	98.05	5624.0
2018-05-11 08:00:00	MSFT	Stock	97.88	98.16	97.87	97.94	32240.0
2018-05-11 09:00:00	MSFT	Stock	97.9	97.93	97.04	97.49	1589855.0
2018-05-11 10:00:00	MSFT	Stock	97.48	97.85	97.44	97.77	2058809.0
2018-05-11 11:00:00	MSFT	Stock	97.765	97.775	97.34	97.515	1500937.0
2018-05-11 12:00:00	MSFT	Stock	97.52	97.585	97.21	97.365	1285155.0
2018-05-11 13:00:00	MSFT	Stock	97.36	97.52	97.252	97.356	996026.0
2018-05-11 14:00:00	MSFT	Stock	97.359	97.425	97.09	97.18	1417236.0
2018-05-11 15:00:00	MSFT	Stock	97.19	97.73	97.12	97.71	2821584.0
2018-05-11 16:00:00	MSFT	Stock	97.7	97.73	97.61	97.67	3556344.0
2018-05-11 17:00:00	MSFT	Stock	97.7	97.7	97.69	97.7	2779.0
2018-05-11 18:00:00	MSFT	Stock	97.7	97.74	97.65	97.73	3724.0
2018-05-11 19:00:00	MSFT	Stock	97.73	97.76	97.7	97.7	2800.0
2018-05-11 04:00:00	NVDA	Stock	6.314	6.3868	6.3108	6.3765	1237000.0
2018-05-11 05:00:00	NVDA	Stock	6.375	6.375	6.3445	6.3625	211400.0
2018-05-11 06:00:00	NVDA	Stock	6.3575	6.4325	6.355	6.3752	1375720.0
2018-05-11 07:00:00	NVDA	Stock	6.3798	6.4	6.3253	6.387	7294560.0
2018-05-11 08:00:00	NVDA	Stock	6.3858	6.3958	6.325	6.3303	14042760.0
2018-05-11 09:00:00	NVDA	Stock	6.3313	6.3885	6.2635	6.3722	297076640.0
2018-05-11 10:00:00	NVDA	Stock	6.3728	6.4948	6.3578	6.4694	303260240.0
2018-05-11 11:00:00	NVDA	Stock	6.4689	6.49	6.4078	6.443	143448080.0
2018-05-11 12:00:00	NVDA	Stock	6.4421	6.444	6.3598	6.4052	102814680.0
2018-05-11 13:00:00	NVDA	Stock	6.4055	6.4293	6.3828	6.4215	60770480.0
2018-05-11 14:00:00	NVDA	Stock	6.4213	6.425	6.3668	6.3703	59712960.0
2018-05-11 15:00:00	NVDA	Stock	6.37	6.3888	6.3468	6.3633	109560640.0
2018-05-11 16:00:00	NVDA	Stock	6.3633	6.3722	6.3528	6.3562	35329960.0
2018-05-11 17:00:00	NVDA	Stock	6.3562	6.36	6.353	6.3555	369200.0
2018-05-11 18:00:00	NVDA	Stock	6.3528	6.3633	6.3512	6.3633	535920.0
2018-05-11 19:00:00	NVDA	Stock	6.365	6.3663	6.35	6.3575	809920.0
2018-05-11 05:00:00	AMZN	Stock	80.5505	80.5505	80.5505	80.5505	2000.0
2018-05-11 07:00:00	AMZN	Stock	80.638	80.725	80.6	80.6	61240.0
2018-05-11 08:00:00	AMZN	Stock	80.65	80.65	80.454	80.55	213920.0

> showing 50 of 48,915 rows — these rows as CSV

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