PREVIEW / stock_1hour / 2020-11-24

all stock 1-hour files

  file:    by_date/stock_1hour/2020/2020-11-24.parquet
  size:    1.4 MB
  rows:    63,276
  symbols: 2,607

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-11-24 04:00:00	AAPL	Stock	114.6	114.65	114.11	114.43	39664.0
2020-11-24 05:00:00	AAPL	Stock	114.63	114.65	114.12	114.24	66921.0
2020-11-24 06:00:00	AAPL	Stock	114.22	114.45	114.0	114.19	37426.0
2020-11-24 07:00:00	AAPL	Stock	114.17	114.61	114.03	114.25	367375.0
2020-11-24 08:00:00	AAPL	Stock	114.25	114.59	114.06	114.3	551145.0
2020-11-24 09:00:00	AAPL	Stock	114.31	114.37	112.59	113.01	19033072.0
2020-11-24 10:00:00	AAPL	Stock	113.02	114.905	113.015	114.903	18098706.0
2020-11-24 11:00:00	AAPL	Stock	114.903	115.37	114.66	114.81	14236539.0
2020-11-24 12:00:00	AAPL	Stock	114.81	115.012	114.23	114.8	8296581.0
2020-11-24 13:00:00	AAPL	Stock	114.79	115.7	114.62	115.69	9739962.0
2020-11-24 14:00:00	AAPL	Stock	115.694	115.85	114.97	115.36	9538267.0
2020-11-24 15:00:00	AAPL	Stock	115.36	115.73	114.97	115.17	13202966.0
2020-11-24 16:00:00	AAPL	Stock	115.17	115.24	115.0	115.14	9057993.0
2020-11-24 17:00:00	AAPL	Stock	115.15	115.17	115.0	115.12	77151.0
2020-11-24 18:00:00	AAPL	Stock	115.11	115.35	115.04	115.33	137129.0
2020-11-24 19:00:00	AAPL	Stock	115.34	115.61	115.22	115.58	183359.0
2020-11-24 04:00:00	MSFT	Stock	211.48	211.48	210.21	210.9	4390.0
2020-11-24 05:00:00	MSFT	Stock	210.88	210.9	209.93	210.12	4003.0
2020-11-24 06:00:00	MSFT	Stock	210.38	210.5	210.02	210.02	2973.0
2020-11-24 07:00:00	MSFT	Stock	210.59	210.59	209.66	210.11	30262.0
2020-11-24 08:00:00	MSFT	Stock	210.15	210.74	209.717	210.64	58074.0
2020-11-24 09:00:00	MSFT	Stock	210.612	210.98	208.86	209.33	3059267.0
2020-11-24 10:00:00	MSFT	Stock	209.307	211.59	208.96	211.15	3981139.0
2020-11-24 11:00:00	MSFT	Stock	211.15	212.65	211.07	212.65	3023699.0
2020-11-24 12:00:00	MSFT	Stock	212.643	214.02	212.36	213.81	2610301.0
2020-11-24 13:00:00	MSFT	Stock	213.8	214.25	213.19	213.99	2206922.0
2020-11-24 14:00:00	MSFT	Stock	214.0	214.21	212.81	213.07	2019777.0
2020-11-24 15:00:00	MSFT	Stock	213.065	214.0	212.46	213.86	3435981.0
2020-11-24 16:00:00	MSFT	Stock	213.87	213.98	213.54	213.963	4680814.0
2020-11-24 17:00:00	MSFT	Stock	213.9	213.93	213.7	213.9	7276.0
2020-11-24 18:00:00	MSFT	Stock	213.9	214.6	213.9	214.35	37227.0
2020-11-24 19:00:00	MSFT	Stock	214.33	214.9	214.25	214.75	30267.0
2020-11-24 04:00:00	NVDA	Stock	13.2125	13.225	13.175	13.175	66600.0
2020-11-24 05:00:00	NVDA	Stock	13.1705	13.1705	13.14	13.14	46800.0
2020-11-24 06:00:00	NVDA	Stock	13.1083	13.1488	13.1083	13.1488	76520.0
2020-11-24 07:00:00	NVDA	Stock	13.1748	13.1748	13.125	13.1575	507080.0
2020-11-24 08:00:00	NVDA	Stock	13.125	13.1832	13.125	13.181	1368520.0
2020-11-24 09:00:00	NVDA	Stock	13.1775	13.1812	12.885	13.0019	53078280.0
2020-11-24 10:00:00	NVDA	Stock	13.0019	13.047	12.89	13.017	45392160.0
2020-11-24 11:00:00	NVDA	Stock	13.017	13.09	12.9262	12.9287	40291720.0
2020-11-24 12:00:00	NVDA	Stock	12.929	13.0005	12.9078	12.9878	30703360.0
2020-11-24 13:00:00	NVDA	Stock	12.9855	13.0418	12.945	13.0375	21489920.0
2020-11-24 14:00:00	NVDA	Stock	13.0355	13.048	12.9803	13.0094	16210520.0
2020-11-24 15:00:00	NVDA	Stock	13.0094	13.0198	12.905	12.9615	50872000.0
2020-11-24 16:00:00	NVDA	Stock	12.9577	12.9732	12.9577	12.9625	19495080.0
2020-11-24 17:00:00	NVDA	Stock	12.9692	12.9725	12.959	12.9715	218520.0
2020-11-24 18:00:00	NVDA	Stock	12.9625	12.9898	12.9625	12.984	118800.0
2020-11-24 19:00:00	NVDA	Stock	12.9875	13.0213	12.984	13.0213	517440.0
2020-11-24 04:00:00	AMZN	Stock	155.25	155.25	155.25	155.25	2000.0
2020-11-24 06:00:00	AMZN	Stock	155.25	155.25	155.25	155.25	5040.0

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

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