PREVIEW / stock_1hour / 2019-05-13

all stock 1-hour files

  file:    by_date/stock_1hour/2019/2019-05-13.parquet
  size:    1.1 MB
  rows:    50,652
  symbols: 2,620

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-13 04:00:00	AAPL	Stock	48.25	48.3375	48.1075	48.2	40596.0
2019-05-13 05:00:00	AAPL	Stock	48.3325	48.3375	48.205	48.2675	31216.0
2019-05-13 06:00:00	AAPL	Stock	48.2875	48.3125	48.115	48.2125	57628.0
2019-05-13 07:00:00	AAPL	Stock	48.24	48.2975	47.875	47.8925	342824.0
2019-05-13 08:00:00	AAPL	Stock	48.165	48.2525	47.275	47.345	2569292.0
2019-05-13 09:00:00	AAPL	Stock	47.345	47.37	46.5	47.06	42090204.0
2019-05-13 10:00:00	AAPL	Stock	47.0525	47.125	46.425	46.9585	35596916.0
2019-05-13 11:00:00	AAPL	Stock	46.9592	46.9975	46.5625	46.7635	17342316.0
2019-05-13 12:00:00	AAPL	Stock	46.77	46.78	46.45	46.4738	13464812.0
2019-05-13 13:00:00	AAPL	Stock	46.47	46.7	46.27	46.6775	19568684.0
2019-05-13 14:00:00	AAPL	Stock	46.675	46.88	46.46	46.7742	17787280.0
2019-05-13 15:00:00	AAPL	Stock	46.7725	46.8525	45.7125	46.43	30203144.0
2019-05-13 16:00:00	AAPL	Stock	46.432	46.75	46.32	46.3875	20113680.0
2019-05-13 17:00:00	AAPL	Stock	46.375	46.41	46.225	46.2465	225988.0
2019-05-13 18:00:00	AAPL	Stock	46.235	46.2375	46.16	46.2375	162416.0
2019-05-13 19:00:00	AAPL	Stock	46.2425	46.2625	46.0575	46.0575	105184.0
2019-05-13 04:00:00	MSFT	Stock	125.07	125.35	124.8	125.04	4496.0
2019-05-13 05:00:00	MSFT	Stock	125.1	125.1	125.01	125.01	862.0
2019-05-13 06:00:00	MSFT	Stock	125.22	125.25	124.89	125.2	3332.0
2019-05-13 07:00:00	MSFT	Stock	125.29	125.43	124.86	124.92	29494.0
2019-05-13 08:00:00	MSFT	Stock	125.3	125.45	124.0	124.38	78776.0
2019-05-13 09:00:00	MSFT	Stock	124.14	125.55	124.02	124.43	3203686.0
2019-05-13 10:00:00	MSFT	Stock	124.435	124.57	123.64	124.28	4354665.0
2019-05-13 11:00:00	MSFT	Stock	124.29	124.46	123.59	124.01	3326755.0
2019-05-13 12:00:00	MSFT	Stock	124.006	124.02	123.35	123.37	2579670.0
2019-05-13 13:00:00	MSFT	Stock	123.38	124.085	123.15	124.03	2508419.0
2019-05-13 14:00:00	MSFT	Stock	124.03	124.29	123.54	124.09	3359320.0
2019-05-13 15:00:00	MSFT	Stock	124.09	124.33	123.04	123.31	5787370.0
2019-05-13 16:00:00	MSFT	Stock	123.35	123.35	123.0	123.008	4649956.0
2019-05-13 17:00:00	MSFT	Stock	123.1	123.18	123.0	123.13	7905.0
2019-05-13 18:00:00	MSFT	Stock	123.04	123.19	122.88	123.19	8516.0
2019-05-13 19:00:00	MSFT	Stock	123.1	123.23	122.9	122.94	7771.0
2019-05-13 04:00:00	NVDA	Stock	4.1112	4.115	4.0972	4.115	153600.0
2019-05-13 05:00:00	NVDA	Stock	4.1115	4.126	4.1108	4.126	22640.0
2019-05-13 06:00:00	NVDA	Stock	4.1245	4.1305	4.11	4.125	107400.0
2019-05-13 07:00:00	NVDA	Stock	4.125	4.14	4.1115	4.1125	1073240.0
2019-05-13 08:00:00	NVDA	Stock	4.1259	4.14	4.0902	4.1075	4660280.0
2019-05-13 09:00:00	NVDA	Stock	4.1112	4.1172	4.0348	4.0467	108048360.0
2019-05-13 10:00:00	NVDA	Stock	4.0452	4.0825	4.0148	4.0451	96166920.0
2019-05-13 11:00:00	NVDA	Stock	4.0458	4.0578	4.002	4.017	61071120.0
2019-05-13 12:00:00	NVDA	Stock	4.0172	4.0202	3.9868	3.9965	62914000.0
2019-05-13 13:00:00	NVDA	Stock	3.9958	4.016	3.9855	4.008	48720640.0
2019-05-13 14:00:00	NVDA	Stock	4.0072	4.0285	3.9805	4.0138	58146120.0
2019-05-13 15:00:00	NVDA	Stock	4.0138	4.0256	3.9452	3.96	123524680.0
2019-05-13 16:00:00	NVDA	Stock	3.9612	3.9655	3.9452	3.9562	4835880.0
2019-05-13 17:00:00	NVDA	Stock	3.9562	3.957	3.9455	3.957	203000.0
2019-05-13 18:00:00	NVDA	Stock	3.9562	3.9598	3.947	3.9598	220320.0
2019-05-13 19:00:00	NVDA	Stock	3.95	3.9553	3.9438	3.9438	407480.0
2019-05-13 04:00:00	AMZN	Stock	92.594	92.6555	92.45	92.6025	28020.0
2019-05-13 05:00:00	AMZN	Stock	92.6005	92.7	92.55	92.675	35020.0

> showing 50 of 50,652 rows — these rows as CSV

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