PREVIEW / stock_1hour / 2020-06-25

all stock 1-hour files

  file:    by_date/stock_1hour/2020/2020-06-25.parquet
  size:    1.2 MB
  rows:    56,710
  symbols: 2,432

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-06-25 04:00:00	AAPL	Stock	89.3875	90.175	89.35	90.175	20904.0
2020-06-25 05:00:00	AAPL	Stock	90.1675	90.4725	90.0875	90.0875	12068.0
2020-06-25 06:00:00	AAPL	Stock	90.16	90.6	90.075	90.53	26664.0
2020-06-25 07:00:00	AAPL	Stock	90.53	90.7	89.9775	89.9775	344716.0
2020-06-25 08:00:00	AAPL	Stock	90.525	90.745	89.8775	90.475	839044.0
2020-06-25 09:00:00	AAPL	Stock	90.45	90.845	89.3925	89.9102	18949676.0
2020-06-25 10:00:00	AAPL	Stock	89.9075	90.72	89.8625	90.3812	20001652.0
2020-06-25 11:00:00	AAPL	Stock	90.3775	90.4925	89.9	90.3358	12224172.0
2020-06-25 12:00:00	AAPL	Stock	90.3425	91.005	90.3425	90.6125	14912668.0
2020-06-25 13:00:00	AAPL	Stock	90.6125	90.735	90.31	90.49	7023624.0
2020-06-25 14:00:00	AAPL	Stock	90.4925	90.5125	90.0	90.2652	10840096.0
2020-06-25 15:00:00	AAPL	Stock	90.255	91.25	90.1675	91.22	20787612.0
2020-06-25 16:00:00	AAPL	Stock	91.21	91.255	90.97	91.1275	6731568.0
2020-06-25 17:00:00	AAPL	Stock	91.1375	91.2075	91.11	91.1125	54924.0
2020-06-25 18:00:00	AAPL	Stock	91.175	91.2475	91.125	91.2125	81376.0
2020-06-25 19:00:00	AAPL	Stock	91.22	91.35	91.18	91.3375	105412.0
2020-06-25 04:00:00	MSFT	Stock	196.5	197.91	196.5	197.91	3150.0
2020-06-25 05:00:00	MSFT	Stock	198.2	198.4	198.2	198.4	200.0
2020-06-25 06:00:00	MSFT	Stock	198.36	198.36	198.0	198.35	6749.0
2020-06-25 07:00:00	MSFT	Stock	198.03	198.35	197.5	197.51	21242.0
2020-06-25 08:00:00	MSFT	Stock	198.3	198.36	197.0	197.8	68481.0
2020-06-25 09:00:00	MSFT	Stock	197.654	199.03	195.468	196.926	3312039.0
2020-06-25 10:00:00	MSFT	Stock	196.88	198.16	196.61	197.495	3363670.0
2020-06-25 11:00:00	MSFT	Stock	197.45	198.06	196.54	197.87	2233796.0
2020-06-25 12:00:00	MSFT	Stock	197.9	198.82	197.86	198.15	2086282.0
2020-06-25 13:00:00	MSFT	Stock	198.15	198.67	197.81	198.415	1659391.0
2020-06-25 14:00:00	MSFT	Stock	198.415	198.48	197.32	197.93	1698492.0
2020-06-25 15:00:00	MSFT	Stock	197.91	200.61	197.73	200.36	5648241.0
2020-06-25 16:00:00	MSFT	Stock	200.34	200.95	200.23	200.78	2903608.0
2020-06-25 17:00:00	MSFT	Stock	200.65	200.66	200.35	200.35	7453.0
2020-06-25 18:00:00	MSFT	Stock	200.44	200.95	200.4	200.68	19145.0
2020-06-25 19:00:00	MSFT	Stock	200.69	201.35	200.5	201.32	21662.0
2020-06-25 04:00:00	NVDA	Stock	9.2	9.2322	9.2	9.2322	26320.0
2020-06-25 05:00:00	NVDA	Stock	9.2778	9.2778	9.275	9.275	13800.0
2020-06-25 06:00:00	NVDA	Stock	9.2968	9.3	9.2968	9.2988	16000.0
2020-06-25 07:00:00	NVDA	Stock	9.3	9.3	9.24	9.2478	609760.0
2020-06-25 08:00:00	NVDA	Stock	9.2812	9.3175	9.241	9.3025	2082040.0
2020-06-25 09:00:00	NVDA	Stock	9.3013	9.3992	9.1823	9.2872	67307520.0
2020-06-25 10:00:00	NVDA	Stock	9.284	9.38	9.2275	9.324	56148720.0
2020-06-25 11:00:00	NVDA	Stock	9.3243	9.3312	9.258	9.3121	29454200.0
2020-06-25 12:00:00	NVDA	Stock	9.3132	9.377	9.3132	9.3388	26146240.0
2020-06-25 13:00:00	NVDA	Stock	9.3362	9.355	9.3095	9.3362	17209640.0
2020-06-25 14:00:00	NVDA	Stock	9.337	9.3495	9.2842	9.3484	20642920.0
2020-06-25 15:00:00	NVDA	Stock	9.3468	9.505	9.34	9.495	82846480.0
2020-06-25 16:00:00	NVDA	Stock	9.49	9.5038	9.4778	9.4892	5811080.0
2020-06-25 17:00:00	NVDA	Stock	9.495	9.4995	9.484	9.4878	238640.0
2020-06-25 18:00:00	NVDA	Stock	9.4927	9.5125	9.4927	9.5125	273680.0
2020-06-25 19:00:00	NVDA	Stock	9.5142	9.528	9.5	9.528	441280.0
2020-06-25 04:00:00	AMZN	Stock	136.65	136.65	136.65	136.65	2000.0
2020-06-25 05:00:00	AMZN	Stock	137.283	137.392	137.173	137.392	6000.0

> showing 50 of 56,710 rows — these rows as CSV

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