PREVIEW / stock_1hour / 2020-05-05

all stock 1-hour files

  file:    by_date/stock_1hour/2020/2020-05-05.parquet
  size:    1.2 MB
  rows:    53,996
  symbols: 2,363

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-05-05 04:00:00	AAPL	Stock	73.9	74.04	73.38	73.38	39952.0
2020-05-05 05:00:00	AAPL	Stock	73.38	73.77	73.3	73.77	40124.0
2020-05-05 06:00:00	AAPL	Stock	73.775	73.8075	73.685	73.8075	44172.0
2020-05-05 07:00:00	AAPL	Stock	73.75	74.0	73.7375	73.96	206396.0
2020-05-05 08:00:00	AAPL	Stock	73.8	74.06	73.73	73.95	413012.0
2020-05-05 09:00:00	AAPL	Stock	73.95	74.555	73.615	74.365	18671184.0
2020-05-05 10:00:00	AAPL	Stock	74.3675	74.665	74.145	74.51	16977808.0
2020-05-05 11:00:00	AAPL	Stock	74.5125	74.7675	74.3325	74.725	11504708.0
2020-05-05 12:00:00	AAPL	Stock	74.725	74.95	74.6325	74.83	13385520.0
2020-05-05 13:00:00	AAPL	Stock	74.8275	75.0	74.6675	74.9275	11013824.0
2020-05-05 14:00:00	AAPL	Stock	74.9325	75.245	74.875	75.235	15503984.0
2020-05-05 15:00:00	AAPL	Stock	75.2325	75.25	74.26	74.445	28381016.0
2020-05-05 16:00:00	AAPL	Stock	74.39	74.475	74.29	74.415	5958156.0
2020-05-05 17:00:00	AAPL	Stock	74.42	74.4625	74.3875	74.425	124032.0
2020-05-05 18:00:00	AAPL	Stock	74.4375	74.7525	74.405	74.725	98920.0
2020-05-05 19:00:00	AAPL	Stock	74.725	74.795	74.65	74.7225	79640.0
2020-05-05 04:00:00	MSFT	Stock	180.29	181.02	180.0	180.06	52099.0
2020-05-05 05:00:00	MSFT	Stock	180.06	180.61	180.0	180.6	10318.0
2020-05-05 06:00:00	MSFT	Stock	180.61	181.04	180.61	180.85	5552.0
2020-05-05 07:00:00	MSFT	Stock	180.65	181.0	180.52	180.9	53957.0
2020-05-05 08:00:00	MSFT	Stock	180.6	181.478	180.5	181.29	196589.0
2020-05-05 09:00:00	MSFT	Stock	181.29	181.75	180.03	181.4	5075985.0
2020-05-05 10:00:00	MSFT	Stock	181.41	181.85	181.01	181.51	4098886.0
2020-05-05 11:00:00	MSFT	Stock	181.53	182.329	181.22	182.315	3670992.0
2020-05-05 12:00:00	MSFT	Stock	182.31	182.74	182.05	182.42	3073403.0
2020-05-05 13:00:00	MSFT	Stock	182.415	183.15	182.33	183.15	2513643.0
2020-05-05 14:00:00	MSFT	Stock	183.14	183.63	182.79	183.6	2738033.0
2020-05-05 15:00:00	MSFT	Stock	183.59	183.65	179.9	180.76	7731636.0
2020-05-05 16:00:00	MSFT	Stock	180.76	180.88	180.02	180.88	2241775.0
2020-05-05 17:00:00	MSFT	Stock	180.76	180.9	180.75	180.8	13128.0
2020-05-05 18:00:00	MSFT	Stock	180.75	181.55	180.75	181.55	32712.0
2020-05-05 19:00:00	MSFT	Stock	181.55	181.8	181.37	181.43	20266.0
2020-05-05 04:00:00	NVDA	Stock	7.3565	7.3565	7.3225	7.3225	33680.0
2020-05-05 05:00:00	NVDA	Stock	7.3375	7.3572	7.3302	7.3302	42000.0
2020-05-05 06:00:00	NVDA	Stock	7.3502	7.375	7.3502	7.3735	49760.0
2020-05-05 07:00:00	NVDA	Stock	7.3688	7.41	7.3688	7.4	628520.0
2020-05-05 08:00:00	NVDA	Stock	7.4025	7.4188	7.36	7.4	1095360.0
2020-05-05 09:00:00	NVDA	Stock	7.4	7.4165	7.325	7.4103	54294080.0
2020-05-05 10:00:00	NVDA	Stock	7.413	7.4405	7.349	7.4092	45898400.0
2020-05-05 11:00:00	NVDA	Stock	7.41	7.456	7.3945	7.4487	33255560.0
2020-05-05 12:00:00	NVDA	Stock	7.4486	7.466	7.4068	7.4192	24353160.0
2020-05-05 13:00:00	NVDA	Stock	7.4182	7.4608	7.4175	7.458	23240960.0
2020-05-05 14:00:00	NVDA	Stock	7.4593	7.5068	7.4511	7.4958	31644800.0
2020-05-05 15:00:00	NVDA	Stock	7.495	7.495	7.2823	7.3408	84296160.0
2020-05-05 16:00:00	NVDA	Stock	7.3435	7.4055	7.3316	7.3495	9835640.0
2020-05-05 17:00:00	NVDA	Stock	7.3595	7.375	7.3505	7.3718	237000.0
2020-05-05 18:00:00	NVDA	Stock	7.3638	7.39	7.3638	7.39	224320.0
2020-05-05 19:00:00	NVDA	Stock	7.3842	7.391	7.3775	7.3875	254480.0
2020-05-05 04:00:00	AMZN	Stock	116.6665	116.75	116.6	116.7	59780.0
2020-05-05 05:00:00	AMZN	Stock	116.4	116.45	116.2615	116.45	10380.0

> showing 50 of 53,996 rows — these rows as CSV

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