PREVIEW / stock_1hour / 2018-11-14

all stock 1-hour files

  file:    by_date/stock_1hour/2018/2018-11-14.parquet
  size:    1.1 MB
  rows:    49,330
  symbols: 2,744

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
2018-11-14 04:00:00	AAPL	Stock	48.375	48.375	47.7075	47.8	62496.0
2018-11-14 05:00:00	AAPL	Stock	47.85	48.09	47.85	48.0525	23116.0
2018-11-14 06:00:00	AAPL	Stock	48.0525	48.0525	47.73	47.73	63816.0
2018-11-14 07:00:00	AAPL	Stock	47.8225	48.05	47.8	47.875	291872.0
2018-11-14 08:00:00	AAPL	Stock	47.8675	48.455	47.75	48.42	913368.0
2018-11-14 09:00:00	AAPL	Stock	48.42	48.62	47.9675	48.045	19421656.0
2018-11-14 10:00:00	AAPL	Stock	48.0375	48.0675	47.2225	47.476	42155996.0
2018-11-14 11:00:00	AAPL	Stock	47.4725	47.4835	46.975	47.1925	28539108.0
2018-11-14 12:00:00	AAPL	Stock	47.195	47.2275	46.5775	46.6115	32092016.0
2018-11-14 13:00:00	AAPL	Stock	46.615	47.105	46.505	46.745	25857564.0
2018-11-14 14:00:00	AAPL	Stock	46.7463	47.12	46.4825	47.0675	19317584.0
2018-11-14 15:00:00	AAPL	Stock	47.065	47.24	46.6225	46.7	28510796.0
2018-11-14 16:00:00	AAPL	Stock	46.7	46.94	46.635	46.94	11226372.0
2018-11-14 17:00:00	AAPL	Stock	46.94	46.985	46.7	46.9475	486576.0
2018-11-14 18:00:00	AAPL	Stock	46.94	47.0125	46.725	46.785	241768.0
2018-11-14 19:00:00	AAPL	Stock	46.7625	46.8625	46.7	46.855	176372.0
2018-11-14 04:00:00	MSFT	Stock	106.0	106.01	105.76	106.01	967.0
2018-11-14 05:00:00	MSFT	Stock	106.34	107.27	106.34	107.27	3542.0
2018-11-14 06:00:00	MSFT	Stock	106.55	106.62	106.52	106.62	1170.0
2018-11-14 07:00:00	MSFT	Stock	106.57	106.9	106.34	106.51	10646.0
2018-11-14 08:00:00	MSFT	Stock	106.6	107.8	106.6	107.64	42010.0
2018-11-14 09:00:00	MSFT	Stock	107.64	108.26	106.68	106.84	3250248.0
2018-11-14 10:00:00	MSFT	Stock	106.84	106.91	105.95	106.17	4513159.0
2018-11-14 11:00:00	MSFT	Stock	106.15	106.15	105.26	105.9	3487805.0
2018-11-14 12:00:00	MSFT	Stock	105.91	106.065	105.1	105.165	3659591.0
2018-11-14 13:00:00	MSFT	Stock	105.16	105.32	104.47	104.94	4881723.0
2018-11-14 14:00:00	MSFT	Stock	104.93	106.5	104.5	106.42	5057154.0
2018-11-14 15:00:00	MSFT	Stock	106.42	106.69	104.79	104.97	7322713.0
2018-11-14 16:00:00	MSFT	Stock	104.97	105.15	104.75	105.06	4447432.0
2018-11-14 17:00:00	MSFT	Stock	105.1	105.23	104.97	105.082	57955.0
2018-11-14 18:00:00	MSFT	Stock	105.08	105.49	105.02	105.02	4356.0
2018-11-14 19:00:00	MSFT	Stock	105.01	105.41	104.78	105.37	6575.0
2018-11-14 04:00:00	NVDA	Stock	5.0	5.0	4.955	4.984	74800.0
2018-11-14 05:00:00	NVDA	Stock	4.9898	5.035	4.9898	5.0328	45160.0
2018-11-14 06:00:00	NVDA	Stock	5.05	5.05	4.9975	5.0128	110680.0
2018-11-14 07:00:00	NVDA	Stock	5.0312	5.0868	5.0288	5.0518	895600.0
2018-11-14 08:00:00	NVDA	Stock	5.08	5.122	5.0375	5.1172	3024560.0
2018-11-14 09:00:00	NVDA	Stock	5.1125	5.172	5.0433	5.0458	86581760.0
2018-11-14 10:00:00	NVDA	Stock	5.044	5.055	4.9835	5.0269	73246120.0
2018-11-14 11:00:00	NVDA	Stock	5.0242	5.026	4.945	5.0108	42875240.0
2018-11-14 12:00:00	NVDA	Stock	5.0113	5.0138	4.9005	4.9045	46793040.0
2018-11-14 13:00:00	NVDA	Stock	4.9062	4.95	4.8466	4.8633	37472360.0
2018-11-14 14:00:00	NVDA	Stock	4.8633	4.9675	4.8208	4.9515	61797520.0
2018-11-14 15:00:00	NVDA	Stock	4.9536	4.984	4.903	4.93	73601480.0
2018-11-14 16:00:00	NVDA	Stock	4.9298	4.9478	4.919	4.9312	10626960.0
2018-11-14 17:00:00	NVDA	Stock	4.9368	4.9373	4.9312	4.9345	234720.0
2018-11-14 18:00:00	NVDA	Stock	4.9373	4.9833	4.9325	4.9505	1009760.0
2018-11-14 19:00:00	NVDA	Stock	4.9505	4.9625	4.913	4.9438	729640.0
2018-11-14 04:00:00	AMZN	Stock	80.8765	80.99	80.8765	80.99	5280.0
2018-11-14 05:00:00	AMZN	Stock	81.159	81.3965	81.159	81.3965	4000.0

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

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