PREVIEW / stock_1hour / 2019-08-26

all stock 1-hour files

  file:    by_date/stock_1hour/2019/2019-08-26.parquet
  size:    1.1 MB
  rows:    50,141
  symbols: 2,548

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-26 04:00:00	AAPL	Stock	51.025	51.71	51.025	51.6375	155596.0
2019-08-26 05:00:00	AAPL	Stock	51.6375	51.7	51.04	51.25	136700.0
2019-08-26 06:00:00	AAPL	Stock	51.2475	51.7125	51.1875	51.4775	132432.0
2019-08-26 07:00:00	AAPL	Stock	51.4075	51.7	51.34	51.49	663712.0
2019-08-26 08:00:00	AAPL	Stock	51.5475	51.7	51.303	51.6075	899632.0
2019-08-26 09:00:00	AAPL	Stock	51.57	51.7975	51.375	51.615	19515940.0
2019-08-26 10:00:00	AAPL	Stock	51.615	51.7125	51.2642	51.545	16047008.0
2019-08-26 11:00:00	AAPL	Stock	51.5442	51.7	51.4325	51.5127	8847608.0
2019-08-26 12:00:00	AAPL	Stock	51.5112	51.795	51.4725	51.685	7943088.0
2019-08-26 13:00:00	AAPL	Stock	51.68	51.7475	51.465	51.485	6243924.0
2019-08-26 14:00:00	AAPL	Stock	51.49	51.505	51.33	51.42	6177804.0
2019-08-26 15:00:00	AAPL	Stock	51.42	51.65	51.295	51.65	14255444.0
2019-08-26 16:00:00	AAPL	Stock	51.6225	51.7125	51.6	51.6375	7538644.0
2019-08-26 17:00:00	AAPL	Stock	51.6375	51.725	51.62	51.6875	90516.0
2019-08-26 18:00:00	AAPL	Stock	51.68	51.7125	51.6275	51.6425	71696.0
2019-08-26 19:00:00	AAPL	Stock	51.6375	51.645	51.55	51.575	40172.0
2019-08-26 04:00:00	MSFT	Stock	134.01	135.45	133.39	135.42	16676.0
2019-08-26 05:00:00	MSFT	Stock	135.45	136.2	134.74	135.07	10822.0
2019-08-26 06:00:00	MSFT	Stock	135.15	135.57	135.15	135.41	2873.0
2019-08-26 07:00:00	MSFT	Stock	135.25	135.38	134.85	134.9	29875.0
2019-08-26 08:00:00	MSFT	Stock	135.002	135.35	134.58	135.25	55979.0
2019-08-26 09:00:00	MSFT	Stock	135.25	135.28	134.15	134.76	2528182.0
2019-08-26 10:00:00	MSFT	Stock	134.76	134.94	133.9	134.635	2370511.0
2019-08-26 11:00:00	MSFT	Stock	134.64	135.16	134.49	134.98	1837852.0
2019-08-26 12:00:00	MSFT	Stock	134.99	135.45	134.87	135.179	1350492.0
2019-08-26 13:00:00	MSFT	Stock	135.18	135.32	134.81	134.945	981422.0
2019-08-26 14:00:00	MSFT	Stock	134.95	135.07	134.73	134.995	1298997.0
2019-08-26 15:00:00	MSFT	Stock	134.99	135.56	134.76	135.54	3224779.0
2019-08-26 16:00:00	MSFT	Stock	135.45	135.79	135.45	135.64	3583278.0
2019-08-26 17:00:00	MSFT	Stock	135.67	135.67	135.5	135.55	8011.0
2019-08-26 18:00:00	MSFT	Stock	135.55	135.6	135.35	135.38	9582.0
2019-08-26 19:00:00	MSFT	Stock	135.38	135.5	135.31	135.35	6379.0
2019-08-26 04:00:00	NVDA	Stock	4.0875	4.1678	4.0875	4.1565	364840.0
2019-08-26 05:00:00	NVDA	Stock	4.1538	4.1625	4.125	4.125	233040.0
2019-08-26 06:00:00	NVDA	Stock	4.125	4.1375	4.1115	4.1198	135120.0
2019-08-26 07:00:00	NVDA	Stock	4.1198	4.15	4.1125	4.1313	1856640.0
2019-08-26 08:00:00	NVDA	Stock	4.13	4.14	4.105	4.135	3243240.0
2019-08-26 09:00:00	NVDA	Stock	4.1302	4.1645	4.0978	4.138	71702440.0
2019-08-26 10:00:00	NVDA	Stock	4.1382	4.15	4.1056	4.1387	42440280.0
2019-08-26 11:00:00	NVDA	Stock	4.1382	4.1638	4.1338	4.152	42971000.0
2019-08-26 12:00:00	NVDA	Stock	4.1508	4.1605	4.1358	4.1443	19076400.0
2019-08-26 13:00:00	NVDA	Stock	4.145	4.1495	4.131	4.135	17286840.0
2019-08-26 14:00:00	NVDA	Stock	4.135	4.135	4.121	4.1285	18807600.0
2019-08-26 15:00:00	NVDA	Stock	4.1285	4.1398	4.1118	4.1365	42474960.0
2019-08-26 16:00:00	NVDA	Stock	4.1362	4.14	4.1263	4.1365	16070960.0
2019-08-26 17:00:00	NVDA	Stock	4.14	4.14	4.1332	4.1362	112480.0
2019-08-26 18:00:00	NVDA	Stock	4.1388	4.142	4.1362	4.1388	248480.0
2019-08-26 19:00:00	NVDA	Stock	4.1388	4.1388	4.1275	4.1275	239840.0
2019-08-26 04:00:00	AMZN	Stock	88.2	88.95	88.2	88.95	70480.0
2019-08-26 05:00:00	AMZN	Stock	88.857	89.095	88.75	88.75	25400.0

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

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