PREVIEW / stock_1hour / 2020-08-24

all stock 1-hour files

  file:    by_date/stock_1hour/2020/2020-08-24.parquet
  size:    1.3 MB
  rows:    58,061
  symbols: 2,454

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-08-24 04:00:00	AAPL	Stock	126.525	127.15	126.1275	126.99	219984.0
2020-08-24 05:00:00	AAPL	Stock	126.95	127.04	126.5575	126.82	87112.0
2020-08-24 06:00:00	AAPL	Stock	126.875	127.4	126.54	127.225	149364.0
2020-08-24 07:00:00	AAPL	Stock	127.25	128.575	127.05	128.4725	2232128.0
2020-08-24 08:00:00	AAPL	Stock	128.4725	128.875	126.4725	128.1925	3172116.0
2020-08-24 09:00:00	AAPL	Stock	128.1875	128.995	125.56	126.8425	56330572.0
2020-08-24 10:00:00	AAPL	Stock	126.83	126.87	123.9362	124.122	54604180.0
2020-08-24 11:00:00	AAPL	Stock	124.1965	127.1575	123.9375	127.02	35159148.0
2020-08-24 12:00:00	AAPL	Stock	127.0275	127.45	126.06	126.2012	26749684.0
2020-08-24 13:00:00	AAPL	Stock	126.1812	127.0	125.78	126.5038	19603216.0
2020-08-24 14:00:00	AAPL	Stock	126.5175	126.77	125.275	125.4325	21529368.0
2020-08-24 15:00:00	AAPL	Stock	125.4275	126.1288	124.655	125.9475	34109784.0
2020-08-24 16:00:00	AAPL	Stock	125.92	126.3375	125.805	126.2125	6889584.0
2020-08-24 17:00:00	AAPL	Stock	126.225	126.25	125.8575	126.16	138468.0
2020-08-24 18:00:00	AAPL	Stock	126.15	126.1875	125.975	126.0625	187248.0
2020-08-24 19:00:00	AAPL	Stock	126.0525	126.525	126.0125	126.525	299248.0
2020-08-24 04:00:00	MSFT	Stock	215.23	215.92	215.13	215.31	5866.0
2020-08-24 05:00:00	MSFT	Stock	215.66	215.66	215.0	215.43	3963.0
2020-08-24 06:00:00	MSFT	Stock	215.49	215.93	215.11	215.11	14868.0
2020-08-24 07:00:00	MSFT	Stock	215.13	215.5	214.58	214.67	48461.0
2020-08-24 08:00:00	MSFT	Stock	215.164	215.433	213.55	214.83	96303.0
2020-08-24 09:00:00	MSFT	Stock	214.85	215.33	213.89	214.609	4343390.0
2020-08-24 10:00:00	MSFT	Stock	214.65	215.52	212.88	213.1	3642571.0
2020-08-24 11:00:00	MSFT	Stock	213.155	213.79	212.43	213.715	2090818.0
2020-08-24 12:00:00	MSFT	Stock	213.705	213.96	213.05	213.552	1517980.0
2020-08-24 13:00:00	MSFT	Stock	213.56	214.11	212.77	213.308	1701361.0
2020-08-24 14:00:00	MSFT	Stock	213.29	213.44	212.51	212.695	1231863.0
2020-08-24 15:00:00	MSFT	Stock	212.69	213.81	212.48	213.71	2732550.0
2020-08-24 16:00:00	MSFT	Stock	213.69	214.44	213.5	213.65	3789624.0
2020-08-24 17:00:00	MSFT	Stock	213.58	213.69	213.25	213.3	20416.0
2020-08-24 18:00:00	MSFT	Stock	213.43	213.76	213.42	213.76	9502.0
2020-08-24 19:00:00	MSFT	Stock	213.75	213.78	213.43	213.72	13190.0
2020-08-24 04:00:00	NVDA	Stock	12.8125	12.875	12.8125	12.835	265240.0
2020-08-24 05:00:00	NVDA	Stock	12.845	12.845	12.816	12.8387	75640.0
2020-08-24 06:00:00	NVDA	Stock	12.8375	12.8438	12.8325	12.8325	70280.0
2020-08-24 07:00:00	NVDA	Stock	12.8268	12.9175	12.775	12.9143	2070600.0
2020-08-24 08:00:00	NVDA	Stock	12.8373	12.9325	12.7835	12.9135	4750720.0
2020-08-24 09:00:00	NVDA	Stock	12.9145	12.9225	12.554	12.6983	98766560.0
2020-08-24 10:00:00	NVDA	Stock	12.7025	12.7667	12.5075	12.5541	105876040.0
2020-08-24 11:00:00	NVDA	Stock	12.556	12.7058	12.5393	12.6915	50039120.0
2020-08-24 12:00:00	NVDA	Stock	12.6909	12.7432	12.647	12.6933	33069600.0
2020-08-24 13:00:00	NVDA	Stock	12.6878	12.7378	12.6809	12.7187	33322720.0
2020-08-24 14:00:00	NVDA	Stock	12.7243	12.75	12.6692	12.677	29214160.0
2020-08-24 15:00:00	NVDA	Stock	12.6763	12.7202	12.6248	12.7155	54940920.0
2020-08-24 16:00:00	NVDA	Stock	12.7202	12.7345	12.6504	12.7062	2303960.0
2020-08-24 17:00:00	NVDA	Stock	12.7125	12.7202	12.7	12.7175	282600.0
2020-08-24 18:00:00	NVDA	Stock	12.719	12.725	12.7108	12.725	198560.0
2020-08-24 19:00:00	NVDA	Stock	12.73	12.735	12.7168	12.7313	414800.0
2020-08-24 04:00:00	AMZN	Stock	165.8745	165.9	165.8745	165.9	7860.0
2020-08-24 05:00:00	AMZN	Stock	165.975	166.045	165.975	166.0265	26180.0

> showing 50 of 58,061 rows — these rows as CSV

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