PREVIEW / stock_1hour / 2019-03-04

all stock 1-hour files

  file:    by_date/stock_1hour/2019/2019-03-04.parquet
  size:    1.1 MB
  rows:    50,541
  symbols: 2,653

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-03-04 04:00:00	AAPL	Stock	43.8875	43.975	43.8775	43.925	20488.0
2019-03-04 05:00:00	AAPL	Stock	43.88	43.9425	43.8775	43.935	6352.0
2019-03-04 06:00:00	AAPL	Stock	43.9375	43.945	43.9375	43.945	17096.0
2019-03-04 07:00:00	AAPL	Stock	43.9375	43.9875	43.9	43.955	94292.0
2019-03-04 08:00:00	AAPL	Stock	43.9698	44.0	43.9225	43.9425	323520.0
2019-03-04 09:00:00	AAPL	Stock	43.9625	44.415	43.9	44.369	16544852.0
2019-03-04 10:00:00	AAPL	Stock	44.3725	44.4375	44.155	44.1775	15918700.0
2019-03-04 11:00:00	AAPL	Stock	44.175	44.1888	43.6908	43.8	15961704.0
2019-03-04 12:00:00	AAPL	Stock	43.7988	43.875	43.4925	43.695	12445812.0
2019-03-04 13:00:00	AAPL	Stock	43.6925	43.875	43.6025	43.8545	7638836.0
2019-03-04 14:00:00	AAPL	Stock	43.8525	43.93	43.805	43.87	6943024.0
2019-03-04 15:00:00	AAPL	Stock	43.865	43.9925	43.8075	43.965	13122372.0
2019-03-04 16:00:00	AAPL	Stock	43.965	44.01	43.9275	43.9375	9235848.0
2019-03-04 17:00:00	AAPL	Stock	43.9425	43.9425	43.9	43.93	15100.0
2019-03-04 18:00:00	AAPL	Stock	43.9125	43.9125	43.85	43.88	27496.0
2019-03-04 19:00:00	AAPL	Stock	43.89	43.9625	43.85	43.8875	36804.0
2019-03-04 04:00:00	MSFT	Stock	112.82	113.05	112.82	113.05	1400.0
2019-03-04 05:00:00	MSFT	Stock	113.12	113.12	113.08	113.08	1100.0
2019-03-04 06:00:00	MSFT	Stock	113.15	113.15	113.0	113.0	7249.0
2019-03-04 07:00:00	MSFT	Stock	112.95	113.15	112.85	113.0	19844.0
2019-03-04 08:00:00	MSFT	Stock	112.95	113.15	112.95	113.05	35967.0
2019-03-04 09:00:00	MSFT	Stock	113.06	113.25	112.745	113.155	2765385.0
2019-03-04 10:00:00	MSFT	Stock	113.15	113.2	112.22	112.23	3131093.0
2019-03-04 11:00:00	MSFT	Stock	112.23	112.32	111.05	111.235	3609853.0
2019-03-04 12:00:00	MSFT	Stock	111.23	111.58	110.8	111.09	2556751.0
2019-03-04 13:00:00	MSFT	Stock	111.09	111.79	110.9	111.705	1864971.0
2019-03-04 14:00:00	MSFT	Stock	111.705	112.0	111.3	111.775	1724905.0
2019-03-04 15:00:00	MSFT	Stock	111.77	112.39	111.6	112.28	3788010.0
2019-03-04 16:00:00	MSFT	Stock	112.27	112.27	111.98	112.1	3097758.0
2019-03-04 17:00:00	MSFT	Stock	111.9	112.08	111.9	112.08	1298.0
2019-03-04 18:00:00	MSFT	Stock	112.02	112.02	111.9	112.0	4307.0
2019-03-04 19:00:00	MSFT	Stock	112.02	112.06	111.5	111.85	9755.0
2019-03-04 04:00:00	NVDA	Stock	3.972	3.972	3.967	3.967	16000.0
2019-03-04 05:00:00	NVDA	Stock	3.9658	3.9658	3.9375	3.9378	36000.0
2019-03-04 06:00:00	NVDA	Stock	3.9375	3.9408	3.9375	3.9408	49200.0
2019-03-04 07:00:00	NVDA	Stock	3.9312	3.955	3.9312	3.9462	344000.0
2019-03-04 08:00:00	NVDA	Stock	3.95	3.9562	3.94	3.9478	1322720.0
2019-03-04 09:00:00	NVDA	Stock	3.9498	3.973	3.9403	3.9605	52925800.0
2019-03-04 10:00:00	NVDA	Stock	3.961	3.9677	3.928	3.9422	62990920.0
2019-03-04 11:00:00	NVDA	Stock	3.9418	3.9462	3.8765	3.8806	62030120.0
2019-03-04 12:00:00	NVDA	Stock	3.8812	3.8998	3.8625	3.8958	67429600.0
2019-03-04 13:00:00	NVDA	Stock	3.8948	3.9188	3.875	3.9136	42285400.0
2019-03-04 14:00:00	NVDA	Stock	3.9145	3.9188	3.8925	3.8983	34308040.0
2019-03-04 15:00:00	NVDA	Stock	3.898	3.92	3.893	3.92	51107440.0
2019-03-04 16:00:00	NVDA	Stock	3.9195	3.9195	3.9108	3.917	6379600.0
2019-03-04 17:00:00	NVDA	Stock	3.9168	3.9172	3.9138	3.915	111040.0
2019-03-04 18:00:00	NVDA	Stock	3.915	3.9175	3.9062	3.9175	304320.0
2019-03-04 19:00:00	NVDA	Stock	3.9175	3.9195	3.9125	3.915	395040.0
2019-03-04 04:00:00	AMZN	Stock	83.9895	83.99	83.825	83.825	112600.0
2019-03-04 05:00:00	AMZN	Stock	83.8065	83.8495	83.8065	83.808	8600.0

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

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