PREVIEW / stock_1hour / 2010-04-15

all stock 1-hour files

  file:    by_date/stock_1hour/2010/2010-04-15.parquet
  size:    923 KB
  rows:    43,534
  symbols: 3,496

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
2010-04-15 04:00:00	AAPL	Stock	8.7454	8.75	8.745	8.75	30800.0
2010-04-15 05:00:00	AAPL	Stock	8.7411	8.7411	8.7393	8.7393	16100.0
2010-04-15 06:00:00	AAPL	Stock	8.7393	8.7393	8.7393	8.7393	7280.0
2010-04-15 07:00:00	AAPL	Stock	8.75	8.7589	8.75	8.7571	107744.0
2010-04-15 08:00:00	AAPL	Stock	8.7586	8.7682	8.7536	8.7668	1843968.0
2010-04-15 09:00:00	AAPL	Stock	8.7679	8.8107	8.7604	8.797	50249108.0
2010-04-15 10:00:00	AAPL	Stock	8.7971	8.8229	8.7918	8.8214	57003520.0
2010-04-15 11:00:00	AAPL	Stock	8.8218	8.85	8.8168	8.8257	67970196.0
2010-04-15 12:00:00	AAPL	Stock	8.8271	8.8554	8.8214	8.8439	40696180.0
2010-04-15 13:00:00	AAPL	Stock	8.8432	8.8557	8.8357	8.8518	24137316.0
2010-04-15 14:00:00	AAPL	Stock	8.8521	8.8832	8.8514	8.8811	43654184.0
2010-04-15 15:00:00	AAPL	Stock	8.8811	8.8939	8.8596	8.89	75700744.0
2010-04-15 16:00:00	AAPL	Stock	8.89	8.8975	8.7698	8.8621	8932756.0
2010-04-15 17:00:00	AAPL	Stock	8.8621	8.8679	8.8471	8.8518	726992.0
2010-04-15 18:00:00	AAPL	Stock	8.85	8.89	8.8475	8.85	432768.0
2010-04-15 19:00:00	AAPL	Stock	8.85	8.8596	8.8464	8.8536	377132.0
2010-04-15 07:00:00	MSFT	Stock	30.68	30.75	30.68	30.75	4600.0
2010-04-15 08:00:00	MSFT	Stock	30.76	30.96	30.76	30.9	29218.0
2010-04-15 09:00:00	MSFT	Stock	30.9	30.95	30.71	30.792	5394523.0
2010-04-15 10:00:00	MSFT	Stock	30.795	30.95	30.76	30.835	9195340.0
2010-04-15 11:00:00	MSFT	Stock	30.84	30.92	30.81	30.84	7833154.0
2010-04-15 12:00:00	MSFT	Stock	30.84	30.91	30.83	30.885	5028320.0
2010-04-15 13:00:00	MSFT	Stock	30.89	30.95	30.85	30.884	3957075.0
2010-04-15 14:00:00	MSFT	Stock	30.88	30.91	30.85	30.893	4085561.0
2010-04-15 15:00:00	MSFT	Stock	30.895	30.9	30.75	30.87	10386217.0
2010-04-15 16:00:00	MSFT	Stock	30.87	30.89	30.75	30.78	6366036.0
2010-04-15 17:00:00	MSFT	Stock	30.78	30.82	30.72	30.72	9484.0
2010-04-15 18:00:00	MSFT	Stock	30.72	30.74	30.72	30.74	4000.0
2010-04-15 19:00:00	MSFT	Stock	30.75	30.75	30.74	30.75	2428.0
2010-04-15 08:00:00	NVDA	Stock	0.4492	0.45	0.449	0.45	116680.0
2010-04-15 09:00:00	NVDA	Stock	0.4475	0.453	0.447	0.4516	98618760.0
2010-04-15 10:00:00	NVDA	Stock	0.4516	0.453	0.4494	0.4512	179334240.0
2010-04-15 11:00:00	NVDA	Stock	0.4512	0.4525	0.448	0.4484	129878480.0
2010-04-15 12:00:00	NVDA	Stock	0.4484	0.4485	0.444	0.4458	82673320.0
2010-04-15 13:00:00	NVDA	Stock	0.4458	0.4478	0.445	0.447	101594760.0
2010-04-15 14:00:00	NVDA	Stock	0.4473	0.4502	0.447	0.45	144859320.0
2010-04-15 15:00:00	NVDA	Stock	0.4498	0.4509	0.4488	0.4502	200004400.0
2010-04-15 16:00:00	NVDA	Stock	0.449	0.4512	0.4448	0.4471	11616240.0
2010-04-15 17:00:00	NVDA	Stock	0.4478	0.4478	0.4462	0.4462	84000.0
2010-04-15 18:00:00	NVDA	Stock	0.4448	0.4478	0.4448	0.4478	134000.0
2010-04-15 19:00:00	NVDA	Stock	0.4488	0.4488	0.4448	0.4458	96000.0
2010-04-15 05:00:00	AMZN	Stock	7.2	7.2	7.2	7.2	2000.0
2010-04-15 07:00:00	AMZN	Stock	7.2215	7.2215	7.221	7.221	12000.0
2010-04-15 08:00:00	AMZN	Stock	7.2485	7.249	7.2265	7.2385	242000.0
2010-04-15 09:00:00	AMZN	Stock	7.2405	7.3545	7.2	7.2894	36205180.0
2010-04-15 10:00:00	AMZN	Stock	7.293	7.34	7.276	7.321	26375780.0
2010-04-15 11:00:00	AMZN	Stock	7.3205	7.328	7.25	7.262	23184760.0
2010-04-15 12:00:00	AMZN	Stock	7.263	7.2754	7.241	7.2685	10003080.0
2010-04-15 13:00:00	AMZN	Stock	7.2685	7.2715	7.2425	7.2605	9448040.0
2010-04-15 14:00:00	AMZN	Stock	7.26	7.331	7.2585	7.2995	18591480.0

> showing 50 of 43,534 rows — these rows as CSV

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