PREVIEW / stock_1hour / 2007-02-27

all stock 1-hour files

  file:    by_date/stock_1hour/2007/2007-02-27.parquet
  size:    694 KB
  rows:    32,961
  symbols: 2,520

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-27 04:00:00	AAPL	Stock	3.1286	3.1286	3.1286	3.1286	8400.0
2007-02-27 07:00:00	AAPL	Stock	3.1143	3.1196	3.1046	3.1104	1594320.0
2007-02-27 08:00:00	AAPL	Stock	3.1096	3.1243	3.0971	3.1039	6045116.0
2007-02-27 09:00:00	AAPL	Stock	3.1036	3.1125	3.0675	3.0882	163280460.0
2007-02-27 10:00:00	AAPL	Stock	3.0882	3.11	3.0839	3.0929	146246268.0
2007-02-27 11:00:00	AAPL	Stock	3.0932	3.1	3.0714	3.0721	101544352.0
2007-02-27 12:00:00	AAPL	Stock	3.0721	3.0746	3.05	3.0629	139004740.0
2007-02-27 13:00:00	AAPL	Stock	3.0629	3.0721	3.0482	3.0536	79688476.0
2007-02-27 14:00:00	AAPL	Stock	3.0536	3.0546	2.9839	3.0036	250436060.0
2007-02-27 15:00:00	AAPL	Stock	3.0032	3.0332	2.9789	2.9982	228946704.0
2007-02-27 16:00:00	AAPL	Stock	2.9996	3.0254	2.9886	2.9929	5715696.0
2007-02-27 17:00:00	AAPL	Stock	2.9921	3.0125	2.9921	2.9961	1794016.0
2007-02-27 18:00:00	AAPL	Stock	2.9961	2.9975	2.9857	2.9875	746088.0
2007-02-27 19:00:00	AAPL	Stock	2.9907	2.9911	2.9875	2.9875	390740.0
2007-02-27 04:00:00	MSFT	Stock	28.82	28.82	28.82	28.82	100.0
2007-02-27 07:00:00	MSFT	Stock	28.75	28.75	28.7	28.7	1500.0
2007-02-27 08:00:00	MSFT	Stock	28.77	29.27	28.7	28.7	40925.0
2007-02-27 09:00:00	MSFT	Stock	28.7	28.95	28.65	28.92	7898831.0
2007-02-27 10:00:00	MSFT	Stock	28.93	28.97	28.8	28.8	9439544.0
2007-02-27 11:00:00	MSFT	Stock	28.8	28.83	28.75	28.75	7427116.0
2007-02-27 12:00:00	MSFT	Stock	28.75	28.76	28.67	28.7	6272191.0
2007-02-27 13:00:00	MSFT	Stock	28.7	28.71	28.56	28.59	7816001.0
2007-02-27 14:00:00	MSFT	Stock	28.58	28.62	28.02	28.03	19456966.0
2007-02-27 15:00:00	MSFT	Stock	28.04	28.41	27.79	27.88	24239659.0
2007-02-27 16:00:00	MSFT	Stock	27.88	27.96	27.7	27.83	620765.0
2007-02-27 17:00:00	MSFT	Stock	27.84	28.04	27.79	27.87	106585.0
2007-02-27 18:00:00	MSFT	Stock	27.85	27.9	27.82	27.9	135020.0
2007-02-27 19:00:00	MSFT	Stock	27.87	27.89	27.84	27.84	11289.0
2007-02-27 08:00:00	NVDA	Stock	0.5302	0.5333	0.525	0.5275	516540.0
2007-02-27 09:00:00	NVDA	Stock	0.5275	0.5302	0.5198	0.5295	89854200.0
2007-02-27 10:00:00	NVDA	Stock	0.5297	0.5425	0.5295	0.5373	130974420.0
2007-02-27 11:00:00	NVDA	Stock	0.5372	0.5392	0.535	0.5353	72763380.0
2007-02-27 12:00:00	NVDA	Stock	0.5353	0.5358	0.5295	0.5302	96571380.0
2007-02-27 13:00:00	NVDA	Stock	0.5302	0.531	0.5267	0.528	59618400.0
2007-02-27 14:00:00	NVDA	Stock	0.5278	0.528	0.5203	0.5243	105615300.0
2007-02-27 15:00:00	NVDA	Stock	0.5243	0.5265	0.5188	0.5198	129381060.0
2007-02-27 16:00:00	NVDA	Stock	0.5187	0.5197	0.5172	0.5172	702300.0
2007-02-27 17:00:00	NVDA	Stock	0.5172	0.5245	0.5172	0.5197	4574880.0
2007-02-27 18:00:00	NVDA	Stock	0.5197	0.5197	0.5192	0.5192	281520.0
2007-02-27 19:00:00	NVDA	Stock	0.5172	0.5173	0.5172	0.5172	126000.0
2007-02-27 04:00:00	AMZN	Stock	2.041	2.041	2.041	2.041	4000.0
2007-02-27 07:00:00	AMZN	Stock	2.01	2.01	2.01	2.01	20000.0
2007-02-27 08:00:00	AMZN	Stock	2.011	2.02	2.01	2.01	136680.0
2007-02-27 09:00:00	AMZN	Stock	2.009	2.022	1.9905	2.015	18334540.0
2007-02-27 10:00:00	AMZN	Stock	2.0165	2.027	2.008	2.0165	14484120.0
2007-02-27 11:00:00	AMZN	Stock	2.016	2.019	2.01	2.0115	12590920.0
2007-02-27 12:00:00	AMZN	Stock	2.0115	2.012	1.9935	1.9965	16755460.0
2007-02-27 13:00:00	AMZN	Stock	1.997	1.9975	1.9665	1.9665	22619620.0
2007-02-27 14:00:00	AMZN	Stock	1.9665	1.9775	1.949	1.9545	36013680.0
2007-02-27 15:00:00	AMZN	Stock	1.9545	1.9645	1.939	1.9425	50232000.0

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

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