PREVIEW / stock_1hour / 2015-08-20

all stock 1-hour files

  file:    by_date/stock_1hour/2015/2015-08-20.parquet
  size:    1.1 MB
  rows:    48,953
  symbols: 3,454

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
2015-08-20 04:00:00	AAPL	Stock	28.6775	28.6775	28.58	28.58	35292.0
2015-08-20 05:00:00	AAPL	Stock	28.5875	28.61	28.5325	28.59	59148.0
2015-08-20 06:00:00	AAPL	Stock	28.605	28.6225	28.5375	28.555	101560.0
2015-08-20 07:00:00	AAPL	Stock	28.565	28.59	28.5325	28.575	231528.0
2015-08-20 08:00:00	AAPL	Stock	28.5825	28.605	28.5025	28.57	725800.0
2015-08-20 09:00:00	AAPL	Stock	28.57	28.5875	28.3	28.3325	31720948.0
2015-08-20 10:00:00	AAPL	Stock	28.3225	28.4412	27.9375	28.1452	57564188.0
2015-08-20 11:00:00	AAPL	Stock	28.145	28.1975	27.9075	28.1475	36212436.0
2015-08-20 12:00:00	AAPL	Stock	28.1475	28.1625	28.06	28.0852	24691820.0
2015-08-20 13:00:00	AAPL	Stock	28.085	28.295	28.055	28.265	26261076.0
2015-08-20 14:00:00	AAPL	Stock	28.265	28.2675	28.1175	28.1675	25894652.0
2015-08-20 15:00:00	AAPL	Stock	28.1675	28.3088	28.125	28.1625	43543400.0
2015-08-20 16:00:00	AAPL	Stock	28.1625	28.5625	28.0925	28.11	11129448.0
2015-08-20 17:00:00	AAPL	Stock	28.1175	28.1225	28.0	28.05	174276.0
2015-08-20 18:00:00	AAPL	Stock	28.06	28.1625	28.06	28.075	760296.0
2015-08-20 19:00:00	AAPL	Stock	28.0625	28.085	28.05	28.0775	90744.0
2015-08-20 07:00:00	MSFT	Stock	46.22	46.22	46.21	46.21	3800.0
2015-08-20 08:00:00	MSFT	Stock	46.26	46.37	46.26	46.33	3580.0
2015-08-20 09:00:00	MSFT	Stock	46.293	46.47	45.94	46.02	3746653.0
2015-08-20 10:00:00	MSFT	Stock	46.02	46.09	45.75	45.99	6587517.0
2015-08-20 11:00:00	MSFT	Stock	45.99	46.095	45.84	46.02	2618790.0
2015-08-20 12:00:00	MSFT	Stock	46.02	46.03	45.8	45.89	3158593.0
2015-08-20 13:00:00	MSFT	Stock	45.884	46.01	45.81	45.975	2780690.0
2015-08-20 14:00:00	MSFT	Stock	45.975	46.1	45.81	45.921	3033246.0
2015-08-20 15:00:00	MSFT	Stock	45.925	46.09	45.67	45.77	8720385.0
2015-08-20 16:00:00	MSFT	Stock	45.67	45.85	45.66	45.75	3568627.0
2015-08-20 17:00:00	MSFT	Stock	45.6	45.65	45.6	45.6	4112.0
2015-08-20 18:00:00	MSFT	Stock	45.647	45.7	45.6	45.62	3054.0
2015-08-20 19:00:00	MSFT	Stock	45.62	45.66	45.6	45.6	26476.0
2015-08-20 08:00:00	NVDA	Stock	0.5558	0.5558	0.5558	0.5558	4000.0
2015-08-20 09:00:00	NVDA	Stock	0.5682	0.571	0.5615	0.5628	67512120.0
2015-08-20 10:00:00	NVDA	Stock	0.5628	0.565	0.5558	0.5622	75130600.0
2015-08-20 11:00:00	NVDA	Stock	0.5625	0.563	0.5602	0.5619	31676920.0
2015-08-20 12:00:00	NVDA	Stock	0.562	0.5628	0.5588	0.56	24013000.0
2015-08-20 13:00:00	NVDA	Stock	0.5598	0.5599	0.5555	0.5558	45901960.0
2015-08-20 14:00:00	NVDA	Stock	0.5558	0.557	0.5512	0.5518	55939880.0
2015-08-20 15:00:00	NVDA	Stock	0.552	0.56	0.5518	0.5539	97364520.0
2015-08-20 16:00:00	NVDA	Stock	0.554	0.554	0.5512	0.5513	12505760.0
2015-08-20 17:00:00	NVDA	Stock	0.5539	0.5539	0.5539	0.5539	69760.0
2015-08-20 04:00:00	AMZN	Stock	26.616	26.616	26.616	26.616	8000.0
2015-08-20 05:00:00	AMZN	Stock	26.4	26.4	26.4	26.4	2000.0
2015-08-20 06:00:00	AMZN	Stock	26.435	26.435	26.435	26.435	2000.0
2015-08-20 07:00:00	AMZN	Stock	26.458	26.4625	26.3705	26.4015	62880.0
2015-08-20 08:00:00	AMZN	Stock	26.4595	26.5305	26.4015	26.504	153860.0
2015-08-20 09:00:00	AMZN	Stock	26.5075	26.6625	26.4865	26.5535	9604980.0
2015-08-20 10:00:00	AMZN	Stock	26.573	26.5998	26.1755	26.282	21792040.0
2015-08-20 11:00:00	AMZN	Stock	26.2913	26.3	25.9605	26.0655	11288620.0
2015-08-20 12:00:00	AMZN	Stock	26.0705	26.0945	25.821	25.8526	6934760.0
2015-08-20 13:00:00	AMZN	Stock	25.8565	26.0325	25.8016	25.8925	7727020.0
2015-08-20 14:00:00	AMZN	Stock	25.9025	25.9465	25.83	25.8622	4479200.0

> showing 50 of 48,953 rows — these rows as CSV

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