PREVIEW / stock_1hour / 2021-02-04

all stock 1-hour files

  file:    by_date/stock_1hour/2021/2021-02-04.parquet
  size:    1.5 MB
  rows:    68,403
  symbols: 2,769

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
2021-02-04 04:00:00	AAPL	Stock	136.38	136.38	135.4	135.94	82189.0
2021-02-04 05:00:00	AAPL	Stock	135.94	136.39	135.93	136.25	20963.0
2021-02-04 06:00:00	AAPL	Stock	136.26	136.65	135.8	136.1	74615.0
2021-02-04 07:00:00	AAPL	Stock	136.21	136.85	136.05	136.25	423180.0
2021-02-04 08:00:00	AAPL	Stock	136.4	136.85	134.27	136.15	659287.0
2021-02-04 09:00:00	AAPL	Stock	136.17	136.75	135.06	135.28	13260079.0
2021-02-04 10:00:00	AAPL	Stock	135.275	135.74	134.59	135.015	11721073.0
2021-02-04 11:00:00	AAPL	Stock	135.01	136.34	134.99	136.03	8127518.0
2021-02-04 12:00:00	AAPL	Stock	136.03	136.27	135.75	135.83	5717831.0
2021-02-04 13:00:00	AAPL	Stock	135.84	136.27	135.75	136.21	4292817.0
2021-02-04 14:00:00	AAPL	Stock	136.22	136.85	136.22	136.74	7080357.0
2021-02-04 15:00:00	AAPL	Stock	136.75	137.4	136.68	137.4	11639679.0
2021-02-04 16:00:00	AAPL	Stock	137.39	137.5	135.893	137.21	8096173.0
2021-02-04 17:00:00	AAPL	Stock	137.21	137.3	137.05	137.13	168685.0
2021-02-04 18:00:00	AAPL	Stock	137.2	137.27	137.0	137.17	98011.0
2021-02-04 19:00:00	AAPL	Stock	137.18	137.21	136.91	136.99	130416.0
2021-02-04 04:00:00	MSFT	Stock	243.5	243.5	243.0	243.23	3446.0
2021-02-04 05:00:00	MSFT	Stock	243.6	243.91	243.6	243.91	4489.0
2021-02-04 06:00:00	MSFT	Stock	243.62	243.62	243.06	243.36	3938.0
2021-02-04 07:00:00	MSFT	Stock	243.16	243.5	243.05	243.3	12261.0
2021-02-04 08:00:00	MSFT	Stock	243.45	243.87	242.4	243.81	39088.0
2021-02-04 09:00:00	MSFT	Stock	243.65	244.15	241.08	242.28	2886767.0
2021-02-04 10:00:00	MSFT	Stock	242.315	242.63	240.53	240.97	2934960.0
2021-02-04 11:00:00	MSFT	Stock	240.96	241.45	240.37	240.95	2109716.0
2021-02-04 12:00:00	MSFT	Stock	240.98	241.18	240.43	240.59	1544419.0
2021-02-04 13:00:00	MSFT	Stock	240.58	241.24	240.41	240.52	1460593.0
2021-02-04 14:00:00	MSFT	Stock	240.52	241.47	240.48	241.24	1387115.0
2021-02-04 15:00:00	MSFT	Stock	241.25	242.16	240.69	241.91	3861308.0
2021-02-04 16:00:00	MSFT	Stock	241.91	242.01	240.96	241.72	3604180.0
2021-02-04 17:00:00	MSFT	Stock	241.72	241.93	241.47	241.54	5968.0
2021-02-04 18:00:00	MSFT	Stock	241.55	241.8	241.46	241.65	15329.0
2021-02-04 19:00:00	MSFT	Stock	241.58	241.8	241.37	241.55	16765.0
2021-02-04 04:00:00	NVDA	Stock	13.485	13.485	13.485	13.485	4000.0
2021-02-04 06:00:00	NVDA	Stock	13.4625	13.4625	13.4625	13.4625	4000.0
2021-02-04 07:00:00	NVDA	Stock	13.4362	13.4875	13.4362	13.4625	271720.0
2021-02-04 08:00:00	NVDA	Stock	13.4589	13.4875	13.45	13.4755	440000.0
2021-02-04 09:00:00	NVDA	Stock	13.4842	13.6665	13.3625	13.3964	25218720.0
2021-02-04 10:00:00	NVDA	Stock	13.3888	13.5	13.3378	13.4686	26864160.0
2021-02-04 11:00:00	NVDA	Stock	13.4672	13.55	13.441	13.5164	15120960.0
2021-02-04 12:00:00	NVDA	Stock	13.5165	13.6363	13.5164	13.604	14490840.0
2021-02-04 13:00:00	NVDA	Stock	13.6023	13.6438	13.5652	13.5788	9945080.0
2021-02-04 14:00:00	NVDA	Stock	13.579	13.5893	13.5363	13.5742	6950440.0
2021-02-04 15:00:00	NVDA	Stock	13.5746	13.6735	13.5688	13.6643	19166120.0
2021-02-04 16:00:00	NVDA	Stock	13.6643	13.6748	13.6308	13.6638	15794560.0
2021-02-04 17:00:00	NVDA	Stock	13.655	13.665	13.6403	13.656	56400.0
2021-02-04 18:00:00	NVDA	Stock	13.6508	13.6625	13.6508	13.6625	56120.0
2021-02-04 19:00:00	NVDA	Stock	13.6598	13.6598	13.64	13.65	205080.0
2021-02-04 04:00:00	AMZN	Stock	166.9515	167.15	166.75	167.0	72600.0
2021-02-04 05:00:00	AMZN	Stock	166.9445	166.9445	166.75	166.75	16940.0
2021-02-04 06:00:00	AMZN	Stock	166.5005	166.5005	166.25	166.25	25640.0

> showing 50 of 68,403 rows — these rows as CSV

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