PREVIEW / stock_1hour / 2017-12-05

all stock 1-hour files

  file:    by_date/stock_1hour/2017/2017-12-05.parquet
  size:    1.1 MB
  rows:    51,183
  symbols: 2,936

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
2017-12-05 04:00:00	AAPL	Stock	42.3625	42.3625	42.255	42.34	28040.0
2017-12-05 05:00:00	AAPL	Stock	42.3	42.3	42.1475	42.1475	37260.0
2017-12-05 06:00:00	AAPL	Stock	42.15	42.25	42.1125	42.25	25120.0
2017-12-05 07:00:00	AAPL	Stock	42.2875	42.525	42.265	42.5225	192068.0
2017-12-05 08:00:00	AAPL	Stock	42.25	42.5775	42.25	42.44	283992.0
2017-12-05 09:00:00	AAPL	Stock	42.4375	42.5675	42.1	42.505	17985536.0
2017-12-05 10:00:00	AAPL	Stock	42.5125	42.835	42.45	42.721	18871192.0
2017-12-05 11:00:00	AAPL	Stock	42.7222	42.88	42.7075	42.7158	10790028.0
2017-12-05 12:00:00	AAPL	Stock	42.7125	42.74	42.565	42.6025	7313248.0
2017-12-05 13:00:00	AAPL	Stock	42.6	42.7885	42.5625	42.728	5773132.0
2017-12-05 14:00:00	AAPL	Stock	42.729	42.7325	42.3925	42.4382	10007492.0
2017-12-05 15:00:00	AAPL	Stock	42.435	42.575	42.3925	42.4125	14934876.0
2017-12-05 16:00:00	AAPL	Stock	42.41	42.465	42.375	42.4	8004316.0
2017-12-05 17:00:00	AAPL	Stock	42.4	42.4625	42.38	42.4625	98444.0
2017-12-05 18:00:00	AAPL	Stock	42.475	42.5	42.4325	42.4725	19896.0
2017-12-05 19:00:00	AAPL	Stock	42.5	42.515	42.475	42.5025	21592.0
2017-12-05 04:00:00	MSFT	Stock	81.08	81.08	80.99	80.99	335.0
2017-12-05 06:00:00	MSFT	Stock	80.6	80.88	80.52	80.88	3261.0
2017-12-05 07:00:00	MSFT	Stock	80.9	81.27	80.8	81.27	7398.0
2017-12-05 08:00:00	MSFT	Stock	81.2	81.5	80.88	81.25	22883.0
2017-12-05 09:00:00	MSFT	Stock	81.21	82.19	80.98	82.04	4849953.0
2017-12-05 10:00:00	MSFT	Stock	82.02	82.19	81.591	82.145	3746472.0
2017-12-05 11:00:00	MSFT	Stock	82.15	82.68	82.12	82.137	3004626.0
2017-12-05 12:00:00	MSFT	Stock	82.138	82.31	81.94	82.0	1533975.0
2017-12-05 13:00:00	MSFT	Stock	82.005	82.207	81.77	82.14	1386661.0
2017-12-05 14:00:00	MSFT	Stock	82.13	82.13	81.62	81.74	2006688.0
2017-12-05 15:00:00	MSFT	Stock	81.746	81.98	81.55	81.59	3525710.0
2017-12-05 16:00:00	MSFT	Stock	81.59	81.72	81.59	81.6	3633413.0
2017-12-05 17:00:00	MSFT	Stock	81.59	81.59	81.41	81.55	4859.0
2017-12-05 18:00:00	MSFT	Stock	81.59	81.59	81.54	81.59	1550.0
2017-12-05 19:00:00	MSFT	Stock	81.58	81.7	81.58	81.7	1918.0
2017-12-05 04:00:00	NVDA	Stock	4.6375	4.6375	4.6	4.608	273320.0
2017-12-05 05:00:00	NVDA	Stock	4.605	4.6057	4.575	4.5803	498280.0
2017-12-05 06:00:00	NVDA	Stock	4.5803	4.6025	4.5635	4.6025	474760.0
2017-12-05 07:00:00	NVDA	Stock	4.6057	4.6462	4.5975	4.6368	2785760.0
2017-12-05 08:00:00	NVDA	Stock	4.64	4.6425	4.5778	4.64	4630360.0
2017-12-05 09:00:00	NVDA	Stock	4.6362	4.7905	4.5145	4.7731	257149600.0
2017-12-05 10:00:00	NVDA	Stock	4.7732	4.8083	4.7475	4.7742	154526960.0
2017-12-05 11:00:00	NVDA	Stock	4.7738	4.8175	4.7475	4.7502	90418320.0
2017-12-05 12:00:00	NVDA	Stock	4.7518	4.7762	4.729	4.7414	55948680.0
2017-12-05 13:00:00	NVDA	Stock	4.7375	4.7392	4.6912	4.7342	59505400.0
2017-12-05 14:00:00	NVDA	Stock	4.734	4.741	4.6712	4.687	57290760.0
2017-12-05 15:00:00	NVDA	Stock	4.6886	4.716	4.6785	4.6925	72687600.0
2017-12-05 16:00:00	NVDA	Stock	4.6935	4.6948	4.6815	4.6862	48870720.0
2017-12-05 17:00:00	NVDA	Stock	4.6862	4.6923	4.6838	4.6912	350400.0
2017-12-05 18:00:00	NVDA	Stock	4.69	4.7	4.69	4.7	296720.0
2017-12-05 19:00:00	NVDA	Stock	4.6992	4.7032	4.6965	4.6987	363280.0
2017-12-05 04:00:00	AMZN	Stock	56.7035	56.7035	56.7035	56.7035	5200.0
2017-12-05 05:00:00	AMZN	Stock	56.406	56.406	56.315	56.4	74140.0
2017-12-05 06:00:00	AMZN	Stock	56.33	56.555	56.3065	56.555	44600.0

> showing 50 of 51,183 rows — these rows as CSV

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