PREVIEW / stock_1hour / 2013-12-31

all stock 1-hour files

  file:    by_date/stock_1hour/2013/2013-12-31.parquet
  size:    1.0 MB
  rows:    48,523
  symbols: 3,551

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
2013-12-31 07:00:00	AAPL	Stock	19.805	19.81	19.7482	19.75	164080.0
2013-12-31 08:00:00	AAPL	Stock	19.75	19.8196	19.7482	19.7839	263620.0
2013-12-31 09:00:00	AAPL	Stock	19.7957	19.9725	19.7857	19.9629	39925984.0
2013-12-31 10:00:00	AAPL	Stock	19.9661	20.0386	19.9504	20.007	40117700.0
2013-12-31 11:00:00	AAPL	Stock	20.0071	20.0457	20.0036	20.0386	20010004.0
2013-12-31 12:00:00	AAPL	Stock	20.0379	20.0386	19.9907	20.0295	13822676.0
2013-12-31 13:00:00	AAPL	Stock	20.03	20.0318	19.9975	20.0107	10285968.0
2013-12-31 14:00:00	AAPL	Stock	20.0107	20.0196	19.9522	19.9874	16910936.0
2013-12-31 15:00:00	AAPL	Stock	19.9879	20.0439	19.9718	20.0414	33505640.0
2013-12-31 16:00:00	AAPL	Stock	20.0396	20.0479	19.8376	20.0479	14135520.0
2013-12-31 17:00:00	AAPL	Stock	20.0479	20.0479	20.0396	20.0479	166264.0
2013-12-31 18:00:00	AAPL	Stock	20.0479	20.0514	20.0429	20.0429	68992.0
2013-12-31 19:00:00	AAPL	Stock	20.0432	20.0464	20.0421	20.0421	42364.0
2013-12-31 08:00:00	MSFT	Stock	37.29	37.37	37.25	37.37	607.0
2013-12-31 09:00:00	MSFT	Stock	37.4	37.44	37.217	37.335	1766447.0
2013-12-31 10:00:00	MSFT	Stock	37.33	37.48	37.33	37.45	2158273.0
2013-12-31 11:00:00	MSFT	Stock	37.45	37.58	37.32	37.36	2384997.0
2013-12-31 12:00:00	MSFT	Stock	37.36	37.42	37.27	37.345	1417897.0
2013-12-31 13:00:00	MSFT	Stock	37.35	37.41	37.32	37.384	1021129.0
2013-12-31 14:00:00	MSFT	Stock	37.39	37.42	37.32	37.33	1155001.0
2013-12-31 15:00:00	MSFT	Stock	37.34	37.45	37.3	37.43	3408105.0
2013-12-31 16:00:00	MSFT	Stock	37.43	37.53	37.38	37.45	3454559.0
2013-12-31 17:00:00	MSFT	Stock	37.376	37.45	37.376	37.41	451.0
2013-12-31 18:00:00	MSFT	Stock	37.41	37.41	37.41	37.41	580.0
2013-12-31 19:00:00	MSFT	Stock	37.43	37.43	37.41	37.41	1370.0
2013-12-31 08:00:00	NVDA	Stock	0.4	0.4	0.4	0.4	136000.0
2013-12-31 09:00:00	NVDA	Stock	0.3995	0.4015	0.3975	0.4005	29345400.0
2013-12-31 10:00:00	NVDA	Stock	0.4008	0.4025	0.3998	0.4011	35106880.0
2013-12-31 11:00:00	NVDA	Stock	0.4013	0.4018	0.3998	0.4001	29675720.0
2013-12-31 12:00:00	NVDA	Stock	0.4001	0.4005	0.3993	0.3999	20787240.0
2013-12-31 13:00:00	NVDA	Stock	0.4	0.4003	0.3998	0.4003	16775080.0
2013-12-31 14:00:00	NVDA	Stock	0.4003	0.4005	0.3995	0.4001	20386240.0
2013-12-31 15:00:00	NVDA	Stock	0.4001	0.4005	0.3995	0.4003	63309800.0
2013-12-31 16:00:00	NVDA	Stock	0.4005	0.4006	0.4003	0.4005	1485160.0
2013-12-31 19:00:00	NVDA	Stock	0.4	0.4	0.4	0.4	8000.0
2013-12-31 08:00:00	AMZN	Stock	19.7	19.7515	19.7	19.75	32080.0
2013-12-31 09:00:00	AMZN	Stock	19.748	19.848	19.69	19.7285	5039800.0
2013-12-31 10:00:00	AMZN	Stock	19.7343	19.85	19.71	19.8475	4465520.0
2013-12-31 11:00:00	AMZN	Stock	19.85	19.8995	19.8071	19.8525	3889360.0
2013-12-31 12:00:00	AMZN	Stock	19.8615	19.898	19.8364	19.8575	2466800.0
2013-12-31 13:00:00	AMZN	Stock	19.8615	19.875	19.8155	19.825	2142480.0
2013-12-31 14:00:00	AMZN	Stock	19.8288	19.849	19.761	19.7648	2806520.0
2013-12-31 15:00:00	AMZN	Stock	19.773	19.9415	19.7625	19.9235	9410720.0
2013-12-31 16:00:00	AMZN	Stock	19.925	19.9695	19.844	19.9395	761320.0
2013-12-31 17:00:00	AMZN	Stock	19.9395	19.95	19.9395	19.95	27500.0
2013-12-31 19:00:00	AMZN	Stock	19.945	19.9625	19.945	19.9625	6000.0
2013-12-31 05:00:00	META	Stock	53.88	53.88	53.88	53.88	100.0
2013-12-31 06:00:00	META	Stock	53.8	53.99	53.8	53.96	4926.0
2013-12-31 07:00:00	META	Stock	53.96	54.3	53.96	54.18	30908.0
2013-12-31 08:00:00	META	Stock	54.18	54.42	53.96	54.33	271842.0

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

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