PREVIEW / stock_1hour / 2020-01-22

all stock 1-hour files

  file:    by_date/stock_1hour/2020/2020-01-22.parquet
  size:    1.2 MB
  rows:    50,897
  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-01-22 04:00:00	AAPL	Stock	79.5175	79.625	79.5175	79.625	25252.0
2020-01-22 05:00:00	AAPL	Stock	79.6875	79.6875	79.625	79.67	9864.0
2020-01-22 06:00:00	AAPL	Stock	79.67	79.7925	79.6675	79.7925	62216.0
2020-01-22 07:00:00	AAPL	Stock	79.76	79.8575	79.75	79.775	373272.0
2020-01-22 08:00:00	AAPL	Stock	79.7625	79.85	79.34	79.655	480448.0
2020-01-22 09:00:00	AAPL	Stock	79.655	79.735	79.3275	79.515	12431540.0
2020-01-22 10:00:00	AAPL	Stock	79.5225	79.725	79.38	79.471	12942676.0
2020-01-22 11:00:00	AAPL	Stock	79.4725	79.6712	79.365	79.63	8883196.0
2020-01-22 12:00:00	AAPL	Stock	79.63	79.9375	79.525	79.9075	10281472.0
2020-01-22 13:00:00	AAPL	Stock	79.91	79.9725	79.7625	79.768	6910144.0
2020-01-22 14:00:00	AAPL	Stock	79.7725	79.9975	79.75	79.97	7011564.0
2020-01-22 15:00:00	AAPL	Stock	79.975	79.975	79.3925	79.425	18433924.0
2020-01-22 16:00:00	AAPL	Stock	79.425	79.455	79.3	79.35	9857064.0
2020-01-22 17:00:00	AAPL	Stock	79.3475	79.4125	79.3475	79.37	32532.0
2020-01-22 18:00:00	AAPL	Stock	79.375	79.405	79.2875	79.375	138884.0
2020-01-22 19:00:00	AAPL	Stock	79.355	79.45	79.3375	79.375	119196.0
2020-01-22 04:00:00	MSFT	Stock	167.45	167.6	167.4	167.4	4960.0
2020-01-22 05:00:00	MSFT	Stock	167.56	167.56	167.45	167.49	2990.0
2020-01-22 06:00:00	MSFT	Stock	167.54	167.7	167.42	167.7	6405.0
2020-01-22 07:00:00	MSFT	Stock	167.56	167.6	167.4	167.49	45142.0
2020-01-22 08:00:00	MSFT	Stock	167.481	167.6	166.91	167.431	39612.0
2020-01-22 09:00:00	MSFT	Stock	167.35	167.49	166.87	167.39	2344684.0
2020-01-22 10:00:00	MSFT	Stock	167.4	167.41	166.865	166.87	2746462.0
2020-01-22 11:00:00	MSFT	Stock	166.87	166.93	166.09	166.251	2155464.0
2020-01-22 12:00:00	MSFT	Stock	166.26	166.61	165.9	166.565	2110189.0
2020-01-22 13:00:00	MSFT	Stock	166.569	166.7	166.11	166.275	1421233.0
2020-01-22 14:00:00	MSFT	Stock	166.275	166.42	166.0	166.38	1549511.0
2020-01-22 15:00:00	MSFT	Stock	166.38	166.409	165.68	165.69	3118863.0
2020-01-22 16:00:00	MSFT	Stock	165.7	165.83	165.37	165.51	5039934.0
2020-01-22 17:00:00	MSFT	Stock	165.76	165.85	165.7	165.71	3661.0
2020-01-22 18:00:00	MSFT	Stock	165.7	165.78	165.45	165.58	7689.0
2020-01-22 19:00:00	MSFT	Stock	165.58	165.88	165.45	165.88	17331.0
2020-01-22 04:00:00	NVDA	Stock	6.2325	6.2325	6.2325	6.2325	4000.0
2020-01-22 05:00:00	NVDA	Stock	6.248	6.248	6.248	6.248	4000.0
2020-01-22 06:00:00	NVDA	Stock	6.2468	6.25	6.2468	6.25	32000.0
2020-01-22 07:00:00	NVDA	Stock	6.2338	6.2462	6.2338	6.2375	218960.0
2020-01-22 08:00:00	NVDA	Stock	6.2375	6.247	6.225	6.2275	816160.0
2020-01-22 09:00:00	NVDA	Stock	6.2275	6.3125	6.2238	6.307	46249720.0
2020-01-22 10:00:00	NVDA	Stock	6.3053	6.3398	6.286	6.3115	40185720.0
2020-01-22 11:00:00	NVDA	Stock	6.3102	6.3288	6.298	6.3032	23375200.0
2020-01-22 12:00:00	NVDA	Stock	6.305	6.3145	6.2895	6.3018	17975000.0
2020-01-22 13:00:00	NVDA	Stock	6.3014	6.3055	6.2685	6.2694	12153160.0
2020-01-22 14:00:00	NVDA	Stock	6.2691	6.2792	6.258	6.2758	17902680.0
2020-01-22 15:00:00	NVDA	Stock	6.2765	6.2765	6.242	6.2528	29688640.0
2020-01-22 16:00:00	NVDA	Stock	6.2513	6.281	6.2325	6.2375	4647120.0
2020-01-22 17:00:00	NVDA	Stock	6.249	6.2638	6.249	6.2515	133640.0
2020-01-22 18:00:00	NVDA	Stock	6.2525	6.2525	6.2488	6.25	96840.0
2020-01-22 19:00:00	NVDA	Stock	6.2498	6.2498	6.2383	6.24	112400.0
2020-01-22 05:00:00	AMZN	Stock	95.088	95.088	95.0	95.0	15960.0
2020-01-22 06:00:00	AMZN	Stock	95.0	95.05	95.0	95.05	26040.0

> showing 50 of 50,897 rows — these rows as CSV

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