PREVIEW / stock_1hour / 2018-08-17

all stock 1-hour files

  file:    by_date/stock_1hour/2018/2018-08-17.parquet
  size:    1.1 MB
  rows:    48,215
  symbols: 2,786

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-17 04:00:00	AAPL	Stock	53.375	53.5	53.375	53.45	12680.0
2018-08-17 05:00:00	AAPL	Stock	53.425	53.45	53.28	53.28	19652.0
2018-08-17 06:00:00	AAPL	Stock	53.28	53.335	53.2725	53.335	31140.0
2018-08-17 07:00:00	AAPL	Stock	53.3475	53.3775	53.3	53.3	63324.0
2018-08-17 08:00:00	AAPL	Stock	53.3625	53.375	53.2	53.265	277044.0
2018-08-17 09:00:00	AAPL	Stock	53.2725	53.8	53.2375	53.6725	21102112.0
2018-08-17 10:00:00	AAPL	Stock	53.67	53.835	53.42	53.8242	19769052.0
2018-08-17 11:00:00	AAPL	Stock	53.8275	54.42	53.755	54.325	22497956.0
2018-08-17 12:00:00	AAPL	Stock	54.3292	54.34	54.025	54.08	14444304.0
2018-08-17 13:00:00	AAPL	Stock	54.08	54.23	54.0575	54.1825	8423824.0
2018-08-17 14:00:00	AAPL	Stock	54.1832	54.3875	54.1675	54.3375	11617628.0
2018-08-17 15:00:00	AAPL	Stock	54.3375	54.4875	54.2355	54.4025	17958460.0
2018-08-17 16:00:00	AAPL	Stock	54.4025	54.4025	54.365	54.3875	5206692.0
2018-08-17 17:00:00	AAPL	Stock	54.3825	54.3875	54.37	54.37	86832.0
2018-08-17 18:00:00	AAPL	Stock	54.375	54.3775	54.3525	54.3525	61140.0
2018-08-17 19:00:00	AAPL	Stock	54.3575	54.3825	54.3575	54.3825	37724.0
2018-08-17 06:00:00	MSFT	Stock	107.5	107.5	107.5	107.5	1504.0
2018-08-17 07:00:00	MSFT	Stock	107.49	107.73	107.49	107.73	539.0
2018-08-17 08:00:00	MSFT	Stock	107.5	107.77	107.33	107.58	16734.0
2018-08-17 09:00:00	MSFT	Stock	107.585	107.588	106.95	107.14	3126720.0
2018-08-17 10:00:00	MSFT	Stock	107.12	107.255	106.69	106.93	2257802.0
2018-08-17 11:00:00	MSFT	Stock	106.94	107.24	106.78	107.195	2068005.0
2018-08-17 12:00:00	MSFT	Stock	107.195	107.24	106.95	106.96	954290.0
2018-08-17 13:00:00	MSFT	Stock	106.95	107.135	106.87	107.075	1063616.0
2018-08-17 14:00:00	MSFT	Stock	107.065	107.9	107.0	107.79	2243642.0
2018-08-17 15:00:00	MSFT	Stock	107.78	107.82	107.46	107.58	2682512.0
2018-08-17 16:00:00	MSFT	Stock	107.58	107.63	107.47	107.473	1881444.0
2018-08-17 17:00:00	MSFT	Stock	107.6	107.65	107.31	107.31	2431.0
2018-08-17 18:00:00	MSFT	Stock	107.46	107.46	107.46	107.46	645.0
2018-08-17 19:00:00	MSFT	Stock	107.44	107.47	107.44	107.47	445.0
2018-08-17 04:00:00	NVDA	Stock	6.145	6.1998	6.145	6.1998	356680.0
2018-08-17 05:00:00	NVDA	Stock	6.1958	6.1962	6.1748	6.1825	182840.0
2018-08-17 06:00:00	NVDA	Stock	6.1875	6.2	6.1752	6.1825	542240.0
2018-08-17 07:00:00	NVDA	Stock	6.175	6.2795	6.162	6.2505	7752160.0
2018-08-17 08:00:00	NVDA	Stock	6.188	6.3112	6.1562	6.2902	17905760.0
2018-08-17 09:00:00	NVDA	Stock	6.2898	6.3305	6.1403	6.147	242073640.0
2018-08-17 10:00:00	NVDA	Stock	6.1468	6.1992	6.135	6.1735	207824880.0
2018-08-17 11:00:00	NVDA	Stock	6.1743	6.1852	6.1378	6.1843	114505000.0
2018-08-17 12:00:00	NVDA	Stock	6.1838	6.1905	6.1045	6.1153	116540200.0
2018-08-17 13:00:00	NVDA	Stock	6.115	6.175	6.1134	6.1363	101728920.0
2018-08-17 14:00:00	NVDA	Stock	6.1355	6.1588	6.1208	6.1304	68292880.0
2018-08-17 15:00:00	NVDA	Stock	6.1305	6.1326	6.0932	6.1225	126250960.0
2018-08-17 16:00:00	NVDA	Stock	6.1205	6.127	6.1075	6.1163	22038480.0
2018-08-17 17:00:00	NVDA	Stock	6.1163	6.1208	6.1025	6.1025	516080.0
2018-08-17 18:00:00	NVDA	Stock	6.1025	6.1092	6.0952	6.1025	809080.0
2018-08-17 19:00:00	NVDA	Stock	6.1002	6.108	6.1002	6.1025	488320.0
2018-08-17 04:00:00	AMZN	Stock	94.5	94.5	94.5	94.5	2000.0
2018-08-17 06:00:00	AMZN	Stock	94.063	94.119	94.063	94.119	5900.0
2018-08-17 07:00:00	AMZN	Stock	94.342	94.3715	94.153	94.156	78480.0
2018-08-17 08:00:00	AMZN	Stock	94.191	94.55	94.007	94.2655	135700.0

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

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