PREVIEW / stock_1hour / 2013-07-15

all stock 1-hour files

  file:    by_date/stock_1hour/2013/2013-07-15.parquet
  size:    995 KB
  rows:    46,238
  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
2013-07-15 04:00:00	AAPL	Stock	15.2586	15.2586	15.2586	15.2586	5600.0
2013-07-15 06:00:00	AAPL	Stock	15.2329	15.2329	15.2329	15.2329	2800.0
2013-07-15 07:00:00	AAPL	Stock	15.2321	15.2325	15.1989	15.1989	23548.0
2013-07-15 08:00:00	AAPL	Stock	15.1807	15.2321	15.1696	15.2146	1074640.0
2013-07-15 09:00:00	AAPL	Stock	15.2143	15.3143	15.1714	15.2914	37852864.0
2013-07-15 10:00:00	AAPL	Stock	15.2929	15.4093	15.2629	15.3368	58767492.0
2013-07-15 11:00:00	AAPL	Stock	15.3382	15.3821	15.3143	15.3443	19195148.0
2013-07-15 12:00:00	AAPL	Stock	15.3482	15.3714	15.2989	15.3286	13822844.0
2013-07-15 13:00:00	AAPL	Stock	15.3271	15.3532	15.305	15.3454	12584964.0
2013-07-15 14:00:00	AAPL	Stock	15.3475	15.3679	15.31	15.3507	18113256.0
2013-07-15 15:00:00	AAPL	Stock	15.3475	15.3564	15.2573	15.2657	34070400.0
2013-07-15 16:00:00	AAPL	Stock	15.2668	15.3222	15.2611	15.2643	32345992.0
2013-07-15 17:00:00	AAPL	Stock	15.2643	15.2679	15.2625	15.2643	86772.0
2013-07-15 18:00:00	AAPL	Stock	15.2643	15.2679	15.2632	15.2664	26740.0
2013-07-15 19:00:00	AAPL	Stock	15.2625	15.2643	15.25	15.25	233548.0
2013-07-15 04:00:00	MSFT	Stock	35.67	35.67	35.67	35.67	5000.0
2013-07-15 05:00:00	MSFT	Stock	35.68	35.68	35.68	35.68	3000.0
2013-07-15 06:00:00	MSFT	Stock	35.69	35.69	35.68	35.68	440.0
2013-07-15 07:00:00	MSFT	Stock	35.7	35.7	35.61	35.61	3631.0
2013-07-15 08:00:00	MSFT	Stock	35.65	35.67	35.62	35.66	3506.0
2013-07-15 09:00:00	MSFT	Stock	35.66	35.81	35.58	35.77	3604627.0
2013-07-15 10:00:00	MSFT	Stock	35.77	36.0	35.73	35.97	4658086.0
2013-07-15 11:00:00	MSFT	Stock	35.97	35.99	35.86	35.99	3689566.0
2013-07-15 12:00:00	MSFT	Stock	35.99	36.15	35.96	36.089	4264373.0
2013-07-15 13:00:00	MSFT	Stock	36.085	36.12	36.03	36.055	3075275.0
2013-07-15 14:00:00	MSFT	Stock	36.06	36.09	36.02	36.055	2942415.0
2013-07-15 15:00:00	MSFT	Stock	36.055	36.22	36.05	36.19	8348430.0
2013-07-15 16:00:00	MSFT	Stock	36.19	36.21	35.837	36.17	3216808.0
2013-07-15 17:00:00	MSFT	Stock	36.21	36.23	36.122	36.2	8701.0
2013-07-15 18:00:00	MSFT	Stock	36.2	36.2	36.19	36.19	962.0
2013-07-15 19:00:00	MSFT	Stock	36.2	36.2	36.18	36.18	2558.0
2013-07-15 09:00:00	NVDA	Stock	0.3672	0.3672	0.3595	0.362	36674000.0
2013-07-15 10:00:00	NVDA	Stock	0.3622	0.3642	0.361	0.3634	24614720.0
2013-07-15 11:00:00	NVDA	Stock	0.3635	0.3655	0.3634	0.365	15948320.0
2013-07-15 12:00:00	NVDA	Stock	0.3652	0.3659	0.3642	0.3642	10916320.0
2013-07-15 13:00:00	NVDA	Stock	0.3645	0.3652	0.3642	0.3642	13633560.0
2013-07-15 14:00:00	NVDA	Stock	0.3643	0.365	0.3628	0.3629	17327800.0
2013-07-15 15:00:00	NVDA	Stock	0.3628	0.3652	0.3628	0.3651	51708760.0
2013-07-15 16:00:00	NVDA	Stock	0.365	0.3657	0.3638	0.3652	23124360.0
2013-07-15 17:00:00	NVDA	Stock	0.3645	0.3645	0.3645	0.3645	6000.0
2013-07-15 06:00:00	AMZN	Stock	15.355	15.359	15.355	15.359	52000.0
2013-07-15 07:00:00	AMZN	Stock	15.355	15.3975	15.35	15.3975	15800.0
2013-07-15 08:00:00	AMZN	Stock	15.385	15.3895	15.361	15.3775	92660.0
2013-07-15 09:00:00	AMZN	Stock	15.3775	15.3995	15.274	15.309	9869120.0
2013-07-15 10:00:00	AMZN	Stock	15.314	15.3566	15.232	15.2615	9196280.0
2013-07-15 11:00:00	AMZN	Stock	15.262	15.2985	15.2425	15.2635	3239480.0
2013-07-15 12:00:00	AMZN	Stock	15.2665	15.274	15.2175	15.2635	3964820.0
2013-07-15 13:00:00	AMZN	Stock	15.2635	15.2863	15.253	15.2615	3316520.0
2013-07-15 14:00:00	AMZN	Stock	15.2615	15.333	15.252	15.31	4511320.0
2013-07-15 15:00:00	AMZN	Stock	15.311	15.3395	15.3095	15.3305	7061160.0

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

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