PREVIEW / stock_1hour / 2019-05-15

all stock 1-hour files

  file:    by_date/stock_1hour/2019/2019-05-15.parquet
  size:    1.1 MB
  rows:    49,618
  symbols: 2,626

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-05-15 04:00:00	AAPL	Stock	47.175	47.2575	47.065	47.2125	34516.0
2019-05-15 05:00:00	AAPL	Stock	47.2225	47.375	47.125	47.125	29684.0
2019-05-15 06:00:00	AAPL	Stock	47.1	47.1525	46.9575	46.9925	33004.0
2019-05-15 07:00:00	AAPL	Stock	47.025	47.185	46.93	46.95	151676.0
2019-05-15 08:00:00	AAPL	Stock	47.05	47.2825	46.7075	46.75	687688.0
2019-05-15 09:00:00	AAPL	Stock	46.7575	47.005	46.505	46.855	13576464.0
2019-05-15 10:00:00	AAPL	Stock	46.845	47.45	46.775	47.3825	19130352.0
2019-05-15 11:00:00	AAPL	Stock	47.385	47.62	47.255	47.57	11707536.0
2019-05-15 12:00:00	AAPL	Stock	47.5725	47.69	47.48	47.5375	7626852.0
2019-05-15 13:00:00	AAPL	Stock	47.535	47.8	47.51	47.77	7129792.0
2019-05-15 14:00:00	AAPL	Stock	47.7745	47.8875	47.745	47.7818	7718556.0
2019-05-15 15:00:00	AAPL	Stock	47.78	47.9375	47.695	47.73	15531600.0
2019-05-15 16:00:00	AAPL	Stock	47.765	47.825	46.8768	47.625	7348792.0
2019-05-15 17:00:00	AAPL	Stock	47.6275	47.65	47.5775	47.65	49100.0
2019-05-15 18:00:00	AAPL	Stock	47.625	47.65	47.6175	47.6325	23940.0
2019-05-15 19:00:00	AAPL	Stock	47.65	47.715	47.6475	47.685	43788.0
2019-05-15 04:00:00	MSFT	Stock	124.41	124.7	124.22	124.7	1467.0
2019-05-15 05:00:00	MSFT	Stock	124.68	124.68	124.33	124.33	2523.0
2019-05-15 06:00:00	MSFT	Stock	124.23	124.23	124.23	124.23	100.0
2019-05-15 07:00:00	MSFT	Stock	124.33	124.49	124.19	124.19	7174.0
2019-05-15 08:00:00	MSFT	Stock	124.33	124.41	123.54	123.7	29075.0
2019-05-15 09:00:00	MSFT	Stock	123.77	124.65	123.5	124.51	2256431.0
2019-05-15 10:00:00	MSFT	Stock	124.51	125.94	124.49	125.65	4038591.0
2019-05-15 11:00:00	MSFT	Stock	125.65	126.2	125.39	126.0	2755609.0
2019-05-15 12:00:00	MSFT	Stock	126.0	126.19	125.59	125.69	1842806.0
2019-05-15 13:00:00	MSFT	Stock	125.685	126.34	125.64	126.265	1634340.0
2019-05-15 14:00:00	MSFT	Stock	126.26	126.71	126.24	126.3	2277819.0
2019-05-15 15:00:00	MSFT	Stock	126.292	126.45	125.82	126.05	3425251.0
2019-05-15 16:00:00	MSFT	Stock	126.02	126.18	125.92	126.06	2752167.0
2019-05-15 17:00:00	MSFT	Stock	126.02	126.1	126.0	126.1	7271.0
2019-05-15 18:00:00	MSFT	Stock	126.02	126.03	125.95	125.95	6039.0
2019-05-15 19:00:00	MSFT	Stock	125.93	125.93	125.93	125.93	1125.0
2019-05-15 04:00:00	NVDA	Stock	4.0552	4.0552	4.045	4.05	72400.0
2019-05-15 05:00:00	NVDA	Stock	4.0712	4.0725	4.045	4.045	43760.0
2019-05-15 06:00:00	NVDA	Stock	4.0462	4.0462	4.0372	4.0455	95880.0
2019-05-15 07:00:00	NVDA	Stock	4.0438	4.05	4.028	4.028	180200.0
2019-05-15 08:00:00	NVDA	Stock	4.045	4.0498	4.002	4.01	1674000.0
2019-05-15 09:00:00	NVDA	Stock	4.0063	4.02	3.9352	3.9785	88509880.0
2019-05-15 10:00:00	NVDA	Stock	3.9772	4.0137	3.958	4.0025	91214840.0
2019-05-15 11:00:00	NVDA	Stock	4.0038	4.0202	3.984	4.014	73436560.0
2019-05-15 12:00:00	NVDA	Stock	4.0148	4.0262	3.995	4.0013	48196360.0
2019-05-15 13:00:00	NVDA	Stock	4.0005	4.017	3.9998	4.007	33938240.0
2019-05-15 14:00:00	NVDA	Stock	4.0072	4.0165	3.9997	4.0033	40260440.0
2019-05-15 15:00:00	NVDA	Stock	4.0033	4.0112	3.9878	3.9895	82710240.0
2019-05-15 16:00:00	NVDA	Stock	3.9895	3.9988	3.9775	3.9938	19233200.0
2019-05-15 17:00:00	NVDA	Stock	3.9905	3.9938	3.9812	3.9875	2162000.0
2019-05-15 18:00:00	NVDA	Stock	3.99	3.99	3.971	3.977	677440.0
2019-05-15 19:00:00	NVDA	Stock	3.982	3.9825	3.9758	3.98	607840.0
2019-05-15 04:00:00	AMZN	Stock	92.25	92.275	92.2125	92.239	51500.0
2019-05-15 05:00:00	AMZN	Stock	92.002	92.002	92.002	92.002	2400.0

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

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