PREVIEW / stock_1hour / 2020-04-14

all stock 1-hour files

  file:    by_date/stock_1hour/2020/2020-04-14.parquet
  size:    1.2 MB
  rows:    55,497
  symbols: 2,422

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-04-14 04:00:00	AAPL	Stock	69.375	69.5	69.0775	69.4	65392.0
2020-04-14 05:00:00	AAPL	Stock	69.45	69.8125	69.4175	69.75	48240.0
2020-04-14 06:00:00	AAPL	Stock	69.75	69.75	69.4325	69.46	45388.0
2020-04-14 07:00:00	AAPL	Stock	69.5925	69.5925	69.2725	69.575	536980.0
2020-04-14 08:00:00	AAPL	Stock	69.4	69.8125	69.3175	69.79	825900.0
2020-04-14 09:00:00	AAPL	Stock	69.775	71.495	69.5125	71.47	30511108.0
2020-04-14 10:00:00	AAPL	Stock	71.4738	71.55	70.9	71.0465	28262100.0
2020-04-14 11:00:00	AAPL	Stock	71.0475	71.23	70.6575	71.0642	17325376.0
2020-04-14 12:00:00	AAPL	Stock	71.07	71.6338	71.07	71.5	15524612.0
2020-04-14 13:00:00	AAPL	Stock	71.5025	71.9325	71.315	71.8225	13121164.0
2020-04-14 14:00:00	AAPL	Stock	71.8275	72.01	71.6725	71.95	12180756.0
2020-04-14 15:00:00	AAPL	Stock	71.95	72.0625	71.4175	71.7675	25089548.0
2020-04-14 16:00:00	AAPL	Stock	71.7625	72.05	70.855	72.035	15296796.0
2020-04-14 17:00:00	AAPL	Stock	72.0275	72.0275	71.8025	71.8725	224696.0
2020-04-14 18:00:00	AAPL	Stock	71.875	71.99	71.775	71.945	177208.0
2020-04-14 19:00:00	AAPL	Stock	71.925	71.97	71.355	71.475	314508.0
2020-04-14 04:00:00	MSFT	Stock	168.11	168.5	167.12	168.26	35716.0
2020-04-14 05:00:00	MSFT	Stock	168.0	168.7	167.9	168.69	19373.0
2020-04-14 06:00:00	MSFT	Stock	168.6	168.9	168.25	168.79	20365.0
2020-04-14 07:00:00	MSFT	Stock	168.6	168.78	167.9	168.58	83708.0
2020-04-14 08:00:00	MSFT	Stock	168.26	169.95	165.92	168.79	251174.0
2020-04-14 09:00:00	MSFT	Stock	168.79	170.71	168.0	170.658	6509574.0
2020-04-14 10:00:00	MSFT	Stock	170.66	171.02	169.93	170.65	6081912.0
2020-04-14 11:00:00	MSFT	Stock	170.66	171.19	170.15	170.99	5231446.0
2020-04-14 12:00:00	MSFT	Stock	170.995	172.969	170.995	172.73	4821058.0
2020-04-14 13:00:00	MSFT	Stock	172.735	173.55	172.36	173.305	4282625.0
2020-04-14 14:00:00	MSFT	Stock	173.32	173.69	173.0	173.524	3519647.0
2020-04-14 15:00:00	MSFT	Stock	173.53	173.75	171.96	173.7	8344437.0
2020-04-14 16:00:00	MSFT	Stock	173.7	174.0	170.806	173.8	4879507.0
2020-04-14 17:00:00	MSFT	Stock	173.78	173.98	173.78	173.98	17399.0
2020-04-14 18:00:00	MSFT	Stock	173.98	173.99	173.76	173.95	24459.0
2020-04-14 19:00:00	MSFT	Stock	173.91	173.98	172.8	173.25	68291.0
2020-04-14 04:00:00	NVDA	Stock	6.87	6.87	6.85	6.8525	58760.0
2020-04-14 05:00:00	NVDA	Stock	6.85	6.85	6.8375	6.8375	149480.0
2020-04-14 06:00:00	NVDA	Stock	6.8385	6.875	6.8385	6.8562	229040.0
2020-04-14 07:00:00	NVDA	Stock	6.8562	6.8775	6.841	6.8652	1695000.0
2020-04-14 08:00:00	NVDA	Stock	6.8625	6.8975	6.84	6.88	3713840.0
2020-04-14 09:00:00	NVDA	Stock	6.8868	7.0342	6.8472	7.0148	98804920.0
2020-04-14 10:00:00	NVDA	Stock	7.0165	7.0498	6.9478	6.9858	89402280.0
2020-04-14 11:00:00	NVDA	Stock	6.9875	7.106	6.9312	7.0953	89296480.0
2020-04-14 12:00:00	NVDA	Stock	7.0966	7.122	7.075	7.0778	51790960.0
2020-04-14 13:00:00	NVDA	Stock	7.08	7.133	7.0585	7.1246	49566000.0
2020-04-14 14:00:00	NVDA	Stock	7.1272	7.133	7.07	7.1062	38652640.0
2020-04-14 15:00:00	NVDA	Stock	7.105	7.113	7.056	7.1002	75043800.0
2020-04-14 16:00:00	NVDA	Stock	7.0988	7.1128	7.0825	7.1075	5707320.0
2020-04-14 17:00:00	NVDA	Stock	7.11	7.1172	7.1058	7.1112	277080.0
2020-04-14 18:00:00	NVDA	Stock	7.11	7.115	7.1028	7.115	376920.0
2020-04-14 19:00:00	NVDA	Stock	7.1172	7.1175	7.0625	7.0625	815200.0
2020-04-14 04:00:00	AMZN	Stock	109.1	109.1	109.1	109.1	2000.0
2020-04-14 05:00:00	AMZN	Stock	109.1005	109.1005	109.1005	109.1005	2000.0

> showing 50 of 55,497 rows — these rows as CSV

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