PREVIEW / stock_1hour / 2018-09-28

all stock 1-hour files

  file:    by_date/stock_1hour/2018/2018-09-28.parquet
  size:    1.1 MB
  rows:    50,068
  symbols: 2,797

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-09-28 04:00:00	AAPL	Stock	56.125	56.1275	56.125	56.1275	5944.0
2018-09-28 05:00:00	AAPL	Stock	56.2	56.2	56.115	56.18	3600.0
2018-09-28 06:00:00	AAPL	Stock	56.1975	56.1975	56.0	56.0	20440.0
2018-09-28 07:00:00	AAPL	Stock	56.0	56.0625	55.905	55.98	137312.0
2018-09-28 08:00:00	AAPL	Stock	55.9775	56.1875	55.9	56.175	614008.0
2018-09-28 09:00:00	AAPL	Stock	56.1625	56.3725	56.005	56.185	11460704.0
2018-09-28 10:00:00	AAPL	Stock	56.1825	56.4575	56.14	56.3925	10999372.0
2018-09-28 11:00:00	AAPL	Stock	56.395	56.455	56.2175	56.2638	7447116.0
2018-09-28 12:00:00	AAPL	Stock	56.2625	56.3092	56.12	56.2525	6511408.0
2018-09-28 13:00:00	AAPL	Stock	56.2475	56.3025	56.1625	56.2485	4744924.0
2018-09-28 14:00:00	AAPL	Stock	56.25	56.355	56.155	56.3525	6083900.0
2018-09-28 15:00:00	AAPL	Stock	56.35	56.46	56.2325	56.44	13415012.0
2018-09-28 16:00:00	AAPL	Stock	56.435	56.49	56.42	56.4875	12767572.0
2018-09-28 17:00:00	AAPL	Stock	56.475	56.4875	56.455	56.48	51364.0
2018-09-28 18:00:00	AAPL	Stock	56.48	56.4925	56.435	56.475	712324.0
2018-09-28 19:00:00	AAPL	Stock	56.475	56.4875	56.4675	56.4825	40692.0
2018-09-28 05:00:00	MSFT	Stock	114.4	114.4	114.4	114.4	200.0
2018-09-28 06:00:00	MSFT	Stock	114.4	114.4	114.21	114.25	1263.0
2018-09-28 07:00:00	MSFT	Stock	114.11	114.11	113.93	114.0	26067.0
2018-09-28 08:00:00	MSFT	Stock	114.2	114.2	113.92	114.05	27718.0
2018-09-28 09:00:00	MSFT	Stock	114.1	114.495	113.79	114.01	1861471.0
2018-09-28 10:00:00	MSFT	Stock	114.0	114.289	113.68	114.239	2739793.0
2018-09-28 11:00:00	MSFT	Stock	114.24	114.46	114.15	114.17	1442691.0
2018-09-28 12:00:00	MSFT	Stock	114.16	114.3	114.01	114.222	1124585.0
2018-09-28 13:00:00	MSFT	Stock	114.22	114.35	114.18	114.23	978060.0
2018-09-28 14:00:00	MSFT	Stock	114.23	114.36	113.97	114.29	1239100.0
2018-09-28 15:00:00	MSFT	Stock	114.288	114.57	114.22	114.49	3578945.0
2018-09-28 16:00:00	MSFT	Stock	114.49	114.49	114.33	114.38	4278170.0
2018-09-28 17:00:00	MSFT	Stock	114.38	114.47	114.38	114.47	1594.0
2018-09-28 18:00:00	MSFT	Stock	114.47	114.48	114.44	114.48	1357.0
2018-09-28 19:00:00	MSFT	Stock	114.48	114.49	114.47	114.47	889.0
2018-09-28 06:00:00	NVDA	Stock	6.6912	6.8248	6.6912	6.815	1223880.0
2018-09-28 07:00:00	NVDA	Stock	6.8128	6.8128	6.7715	6.7808	1390040.0
2018-09-28 08:00:00	NVDA	Stock	6.7912	6.8222	6.762	6.821	3834320.0
2018-09-28 09:00:00	NVDA	Stock	6.821	6.9172	6.79	6.9095	124055920.0
2018-09-28 10:00:00	NVDA	Stock	6.9095	6.9905	6.8768	6.9818	114763600.0
2018-09-28 11:00:00	NVDA	Stock	6.9802	6.9998	6.9205	6.9638	77900400.0
2018-09-28 12:00:00	NVDA	Stock	6.9659	7.0312	6.9491	7.0221	85264160.0
2018-09-28 13:00:00	NVDA	Stock	7.0228	7.0479	6.998	7.0065	55969480.0
2018-09-28 14:00:00	NVDA	Stock	7.0052	7.0075	6.9762	6.9962	39749160.0
2018-09-28 15:00:00	NVDA	Stock	6.9968	7.0375	6.9826	7.028	100963880.0
2018-09-28 16:00:00	NVDA	Stock	7.028	7.0332	7.0248	7.0275	27537200.0
2018-09-28 17:00:00	NVDA	Stock	7.0255	7.031	7.0255	7.031	237480.0
2018-09-28 18:00:00	NVDA	Stock	7.031	7.0425	7.0255	7.0375	289320.0
2018-09-28 19:00:00	NVDA	Stock	7.0372	7.0438	7.035	7.0438	402800.0
2018-09-28 04:00:00	AMZN	Stock	100.7	100.706	100.7	100.706	6000.0
2018-09-28 05:00:00	AMZN	Stock	100.7185	100.7185	100.6295	100.6295	6000.0
2018-09-28 06:00:00	AMZN	Stock	100.55	100.55	100.0065	100.1275	19820.0
2018-09-28 07:00:00	AMZN	Stock	100.11	100.1985	99.9185	99.935	123740.0
2018-09-28 08:00:00	AMZN	Stock	100.1201	100.24	99.95	100.15	203720.0

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

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