PREVIEW / stock_1hour / 2014-06-30

all stock 1-hour files

  file:    by_date/stock_1hour/2014/2014-06-30.parquet
  size:    1.1 MB
  rows:    49,618
  symbols: 3,598

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
2014-06-30 04:00:00	AAPL	Stock	23.0275	23.1025	23.0275	23.075	10356.0
2014-06-30 05:00:00	AAPL	Stock	23.0825	23.09	23.0	23.0	19992.0
2014-06-30 06:00:00	AAPL	Stock	23.035	23.055	23.02	23.05	33116.0
2014-06-30 07:00:00	AAPL	Stock	23.05	23.065	23.0275	23.045	72016.0
2014-06-30 08:00:00	AAPL	Stock	23.0375	23.065	22.995	23.03	744000.0
2014-06-30 09:00:00	AAPL	Stock	23.03	23.2075	23.0175	23.1575	28772548.0
2014-06-30 10:00:00	AAPL	Stock	23.1575	23.19	23.09	23.1688	20930824.0
2014-06-30 11:00:00	AAPL	Stock	23.1698	23.2	23.14	23.1725	16507944.0
2014-06-30 12:00:00	AAPL	Stock	23.1735	23.1975	23.14	23.1875	11171652.0
2014-06-30 13:00:00	AAPL	Stock	23.1868	23.3375	23.1825	23.3355	22581836.0
2014-06-30 14:00:00	AAPL	Stock	23.3362	23.4312	23.325	23.33	25834916.0
2014-06-30 15:00:00	AAPL	Stock	23.3288	23.375	23.2325	23.24	35740432.0
2014-06-30 16:00:00	AAPL	Stock	23.24	23.2975	23.155	23.2975	19325076.0
2014-06-30 17:00:00	AAPL	Stock	23.295	23.2975	23.2325	23.2825	147852.0
2014-06-30 18:00:00	AAPL	Stock	23.275	23.2875	23.2325	23.2625	319640.0
2014-06-30 19:00:00	AAPL	Stock	23.2625	23.2875	23.26	23.28	58180.0
2014-06-30 05:00:00	MSFT	Stock	42.23	42.23	42.23	42.23	500.0
2014-06-30 06:00:00	MSFT	Stock	42.27	42.27	42.27	42.27	200.0
2014-06-30 07:00:00	MSFT	Stock	42.23	42.23	42.14	42.14	1950.0
2014-06-30 08:00:00	MSFT	Stock	42.13	42.22	42.13	42.2	2574.0
2014-06-30 09:00:00	MSFT	Stock	42.19	42.21	41.94	42.11	4054033.0
2014-06-30 10:00:00	MSFT	Stock	42.1	42.18	41.92	41.93	3806977.0
2014-06-30 11:00:00	MSFT	Stock	41.93	42.03	41.88	41.88	1829493.0
2014-06-30 12:00:00	MSFT	Stock	41.88	42.02	41.88	41.925	2068220.0
2014-06-30 13:00:00	MSFT	Stock	41.93	41.99	41.89	41.9	1925020.0
2014-06-30 14:00:00	MSFT	Stock	41.89	41.93	41.73	41.75	2812008.0
2014-06-30 15:00:00	MSFT	Stock	41.76	41.8	41.7	41.7	7289357.0
2014-06-30 16:00:00	MSFT	Stock	41.7	41.883	41.698	41.7	5777369.0
2014-06-30 17:00:00	MSFT	Stock	41.76	41.79	41.7	41.79	23171.0
2014-06-30 18:00:00	MSFT	Stock	41.79	41.79	41.79	41.79	5785.0
2014-06-30 19:00:00	MSFT	Stock	41.79	41.79	41.74	41.74	6410.0
2014-06-30 09:00:00	NVDA	Stock	0.4578	0.4643	0.4578	0.463	26669360.0
2014-06-30 10:00:00	NVDA	Stock	0.463	0.4648	0.4622	0.463	31578280.0
2014-06-30 11:00:00	NVDA	Stock	0.4632	0.464	0.4622	0.4626	19458440.0
2014-06-30 12:00:00	NVDA	Stock	0.4626	0.4635	0.4612	0.4628	15622800.0
2014-06-30 13:00:00	NVDA	Stock	0.4628	0.4643	0.462	0.4622	20456680.0
2014-06-30 14:00:00	NVDA	Stock	0.462	0.4635	0.462	0.462	9681000.0
2014-06-30 15:00:00	NVDA	Stock	0.462	0.4638	0.4618	0.4633	37914800.0
2014-06-30 16:00:00	NVDA	Stock	0.4635	0.4636	0.4634	0.4635	15987560.0
2014-06-30 19:00:00	NVDA	Stock	0.4635	0.4635	0.4635	0.4635	53960.0
2014-06-30 07:00:00	AMZN	Stock	16.2235	16.2235	16.2235	16.2235	3420.0
2014-06-30 08:00:00	AMZN	Stock	16.16	16.2575	16.1595	16.255	64140.0
2014-06-30 09:00:00	AMZN	Stock	16.2495	16.349	16.166	16.191	7560180.0
2014-06-30 10:00:00	AMZN	Stock	16.1852	16.2625	16.112	16.145	10282080.0
2014-06-30 11:00:00	AMZN	Stock	16.144	16.218	16.142	16.192	4557080.0
2014-06-30 12:00:00	AMZN	Stock	16.19	16.2	16.1435	16.1515	4351240.0
2014-06-30 13:00:00	AMZN	Stock	16.1515	16.243	16.1515	16.2118	4168100.0
2014-06-30 14:00:00	AMZN	Stock	16.2205	16.244	16.1935	16.2105	3785440.0
2014-06-30 15:00:00	AMZN	Stock	16.2115	16.2564	16.2098	16.2395	9720860.0
2014-06-30 16:00:00	AMZN	Stock	16.239	16.25	16.2132	16.2389	1225920.0

> showing 50 of 49,618 rows — these rows as CSV

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