PREVIEW / stock_1hour / 2019-08-29

all stock 1-hour files

  file:    by_date/stock_1hour/2019/2019-08-29.parquet
  size:    1.1 MB
  rows:    50,620
  symbols: 2,579

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-08-29 04:00:00	AAPL	Stock	51.85	52.0025	51.85	51.975	31156.0
2019-08-29 05:00:00	AAPL	Stock	52.0	52.2125	52.0	52.2125	41900.0
2019-08-29 06:00:00	AAPL	Stock	52.195	52.2625	52.175	52.25	56880.0
2019-08-29 07:00:00	AAPL	Stock	52.25	52.255	52.085	52.145	201312.0
2019-08-29 08:00:00	AAPL	Stock	52.2025	52.25	52.03	52.1375	530544.0
2019-08-29 09:00:00	AAPL	Stock	52.1	52.3075	52.03	52.0675	12988112.0
2019-08-29 10:00:00	AAPL	Stock	52.065	52.0775	51.6638	51.9475	11148584.0
2019-08-29 11:00:00	AAPL	Stock	51.95	52.065	51.885	52.01	6561512.0
2019-08-29 12:00:00	AAPL	Stock	52.01	52.23	51.9725	52.1375	9050552.0
2019-08-29 13:00:00	AAPL	Stock	52.135	52.2225	52.1082	52.22	4213812.0
2019-08-29 14:00:00	AAPL	Stock	52.22	52.33	52.1025	52.14	8968776.0
2019-08-29 15:00:00	AAPL	Stock	52.1425	52.275	52.065	52.275	11063084.0
2019-08-29 16:00:00	AAPL	Stock	52.295	52.295	52.1235	52.2275	7757876.0
2019-08-29 17:00:00	AAPL	Stock	52.23	52.25	52.205	52.2275	27900.0
2019-08-29 18:00:00	AAPL	Stock	52.2075	52.225	52.1875	52.195	45016.0
2019-08-29 19:00:00	AAPL	Stock	52.2125	52.25	52.175	52.2	35036.0
2019-08-29 04:00:00	MSFT	Stock	136.16	136.72	136.16	136.66	1922.0
2019-08-29 05:00:00	MSFT	Stock	136.91	137.49	136.91	137.36	2800.0
2019-08-29 06:00:00	MSFT	Stock	137.36	137.36	137.3	137.3	2023.0
2019-08-29 07:00:00	MSFT	Stock	137.28	137.4	136.9	137.11	70158.0
2019-08-29 08:00:00	MSFT	Stock	137.15	137.3	136.914	137.15	44119.0
2019-08-29 09:00:00	MSFT	Stock	137.15	138.3	137.02	137.985	2984385.0
2019-08-29 10:00:00	MSFT	Stock	137.98	138.17	136.91	137.62	2837002.0
2019-08-29 11:00:00	MSFT	Stock	137.601	138.2	137.54	138.02	1486127.0
2019-08-29 12:00:00	MSFT	Stock	137.975	138.42	137.86	138.14	1750715.0
2019-08-29 13:00:00	MSFT	Stock	138.14	138.41	138.06	138.24	1064556.0
2019-08-29 14:00:00	MSFT	Stock	138.24	138.44	138.04	138.09	1256680.0
2019-08-29 15:00:00	MSFT	Stock	138.1	138.3	137.69	138.16	2760774.0
2019-08-29 16:00:00	MSFT	Stock	138.13	138.21	137.86	138.1	2446401.0
2019-08-29 17:00:00	MSFT	Stock	138.0	138.25	138.0	138.036	17657.0
2019-08-29 18:00:00	MSFT	Stock	138.08	138.11	137.9	138.01	7437.0
2019-08-29 19:00:00	MSFT	Stock	138.01	138.1	137.9	137.95	8272.0
2019-08-29 04:00:00	NVDA	Stock	4.0752	4.0875	4.07	4.0872	81240.0
2019-08-29 05:00:00	NVDA	Stock	4.094	4.094	4.094	4.094	11640.0
2019-08-29 06:00:00	NVDA	Stock	4.105	4.1123	4.1048	4.1123	51120.0
2019-08-29 07:00:00	NVDA	Stock	4.1158	4.1288	4.1	4.1288	1046400.0
2019-08-29 08:00:00	NVDA	Stock	4.1075	4.13	4.1008	4.1203	1418320.0
2019-08-29 09:00:00	NVDA	Stock	4.1162	4.181	4.1145	4.1704	70729640.0
2019-08-29 10:00:00	NVDA	Stock	4.1705	4.1875	4.137	4.1725	72362280.0
2019-08-29 11:00:00	NVDA	Stock	4.1725	4.1935	4.166	4.1828	48726120.0
2019-08-29 12:00:00	NVDA	Stock	4.1818	4.1978	4.1765	4.1925	30114880.0
2019-08-29 13:00:00	NVDA	Stock	4.1925	4.2028	4.1852	4.2019	26812600.0
2019-08-29 14:00:00	NVDA	Stock	4.2028	4.2075	4.18	4.1828	38326400.0
2019-08-29 15:00:00	NVDA	Stock	4.1822	4.1895	4.1678	4.1748	52853440.0
2019-08-29 16:00:00	NVDA	Stock	4.175	4.1788	4.1675	4.175	3522320.0
2019-08-29 17:00:00	NVDA	Stock	4.1722	4.1758	4.172	4.1749	91400.0
2019-08-29 18:00:00	NVDA	Stock	4.1722	4.173	4.1718	4.1718	188320.0
2019-08-29 19:00:00	NVDA	Stock	4.173	4.175	4.1708	4.1708	302000.0
2019-08-29 04:00:00	AMZN	Stock	88.885	89.0	88.885	89.0	21280.0
2019-08-29 05:00:00	AMZN	Stock	89.006	89.006	89.006	89.006	9360.0

> showing 50 of 50,620 rows — these rows as CSV

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