PREVIEW / stock_1hour / 2019-09-24

all stock 1-hour files

  file:    by_date/stock_1hour/2019/2019-09-24.parquet
  size:    1.1 MB
  rows:    50,262
  symbols: 2,561

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-09-24 04:00:00	AAPL	Stock	54.975	55.1675	54.95	55.0825	38852.0
2019-09-24 05:00:00	AAPL	Stock	55.08	55.115	55.0375	55.1	15400.0
2019-09-24 06:00:00	AAPL	Stock	55.08	55.12	55.075	55.12	41312.0
2019-09-24 07:00:00	AAPL	Stock	55.08	55.205	55.08	55.16	170256.0
2019-09-24 08:00:00	AAPL	Stock	55.1675	55.225	55.1	55.2	441332.0
2019-09-24 09:00:00	AAPL	Stock	55.175	55.6225	55.17	55.47	15792912.0
2019-09-24 10:00:00	AAPL	Stock	55.4675	55.475	55.03	55.1725	13774540.0
2019-09-24 11:00:00	AAPL	Stock	55.1725	55.2248	54.6875	54.7875	11939188.0
2019-09-24 12:00:00	AAPL	Stock	54.78	54.9525	54.325	54.374	13131100.0
2019-09-24 13:00:00	AAPL	Stock	54.3725	54.57	54.2975	54.4275	8544996.0
2019-09-24 14:00:00	AAPL	Stock	54.43	54.925	54.3525	54.5875	11591364.0
2019-09-24 15:00:00	AAPL	Stock	54.585	54.665	54.3875	54.42	14288272.0
2019-09-24 16:00:00	AAPL	Stock	54.42	54.51	54.415	54.4625	11735872.0
2019-09-24 17:00:00	AAPL	Stock	54.45	54.4625	54.39	54.4375	130700.0
2019-09-24 18:00:00	AAPL	Stock	54.4625	54.55	54.4125	54.5375	69896.0
2019-09-24 19:00:00	AAPL	Stock	54.525	54.615	54.4875	54.575	53872.0
2019-09-24 04:00:00	MSFT	Stock	139.85	139.85	139.63	139.73	1787.0
2019-09-24 05:00:00	MSFT	Stock	139.82	139.97	139.82	139.95	407.0
2019-09-24 06:00:00	MSFT	Stock	139.78	139.89	139.55	139.84	1173.0
2019-09-24 07:00:00	MSFT	Stock	139.9	139.95	139.6	139.75	19518.0
2019-09-24 08:00:00	MSFT	Stock	139.94	139.94	139.39	139.63	68873.0
2019-09-24 09:00:00	MSFT	Stock	139.51	140.69	139.39	140.468	2848894.0
2019-09-24 10:00:00	MSFT	Stock	140.465	140.51	139.55	139.955	2995702.0
2019-09-24 11:00:00	MSFT	Stock	139.96	139.97	138.44	138.717	2176024.0
2019-09-24 12:00:00	MSFT	Stock	138.7	138.965	137.12	137.21	3352312.0
2019-09-24 13:00:00	MSFT	Stock	137.22	137.5	136.88	137.19	2449323.0
2019-09-24 14:00:00	MSFT	Stock	137.185	138.28	137.02	137.355	2739099.0
2019-09-24 15:00:00	MSFT	Stock	137.34	137.73	136.97	137.38	3694237.0
2019-09-24 16:00:00	MSFT	Stock	137.38	137.65	137.38	137.41	4290731.0
2019-09-24 17:00:00	MSFT	Stock	137.45	137.54	137.28	137.28	18136.0
2019-09-24 18:00:00	MSFT	Stock	137.38	137.6	137.28	137.6	10215.0
2019-09-24 19:00:00	MSFT	Stock	137.65	137.8	137.65	137.75	11898.0
2019-09-24 04:00:00	NVDA	Stock	4.4045	4.4045	4.4002	4.4002	12200.0
2019-09-24 05:00:00	NVDA	Stock	4.408	4.408	4.408	4.408	8000.0
2019-09-24 06:00:00	NVDA	Stock	4.4175	4.4197	4.4175	4.4197	43480.0
2019-09-24 07:00:00	NVDA	Stock	4.4205	4.4245	4.4167	4.4205	321040.0
2019-09-24 08:00:00	NVDA	Stock	4.4218	4.4245	4.4025	4.4125	896120.0
2019-09-24 09:00:00	NVDA	Stock	4.413	4.4322	4.3945	4.4075	41678440.0
2019-09-24 10:00:00	NVDA	Stock	4.4078	4.4201	4.3469	4.3672	42761160.0
2019-09-24 11:00:00	NVDA	Stock	4.3668	4.3732	4.3228	4.3415	30824200.0
2019-09-24 12:00:00	NVDA	Stock	4.3408	4.3538	4.2842	4.2908	42756480.0
2019-09-24 13:00:00	NVDA	Stock	4.2913	4.3105	4.284	4.2965	22746240.0
2019-09-24 14:00:00	NVDA	Stock	4.2962	4.4134	4.2775	4.2995	35270440.0
2019-09-24 15:00:00	NVDA	Stock	4.2998	4.317	4.2842	4.314	50609280.0
2019-09-24 16:00:00	NVDA	Stock	4.3132	4.3192	4.3045	4.3068	20717640.0
2019-09-24 17:00:00	NVDA	Stock	4.3068	4.3068	4.3013	4.3025	200960.0
2019-09-24 18:00:00	NVDA	Stock	4.3088	4.3142	4.3028	4.312	127000.0
2019-09-24 19:00:00	NVDA	Stock	4.3123	4.3265	4.3112	4.3198	482880.0
2019-09-24 07:00:00	AMZN	Stock	89.79	89.85	89.698	89.698	18720.0
2019-09-24 08:00:00	AMZN	Stock	89.7	89.7	89.4995	89.4995	85140.0

> showing 50 of 50,262 rows — these rows as CSV

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