PREVIEW / stock_1hour / 2020-07-31

all stock 1-hour files

  file:    by_date/stock_1hour/2020/2020-07-31.parquet
  size:    1.3 MB
  rows:    57,556
  symbols: 2,464

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-07-31 04:00:00	AAPL	Stock	102.335	102.39	101.75	102.135	189884.0
2020-07-31 05:00:00	AAPL	Stock	102.1575	102.275	102.0875	102.115	32140.0
2020-07-31 06:00:00	AAPL	Stock	102.0975	102.235	101.9325	102.1375	78032.0
2020-07-31 07:00:00	AAPL	Stock	102.125	103.4875	102.125	103.2925	2206512.0
2020-07-31 08:00:00	AAPL	Stock	103.175	103.4925	102.25	102.375	3224952.0
2020-07-31 09:00:00	AAPL	Stock	102.355	103.0	100.825	102.625	56962448.0
2020-07-31 10:00:00	AAPL	Stock	102.6238	102.645	101.0225	102.31	38787300.0
2020-07-31 11:00:00	AAPL	Stock	102.3188	103.055	102.175	102.5975	29725096.0
2020-07-31 12:00:00	AAPL	Stock	102.5925	102.83	102.0375	102.2275	17775512.0
2020-07-31 13:00:00	AAPL	Stock	102.22	103.17	102.165	103.0	20701168.0
2020-07-31 14:00:00	AAPL	Stock	102.9975	104.4375	102.9075	104.17	32459496.0
2020-07-31 15:00:00	AAPL	Stock	104.1575	106.415	104.1075	106.2975	75322508.0
2020-07-31 16:00:00	AAPL	Stock	106.2975	106.7	106.2	106.55	14483064.0
2020-07-31 17:00:00	AAPL	Stock	106.5625	106.985	106.55	106.825	976868.0
2020-07-31 18:00:00	AAPL	Stock	106.83	106.94	106.7625	106.91	261724.0
2020-07-31 19:00:00	AAPL	Stock	106.8875	106.9625	106.7875	106.86	454568.0
2020-07-31 04:00:00	MSFT	Stock	204.75	205.2	204.6	205.2	4448.0
2020-07-31 05:00:00	MSFT	Stock	205.11	205.46	204.52	204.52	3526.0
2020-07-31 06:00:00	MSFT	Stock	204.8	205.0	204.8	205.0	5398.0
2020-07-31 07:00:00	MSFT	Stock	204.99	205.0	204.45	204.8	31360.0
2020-07-31 08:00:00	MSFT	Stock	204.862	205.11	204.4	204.91	97181.0
2020-07-31 09:00:00	MSFT	Stock	204.893	204.94	200.13	200.97	6110073.0
2020-07-31 10:00:00	MSFT	Stock	200.96	201.01	199.01	200.86	6555921.0
2020-07-31 11:00:00	MSFT	Stock	200.87	202.55	200.7	201.225	3475524.0
2020-07-31 12:00:00	MSFT	Stock	201.21	201.469	199.88	200.06	2609700.0
2020-07-31 13:00:00	MSFT	Stock	200.05	201.98	199.995	201.15	2951892.0
2020-07-31 14:00:00	MSFT	Stock	201.15	202.62	200.25	202.59	3797295.0
2020-07-31 15:00:00	MSFT	Stock	202.59	205.1	202.41	205.1	9180056.0
2020-07-31 16:00:00	MSFT	Stock	205.1	205.15	204.73	205.07	6447663.0
2020-07-31 17:00:00	MSFT	Stock	205.07	205.65	204.97	205.65	126581.0
2020-07-31 18:00:00	MSFT	Stock	205.65	206.87	205.55	205.74	153082.0
2020-07-31 19:00:00	MSFT	Stock	205.55	206.75	205.43	205.5	78223.0
2020-07-31 04:00:00	NVDA	Stock	10.6445	10.6445	10.6445	10.6445	10680.0
2020-07-31 05:00:00	NVDA	Stock	10.7095	10.715	10.6285	10.7002	330160.0
2020-07-31 06:00:00	NVDA	Stock	10.6965	10.7125	10.51	10.525	664840.0
2020-07-31 07:00:00	NVDA	Stock	10.5248	10.614	10.5248	10.5755	1570520.0
2020-07-31 08:00:00	NVDA	Stock	10.5916	10.6213	10.55	10.6008	1711120.0
2020-07-31 09:00:00	NVDA	Stock	10.6033	10.7665	10.476	10.6574	71752000.0
2020-07-31 10:00:00	NVDA	Stock	10.6585	10.6643	10.433	10.5332	64292920.0
2020-07-31 11:00:00	NVDA	Stock	10.5338	10.6481	10.519	10.5888	42252880.0
2020-07-31 12:00:00	NVDA	Stock	10.5882	10.6017	10.443	10.473	44332920.0
2020-07-31 13:00:00	NVDA	Stock	10.4732	10.525	10.4593	10.475	24645160.0
2020-07-31 14:00:00	NVDA	Stock	10.472	10.5462	10.4455	10.54	22283240.0
2020-07-31 15:00:00	NVDA	Stock	10.5398	10.6165	10.5255	10.6145	40059440.0
2020-07-31 16:00:00	NVDA	Stock	10.6148	10.6172	10.5938	10.6075	5443840.0
2020-07-31 17:00:00	NVDA	Stock	10.6065	10.6148	10.6025	10.6063	822320.0
2020-07-31 18:00:00	NVDA	Stock	10.6068	10.6098	10.603	10.6098	106960.0
2020-07-31 19:00:00	NVDA	Stock	10.6063	10.6063	10.6	10.605	60200.0
2020-07-31 04:00:00	AMZN	Stock	160.5	161.0055	160.5	161.0055	28260.0
2020-07-31 05:00:00	AMZN	Stock	160.9	161.0995	160.85	160.85	55080.0

> showing 50 of 57,556 rows — these rows as CSV

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