PREVIEW / stock_1hour / 2011-10-05

all stock 1-hour files

  file:    by_date/stock_1hour/2011/2011-10-05.parquet
  size:    923 KB
  rows:    44,590
  symbols: 3,510

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
2011-10-05 04:00:00	AAPL	Stock	13.2411	13.2554	13.2321	13.2554	16800.0
2011-10-05 05:00:00	AAPL	Stock	13.2321	13.2321	13.1964	13.2143	30800.0
2011-10-05 06:00:00	AAPL	Stock	13.2143	13.2661	13.2143	13.2607	119840.0
2011-10-05 07:00:00	AAPL	Stock	13.2679	13.3371	13.1732	13.1804	667380.0
2011-10-05 08:00:00	AAPL	Stock	13.2143	13.2371	13.0457	13.0964	6501096.0
2011-10-05 09:00:00	AAPL	Stock	13.1011	13.1925	12.8679	12.9939	129736320.0
2011-10-05 10:00:00	AAPL	Stock	12.9912	13.3382	12.9343	13.3089	161558236.0
2011-10-05 11:00:00	AAPL	Stock	13.3089	13.35	13.1671	13.3141	94480204.0
2011-10-05 12:00:00	AAPL	Stock	13.3154	13.3382	13.1668	13.3236	76355888.0
2011-10-05 13:00:00	AAPL	Stock	13.3246	13.4929	13.3229	13.4804	94517360.0
2011-10-05 14:00:00	AAPL	Stock	13.4804	13.565	13.4404	13.5293	106697444.0
2011-10-05 15:00:00	AAPL	Stock	13.5318	13.5446	13.4725	13.5221	97876940.0
2011-10-05 16:00:00	AAPL	Stock	13.5214	13.5464	13.0134	13.5179	12865048.0
2011-10-05 17:00:00	AAPL	Stock	13.5164	13.5238	13.5093	13.5179	263620.0
2011-10-05 18:00:00	AAPL	Stock	13.5204	13.5268	13.5089	13.5146	385252.0
2011-10-05 19:00:00	AAPL	Stock	13.5146	13.5204	13.4721	13.4721	148232.0
2011-10-05 06:00:00	MSFT	Stock	25.42	25.42	25.4	25.4	400.0
2011-10-05 07:00:00	MSFT	Stock	25.42	25.42	25.32	25.35	700.0
2011-10-05 08:00:00	MSFT	Stock	25.39	25.5	25.3	25.31	51199.0
2011-10-05 09:00:00	MSFT	Stock	25.32	25.535	25.16	25.482	6857266.0
2011-10-05 10:00:00	MSFT	Stock	25.48	26.03	25.42	26.02	16438788.0
2011-10-05 11:00:00	MSFT	Stock	26.025	26.11	25.84	25.935	10853697.0
2011-10-05 12:00:00	MSFT	Stock	25.935	25.99	25.73	25.945	7596103.0
2011-10-05 13:00:00	MSFT	Stock	25.945	26.11	25.88	26.091	6740203.0
2011-10-05 14:00:00	MSFT	Stock	26.09	26.16	25.68	25.7	16666852.0
2011-10-05 15:00:00	MSFT	Stock	25.695	25.99	25.4	25.92	24062667.0
2011-10-05 16:00:00	MSFT	Stock	25.91	26.02	25.377	25.96	3338804.0
2011-10-05 17:00:00	MSFT	Stock	25.96	26.02	25.91	26.01	42349.0
2011-10-05 18:00:00	MSFT	Stock	25.96	26.02	25.89	25.92	64543.0
2011-10-05 19:00:00	MSFT	Stock	25.91	25.91	25.85	25.86	8585.0
2011-10-05 08:00:00	NVDA	Stock	0.3188	0.3243	0.3188	0.3188	169760.0
2011-10-05 09:00:00	NVDA	Stock	0.3188	0.322	0.3153	0.3195	69529920.0
2011-10-05 10:00:00	NVDA	Stock	0.3193	0.337	0.3183	0.3365	213285880.0
2011-10-05 11:00:00	NVDA	Stock	0.3362	0.3368	0.329	0.3303	133219560.0
2011-10-05 12:00:00	NVDA	Stock	0.3305	0.3315	0.3235	0.3263	86860880.0
2011-10-05 13:00:00	NVDA	Stock	0.3263	0.3325	0.3263	0.3321	64315240.0
2011-10-05 14:00:00	NVDA	Stock	0.3322	0.3333	0.3294	0.3325	81731760.0
2011-10-05 15:00:00	NVDA	Stock	0.3325	0.3355	0.3303	0.334	182525920.0
2011-10-05 16:00:00	NVDA	Stock	0.334	0.3345	0.3178	0.3338	20203360.0
2011-10-05 17:00:00	NVDA	Stock	0.3338	0.3353	0.3338	0.3353	728040.0
2011-10-05 18:00:00	NVDA	Stock	0.3345	0.3348	0.3338	0.3348	301600.0
2011-10-05 19:00:00	NVDA	Stock	0.3333	0.3333	0.332	0.332	172000.0
2011-10-05 04:00:00	AMZN	Stock	10.5895	10.5895	10.5895	10.5895	2000.0
2011-10-05 05:00:00	AMZN	Stock	10.579	10.579	10.579	10.579	2000.0
2011-10-05 06:00:00	AMZN	Stock	10.652	10.7015	10.652	10.7	41000.0
2011-10-05 07:00:00	AMZN	Stock	10.72	10.769	10.65	10.65	409900.0
2011-10-05 08:00:00	AMZN	Stock	10.6915	10.72	10.499	10.523	368980.0
2011-10-05 09:00:00	AMZN	Stock	10.5175	10.7375	10.446	10.5065	20220740.0
2011-10-05 10:00:00	AMZN	Stock	10.497	10.7118	10.4241	10.6775	22486320.0
2011-10-05 11:00:00	AMZN	Stock	10.6765	10.845	10.578	10.826	18435300.0

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

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