PREVIEW / stock_1hour / 2021-12-14

all stock 1-hour files

  file:    by_date/stock_1hour/2021/2021-12-14.parquet
  size:    1.5 MB
  rows:    66,038
  symbols: 2,693

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-12-14 04:00:00	AAPL	Stock	177.27	177.84	175.74	175.85	262245.0
2021-12-14 05:00:00	AAPL	Stock	175.8	176.5	175.8	176.33	63865.0
2021-12-14 06:00:00	AAPL	Stock	176.33	176.73	176.16	176.4	56355.0
2021-12-14 07:00:00	AAPL	Stock	176.45	177.41	176.0	176.95	397604.0
2021-12-14 08:00:00	AAPL	Stock	176.64	177.42	174.58	175.0	1230060.0
2021-12-14 09:00:00	AAPL	Stock	174.97	177.74	174.4	175.8604	16690797.0
2021-12-14 10:00:00	AAPL	Stock	175.87	176.09	173.15	173.36	19559693.0
2021-12-14 11:00:00	AAPL	Stock	173.35	173.63	172.39	173.255	14918168.0
2021-12-14 12:00:00	AAPL	Stock	173.24	173.47	172.21	173.445	11113100.0
2021-12-14 13:00:00	AAPL	Stock	173.43	174.07	173.08	173.45	7678756.0
2021-12-14 14:00:00	AAPL	Stock	173.45	174.7	173.38	174.52	9044685.0
2021-12-14 15:00:00	AAPL	Stock	174.52	175.61	173.77	174.34	17214178.0
2021-12-14 16:00:00	AAPL	Stock	174.63	174.63	174.17	174.25	19512051.0
2021-12-14 17:00:00	AAPL	Stock	174.25	174.33	173.75	173.95	1245521.0
2021-12-14 18:00:00	AAPL	Stock	173.95	174.44	173.81	174.05	69405.0
2021-12-14 19:00:00	AAPL	Stock	174.03	174.44	173.95	174.44	46602.0
2021-12-14 04:00:00	MSFT	Stock	339.59	339.9	336.79	336.84	9357.0
2021-12-14 05:00:00	MSFT	Stock	337.0	337.01	336.07	336.4	6965.0
2021-12-14 06:00:00	MSFT	Stock	336.33	336.9	336.13	336.5	6146.0
2021-12-14 07:00:00	MSFT	Stock	336.7	337.72	336.4	336.94	16697.0
2021-12-14 08:00:00	MSFT	Stock	336.9432	339.4	333.72	335.25	87486.0
2021-12-14 09:00:00	MSFT	Stock	335.04	335.39	329.67	330.03	4280742.0
2021-12-14 10:00:00	MSFT	Stock	330.045	330.33	326.32	326.82	4334688.0
2021-12-14 11:00:00	MSFT	Stock	326.78	326.98	324.82	325.895	4338525.0
2021-12-14 12:00:00	MSFT	Stock	325.89	326.01	324.11	324.9	2527476.0
2021-12-14 13:00:00	MSFT	Stock	324.9	326.16	324.8145	325.27	2220562.0
2021-12-14 14:00:00	MSFT	Stock	325.26	327.5	325.22	327.05	2712116.0
2021-12-14 15:00:00	MSFT	Stock	327.02	329.68	327.01	328.48	5570674.0
2021-12-14 16:00:00	MSFT	Stock	328.34	329.0	328.31	328.7	7373098.0
2021-12-14 17:00:00	MSFT	Stock	328.7	328.74	328.05	328.47	540813.0
2021-12-14 18:00:00	MSFT	Stock	328.48	329.37	328.35	328.5	18103.0
2021-12-14 19:00:00	MSFT	Stock	328.6	329.2899	328.6	328.99	11915.0
2021-12-14 04:00:00	NVDA	Stock	28.3	28.503	27.831	27.9	565290.0
2021-12-14 05:00:00	NVDA	Stock	27.885	27.999	27.73	27.91	393680.0
2021-12-14 06:00:00	NVDA	Stock	27.928	27.944	27.833	27.901	144630.0
2021-12-14 07:00:00	NVDA	Stock	27.905	28.094	27.86	27.903	925420.0
2021-12-14 08:00:00	NVDA	Stock	28.03	28.093	27.282	27.4	4457910.0
2021-12-14 09:00:00	NVDA	Stock	27.4	28.426	27.211	28.172	97926480.0
2021-12-14 10:00:00	NVDA	Stock	28.163	28.678	27.77	27.8959	113961750.0
2021-12-14 11:00:00	NVDA	Stock	27.8986	28.13	27.576	27.706	64475440.0
2021-12-14 12:00:00	NVDA	Stock	27.718	27.753	27.434	27.6364	40984320.0
2021-12-14 13:00:00	NVDA	Stock	27.63	27.8727	27.6	27.68	34742730.0
2021-12-14 14:00:00	NVDA	Stock	27.678	28.19	27.6511	28.066	53975540.0
2021-12-14 15:00:00	NVDA	Stock	28.062	28.497	28.047	28.342	79935600.0
2021-12-14 16:00:00	NVDA	Stock	28.337	28.468	28.337	28.375	21615040.0
2021-12-14 17:00:00	NVDA	Stock	28.4	28.4	28.25	28.299	2954360.0
2021-12-14 18:00:00	NVDA	Stock	28.299	28.389	28.294	28.356	307010.0
2021-12-14 19:00:00	NVDA	Stock	28.34	28.42	28.33	28.36	286170.0
2021-12-14 07:00:00	AMZN	Stock	168.5325	168.88	168.5325	168.801	13060.0
2021-12-14 08:00:00	AMZN	Stock	168.2194	169.5675	167.4	167.65	134060.0

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

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