PREVIEW / stock_1hour / 2019-05-09

all stock 1-hour files

  file:    by_date/stock_1hour/2019/2019-05-09.parquet
  size:    1.1 MB
  rows:    49,761
  symbols: 2,595

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-05-09 04:00:00	AAPL	Stock	50.3375	50.34	50.1275	50.25	19840.0
2019-05-09 05:00:00	AAPL	Stock	50.2975	50.3475	50.2525	50.3475	13924.0
2019-05-09 06:00:00	AAPL	Stock	50.2775	50.3625	50.2375	50.3125	7716.0
2019-05-09 07:00:00	AAPL	Stock	50.35	50.4725	50.325	50.4025	176552.0
2019-05-09 08:00:00	AAPL	Stock	50.3775	50.4375	50.2	50.2325	725932.0
2019-05-09 09:00:00	AAPL	Stock	50.2075	50.255	49.575	49.75	24243292.0
2019-05-09 10:00:00	AAPL	Stock	49.7625	49.7625	49.165	49.384	24277076.0
2019-05-09 11:00:00	AAPL	Stock	49.38	49.6775	49.2425	49.6575	13714032.0
2019-05-09 12:00:00	AAPL	Stock	49.6525	50.3525	49.52	50.0325	18385848.0
2019-05-09 13:00:00	AAPL	Stock	50.04	50.42	50.02	50.2825	9805992.0
2019-05-09 14:00:00	AAPL	Stock	50.2778	50.3775	49.9012	49.9175	9013660.0
2019-05-09 15:00:00	AAPL	Stock	49.9135	50.225	49.7625	50.18	15580580.0
2019-05-09 16:00:00	AAPL	Stock	50.18	50.205	49.8035	50.0775	5965980.0
2019-05-09 17:00:00	AAPL	Stock	50.125	50.175	50.075	50.1705	50292.0
2019-05-09 18:00:00	AAPL	Stock	50.125	50.1625	50.0775	50.0825	46524.0
2019-05-09 19:00:00	AAPL	Stock	50.075	50.2125	50.075	50.18	66012.0
2019-05-09 04:00:00	MSFT	Stock	124.31	124.48	124.31	124.48	200.0
2019-05-09 05:00:00	MSFT	Stock	124.59	124.59	124.59	124.59	200.0
2019-05-09 06:00:00	MSFT	Stock	124.63	124.63	124.63	124.63	165.0
2019-05-09 07:00:00	MSFT	Stock	124.77	124.81	124.62	124.62	4292.0
2019-05-09 08:00:00	MSFT	Stock	124.7	124.8	124.24	124.35	35532.0
2019-05-09 09:00:00	MSFT	Stock	124.35	124.72	123.69	124.25	3123929.0
2019-05-09 10:00:00	MSFT	Stock	124.26	124.3	123.575	123.645	3412533.0
2019-05-09 11:00:00	MSFT	Stock	123.62	124.43	123.57	124.34	2879758.0
2019-05-09 12:00:00	MSFT	Stock	124.34	125.79	124.045	124.95	3758526.0
2019-05-09 13:00:00	MSFT	Stock	124.95	125.52	124.68	125.108	1960472.0
2019-05-09 14:00:00	MSFT	Stock	125.11	125.45	124.811	124.91	1857400.0
2019-05-09 15:00:00	MSFT	Stock	124.91	125.69	124.65	125.51	3641387.0
2019-05-09 16:00:00	MSFT	Stock	125.507	125.99	125.5	125.75	3329189.0
2019-05-09 17:00:00	MSFT	Stock	125.56	125.75	125.55	125.75	3574.0
2019-05-09 18:00:00	MSFT	Stock	125.51	125.62	125.45	125.45	4062.0
2019-05-09 19:00:00	MSFT	Stock	125.4	125.63	125.35	125.54	5457.0
2019-05-09 04:00:00	NVDA	Stock	4.302	4.302	4.2702	4.287	114320.0
2019-05-09 05:00:00	NVDA	Stock	4.2898	4.2898	4.2758	4.2815	37200.0
2019-05-09 06:00:00	NVDA	Stock	4.2865	4.2872	4.2775	4.282	87080.0
2019-05-09 07:00:00	NVDA	Stock	4.2905	4.301	4.285	4.29	486680.0
2019-05-09 08:00:00	NVDA	Stock	4.2875	4.304	4.2725	4.2825	2104760.0
2019-05-09 09:00:00	NVDA	Stock	4.2792	4.2883	4.166	4.1946	94713560.0
2019-05-09 10:00:00	NVDA	Stock	4.1947	4.1952	4.135	4.1512	103646520.0
2019-05-09 11:00:00	NVDA	Stock	4.1512	4.2185	4.1485	4.215	63389480.0
2019-05-09 12:00:00	NVDA	Stock	4.215	4.2855	4.1985	4.259	80013600.0
2019-05-09 13:00:00	NVDA	Stock	4.2584	4.2845	4.2462	4.2742	49727560.0
2019-05-09 14:00:00	NVDA	Stock	4.2755	4.2812	4.2495	4.2506	44692240.0
2019-05-09 15:00:00	NVDA	Stock	4.2505	4.2675	4.228	4.255	99613600.0
2019-05-09 16:00:00	NVDA	Stock	4.2548	4.2627	4.2462	4.25	2216000.0
2019-05-09 17:00:00	NVDA	Stock	4.25	4.25	4.2438	4.25	87920.0
2019-05-09 18:00:00	NVDA	Stock	4.2475	4.2545	4.2438	4.245	239360.0
2019-05-09 19:00:00	NVDA	Stock	4.2462	4.2662	4.2462	4.2502	392000.0
2019-05-09 04:00:00	AMZN	Stock	94.807	94.886	94.807	94.886	4000.0
2019-05-09 05:00:00	AMZN	Stock	95.0445	95.0995	95.0445	95.0615	10000.0

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

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