PREVIEW / stock_1hour / 2018-08-23

all stock 1-hour files

  file:    by_date/stock_1hour/2018/2018-08-23.parquet
  size:    1.1 MB
  rows:    48,323
  symbols: 2,787

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-23 04:00:00	AAPL	Stock	53.8125	53.8125	53.7725	53.7725	1384.0
2018-08-23 05:00:00	AAPL	Stock	53.8725	53.8725	53.8625	53.8625	3524.0
2018-08-23 06:00:00	AAPL	Stock	53.8475	53.8475	53.7675	53.8175	9200.0
2018-08-23 07:00:00	AAPL	Stock	53.82	53.85	53.7575	53.7875	81248.0
2018-08-23 08:00:00	AAPL	Stock	53.8468	53.8468	53.6875	53.73	186592.0
2018-08-23 09:00:00	AAPL	Stock	53.7325	54.2625	53.65	54.19	10999232.0
2018-08-23 10:00:00	AAPL	Stock	54.19	54.2425	53.9825	53.9885	9912288.0
2018-08-23 11:00:00	AAPL	Stock	53.9875	54.0178	53.7775	53.86	8790916.0
2018-08-23 12:00:00	AAPL	Stock	53.8625	54.1125	53.8475	54.0075	6908108.0
2018-08-23 13:00:00	AAPL	Stock	54.0075	54.065	53.9625	53.9898	3652956.0
2018-08-23 14:00:00	AAPL	Stock	53.9875	54.1712	53.9875	54.125	5793492.0
2018-08-23 15:00:00	AAPL	Stock	54.125	54.1375	53.7875	53.895	11497268.0
2018-08-23 16:00:00	AAPL	Stock	53.8925	53.935	53.8725	53.9125	7850764.0
2018-08-23 17:00:00	AAPL	Stock	53.9025	53.925	53.9	53.925	59584.0
2018-08-23 18:00:00	AAPL	Stock	53.9125	53.95	53.9	53.95	13112.0
2018-08-23 19:00:00	AAPL	Stock	53.945	53.975	53.925	53.925	26104.0
2018-08-23 04:00:00	MSFT	Stock	107.01	107.01	107.01	107.01	100.0
2018-08-23 07:00:00	MSFT	Stock	107.05	107.06	106.92	107.05	11051.0
2018-08-23 08:00:00	MSFT	Stock	107.01	107.07	106.82	106.9	15013.0
2018-08-23 09:00:00	MSFT	Stock	106.9	108.08	106.74	107.98	2415915.0
2018-08-23 10:00:00	MSFT	Stock	107.99	108.18	107.81	107.89	2103271.0
2018-08-23 11:00:00	MSFT	Stock	107.89	107.935	107.09	107.29	2013597.0
2018-08-23 12:00:00	MSFT	Stock	107.29	107.81	107.29	107.645	1137632.0
2018-08-23 13:00:00	MSFT	Stock	107.645	108.049	107.575	108.02	1108347.0
2018-08-23 14:00:00	MSFT	Stock	108.03	108.18	107.82	107.925	1639289.0
2018-08-23 15:00:00	MSFT	Stock	107.92	107.98	107.345	107.56	3123402.0
2018-08-23 16:00:00	MSFT	Stock	107.56	107.808	107.0	107.17	2407161.0
2018-08-23 17:00:00	MSFT	Stock	107.2	107.3	107.17	107.18	8344.0
2018-08-23 18:00:00	MSFT	Stock	107.18	107.3	107.17	107.3	11258.0
2018-08-23 19:00:00	MSFT	Stock	107.2	107.35	107.2	107.3	5843.0
2018-08-23 04:00:00	NVDA	Stock	6.5625	6.5692	6.5625	6.5692	12520.0
2018-08-23 05:00:00	NVDA	Stock	6.5555	6.5843	6.5555	6.5843	12000.0
2018-08-23 06:00:00	NVDA	Stock	6.585	6.585	6.5542	6.5542	97200.0
2018-08-23 07:00:00	NVDA	Stock	6.55	6.5668	6.55	6.56	307720.0
2018-08-23 08:00:00	NVDA	Stock	6.56	6.5705	6.5392	6.5395	2171520.0
2018-08-23 09:00:00	NVDA	Stock	6.5375	6.6708	6.5175	6.6681	117343000.0
2018-08-23 10:00:00	NVDA	Stock	6.6662	6.7105	6.643	6.6711	126166640.0
2018-08-23 11:00:00	NVDA	Stock	6.6713	6.69	6.5908	6.6712	107345960.0
2018-08-23 12:00:00	NVDA	Stock	6.6708	6.7298	6.6675	6.7108	80695320.0
2018-08-23 13:00:00	NVDA	Stock	6.7104	6.717	6.6915	6.7022	43173360.0
2018-08-23 14:00:00	NVDA	Stock	6.703	6.737	6.7004	6.7118	57387880.0
2018-08-23 15:00:00	NVDA	Stock	6.7115	6.714	6.6405	6.6718	79838840.0
2018-08-23 16:00:00	NVDA	Stock	6.671	6.6895	6.671	6.671	9559880.0
2018-08-23 17:00:00	NVDA	Stock	6.6728	6.6772	6.6688	6.6688	727440.0
2018-08-23 18:00:00	NVDA	Stock	6.6625	6.6702	6.6625	6.6638	259200.0
2018-08-23 19:00:00	NVDA	Stock	6.665	6.6688	6.6612	6.6625	376520.0
2018-08-23 06:00:00	AMZN	Stock	95.359	95.444	95.35	95.35	11260.0
2018-08-23 07:00:00	AMZN	Stock	95.461	95.521	95.345	95.387	203220.0
2018-08-23 08:00:00	AMZN	Stock	95.4964	95.5175	95.245	95.3315	205640.0
2018-08-23 09:00:00	AMZN	Stock	95.35	95.925	95.1872	95.8183	12594940.0

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

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