PREVIEW / stock_1hour / 2019-09-30

all stock 1-hour files

  file:    by_date/stock_1hour/2019/2019-09-30.parquet
  size:    1.1 MB
  rows:    49,807
  symbols: 2,522

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-09-30 04:00:00	AAPL	Stock	55.0	55.25	55.0	55.1	40892.0
2019-09-30 05:00:00	AAPL	Stock	55.145	55.1675	55.1425	55.1675	2000.0
2019-09-30 06:00:00	AAPL	Stock	55.205	55.22	55.0675	55.0675	32984.0
2019-09-30 07:00:00	AAPL	Stock	55.0175	55.14	54.97	55.1	164104.0
2019-09-30 08:00:00	AAPL	Stock	55.1325	55.21	54.96	55.14	458676.0
2019-09-30 09:00:00	AAPL	Stock	55.125	55.5925	55.11	55.4375	14557572.0
2019-09-30 10:00:00	AAPL	Stock	55.4312	55.6595	55.29	55.6595	11055380.0
2019-09-30 11:00:00	AAPL	Stock	55.6575	55.8575	55.63	55.7925	11083676.0
2019-09-30 12:00:00	AAPL	Stock	55.8	56.1075	55.7975	56.105	10328640.0
2019-09-30 13:00:00	AAPL	Stock	56.1075	56.145	55.9525	56.045	7477512.0
2019-09-30 14:00:00	AAPL	Stock	56.0475	56.0975	55.875	56.0275	6987256.0
2019-09-30 15:00:00	AAPL	Stock	56.035	56.075	55.885	55.995	14492112.0
2019-09-30 16:00:00	AAPL	Stock	55.9925	56.1	55.9925	56.0825	10268068.0
2019-09-30 17:00:00	AAPL	Stock	56.0575	56.115	56.055	56.095	94732.0
2019-09-30 18:00:00	AAPL	Stock	56.0975	56.16	56.05	56.0925	122604.0
2019-09-30 19:00:00	AAPL	Stock	56.0925	56.1375	56.0825	56.1325	46920.0
2019-09-30 04:00:00	MSFT	Stock	138.29	138.83	138.29	138.62	3819.0
2019-09-30 05:00:00	MSFT	Stock	138.72	138.72	138.6	138.6	1094.0
2019-09-30 06:00:00	MSFT	Stock	138.52	138.73	138.36	138.36	3691.0
2019-09-30 07:00:00	MSFT	Stock	138.48	138.48	138.2	138.28	11555.0
2019-09-30 08:00:00	MSFT	Stock	138.24	138.39	137.87	137.99	39485.0
2019-09-30 09:00:00	MSFT	Stock	137.86	138.49	137.78	138.3	1499711.0
2019-09-30 10:00:00	MSFT	Stock	138.28	138.73	138.155	138.416	1339176.0
2019-09-30 11:00:00	MSFT	Stock	138.415	138.83	138.3	138.72	1253361.0
2019-09-30 12:00:00	MSFT	Stock	138.74	139.18	138.64	139.068	1285715.0
2019-09-30 13:00:00	MSFT	Stock	139.065	139.215	138.83	139.0	947261.0
2019-09-30 14:00:00	MSFT	Stock	139.0	139.06	138.79	138.84	970890.0
2019-09-30 15:00:00	MSFT	Stock	138.84	139.2	138.56	139.03	3100402.0
2019-09-30 16:00:00	MSFT	Stock	139.03	139.31	138.95	139.24	4406402.0
2019-09-30 17:00:00	MSFT	Stock	139.13	139.24	139.13	139.17	2974.0
2019-09-30 18:00:00	MSFT	Stock	139.22	139.25	139.13	139.13	6283.0
2019-09-30 19:00:00	MSFT	Stock	139.29	139.29	139.18	139.23	2946.0
2019-09-30 04:00:00	NVDA	Stock	4.3342	4.3342	4.3342	4.3342	4000.0
2019-09-30 05:00:00	NVDA	Stock	4.329	4.329	4.3282	4.3282	12120.0
2019-09-30 06:00:00	NVDA	Stock	4.3303	4.3303	4.3268	4.3268	8000.0
2019-09-30 07:00:00	NVDA	Stock	4.3153	4.3182	4.3153	4.3165	67600.0
2019-09-30 08:00:00	NVDA	Stock	4.325	4.329	4.2952	4.3038	662520.0
2019-09-30 09:00:00	NVDA	Stock	4.303	4.3288	4.2885	4.322	24733520.0
2019-09-30 10:00:00	NVDA	Stock	4.3229	4.3264	4.2925	4.3063	16586280.0
2019-09-30 11:00:00	NVDA	Stock	4.308	4.3252	4.2988	4.3222	11750320.0
2019-09-30 12:00:00	NVDA	Stock	4.3218	4.3538	4.321	4.3488	22282400.0
2019-09-30 13:00:00	NVDA	Stock	4.3489	4.362	4.3434	4.3555	12622600.0
2019-09-30 14:00:00	NVDA	Stock	4.3555	4.358	4.3376	4.3376	10206520.0
2019-09-30 15:00:00	NVDA	Stock	4.3385	4.3562	4.335	4.3518	32091520.0
2019-09-30 16:00:00	NVDA	Stock	4.3518	4.3685	4.3488	4.3625	19395800.0
2019-09-30 17:00:00	NVDA	Stock	4.368	4.368	4.3605	4.363	85480.0
2019-09-30 18:00:00	NVDA	Stock	4.363	4.3655	4.3608	4.3625	67800.0
2019-09-30 19:00:00	NVDA	Stock	4.3625	4.3658	4.3612	4.3645	89280.0
2019-09-30 04:00:00	AMZN	Stock	86.75	86.75	86.75	86.75	2000.0
2019-09-30 05:00:00	AMZN	Stock	86.7	86.7	86.7	86.7	2000.0

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

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