PREVIEW / stock_1hour / 2020-12-09

all stock 1-hour files

  file:    by_date/stock_1hour/2020/2020-12-09.parquet
  size:    1.4 MB
  rows:    63,347
  symbols: 2,669

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-09 04:00:00	AAPL	Stock	124.8	124.8	124.01	124.12	13971.0
2020-12-09 05:00:00	AAPL	Stock	124.14	124.37	124.01	124.3	15298.0
2020-12-09 06:00:00	AAPL	Stock	124.33	124.33	124.13	124.16	12095.0
2020-12-09 07:00:00	AAPL	Stock	124.21	124.84	124.14	124.83	277572.0
2020-12-09 08:00:00	AAPL	Stock	124.34	124.93	124.17	124.85	431980.0
2020-12-09 09:00:00	AAPL	Stock	124.84	125.95	123.86	125.86	15654268.0
2020-12-09 10:00:00	AAPL	Stock	125.865	125.9	124.59	125.41	13059149.0
2020-12-09 11:00:00	AAPL	Stock	125.4	125.44	124.67	124.895	7682873.0
2020-12-09 12:00:00	AAPL	Stock	124.891	124.92	122.83	123.648	11015385.0
2020-12-09 13:00:00	AAPL	Stock	123.64	123.71	121.61	121.64	13552721.0
2020-12-09 14:00:00	AAPL	Stock	121.66	122.25	121.0	121.63	10898715.0
2020-12-09 15:00:00	AAPL	Stock	121.62	122.21	121.07	121.67	15945769.0
2020-12-09 16:00:00	AAPL	Stock	121.78	122.799	121.36	121.49	13342141.0
2020-12-09 17:00:00	AAPL	Stock	121.49	121.52	120.9	120.93	201192.0
2020-12-09 18:00:00	AAPL	Stock	120.93	121.49	120.92	121.39	145541.0
2020-12-09 19:00:00	AAPL	Stock	121.36	121.5	121.15	121.16	134846.0
2020-12-09 04:00:00	MSFT	Stock	216.48	216.69	215.54	215.76	3977.0
2020-12-09 05:00:00	MSFT	Stock	215.85	215.91	215.4	215.4	3238.0
2020-12-09 07:00:00	MSFT	Stock	215.76	215.76	215.27	215.3	14354.0
2020-12-09 08:00:00	MSFT	Stock	215.78	215.78	215.24	215.43	33161.0
2020-12-09 09:00:00	MSFT	Stock	215.45	215.79	214.09	214.21	2979612.0
2020-12-09 10:00:00	MSFT	Stock	214.19	214.69	213.18	214.58	3746940.0
2020-12-09 11:00:00	MSFT	Stock	214.59	214.7	213.93	214.267	1695312.0
2020-12-09 12:00:00	MSFT	Stock	214.26	214.265	213.06	213.39	1990853.0
2020-12-09 13:00:00	MSFT	Stock	213.35	213.64	212.185	212.29	2499184.0
2020-12-09 14:00:00	MSFT	Stock	212.29	213.04	211.83	212.32	2453833.0
2020-12-09 15:00:00	MSFT	Stock	212.31	212.6	211.214	211.41	4224099.0
2020-12-09 16:00:00	MSFT	Stock	211.8	212.48	211.5	212.15	7153462.0
2020-12-09 17:00:00	MSFT	Stock	212.15	212.18	211.87	212.0	10612.0
2020-12-09 18:00:00	MSFT	Stock	212.0	212.25	211.9	211.97	10103.0
2020-12-09 19:00:00	MSFT	Stock	212.25	212.46	211.97	212.02	11253.0
2020-12-09 04:00:00	NVDA	Stock	13.325	13.325	13.3	13.3	34880.0
2020-12-09 05:00:00	NVDA	Stock	13.2805	13.2855	13.275	13.2855	41320.0
2020-12-09 06:00:00	NVDA	Stock	13.3002	13.302	13.3	13.3	25040.0
2020-12-09 07:00:00	NVDA	Stock	13.3222	13.3375	13.295	13.3125	273240.0
2020-12-09 08:00:00	NVDA	Stock	13.3003	13.3833	13.3003	13.32	727200.0
2020-12-09 09:00:00	NVDA	Stock	13.3125	13.3916	13.1403	13.3812	42974280.0
2020-12-09 10:00:00	NVDA	Stock	13.3769	13.3863	13.2248	13.3612	36278000.0
2020-12-09 11:00:00	NVDA	Stock	13.362	13.414	13.252	13.2709	25088120.0
2020-12-09 12:00:00	NVDA	Stock	13.2705	13.2705	13.0643	13.1268	41323040.0
2020-12-09 13:00:00	NVDA	Stock	13.1262	13.1638	12.9125	12.9173	34721800.0
2020-12-09 14:00:00	NVDA	Stock	12.9185	13.0342	12.9185	12.9876	35463360.0
2020-12-09 15:00:00	NVDA	Stock	12.9803	12.9923	12.8683	12.9308	52436760.0
2020-12-09 16:00:00	NVDA	Stock	12.9308	12.962	12.9	12.9488	44025160.0
2020-12-09 17:00:00	NVDA	Stock	12.9577	12.962	12.95	12.955	99880.0
2020-12-09 18:00:00	NVDA	Stock	12.962	12.9825	12.962	12.968	107960.0
2020-12-09 19:00:00	NVDA	Stock	12.975	12.975	12.9288	12.9375	368800.0
2020-12-09 06:00:00	AMZN	Stock	158.7	158.7	158.5	158.5	7680.0
2020-12-09 07:00:00	AMZN	Stock	158.575	158.6425	158.45	158.5055	98600.0
2020-12-09 08:00:00	AMZN	Stock	158.5999	159.2615	158.5999	158.697	27300.0

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

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