PREVIEW / stock_1hour / 2013-07-23

all stock 1-hour files

  file:    by_date/stock_1hour/2013/2013-07-23.parquet
  size:    1002 KB
  rows:    46,330
  symbols: 3,504

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-07-23 04:00:00	AAPL	Stock	15.2607	15.2607	15.2607	15.2607	5600.0
2013-07-23 06:00:00	AAPL	Stock	15.2493	15.2529	15.2493	15.2529	14028.0
2013-07-23 07:00:00	AAPL	Stock	15.2554	15.3221	15.2443	15.3221	223832.0
2013-07-23 08:00:00	AAPL	Stock	15.3214	15.3389	15.1964	15.2696	757708.0
2013-07-23 09:00:00	AAPL	Stock	15.2679	15.2786	15.0989	15.1164	36292424.0
2013-07-23 10:00:00	AAPL	Stock	15.1196	15.1339	15.0575	15.0984	43979544.0
2013-07-23 11:00:00	AAPL	Stock	15.0982	15.1586	15.0796	15.145	25168752.0
2013-07-23 12:00:00	AAPL	Stock	15.1436	15.1436	15.0832	15.1014	21485884.0
2013-07-23 13:00:00	AAPL	Stock	15.1029	15.135	15.0978	15.1229	16126012.0
2013-07-23 14:00:00	AAPL	Stock	15.1211	15.1264	15.0793	15.1143	18557112.0
2013-07-23 15:00:00	AAPL	Stock	15.1143	15.1146	14.9539	14.9636	89550608.0
2013-07-23 16:00:00	AAPL	Stock	14.9639	15.7857	14.9593	15.7404	83115620.0
2013-07-23 17:00:00	AAPL	Stock	15.7321	15.7432	15.0151	15.5	22750364.0
2013-07-23 18:00:00	AAPL	Stock	15.495	15.5357	15.4575	15.5107	3148768.0
2013-07-23 19:00:00	AAPL	Stock	15.5007	15.5718	15.4889	15.5493	1995644.0
2013-07-23 04:00:00	MSFT	Stock	31.99	31.99	31.99	31.99	529.0
2013-07-23 05:00:00	MSFT	Stock	31.99	31.99	31.99	31.99	600.0
2013-07-23 06:00:00	MSFT	Stock	32.01	32.01	32.01	32.01	1100.0
2013-07-23 07:00:00	MSFT	Stock	32.03	32.03	31.9	32.0	12360.0
2013-07-23 08:00:00	MSFT	Stock	32.0	32.01	31.9	32.01	306242.0
2013-07-23 09:00:00	MSFT	Stock	31.98	32.03	31.8	31.88	10844619.0
2013-07-23 10:00:00	MSFT	Stock	31.88	31.95	31.75	31.79	9966929.0
2013-07-23 11:00:00	MSFT	Stock	31.785	31.84	31.71	31.766	6597955.0
2013-07-23 12:00:00	MSFT	Stock	31.77	31.84	31.71	31.82	4280559.0
2013-07-23 13:00:00	MSFT	Stock	31.815	32.04	31.81	31.951	8950692.0
2013-07-23 14:00:00	MSFT	Stock	31.95	31.95	31.79	31.89	6585716.0
2013-07-23 15:00:00	MSFT	Stock	31.88	31.97	31.78	31.83	15465368.0
2013-07-23 16:00:00	MSFT	Stock	31.82	31.97	31.7	31.85	2390276.0
2013-07-23 17:00:00	MSFT	Stock	31.82	32.01	31.82	31.84	149617.0
2013-07-23 18:00:00	MSFT	Stock	31.84	31.84	31.82	31.83	3700.0
2013-07-23 19:00:00	MSFT	Stock	31.91	31.92	31.83	31.83	5177.0
2013-07-23 08:00:00	NVDA	Stock	0.361	0.3615	0.361	0.3615	116000.0
2013-07-23 09:00:00	NVDA	Stock	0.3602	0.3602	0.3565	0.3582	36983600.0
2013-07-23 10:00:00	NVDA	Stock	0.3582	0.3585	0.3535	0.3558	46930560.0
2013-07-23 11:00:00	NVDA	Stock	0.3558	0.3585	0.3555	0.357	30992360.0
2013-07-23 12:00:00	NVDA	Stock	0.357	0.3571	0.3556	0.356	15461480.0
2013-07-23 13:00:00	NVDA	Stock	0.3561	0.3562	0.3555	0.3556	16498200.0
2013-07-23 14:00:00	NVDA	Stock	0.3556	0.3575	0.3555	0.3568	29205440.0
2013-07-23 15:00:00	NVDA	Stock	0.357	0.357	0.3545	0.3553	47609160.0
2013-07-23 16:00:00	NVDA	Stock	0.3553	0.3562	0.3552	0.3552	22328920.0
2013-07-23 17:00:00	NVDA	Stock	0.3556	0.3556	0.3556	0.3556	404000.0
2013-07-23 08:00:00	AMZN	Stock	15.19	15.19	15.159	15.159	8000.0
2013-07-23 09:00:00	AMZN	Stock	15.174	15.253	15.132	15.207	5604780.0
2013-07-23 10:00:00	AMZN	Stock	15.207	15.23	15.0795	15.121	5876900.0
2013-07-23 11:00:00	AMZN	Stock	15.113	15.121	15.0555	15.096	3574440.0
2013-07-23 12:00:00	AMZN	Stock	15.0905	15.115	15.0502	15.0814	3978120.0
2013-07-23 13:00:00	AMZN	Stock	15.084	15.1965	15.0805	15.1608	4202420.0
2013-07-23 14:00:00	AMZN	Stock	15.159	15.1665	15.1	15.1165	3545300.0
2013-07-23 15:00:00	AMZN	Stock	15.119	15.1252	15.028	15.0525	11168460.0
2013-07-23 16:00:00	AMZN	Stock	15.052	15.1455	15.05	15.125	206220.0

> showing 50 of 46,330 rows — these rows as CSV

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