PREVIEW / stock_1hour / 2007-02-28

all stock 1-hour files

  file:    by_date/stock_1hour/2007/2007-02-28.parquet
  size:    681 KB
  rows:    32,087
  symbols: 2,532

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
2007-02-28 04:00:00	AAPL	Stock	2.995	3.0032	2.9946	3.0032	58464.0
2007-02-28 05:00:00	AAPL	Stock	3.0039	3.0039	3.0039	3.0039	25200.0
2007-02-28 06:00:00	AAPL	Stock	3.0104	3.0282	3.0071	3.0143	164332.0
2007-02-28 07:00:00	AAPL	Stock	3.0143	3.025	3.0057	3.0232	748160.0
2007-02-28 08:00:00	AAPL	Stock	3.0232	3.0386	3.0196	3.025	6771240.0
2007-02-28 09:00:00	AAPL	Stock	3.025	3.0325	2.9643	3.0175	165752916.0
2007-02-28 10:00:00	AAPL	Stock	3.0175	3.0525	3.0004	3.0429	227243184.0
2007-02-28 11:00:00	AAPL	Stock	3.0429	3.0571	3.0136	3.0186	138520508.0
2007-02-28 12:00:00	AAPL	Stock	3.0179	3.0336	3.0143	3.0275	83232660.0
2007-02-28 13:00:00	AAPL	Stock	3.0275	3.0375	3.0182	3.0254	61594316.0
2007-02-28 14:00:00	AAPL	Stock	3.0257	3.0357	3.0161	3.0257	94034696.0
2007-02-28 15:00:00	AAPL	Stock	3.0261	3.0411	3.0196	3.0214	128215892.0
2007-02-28 16:00:00	AAPL	Stock	3.02	3.0218	3.0161	3.0186	1106840.0
2007-02-28 17:00:00	AAPL	Stock	3.0196	3.0211	3.0189	3.0196	106036.0
2007-02-28 18:00:00	AAPL	Stock	3.0212	3.0289	3.0189	3.0214	442092.0
2007-02-28 19:00:00	AAPL	Stock	3.0225	3.0225	3.0207	3.0214	204008.0
2007-02-28 04:00:00	MSFT	Stock	27.67	27.73	27.65	27.65	8100.0
2007-02-28 05:00:00	MSFT	Stock	27.74	27.83	27.74	27.83	7800.0
2007-02-28 06:00:00	MSFT	Stock	27.92	27.95	27.85	27.94	15500.0
2007-02-28 07:00:00	MSFT	Stock	27.94	28.0	27.88	28.0	77395.0
2007-02-28 08:00:00	MSFT	Stock	27.97	28.14	27.91	28.11	404699.0
2007-02-28 09:00:00	MSFT	Stock	28.12	28.24	27.87	28.16	18946180.0
2007-02-28 10:00:00	MSFT	Stock	28.16	28.25	28.01	28.07	18280517.0
2007-02-28 11:00:00	MSFT	Stock	28.07	28.24	28.0	28.02	9281180.0
2007-02-28 12:00:00	MSFT	Stock	28.02	28.15	27.97	28.1	5575290.0
2007-02-28 13:00:00	MSFT	Stock	28.1	28.11	28.04	28.06	4943344.0
2007-02-28 14:00:00	MSFT	Stock	28.06	28.19	28.02	28.121	8937708.0
2007-02-28 15:00:00	MSFT	Stock	28.12	28.25	28.06	28.152	14199569.0
2007-02-28 16:00:00	MSFT	Stock	28.17	28.19	28.13	28.17	1351266.0
2007-02-28 17:00:00	MSFT	Stock	28.17	28.18	28.16	28.16	12360.0
2007-02-28 18:00:00	MSFT	Stock	28.164	28.176	28.085	28.17	140457.0
2007-02-28 19:00:00	MSFT	Stock	28.18	28.19	28.17	28.18	15602.0
2007-02-28 09:00:00	NVDA	Stock	0.5235	0.5278	0.5118	0.5208	83955960.0
2007-02-28 10:00:00	NVDA	Stock	0.5208	0.5247	0.5175	0.5218	147319920.0
2007-02-28 11:00:00	NVDA	Stock	0.5218	0.5223	0.5183	0.519	92220600.0
2007-02-28 12:00:00	NVDA	Stock	0.5189	0.5207	0.5178	0.5195	89486940.0
2007-02-28 13:00:00	NVDA	Stock	0.5193	0.52	0.517	0.519	78484200.0
2007-02-28 14:00:00	NVDA	Stock	0.519	0.5205	0.517	0.5183	93677160.0
2007-02-28 15:00:00	NVDA	Stock	0.5185	0.5202	0.5167	0.5167	164471340.0
2007-02-28 16:00:00	NVDA	Stock	0.5167	0.5173	0.5162	0.5165	344820.0
2007-02-28 17:00:00	NVDA	Stock	0.5165	0.5165	0.5165	0.5165	18000.0
2007-02-28 18:00:00	NVDA	Stock	0.5167	0.5199	0.5166	0.5199	482940.0
2007-02-28 19:00:00	NVDA	Stock	0.5167	0.5168	0.5165	0.5168	234000.0
2007-02-28 07:00:00	AMZN	Stock	1.95	1.95	1.95	1.95	4000.0
2007-02-28 08:00:00	AMZN	Stock	1.9575	1.96	1.9535	1.9535	112360.0
2007-02-28 09:00:00	AMZN	Stock	1.953	1.9545	1.904	1.9375	25957200.0
2007-02-28 10:00:00	AMZN	Stock	1.9375	1.979	1.9345	1.966	26187320.0
2007-02-28 11:00:00	AMZN	Stock	1.966	1.9695	1.9455	1.949	17039260.0
2007-02-28 12:00:00	AMZN	Stock	1.949	1.967	1.9455	1.9615	9626640.0
2007-02-28 13:00:00	AMZN	Stock	1.9615	1.965	1.9515	1.956	7406460.0

> showing 50 of 32,087 rows — these rows as CSV

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