PREVIEW / stock_1hour / 2019-01-03

all stock 1-hour files

  file:    by_date/stock_1hour/2019/2019-01-03.parquet
  size:    1.1 MB
  rows:    49,441
  symbols: 2,680

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-01-03 04:00:00	AAPL	Stock	36.5	36.665	36.25	36.5125	281028.0
2019-01-03 05:00:00	AAPL	Stock	36.515	36.625	36.21	36.285	419680.0
2019-01-03 06:00:00	AAPL	Stock	36.335	36.345	35.7825	35.84	632376.0
2019-01-03 07:00:00	AAPL	Stock	35.87	36.325	35.83	36.23	2162108.0
2019-01-03 08:00:00	AAPL	Stock	35.975	36.5	35.8625	36.0475	3616140.0
2019-01-03 09:00:00	AAPL	Stock	36.0475	36.245	35.7025	36.1025	73462188.0
2019-01-03 10:00:00	AAPL	Stock	36.1	36.1	35.52	35.7983	58905380.0
2019-01-03 11:00:00	AAPL	Stock	35.7988	36.375	35.7875	36.1825	41614248.0
2019-01-03 12:00:00	AAPL	Stock	36.182	36.43	36.105	36.26	25637192.0
2019-01-03 13:00:00	AAPL	Stock	36.2525	36.2928	35.725	35.74	24949584.0
2019-01-03 14:00:00	AAPL	Stock	35.7375	35.9925	35.625	35.656	22947896.0
2019-01-03 15:00:00	AAPL	Stock	35.6575	35.835	35.5	35.5212	45448576.0
2019-01-03 16:00:00	AAPL	Stock	35.5475	35.73	35.535	35.625	17825084.0
2019-01-03 17:00:00	AAPL	Stock	35.6275	35.67	35.5475	35.67	527640.0
2019-01-03 18:00:00	AAPL	Stock	35.64	35.6825	35.6	35.645	117928.0
2019-01-03 19:00:00	AAPL	Stock	35.6375	35.6375	35.52	35.52	133152.0
2019-01-03 04:00:00	MSFT	Stock	99.03	99.5	98.98	99.3	6870.0
2019-01-03 05:00:00	MSFT	Stock	99.24	99.47	99.01	99.45	10587.0
2019-01-03 06:00:00	MSFT	Stock	99.19	99.19	98.97	99.0	14995.0
2019-01-03 07:00:00	MSFT	Stock	99.0	99.51	99.0	99.5	37195.0
2019-01-03 08:00:00	MSFT	Stock	99.25	100.03	99.0	99.92	81674.0
2019-01-03 09:00:00	MSFT	Stock	99.8	100.4	98.63	99.02	4095271.0
2019-01-03 10:00:00	MSFT	Stock	98.99	98.99	97.46	97.973	6746321.0
2019-01-03 11:00:00	MSFT	Stock	97.98	99.589	97.95	99.08	4796021.0
2019-01-03 12:00:00	MSFT	Stock	99.08	99.29	98.6	99.2	2469975.0
2019-01-03 13:00:00	MSFT	Stock	99.19	99.193	97.79	97.92	3479954.0
2019-01-03 14:00:00	MSFT	Stock	97.92	98.82	97.75	97.81	3912098.0
2019-01-03 15:00:00	MSFT	Stock	97.82	98.31	97.2	97.36	7056220.0
2019-01-03 16:00:00	MSFT	Stock	97.38	97.81	97.25	97.45	4886688.0
2019-01-03 17:00:00	MSFT	Stock	97.5	97.55	97.368	97.55	13788.0
2019-01-03 18:00:00	MSFT	Stock	97.5	97.64	97.4	97.48	29657.0
2019-01-03 19:00:00	MSFT	Stock	97.44	97.44	97.0	97.15	22737.0
2019-01-03 04:00:00	NVDA	Stock	3.2875	3.3125	3.2875	3.2945	92200.0
2019-01-03 05:00:00	NVDA	Stock	3.2888	3.3035	3.285	3.296	81200.0
2019-01-03 06:00:00	NVDA	Stock	3.2942	3.2972	3.2852	3.2852	20480.0
2019-01-03 07:00:00	NVDA	Stock	3.28	3.3118	3.28	3.3	466880.0
2019-01-03 08:00:00	NVDA	Stock	3.2938	3.33	3.2912	3.3125	1869280.0
2019-01-03 09:00:00	NVDA	Stock	3.3175	3.379	3.239	3.25	128653000.0
2019-01-03 10:00:00	NVDA	Stock	3.2478	3.2496	3.1923	3.244	125719640.0
2019-01-03 11:00:00	NVDA	Stock	3.244	3.287	3.2252	3.257	88677000.0
2019-01-03 12:00:00	NVDA	Stock	3.2554	3.2676	3.233	3.2517	46397400.0
2019-01-03 13:00:00	NVDA	Stock	3.2519	3.2519	3.1965	3.201	45106480.0
2019-01-03 14:00:00	NVDA	Stock	3.2	3.2428	3.193	3.2163	48108040.0
2019-01-03 15:00:00	NVDA	Stock	3.2172	3.23	3.195	3.1998	82006160.0
2019-01-03 16:00:00	NVDA	Stock	3.1998	3.2095	3.1922	3.2042	43055840.0
2019-01-03 17:00:00	NVDA	Stock	3.2	3.2025	3.2	3.2025	263240.0
2019-01-03 18:00:00	NVDA	Stock	3.2025	3.2188	3.2025	3.2078	771120.0
2019-01-03 19:00:00	NVDA	Stock	3.205	3.205	3.192	3.192	562000.0
2019-01-03 04:00:00	AMZN	Stock	75.25	75.32	75.25	75.297	20100.0
2019-01-03 05:00:00	AMZN	Stock	75.295	75.295	75.295	75.295	2000.0

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

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