PREVIEW / stock_1hour / 2018-08-30

all stock 1-hour files

  file:    by_date/stock_1hour/2018/2018-08-30.parquet
  size:    1.1 MB
  rows:    48,796
  symbols: 2,780

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-30 04:00:00	AAPL	Stock	56.0	56.0	55.7125	55.75	37380.0
2018-08-30 05:00:00	AAPL	Stock	55.75	55.7625	55.73	55.73	8788.0
2018-08-30 06:00:00	AAPL	Stock	55.75	55.8125	55.68	55.77	41040.0
2018-08-30 07:00:00	AAPL	Stock	55.78	55.85	55.5525	55.825	136496.0
2018-08-30 08:00:00	AAPL	Stock	55.7575	55.965	55.6625	55.8575	481120.0
2018-08-30 09:00:00	AAPL	Stock	55.8575	56.1425	55.635	55.6625	19982668.0
2018-08-30 10:00:00	AAPL	Stock	55.66	55.9725	55.6	55.8575	16657872.0
2018-08-30 11:00:00	AAPL	Stock	55.855	56.16	55.8275	56.125	14738852.0
2018-08-30 12:00:00	AAPL	Stock	56.1275	56.6575	56.07	56.5825	24022460.0
2018-08-30 13:00:00	AAPL	Stock	56.5775	57.0	56.5725	56.9425	25016904.0
2018-08-30 14:00:00	AAPL	Stock	56.9425	57.065	56.2775	56.2775	29839792.0
2018-08-30 15:00:00	AAPL	Stock	56.28	56.3725	55.955	56.2675	31200128.0
2018-08-30 16:00:00	AAPL	Stock	56.265	56.3465	56.2525	56.275	6411024.0
2018-08-30 17:00:00	AAPL	Stock	56.275	56.31	56.2625	56.2775	78680.0
2018-08-30 18:00:00	AAPL	Stock	56.29	56.3125	56.205	56.275	186260.0
2018-08-30 19:00:00	AAPL	Stock	56.2625	56.2875	56.25	56.25	97836.0
2018-08-30 04:00:00	MSFT	Stock	111.89	111.89	111.82	111.87	1245.0
2018-08-30 05:00:00	MSFT	Stock	111.73	111.73	111.73	111.73	239.0
2018-08-30 06:00:00	MSFT	Stock	111.7	111.85	111.7	111.85	580.0
2018-08-30 07:00:00	MSFT	Stock	111.85	111.95	111.75	111.93	5856.0
2018-08-30 08:00:00	MSFT	Stock	111.8	111.94	111.75	111.93	4167.0
2018-08-30 09:00:00	MSFT	Stock	111.9	112.02	111.545	111.725	2463532.0
2018-08-30 10:00:00	MSFT	Stock	111.725	112.5	111.71	112.415	3330747.0
2018-08-30 11:00:00	MSFT	Stock	112.42	112.515	112.17	112.42	2362029.0
2018-08-30 12:00:00	MSFT	Stock	112.42	112.57	112.36	112.485	1440618.0
2018-08-30 13:00:00	MSFT	Stock	112.486	112.61	112.25	112.288	1304499.0
2018-08-30 14:00:00	MSFT	Stock	112.287	112.36	111.72	111.78	3063842.0
2018-08-30 15:00:00	MSFT	Stock	111.78	111.96	111.44	111.95	4025259.0
2018-08-30 16:00:00	MSFT	Stock	111.95	112.0	111.76	111.9	2602310.0
2018-08-30 17:00:00	MSFT	Stock	111.88	111.94	111.77	111.94	2888.0
2018-08-30 18:00:00	MSFT	Stock	111.81	111.93	111.71	111.93	893.0
2018-08-30 19:00:00	MSFT	Stock	111.73	111.87	111.73	111.78	2017.0
2018-08-30 06:00:00	NVDA	Stock	6.9378	6.9463	6.9378	6.9463	47400.0
2018-08-30 07:00:00	NVDA	Stock	6.9448	6.95	6.9425	6.95	143080.0
2018-08-30 08:00:00	NVDA	Stock	6.9392	6.9575	6.9392	6.9445	1640920.0
2018-08-30 09:00:00	NVDA	Stock	6.9438	6.9925	6.908	6.983	59442080.0
2018-08-30 10:00:00	NVDA	Stock	6.985	7.0429	6.983	7.0088	77222120.0
2018-08-30 11:00:00	NVDA	Stock	7.0088	7.0189	6.958	6.9856	38834960.0
2018-08-30 12:00:00	NVDA	Stock	6.9862	7.0172	6.9862	7.0066	26416840.0
2018-08-30 13:00:00	NVDA	Stock	7.0075	7.0098	6.9811	6.9885	23244400.0
2018-08-30 14:00:00	NVDA	Stock	6.9888	6.9963	6.9397	6.9484	28540800.0
2018-08-30 15:00:00	NVDA	Stock	6.9481	6.95	6.9228	6.945	49528320.0
2018-08-30 16:00:00	NVDA	Stock	6.9452	6.9472	6.925	6.9302	8669960.0
2018-08-30 17:00:00	NVDA	Stock	6.9372	6.9388	6.929	6.9375	42000.0
2018-08-30 18:00:00	NVDA	Stock	6.9375	6.9375	6.928	6.93	334200.0
2018-08-30 19:00:00	NVDA	Stock	6.9325	6.9368	6.9275	6.9275	555840.0
2018-08-30 04:00:00	AMZN	Stock	100.006	100.006	100.006	100.006	2500.0
2018-08-30 05:00:00	AMZN	Stock	99.9795	99.9795	99.9715	99.9715	13600.0
2018-08-30 06:00:00	AMZN	Stock	100.025	100.054	99.95	100.054	33840.0
2018-08-30 07:00:00	AMZN	Stock	100.0125	100.1275	99.975	100.044	217520.0

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

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