PREVIEW / stock_1hour / 2011-02-01

all stock 1-hour files

  file:    by_date/stock_1hour/2011/2011-02-01.parquet
  size:    976 KB
  rows:    46,850
  symbols: 3,524

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
2011-02-01 04:00:00	AAPL	Stock	12.1332	12.1696	12.1332	12.1404	36400.0
2011-02-01 05:00:00	AAPL	Stock	12.1554	12.1554	12.1529	12.1529	5600.0
2011-02-01 06:00:00	AAPL	Stock	12.16	12.1696	12.1393	12.1696	21700.0
2011-02-01 07:00:00	AAPL	Stock	12.1696	12.1775	12.1554	12.1625	283472.0
2011-02-01 08:00:00	AAPL	Stock	12.1582	12.1943	12.1186	12.175	1847132.0
2011-02-01 09:00:00	AAPL	Stock	12.1768	12.2496	12.1186	12.2296	55059424.0
2011-02-01 10:00:00	AAPL	Stock	12.2277	12.3036	12.2	12.2975	80269980.0
2011-02-01 11:00:00	AAPL	Stock	12.2979	12.3168	12.275	12.29	50227380.0
2011-02-01 12:00:00	AAPL	Stock	12.29	12.33	12.29	12.3282	61558140.0
2011-02-01 13:00:00	AAPL	Stock	12.3271	12.3304	12.3086	12.3104	34952288.0
2011-02-01 14:00:00	AAPL	Stock	12.31	12.3393	12.3093	12.3325	46518724.0
2011-02-01 15:00:00	AAPL	Stock	12.3329	12.3446	12.3143	12.3254	68261592.0
2011-02-01 16:00:00	AAPL	Stock	12.3225	12.3354	12.2944	12.3043	23594564.0
2011-02-01 17:00:00	AAPL	Stock	12.3104	12.3225	12.3086	12.3225	869372.0
2011-02-01 18:00:00	AAPL	Stock	12.3175	12.3225	12.3111	12.3161	194768.0
2011-02-01 19:00:00	AAPL	Stock	12.3161	12.3214	12.3143	12.3214	338884.0
2011-02-01 04:00:00	MSFT	Stock	27.72	27.72	27.65	27.65	2000.0
2011-02-01 05:00:00	MSFT	Stock	27.8	27.8	27.8	27.8	200.0
2011-02-01 06:00:00	MSFT	Stock	27.89	27.9	27.77	27.88	600.0
2011-02-01 07:00:00	MSFT	Stock	27.88	27.88	27.82	27.85	4550.0
2011-02-01 08:00:00	MSFT	Stock	27.87	27.87	27.725	27.8	78099.0
2011-02-01 09:00:00	MSFT	Stock	27.8	27.83	27.61	27.66	6836492.0
2011-02-01 10:00:00	MSFT	Stock	27.65	27.8	27.64	27.8	10323356.0
2011-02-01 11:00:00	MSFT	Stock	27.8	27.85	27.75	27.801	7603376.0
2011-02-01 12:00:00	MSFT	Stock	27.8	28.02	27.77	28.0	9413391.0
2011-02-01 13:00:00	MSFT	Stock	28.0	28.02	27.86	27.96	5860819.0
2011-02-01 14:00:00	MSFT	Stock	27.96	27.98	27.9	27.97	5998576.0
2011-02-01 15:00:00	MSFT	Stock	27.97	28.06	27.91	28.01	12507876.0
2011-02-01 16:00:00	MSFT	Stock	28.01	28.02	27.871	27.98	2240900.0
2011-02-01 17:00:00	MSFT	Stock	28.0	28.01	27.98	28.01	35627.0
2011-02-01 18:00:00	MSFT	Stock	28.01	28.01	27.99	28.0	71619.0
2011-02-01 19:00:00	MSFT	Stock	28.0	28.01	28.0	28.01	3726.0
2011-02-01 08:00:00	NVDA	Stock	0.5975	0.6038	0.5975	0.6038	470120.0
2011-02-01 09:00:00	NVDA	Stock	0.6025	0.6113	0.598	0.6085	91038600.0
2011-02-01 10:00:00	NVDA	Stock	0.6085	0.6113	0.606	0.6103	108432680.0
2011-02-01 11:00:00	NVDA	Stock	0.61	0.6101	0.6045	0.6068	77863040.0
2011-02-01 12:00:00	NVDA	Stock	0.607	0.614	0.6069	0.614	113514680.0
2011-02-01 13:00:00	NVDA	Stock	0.6139	0.6148	0.6125	0.6141	56741600.0
2011-02-01 14:00:00	NVDA	Stock	0.614	0.6162	0.6105	0.6127	78097120.0
2011-02-01 15:00:00	NVDA	Stock	0.6128	0.615	0.61	0.6115	109931840.0
2011-02-01 16:00:00	NVDA	Stock	0.6115	0.6135	0.61	0.61	5315640.0
2011-02-01 17:00:00	NVDA	Stock	0.61	0.615	0.6085	0.6118	396880.0
2011-02-01 18:00:00	NVDA	Stock	0.6118	0.6118	0.6105	0.6105	525840.0
2011-02-01 19:00:00	NVDA	Stock	0.6105	0.6133	0.6105	0.612	34000.0
2011-02-01 07:00:00	AMZN	Stock	8.4885	8.5375	8.4885	8.5375	4000.0
2011-02-01 08:00:00	AMZN	Stock	8.52	8.5385	8.482	8.5	76920.0
2011-02-01 09:00:00	AMZN	Stock	8.5	8.565	8.4755	8.5322	18309220.0
2011-02-01 10:00:00	AMZN	Stock	8.5325	8.6155	8.4925	8.6045	20714860.0
2011-02-01 11:00:00	AMZN	Stock	8.607	8.625	8.5755	8.6005	11016740.0
2011-02-01 12:00:00	AMZN	Stock	8.603	8.655	8.601	8.6355	9539100.0

> showing 50 of 46,850 rows — these rows as CSV

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