PREVIEW / stock_1hour / 2009-11-19

all stock 1-hour files

  file:    by_date/stock_1hour/2009/2009-11-19.parquet
  size:    879 KB
  rows:    41,898
  symbols: 3,403

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
2009-11-19 05:00:00	AAPL	Stock	7.3232	7.3232	7.3232	7.3232	13888.0
2009-11-19 06:00:00	AAPL	Stock	7.3171	7.3171	7.3089	7.3089	27468.0
2009-11-19 07:00:00	AAPL	Stock	7.3089	7.3089	7.2714	7.285	445032.0
2009-11-19 08:00:00	AAPL	Stock	7.285	7.3214	7.2719	7.3086	1816808.0
2009-11-19 09:00:00	AAPL	Stock	7.3104	7.3186	7.165	7.18	118406316.0
2009-11-19 10:00:00	AAPL	Stock	7.1789	7.2204	7.1771	7.1911	96407724.0
2009-11-19 11:00:00	AAPL	Stock	7.1904	7.2121	7.1786	7.2121	40970076.0
2009-11-19 12:00:00	AAPL	Stock	7.2118	7.2196	7.1686	7.1786	49749140.0
2009-11-19 13:00:00	AAPL	Stock	7.1786	7.1893	7.1546	7.1757	48651512.0
2009-11-19 14:00:00	AAPL	Stock	7.1761	7.1836	7.1357	7.1643	79903236.0
2009-11-19 15:00:00	AAPL	Stock	7.1643	7.1836	7.1493	7.1579	87874528.0
2009-11-19 16:00:00	AAPL	Stock	7.1607	7.1896	7.145	7.155	10550232.0
2009-11-19 17:00:00	AAPL	Stock	7.1521	7.3557	7.1429	7.1464	799428.0
2009-11-19 18:00:00	AAPL	Stock	7.1429	7.1582	7.1393	7.1411	1537480.0
2009-11-19 19:00:00	AAPL	Stock	7.1429	7.1436	7.1339	7.1357	463596.0
2009-11-19 05:00:00	MSFT	Stock	29.85	29.85	29.8	29.8	2600.0
2009-11-19 06:00:00	MSFT	Stock	29.81	29.81	29.81	29.81	500.0
2009-11-19 07:00:00	MSFT	Stock	29.98	29.98	29.96	29.96	11900.0
2009-11-19 08:00:00	MSFT	Stock	29.97	30.05	29.95	30.02	150214.0
2009-11-19 09:00:00	MSFT	Stock	30.02	30.05	29.75	29.82	7908397.0
2009-11-19 10:00:00	MSFT	Stock	29.82	29.9	29.75	29.755	9902186.0
2009-11-19 11:00:00	MSFT	Stock	29.75	29.82	29.7	29.76	7389266.0
2009-11-19 12:00:00	MSFT	Stock	29.765	29.97	29.73	29.87	6382778.0
2009-11-19 13:00:00	MSFT	Stock	29.87	29.9	29.81	29.87	3282769.0
2009-11-19 14:00:00	MSFT	Stock	29.87	29.9	29.8	29.82	4445189.0
2009-11-19 15:00:00	MSFT	Stock	29.82	29.88	29.77	29.77	8870771.0
2009-11-19 16:00:00	MSFT	Stock	29.77	30.11	29.7	29.76	2178518.0
2009-11-19 17:00:00	MSFT	Stock	29.76	29.79	29.72	29.73	8466.0
2009-11-19 18:00:00	MSFT	Stock	29.75	29.79	29.72	29.76	76369.0
2009-11-19 19:00:00	MSFT	Stock	29.77	29.8	29.77	29.8	2703.0
2009-11-19 05:00:00	NVDA	Stock	0.3313	0.3313	0.3313	0.3313	40000.0
2009-11-19 08:00:00	NVDA	Stock	0.3313	0.3313	0.3263	0.33	797000.0
2009-11-19 09:00:00	NVDA	Stock	0.33	0.3308	0.3213	0.3218	178049680.0
2009-11-19 10:00:00	NVDA	Stock	0.3218	0.3238	0.319	0.319	197400480.0
2009-11-19 11:00:00	NVDA	Stock	0.3193	0.3218	0.3185	0.3215	77728000.0
2009-11-19 12:00:00	NVDA	Stock	0.3215	0.326	0.3215	0.3244	109530200.0
2009-11-19 13:00:00	NVDA	Stock	0.3245	0.3263	0.3233	0.326	73135160.0
2009-11-19 14:00:00	NVDA	Stock	0.326	0.3261	0.3235	0.3243	58344400.0
2009-11-19 15:00:00	NVDA	Stock	0.3245	0.325	0.3228	0.3245	111786600.0
2009-11-19 16:00:00	NVDA	Stock	0.3245	0.3251	0.3203	0.3218	16316000.0
2009-11-19 17:00:00	NVDA	Stock	0.3213	0.3215	0.3195	0.3203	75600.0
2009-11-19 18:00:00	NVDA	Stock	0.3203	0.3203	0.3203	0.3203	20000.0
2009-11-19 19:00:00	NVDA	Stock	0.32	0.32	0.32	0.32	80320.0
2009-11-19 05:00:00	AMZN	Stock	6.5345	6.5345	6.5	6.5	11800.0
2009-11-19 06:00:00	AMZN	Stock	6.5	6.5685	6.5	6.5685	37160.0
2009-11-19 07:00:00	AMZN	Stock	6.55	6.55	6.508	6.5085	26980.0
2009-11-19 08:00:00	AMZN	Stock	6.5225	6.53	6.51	6.5225	139640.0
2009-11-19 09:00:00	AMZN	Stock	6.52	6.531	6.4475	6.456	17834100.0
2009-11-19 10:00:00	AMZN	Stock	6.4565	6.469	6.4375	6.4388	23304100.0
2009-11-19 11:00:00	AMZN	Stock	6.4375	6.462	6.424	6.462	17523200.0

> showing 50 of 41,898 rows — these rows as CSV

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