PREVIEW / stock_1hour / 2019-01-11

all stock 1-hour files

  file:    by_date/stock_1hour/2019/2019-01-11.parquet
  size:    1.1 MB
  rows:    48,775
  symbols: 2,669

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-11 04:00:00	AAPL	Stock	38.635	38.635	38.56	38.575	11204.0
2019-01-11 05:00:00	AAPL	Stock	38.625	38.6325	38.45	38.5225	29688.0
2019-01-11 06:00:00	AAPL	Stock	38.565	38.62	38.4625	38.495	32720.0
2019-01-11 07:00:00	AAPL	Stock	38.5125	38.5125	38.325	38.3275	99144.0
2019-01-11 08:00:00	AAPL	Stock	38.5	38.55	38.1675	38.2375	514120.0
2019-01-11 09:00:00	AAPL	Stock	38.2475	38.425	38.1875	38.2775	11400752.0
2019-01-11 10:00:00	AAPL	Stock	38.2725	38.375	38.0075	38.2075	16501564.0
2019-01-11 11:00:00	AAPL	Stock	38.2075	38.2475	37.96	38.093	12839708.0
2019-01-11 12:00:00	AAPL	Stock	38.0925	38.17	38.05	38.1075	7911604.0
2019-01-11 13:00:00	AAPL	Stock	38.11	38.1125	37.8775	37.9125	11319092.0
2019-01-11 14:00:00	AAPL	Stock	37.91	38.0775	37.8812	38.0342	8602348.0
2019-01-11 15:00:00	AAPL	Stock	38.0325	38.1475	38.0	38.07	15666508.0
2019-01-11 16:00:00	AAPL	Stock	38.0725	38.125	38.025	38.065	12615132.0
2019-01-11 17:00:00	AAPL	Stock	38.0625	38.0825	38.0525	38.0725	37360.0
2019-01-11 18:00:00	AAPL	Stock	38.0625	38.0625	38.03	38.06	27384.0
2019-01-11 19:00:00	AAPL	Stock	38.05	38.0875	38.05	38.0875	65408.0
2019-01-11 04:00:00	MSFT	Stock	103.65	103.65	103.65	103.65	600.0
2019-01-11 05:00:00	MSFT	Stock	103.5	103.5	103.25	103.25	1777.0
2019-01-11 06:00:00	MSFT	Stock	103.5	103.5	103.48	103.48	930.0
2019-01-11 07:00:00	MSFT	Stock	103.5	103.59	103.12	103.22	12447.0
2019-01-11 08:00:00	MSFT	Stock	103.32	103.32	102.85	102.99	13382.0
2019-01-11 09:00:00	MSFT	Stock	103.13	103.44	101.94	102.41	3351792.0
2019-01-11 10:00:00	MSFT	Stock	102.4	102.71	102.0	102.485	3564438.0
2019-01-11 11:00:00	MSFT	Stock	102.48	102.54	101.92	102.25	3056477.0
2019-01-11 12:00:00	MSFT	Stock	102.24	102.41	101.97	102.035	2082169.0
2019-01-11 13:00:00	MSFT	Stock	102.03	102.06	101.64	101.77	2374820.0
2019-01-11 14:00:00	MSFT	Stock	101.76	102.46	101.66	102.434	2831750.0
2019-01-11 15:00:00	MSFT	Stock	102.44	102.91	102.35	102.769	5314132.0
2019-01-11 16:00:00	MSFT	Stock	102.8	102.8	102.66	102.8	3290426.0
2019-01-11 17:00:00	MSFT	Stock	102.79	102.79	102.64	102.7	7065.0
2019-01-11 18:00:00	MSFT	Stock	102.62	102.75	102.62	102.75	6660.0
2019-01-11 19:00:00	MSFT	Stock	102.73	102.75	102.63	102.75	2052.0
2019-01-11 04:00:00	NVDA	Stock	3.6403	3.6403	3.6403	3.6403	4000.0
2019-01-11 05:00:00	NVDA	Stock	3.6403	3.6403	3.6268	3.6268	171600.0
2019-01-11 06:00:00	NVDA	Stock	3.6268	3.629	3.6155	3.6155	118840.0
2019-01-11 07:00:00	NVDA	Stock	3.6125	3.6198	3.6078	3.6198	267640.0
2019-01-11 08:00:00	NVDA	Stock	3.6164	3.6212	3.5988	3.6018	1208600.0
2019-01-11 09:00:00	NVDA	Stock	3.605	3.67	3.5803	3.6426	88699760.0
2019-01-11 10:00:00	NVDA	Stock	3.643	3.6583	3.6062	3.6378	76888240.0
2019-01-11 11:00:00	NVDA	Stock	3.6385	3.645	3.6178	3.6368	44474040.0
2019-01-11 12:00:00	NVDA	Stock	3.6367	3.7335	3.634	3.7306	163616080.0
2019-01-11 13:00:00	NVDA	Stock	3.7305	3.7358	3.6868	3.7042	113432280.0
2019-01-11 14:00:00	NVDA	Stock	3.7035	3.7348	3.6995	3.7245	105744680.0
2019-01-11 15:00:00	NVDA	Stock	3.7249	3.7438	3.7195	3.72	198919920.0
2019-01-11 16:00:00	NVDA	Stock	3.7208	3.7242	3.7125	3.7163	13674360.0
2019-01-11 17:00:00	NVDA	Stock	3.7163	3.7208	3.7125	3.7145	574160.0
2019-01-11 18:00:00	NVDA	Stock	3.715	3.7195	3.7133	3.717	177200.0
2019-01-11 19:00:00	NVDA	Stock	3.7155	3.719	3.715	3.7155	163080.0
2019-01-11 04:00:00	AMZN	Stock	82.95	82.95	82.85	82.85	10620.0
2019-01-11 05:00:00	AMZN	Stock	82.7	82.7	82.4525	82.5	28320.0

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

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