PREVIEW / stock_1hour / 2014-03-28

all stock 1-hour files

  file:    by_date/stock_1hour/2014/2014-03-28.parquet
  size:    1.0 MB
  rows:    48,493
  symbols: 3,553

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-03-28 04:00:00	AAPL	Stock	19.2657	19.2657	19.2657	19.2657	2800.0
2014-03-28 05:00:00	AAPL	Stock	19.2739	19.2786	19.2739	19.2786	67200.0
2014-03-28 06:00:00	AAPL	Stock	19.2786	19.3214	19.2786	19.2971	67116.0
2014-03-28 07:00:00	AAPL	Stock	19.31	19.32	19.2607	19.2857	158480.0
2014-03-28 08:00:00	AAPL	Stock	19.2857	19.3021	19.2446	19.2571	547876.0
2014-03-28 09:00:00	AAPL	Stock	19.2629	19.2679	19.1475	19.192	29206996.0
2014-03-28 10:00:00	AAPL	Stock	19.1964	19.2231	19.1618	19.2104	19246780.0
2014-03-28 11:00:00	AAPL	Stock	19.2075	19.2146	19.1607	19.1889	22456224.0
2014-03-28 12:00:00	AAPL	Stock	19.1886	19.2207	19.18	19.1993	10421292.0
2014-03-28 13:00:00	AAPL	Stock	19.2004	19.2014	19.1289	19.1457	18747708.0
2014-03-28 14:00:00	AAPL	Stock	19.1407	19.145	19.0804	19.1133	24477600.0
2014-03-28 15:00:00	AAPL	Stock	19.1146	19.1757	19.0986	19.1736	35157052.0
2014-03-28 16:00:00	AAPL	Stock	19.1736	19.1971	19.1632	19.1946	6182288.0
2014-03-28 17:00:00	AAPL	Stock	19.1964	19.2032	19.1736	19.1954	650244.0
2014-03-28 18:00:00	AAPL	Stock	19.1954	19.2114	19.1736	19.21	1388940.0
2014-03-28 19:00:00	AAPL	Stock	19.21	19.2143	19.1964	19.2068	106316.0
2014-03-28 05:00:00	MSFT	Stock	39.44	39.44	39.44	39.44	110.0
2014-03-28 06:00:00	MSFT	Stock	39.86	39.86	39.6	39.64	4450.0
2014-03-28 07:00:00	MSFT	Stock	39.69	39.69	39.61	39.61	1000.0
2014-03-28 08:00:00	MSFT	Stock	39.69	39.75	39.6	39.65	22477.0
2014-03-28 09:00:00	MSFT	Stock	39.72	40.43	39.68	40.27	8078765.0
2014-03-28 10:00:00	MSFT	Stock	40.28	40.635	40.26	40.52	10753275.0
2014-03-28 11:00:00	MSFT	Stock	40.51	40.52	40.32	40.45	4481937.0
2014-03-28 12:00:00	MSFT	Stock	40.44	40.556	40.41	40.496	3402725.0
2014-03-28 13:00:00	MSFT	Stock	40.5	40.51	40.35	40.42	2561637.0
2014-03-28 14:00:00	MSFT	Stock	40.41	40.41	40.07	40.124	4428361.0
2014-03-28 15:00:00	MSFT	Stock	40.13	40.32	40.12	40.29	6644666.0
2014-03-28 16:00:00	MSFT	Stock	40.3	40.421	40.172	40.292	2057761.0
2014-03-28 17:00:00	MSFT	Stock	40.28	40.31	40.244	40.31	12747.0
2014-03-28 18:00:00	MSFT	Stock	40.32	40.32	40.3	40.3	45250.0
2014-03-28 19:00:00	MSFT	Stock	40.32	40.32	40.32	40.32	1000.0
2014-03-28 09:00:00	NVDA	Stock	0.4448	0.448	0.4428	0.4469	33480680.0
2014-03-28 10:00:00	NVDA	Stock	0.4469	0.4502	0.4468	0.4494	95548080.0
2014-03-28 11:00:00	NVDA	Stock	0.4494	0.4496	0.447	0.4495	31909040.0
2014-03-28 12:00:00	NVDA	Stock	0.4498	0.45	0.4482	0.4498	44744040.0
2014-03-28 13:00:00	NVDA	Stock	0.45	0.45	0.448	0.4494	25580520.0
2014-03-28 14:00:00	NVDA	Stock	0.4495	0.45	0.448	0.4489	21444040.0
2014-03-28 15:00:00	NVDA	Stock	0.449	0.4492	0.4472	0.4472	123533960.0
2014-03-28 16:00:00	NVDA	Stock	0.4475	0.448	0.4462	0.4474	17560400.0
2014-03-28 17:00:00	NVDA	Stock	0.4498	0.4498	0.4498	0.4498	4000.0
2014-03-28 19:00:00	NVDA	Stock	0.4498	0.4498	0.4498	0.4498	8000.0
2014-03-28 05:00:00	AMZN	Stock	17.064	17.064	17.05	17.05	4000.0
2014-03-28 07:00:00	AMZN	Stock	17.0195	17.025	17.0195	17.025	4000.0
2014-03-28 08:00:00	AMZN	Stock	17.0425	17.1205	17.0425	17.0725	269600.0
2014-03-28 09:00:00	AMZN	Stock	17.061	17.2105	16.9235	17.0775	13168500.0
2014-03-28 10:00:00	AMZN	Stock	17.0895	17.35	17.0835	17.295	15611540.0
2014-03-28 11:00:00	AMZN	Stock	17.3015	17.3275	17.211	17.238	7533720.0
2014-03-28 12:00:00	AMZN	Stock	17.2405	17.2565	17.1005	17.1748	5305920.0
2014-03-28 13:00:00	AMZN	Stock	17.1734	17.1865	17.05	17.055	4501540.0
2014-03-28 14:00:00	AMZN	Stock	17.0545	17.0545	16.804	16.9	12120780.0

> showing 50 of 48,493 rows — these rows as CSV

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