PREVIEW / stock_1hour / 2018-08-07

all stock 1-hour files

  file:    by_date/stock_1hour/2018/2018-08-07.parquet
  size:    1.1 MB
  rows:    49,209
  symbols: 2,779

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-08-07 04:00:00	AAPL	Stock	52.3125	52.44	52.28	52.4375	31488.0
2018-08-07 05:00:00	AAPL	Stock	52.4375	52.4675	52.4125	52.4225	23644.0
2018-08-07 06:00:00	AAPL	Stock	52.42	52.4225	52.36	52.4125	24120.0
2018-08-07 07:00:00	AAPL	Stock	52.4125	52.415	52.36	52.3625	135032.0
2018-08-07 08:00:00	AAPL	Stock	52.395	52.42	52.315	52.37	308724.0
2018-08-07 09:00:00	AAPL	Stock	52.3725	52.375	51.9675	52.0575	16071748.0
2018-08-07 10:00:00	AAPL	Stock	52.0575	52.0925	51.69	51.8225	21823316.0
2018-08-07 11:00:00	AAPL	Stock	51.825	51.9075	51.7	51.785	11739388.0
2018-08-07 12:00:00	AAPL	Stock	51.7875	51.8775	51.7275	51.8718	8314140.0
2018-08-07 13:00:00	AAPL	Stock	51.8725	51.8925	51.7675	51.8875	6326128.0
2018-08-07 14:00:00	AAPL	Stock	51.8875	51.94	51.7925	51.81	6283120.0
2018-08-07 15:00:00	AAPL	Stock	51.8125	51.845	51.715	51.7775	13617704.0
2018-08-07 16:00:00	AAPL	Stock	51.7775	51.8787	51.7525	51.76	5334992.0
2018-08-07 17:00:00	AAPL	Stock	51.78	51.78	51.7375	51.75	97072.0
2018-08-07 18:00:00	AAPL	Stock	51.75	51.7625	51.725	51.7375	59040.0
2018-08-07 19:00:00	AAPL	Stock	51.74	51.7625	51.72	51.72	89872.0
2018-08-07 04:00:00	MSFT	Stock	108.2	108.58	108.2	108.58	386.0
2018-08-07 05:00:00	MSFT	Stock	108.59	108.59	108.59	108.59	320.0
2018-08-07 06:00:00	MSFT	Stock	108.54	108.54	108.5	108.54	828.0
2018-08-07 07:00:00	MSFT	Stock	108.3	108.54	108.3	108.4	1955.0
2018-08-07 08:00:00	MSFT	Stock	108.38	108.59	108.25	108.35	10349.0
2018-08-07 09:00:00	MSFT	Stock	108.4	109.1	108.17	108.72	2590362.0
2018-08-07 10:00:00	MSFT	Stock	108.72	108.98	108.406	108.48	2328508.0
2018-08-07 11:00:00	MSFT	Stock	108.49	108.66	108.28	108.605	1465514.0
2018-08-07 12:00:00	MSFT	Stock	108.61	108.92	108.585	108.863	1381724.0
2018-08-07 13:00:00	MSFT	Stock	108.87	109.03	108.71	108.98	1583877.0
2018-08-07 14:00:00	MSFT	Stock	108.97	109.07	108.91	108.99	1243723.0
2018-08-07 15:00:00	MSFT	Stock	108.989	109.02	108.79	108.87	2248552.0
2018-08-07 16:00:00	MSFT	Stock	108.88	108.94	108.8	108.94	1264072.0
2018-08-07 17:00:00	MSFT	Stock	108.89	108.89	108.77	108.84	1840.0
2018-08-07 18:00:00	MSFT	Stock	108.88	108.95	108.88	108.89	1506.0
2018-08-07 19:00:00	MSFT	Stock	108.94	108.99	108.89	108.99	6107.0
2018-08-07 04:00:00	NVDA	Stock	6.345	6.3705	6.345	6.3705	66640.0
2018-08-07 05:00:00	NVDA	Stock	6.372	6.372	6.3678	6.372	37280.0
2018-08-07 06:00:00	NVDA	Stock	6.3742	6.4	6.3742	6.3975	86720.0
2018-08-07 07:00:00	NVDA	Stock	6.3878	6.4	6.38	6.3938	226960.0
2018-08-07 08:00:00	NVDA	Stock	6.3863	6.4108	6.365	6.403	850560.0
2018-08-07 09:00:00	NVDA	Stock	6.405	6.438	6.373	6.3988	43484760.0
2018-08-07 10:00:00	NVDA	Stock	6.4015	6.442	6.3775	6.382	61165160.0
2018-08-07 11:00:00	NVDA	Stock	6.383	6.4179	6.375	6.4065	24773880.0
2018-08-07 12:00:00	NVDA	Stock	6.4078	6.4423	6.4048	6.4328	24633120.0
2018-08-07 13:00:00	NVDA	Stock	6.4328	6.4425	6.4073	6.4412	24732640.0
2018-08-07 14:00:00	NVDA	Stock	6.4408	6.4423	6.4225	6.4285	14403160.0
2018-08-07 15:00:00	NVDA	Stock	6.4288	6.4293	6.4125	6.4228	26582640.0
2018-08-07 16:00:00	NVDA	Stock	6.4238	6.4275	6.4188	6.4232	7448200.0
2018-08-07 17:00:00	NVDA	Stock	6.4263	6.4263	6.4188	6.4232	144800.0
2018-08-07 18:00:00	NVDA	Stock	6.423	6.4238	6.423	6.4238	101680.0
2018-08-07 19:00:00	NVDA	Stock	6.425	6.4302	6.4225	6.4302	111520.0
2018-08-07 05:00:00	AMZN	Stock	92.625	92.65	92.625	92.65	11440.0
2018-08-07 06:00:00	AMZN	Stock	92.65	92.6945	92.6465	92.6505	16000.0

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

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