PREVIEW / stock_1hour / 2020-12-22

all stock 1-hour files

  file:    by_date/stock_1hour/2020/2020-12-22.parquet
  size:    1.4 MB
  rows:    65,046
  symbols: 2,683

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-22 04:00:00	AAPL	Stock	130.7	131.94	130.69	131.81	172175.0
2020-12-22 05:00:00	AAPL	Stock	131.82	131.98	131.14	131.39	67432.0
2020-12-22 06:00:00	AAPL	Stock	131.38	131.9	131.25	131.55	67090.0
2020-12-22 07:00:00	AAPL	Stock	131.55	132.5	131.4	131.85	1246783.0
2020-12-22 08:00:00	AAPL	Stock	131.915	132.47	130.58	132.16	1635052.0
2020-12-22 09:00:00	AAPL	Stock	132.17	134.25	130.4	134.13	37947807.0
2020-12-22 10:00:00	AAPL	Stock	134.12	134.405	132.28	132.879	28588165.0
2020-12-22 11:00:00	AAPL	Stock	132.875	132.895	129.65	131.475	22046266.0
2020-12-22 12:00:00	AAPL	Stock	131.475	132.36	131.04	131.992	14990579.0
2020-12-22 13:00:00	AAPL	Stock	132.0	133.15	131.97	132.755	11894208.0
2020-12-22 14:00:00	AAPL	Stock	132.76	132.99	131.89	132.041	10551488.0
2020-12-22 15:00:00	AAPL	Stock	132.05	132.32	131.222	131.845	14664959.0
2020-12-22 16:00:00	AAPL	Stock	131.88	131.89	131.5	131.71	7226286.0
2020-12-22 17:00:00	AAPL	Stock	131.71	131.88	131.52	131.67	566680.0
2020-12-22 18:00:00	AAPL	Stock	131.68	131.88	131.53	131.8	646366.0
2020-12-22 19:00:00	AAPL	Stock	131.73	131.8	130.23	130.33	302301.0
2020-12-22 04:00:00	MSFT	Stock	222.4	223.22	222.4	222.85	4065.0
2020-12-22 05:00:00	MSFT	Stock	222.8	222.86	222.7	222.7	552.0
2020-12-22 06:00:00	MSFT	Stock	222.72	223.35	222.7	223.0	3601.0
2020-12-22 07:00:00	MSFT	Stock	223.04	223.72	222.94	223.31	23720.0
2020-12-22 08:00:00	MSFT	Stock	223.512	223.75	222.36	222.95	56233.0
2020-12-22 09:00:00	MSFT	Stock	222.86	225.63	221.85	225.3	3794508.0
2020-12-22 10:00:00	MSFT	Stock	225.305	225.305	223.45	224.16	2734522.0
2020-12-22 11:00:00	MSFT	Stock	224.154	224.57	223.12	223.72	2096598.0
2020-12-22 12:00:00	MSFT	Stock	223.74	224.46	223.66	224.28	1066417.0
2020-12-22 13:00:00	MSFT	Stock	224.28	224.58	224.07	224.21	1379010.0
2020-12-22 14:00:00	MSFT	Stock	224.26	224.477	223.16	223.27	1385848.0
2020-12-22 15:00:00	MSFT	Stock	223.27	224.0	222.97	223.97	2606596.0
2020-12-22 16:00:00	MSFT	Stock	223.96	223.96	223.51	223.7	2956870.0
2020-12-22 17:00:00	MSFT	Stock	223.7	223.94	223.3	223.4	125809.0
2020-12-22 18:00:00	MSFT	Stock	223.39	223.94	223.31	223.64	120951.0
2020-12-22 19:00:00	MSFT	Stock	223.52	223.52	222.17	222.5	17625.0
2020-12-22 04:00:00	NVDA	Stock	13.3325	13.3615	13.3325	13.3615	22080.0
2020-12-22 05:00:00	NVDA	Stock	13.3485	13.3485	13.3485	13.3485	4000.0
2020-12-22 07:00:00	NVDA	Stock	13.3375	13.3688	13.3375	13.3688	127720.0
2020-12-22 08:00:00	NVDA	Stock	13.36	13.3794	13.3302	13.3775	496560.0
2020-12-22 09:00:00	NVDA	Stock	13.3688	13.3688	13.2185	13.2502	23483200.0
2020-12-22 10:00:00	NVDA	Stock	13.25	13.2964	13.175	13.2158	23734320.0
2020-12-22 11:00:00	NVDA	Stock	13.2176	13.24	13.0539	13.142	25693600.0
2020-12-22 12:00:00	NVDA	Stock	13.138	13.2198	13.1188	13.2151	15132920.0
2020-12-22 13:00:00	NVDA	Stock	13.2185	13.2435	13.2082	13.2228	10227440.0
2020-12-22 14:00:00	NVDA	Stock	13.2288	13.2663	13.2288	13.2525	11305600.0
2020-12-22 15:00:00	NVDA	Stock	13.2518	13.2791	13.224	13.2782	21508200.0
2020-12-22 16:00:00	NVDA	Stock	13.2782	13.2796	13.256	13.2562	21634760.0
2020-12-22 17:00:00	NVDA	Stock	13.24	13.2782	13.24	13.2782	244320.0
2020-12-22 18:00:00	NVDA	Stock	13.2782	13.2782	13.2458	13.25	394520.0
2020-12-22 19:00:00	NVDA	Stock	13.2475	13.2548	13.1875	13.1875	476680.0
2020-12-22 07:00:00	AMZN	Stock	160.2	160.639	160.2	160.639	14100.0
2020-12-22 08:00:00	AMZN	Stock	160.1111	160.759	160.1063	160.5	655880.0
2020-12-22 09:00:00	AMZN	Stock	160.3	161.1	159.4	160.9613	4040540.0

> showing 50 of 65,046 rows — these rows as CSV

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