PREVIEW / stock_1hour / 2021-05-27

all stock 1-hour files

  file:    by_date/stock_1hour/2021/2021-05-27.parquet
  size:    1.4 MB
  rows:    65,115
  symbols: 2,971

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
2021-05-27 04:00:00	AAPL	Stock	126.36	126.66	126.29	126.35	11218.0
2021-05-27 05:00:00	AAPL	Stock	126.25	126.7	126.2	126.36	13214.0
2021-05-27 06:00:00	AAPL	Stock	126.28	126.4	126.27	126.36	3476.0
2021-05-27 07:00:00	AAPL	Stock	126.38	126.57	126.21	126.57	81074.0
2021-05-27 08:00:00	AAPL	Stock	126.44	126.85	126.19	126.48	953503.0
2021-05-27 09:00:00	AAPL	Stock	126.5	127.495	126.21	127.1299	8681254.0
2021-05-27 10:00:00	AAPL	Stock	127.11	127.64	126.915	127.065	9236794.0
2021-05-27 11:00:00	AAPL	Stock	127.06	127.24	126.7	126.815	6482756.0
2021-05-27 12:00:00	AAPL	Stock	126.82	126.89	126.5199	126.6277	4590825.0
2021-05-27 13:00:00	AAPL	Stock	126.6239	126.71	126.21	126.28	4879346.0
2021-05-27 14:00:00	AAPL	Stock	126.28	126.3	125.8	125.98	7204520.0
2021-05-27 15:00:00	AAPL	Stock	125.975	126.0	125.08	125.33	14696772.0
2021-05-27 16:00:00	AAPL	Stock	125.34	125.83	125.28	125.81	25002325.0
2021-05-27 17:00:00	AAPL	Stock	125.81	125.9	125.28	125.86	327118.0
2021-05-27 18:00:00	AAPL	Stock	125.86	125.93	125.84	125.89	35802.0
2021-05-27 19:00:00	AAPL	Stock	125.89	126.05	125.84	126.0401	65913.0
2021-05-27 04:00:00	MSFT	Stock	250.48	250.48	249.69	250.0	1063.0
2021-05-27 05:00:00	MSFT	Stock	249.68	249.68	249.4	249.44	2452.0
2021-05-27 06:00:00	MSFT	Stock	249.44	250.12	249.44	250.11	1384.0
2021-05-27 07:00:00	MSFT	Stock	250.33	250.5	250.0	250.5	14518.0
2021-05-27 08:00:00	MSFT	Stock	250.68	251.0	250.0	250.8	44094.0
2021-05-27 09:00:00	MSFT	Stock	250.79	251.49	250.26	250.27	1709787.0
2021-05-27 10:00:00	MSFT	Stock	250.27	251.39	250.13	250.72	1670713.0
2021-05-27 11:00:00	MSFT	Stock	250.71	251.23	250.51	250.975	1116441.0
2021-05-27 12:00:00	MSFT	Stock	250.95	251.07	250.38	250.58	962333.0
2021-05-27 13:00:00	MSFT	Stock	250.59	250.85	250.04	250.22	932811.0
2021-05-27 14:00:00	MSFT	Stock	250.22	250.34	249.61	249.93	1319687.0
2021-05-27 15:00:00	MSFT	Stock	249.925	250.27	249.25	249.31	3001564.0
2021-05-27 16:00:00	MSFT	Stock	249.31	250.39	249.31	250.23	8183555.0
2021-05-27 17:00:00	MSFT	Stock	250.19	250.26	249.31	250.19	5395.0
2021-05-27 18:00:00	MSFT	Stock	250.35	250.35	250.2	250.2	4345.0
2021-05-27 19:00:00	MSFT	Stock	250.2	250.4	250.19	250.4	8679.0
2021-05-27 04:00:00	NVDA	Stock	15.625	15.6625	15.565	15.565	144680.0
2021-05-27 05:00:00	NVDA	Stock	15.5805	15.6062	15.575	15.6055	107080.0
2021-05-27 06:00:00	NVDA	Stock	15.595	15.6625	15.595	15.645	124720.0
2021-05-27 07:00:00	NVDA	Stock	15.6278	15.85	15.625	15.7875	3722800.0
2021-05-27 08:00:00	NVDA	Stock	15.7646	15.85	15.625	15.6898	3746600.0
2021-05-27 09:00:00	NVDA	Stock	15.6805	15.7735	15.46	15.5099	82950840.0
2021-05-27 10:00:00	NVDA	Stock	15.5058	15.75	15.4742	15.5602	65889040.0
2021-05-27 11:00:00	NVDA	Stock	15.5648	15.707	15.5648	15.5868	38241360.0
2021-05-27 12:00:00	NVDA	Stock	15.5861	15.617	15.5448	15.5762	20105760.0
2021-05-27 13:00:00	NVDA	Stock	15.5745	15.6555	15.5636	15.5938	22508480.0
2021-05-27 14:00:00	NVDA	Stock	15.5958	15.5958	15.52	15.5632	28501600.0
2021-05-27 15:00:00	NVDA	Stock	15.5625	15.571	15.475	15.4755	38848760.0
2021-05-27 16:00:00	NVDA	Stock	15.4762	15.5125	15.4755	15.505	45588920.0
2021-05-27 17:00:00	NVDA	Stock	15.5058	15.5168	15.488	15.5148	1172240.0
2021-05-27 18:00:00	NVDA	Stock	15.515	15.5165	15.505	15.5062	214960.0
2021-05-27 19:00:00	NVDA	Stock	15.5075	15.5275	15.5055	15.5275	357480.0
2021-05-27 06:00:00	AMZN	Stock	162.95	162.95	162.95	162.95	2000.0
2021-05-27 07:00:00	AMZN	Stock	162.9	163.1	162.75	163.1	36220.0

> showing 50 of 65,115 rows — these rows as CSV

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