PREVIEW / stock_1hour / 2010-06-10

all stock 1-hour files

  file:    by_date/stock_1hour/2010/2010-06-10.parquet
  size:    891 KB
  rows:    42,807
  symbols: 3,460

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-06-10 04:00:00	AAPL	Stock	8.7746	8.7746	8.7746	8.7746	2800.0
2010-06-10 05:00:00	AAPL	Stock	8.8114	8.8114	8.7911	8.8018	33600.0
2010-06-10 06:00:00	AAPL	Stock	8.7857	8.7857	8.7857	8.7857	42000.0
2010-06-10 07:00:00	AAPL	Stock	8.7857	8.7929	8.6929	8.7179	930440.0
2010-06-10 08:00:00	AAPL	Stock	8.7143	8.7655	8.7036	8.7221	4463872.0
2010-06-10 09:00:00	AAPL	Stock	8.7189	8.7857	8.65	8.7546	130619748.0
2010-06-10 10:00:00	AAPL	Stock	8.7539	8.85	8.75	8.8246	152996900.0
2010-06-10 11:00:00	AAPL	Stock	8.8229	8.8511	8.7789	8.8075	79788492.0
2010-06-10 12:00:00	AAPL	Stock	8.808	8.8232	8.7429	8.7839	73357564.0
2010-06-10 13:00:00	AAPL	Stock	8.7854	8.8386	8.7632	8.8236	61640236.0
2010-06-10 14:00:00	AAPL	Stock	8.8229	8.9236	8.7961	8.9111	95969104.0
2010-06-10 15:00:00	AAPL	Stock	8.9111	8.9636	8.895	8.955	148087688.0
2010-06-10 16:00:00	AAPL	Stock	8.955	8.9643	8.9332	8.9625	19802804.0
2010-06-10 17:00:00	AAPL	Stock	8.9625	8.9632	8.9486	8.9557	523236.0
2010-06-10 18:00:00	AAPL	Stock	8.9557	8.9589	8.9468	8.9571	267596.0
2010-06-10 19:00:00	AAPL	Stock	8.96	8.9643	8.9523	8.9618	761096.0
2010-06-10 07:00:00	MSFT	Stock	25.22	25.22	25.0	25.0	500.0
2010-06-10 08:00:00	MSFT	Stock	24.98	25.02	24.95	25.0	486557.0
2010-06-10 09:00:00	MSFT	Stock	25.01	25.15	24.97	25.065	7832933.0
2010-06-10 10:00:00	MSFT	Stock	25.068	25.13	25.02	25.035	9807805.0
2010-06-10 11:00:00	MSFT	Stock	25.04	25.045	24.91	25.01	7058894.0
2010-06-10 12:00:00	MSFT	Stock	25.01	25.08	24.82	24.855	7519763.0
2010-06-10 13:00:00	MSFT	Stock	24.86	24.96	24.78	24.93	5627204.0
2010-06-10 14:00:00	MSFT	Stock	24.94	25.05	24.85	25.032	6403267.0
2010-06-10 15:00:00	MSFT	Stock	25.04	25.1	24.89	25.0	27892795.0
2010-06-10 16:00:00	MSFT	Stock	25.0	25.045	24.825	24.92	4607327.0
2010-06-10 17:00:00	MSFT	Stock	24.95	25.0	24.88	25.0	124004.0
2010-06-10 18:00:00	MSFT	Stock	25.01	25.02	25.0	25.0	563136.0
2010-06-10 19:00:00	MSFT	Stock	25.01	25.02	25.0	25.02	74576.0
2010-06-10 20:00:00	MSFT	Stock	25.02	25.02	25.02	25.02	1900.0
2010-06-10 08:00:00	NVDA	Stock	0.2775	0.2775	0.2752	0.2752	92000.0
2010-06-10 09:00:00	NVDA	Stock	0.2775	0.285	0.2775	0.2828	98032920.0
2010-06-10 10:00:00	NVDA	Stock	0.2828	0.2842	0.2812	0.2836	73706320.0
2010-06-10 11:00:00	NVDA	Stock	0.2838	0.2845	0.2815	0.2828	58740160.0
2010-06-10 12:00:00	NVDA	Stock	0.2828	0.2828	0.2783	0.2792	53877640.0
2010-06-10 13:00:00	NVDA	Stock	0.2792	0.2812	0.2778	0.2801	65653880.0
2010-06-10 14:00:00	NVDA	Stock	0.2802	0.2815	0.2792	0.2808	86827520.0
2010-06-10 15:00:00	NVDA	Stock	0.2809	0.2842	0.2808	0.2839	154674560.0
2010-06-10 16:00:00	NVDA	Stock	0.284	0.2842	0.2724	0.2825	4482480.0
2010-06-10 17:00:00	NVDA	Stock	0.2841	0.2841	0.2841	0.2841	100680.0
2010-06-10 18:00:00	NVDA	Stock	0.2845	0.2845	0.2845	0.2845	32000.0
2010-06-10 19:00:00	NVDA	Stock	0.2845	0.285	0.2838	0.2838	136600.0
2010-06-10 08:00:00	AMZN	Stock	5.9275	5.9675	5.9275	5.96	118420.0
2010-06-10 09:00:00	AMZN	Stock	5.96	6.0975	5.95	6.085	16953820.0
2010-06-10 10:00:00	AMZN	Stock	6.0845	6.116	6.038	6.0935	21064980.0
2010-06-10 11:00:00	AMZN	Stock	6.092	6.15	6.071	6.099	15246060.0
2010-06-10 12:00:00	AMZN	Stock	6.1	6.124	6.0555	6.09	9710180.0
2010-06-10 13:00:00	AMZN	Stock	6.0885	6.1465	6.0695	6.1307	10406940.0
2010-06-10 14:00:00	AMZN	Stock	6.1305	6.161	6.093	6.13	13239100.0
2010-06-10 15:00:00	AMZN	Stock	6.13	6.175	6.123	6.1605	26019100.0

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

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