PREVIEW / stock_1hour / 2019-12-23

all stock 1-hour files

  file:    by_date/stock_1hour/2019/2019-12-23.parquet
  size:    1.2 MB
  rows:    51,134
  symbols: 2,463

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-12-23 04:00:00	AAPL	Stock	69.955	70.075	69.955	70.0625	6404.0
2019-12-23 05:00:00	AAPL	Stock	70.0625	70.07	70.0625	70.0625	9712.0
2019-12-23 06:00:00	AAPL	Stock	70.06	70.1325	70.06	70.0625	23240.0
2019-12-23 07:00:00	AAPL	Stock	70.0675	70.15	70.03	70.075	172532.0
2019-12-23 08:00:00	AAPL	Stock	70.05	70.2425	70.025	70.1725	547388.0
2019-12-23 09:00:00	AAPL	Stock	70.1725	70.605	69.86	70.5025	14969488.0
2019-12-23 10:00:00	AAPL	Stock	70.5075	70.7395	70.45	70.6725	11810748.0
2019-12-23 11:00:00	AAPL	Stock	70.6725	70.94	70.6725	70.87	10299564.0
2019-12-23 12:00:00	AAPL	Stock	70.8712	71.015	70.845	70.8875	7236568.0
2019-12-23 13:00:00	AAPL	Stock	70.8842	70.9925	70.8625	70.9175	4140764.0
2019-12-23 14:00:00	AAPL	Stock	70.9205	71.055	70.9025	71.02	4811428.0
2019-12-23 15:00:00	AAPL	Stock	71.02	71.0625	70.8875	70.9925	9799276.0
2019-12-23 16:00:00	AAPL	Stock	71.0	71.05	70.995	71.05	18791032.0
2019-12-23 17:00:00	AAPL	Stock	71.0475	71.1525	71.0375	71.14	187136.0
2019-12-23 18:00:00	AAPL	Stock	71.1375	71.1675	71.0975	71.1125	56828.0
2019-12-23 19:00:00	AAPL	Stock	71.1025	71.14	71.1025	71.14	81628.0
2019-12-23 04:00:00	MSFT	Stock	157.79	157.98	157.79	157.92	1014.0
2019-12-23 05:00:00	MSFT	Stock	157.92	158.0	157.92	157.96	3650.0
2019-12-23 06:00:00	MSFT	Stock	158.0	158.0	157.89	157.95	1400.0
2019-12-23 07:00:00	MSFT	Stock	157.95	158.11	157.89	158.05	11569.0
2019-12-23 08:00:00	MSFT	Stock	157.96	158.11	157.41	157.95	72107.0
2019-12-23 09:00:00	MSFT	Stock	158.0	158.12	157.41	157.66	1827520.0
2019-12-23 10:00:00	MSFT	Stock	157.67	157.8	157.32	157.8	1770349.0
2019-12-23 11:00:00	MSFT	Stock	157.792	157.81	157.47	157.65	1153032.0
2019-12-23 12:00:00	MSFT	Stock	157.66	157.68	157.485	157.505	1139219.0
2019-12-23 13:00:00	MSFT	Stock	157.5	157.64	157.46	157.525	700305.0
2019-12-23 14:00:00	MSFT	Stock	157.525	157.665	157.4	157.49	1226803.0
2019-12-23 15:00:00	MSFT	Stock	157.5	157.52	157.27	157.41	2681371.0
2019-12-23 16:00:00	MSFT	Stock	157.41	157.5	157.4	157.47	5169993.0
2019-12-23 17:00:00	MSFT	Stock	157.48	157.54	157.46	157.5	4329.0
2019-12-23 18:00:00	MSFT	Stock	157.54	157.56	157.52	157.53	1612.0
2019-12-23 19:00:00	MSFT	Stock	157.56	157.56	157.45	157.45	5495.0
2019-12-23 04:00:00	NVDA	Stock	5.9975	6.0275	5.9913	6.0275	35320.0
2019-12-23 05:00:00	NVDA	Stock	6.0242	6.049	6.0242	6.0375	128040.0
2019-12-23 06:00:00	NVDA	Stock	6.0288	6.0288	6.0288	6.0288	4000.0
2019-12-23 07:00:00	NVDA	Stock	6.0278	6.045	6.0278	6.0438	658760.0
2019-12-23 08:00:00	NVDA	Stock	6.035	6.0482	5.9695	6.0413	1724520.0
2019-12-23 09:00:00	NVDA	Stock	6.0413	6.0452	5.9598	5.9834	68360160.0
2019-12-23 10:00:00	NVDA	Stock	5.9848	6.0143	5.9653	5.9946	62221920.0
2019-12-23 11:00:00	NVDA	Stock	5.9945	6.0189	5.9908	6.0143	29763040.0
2019-12-23 12:00:00	NVDA	Stock	6.0143	6.025	5.9943	5.9978	24801680.0
2019-12-23 13:00:00	NVDA	Stock	5.9968	5.9995	5.985	5.991	17787640.0
2019-12-23 14:00:00	NVDA	Stock	5.9914	6.003	5.9854	5.9895	14947920.0
2019-12-23 15:00:00	NVDA	Stock	5.9895	5.9922	5.9618	5.9705	36375480.0
2019-12-23 16:00:00	NVDA	Stock	5.9705	5.9751	5.9705	5.9751	31299480.0
2019-12-23 17:00:00	NVDA	Stock	5.9743	5.9743	5.9713	5.9713	78480.0
2019-12-23 18:00:00	NVDA	Stock	5.975	5.9762	5.9728	5.975	128000.0
2019-12-23 19:00:00	NVDA	Stock	5.9762	5.978	5.975	5.978	165800.0
2019-12-23 06:00:00	AMZN	Stock	89.495	89.5	89.495	89.5	6760.0
2019-12-23 07:00:00	AMZN	Stock	89.475	89.55	89.475	89.55	14000.0

> showing 50 of 51,134 rows — these rows as CSV

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