PREVIEW / stock_1hour / 2020-01-07

all stock 1-hour files

  file:    by_date/stock_1hour/2020/2020-01-07.parquet
  size:    1.2 MB
  rows:    52,671
  symbols: 2,468

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-07 04:00:00	AAPL	Stock	75.1225	75.225	75.03	75.125	66976.0
2020-01-07 05:00:00	AAPL	Stock	75.1225	75.1225	75.05	75.08	61900.0
2020-01-07 06:00:00	AAPL	Stock	75.0825	75.1125	74.96	74.9775	99376.0
2020-01-07 07:00:00	AAPL	Stock	75.0	75.165	74.975	75.14	407644.0
2020-01-07 08:00:00	AAPL	Stock	74.9975	75.15	74.8475	74.8912	723428.0
2020-01-07 09:00:00	AAPL	Stock	74.9	75.225	74.4375	74.706	19925172.0
2020-01-07 10:00:00	AAPL	Stock	74.7225	74.8925	74.37	74.8508	16789220.0
2020-01-07 11:00:00	AAPL	Stock	74.845	74.9708	74.6375	74.7325	10032744.0
2020-01-07 12:00:00	AAPL	Stock	74.7375	74.9125	74.6625	74.8925	6298536.0
2020-01-07 13:00:00	AAPL	Stock	74.8935	75.1025	74.8935	75.0175	7334528.0
2020-01-07 14:00:00	AAPL	Stock	75.0185	75.025	74.74	74.7505	6304420.0
2020-01-07 15:00:00	AAPL	Stock	74.7525	74.891	74.4875	74.5675	12771204.0
2020-01-07 16:00:00	AAPL	Stock	74.5975	74.5975	74.3475	74.475	8530844.0
2020-01-07 17:00:00	AAPL	Stock	74.4625	74.5975	74.425	74.4625	56652.0
2020-01-07 18:00:00	AAPL	Stock	74.44	74.5	73.425	73.65	942364.0
2020-01-07 19:00:00	AAPL	Stock	73.64	73.6725	73.0	73.15	1299704.0
2020-01-07 04:00:00	MSFT	Stock	159.28	159.85	159.15	159.45	6460.0
2020-01-07 05:00:00	MSFT	Stock	159.45	159.69	159.3	159.49	9872.0
2020-01-07 06:00:00	MSFT	Stock	159.36	159.5	158.72	159.12	13669.0
2020-01-07 07:00:00	MSFT	Stock	159.13	159.4	159.1	159.4	23490.0
2020-01-07 08:00:00	MSFT	Stock	159.25	159.457	158.78	158.84	203521.0
2020-01-07 09:00:00	MSFT	Stock	158.75	159.67	158.465	158.92	2731972.0
2020-01-07 10:00:00	MSFT	Stock	158.93	159.14	158.428	158.898	2205925.0
2020-01-07 11:00:00	MSFT	Stock	158.9	159.13	158.49	158.656	1604693.0
2020-01-07 12:00:00	MSFT	Stock	158.66	158.79	158.34	158.39	1348134.0
2020-01-07 13:00:00	MSFT	Stock	158.397	158.73	158.29	158.365	1368158.0
2020-01-07 14:00:00	MSFT	Stock	158.37	158.38	157.845	158.04	1896286.0
2020-01-07 15:00:00	MSFT	Stock	158.04	158.31	157.32	157.6	3657540.0
2020-01-07 16:00:00	MSFT	Stock	157.58	158.58	157.0	157.35	3502038.0
2020-01-07 17:00:00	MSFT	Stock	157.38	157.58	157.3	157.48	32825.0
2020-01-07 18:00:00	MSFT	Stock	157.35	157.35	155.07	155.6	73718.0
2020-01-07 19:00:00	MSFT	Stock	155.6	155.85	154.11	154.45	126412.0
2020-01-07 04:00:00	NVDA	Stock	5.955	5.964	5.955	5.9578	16000.0
2020-01-07 05:00:00	NVDA	Stock	5.9528	5.9528	5.9528	5.9528	6720.0
2020-01-07 06:00:00	NVDA	Stock	5.9558	5.966	5.952	5.952	13440.0
2020-01-07 07:00:00	NVDA	Stock	5.956	5.978	5.95	5.9715	397440.0
2020-01-07 08:00:00	NVDA	Stock	5.9658	5.9793	5.935	5.9453	1073000.0
2020-01-07 09:00:00	NVDA	Stock	5.9468	5.991	5.9098	5.9722	46833360.0
2020-01-07 10:00:00	NVDA	Stock	5.975	6.0385	5.959	6.0332	60127440.0
2020-01-07 11:00:00	NVDA	Stock	6.0324	6.0443	6.011	6.0175	42205280.0
2020-01-07 12:00:00	NVDA	Stock	6.0175	6.0355	6.007	6.0336	25407520.0
2020-01-07 13:00:00	NVDA	Stock	6.033	6.0438	6.0005	6.0125	27345680.0
2020-01-07 14:00:00	NVDA	Stock	6.0125	6.0125	5.9873	6.0047	19898800.0
2020-01-07 15:00:00	NVDA	Stock	6.0045	6.0158	5.986	5.9985	36741920.0
2020-01-07 16:00:00	NVDA	Stock	5.9983	5.9983	5.9713	5.9838	19784480.0
2020-01-07 17:00:00	NVDA	Stock	5.9983	5.9983	5.98	5.9862	81840.0
2020-01-07 18:00:00	NVDA	Stock	5.9805	5.984	5.875	5.8888	1124520.0
2020-01-07 19:00:00	NVDA	Stock	5.8875	5.8875	5.7632	5.7875	2354360.0
2020-01-07 04:00:00	AMZN	Stock	95.46	95.46	95.4	95.4	5560.0
2020-01-07 05:00:00	AMZN	Stock	95.325	95.325	95.15	95.25	13740.0

> showing 50 of 52,671 rows — these rows as CSV

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