PREVIEW / stock_1hour / 2007-02-26

all stock 1-hour files

  file:    by_date/stock_1hour/2007/2007-02-26.parquet
  size:    663 KB
  rows:    31,070
  symbols: 2,521

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-26 05:00:00	AAPL	Stock	3.1914	3.1929	3.1914	3.1929	27328.0
2007-02-26 06:00:00	AAPL	Stock	3.1929	3.1929	3.1929	3.1929	20216.0
2007-02-26 07:00:00	AAPL	Stock	3.1961	3.2393	3.1961	3.2257	879228.0
2007-02-26 08:00:00	AAPL	Stock	3.2239	3.2268	3.1964	3.2086	3086944.0
2007-02-26 09:00:00	AAPL	Stock	3.2086	3.2143	3.1643	3.1693	100617356.0
2007-02-26 10:00:00	AAPL	Stock	3.1686	3.1714	3.1375	3.1571	125448288.0
2007-02-26 11:00:00	AAPL	Stock	3.1571	3.2071	3.1468	3.1564	62704236.0
2007-02-26 12:00:00	AAPL	Stock	3.1561	3.1575	3.1293	3.1321	76580896.0
2007-02-26 13:00:00	AAPL	Stock	3.1318	3.1632	3.1289	3.1529	52432016.0
2007-02-26 14:00:00	AAPL	Stock	3.1525	3.1657	3.1471	3.163	60821040.0
2007-02-26 15:00:00	AAPL	Stock	3.1629	3.1643	3.1389	3.1614	120256472.0
2007-02-26 16:00:00	AAPL	Stock	3.1625	3.1636	3.1504	3.1568	5348196.0
2007-02-26 17:00:00	AAPL	Stock	3.1568	3.2096	3.1554	3.1564	1130472.0
2007-02-26 18:00:00	AAPL	Stock	3.1589	3.165	3.1586	3.1586	307412.0
2007-02-26 19:00:00	AAPL	Stock	3.1604	3.1604	3.1564	3.1586	47880.0
2007-02-26 05:00:00	MSFT	Stock	28.92	28.93	28.92	28.93	1500.0
2007-02-26 07:00:00	MSFT	Stock	28.92	28.92	28.92	28.92	100.0
2007-02-26 08:00:00	MSFT	Stock	29.65	31.0	28.9	28.98	52407.0
2007-02-26 09:00:00	MSFT	Stock	28.97	29.03	28.91	28.95	9013509.0
2007-02-26 10:00:00	MSFT	Stock	28.95	28.99	28.92	28.96	9569035.0
2007-02-26 11:00:00	MSFT	Stock	28.96	28.98	28.93	28.96	3997676.0
2007-02-26 12:00:00	MSFT	Stock	28.96	28.98	28.88	28.91	8081806.0
2007-02-26 13:00:00	MSFT	Stock	28.9	28.95	28.89	28.92	7976078.0
2007-02-26 14:00:00	MSFT	Stock	28.91	28.98	28.9	28.93	7897343.0
2007-02-26 15:00:00	MSFT	Stock	28.93	29.09	28.93	29.09	10563787.0
2007-02-26 16:00:00	MSFT	Stock	29.09	29.09	28.95	29.06	3260395.0
2007-02-26 17:00:00	MSFT	Stock	29.04	29.07	29.04	29.04	61103.0
2007-02-26 18:00:00	MSFT	Stock	29.05	29.05	29.05	29.05	300.0
2007-02-26 19:00:00	MSFT	Stock	29.07	29.07	29.04	29.04	1790.0
2007-02-26 08:00:00	NVDA	Stock	0.544	0.547	0.544	0.545	106680.0
2007-02-26 09:00:00	NVDA	Stock	0.547	0.5498	0.5442	0.5443	45488580.0
2007-02-26 10:00:00	NVDA	Stock	0.5442	0.548	0.538	0.5408	72768120.0
2007-02-26 11:00:00	NVDA	Stock	0.541	0.5458	0.5402	0.5423	41603880.0
2007-02-26 12:00:00	NVDA	Stock	0.5425	0.5433	0.538	0.5385	82677000.0
2007-02-26 13:00:00	NVDA	Stock	0.5383	0.5407	0.5382	0.5385	44990100.0
2007-02-26 14:00:00	NVDA	Stock	0.5386	0.5405	0.5363	0.5378	66172620.0
2007-02-26 15:00:00	NVDA	Stock	0.5378	0.5388	0.535	0.5362	127929360.0
2007-02-26 16:00:00	NVDA	Stock	0.5362	0.5375	0.5358	0.5375	443700.0
2007-02-26 17:00:00	NVDA	Stock	0.5367	0.5375	0.5358	0.5375	560460.0
2007-02-26 19:00:00	NVDA	Stock	0.5358	0.5358	0.5358	0.5358	60000.0
2007-02-26 08:00:00	AMZN	Stock	2.04	2.04	2.04	2.04	2000.0
2007-02-26 09:00:00	AMZN	Stock	2.04	2.06	2.04	2.048	10362160.0
2007-02-26 10:00:00	AMZN	Stock	2.048	2.0519	2.0385	2.0445	10571440.0
2007-02-26 11:00:00	AMZN	Stock	2.0445	2.0485	2.042	2.0445	5064840.0
2007-02-26 12:00:00	AMZN	Stock	2.045	2.045	2.0225	2.0225	14722720.0
2007-02-26 13:00:00	AMZN	Stock	2.0225	2.0245	2.02	2.0225	11652440.0
2007-02-26 14:00:00	AMZN	Stock	2.022	2.0325	2.0215	2.032	8626460.0
2007-02-26 15:00:00	AMZN	Stock	2.032	2.046	2.0305	2.044	16906640.0
2007-02-26 16:00:00	AMZN	Stock	2.044	2.048	2.0435	2.0435	204100.0
2007-02-26 17:00:00	AMZN	Stock	2.0435	2.0435	2.0435	2.0435	41800.0

> showing 50 of 31,070 rows — these rows as CSV

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