PREVIEW / stock_1hour / 2021-06-21

all stock 1-hour files

  file:    by_date/stock_1hour/2021/2021-06-21.parquet
  size:    1.4 MB
  rows:    66,198
  symbols: 2,922

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-06-21 04:00:00	AAPL	Stock	130.77	131.3	130.21	130.95	25144.0
2021-06-21 05:00:00	AAPL	Stock	130.91	131.19	130.85	131.0	20908.0
2021-06-21 06:00:00	AAPL	Stock	131.01	131.01	130.88	130.97	3392.0
2021-06-21 07:00:00	AAPL	Stock	130.93	130.93	130.44	130.61	130654.0
2021-06-21 08:00:00	AAPL	Stock	130.8499	130.89	130.24	130.51	332375.0
2021-06-21 09:00:00	AAPL	Stock	130.47	130.83	129.21	130.405	10724347.0
2021-06-21 10:00:00	AAPL	Stock	130.41	131.435	130.17	131.2573	11641949.0
2021-06-21 11:00:00	AAPL	Stock	131.26	131.7	131.2582	131.61	7585539.0
2021-06-21 12:00:00	AAPL	Stock	131.62	132.19	131.61	132.045	6968118.0
2021-06-21 13:00:00	AAPL	Stock	132.05	132.41	131.88	132.245	5160624.0
2021-06-21 14:00:00	AAPL	Stock	132.245	132.3	131.97	131.99	4969980.0
2021-06-21 15:00:00	AAPL	Stock	131.99	132.3	131.93	132.3	10004047.0
2021-06-21 16:00:00	AAPL	Stock	132.29	132.36	132.11	132.27	13837547.0
2021-06-21 17:00:00	AAPL	Stock	132.27	132.36	132.25	132.32	41048.0
2021-06-21 18:00:00	AAPL	Stock	132.3	132.35	132.27	132.31	22587.0
2021-06-21 19:00:00	AAPL	Stock	132.32	132.45	132.31	132.45	63394.0
2021-06-21 04:00:00	MSFT	Stock	259.56	260.99	259.56	260.37	2845.0
2021-06-21 05:00:00	MSFT	Stock	260.85	261.39	260.65	260.95	6806.0
2021-06-21 06:00:00	MSFT	Stock	260.73	260.73	260.73	260.73	189.0
2021-06-21 07:00:00	MSFT	Stock	260.56	260.95	259.78	260.35	15628.0
2021-06-21 08:00:00	MSFT	Stock	260.65	260.9	259.38	259.85	28017.0
2021-06-21 09:00:00	MSFT	Stock	259.86	260.45	257.92	260.29	2423933.0
2021-06-21 10:00:00	MSFT	Stock	260.3	263.16	260.18	262.77	3870572.0
2021-06-21 11:00:00	MSFT	Stock	262.75	263.52	262.51	262.99	2264498.0
2021-06-21 12:00:00	MSFT	Stock	263.0	263.06	261.88	261.92	1290409.0
2021-06-21 13:00:00	MSFT	Stock	261.915	263.13	261.6802	262.7001	1694437.0
2021-06-21 14:00:00	MSFT	Stock	262.715	262.7487	262.1586	262.21	1290225.0
2021-06-21 15:00:00	MSFT	Stock	262.19	262.93	261.885	262.63	3342241.0
2021-06-21 16:00:00	MSFT	Stock	262.5879	262.86	261.9779	262.67	4227700.0
2021-06-21 17:00:00	MSFT	Stock	262.7	262.7	262.65	262.65	1666.0
2021-06-21 18:00:00	MSFT	Stock	262.73	262.88	262.72	262.75	4408.0
2021-06-21 19:00:00	MSFT	Stock	262.82	263.19	262.82	263.0	10611.0
2021-06-21 04:00:00	NVDA	Stock	18.7118	18.75	18.6	18.7	217760.0
2021-06-21 05:00:00	NVDA	Stock	18.7	18.7423	18.6982	18.7375	60240.0
2021-06-21 06:00:00	NVDA	Stock	18.7155	18.7155	18.6202	18.6252	136600.0
2021-06-21 07:00:00	NVDA	Stock	18.6613	18.6685	18.4435	18.5	1879120.0
2021-06-21 08:00:00	NVDA	Stock	18.5	18.675	18.3553	18.4246	2359080.0
2021-06-21 09:00:00	NVDA	Stock	18.4	18.5365	17.976	18.1048	91301960.0
2021-06-21 10:00:00	NVDA	Stock	18.1135	18.1138	17.8226	18.062	95489640.0
2021-06-21 11:00:00	NVDA	Stock	18.0623	18.134	17.9375	18.0752	42692360.0
2021-06-21 12:00:00	NVDA	Stock	18.081	18.1498	18.0803	18.0822	23235320.0
2021-06-21 13:00:00	NVDA	Stock	18.085	18.308	18.0225	18.2612	36094000.0
2021-06-21 14:00:00	NVDA	Stock	18.2662	18.3067	18.1896	18.2831	33407520.0
2021-06-21 15:00:00	NVDA	Stock	18.2752	18.4665	18.1828	18.43	74364080.0
2021-06-21 16:00:00	NVDA	Stock	18.4272	18.45	18.407	18.4188	23450040.0
2021-06-21 17:00:00	NVDA	Stock	18.4198	18.4198	18.3862	18.3862	195440.0
2021-06-21 18:00:00	NVDA	Stock	18.3963	18.4002	18.338	18.35	290480.0
2021-06-21 19:00:00	NVDA	Stock	18.3475	18.4122	18.3475	18.4088	304960.0
2021-06-21 04:00:00	AMZN	Stock	174.4	174.5	174.4	174.5	13880.0
2021-06-21 05:00:00	AMZN	Stock	174.65	174.8	174.65	174.8	9540.0

> showing 50 of 66,198 rows — these rows as CSV

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