PREVIEW / stock_1hour / 2009-11-02

all stock 1-hour files

  file:    by_date/stock_1hour/2009/2009-11-02.parquet
  size:    904 KB
  rows:    43,269
  symbols: 3,411

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-11-02 04:00:00	AAPL	Stock	6.7707	6.7707	6.7679	6.7679	30408.0
2009-11-02 05:00:00	AAPL	Stock	6.75	6.7643	6.75	6.7643	5600.0
2009-11-02 06:00:00	AAPL	Stock	6.7821	6.7821	6.7821	6.7821	24360.0
2009-11-02 07:00:00	AAPL	Stock	6.7625	6.7857	6.7607	6.7607	341320.0
2009-11-02 08:00:00	AAPL	Stock	6.7714	6.7968	6.7321	6.7857	2378096.0
2009-11-02 09:00:00	AAPL	Stock	6.7845	6.8079	6.6275	6.7404	141192800.0
2009-11-02 10:00:00	AAPL	Stock	6.7404	6.8886	6.7361	6.8125	168991116.0
2009-11-02 11:00:00	AAPL	Stock	6.8137	6.8479	6.7979	6.8232	60443068.0
2009-11-02 12:00:00	AAPL	Stock	6.8246	6.8279	6.6864	6.6875	70438984.0
2009-11-02 13:00:00	AAPL	Stock	6.6875	6.7643	6.6821	6.7061	75758620.0
2009-11-02 14:00:00	AAPL	Stock	6.7041	6.7821	6.685	6.763	76072276.0
2009-11-02 15:00:00	AAPL	Stock	6.7625	6.7786	6.7257	6.7604	69918604.0
2009-11-02 16:00:00	AAPL	Stock	6.7604	6.7732	6.7366	6.7625	6730472.0
2009-11-02 17:00:00	AAPL	Stock	6.7661	6.7711	6.7439	6.7675	541632.0
2009-11-02 18:00:00	AAPL	Stock	6.7611	6.765	6.7589	6.7607	674184.0
2009-11-02 19:00:00	AAPL	Stock	6.7607	6.775	6.7607	6.775	430836.0
2009-11-02 04:00:00	MSFT	Stock	27.68	27.68	27.65	27.65	1000.0
2009-11-02 07:00:00	MSFT	Stock	27.71	27.78	27.71	27.78	1400.0
2009-11-02 08:00:00	MSFT	Stock	27.78	27.89	27.78	27.83	17703.0
2009-11-02 09:00:00	MSFT	Stock	27.82	27.88	27.41	27.82	7727865.0
2009-11-02 10:00:00	MSFT	Stock	27.83	28.0	27.71	27.87	11111027.0
2009-11-02 11:00:00	MSFT	Stock	27.86	28.05	27.8	28.0	5976540.0
2009-11-02 12:00:00	MSFT	Stock	28.0	28.01	27.6	27.62	5864745.0
2009-11-02 13:00:00	MSFT	Stock	27.61	27.87	27.59	27.74	7862867.0
2009-11-02 14:00:00	MSFT	Stock	27.74	28.0	27.66	27.95	6489892.0
2009-11-02 15:00:00	MSFT	Stock	27.952	28.01	27.8	27.87	11524871.0
2009-11-02 16:00:00	MSFT	Stock	27.87	27.98	27.814	27.87	4942650.0
2009-11-02 17:00:00	MSFT	Stock	27.87	27.87	27.86	27.87	1165.0
2009-11-02 18:00:00	MSFT	Stock	27.88	27.89	27.86	27.89	60965.0
2009-11-02 19:00:00	MSFT	Stock	27.86	27.89	27.85	27.85	2300.0
2009-11-02 08:00:00	NVDA	Stock	0.2982	0.3015	0.2982	0.3015	106680.0
2009-11-02 09:00:00	NVDA	Stock	0.2988	0.3018	0.2932	0.3008	75263880.0
2009-11-02 10:00:00	NVDA	Stock	0.3008	0.3083	0.3008	0.3045	150661920.0
2009-11-02 11:00:00	NVDA	Stock	0.3048	0.3073	0.3038	0.3058	45120080.0
2009-11-02 12:00:00	NVDA	Stock	0.306	0.3073	0.2998	0.3005	77027440.0
2009-11-02 13:00:00	NVDA	Stock	0.3002	0.3032	0.2988	0.2995	69015080.0
2009-11-02 14:00:00	NVDA	Stock	0.2992	0.3012	0.2975	0.3005	57622880.0
2009-11-02 15:00:00	NVDA	Stock	0.3005	0.302	0.298	0.3015	107560240.0
2009-11-02 16:00:00	NVDA	Stock	0.3018	0.302	0.3005	0.3018	1028880.0
2009-11-02 18:00:00	NVDA	Stock	0.3025	0.3025	0.3025	0.3025	7000.0
2009-11-02 06:00:00	AMZN	Stock	5.975	5.975	5.975	5.975	4000.0
2009-11-02 07:00:00	AMZN	Stock	5.9625	5.9625	5.9515	5.9515	8000.0
2009-11-02 08:00:00	AMZN	Stock	5.9405	5.9915	5.9405	5.965	267600.0
2009-11-02 09:00:00	AMZN	Stock	5.965	5.975	5.8355	5.869	40667560.0
2009-11-02 10:00:00	AMZN	Stock	5.8715	5.975	5.867	5.9331	56334460.0
2009-11-02 11:00:00	AMZN	Stock	5.9325	5.9745	5.915	5.963	23283840.0
2009-11-02 12:00:00	AMZN	Stock	5.963	5.967	5.8505	5.86	25602020.0
2009-11-02 13:00:00	AMZN	Stock	5.86	5.9125	5.84	5.8455	18656620.0
2009-11-02 14:00:00	AMZN	Stock	5.85	5.964	5.8405	5.913	24716260.0
2009-11-02 15:00:00	AMZN	Stock	5.9145	5.9495	5.894	5.9435	28563020.0

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

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