PREVIEW / stock_1hour / 2020-03-06

all stock 1-hour files

  file:    by_date/stock_1hour/2020/2020-03-06.parquet
  size:    1.2 MB
  rows:    54,104
  symbols: 2,420

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-03-06 04:00:00	AAPL	Stock	72.25	72.25	71.44	71.575	83196.0
2020-03-06 05:00:00	AAPL	Stock	71.4025	71.4025	70.2625	70.75	126216.0
2020-03-06 06:00:00	AAPL	Stock	70.755	71.1325	70.5275	70.8775	112408.0
2020-03-06 07:00:00	AAPL	Stock	70.925	71.265	70.075	70.56	1140896.0
2020-03-06 08:00:00	AAPL	Stock	70.55	71.26	70.06	70.88	1507128.0
2020-03-06 09:00:00	AAPL	Stock	70.8675	71.3775	70.125	71.0958	27891104.0
2020-03-06 10:00:00	AAPL	Stock	71.1	72.5125	71.0788	71.9575	32343960.0
2020-03-06 11:00:00	AAPL	Stock	71.9625	72.0075	71.0275	71.1295	19710272.0
2020-03-06 12:00:00	AAPL	Stock	71.14	71.8975	70.8975	71.32	16605964.0
2020-03-06 13:00:00	AAPL	Stock	71.31	72.0588	71.105	71.2	14788156.0
2020-03-06 14:00:00	AAPL	Stock	71.2138	71.3695	70.4975	70.6225	18363508.0
2020-03-06 15:00:00	AAPL	Stock	70.625	72.705	70.4	72.245	39100092.0
2020-03-06 16:00:00	AAPL	Stock	72.25	72.45	72.0	72.0525	14836164.0
2020-03-06 17:00:00	AAPL	Stock	72.12	72.2575	71.5975	71.67	228132.0
2020-03-06 18:00:00	AAPL	Stock	71.6125	71.8375	71.6	71.73	109428.0
2020-03-06 19:00:00	AAPL	Stock	71.6375	71.735	71.4625	71.5	92912.0
2020-03-06 04:00:00	MSFT	Stock	164.74	164.74	162.14	162.14	14380.0
2020-03-06 05:00:00	MSFT	Stock	162.14	162.27	160.8	161.5	14039.0
2020-03-06 06:00:00	MSFT	Stock	161.5	162.25	161.22	161.33	18139.0
2020-03-06 07:00:00	MSFT	Stock	161.5	162.89	160.5	161.17	127809.0
2020-03-06 08:00:00	MSFT	Stock	161.7	162.41	160.1	161.22	225880.0
2020-03-06 09:00:00	MSFT	Stock	161.22	163.11	159.67	160.59	8359327.0
2020-03-06 10:00:00	MSFT	Stock	160.59	162.44	159.08	161.39	9253710.0
2020-03-06 11:00:00	MSFT	Stock	161.4	161.98	160.12	160.36	4953682.0
2020-03-06 12:00:00	MSFT	Stock	160.36	160.58	159.0	159.55	5379873.0
2020-03-06 13:00:00	MSFT	Stock	159.55	160.776	158.76	158.93	4974679.0
2020-03-06 14:00:00	MSFT	Stock	158.92	158.98	156.56	157.04	6928736.0
2020-03-06 15:00:00	MSFT	Stock	157.03	163.03	156.0	161.57	14031933.0
2020-03-06 16:00:00	MSFT	Stock	160.32	161.58	160.11	161.35	5844324.0
2020-03-06 17:00:00	MSFT	Stock	161.37	161.57	160.66	160.66	44431.0
2020-03-06 18:00:00	MSFT	Stock	160.61	160.99	160.55	160.75	19536.0
2020-03-06 19:00:00	MSFT	Stock	160.75	160.89	160.0	160.2	10526.0
2020-03-06 04:00:00	NVDA	Stock	6.772	6.8	6.6562	6.6562	110640.0
2020-03-06 05:00:00	NVDA	Stock	6.6265	6.6265	6.551	6.6	309040.0
2020-03-06 06:00:00	NVDA	Stock	6.6	6.65	6.6	6.64	212320.0
2020-03-06 07:00:00	NVDA	Stock	6.6598	6.6698	6.5875	6.6008	2823760.0
2020-03-06 08:00:00	NVDA	Stock	6.6552	6.675	6.5655	6.6588	2633680.0
2020-03-06 09:00:00	NVDA	Stock	6.6538	6.6975	6.491	6.5663	73704480.0
2020-03-06 10:00:00	NVDA	Stock	6.5632	6.7098	6.5175	6.6515	84093440.0
2020-03-06 11:00:00	NVDA	Stock	6.654	6.6585	6.5113	6.5442	59543320.0
2020-03-06 12:00:00	NVDA	Stock	6.5448	6.6118	6.5165	6.5628	36139680.0
2020-03-06 13:00:00	NVDA	Stock	6.5607	6.6163	6.5063	6.5068	33015880.0
2020-03-06 14:00:00	NVDA	Stock	6.5138	6.5315	6.4625	6.468	42126920.0
2020-03-06 15:00:00	NVDA	Stock	6.4675	6.6745	6.45	6.6518	76220120.0
2020-03-06 16:00:00	NVDA	Stock	6.651	6.651	6.615	6.6312	22110360.0
2020-03-06 17:00:00	NVDA	Stock	6.6365	6.6375	6.6095	6.6095	445280.0
2020-03-06 18:00:00	NVDA	Stock	6.6	6.6095	6.5832	6.5975	44000.0
2020-03-06 19:00:00	NVDA	Stock	6.6012	6.602	6.578	6.578	37360.0
2020-03-06 04:00:00	AMZN	Stock	95.0	95.0	94.355	94.355	14500.0
2020-03-06 05:00:00	AMZN	Stock	94.0	94.0	93.183	93.499	17380.0

> showing 50 of 54,104 rows — these rows as CSV

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