PREVIEW / stock_1hour / 2019-02-15

all stock 1-hour files

  file:    by_date/stock_1hour/2019/2019-02-15.parquet
  size:    1.1 MB
  rows:    49,845
  symbols: 2,667

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
2019-02-15 04:00:00	AAPL	Stock	42.37	42.37	42.2925	42.325	30140.0
2019-02-15 05:00:00	AAPL	Stock	42.3625	42.5175	42.3625	42.5175	4000.0
2019-02-15 06:00:00	AAPL	Stock	42.5475	42.615	42.4575	42.4575	16308.0
2019-02-15 07:00:00	AAPL	Stock	42.46	42.6175	42.45	42.5375	109316.0
2019-02-15 08:00:00	AAPL	Stock	42.455	42.6175	42.4075	42.6025	452764.0
2019-02-15 09:00:00	AAPL	Stock	42.5975	42.965	42.4375	42.615	22092528.0
2019-02-15 10:00:00	AAPL	Stock	42.6225	42.7975	42.5275	42.61	14193908.0
2019-02-15 11:00:00	AAPL	Stock	42.61	42.66	42.46	42.5325	9505372.0
2019-02-15 12:00:00	AAPL	Stock	42.5325	42.6575	42.4875	42.507	6219396.0
2019-02-15 13:00:00	AAPL	Stock	42.505	42.5475	42.4825	42.515	5453156.0
2019-02-15 14:00:00	AAPL	Stock	42.515	42.62	42.5125	42.605	5763920.0
2019-02-15 15:00:00	AAPL	Stock	42.6	42.64	42.4675	42.595	15341232.0
2019-02-15 16:00:00	AAPL	Stock	42.595	42.61	42.5525	42.595	8500900.0
2019-02-15 17:00:00	AAPL	Stock	42.595	42.6075	42.59	42.6	26476.0
2019-02-15 18:00:00	AAPL	Stock	42.5975	42.625	42.59	42.625	39300.0
2019-02-15 19:00:00	AAPL	Stock	42.6	42.625	42.59	42.625	36200.0
2019-02-15 04:00:00	MSFT	Stock	106.61	106.7	106.61	106.7	1647.0
2019-02-15 05:00:00	MSFT	Stock	106.8	107.01	106.8	107.01	1396.0
2019-02-15 06:00:00	MSFT	Stock	107.0	107.17	106.9	107.17	2032.0
2019-02-15 07:00:00	MSFT	Stock	106.91	107.29	106.9	107.18	15416.0
2019-02-15 08:00:00	MSFT	Stock	107.08	107.4	107.08	107.32	24070.0
2019-02-15 09:00:00	MSFT	Stock	107.25	108.3	107.2	107.73	7185365.0
2019-02-15 10:00:00	MSFT	Stock	107.74	108.29	107.64	107.81	3501226.0
2019-02-15 11:00:00	MSFT	Stock	107.815	107.95	107.362	107.625	2320883.0
2019-02-15 12:00:00	MSFT	Stock	107.63	107.82	107.54	107.65	1264892.0
2019-02-15 13:00:00	MSFT	Stock	107.645	107.72	107.52	107.655	1241729.0
2019-02-15 14:00:00	MSFT	Stock	107.65	108.01	107.65	107.955	1739018.0
2019-02-15 15:00:00	MSFT	Stock	107.95	108.22	107.82	108.21	3665482.0
2019-02-15 16:00:00	MSFT	Stock	108.21	108.22	108.0	108.14	2718895.0
2019-02-15 17:00:00	MSFT	Stock	108.05	108.22	108.05	108.13	12643.0
2019-02-15 18:00:00	MSFT	Stock	108.09	108.19	108.08	108.09	2333.0
2019-02-15 19:00:00	MSFT	Stock	108.17	108.22	108.08	108.2	4488.0
2019-02-15 04:00:00	NVDA	Stock	4.0498	4.0625	4.0215	4.05	688320.0
2019-02-15 05:00:00	NVDA	Stock	4.05	4.0675	4.05	4.0662	485640.0
2019-02-15 06:00:00	NVDA	Stock	4.0625	4.0965	4.05	4.0848	1150400.0
2019-02-15 07:00:00	NVDA	Stock	4.0815	4.12	4.0425	4.12	7986240.0
2019-02-15 08:00:00	NVDA	Stock	4.045	4.121	4.0425	4.0722	14217160.0
2019-02-15 09:00:00	NVDA	Stock	4.0703	4.1088	3.9255	3.952	360972520.0
2019-02-15 10:00:00	NVDA	Stock	3.953	4.0153	3.9192	3.979	349002440.0
2019-02-15 11:00:00	NVDA	Stock	3.979	4.0212	3.9693	3.9723	183284840.0
2019-02-15 12:00:00	NVDA	Stock	3.9725	3.9916	3.9528	3.954	103201600.0
2019-02-15 13:00:00	NVDA	Stock	3.9538	3.9641	3.9325	3.9535	106109880.0
2019-02-15 14:00:00	NVDA	Stock	3.9528	3.955	3.924	3.9318	112344120.0
2019-02-15 15:00:00	NVDA	Stock	3.9312	3.9418	3.9105	3.9325	156470840.0
2019-02-15 16:00:00	NVDA	Stock	3.9328	3.9373	3.9288	3.9358	20875080.0
2019-02-15 17:00:00	NVDA	Stock	3.9362	3.9373	3.9322	3.9345	809280.0
2019-02-15 18:00:00	NVDA	Stock	3.9345	3.9358	3.9308	3.9358	554440.0
2019-02-15 19:00:00	NVDA	Stock	3.9338	3.9375	3.9315	3.9315	563640.0
2019-02-15 04:00:00	AMZN	Stock	80.65	80.7	80.65	80.7	6000.0
2019-02-15 05:00:00	AMZN	Stock	81.1715	81.1715	81.1715	81.1715	2000.0

> showing 50 of 49,845 rows — these rows as CSV

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