PREVIEW / stock_1hour / 2019-02-06

all stock 1-hour files

  file:    by_date/stock_1hour/2019/2019-02-06.parquet
  size:    1.1 MB
  rows:    48,968
  symbols: 2,661

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-02-06 04:00:00	AAPL	Stock	43.5475	43.5525	43.4075	43.4375	38500.0
2019-02-06 05:00:00	AAPL	Stock	43.475	43.555	43.475	43.555	58100.0
2019-02-06 06:00:00	AAPL	Stock	43.57	43.6175	43.57	43.595	23336.0
2019-02-06 07:00:00	AAPL	Stock	43.595	43.6925	43.55	43.6475	172392.0
2019-02-06 08:00:00	AAPL	Stock	43.6125	43.7375	43.545	43.695	348580.0
2019-02-06 09:00:00	AAPL	Stock	43.687	43.8325	43.3825	43.4075	15252988.0
2019-02-06 10:00:00	AAPL	Stock	43.4115	43.65	43.2132	43.575	17082220.0
2019-02-06 11:00:00	AAPL	Stock	43.5737	43.8925	43.515	43.707	18341932.0
2019-02-06 12:00:00	AAPL	Stock	43.7075	43.7175	43.425	43.4725	12087600.0
2019-02-06 13:00:00	AAPL	Stock	43.4725	43.6175	43.4425	43.545	8041312.0
2019-02-06 14:00:00	AAPL	Stock	43.547	43.5688	43.42	43.5688	7770564.0
2019-02-06 15:00:00	AAPL	Stock	43.5675	43.5868	43.4975	43.57	11373564.0
2019-02-06 16:00:00	AAPL	Stock	43.56	43.575	43.5002	43.55	5936364.0
2019-02-06 17:00:00	AAPL	Stock	43.545	43.56	43.5	43.5	118404.0
2019-02-06 18:00:00	AAPL	Stock	43.5025	43.5225	43.5	43.5175	31376.0
2019-02-06 19:00:00	AAPL	Stock	43.52	43.5225	43.5	43.5	51456.0
2019-02-06 04:00:00	MSFT	Stock	106.94	106.94	106.75	106.75	649.0
2019-02-06 05:00:00	MSFT	Stock	106.88	106.93	106.74	106.77	8960.0
2019-02-06 06:00:00	MSFT	Stock	106.89	106.89	106.89	106.89	300.0
2019-02-06 07:00:00	MSFT	Stock	106.9	107.0	106.8	106.89	21201.0
2019-02-06 08:00:00	MSFT	Stock	106.9	107.5	106.8	106.97	28031.0
2019-02-06 09:00:00	MSFT	Stock	106.93	107.0	106.153	106.24	2567904.0
2019-02-06 10:00:00	MSFT	Stock	106.245	106.34	105.53	106.3	3029182.0
2019-02-06 11:00:00	MSFT	Stock	106.29	106.5	105.88	106.005	2047464.0
2019-02-06 12:00:00	MSFT	Stock	106.01	106.197	105.87	106.069	1367793.0
2019-02-06 13:00:00	MSFT	Stock	106.07	106.2	105.87	105.973	1132227.0
2019-02-06 14:00:00	MSFT	Stock	105.98	106.01	105.61	105.983	1721074.0
2019-02-06 15:00:00	MSFT	Stock	105.985	106.25	105.885	106.09	3067606.0
2019-02-06 16:00:00	MSFT	Stock	106.03	106.12	105.9	105.95	3173323.0
2019-02-06 17:00:00	MSFT	Stock	105.95	106.03	105.94	105.95	20915.0
2019-02-06 18:00:00	MSFT	Stock	105.9	105.9	105.8	105.8	2367.0
2019-02-06 19:00:00	MSFT	Stock	105.95	105.95	105.65	105.74	9545.0
2019-02-06 04:00:00	NVDA	Stock	3.7238	3.7238	3.7125	3.7125	19160.0
2019-02-06 05:00:00	NVDA	Stock	3.7193	3.7193	3.7135	3.7138	62120.0
2019-02-06 06:00:00	NVDA	Stock	3.72	3.72	3.7028	3.7028	48760.0
2019-02-06 07:00:00	NVDA	Stock	3.7153	3.7422	3.7125	3.7375	1035760.0
2019-02-06 08:00:00	NVDA	Stock	3.7165	3.7662	3.7138	3.76	2136920.0
2019-02-06 09:00:00	NVDA	Stock	3.7625	3.875	3.76	3.8456	154100560.0
2019-02-06 10:00:00	NVDA	Stock	3.8459	3.8535	3.786	3.85	152270400.0
2019-02-06 11:00:00	NVDA	Stock	3.85	3.89	3.8413	3.8666	104066080.0
2019-02-06 12:00:00	NVDA	Stock	3.8655	3.879	3.851	3.865	66409560.0
2019-02-06 13:00:00	NVDA	Stock	3.8645	3.8715	3.8375	3.8415	42410880.0
2019-02-06 14:00:00	NVDA	Stock	3.8419	3.8428	3.8118	3.832	47422000.0
2019-02-06 15:00:00	NVDA	Stock	3.8315	3.8353	3.8175	3.825	59738880.0
2019-02-06 16:00:00	NVDA	Stock	3.825	3.828	3.81	3.8178	4788480.0
2019-02-06 17:00:00	NVDA	Stock	3.8162	3.8251	3.815	3.8185	160720.0
2019-02-06 18:00:00	NVDA	Stock	3.8155	3.82	3.8155	3.8175	142760.0
2019-02-06 19:00:00	NVDA	Stock	3.8175	3.8188	3.81	3.81	355400.0
2019-02-06 07:00:00	AMZN	Stock	82.95	83.325	82.95	83.1525	133780.0
2019-02-06 08:00:00	AMZN	Stock	83.0	83.75	83.0	83.69	836380.0

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

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