PREVIEW / stock_1hour / 2010-02-23

all stock 1-hour files

  file:    by_date/stock_1hour/2010/2010-02-23.parquet
  size:    889 KB
  rows:    42,799
  symbols: 3,457

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-23 04:00:00	AAPL	Stock	7.1764	7.1764	7.1764	7.1764	2800.0
2010-02-23 05:00:00	AAPL	Stock	7.1621	7.1621	7.1611	7.1611	5740.0
2010-02-23 06:00:00	AAPL	Stock	7.1411	7.1411	7.1254	7.1254	9632.0
2010-02-23 07:00:00	AAPL	Stock	7.125	7.1336	7.125	7.1304	39620.0
2010-02-23 08:00:00	AAPL	Stock	7.1304	7.15	7.1268	7.1336	862260.0
2010-02-23 09:00:00	AAPL	Stock	7.1332	7.1904	7.0957	7.1814	65143848.0
2010-02-23 10:00:00	AAPL	Stock	7.1707	7.1836	7.06	7.0879	116456704.0
2010-02-23 11:00:00	AAPL	Stock	7.0864	7.0925	7.0471	7.0589	48825056.0
2010-02-23 12:00:00	AAPL	Stock	7.0593	7.0625	6.9896	7.0272	85007888.0
2010-02-23 13:00:00	AAPL	Stock	7.0271	7.0421	7.0136	7.0279	43799056.0
2010-02-23 14:00:00	AAPL	Stock	7.0289	7.0557	7.0189	7.0457	46972212.0
2010-02-23 15:00:00	AAPL	Stock	7.0457	7.0579	7.03	7.035	63190148.0
2010-02-23 16:00:00	AAPL	Stock	7.035	7.0861	7.0343	7.0536	13985384.0
2010-02-23 17:00:00	AAPL	Stock	7.0514	7.0518	7.0454	7.05	165256.0
2010-02-23 18:00:00	AAPL	Stock	7.05	7.05	7.0379	7.0464	156464.0
2010-02-23 19:00:00	AAPL	Stock	7.0454	7.05	7.0454	7.0493	104076.0
2010-02-23 07:00:00	MSFT	Stock	28.75	28.75	28.75	28.75	500.0
2010-02-23 08:00:00	MSFT	Stock	28.69	28.69	28.64	28.64	4945.0
2010-02-23 09:00:00	MSFT	Stock	28.64	28.83	28.56	28.6	6032801.0
2010-02-23 10:00:00	MSFT	Stock	28.6	28.61	28.12	28.165	14081329.0
2010-02-23 11:00:00	MSFT	Stock	28.165	28.26	28.15	28.2	5557241.0
2010-02-23 12:00:00	MSFT	Stock	28.2	28.24	28.09	28.24	4396321.0
2010-02-23 13:00:00	MSFT	Stock	28.24	28.305	28.19	28.25	6431507.0
2010-02-23 14:00:00	MSFT	Stock	28.25	28.45	28.18	28.41	5006369.0
2010-02-23 15:00:00	MSFT	Stock	28.41	28.46	28.29	28.34	6376324.0
2010-02-23 16:00:00	MSFT	Stock	28.33	28.42	28.28	28.4	3027862.0
2010-02-23 17:00:00	MSFT	Stock	28.4	28.43	28.4	28.4	14968.0
2010-02-23 18:00:00	MSFT	Stock	28.42	28.47	28.42	28.47	3000.0
2010-02-23 19:00:00	MSFT	Stock	28.38	28.38	28.38	28.38	200.0
2010-02-23 20:00:00	MSFT	Stock	28.21	28.21	28.21	28.21	3700.0
2010-02-23 08:00:00	NVDA	Stock	0.4152	0.4152	0.413	0.4138	40000.0
2010-02-23 09:00:00	NVDA	Stock	0.4162	0.4182	0.4118	0.413	59929920.0
2010-02-23 10:00:00	NVDA	Stock	0.4125	0.4138	0.4038	0.408	99193040.0
2010-02-23 11:00:00	NVDA	Stock	0.4078	0.408	0.4038	0.404	61938560.0
2010-02-23 12:00:00	NVDA	Stock	0.404	0.404	0.401	0.4018	42250760.0
2010-02-23 13:00:00	NVDA	Stock	0.4018	0.403	0.4013	0.4022	44401080.0
2010-02-23 14:00:00	NVDA	Stock	0.402	0.4055	0.4018	0.405	67087600.0
2010-02-23 15:00:00	NVDA	Stock	0.405	0.4078	0.405	0.4055	103152760.0
2010-02-23 16:00:00	NVDA	Stock	0.4055	0.407	0.4052	0.4053	9308720.0
2010-02-23 17:00:00	NVDA	Stock	0.4053	0.4053	0.4053	0.4053	39600.0
2010-02-23 18:00:00	NVDA	Stock	0.4053	0.4062	0.4053	0.4062	2231160.0
2010-02-23 08:00:00	AMZN	Stock	5.895	5.905	5.895	5.9025	82000.0
2010-02-23 09:00:00	AMZN	Stock	5.91	5.9625	5.8925	5.945	19932360.0
2010-02-23 10:00:00	AMZN	Stock	5.945	5.9465	5.8575	5.888	35256980.0
2010-02-23 11:00:00	AMZN	Stock	5.8855	5.936	5.873	5.8775	25120940.0
2010-02-23 12:00:00	AMZN	Stock	5.878	5.8855	5.8255	5.845	15900360.0
2010-02-23 13:00:00	AMZN	Stock	5.845	5.8645	5.834	5.8605	9538000.0
2010-02-23 14:00:00	AMZN	Stock	5.8616	5.886	5.8522	5.874	14342800.0
2010-02-23 15:00:00	AMZN	Stock	5.874	5.8855	5.861	5.862	18494000.0
2010-02-23 16:00:00	AMZN	Stock	5.865	5.8873	5.862	5.87	580100.0

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

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