PREVIEW / stock_1hour / 2012-01-20

all stock 1-hour files

  file:    by_date/stock_1hour/2012/2012-01-20.parquet
  size:    925 KB
  rows:    43,563
  symbols: 3,506

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
2012-01-20 04:00:00	AAPL	Stock	15.2107	15.2107	15.1821	15.2082	12040.0
2012-01-20 05:00:00	AAPL	Stock	15.155	15.2143	15.1518	15.2143	39200.0
2012-01-20 06:00:00	AAPL	Stock	15.2225	15.2225	15.2143	15.2143	5600.0
2012-01-20 07:00:00	AAPL	Stock	15.2096	15.275	15.2096	15.2411	298144.0
2012-01-20 08:00:00	AAPL	Stock	15.2536	15.2536	15.2157	15.2304	465136.0
2012-01-20 09:00:00	AAPL	Stock	15.2321	15.2682	15.1114	15.1625	83057324.0
2012-01-20 10:00:00	AAPL	Stock	15.16	15.1786	15.1468	15.1586	38649940.0
2012-01-20 11:00:00	AAPL	Stock	15.1589	15.1625	15.1289	15.1429	26856144.0
2012-01-20 12:00:00	AAPL	Stock	15.1421	15.1464	15.14	15.1414	21705936.0
2012-01-20 13:00:00	AAPL	Stock	15.1411	15.1446	15.04	15.0429	40860260.0
2012-01-20 14:00:00	AAPL	Stock	15.0421	15.0749	14.9911	15.0189	85709708.0
2012-01-20 15:00:00	AAPL	Stock	15.0193	15.0578	15.0	15.0093	92241100.0
2012-01-20 16:00:00	AAPL	Stock	15.011	15.2768	15.0007	15.0339	15659280.0
2012-01-20 17:00:00	AAPL	Stock	15.0354	15.0643	15.0289	15.0396	1194172.0
2012-01-20 18:00:00	AAPL	Stock	15.05	15.0711	15.0107	15.0693	473200.0
2012-01-20 19:00:00	AAPL	Stock	15.0693	15.0832	15.0693	15.0714	610988.0
2012-01-20 04:00:00	MSFT	Stock	28.7	28.7	28.7	28.7	1000.0
2012-01-20 05:00:00	MSFT	Stock	28.64	28.87	28.64	28.87	7000.0
2012-01-20 06:00:00	MSFT	Stock	28.77	28.77	28.7	28.72	2100.0
2012-01-20 07:00:00	MSFT	Stock	28.71	28.98	28.7	28.91	104632.0
2012-01-20 08:00:00	MSFT	Stock	28.91	28.93	28.73	28.8	444516.0
2012-01-20 09:00:00	MSFT	Stock	28.79	29.07	28.68	29.05	33660005.0
2012-01-20 10:00:00	MSFT	Stock	29.05	29.18	28.99	29.1	26398242.0
2012-01-20 11:00:00	MSFT	Stock	29.1	29.4	29.09	29.342	23084753.0
2012-01-20 12:00:00	MSFT	Stock	29.345	29.5	29.28	29.465	16228800.0
2012-01-20 13:00:00	MSFT	Stock	29.46	29.73	29.46	29.64	17324372.0
2012-01-20 14:00:00	MSFT	Stock	29.63	29.645	29.42	29.565	12959030.0
2012-01-20 15:00:00	MSFT	Stock	29.563	29.74	29.46	29.71	27178407.0
2012-01-20 16:00:00	MSFT	Stock	29.71	29.76	28.12	29.73	1505500.0
2012-01-20 17:00:00	MSFT	Stock	29.74	29.77	29.72	29.77	30746.0
2012-01-20 18:00:00	MSFT	Stock	29.77	29.77	29.71	29.75	50534.0
2012-01-20 19:00:00	MSFT	Stock	29.76	29.77	29.75	29.77	16550.0
2012-01-20 08:00:00	NVDA	Stock	0.3575	0.3575	0.3575	0.3575	10000.0
2012-01-20 09:00:00	NVDA	Stock	0.3572	0.3615	0.3572	0.361	75350760.0
2012-01-20 10:00:00	NVDA	Stock	0.3611	0.3625	0.3585	0.3621	69929360.0
2012-01-20 11:00:00	NVDA	Stock	0.3621	0.3625	0.3582	0.36	61117280.0
2012-01-20 12:00:00	NVDA	Stock	0.3601	0.3612	0.3592	0.3602	53002400.0
2012-01-20 13:00:00	NVDA	Stock	0.3604	0.3612	0.3592	0.3592	39843000.0
2012-01-20 14:00:00	NVDA	Stock	0.3592	0.3598	0.356	0.3581	76707520.0
2012-01-20 15:00:00	NVDA	Stock	0.358	0.3582	0.3542	0.3555	146734880.0
2012-01-20 16:00:00	NVDA	Stock	0.355	0.3586	0.355	0.3562	4607080.0
2012-01-20 04:00:00	AMZN	Stock	9.634	9.6415	9.634	9.6415	4000.0
2012-01-20 06:00:00	AMZN	Stock	9.582	9.6355	9.5815	9.6355	8000.0
2012-01-20 07:00:00	AMZN	Stock	9.6	9.6	9.555	9.5825	122820.0
2012-01-20 08:00:00	AMZN	Stock	9.585	9.585	9.515	9.549	439180.0
2012-01-20 09:00:00	AMZN	Stock	9.5495	9.645	9.5055	9.5305	24639540.0
2012-01-20 10:00:00	AMZN	Stock	9.5335	9.5775	9.5125	9.5445	17204480.0
2012-01-20 11:00:00	AMZN	Stock	9.543	9.5535	9.4905	9.5	13455620.0
2012-01-20 12:00:00	AMZN	Stock	9.5005	9.5185	9.456	9.456	9872940.0
2012-01-20 13:00:00	AMZN	Stock	9.456	9.5019	9.452	9.482	8218480.0

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

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