PREVIEW / stock_1hour / 2021-04-20

all stock 1-hour files

  file:    by_date/stock_1hour/2021/2021-04-20.parquet
  size:    1.4 MB
  rows:    64,924
  symbols: 2,977

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-04-20 04:00:00	AAPL	Stock	135.0	135.18	134.38	135.05	28530.0
2021-04-20 05:00:00	AAPL	Stock	135.01	135.09	134.3	134.4	21968.0
2021-04-20 06:00:00	AAPL	Stock	134.41	134.6	134.12	134.42	23805.0
2021-04-20 07:00:00	AAPL	Stock	134.43	134.75	134.33	134.65	108773.0
2021-04-20 08:00:00	AAPL	Stock	134.47	134.86	134.2522	134.65	334817.0
2021-04-20 09:00:00	AAPL	Stock	134.66	135.53	134.44	135.21	11241893.0
2021-04-20 10:00:00	AAPL	Stock	135.215	135.44	133.49	133.68	13304699.0
2021-04-20 11:00:00	AAPL	Stock	133.675	133.8	132.28	133.155	13043624.0
2021-04-20 12:00:00	AAPL	Stock	133.16	133.74	133.11	133.5597	6848728.0
2021-04-20 13:00:00	AAPL	Stock	133.55	133.82	132.3599	133.1617	10493495.0
2021-04-20 14:00:00	AAPL	Stock	133.16	133.1699	131.81	131.985	9568082.0
2021-04-20 15:00:00	AAPL	Stock	131.9899	133.2	131.9899	133.12	12502869.0
2021-04-20 16:00:00	AAPL	Stock	133.11	133.16	132.52	132.61	5275380.0
2021-04-20 17:00:00	AAPL	Stock	132.6	132.71	132.51	132.63	85207.0
2021-04-20 18:00:00	AAPL	Stock	132.62	132.75	132.48	132.55	59017.0
2021-04-20 19:00:00	AAPL	Stock	132.53	132.56	132.2	132.3	92606.0
2021-04-20 04:00:00	MSFT	Stock	258.83	259.4	258.83	259.4	278.0
2021-04-20 05:00:00	MSFT	Stock	259.03	259.03	258.02	258.02	4161.0
2021-04-20 06:00:00	MSFT	Stock	257.83	257.98	257.55	257.98	1500.0
2021-04-20 07:00:00	MSFT	Stock	257.76	258.17	257.72	258.11	11391.0
2021-04-20 08:00:00	MSFT	Stock	257.7101	258.38	257.71	258.05	26240.0
2021-04-20 09:00:00	MSFT	Stock	258.07	260.2	257.75	259.685	1484654.0
2021-04-20 10:00:00	MSFT	Stock	259.67	259.87	258.245	258.25	2032275.0
2021-04-20 11:00:00	MSFT	Stock	258.255	258.4	256.84	257.38	2244702.0
2021-04-20 12:00:00	MSFT	Stock	257.41	258.79	257.24	257.91	1596992.0
2021-04-20 13:00:00	MSFT	Stock	257.89	258.8	257.46	258.3599	1396677.0
2021-04-20 14:00:00	MSFT	Stock	258.32	258.49	257.13	257.34	1053645.0
2021-04-20 15:00:00	MSFT	Stock	257.33	258.5	257.33	258.28	1910719.0
2021-04-20 16:00:00	MSFT	Stock	258.26	258.35	257.5	257.5	2550658.0
2021-04-20 17:00:00	MSFT	Stock	257.52	257.7	257.5	257.7	5679.0
2021-04-20 18:00:00	MSFT	Stock	257.52	257.74	257.5	257.74	2955.0
2021-04-20 19:00:00	MSFT	Stock	257.84	258.0	257.84	258.0	4729.0
2021-04-20 04:00:00	NVDA	Stock	15.3412	15.3412	15.3412	15.3412	4000.0
2021-04-20 05:00:00	NVDA	Stock	15.345	15.345	15.325	15.325	9120.0
2021-04-20 06:00:00	NVDA	Stock	15.1875	15.1875	15.1525	15.175	109440.0
2021-04-20 07:00:00	NVDA	Stock	15.1808	15.2	15.15	15.19	196440.0
2021-04-20 08:00:00	NVDA	Stock	15.1755	15.4002	15.1488	15.222	486480.0
2021-04-20 09:00:00	NVDA	Stock	15.2212	15.497	15.2212	15.4154	26449280.0
2021-04-20 10:00:00	NVDA	Stock	15.414	15.441	15.1778	15.2075	29845600.0
2021-04-20 11:00:00	NVDA	Stock	15.2005	15.2457	14.963	15.0265	41666760.0
2021-04-20 12:00:00	NVDA	Stock	15.0305	15.1508	15.0178	15.0632	21606360.0
2021-04-20 13:00:00	NVDA	Stock	15.062	15.1101	15.0008	15.105	12702360.0
2021-04-20 14:00:00	NVDA	Stock	15.1083	15.1694	15.0348	15.0492	16914760.0
2021-04-20 15:00:00	NVDA	Stock	15.0492	15.205	15.0458	15.171	37672800.0
2021-04-20 16:00:00	NVDA	Stock	15.1712	15.1712	15.085	15.085	22154480.0
2021-04-20 17:00:00	NVDA	Stock	15.085	15.0962	15.0778	15.078	122160.0
2021-04-20 18:00:00	NVDA	Stock	15.0935	15.0935	15.087	15.0875	133960.0
2021-04-20 19:00:00	NVDA	Stock	15.088	15.1	15.083	15.0995	105600.0
2021-04-20 05:00:00	AMZN	Stock	168.75	168.75	168.75	168.75	2000.0
2021-04-20 07:00:00	AMZN	Stock	168.35	168.35	168.35	168.35	2200.0

> showing 50 of 64,924 rows — these rows as CSV

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