PREVIEW / stock_1hour / 2010-04-14

all stock 1-hour files

  file:    by_date/stock_1hour/2010/2010-04-14.parquet
  size:    936 KB
  rows:    44,207
  symbols: 3,486

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-04-14 04:00:00	AAPL	Stock	8.7054	8.7186	8.7054	8.7186	25200.0
2010-04-14 05:00:00	AAPL	Stock	8.7143	8.7143	8.7061	8.7061	16800.0
2010-04-14 06:00:00	AAPL	Stock	8.7071	8.7125	8.7061	8.7104	42000.0
2010-04-14 07:00:00	AAPL	Stock	8.7107	8.7107	8.6857	8.6929	216328.0
2010-04-14 08:00:00	AAPL	Stock	8.6964	8.8014	8.6946	8.7814	19237540.0
2010-04-14 09:00:00	AAPL	Stock	8.7811	8.7854	8.7259	8.74	85312836.0
2010-04-14 10:00:00	AAPL	Stock	8.74	8.7768	8.7168	8.7557	102493832.0
2010-04-14 11:00:00	AAPL	Stock	8.7561	8.7745	8.7493	8.7636	47331284.0
2010-04-14 12:00:00	AAPL	Stock	8.7643	8.7664	8.7521	8.7654	24441228.0
2010-04-14 13:00:00	AAPL	Stock	8.7646	8.7679	8.75	8.7511	24292520.0
2010-04-14 14:00:00	AAPL	Stock	8.7511	8.7711	8.7439	8.7643	27383440.0
2010-04-14 15:00:00	AAPL	Stock	8.7646	8.7789	8.7589	8.7725	62085912.0
2010-04-14 16:00:00	AAPL	Stock	8.7704	8.775	8.7547	8.7748	7817236.0
2010-04-14 17:00:00	AAPL	Stock	8.7689	8.7821	8.7689	8.7786	630308.0
2010-04-14 18:00:00	AAPL	Stock	8.7768	8.7818	8.7746	8.7793	224896.0
2010-04-14 19:00:00	AAPL	Stock	8.7804	8.7821	8.7786	8.7821	283920.0
2010-04-14 07:00:00	MSFT	Stock	30.74	30.8	30.7	30.8	5400.0
2010-04-14 08:00:00	MSFT	Stock	30.8	30.92	30.76	30.89	94494.0
2010-04-14 09:00:00	MSFT	Stock	30.89	31.0	30.66	30.988	14589119.0
2010-04-14 10:00:00	MSFT	Stock	30.98	30.99	30.75	30.78	12105658.0
2010-04-14 11:00:00	MSFT	Stock	30.785	30.89	30.73	30.89	7592438.0
2010-04-14 12:00:00	MSFT	Stock	30.885	30.9	30.8	30.81	4802448.0
2010-04-14 13:00:00	MSFT	Stock	30.81	30.88	30.75	30.76	4728188.0
2010-04-14 14:00:00	MSFT	Stock	30.77	30.81	30.72	30.8	5023477.0
2010-04-14 15:00:00	MSFT	Stock	30.8	30.87	30.72	30.83	9052595.0
2010-04-14 16:00:00	MSFT	Stock	30.82	30.872	30.769	30.82	4949866.0
2010-04-14 17:00:00	MSFT	Stock	30.8	30.84	30.8	30.82	6508.0
2010-04-14 18:00:00	MSFT	Stock	30.81	30.86	30.81	30.86	27252.0
2010-04-14 19:00:00	MSFT	Stock	30.86	30.86	30.84	30.86	2917.0
2010-04-14 20:00:00	MSFT	Stock	30.8	30.8	30.8	30.8	977.0
2010-04-14 07:00:00	NVDA	Stock	0.4565	0.4605	0.4565	0.4605	35600.0
2010-04-14 08:00:00	NVDA	Stock	0.4575	0.458	0.455	0.455	465320.0
2010-04-14 09:00:00	NVDA	Stock	0.455	0.4555	0.4422	0.446	205247280.0
2010-04-14 10:00:00	NVDA	Stock	0.446	0.4465	0.44	0.4432	156075920.0
2010-04-14 11:00:00	NVDA	Stock	0.4432	0.4482	0.4432	0.4457	119466320.0
2010-04-14 12:00:00	NVDA	Stock	0.4456	0.448	0.4455	0.4462	50425280.0
2010-04-14 13:00:00	NVDA	Stock	0.4462	0.447	0.4448	0.4452	62290400.0
2010-04-14 14:00:00	NVDA	Stock	0.4452	0.4468	0.444	0.445	59836040.0
2010-04-14 15:00:00	NVDA	Stock	0.4448	0.4485	0.4425	0.4475	217900440.0
2010-04-14 16:00:00	NVDA	Stock	0.4475	0.4476	0.4458	0.4475	11997360.0
2010-04-14 18:00:00	NVDA	Stock	0.447	0.448	0.447	0.448	458240.0
2010-04-14 19:00:00	NVDA	Stock	0.4482	0.4482	0.4478	0.4478	66240.0
2010-04-14 08:00:00	AMZN	Stock	7.0495	7.095	7.0485	7.0725	312380.0
2010-04-14 09:00:00	AMZN	Stock	7.0695	7.1235	6.96	7.0932	26893500.0
2010-04-14 10:00:00	AMZN	Stock	7.0905	7.2115	7.0635	7.187	41805740.0
2010-04-14 11:00:00	AMZN	Stock	7.1895	7.2205	7.1825	7.1945	17237640.0
2010-04-14 12:00:00	AMZN	Stock	7.1935	7.216	7.171	7.201	12573380.0
2010-04-14 13:00:00	AMZN	Stock	7.2015	7.209	7.1725	7.1808	10729800.0
2010-04-14 14:00:00	AMZN	Stock	7.1805	7.2075	7.1805	7.2025	10892020.0
2010-04-14 15:00:00	AMZN	Stock	7.203	7.225	7.191	7.205	26942800.0

> showing 50 of 44,207 rows — these rows as CSV

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