PREVIEW / stock_1hour / 2010-02-24

all stock 1-hour files

  file:    by_date/stock_1hour/2010/2010-02-24.parquet
  size:    883 KB
  rows:    42,238
  symbols: 3,455

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-02-24 04:00:00	AAPL	Stock	7.0432	7.0432	7.0154	7.0154	29008.0
2010-02-24 05:00:00	AAPL	Stock	7.0261	7.0314	7.0261	7.0314	8400.0
2010-02-24 06:00:00	AAPL	Stock	7.0357	7.0529	7.0318	7.0529	25200.0
2010-02-24 07:00:00	AAPL	Stock	7.0571	7.0804	7.0571	7.0679	690312.0
2010-02-24 08:00:00	AAPL	Stock	7.0636	7.0761	7.0607	7.075	1802892.0
2010-02-24 09:00:00	AAPL	Stock	7.0721	7.1375	7.0643	7.1289	75766964.0
2010-02-24 10:00:00	AAPL	Stock	7.1282	7.175	7.1021	7.1668	109786852.0
2010-02-24 11:00:00	AAPL	Stock	7.1664	7.1714	7.14	7.1507	48644596.0
2010-02-24 12:00:00	AAPL	Stock	7.1507	7.1685	7.145	7.1607	28445844.0
2010-02-24 13:00:00	AAPL	Stock	7.1611	7.1943	7.1571	7.1896	56599648.0
2010-02-24 14:00:00	AAPL	Stock	7.1889	7.1914	7.1336	7.1339	53742752.0
2010-02-24 15:00:00	AAPL	Stock	7.1346	7.1711	7.1193	7.1625	72131920.0
2010-02-24 16:00:00	AAPL	Stock	7.1625	7.1768	7.1371	7.1689	7625828.0
2010-02-24 17:00:00	AAPL	Stock	7.1544	7.1696	7.1544	7.1693	67200.0
2010-02-24 18:00:00	AAPL	Stock	7.1664	7.1696	7.1664	7.1682	85372.0
2010-02-24 19:00:00	AAPL	Stock	7.1661	7.1704	7.1625	7.1661	294028.0
2010-02-24 08:00:00	MSFT	Stock	28.4	28.4	28.38	28.39	16018.0
2010-02-24 09:00:00	MSFT	Stock	28.4	28.77	28.38	28.738	5892251.0
2010-02-24 10:00:00	MSFT	Stock	28.72	28.75	28.38	28.71	11990653.0
2010-02-24 11:00:00	MSFT	Stock	28.705	28.75	28.6	28.715	3825675.0
2010-02-24 12:00:00	MSFT	Stock	28.71	28.79	28.68	28.73	3061665.0
2010-02-24 13:00:00	MSFT	Stock	28.72	28.74	28.59	28.64	3960420.0
2010-02-24 14:00:00	MSFT	Stock	28.65	28.655	28.51	28.56	5046727.0
2010-02-24 15:00:00	MSFT	Stock	28.565	28.66	28.52	28.64	6594807.0
2010-02-24 16:00:00	MSFT	Stock	28.64	28.65	28.56	28.65	1826400.0
2010-02-24 17:00:00	MSFT	Stock	28.71	28.71	28.59	28.59	200200.0
2010-02-24 19:00:00	MSFT	Stock	28.59	28.59	28.59	28.59	1000.0
2010-02-24 08:00:00	NVDA	Stock	0.4098	0.4098	0.4098	0.4098	40160.0
2010-02-24 09:00:00	NVDA	Stock	0.408	0.4128	0.4075	0.4118	55536320.0
2010-02-24 10:00:00	NVDA	Stock	0.4115	0.4162	0.409	0.4155	97715800.0
2010-02-24 11:00:00	NVDA	Stock	0.4155	0.4178	0.414	0.4168	59110720.0
2010-02-24 12:00:00	NVDA	Stock	0.4168	0.4173	0.4133	0.4135	42604520.0
2010-02-24 13:00:00	NVDA	Stock	0.4138	0.4155	0.4135	0.4148	23580480.0
2010-02-24 14:00:00	NVDA	Stock	0.4148	0.4148	0.4128	0.4129	68847960.0
2010-02-24 15:00:00	NVDA	Stock	0.4128	0.4142	0.411	0.4138	87091560.0
2010-02-24 16:00:00	NVDA	Stock	0.4138	0.4138	0.4115	0.412	8013480.0
2010-02-24 17:00:00	NVDA	Stock	0.412	0.412	0.412	0.412	60000.0
2010-02-24 18:00:00	NVDA	Stock	0.4138	0.4138	0.4138	0.4138	1483800.0
2010-02-24 19:00:00	NVDA	Stock	0.4135	0.4135	0.4135	0.4135	48000.0
2010-02-24 04:00:00	AMZN	Stock	5.85	5.85	5.85	5.85	4000.0
2010-02-24 08:00:00	AMZN	Stock	5.87	5.895	5.87	5.8885	33120.0
2010-02-24 09:00:00	AMZN	Stock	5.8945	5.935	5.875	5.9211	13583220.0
2010-02-24 10:00:00	AMZN	Stock	5.9195	5.9345	5.8575	5.92	32070260.0
2010-02-24 11:00:00	AMZN	Stock	5.92	5.93	5.905	5.923	13756780.0
2010-02-24 12:00:00	AMZN	Stock	5.9235	5.935	5.912	5.9295	10490120.0
2010-02-24 13:00:00	AMZN	Stock	5.9295	5.975	5.9265	5.9645	23508200.0
2010-02-24 14:00:00	AMZN	Stock	5.965	5.9665	5.9325	5.9505	17008240.0
2010-02-24 15:00:00	AMZN	Stock	5.9505	5.99	5.9375	5.9845	33252600.0
2010-02-24 16:00:00	AMZN	Stock	5.9875	5.9875	5.9324	5.968	2107680.0
2010-02-24 17:00:00	AMZN	Stock	5.92	5.979	5.92	5.9785	106400.0

> showing 50 of 42,238 rows — these rows as CSV

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