PREVIEW / stock_1hour / 2020-09-16

all stock 1-hour files

  file:    by_date/stock_1hour/2020/2020-09-16.parquet
  size:    1.2 MB
  rows:    56,796
  symbols: 2,484

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
2020-09-16 04:00:00	AAPL	Stock	115.51	116.3	115.25	116.0	84815.0
2020-09-16 05:00:00	AAPL	Stock	116.08	116.5	116.08	116.18	40837.0
2020-09-16 06:00:00	AAPL	Stock	116.18	116.64	115.6	116.39	57878.0
2020-09-16 07:00:00	AAPL	Stock	116.33	116.35	114.88	115.6	631907.0
2020-09-16 08:00:00	AAPL	Stock	115.61	116.21	114.88	115.12	959180.0
2020-09-16 09:00:00	AAPL	Stock	115.11	116.0	114.18	114.86	16348740.0
2020-09-16 10:00:00	AAPL	Stock	114.87	115.05	113.35	113.87	20009487.0
2020-09-16 11:00:00	AAPL	Stock	113.87	114.39	113.6	113.676	12998913.0
2020-09-16 12:00:00	AAPL	Stock	113.67	113.85	113.14	113.345	11983197.0
2020-09-16 13:00:00	AAPL	Stock	113.346	113.57	112.75	113.41	14106864.0
2020-09-16 14:00:00	AAPL	Stock	113.463	114.6	113.02	113.295	19887204.0
2020-09-16 15:00:00	AAPL	Stock	113.295	113.46	112.04	112.13	25674368.0
2020-09-16 16:00:00	AAPL	Stock	112.11	114.403	112.0	112.54	9212301.0
2020-09-16 17:00:00	AAPL	Stock	112.54	112.7	112.45	112.7	175169.0
2020-09-16 18:00:00	AAPL	Stock	112.71	112.8	112.5	112.71	166386.0
2020-09-16 19:00:00	AAPL	Stock	112.73	112.82	112.56	112.8	161701.0
2020-09-16 04:00:00	MSFT	Stock	210.5	211.26	210.5	211.01	5869.0
2020-09-16 05:00:00	MSFT	Stock	211.24	211.45	211.05	211.05	3674.0
2020-09-16 06:00:00	MSFT	Stock	211.08	211.2	210.6	211.2	4047.0
2020-09-16 07:00:00	MSFT	Stock	211.28	211.4	210.22	210.93	78095.0
2020-09-16 08:00:00	MSFT	Stock	211.1	211.146	210.1	210.75	73648.0
2020-09-16 09:00:00	MSFT	Stock	210.82	210.82	207.81	208.74	2668516.0
2020-09-16 10:00:00	MSFT	Stock	208.75	208.9	206.78	207.69	2605443.0
2020-09-16 11:00:00	MSFT	Stock	207.68	209.21	207.51	208.22	1881678.0
2020-09-16 12:00:00	MSFT	Stock	208.23	208.79	207.39	207.79	1199967.0
2020-09-16 13:00:00	MSFT	Stock	207.78	208.0	206.47	207.42	1444273.0
2020-09-16 14:00:00	MSFT	Stock	207.37	209.21	206.89	207.16	2544458.0
2020-09-16 15:00:00	MSFT	Stock	207.13	207.59	204.64	204.93	5221064.0
2020-09-16 16:00:00	MSFT	Stock	205.05	205.47	204.69	204.79	3495028.0
2020-09-16 17:00:00	MSFT	Stock	204.94	205.23	204.76	205.19	13860.0
2020-09-16 18:00:00	MSFT	Stock	205.19	205.94	205.05	205.75	21193.0
2020-09-16 19:00:00	MSFT	Stock	205.7	206.0	205.51	205.51	19731.0
2020-09-16 04:00:00	NVDA	Stock	13.125	13.15	13.075	13.125	514560.0
2020-09-16 05:00:00	NVDA	Stock	13.1238	13.1375	13.1	13.1	65160.0
2020-09-16 06:00:00	NVDA	Stock	13.1	13.103	13.041	13.1	189040.0
2020-09-16 07:00:00	NVDA	Stock	13.0988	13.0988	12.89	12.948	1843720.0
2020-09-16 08:00:00	NVDA	Stock	12.9275	13.0787	12.8778	12.945	1212560.0
2020-09-16 09:00:00	NVDA	Stock	12.9402	13.0928	12.7538	12.8821	76107520.0
2020-09-16 10:00:00	NVDA	Stock	12.8816	12.9	12.6413	12.7045	79971640.0
2020-09-16 11:00:00	NVDA	Stock	12.703	12.8095	12.6945	12.7315	57803600.0
2020-09-16 12:00:00	NVDA	Stock	12.7368	12.8042	12.674	12.6948	33500680.0
2020-09-16 13:00:00	NVDA	Stock	12.6912	12.7172	12.6	12.6953	37720120.0
2020-09-16 14:00:00	NVDA	Stock	12.6993	12.804	12.6705	12.7043	51900240.0
2020-09-16 15:00:00	NVDA	Stock	12.7048	12.7375	12.5138	12.514	83545120.0
2020-09-16 16:00:00	NVDA	Stock	12.5145	12.5905	12.5125	12.5692	13411240.0
2020-09-16 17:00:00	NVDA	Stock	12.57	12.5793	12.5575	12.5662	232560.0
2020-09-16 18:00:00	NVDA	Stock	12.5625	12.6112	12.5558	12.5818	272240.0
2020-09-16 19:00:00	NVDA	Stock	12.583	12.6025	12.5575	12.5955	322880.0
2020-09-16 05:00:00	AMZN	Stock	159.75	159.75	159.75	159.75	6220.0
2020-09-16 06:00:00	AMZN	Stock	159.1505	159.5	159.15	159.5	10000.0

> showing 50 of 56,796 rows — these rows as CSV

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