PREVIEW / stock_1hour / 2010-04-16

all stock 1-hour files

  file:    by_date/stock_1hour/2010/2010-04-16.parquet
  size:    937 KB
  rows:    43,933
  symbols: 3,476

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-16 04:00:00	AAPL	Stock	8.8639	8.8639	8.8639	8.8639	25760.0
2010-04-16 05:00:00	AAPL	Stock	8.8639	8.8639	8.8639	8.8639	7084.0
2010-04-16 06:00:00	AAPL	Stock	8.8714	8.8714	8.8607	8.8607	8400.0
2010-04-16 07:00:00	AAPL	Stock	8.8607	8.875	8.8536	8.8571	188580.0
2010-04-16 08:00:00	AAPL	Stock	8.8611	8.8754	8.8536	8.8625	1633156.0
2010-04-16 09:00:00	AAPL	Stock	8.8607	8.9136	8.8414	8.905	98558292.0
2010-04-16 10:00:00	AAPL	Stock	8.9046	8.9693	8.8514	8.8861	167740524.0
2010-04-16 11:00:00	AAPL	Stock	8.8854	8.9121	8.7964	8.8344	115080560.0
2010-04-16 12:00:00	AAPL	Stock	8.8354	8.8354	8.7339	8.7925	99415092.0
2010-04-16 13:00:00	AAPL	Stock	8.7925	8.8332	8.7743	8.8039	51959404.0
2010-04-16 14:00:00	AAPL	Stock	8.8025	8.8725	8.7957	8.8121	66094028.0
2010-04-16 15:00:00	AAPL	Stock	8.8125	8.8496	8.7961	8.8371	84951720.0
2010-04-16 16:00:00	AAPL	Stock	8.8429	8.8605	8.8022	8.8411	16216732.0
2010-04-16 17:00:00	AAPL	Stock	8.8034	8.8429	8.8034	8.8357	579404.0
2010-04-16 18:00:00	AAPL	Stock	8.8311	8.8404	8.8307	8.8393	246988.0
2010-04-16 19:00:00	AAPL	Stock	8.8429	8.8429	8.8325	8.8354	154028.0
2010-04-16 08:00:00	MSFT	Stock	30.75	30.816	30.7	30.75	13186.0
2010-04-16 09:00:00	MSFT	Stock	30.74	30.89	30.7	30.88	10552054.0
2010-04-16 10:00:00	MSFT	Stock	30.88	30.98	30.85	30.94	17464810.0
2010-04-16 11:00:00	MSFT	Stock	30.94	30.98	30.79	30.86	13520208.0
2010-04-16 12:00:00	MSFT	Stock	30.86	30.9	30.69	30.732	10544691.0
2010-04-16 13:00:00	MSFT	Stock	30.73	30.79	30.64	30.68	7074622.0
2010-04-16 14:00:00	MSFT	Stock	30.69	30.72	30.6	30.65	8619571.0
2010-04-16 15:00:00	MSFT	Stock	30.64	30.78	30.61	30.67	12754749.0
2010-04-16 16:00:00	MSFT	Stock	30.68	30.89	30.664	30.67	7425149.0
2010-04-16 17:00:00	MSFT	Stock	30.66	30.7	30.66	30.67	4510.0
2010-04-16 18:00:00	MSFT	Stock	30.67	30.7	30.67	30.7	4611.0
2010-04-16 19:00:00	MSFT	Stock	30.65	30.7	30.65	30.7	300.0
2010-04-16 08:00:00	NVDA	Stock	0.4465	0.4465	0.435	0.4365	2321200.0
2010-04-16 09:00:00	NVDA	Stock	0.4365	0.4372	0.4253	0.4255	396924520.0
2010-04-16 10:00:00	NVDA	Stock	0.4258	0.4318	0.422	0.4245	358393200.0
2010-04-16 11:00:00	NVDA	Stock	0.4242	0.425	0.4175	0.421	310237400.0
2010-04-16 12:00:00	NVDA	Stock	0.421	0.426	0.417	0.4258	243885200.0
2010-04-16 13:00:00	NVDA	Stock	0.4258	0.4275	0.423	0.4264	115519600.0
2010-04-16 14:00:00	NVDA	Stock	0.4265	0.4328	0.4262	0.4308	124537200.0
2010-04-16 15:00:00	NVDA	Stock	0.4305	0.4325	0.4255	0.4262	340813200.0
2010-04-16 16:00:00	NVDA	Stock	0.4265	0.4279	0.42	0.4262	10290760.0
2010-04-16 17:00:00	NVDA	Stock	0.425	0.425	0.4248	0.4248	149200.0
2010-04-16 18:00:00	NVDA	Stock	0.4262	0.4268	0.4262	0.4268	52000.0
2010-04-16 19:00:00	NVDA	Stock	0.4268	0.4268	0.425	0.425	76400.0
2010-04-16 08:00:00	AMZN	Stock	7.2783	7.2783	7.2355	7.24	66460.0
2010-04-16 09:00:00	AMZN	Stock	7.2435	7.2845	7.2	7.2495	27515660.0
2010-04-16 10:00:00	AMZN	Stock	7.248	7.3585	7.2125	7.2695	39592000.0
2010-04-16 11:00:00	AMZN	Stock	7.268	7.276	7.151	7.1768	27382220.0
2010-04-16 12:00:00	AMZN	Stock	7.1755	7.208	7.108	7.1725	19664200.0
2010-04-16 13:00:00	AMZN	Stock	7.1745	7.1795	7.1185	7.145	12012860.0
2010-04-16 14:00:00	AMZN	Stock	7.1455	7.1945	7.1455	7.153	8614820.0
2010-04-16 15:00:00	AMZN	Stock	7.153	7.1571	7.0725	7.112	28017880.0
2010-04-16 16:00:00	AMZN	Stock	7.1115	7.2076	7.1005	7.1086	4658720.0
2010-04-16 17:00:00	AMZN	Stock	7.1637	7.1637	7.116	7.124	41220.0

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

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