PREVIEW / stock_1hour / 2009-09-02

all stock 1-hour files

  file:    by_date/stock_1hour/2009/2009-09-02.parquet
  size:    862 KB
  rows:    42,475
  symbols: 3,359

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
2009-09-02 04:00:00	AAPL	Stock	5.8393	5.8393	5.8214	5.8214	28000.0
2009-09-02 05:00:00	AAPL	Stock	5.8482	5.8482	5.8482	5.8482	2800.0
2009-09-02 06:00:00	AAPL	Stock	5.8682	5.8754	5.8675	5.875	47544.0
2009-09-02 07:00:00	AAPL	Stock	5.8757	5.8911	5.8757	5.8911	85400.0
2009-09-02 08:00:00	AAPL	Stock	5.8929	5.9	5.8839	5.8954	647444.0
2009-09-02 09:00:00	AAPL	Stock	5.8964	5.9782	5.8611	5.9318	81826080.0
2009-09-02 10:00:00	AAPL	Stock	5.9318	5.9861	5.9011	5.9704	88525752.0
2009-09-02 11:00:00	AAPL	Stock	5.9707	5.9739	5.9379	5.9407	38186372.0
2009-09-02 12:00:00	AAPL	Stock	5.9404	5.9618	5.9289	5.9464	28937356.0
2009-09-02 13:00:00	AAPL	Stock	5.9464	5.9482	5.9144	5.9171	24375960.0
2009-09-02 14:00:00	AAPL	Stock	5.9171	5.9325	5.9111	5.925	33516896.0
2009-09-02 15:00:00	AAPL	Stock	5.925	5.9396	5.8939	5.8982	52152436.0
2009-09-02 16:00:00	AAPL	Stock	5.8989	5.9363	5.885	5.9064	5547360.0
2009-09-02 17:00:00	AAPL	Stock	5.9064	5.9089	5.9043	5.9089	39984.0
2009-09-02 18:00:00	AAPL	Stock	5.9086	5.9089	5.8979	5.9054	316820.0
2009-09-02 19:00:00	AAPL	Stock	5.9036	5.9089	5.9032	5.9089	105448.0
2009-09-02 07:00:00	MSFT	Stock	23.86	23.86	23.86	23.86	200.0
2009-09-02 08:00:00	MSFT	Stock	23.96	24.0	23.88	23.88	10132.0
2009-09-02 09:00:00	MSFT	Stock	24.0	24.04	23.78	23.99	7969688.0
2009-09-02 10:00:00	MSFT	Stock	23.99	24.13	23.9	24.11	7423117.0
2009-09-02 11:00:00	MSFT	Stock	24.11	24.14	23.96	23.998	4146194.0
2009-09-02 12:00:00	MSFT	Stock	23.993	24.04	23.95	23.977	4016904.0
2009-09-02 13:00:00	MSFT	Stock	23.97	24.0	23.94	23.97	3255025.0
2009-09-02 14:00:00	MSFT	Stock	23.961	24.01	23.95	23.961	3126060.0
2009-09-02 15:00:00	MSFT	Stock	23.961	24.03	23.86	23.86	8353582.0
2009-09-02 16:00:00	MSFT	Stock	23.86	24.093	23.76	23.86	1920907.0
2009-09-02 17:00:00	MSFT	Stock	23.86	23.86	23.86	23.86	1000.0
2009-09-02 18:00:00	MSFT	Stock	23.86	23.88	23.86	23.88	3087.0
2009-09-02 19:00:00	MSFT	Stock	23.86	23.89	23.86	23.88	2700.0
2009-09-02 20:00:00	MSFT	Stock	23.98	23.98	23.98	23.98	39425.0
2009-09-02 08:00:00	NVDA	Stock	0.3522	0.3522	0.3508	0.3522	415120.0
2009-09-02 09:00:00	NVDA	Stock	0.3508	0.3592	0.3493	0.355	73370120.0
2009-09-02 10:00:00	NVDA	Stock	0.3548	0.3582	0.353	0.3575	80007840.0
2009-09-02 11:00:00	NVDA	Stock	0.3572	0.3582	0.3553	0.3558	52198080.0
2009-09-02 12:00:00	NVDA	Stock	0.356	0.3575	0.354	0.3572	40330680.0
2009-09-02 13:00:00	NVDA	Stock	0.3572	0.3575	0.356	0.3565	28635760.0
2009-09-02 14:00:00	NVDA	Stock	0.3565	0.3575	0.3555	0.356	31709440.0
2009-09-02 15:00:00	NVDA	Stock	0.3558	0.3572	0.3548	0.3558	77295120.0
2009-09-02 16:00:00	NVDA	Stock	0.3553	0.3559	0.3541	0.3558	6617040.0
2009-09-02 17:00:00	NVDA	Stock	0.3508	0.3562	0.3508	0.3558	31520.0
2009-09-02 18:00:00	NVDA	Stock	0.3548	0.355	0.3538	0.3538	33200.0
2009-09-02 19:00:00	NVDA	Stock	0.3542	0.3542	0.3542	0.3542	29600.0
2009-09-02 07:00:00	AMZN	Stock	3.99	3.99	3.975	3.975	12000.0
2009-09-02 08:00:00	AMZN	Stock	3.9545	3.9745	3.9545	3.958	53980.0
2009-09-02 09:00:00	AMZN	Stock	3.958	4.0075	3.9425	3.961	16934780.0
2009-09-02 10:00:00	AMZN	Stock	3.9595	3.9814	3.9305	3.966	21925700.0
2009-09-02 11:00:00	AMZN	Stock	3.9669	3.9725	3.933	3.934	13212440.0
2009-09-02 12:00:00	AMZN	Stock	3.934	3.9395	3.897	3.9	21043000.0
2009-09-02 13:00:00	AMZN	Stock	3.9004	3.9095	3.89	3.898	19519580.0
2009-09-02 14:00:00	AMZN	Stock	3.8989	3.9145	3.8945	3.903	11731580.0

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

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