PREVIEW / stock_1hour / 2007-10-15

all stock 1-hour files

  file:    by_date/stock_1hour/2007/2007-10-15.parquet
  size:    804 KB
  rows:    39,624
  symbols: 3,137

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-10-15 05:00:00	AAPL	Stock	6.0314	6.0429	6.0314	6.0386	49700.0
2007-10-15 06:00:00	AAPL	Stock	6.0443	6.0446	6.0314	6.0339	70000.0
2007-10-15 07:00:00	AAPL	Stock	6.0339	6.0339	5.9889	5.9896	287644.0
2007-10-15 08:00:00	AAPL	Stock	5.9896	6.0286	5.9743	6.0143	6322344.0
2007-10-15 09:00:00	AAPL	Stock	6.0143	6.0561	5.9739	6.01	129995572.0
2007-10-15 10:00:00	AAPL	Stock	6.0089	6.0482	5.9743	5.9757	143815252.0
2007-10-15 11:00:00	AAPL	Stock	5.9755	5.9757	5.8393	5.9282	242496464.0
2007-10-15 12:00:00	AAPL	Stock	5.9286	5.9393	5.8925	5.9111	87058356.0
2007-10-15 13:00:00	AAPL	Stock	5.9125	5.9657	5.875	5.9471	131479236.0
2007-10-15 14:00:00	AAPL	Stock	5.9468	5.9582	5.9032	5.9221	109460176.0
2007-10-15 15:00:00	AAPL	Stock	5.9221	5.9639	5.8611	5.9639	210210616.0
2007-10-15 16:00:00	AAPL	Stock	5.9639	5.975	5.9226	5.9636	15617168.0
2007-10-15 17:00:00	AAPL	Stock	5.9636	5.9643	5.8861	5.9571	1245020.0
2007-10-15 18:00:00	AAPL	Stock	5.9571	5.9636	5.9529	5.96	383404.0
2007-10-15 19:00:00	AAPL	Stock	5.9582	5.9607	5.9525	5.9554	232904.0
2007-10-15 08:00:00	MSFT	Stock	30.15	30.24	30.15	30.17	515484.0
2007-10-15 09:00:00	MSFT	Stock	30.17	30.32	30.05	30.26	5107047.0
2007-10-15 10:00:00	MSFT	Stock	30.26	30.33	30.17	30.2	6649310.0
2007-10-15 11:00:00	MSFT	Stock	30.2	30.27	30.13	30.18	6122086.0
2007-10-15 12:00:00	MSFT	Stock	30.18	30.23	30.0	30.1	6237894.0
2007-10-15 13:00:00	MSFT	Stock	30.1	30.13	30.04	30.09	4181537.0
2007-10-15 14:00:00	MSFT	Stock	30.1	30.111	30.0	30.09	5039515.0
2007-10-15 15:00:00	MSFT	Stock	30.1	30.16	30.0	30.1	10560454.0
2007-10-15 16:00:00	MSFT	Stock	30.07	30.144	30.028	30.118	2678721.0
2007-10-15 17:00:00	MSFT	Stock	30.171	30.171	30.03	30.05	42374.0
2007-10-15 18:00:00	MSFT	Stock	30.07	30.07	30.04	30.04	10392.0
2007-10-15 19:00:00	MSFT	Stock	30.08	30.1	30.04	30.04	6125.0
2007-10-15 08:00:00	NVDA	Stock	0.9062	0.9148	0.9033	0.9125	291040.0
2007-10-15 09:00:00	NVDA	Stock	0.9125	0.9162	0.9028	0.9158	43830520.0
2007-10-15 10:00:00	NVDA	Stock	0.9155	0.92	0.9128	0.9152	54457640.0
2007-10-15 11:00:00	NVDA	Stock	0.9152	0.9195	0.9088	0.919	51623360.0
2007-10-15 12:00:00	NVDA	Stock	0.919	0.9215	0.9148	0.9152	41157480.0
2007-10-15 13:00:00	NVDA	Stock	0.915	0.9193	0.914	0.917	26388440.0
2007-10-15 14:00:00	NVDA	Stock	0.917	0.917	0.9092	0.91	37725360.0
2007-10-15 15:00:00	NVDA	Stock	0.9098	0.9128	0.902	0.91	77240640.0
2007-10-15 16:00:00	NVDA	Stock	0.91	0.9134	0.9073	0.9133	15527960.0
2007-10-15 17:00:00	NVDA	Stock	0.9151	0.9162	0.9113	0.9113	7437000.0
2007-10-15 18:00:00	NVDA	Stock	0.91	0.9135	0.91	0.912	214600.0
2007-10-15 19:00:00	NVDA	Stock	0.9102	0.9102	0.9068	0.9068	56000.0
2007-10-15 08:00:00	AMZN	Stock	4.6415	4.6425	4.621	4.621	85980.0
2007-10-15 09:00:00	AMZN	Stock	4.621	4.621	4.5436	4.567	16922420.0
2007-10-15 10:00:00	AMZN	Stock	4.5665	4.592	4.543	4.5475	18685180.0
2007-10-15 11:00:00	AMZN	Stock	4.548	4.5525	4.505	4.5425	16599380.0
2007-10-15 12:00:00	AMZN	Stock	4.5429	4.558	4.509	4.535	11756200.0
2007-10-15 13:00:00	AMZN	Stock	4.534	4.5425	4.513	4.5385	10618180.0
2007-10-15 14:00:00	AMZN	Stock	4.539	4.5395	4.5175	4.5265	9037940.0
2007-10-15 15:00:00	AMZN	Stock	4.526	4.538	4.506	4.5303	24091820.0
2007-10-15 16:00:00	AMZN	Stock	4.532	4.6185	4.5265	4.5309	1725280.0
2007-10-15 17:00:00	AMZN	Stock	4.5499	4.5499	4.505	4.525	702120.0
2007-10-15 18:00:00	AMZN	Stock	4.5225	4.5225	4.5225	4.5225	3520.0

> showing 50 of 39,624 rows — these rows as CSV

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