PREVIEW / stock_1hour / 2018-09-07

all stock 1-hour files

  file:    by_date/stock_1hour/2018/2018-09-07.parquet
  size:    1.1 MB
  rows:    49,020
  symbols: 2,783

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-09-07 04:00:00	AAPL	Stock	55.885	55.885	55.825	55.825	800.0
2018-09-07 05:00:00	AAPL	Stock	55.875	55.9625	55.875	55.88	35928.0
2018-09-07 06:00:00	AAPL	Stock	55.8525	55.95	55.85	55.95	23636.0
2018-09-07 07:00:00	AAPL	Stock	55.895	55.9575	55.78	55.78	172184.0
2018-09-07 08:00:00	AAPL	Stock	55.8875	55.9625	55.5625	55.595	564888.0
2018-09-07 09:00:00	AAPL	Stock	55.59	56.19	55.385	56.1415	17537364.0
2018-09-07 10:00:00	AAPL	Stock	56.1425	56.3055	56.05	56.2925	13945088.0
2018-09-07 11:00:00	AAPL	Stock	56.295	56.3425	56.1125	56.1488	11279720.0
2018-09-07 12:00:00	AAPL	Stock	56.1488	56.1635	55.6952	56.0688	15155996.0
2018-09-07 13:00:00	AAPL	Stock	56.0682	56.085	55.7775	55.85	7910436.0
2018-09-07 14:00:00	AAPL	Stock	55.8475	56.185	55.8425	56.18	7979152.0
2018-09-07 15:00:00	AAPL	Stock	56.1775	56.21	55.1775	55.355	45009160.0
2018-09-07 16:00:00	AAPL	Stock	55.325	55.805	55.1575	55.27	9357656.0
2018-09-07 17:00:00	AAPL	Stock	55.2675	55.9808	55.02	55.0525	380412.0
2018-09-07 18:00:00	AAPL	Stock	55.0725	55.0725	54.88	55.0225	239892.0
2018-09-07 19:00:00	AAPL	Stock	55.02	55.1575	54.95	55.0825	123772.0
2018-09-07 04:00:00	MSFT	Stock	108.74	108.74	108.74	108.74	100.0
2018-09-07 07:00:00	MSFT	Stock	108.72	108.94	108.72	108.8	4045.0
2018-09-07 08:00:00	MSFT	Stock	108.83	108.85	107.92	108.1	23617.0
2018-09-07 09:00:00	MSFT	Stock	108.02	108.515	107.23	108.515	3398213.0
2018-09-07 10:00:00	MSFT	Stock	108.52	108.725	108.05	108.56	3034118.0
2018-09-07 11:00:00	MSFT	Stock	108.57	108.67	108.28	108.48	1688311.0
2018-09-07 12:00:00	MSFT	Stock	108.48	108.72	107.79	108.615	2270840.0
2018-09-07 13:00:00	MSFT	Stock	108.62	108.64	108.1	108.12	1066874.0
2018-09-07 14:00:00	MSFT	Stock	108.116	108.38	108.1	108.345	1266078.0
2018-09-07 15:00:00	MSFT	Stock	108.34	108.385	107.98	108.29	4392223.0
2018-09-07 16:00:00	MSFT	Stock	108.21	108.3	107.97	108.15	3309368.0
2018-09-07 17:00:00	MSFT	Stock	108.15	108.229	108.06	108.2	6949.0
2018-09-07 18:00:00	MSFT	Stock	108.04	108.18	108.04	108.18	1851.0
2018-09-07 19:00:00	MSFT	Stock	108.06	108.06	108.06	108.06	100.0
2018-09-07 04:00:00	NVDA	Stock	6.7592	6.7782	6.758	6.7782	46160.0
2018-09-07 06:00:00	NVDA	Stock	6.7795	6.7795	6.7795	6.7795	4000.0
2018-09-07 07:00:00	NVDA	Stock	6.789	6.8018	6.7825	6.789	212640.0
2018-09-07 08:00:00	NVDA	Stock	6.7873	6.8	6.7458	6.7458	1403160.0
2018-09-07 09:00:00	NVDA	Stock	6.7392	6.8775	6.6798	6.8702	53420480.0
2018-09-07 10:00:00	NVDA	Stock	6.8695	6.905	6.844	6.8865	50194760.0
2018-09-07 11:00:00	NVDA	Stock	6.8859	6.9232	6.8672	6.8675	27092200.0
2018-09-07 12:00:00	NVDA	Stock	6.8695	6.8755	6.8055	6.8585	30592840.0
2018-09-07 13:00:00	NVDA	Stock	6.8609	6.8617	6.799	6.8036	13232800.0
2018-09-07 14:00:00	NVDA	Stock	6.803	6.8395	6.8019	6.8187	18355800.0
2018-09-07 15:00:00	NVDA	Stock	6.82	6.8282	6.7862	6.797	44571880.0
2018-09-07 16:00:00	NVDA	Stock	6.7995	6.8062	6.7628	6.7842	3127640.0
2018-09-07 17:00:00	NVDA	Stock	6.7875	6.7965	6.784	6.7965	102080.0
2018-09-07 18:00:00	NVDA	Stock	6.79	6.79	6.7765	6.7768	48680.0
2018-09-07 19:00:00	NVDA	Stock	6.7763	6.784	6.7763	6.78	51680.0
2018-09-07 04:00:00	AMZN	Stock	98.0	98.0	98.0	98.0	4600.0
2018-09-07 06:00:00	AMZN	Stock	97.671	97.683	97.671	97.683	6000.0
2018-09-07 07:00:00	AMZN	Stock	97.7	97.7	97.4825	97.4825	30980.0
2018-09-07 08:00:00	AMZN	Stock	97.7	97.7	97.0	97.0	451420.0
2018-09-07 09:00:00	AMZN	Stock	96.9015	98.3825	96.75	98.1995	12210020.0

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

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