PREVIEW / stock_1hour / 2015-04-13

all stock 1-hour files

  file:    by_date/stock_1hour/2015/2015-04-13.parquet
  size:    1.0 MB
  rows:    48,665
  symbols: 3,513

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-04-13 04:00:00	AAPL	Stock	31.775	31.775	31.7525	31.7575	17056.0
2015-04-13 05:00:00	AAPL	Stock	31.7575	31.7675	31.745	31.765	22676.0
2015-04-13 06:00:00	AAPL	Stock	31.7675	31.8475	31.7625	31.8475	127116.0
2015-04-13 07:00:00	AAPL	Stock	31.8475	31.925	31.8375	31.9125	217320.0
2015-04-13 08:00:00	AAPL	Stock	31.905	32.0325	31.8475	31.975	1527908.0
2015-04-13 09:00:00	AAPL	Stock	31.9675	32.1425	31.9375	32.015	31042048.0
2015-04-13 10:00:00	AAPL	Stock	32.0125	32.0575	31.9525	31.9675	19782716.0
2015-04-13 11:00:00	AAPL	Stock	31.97	32.025	31.8125	31.8625	17654980.0
2015-04-13 12:00:00	AAPL	Stock	31.8612	31.8925	31.7825	31.83	12272628.0
2015-04-13 13:00:00	AAPL	Stock	31.83	31.83	31.69	31.725	15431368.0
2015-04-13 14:00:00	AAPL	Stock	31.7275	31.775	31.6825	31.75	11637432.0
2015-04-13 15:00:00	AAPL	Stock	31.7475	31.8275	31.6525	31.7125	21058296.0
2015-04-13 16:00:00	AAPL	Stock	31.72	31.7625	31.6975	31.7125	4816572.0
2015-04-13 17:00:00	AAPL	Stock	31.7125	31.7375	31.705	31.735	122684.0
2015-04-13 18:00:00	AAPL	Stock	31.735	31.755	31.7225	31.7225	131252.0
2015-04-13 19:00:00	AAPL	Stock	31.7225	31.7425	31.72	31.7375	105808.0
2015-04-13 07:00:00	MSFT	Stock	41.71	41.72	41.71	41.72	1000.0
2015-04-13 08:00:00	MSFT	Stock	41.7	41.72	41.5	41.58	4918.0
2015-04-13 09:00:00	MSFT	Stock	41.54	41.9	41.39	41.86	4365062.0
2015-04-13 10:00:00	MSFT	Stock	41.855	41.935	41.81	41.885	3296590.0
2015-04-13 11:00:00	MSFT	Stock	41.88	42.06	41.88	41.95	2716395.0
2015-04-13 12:00:00	MSFT	Stock	41.95	42.03	41.86	41.94	1885652.0
2015-04-13 13:00:00	MSFT	Stock	41.945	41.95	41.69	41.79	2235295.0
2015-04-13 14:00:00	MSFT	Stock	41.79	41.87	41.74	41.78	2174171.0
2015-04-13 15:00:00	MSFT	Stock	41.79	41.89	41.72	41.77	7450589.0
2015-04-13 16:00:00	MSFT	Stock	41.76	41.82	41.76	41.77	4342753.0
2015-04-13 17:00:00	MSFT	Stock	41.77	41.77	41.72	41.72	5000.0
2015-04-13 18:00:00	MSFT	Stock	41.75	41.75	41.75	41.75	350.0
2015-04-13 09:00:00	NVDA	Stock	0.5675	0.571	0.5645	0.5685	27085280.0
2015-04-13 10:00:00	NVDA	Stock	0.5685	0.569	0.5612	0.563	45007840.0
2015-04-13 11:00:00	NVDA	Stock	0.563	0.566	0.5612	0.5646	42828840.0
2015-04-13 12:00:00	NVDA	Stock	0.5645	0.5662	0.5645	0.5652	19216600.0
2015-04-13 13:00:00	NVDA	Stock	0.5652	0.5655	0.5615	0.5624	26310680.0
2015-04-13 14:00:00	NVDA	Stock	0.5625	0.565	0.562	0.565	16258840.0
2015-04-13 15:00:00	NVDA	Stock	0.565	0.5658	0.5638	0.5638	46856120.0
2015-04-13 16:00:00	NVDA	Stock	0.5638	0.5638	0.5602	0.5632	1516640.0
2015-04-13 17:00:00	NVDA	Stock	0.5632	0.5632	0.5612	0.5612	12520.0
2015-04-13 19:00:00	NVDA	Stock	0.5635	0.5635	0.5635	0.5635	12000.0
2015-04-13 04:00:00	AMZN	Stock	19.1265	19.1265	19.1265	19.1265	8000.0
2015-04-13 08:00:00	AMZN	Stock	19.1	19.1505	19.1	19.1505	145400.0
2015-04-13 09:00:00	AMZN	Stock	19.152	19.264	19.1155	19.204	5792220.0
2015-04-13 10:00:00	AMZN	Stock	19.2028	19.21	19.135	19.154	4082760.0
2015-04-13 11:00:00	AMZN	Stock	19.154	19.154	19.084	19.1092	3491520.0
2015-04-13 12:00:00	AMZN	Stock	19.113	19.1165	19.0312	19.0535	4809240.0
2015-04-13 13:00:00	AMZN	Stock	19.0514	19.062	19.007	19.0455	2269580.0
2015-04-13 14:00:00	AMZN	Stock	19.046	19.1065	19.036	19.0895	3172780.0
2015-04-13 15:00:00	AMZN	Stock	19.0855	19.1445	19.077	19.123	7109020.0
2015-04-13 16:00:00	AMZN	Stock	19.118	19.1623	19.118	19.1623	3819740.0
2015-04-13 07:00:00	GOOGL	Stock	27.301	27.301	27.3	27.3	6000.0
2015-04-13 08:00:00	GOOGL	Stock	27.4245	27.427	27.285	27.3265	20380.0

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

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