PREVIEW / stock_1hour / 2013-07-17

all stock 1-hour files

  file:    by_date/stock_1hour/2013/2013-07-17.parquet
  size:    989 KB
  rows:    46,025
  symbols: 3,497

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-17 05:00:00	AAPL	Stock	15.335	15.335	15.3186	15.3221	32004.0
2013-07-17 06:00:00	AAPL	Stock	15.3218	15.3221	15.3161	15.3161	66640.0
2013-07-17 07:00:00	AAPL	Stock	15.3214	15.3414	15.2518	15.2786	759724.0
2013-07-17 08:00:00	AAPL	Stock	15.2893	15.3571	15.2893	15.3375	1322104.0
2013-07-17 09:00:00	AAPL	Stock	15.3446	15.4364	15.2936	15.385	41731676.0
2013-07-17 10:00:00	AAPL	Stock	15.3914	15.4357	15.3268	15.3768	37298912.0
2013-07-17 11:00:00	AAPL	Stock	15.3768	15.3989	15.325	15.3415	19202568.0
2013-07-17 12:00:00	AAPL	Stock	15.3404	15.3782	15.3321	15.3607	16086000.0
2013-07-17 13:00:00	AAPL	Stock	15.3589	15.3804	15.3482	15.3632	12404056.0
2013-07-17 14:00:00	AAPL	Stock	15.3575	15.3714	15.3232	15.3421	18931500.0
2013-07-17 15:00:00	AAPL	Stock	15.3382	15.3714	15.3268	15.3679	27725208.0
2013-07-17 16:00:00	AAPL	Stock	15.3636	15.3886	15.3435	15.3646	20441624.0
2013-07-17 17:00:00	AAPL	Stock	15.3689	15.3736	15.3686	15.3736	28392.0
2013-07-17 18:00:00	AAPL	Stock	15.3764	15.3768	15.3732	15.3732	23100.0
2013-07-17 19:00:00	AAPL	Stock	15.3764	15.3764	15.3679	15.3729	60480.0
2013-07-17 07:00:00	MSFT	Stock	36.25	36.25	36.25	36.25	200.0
2013-07-17 08:00:00	MSFT	Stock	36.15	36.34	36.15	36.34	6840.0
2013-07-17 09:00:00	MSFT	Stock	36.35	36.42	36.02	36.115	3687277.0
2013-07-17 10:00:00	MSFT	Stock	36.12	36.14	35.9	35.975	6698084.0
2013-07-17 11:00:00	MSFT	Stock	35.975	36.055	35.87	36.05	3242339.0
2013-07-17 12:00:00	MSFT	Stock	36.045	36.15	36.04	36.08	1836235.0
2013-07-17 13:00:00	MSFT	Stock	36.09	36.14	35.79	35.84	3798608.0
2013-07-17 14:00:00	MSFT	Stock	35.84	35.915	35.49	35.541	6393541.0
2013-07-17 15:00:00	MSFT	Stock	35.55	35.75	35.5	35.73	6787040.0
2013-07-17 16:00:00	MSFT	Stock	35.72	36.029	35.611	35.68	2596340.0
2013-07-17 17:00:00	MSFT	Stock	36.11	36.11	35.56	35.64	3890.0
2013-07-17 18:00:00	MSFT	Stock	35.64	35.65	35.6	35.6	5500.0
2013-07-17 19:00:00	MSFT	Stock	35.6	35.65	35.6	35.61	2304.0
2013-07-17 08:00:00	NVDA	Stock	0.356	0.356	0.356	0.356	83560.0
2013-07-17 09:00:00	NVDA	Stock	0.369	0.369	0.365	0.3662	20985560.0
2013-07-17 10:00:00	NVDA	Stock	0.3662	0.3678	0.365	0.366	33582480.0
2013-07-17 11:00:00	NVDA	Stock	0.366	0.3665	0.3648	0.365	23476400.0
2013-07-17 12:00:00	NVDA	Stock	0.365	0.366	0.3646	0.3648	17465760.0
2013-07-17 13:00:00	NVDA	Stock	0.365	0.3658	0.3645	0.3652	15302880.0
2013-07-17 14:00:00	NVDA	Stock	0.3654	0.366	0.3648	0.3649	14236080.0
2013-07-17 15:00:00	NVDA	Stock	0.365	0.3652	0.3642	0.3652	33571720.0
2013-07-17 16:00:00	NVDA	Stock	0.3652	0.3655	0.3652	0.3652	907880.0
2013-07-17 18:00:00	NVDA	Stock	0.3652	0.3652	0.3652	0.3652	117600.0
2013-07-17 06:00:00	AMZN	Stock	15.325	15.335	15.325	15.335	6000.0
2013-07-17 07:00:00	AMZN	Stock	15.399	15.399	15.345	15.365	8000.0
2013-07-17 08:00:00	AMZN	Stock	15.3575	15.38	15.3	15.35	113000.0
2013-07-17 09:00:00	AMZN	Stock	15.371	15.44	15.3	15.435	8366220.0
2013-07-17 10:00:00	AMZN	Stock	15.4225	15.4225	15.285	15.3275	9291560.0
2013-07-17 11:00:00	AMZN	Stock	15.327	15.354	15.2845	15.332	4410340.0
2013-07-17 12:00:00	AMZN	Stock	15.332	15.3735	15.3215	15.3585	3753800.0
2013-07-17 13:00:00	AMZN	Stock	15.3605	15.3815	15.3466	15.3715	1936640.0
2013-07-17 14:00:00	AMZN	Stock	15.3735	15.3865	15.3425	15.3725	2764920.0
2013-07-17 15:00:00	AMZN	Stock	15.37	15.436	15.3625	15.4345	7434700.0
2013-07-17 16:00:00	AMZN	Stock	15.4345	15.4345	15.3175	15.3365	2316220.0
2013-07-17 17:00:00	AMZN	Stock	15.315	15.34	15.315	15.34	112960.0

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

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