PREVIEW / stock_1hour / 2018-01-17

all stock 1-hour files

  file:    by_date/stock_1hour/2018/2018-01-17.parquet
  size:    1.1 MB
  rows:    49,626
  symbols: 2,909

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
2018-01-17 04:00:00	AAPL	Stock	43.5525	43.735	43.3	43.6	233628.0
2018-01-17 05:00:00	AAPL	Stock	43.6225	43.66	43.5875	43.6475	38092.0
2018-01-17 06:00:00	AAPL	Stock	43.6475	44.005	43.6475	43.875	163420.0
2018-01-17 07:00:00	AAPL	Stock	43.875	44.05	43.8375	43.905	197836.0
2018-01-17 08:00:00	AAPL	Stock	43.8775	44.15	43.825	44.1	513652.0
2018-01-17 09:00:00	AAPL	Stock	44.1	44.175	43.7675	43.9125	14638208.0
2018-01-17 10:00:00	AAPL	Stock	43.9162	44.0125	43.8	43.92	11509008.0
2018-01-17 11:00:00	AAPL	Stock	43.92	43.9775	43.854	43.8925	7507972.0
2018-01-17 12:00:00	AAPL	Stock	43.89	43.9975	43.86	43.989	6019380.0
2018-01-17 13:00:00	AAPL	Stock	43.9875	44.38	43.905	44.1875	22660352.0
2018-01-17 14:00:00	AAPL	Stock	44.1775	44.64	44.1528	44.62	17440976.0
2018-01-17 15:00:00	AAPL	Stock	44.615	44.8125	44.61	44.775	28354992.0
2018-01-17 16:00:00	AAPL	Stock	44.775	44.815	44.0475	44.8	13331772.0
2018-01-17 17:00:00	AAPL	Stock	44.8	44.8225	44.775	44.82	1264224.0
2018-01-17 18:00:00	AAPL	Stock	44.8175	44.8625	44.8175	44.8625	273768.0
2018-01-17 19:00:00	AAPL	Stock	44.8625	44.8625	44.8425	44.8625	136524.0
2018-01-17 06:00:00	MSFT	Stock	88.8	88.8	88.8	88.8	500.0
2018-01-17 07:00:00	MSFT	Stock	88.72	88.9	88.5	88.77	7255.0
2018-01-17 08:00:00	MSFT	Stock	88.82	88.9	88.55	88.84	21562.0
2018-01-17 09:00:00	MSFT	Stock	88.8	89.5	88.65	88.97	3432061.0
2018-01-17 10:00:00	MSFT	Stock	88.97	89.98	88.96	89.93	3090472.0
2018-01-17 11:00:00	MSFT	Stock	89.93	90.05	89.71	89.865	2066184.0
2018-01-17 12:00:00	MSFT	Stock	89.864	90.17	89.82	90.105	1580726.0
2018-01-17 13:00:00	MSFT	Stock	90.11	90.28	89.96	89.995	2111880.0
2018-01-17 14:00:00	MSFT	Stock	89.995	90.22	89.99	90.15	1971857.0
2018-01-17 15:00:00	MSFT	Stock	90.145	90.21	89.96	90.15	4479817.0
2018-01-17 16:00:00	MSFT	Stock	90.14	90.18	88.35	90.12	4353676.0
2018-01-17 17:00:00	MSFT	Stock	90.17	90.17	90.06	90.11	10851.0
2018-01-17 18:00:00	MSFT	Stock	90.06	90.18	90.06	90.18	918.0
2018-01-17 19:00:00	MSFT	Stock	90.18	90.19	90.18	90.19	2065.0
2018-01-17 04:00:00	NVDA	Stock	5.469	5.5078	5.469	5.5078	35200.0
2018-01-17 05:00:00	NVDA	Stock	5.5125	5.542	5.5125	5.542	80000.0
2018-01-17 06:00:00	NVDA	Stock	5.5375	5.5418	5.5375	5.5418	8000.0
2018-01-17 07:00:00	NVDA	Stock	5.5123	5.5468	5.5075	5.5263	1357800.0
2018-01-17 08:00:00	NVDA	Stock	5.525	5.547	5.5075	5.5265	3193120.0
2018-01-17 09:00:00	NVDA	Stock	5.525	5.525	5.4225	5.4328	98772120.0
2018-01-17 10:00:00	NVDA	Stock	5.4328	5.516	5.4325	5.4781	97548000.0
2018-01-17 11:00:00	NVDA	Stock	5.4793	5.5433	5.4672	5.5402	72221760.0
2018-01-17 12:00:00	NVDA	Stock	5.5404	5.5768	5.5404	5.5612	54040440.0
2018-01-17 13:00:00	NVDA	Stock	5.562	5.5832	5.5525	5.574	35741560.0
2018-01-17 14:00:00	NVDA	Stock	5.5732	5.5845	5.5673	5.5775	29474000.0
2018-01-17 15:00:00	NVDA	Stock	5.5769	5.628	5.5763	5.6175	97988760.0
2018-01-17 16:00:00	NVDA	Stock	5.618	5.618	5.5028	5.6125	24684640.0
2018-01-17 17:00:00	NVDA	Stock	5.6125	5.6172	5.6065	5.6108	433600.0
2018-01-17 18:00:00	NVDA	Stock	5.6108	5.615	5.6088	5.6138	364000.0
2018-01-17 19:00:00	NVDA	Stock	5.615	5.6175	5.61	5.6138	451360.0
2018-01-17 04:00:00	AMZN	Stock	65.5	65.5	65.5	65.5	4000.0
2018-01-17 05:00:00	AMZN	Stock	65.5	65.7475	65.5	65.6535	35420.0
2018-01-17 06:00:00	AMZN	Stock	65.7	65.792	65.6665	65.7	61020.0
2018-01-17 07:00:00	AMZN	Stock	65.6945	65.74	65.55	65.55	223480.0

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

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