PREVIEW / stock_1hour / 2010-02-10

all stock 1-hour files

  file:    by_date/stock_1hour/2010/2010-02-10.parquet
  size:    861 KB
  rows:    41,303
  symbols: 3,408

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-10 05:00:00	AAPL	Stock	7.0161	7.0339	7.0161	7.0339	21588.0
2010-02-10 06:00:00	AAPL	Stock	7.0393	7.0393	7.0393	7.0393	28000.0
2010-02-10 07:00:00	AAPL	Stock	7.02	7.0514	7.0179	7.0339	196616.0
2010-02-10 08:00:00	AAPL	Stock	7.0271	7.0271	6.9968	7.0118	1442168.0
2010-02-10 09:00:00	AAPL	Stock	7.0079	7.0214	6.9718	6.9936	50765736.0
2010-02-10 10:00:00	AAPL	Stock	6.9936	6.9971	6.9379	6.9589	80598784.0
2010-02-10 11:00:00	AAPL	Stock	6.96	6.9818	6.9507	6.9679	43659896.0
2010-02-10 12:00:00	AAPL	Stock	6.9686	7.0011	6.9561	6.9964	41267016.0
2010-02-10 13:00:00	AAPL	Stock	6.9954	7.0189	6.9882	6.9936	39592084.0
2010-02-10 14:00:00	AAPL	Stock	6.9946	7.0068	6.9711	6.9821	35051912.0
2010-02-10 15:00:00	AAPL	Stock	6.9814	7.0014	6.9582	6.9732	60128768.0
2010-02-10 16:00:00	AAPL	Stock	6.9741	6.9993	6.9671	6.97	9964080.0
2010-02-10 17:00:00	AAPL	Stock	6.9714	6.9721	6.97	6.9707	81760.0
2010-02-10 18:00:00	AAPL	Stock	6.9732	6.9732	6.9661	6.9714	174020.0
2010-02-10 19:00:00	AAPL	Stock	6.9679	6.9839	6.9679	6.9839	647500.0
2010-02-10 20:00:00	AAPL	Stock	7.0068	7.0068	7.0068	7.0068	238000.0
2010-02-10 07:00:00	MSFT	Stock	28.15	28.15	28.06	28.06	800.0
2010-02-10 08:00:00	MSFT	Stock	28.06	28.11	27.95	27.98	10565.0
2010-02-10 09:00:00	MSFT	Stock	28.03	28.24	27.9	28.19	6067392.0
2010-02-10 10:00:00	MSFT	Stock	28.19	28.2	27.95	28.03	11090228.0
2010-02-10 11:00:00	MSFT	Stock	28.03	28.05	27.87	27.9	6528828.0
2010-02-10 12:00:00	MSFT	Stock	27.9	28.14	27.84	28.07	5455035.0
2010-02-10 13:00:00	MSFT	Stock	28.06	28.12	28.03	28.08	4257179.0
2010-02-10 14:00:00	MSFT	Stock	28.09	28.12	27.97	28.02	3381318.0
2010-02-10 15:00:00	MSFT	Stock	28.02	28.04	27.9	27.99	9363292.0
2010-02-10 16:00:00	MSFT	Stock	28.0	28.07	27.94	28.01	1348151.0
2010-02-10 17:00:00	MSFT	Stock	27.95	28.0	27.95	28.0	600.0
2010-02-10 18:00:00	MSFT	Stock	28.0	28.03	28.0	28.03	1100.0
2010-02-10 19:00:00	MSFT	Stock	28.03	28.08	28.02	28.05	5152.0
2010-02-10 20:00:00	MSFT	Stock	28.01	28.01	28.01	28.01	635050.0
2010-02-10 09:00:00	NVDA	Stock	0.4032	0.411	0.4032	0.4099	67312280.0
2010-02-10 10:00:00	NVDA	Stock	0.41	0.4102	0.4015	0.4035	124894000.0
2010-02-10 11:00:00	NVDA	Stock	0.4038	0.4062	0.4013	0.4048	67724160.0
2010-02-10 12:00:00	NVDA	Stock	0.4048	0.4102	0.404	0.4093	48444360.0
2010-02-10 13:00:00	NVDA	Stock	0.4093	0.413	0.409	0.4112	61945800.0
2010-02-10 14:00:00	NVDA	Stock	0.4112	0.4122	0.4095	0.4102	43611280.0
2010-02-10 15:00:00	NVDA	Stock	0.4105	0.412	0.4093	0.4093	98881760.0
2010-02-10 16:00:00	NVDA	Stock	0.4095	0.4098	0.4079	0.4093	17273360.0
2010-02-10 17:00:00	NVDA	Stock	0.4093	0.4093	0.4093	0.4093	78000.0
2010-02-10 08:00:00	AMZN	Stock	5.9055	5.9055	5.867	5.8725	145300.0
2010-02-10 09:00:00	AMZN	Stock	5.8825	5.9305	5.869	5.885	18403760.0
2010-02-10 10:00:00	AMZN	Stock	5.8865	5.8875	5.8	5.8325	34653700.0
2010-02-10 11:00:00	AMZN	Stock	5.8345	5.8708	5.8107	5.861	15396780.0
2010-02-10 12:00:00	AMZN	Stock	5.8615	5.911	5.847	5.883	16804100.0
2010-02-10 13:00:00	AMZN	Stock	5.8835	5.9035	5.8575	5.8675	11902500.0
2010-02-10 14:00:00	AMZN	Stock	5.8665	5.88	5.8555	5.8662	7761500.0
2010-02-10 15:00:00	AMZN	Stock	5.866	5.8905	5.855	5.8685	16481460.0
2010-02-10 16:00:00	AMZN	Stock	5.868	5.8889	5.8648	5.876	2272520.0
2010-02-10 17:00:00	AMZN	Stock	5.8765	5.8765	5.868	5.8685	47160.0
2010-02-10 18:00:00	AMZN	Stock	5.8685	5.8745	5.8685	5.8745	27000.0

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

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