PREVIEW / stock_1hour / 2018-08-16

all stock 1-hour files

  file:    by_date/stock_1hour/2018/2018-08-16.parquet
  size:    1.1 MB
  rows:    48,849
  symbols: 2,789

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-16 04:00:00	AAPL	Stock	52.675	52.85	52.675	52.85	31068.0
2018-08-16 05:00:00	AAPL	Stock	52.8375	52.875	52.8375	52.8375	7628.0
2018-08-16 06:00:00	AAPL	Stock	52.95	52.96	52.895	52.9525	49508.0
2018-08-16 07:00:00	AAPL	Stock	52.9525	52.9875	52.9075	52.9175	242048.0
2018-08-16 08:00:00	AAPL	Stock	52.915	52.985	52.825	52.8625	478164.0
2018-08-16 09:00:00	AAPL	Stock	52.8575	53.115	52.56	52.9825	16181680.0
2018-08-16 10:00:00	AAPL	Stock	52.9825	53.3138	52.965	53.22	16602940.0
2018-08-16 11:00:00	AAPL	Stock	53.219	53.3825	53.2128	53.3075	11506104.0
2018-08-16 12:00:00	AAPL	Stock	53.305	53.415	53.235	53.2938	9480168.0
2018-08-16 13:00:00	AAPL	Stock	53.295	53.3625	53.2725	53.335	5192804.0
2018-08-16 14:00:00	AAPL	Stock	53.3362	53.45	53.2778	53.3875	9752820.0
2018-08-16 15:00:00	AAPL	Stock	53.39	53.453	53.225	53.37	16697472.0
2018-08-16 16:00:00	AAPL	Stock	53.37	53.37	53.1875	53.24	10632384.0
2018-08-16 17:00:00	AAPL	Stock	53.2375	53.2775	53.225	53.25	138640.0
2018-08-16 18:00:00	AAPL	Stock	53.275	53.28	53.2325	53.25	49356.0
2018-08-16 19:00:00	AAPL	Stock	53.25	53.2775	53.2475	53.2475	48296.0
2018-08-16 04:00:00	MSFT	Stock	108.0	108.26	108.0	108.26	2100.0
2018-08-16 05:00:00	MSFT	Stock	108.47	108.55	108.35	108.55	3080.0
2018-08-16 06:00:00	MSFT	Stock	108.65	108.67	108.46	108.51	1789.0
2018-08-16 07:00:00	MSFT	Stock	108.6	108.69	108.43	108.45	11856.0
2018-08-16 08:00:00	MSFT	Stock	108.68	108.7	107.66	108.24	29419.0
2018-08-16 09:00:00	MSFT	Stock	108.24	108.86	107.95	108.03	2222068.0
2018-08-16 10:00:00	MSFT	Stock	108.03	108.43	107.96	108.06	2232721.0
2018-08-16 11:00:00	MSFT	Stock	108.06	108.45	108.058	108.31	1353624.0
2018-08-16 12:00:00	MSFT	Stock	108.305	108.52	108.16	108.23	1142196.0
2018-08-16 13:00:00	MSFT	Stock	108.22	108.325	107.85	107.85	1470431.0
2018-08-16 14:00:00	MSFT	Stock	107.855	108.03	107.53	107.696	2440124.0
2018-08-16 15:00:00	MSFT	Stock	107.71	107.785	107.3	107.64	4082349.0
2018-08-16 16:00:00	MSFT	Stock	107.64	108.448	107.4	107.64	3806549.0
2018-08-16 17:00:00	MSFT	Stock	107.64	107.77	107.58	107.77	3339.0
2018-08-16 18:00:00	MSFT	Stock	107.65	107.71	107.44	107.44	6768.0
2018-08-16 19:00:00	MSFT	Stock	107.5	107.5	107.5	107.5	350.0
2018-08-16 04:00:00	NVDA	Stock	6.5275	6.5338	6.525	6.5338	111880.0
2018-08-16 05:00:00	NVDA	Stock	6.5323	6.5323	6.5323	6.5323	6320.0
2018-08-16 06:00:00	NVDA	Stock	6.5318	6.55	6.5318	6.5415	82000.0
2018-08-16 07:00:00	NVDA	Stock	6.54	6.555	6.54	6.5475	1135840.0
2018-08-16 08:00:00	NVDA	Stock	6.5475	6.5625	6.5402	6.55	3226760.0
2018-08-16 09:00:00	NVDA	Stock	6.5488	6.556	6.3752	6.3783	101688760.0
2018-08-16 10:00:00	NVDA	Stock	6.3778	6.4373	6.3778	6.409	80774680.0
2018-08-16 11:00:00	NVDA	Stock	6.4088	6.4948	6.4077	6.4762	76676280.0
2018-08-16 12:00:00	NVDA	Stock	6.4761	6.5278	6.4761	6.483	82836560.0
2018-08-16 13:00:00	NVDA	Stock	6.483	6.5	6.4638	6.472	48293560.0
2018-08-16 14:00:00	NVDA	Stock	6.4713	6.4859	6.4408	6.4804	54945160.0
2018-08-16 15:00:00	NVDA	Stock	6.48	6.492	6.4194	6.4382	105870600.0
2018-08-16 16:00:00	NVDA	Stock	6.436	6.4963	6.0235	6.1758	97157560.0
2018-08-16 17:00:00	NVDA	Stock	6.1835	6.2475	6.15	6.2015	26613160.0
2018-08-16 18:00:00	NVDA	Stock	6.211	6.2175	6.1043	6.1212	12987080.0
2018-08-16 19:00:00	NVDA	Stock	6.1212	6.1388	6.1125	6.1388	3946800.0
2018-08-16 04:00:00	AMZN	Stock	94.945	95.03	94.863	95.03	12200.0
2018-08-16 05:00:00	AMZN	Stock	94.995	95.0955	94.995	95.0955	19840.0

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

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