PREVIEW / stock_1hour / 2020-09-24

all stock 1-hour files

  file:    by_date/stock_1hour/2020/2020-09-24.parquet
  size:    1.2 MB
  rows:    57,280
  symbols: 2,496

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-24 04:00:00	AAPL	Stock	106.5	106.85	105.82	106.31	58057.0
2020-09-24 05:00:00	AAPL	Stock	106.25	106.3	105.9	106.09	23452.0
2020-09-24 06:00:00	AAPL	Stock	106.19	107.01	106.19	106.55	46243.0
2020-09-24 07:00:00	AAPL	Stock	106.53	106.68	105.83	105.91	321052.0
2020-09-24 08:00:00	AAPL	Stock	106.431	106.6	105.0	105.31	1227485.0
2020-09-24 09:00:00	AAPL	Stock	105.31	108.97	104.8	108.71	23825447.0
2020-09-24 10:00:00	AAPL	Stock	108.72	109.3	107.61	109.16	26638764.0
2020-09-24 11:00:00	AAPL	Stock	109.16	110.05	108.22	109.57	18879160.0
2020-09-24 12:00:00	AAPL	Stock	109.57	110.25	108.67	109.57	16056478.0
2020-09-24 13:00:00	AAPL	Stock	109.56	110.2	109.35	109.48	14109063.0
2020-09-24 14:00:00	AAPL	Stock	109.48	109.72	108.07	108.11	15516850.0
2020-09-24 15:00:00	AAPL	Stock	108.11	108.99	107.53	108.202	24013964.0
2020-09-24 16:00:00	AAPL	Stock	108.2	109.4	108.0	108.68	8906646.0
2020-09-24 17:00:00	AAPL	Stock	108.69	109.0	108.22	108.98	211721.0
2020-09-24 18:00:00	AAPL	Stock	109.0	109.28	108.81	108.97	173621.0
2020-09-24 19:00:00	AAPL	Stock	108.98	109.25	108.8	109.0	283041.0
2020-09-24 04:00:00	MSFT	Stock	200.51	200.51	199.88	200.02	5596.0
2020-09-24 05:00:00	MSFT	Stock	199.87	200.38	199.61	200.13	3181.0
2020-09-24 06:00:00	MSFT	Stock	200.3	201.88	200.3	201.88	7694.0
2020-09-24 07:00:00	MSFT	Stock	201.42	201.42	200.13	200.17	25191.0
2020-09-24 08:00:00	MSFT	Stock	201.28	201.4	198.04	198.8	163466.0
2020-09-24 09:00:00	MSFT	Stock	198.8	203.21	198.06	202.44	3768265.0
2020-09-24 10:00:00	MSFT	Stock	202.42	204.47	201.63	203.99	4731258.0
2020-09-24 11:00:00	MSFT	Stock	203.97	205.09	202.67	204.836	2878228.0
2020-09-24 12:00:00	MSFT	Stock	204.86	205.57	203.99	204.94	2471057.0
2020-09-24 13:00:00	MSFT	Stock	204.965	205.505	204.23	204.33	2348602.0
2020-09-24 14:00:00	MSFT	Stock	204.33	204.58	202.66	202.712	2555140.0
2020-09-24 15:00:00	MSFT	Stock	202.73	203.85	201.81	203.18	4052937.0
2020-09-24 16:00:00	MSFT	Stock	203.19	204.875	203.01	203.6	3295174.0
2020-09-24 17:00:00	MSFT	Stock	203.75	203.78	203.19	203.53	21472.0
2020-09-24 18:00:00	MSFT	Stock	203.7	204.25	203.7	204.1	12352.0
2020-09-24 19:00:00	MSFT	Stock	204.0	204.8	203.88	204.75	33033.0
2020-09-24 04:00:00	NVDA	Stock	12.05	12.0755	12.0192	12.05	78640.0
2020-09-24 05:00:00	NVDA	Stock	12.0338	12.05	12.0275	12.05	54320.0
2020-09-24 06:00:00	NVDA	Stock	12.045	12.125	12.045	12.125	33600.0
2020-09-24 07:00:00	NVDA	Stock	12.0875	12.1313	12.0538	12.0558	475400.0
2020-09-24 08:00:00	NVDA	Stock	12.085	12.1535	11.9278	11.9688	2243160.0
2020-09-24 09:00:00	NVDA	Stock	11.9685	12.4435	11.9348	12.3575	128449640.0
2020-09-24 10:00:00	NVDA	Stock	12.3575	12.4915	12.1975	12.3683	148426920.0
2020-09-24 11:00:00	NVDA	Stock	12.3633	12.5656	12.3125	12.5424	84634920.0
2020-09-24 12:00:00	NVDA	Stock	12.544	12.55	12.3953	12.4877	56800440.0
2020-09-24 13:00:00	NVDA	Stock	12.485	12.5695	12.4628	12.4728	52562520.0
2020-09-24 14:00:00	NVDA	Stock	12.4785	12.5368	12.4035	12.4108	58078680.0
2020-09-24 15:00:00	NVDA	Stock	12.4113	12.4438	12.2552	12.348	115345680.0
2020-09-24 16:00:00	NVDA	Stock	12.348	12.4816	12.3365	12.3865	9023960.0
2020-09-24 17:00:00	NVDA	Stock	12.386	12.4	12.348	12.4	260120.0
2020-09-24 18:00:00	NVDA	Stock	12.4035	12.45	12.4	12.4463	935080.0
2020-09-24 19:00:00	NVDA	Stock	12.4448	12.4998	12.429	12.475	772880.0
2020-09-24 06:00:00	AMZN	Stock	149.2	149.9	149.2	149.9	29900.0
2020-09-24 07:00:00	AMZN	Stock	149.692	149.85	149.055	149.055	104900.0

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

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