PREVIEW / stock_1hour / 2013-05-08

all stock 1-hour files

  file:    by_date/stock_1hour/2013/2013-05-08.parquet
  size:    997 KB
  rows:    46,158
  symbols: 3,490

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-05-08 04:00:00	AAPL	Stock	16.4286	16.4286	16.4286	16.4286	2800.0
2013-05-08 05:00:00	AAPL	Stock	16.4304	16.4304	16.4161	16.4161	15232.0
2013-05-08 06:00:00	AAPL	Stock	16.42	16.4889	16.42	16.4432	33376.0
2013-05-08 07:00:00	AAPL	Stock	16.4182	16.5132	16.4161	16.4629	748104.0
2013-05-08 08:00:00	AAPL	Stock	16.4607	16.5064	16.3571	16.4121	2158044.0
2013-05-08 09:00:00	AAPL	Stock	16.4164	16.5421	16.2789	16.535	77972328.0
2013-05-08 10:00:00	AAPL	Stock	16.5375	16.5964	16.4907	16.5507	86682344.0
2013-05-08 11:00:00	AAPL	Stock	16.5529	16.5996	16.5446	16.5877	48504400.0
2013-05-08 12:00:00	AAPL	Stock	16.5871	16.6036	16.5643	16.5996	33445048.0
2013-05-08 13:00:00	AAPL	Stock	16.5986	16.6204	16.5568	16.5768	38027920.0
2013-05-08 14:00:00	AAPL	Stock	16.5768	16.5936	16.4606	16.5246	44581012.0
2013-05-08 15:00:00	AAPL	Stock	16.525	16.5893	16.5179	16.5611	61918528.0
2013-05-08 16:00:00	AAPL	Stock	16.5582	16.5945	16.5272	16.5475	11614092.0
2013-05-08 17:00:00	AAPL	Stock	16.5479	16.5786	16.5411	16.5721	562100.0
2013-05-08 18:00:00	AAPL	Stock	16.5786	16.5804	16.5714	16.5714	244860.0
2013-05-08 19:00:00	AAPL	Stock	16.5789	16.5893	16.5771	16.5825	308168.0
2013-05-08 04:00:00	MSFT	Stock	33.18	33.18	33.18	33.18	100.0
2013-05-08 06:00:00	MSFT	Stock	33.25	33.28	33.25	33.28	700.0
2013-05-08 07:00:00	MSFT	Stock	33.26	33.28	33.26	33.26	2240.0
2013-05-08 08:00:00	MSFT	Stock	33.26	33.5	33.11	33.11	23512.0
2013-05-08 09:00:00	MSFT	Stock	33.14	33.17	32.65	32.695	13240958.0
2013-05-08 10:00:00	MSFT	Stock	32.7	33.05	32.68	32.99	10898812.0
2013-05-08 11:00:00	MSFT	Stock	33.0	33.14	32.96	33.11	4573962.0
2013-05-08 12:00:00	MSFT	Stock	33.111	33.16	33.06	33.1	3414387.0
2013-05-08 13:00:00	MSFT	Stock	33.109	33.19	33.07	33.16	3106886.0
2013-05-08 14:00:00	MSFT	Stock	33.16	33.24	33.09	33.14	2999175.0
2013-05-08 15:00:00	MSFT	Stock	33.15	33.156	33.0	33.0	9480628.0
2013-05-08 16:00:00	MSFT	Stock	33.0	33.31	32.69	32.98	2359567.0
2013-05-08 17:00:00	MSFT	Stock	33.0	33.0	32.98	32.98	3573.0
2013-05-08 18:00:00	MSFT	Stock	32.99	32.99	32.98	32.99	1645.0
2013-05-08 19:00:00	MSFT	Stock	32.97	32.99	32.97	32.99	582.0
2013-05-08 09:00:00	NVDA	Stock	0.3418	0.3433	0.3405	0.3428	17065320.0
2013-05-08 10:00:00	NVDA	Stock	0.343	0.3488	0.343	0.347	100822680.0
2013-05-08 11:00:00	NVDA	Stock	0.347	0.3488	0.3469	0.3484	42796720.0
2013-05-08 12:00:00	NVDA	Stock	0.3484	0.3495	0.348	0.3491	26117880.0
2013-05-08 13:00:00	NVDA	Stock	0.349	0.3493	0.3468	0.3474	28470720.0
2013-05-08 14:00:00	NVDA	Stock	0.3473	0.3478	0.3455	0.3465	25767800.0
2013-05-08 15:00:00	NVDA	Stock	0.3465	0.349	0.3465	0.3473	74669960.0
2013-05-08 16:00:00	NVDA	Stock	0.3473	0.3488	0.3413	0.3488	17257000.0
2013-05-08 17:00:00	NVDA	Stock	0.3488	0.3488	0.3488	0.3488	8000.0
2013-05-08 18:00:00	NVDA	Stock	0.3488	0.3498	0.3488	0.3488	112000.0
2013-05-08 19:00:00	NVDA	Stock	0.3488	0.35	0.3488	0.35	39400.0
2013-05-08 04:00:00	AMZN	Stock	12.9	12.9	12.9	12.9	2000.0
2013-05-08 05:00:00	AMZN	Stock	12.9205	12.9205	12.9205	12.9205	2000.0
2013-05-08 07:00:00	AMZN	Stock	12.9125	12.9375	12.9125	12.9375	20000.0
2013-05-08 08:00:00	AMZN	Stock	12.9125	12.9495	12.885	12.885	116720.0
2013-05-08 09:00:00	AMZN	Stock	12.89	12.9203	12.7667	12.914	8096420.0
2013-05-08 10:00:00	AMZN	Stock	12.914	12.9655	12.885	12.9518	8775440.0
2013-05-08 11:00:00	AMZN	Stock	12.95	13.009	12.93	13.0025	8014440.0
2013-05-08 12:00:00	AMZN	Stock	13.0038	13.0148	12.961	13.004	4167220.0

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

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