PREVIEW / stock_1hour / 2020-12-29

all stock 1-hour files

  file:    by_date/stock_1hour/2020/2020-12-29.parquet
  size:    1.4 MB
  rows:    63,875
  symbols: 2,685

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-12-29 04:00:00	AAPL	Stock	137.5	137.95	137.15	137.51	68967.0
2020-12-29 05:00:00	AAPL	Stock	137.5	137.65	137.01	137.6	16097.0
2020-12-29 06:00:00	AAPL	Stock	137.61	137.63	137.3	137.35	27762.0
2020-12-29 07:00:00	AAPL	Stock	137.33	138.25	137.33	138.1	564008.0
2020-12-29 08:00:00	AAPL	Stock	137.7	138.41	137.35	138.22	846553.0
2020-12-29 09:00:00	AAPL	Stock	138.22	138.789	135.94	136.42	23016281.0
2020-12-29 10:00:00	AAPL	Stock	136.42	137.06	135.51	136.73	19147549.0
2020-12-29 11:00:00	AAPL	Stock	136.73	137.57	136.6	137.09	13816656.0
2020-12-29 12:00:00	AAPL	Stock	137.095	137.1	135.67	136.3	13437444.0
2020-12-29 13:00:00	AAPL	Stock	136.3	136.454	135.94	136.139	7595251.0
2020-12-29 14:00:00	AAPL	Stock	136.135	136.16	135.13	135.435	9475522.0
2020-12-29 15:00:00	AAPL	Stock	135.435	135.67	134.341	134.93	14997664.0
2020-12-29 16:00:00	AAPL	Stock	134.87	135.13	134.67	135.1	4602993.0
2020-12-29 17:00:00	AAPL	Stock	135.08	135.25	134.91	134.92	152214.0
2020-12-29 18:00:00	AAPL	Stock	134.96	135.0	134.68	134.85	161104.0
2020-12-29 19:00:00	AAPL	Stock	134.85	134.85	134.62	134.7	137440.0
2020-12-29 04:00:00	MSFT	Stock	226.0	226.0	225.72	225.95	1162.0
2020-12-29 05:00:00	MSFT	Stock	225.95	225.95	225.8	225.88	3832.0
2020-12-29 06:00:00	MSFT	Stock	225.86	225.86	225.6	225.7	3114.0
2020-12-29 07:00:00	MSFT	Stock	225.71	225.84	225.6	225.7	6183.0
2020-12-29 08:00:00	MSFT	Stock	225.8	225.875	225.58	225.68	14345.0
2020-12-29 09:00:00	MSFT	Stock	225.7	227.18	225.41	225.745	2181658.0
2020-12-29 10:00:00	MSFT	Stock	225.794	226.118	224.87	225.88	1872975.0
2020-12-29 11:00:00	MSFT	Stock	225.88	226.19	225.13	225.4	1712734.0
2020-12-29 12:00:00	MSFT	Stock	225.42	225.45	223.58	224.34	2179530.0
2020-12-29 13:00:00	MSFT	Stock	224.33	224.67	223.97	224.48	1096031.0
2020-12-29 14:00:00	MSFT	Stock	224.49	224.54	223.77	224.17	1022792.0
2020-12-29 15:00:00	MSFT	Stock	224.16	224.75	223.83	224.29	1998105.0
2020-12-29 16:00:00	MSFT	Stock	224.15	224.48	224.0	224.0	1687827.0
2020-12-29 17:00:00	MSFT	Stock	224.24	224.24	224.04	224.15	7376.0
2020-12-29 18:00:00	MSFT	Stock	224.24	224.49	224.19	224.29	48916.0
2020-12-29 19:00:00	MSFT	Stock	224.29	224.29	224.15	224.15	10543.0
2020-12-29 05:00:00	NVDA	Stock	12.9558	12.9558	12.935	12.935	35640.0
2020-12-29 06:00:00	NVDA	Stock	12.925	12.925	12.925	12.925	4000.0
2020-12-29 07:00:00	NVDA	Stock	12.9375	12.9512	12.9252	12.9252	270280.0
2020-12-29 08:00:00	NVDA	Stock	12.95	12.9532	12.925	12.9412	316760.0
2020-12-29 09:00:00	NVDA	Stock	12.9288	13.0725	12.8718	12.9815	32326080.0
2020-12-29 10:00:00	NVDA	Stock	12.9828	13.0225	12.8922	13.0005	26642360.0
2020-12-29 11:00:00	NVDA	Stock	12.9983	13.017	12.9062	12.9433	18666600.0
2020-12-29 12:00:00	NVDA	Stock	12.9445	12.9463	12.8423	12.9005	17441120.0
2020-12-29 13:00:00	NVDA	Stock	12.8985	12.9273	12.8768	12.9125	9884240.0
2020-12-29 14:00:00	NVDA	Stock	12.91	12.925	12.881	12.9238	9573720.0
2020-12-29 15:00:00	NVDA	Stock	12.9248	12.9803	12.9208	12.9438	22581000.0
2020-12-29 16:00:00	NVDA	Stock	12.9433	12.956	12.9375	12.95	6350080.0
2020-12-29 17:00:00	NVDA	Stock	12.945	12.945	12.9322	12.9393	100040.0
2020-12-29 18:00:00	NVDA	Stock	12.945	12.945	12.9305	12.9305	131800.0
2020-12-29 19:00:00	NVDA	Stock	12.92	12.9225	12.9138	12.9225	71280.0
2020-12-29 05:00:00	AMZN	Stock	164.5025	164.5025	164.5025	164.5025	2380.0
2020-12-29 06:00:00	AMZN	Stock	164.85	164.85	164.85	164.85	2000.0
2020-12-29 07:00:00	AMZN	Stock	164.61	165.1445	164.5935	165.144	176340.0

> showing 50 of 63,875 rows — these rows as CSV

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