PREVIEW / stock_1hour / 2019-03-25

all stock 1-hour files

  file:    by_date/stock_1hour/2019/2019-03-25.parquet
  size:    1.1 MB
  rows:    49,738
  symbols: 2,641

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
2019-03-25 04:00:00	AAPL	Stock	47.5925	47.625	47.415	47.415	38216.0
2019-03-25 05:00:00	AAPL	Stock	47.535	47.675	47.535	47.5525	29884.0
2019-03-25 06:00:00	AAPL	Stock	47.55	47.5875	47.5125	47.5575	129468.0
2019-03-25 07:00:00	AAPL	Stock	47.5925	47.625	47.535	47.5975	259680.0
2019-03-25 08:00:00	AAPL	Stock	47.6	48.25	47.5375	48.12	1334928.0
2019-03-25 09:00:00	AAPL	Stock	48.12	48.14	46.8125	46.9375	30414060.0
2019-03-25 10:00:00	AAPL	Stock	46.9382	47.625	46.8642	47.5175	25360368.0
2019-03-25 11:00:00	AAPL	Stock	47.515	47.653	47.29	47.54	13833680.0
2019-03-25 12:00:00	AAPL	Stock	47.54	47.74	47.35	47.445	12146020.0
2019-03-25 13:00:00	AAPL	Stock	47.4517	47.48	46.96	47.0625	19806588.0
2019-03-25 14:00:00	AAPL	Stock	47.0628	47.1075	46.7975	46.8688	20119756.0
2019-03-25 15:00:00	AAPL	Stock	46.8675	47.2075	46.65	47.1925	26343716.0
2019-03-25 16:00:00	AAPL	Stock	47.185	47.32	47.1325	47.295	6591256.0
2019-03-25 17:00:00	AAPL	Stock	47.29	47.2975	47.185	47.225	153960.0
2019-03-25 18:00:00	AAPL	Stock	47.225	47.3275	47.225	47.285	124468.0
2019-03-25 19:00:00	AAPL	Stock	47.275	47.29	47.085	47.29	154260.0
2019-03-25 04:00:00	MSFT	Stock	115.75	116.54	115.75	116.1	9962.0
2019-03-25 05:00:00	MSFT	Stock	116.7	116.72	116.5	116.55	6954.0
2019-03-25 06:00:00	MSFT	Stock	116.55	116.9	116.5	116.71	11470.0
2019-03-25 07:00:00	MSFT	Stock	116.86	116.86	116.49	116.59	20516.0
2019-03-25 08:00:00	MSFT	Stock	116.55	117.0	116.45	117.0	30675.0
2019-03-25 09:00:00	MSFT	Stock	116.92	117.857	116.322	117.16	3859553.0
2019-03-25 10:00:00	MSFT	Stock	117.16	117.64	116.73	117.54	3607213.0
2019-03-25 11:00:00	MSFT	Stock	117.53	118.01	117.34	117.39	2881861.0
2019-03-25 12:00:00	MSFT	Stock	117.4	117.81	117.23	117.38	1689832.0
2019-03-25 13:00:00	MSFT	Stock	117.395	117.61	116.91	117.05	2145249.0
2019-03-25 14:00:00	MSFT	Stock	117.04	117.52	116.85	117.505	1968223.0
2019-03-25 15:00:00	MSFT	Stock	117.51	117.925	117.44	117.65	4246626.0
2019-03-25 16:00:00	MSFT	Stock	117.65	117.79	117.57	117.7	2142894.0
2019-03-25 17:00:00	MSFT	Stock	117.79	117.83	117.79	117.83	1471.0
2019-03-25 18:00:00	MSFT	Stock	117.72	117.82	117.71	117.82	873.0
2019-03-25 19:00:00	MSFT	Stock	117.82	118.04	117.68	118.04	13774.0
2019-03-25 04:00:00	NVDA	Stock	4.4	4.4	4.37	4.375	86200.0
2019-03-25 05:00:00	NVDA	Stock	4.387	4.4	4.387	4.4	116040.0
2019-03-25 06:00:00	NVDA	Stock	4.4122	4.4122	4.4012	4.4122	20400.0
2019-03-25 07:00:00	NVDA	Stock	4.4112	4.4125	4.368	4.3813	611120.0
2019-03-25 08:00:00	NVDA	Stock	4.4	4.4325	4.3662	4.4312	1506720.0
2019-03-25 09:00:00	NVDA	Stock	4.4312	4.4612	4.339	4.3488	100407280.0
2019-03-25 10:00:00	NVDA	Stock	4.3488	4.36	4.2778	4.3348	119681600.0
2019-03-25 11:00:00	NVDA	Stock	4.3333	4.3493	4.3008	4.3038	55858320.0
2019-03-25 12:00:00	NVDA	Stock	4.304	4.3425	4.3026	4.3298	36974040.0
2019-03-25 13:00:00	NVDA	Stock	4.3318	4.3385	4.2895	4.3042	32182920.0
2019-03-25 14:00:00	NVDA	Stock	4.3036	4.3262	4.296	4.3173	34499440.0
2019-03-25 15:00:00	NVDA	Stock	4.3178	4.3595	4.3178	4.3445	74252800.0
2019-03-25 16:00:00	NVDA	Stock	4.3445	4.3583	4.3413	4.35	8846320.0
2019-03-25 17:00:00	NVDA	Stock	4.3502	4.36	4.3502	4.36	240720.0
2019-03-25 18:00:00	NVDA	Stock	4.355	4.3598	4.3525	4.3525	89680.0
2019-03-25 19:00:00	NVDA	Stock	4.353	4.353	4.3358	4.3465	324040.0
2019-03-25 04:00:00	AMZN	Stock	87.25	87.405	87.25	87.2965	75980.0
2019-03-25 05:00:00	AMZN	Stock	87.74	87.74	87.625	87.625	12840.0

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

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