PREVIEW / stock_1hour / 2012-10-10

all stock 1-hour files

  file:    by_date/stock_1hour/2012/2012-10-10.parquet
  size:    927 KB
  rows:    43,827
  symbols: 3,474

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-10-10 04:00:00	AAPL	Stock	22.8171	22.8214	22.8071	22.8071	79772.0
2012-10-10 05:00:00	AAPL	Stock	22.8039	22.8039	22.6911	22.7143	148988.0
2012-10-10 06:00:00	AAPL	Stock	22.7071	22.7286	22.7071	22.7286	78008.0
2012-10-10 07:00:00	AAPL	Stock	22.7232	22.8321	22.7179	22.8214	1269940.0
2012-10-10 08:00:00	AAPL	Stock	22.8311	22.855	22.7557	22.7904	2683884.0
2012-10-10 09:00:00	AAPL	Stock	22.7904	22.9489	22.75	22.835	99475684.0
2012-10-10 10:00:00	AAPL	Stock	22.8389	23.0268	22.8286	22.9636	95327064.0
2012-10-10 11:00:00	AAPL	Stock	22.9639	23.035	22.8686	22.9196	66899196.0
2012-10-10 12:00:00	AAPL	Stock	22.92	22.9521	22.7914	22.8096	51806020.0
2012-10-10 13:00:00	AAPL	Stock	22.8068	22.8968	22.7857	22.8598	43183084.0
2012-10-10 14:00:00	AAPL	Stock	22.8596	22.9814	22.8586	22.9076	48422500.0
2012-10-10 15:00:00	AAPL	Stock	22.9054	22.9343	22.8257	22.8886	66923584.0
2012-10-10 16:00:00	AAPL	Stock	22.8896	22.9416	22.8637	22.8761	16344608.0
2012-10-10 17:00:00	AAPL	Stock	22.8804	22.8896	22.8432	22.8896	415940.0
2012-10-10 18:00:00	AAPL	Stock	22.8582	22.8643	22.8446	22.8471	274568.0
2012-10-10 19:00:00	AAPL	Stock	22.8536	22.8536	22.8271	22.8393	520520.0
2012-10-10 07:00:00	MSFT	Stock	29.24	29.26	29.24	29.26	900.0
2012-10-10 08:00:00	MSFT	Stock	29.35	29.35	29.24	29.24	18827.0
2012-10-10 09:00:00	MSFT	Stock	29.25	29.26	29.03	29.18	4904594.0
2012-10-10 10:00:00	MSFT	Stock	29.18	29.31	29.145	29.204	6862782.0
2012-10-10 11:00:00	MSFT	Stock	29.21	29.25	29.15	29.195	4396730.0
2012-10-10 12:00:00	MSFT	Stock	29.19	29.23	29.12	29.14	3550726.0
2012-10-10 13:00:00	MSFT	Stock	29.14	29.16	29.01	29.06	7502008.0
2012-10-10 14:00:00	MSFT	Stock	29.055	29.09	28.97	28.995	6097259.0
2012-10-10 15:00:00	MSFT	Stock	29.0	29.03	28.95	28.99	9474403.0
2012-10-10 16:00:00	MSFT	Stock	28.98	29.232	28.89	29.232	2103372.0
2012-10-10 17:00:00	MSFT	Stock	28.98	28.98	28.96	28.97	3075.0
2012-10-10 18:00:00	MSFT	Stock	28.97	28.98	28.94	28.98	10900.0
2012-10-10 19:00:00	MSFT	Stock	28.98	28.99	28.96	28.96	5080.0
2012-10-10 08:00:00	NVDA	Stock	0.3225	0.3225	0.3225	0.3225	40000.0
2012-10-10 09:00:00	NVDA	Stock	0.3223	0.3223	0.3155	0.318	65056160.0
2012-10-10 10:00:00	NVDA	Stock	0.3181	0.3195	0.317	0.3179	63660080.0
2012-10-10 11:00:00	NVDA	Stock	0.318	0.3185	0.3164	0.317	33063720.0
2012-10-10 12:00:00	NVDA	Stock	0.317	0.319	0.3169	0.3183	45550800.0
2012-10-10 13:00:00	NVDA	Stock	0.3181	0.3188	0.3166	0.3188	22542200.0
2012-10-10 14:00:00	NVDA	Stock	0.3188	0.3195	0.3183	0.3183	30436880.0
2012-10-10 15:00:00	NVDA	Stock	0.3183	0.3185	0.3163	0.3168	56010400.0
2012-10-10 16:00:00	NVDA	Stock	0.3168	0.3188	0.3163	0.3168	8929760.0
2012-10-10 17:00:00	NVDA	Stock	0.3168	0.3168	0.3168	0.3168	12000.0
2012-10-10 07:00:00	AMZN	Stock	12.505	12.575	12.505	12.575	4000.0
2012-10-10 08:00:00	AMZN	Stock	12.6035	12.62	12.577	12.5775	154480.0
2012-10-10 09:00:00	AMZN	Stock	12.577	12.6125	12.4745	12.5085	11222920.0
2012-10-10 10:00:00	AMZN	Stock	12.5085	12.623	12.481	12.491	11032220.0
2012-10-10 11:00:00	AMZN	Stock	12.491	12.5275	12.4255	12.4305	8591300.0
2012-10-10 12:00:00	AMZN	Stock	12.425	12.441	12.3015	12.3055	9637240.0
2012-10-10 13:00:00	AMZN	Stock	12.309	12.35	12.2642	12.283	11965560.0
2012-10-10 14:00:00	AMZN	Stock	12.283	12.3295	12.2005	12.2485	10994040.0
2012-10-10 15:00:00	AMZN	Stock	12.246	12.274	12.2225	12.2455	12068680.0
2012-10-10 16:00:00	AMZN	Stock	12.2565	12.3857	12.2418	12.2495	895260.0
2012-10-10 17:00:00	AMZN	Stock	12.2375	12.2375	12.221	12.221	24000.0

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

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