PREVIEW / stock_1hour / 2020-05-01

all stock 1-hour files

  file:    by_date/stock_1hour/2020/2020-05-01.parquet
  size:    1.2 MB
  rows:    54,391
  symbols: 2,394

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
2020-05-01 04:00:00	AAPL	Stock	71.32	71.4175	71.0	71.245	32516.0
2020-05-01 05:00:00	AAPL	Stock	71.325	71.4975	71.125	71.135	17632.0
2020-05-01 06:00:00	AAPL	Stock	71.2625	71.65	71.26	71.3775	53988.0
2020-05-01 07:00:00	AAPL	Stock	71.38	71.525	71.05	71.375	366660.0
2020-05-01 08:00:00	AAPL	Stock	71.455	71.8125	71.0275	71.6775	1140216.0
2020-05-01 09:00:00	AAPL	Stock	71.72	73.7075	71.4375	73.54	40153400.0
2020-05-01 10:00:00	AAPL	Stock	73.5475	74.75	73.375	74.2	49963844.0
2020-05-01 11:00:00	AAPL	Stock	74.2	74.32	73.275	73.365	23037192.0
2020-05-01 12:00:00	AAPL	Stock	73.3675	73.4375	72.2125	72.5875	24945052.0
2020-05-01 13:00:00	AAPL	Stock	72.5875	72.875	72.17	72.6375	13511576.0
2020-05-01 14:00:00	AAPL	Stock	72.635	72.955	72.415	72.8488	12618068.0
2020-05-01 15:00:00	AAPL	Stock	72.8525	73.14	72.005	72.2675	24866992.0
2020-05-01 16:00:00	AAPL	Stock	72.44	72.4875	72.2675	72.39	10610656.0
2020-05-01 17:00:00	AAPL	Stock	72.4075	72.625	72.3675	72.5225	112088.0
2020-05-01 18:00:00	AAPL	Stock	72.5125	72.635	72.5125	72.635	82436.0
2020-05-01 19:00:00	AAPL	Stock	72.6	72.7375	72.6	72.6	108164.0
2020-05-01 04:00:00	MSFT	Stock	175.95	175.95	174.15	175.25	6407.0
2020-05-01 05:00:00	MSFT	Stock	175.39	175.5	175.25	175.5	6201.0
2020-05-01 06:00:00	MSFT	Stock	175.66	175.7	175.32	175.44	4852.0
2020-05-01 07:00:00	MSFT	Stock	175.67	176.0	174.8	175.6	91701.0
2020-05-01 08:00:00	MSFT	Stock	174.9	175.984	174.8	175.8	165779.0
2020-05-01 09:00:00	MSFT	Stock	175.78	177.83	175.62	177.586	4460867.0
2020-05-01 10:00:00	MSFT	Stock	177.61	178.64	176.81	178.121	4928454.0
2020-05-01 11:00:00	MSFT	Stock	178.11	178.11	176.162	176.31	3445641.0
2020-05-01 12:00:00	MSFT	Stock	176.3	176.32	174.9	175.16	3803059.0
2020-05-01 13:00:00	MSFT	Stock	175.16	175.5	174.44	174.715	2854513.0
2020-05-01 14:00:00	MSFT	Stock	174.72	175.39	174.42	175.31	3326948.0
2020-05-01 15:00:00	MSFT	Stock	175.31	176.12	174.01	174.5	6489432.0
2020-05-01 16:00:00	MSFT	Stock	175.02	175.02	174.18	174.314	4361388.0
2020-05-01 17:00:00	MSFT	Stock	174.36	174.79	174.17	174.7	33697.0
2020-05-01 18:00:00	MSFT	Stock	174.6	174.8	174.55	174.78	22469.0
2020-05-01 19:00:00	MSFT	Stock	174.65	174.8	174.5	174.6	28308.0
2020-05-01 04:00:00	NVDA	Stock	7.1243	7.1243	7.1243	7.1243	5640.0
2020-05-01 05:00:00	NVDA	Stock	7.1	7.1	7.1	7.1	10600.0
2020-05-01 06:00:00	NVDA	Stock	7.125	7.125	7.1138	7.1138	8000.0
2020-05-01 07:00:00	NVDA	Stock	7.125	7.1312	7.056	7.1192	936400.0
2020-05-01 08:00:00	NVDA	Stock	7.1153	7.15	7.075	7.142	1084520.0
2020-05-01 09:00:00	NVDA	Stock	7.128	7.2225	7.059	7.1172	51187480.0
2020-05-01 10:00:00	NVDA	Stock	7.1188	7.1705	7.0855	7.1391	52097920.0
2020-05-01 11:00:00	NVDA	Stock	7.1385	7.1425	7.0285	7.042	35620200.0
2020-05-01 12:00:00	NVDA	Stock	7.041	7.0687	7.0211	7.041	21882360.0
2020-05-01 13:00:00	NVDA	Stock	7.0411	7.0768	7.0308	7.0713	16473880.0
2020-05-01 14:00:00	NVDA	Stock	7.072	7.12	7.0608	7.114	27844880.0
2020-05-01 15:00:00	NVDA	Stock	7.1142	7.1305	7.0472	7.071	59411840.0
2020-05-01 16:00:00	NVDA	Stock	7.0695	7.081	7.0555	7.0578	5790000.0
2020-05-01 17:00:00	NVDA	Stock	7.065	7.0713	7.0612	7.0713	302240.0
2020-05-01 18:00:00	NVDA	Stock	7.0713	7.0763	7.0675	7.0763	96280.0
2020-05-01 19:00:00	NVDA	Stock	7.08	7.0935	7.08	7.0825	132240.0
2020-05-01 05:00:00	AMZN	Stock	116.771	116.771	116.75	116.7595	13800.0
2020-05-01 06:00:00	AMZN	Stock	116.7535	117.744	116.75	117.4995	75620.0

> showing 50 of 54,391 rows — these rows as CSV

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