PREVIEW / stock_1hour / 2014-06-05

all stock 1-hour files

  file:    by_date/stock_1hour/2014/2014-06-05.parquet
  size:    1.0 MB
  rows:    49,112
  symbols: 3,538

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-05 05:00:00	AAPL	Stock	23.0536	23.0536	23.0536	23.0536	2800.0
2014-06-05 06:00:00	AAPL	Stock	23.0571	23.0571	23.0571	23.0571	2800.0
2014-06-05 07:00:00	AAPL	Stock	23.0714	23.1036	23.0539	23.0714	489384.0
2014-06-05 08:00:00	AAPL	Stock	23.0714	23.1071	23.0575	23.1007	1537984.0
2014-06-05 09:00:00	AAPL	Stock	23.0979	23.1918	23.045	23.1079	52361568.0
2014-06-05 10:00:00	AAPL	Stock	23.1089	23.1286	22.9504	23.0754	54155556.0
2014-06-05 11:00:00	AAPL	Stock	23.075	23.0889	22.9689	23.0086	28849548.0
2014-06-05 12:00:00	AAPL	Stock	23.0143	23.0889	23.0134	23.0442	20633564.0
2014-06-05 13:00:00	AAPL	Stock	23.0482	23.0789	22.9804	23.0154	14946876.0
2014-06-05 14:00:00	AAPL	Stock	23.0143	23.1246	23.0093	23.085	20130516.0
2014-06-05 15:00:00	AAPL	Stock	23.0884	23.1196	23.0318	23.1196	29530620.0
2014-06-05 16:00:00	AAPL	Stock	23.1161	23.1243	23.0674	23.1043	8019032.0
2014-06-05 17:00:00	AAPL	Stock	23.095	23.1196	23.0946	23.0946	254632.0
2014-06-05 18:00:00	AAPL	Stock	23.1007	23.1196	23.0932	23.0982	243544.0
2014-06-05 19:00:00	AAPL	Stock	23.0918	23.1068	23.0918	23.1068	152488.0
2014-06-05 04:00:00	MSFT	Stock	40.45	40.86	40.45	40.86	4220.0
2014-06-05 05:00:00	MSFT	Stock	40.59	40.59	40.59	40.59	200.0
2014-06-05 06:00:00	MSFT	Stock	40.58	40.58	40.56	40.56	1900.0
2014-06-05 07:00:00	MSFT	Stock	40.67	40.71	40.67	40.71	770.0
2014-06-05 08:00:00	MSFT	Stock	40.7	40.74	40.57	40.67	48262.0
2014-06-05 09:00:00	MSFT	Stock	40.62	40.62	40.42	40.545	3401146.0
2014-06-05 10:00:00	MSFT	Stock	40.55	40.68	40.4	40.675	3541309.0
2014-06-05 11:00:00	MSFT	Stock	40.67	40.82	40.57	40.81	2651560.0
2014-06-05 12:00:00	MSFT	Stock	40.803	40.97	40.8	40.935	2873545.0
2014-06-05 13:00:00	MSFT	Stock	40.93	41.0	40.92	41.0	2102846.0
2014-06-05 14:00:00	MSFT	Stock	40.99	41.25	40.98	41.166	4095094.0
2014-06-05 15:00:00	MSFT	Stock	41.16	41.24	41.1	41.2	8501384.0
2014-06-05 16:00:00	MSFT	Stock	41.21	41.25	40.911	41.21	3476178.0
2014-06-05 17:00:00	MSFT	Stock	41.22	41.34	41.21	41.31	17683.0
2014-06-05 18:00:00	MSFT	Stock	41.3	41.3	41.21	41.28	16322.0
2014-06-05 19:00:00	MSFT	Stock	41.25	41.28	41.25	41.28	2150.0
2014-06-05 09:00:00	NVDA	Stock	0.4788	0.4788	0.4702	0.4715	24054000.0
2014-06-05 10:00:00	NVDA	Stock	0.4715	0.473	0.47	0.4706	31342360.0
2014-06-05 11:00:00	NVDA	Stock	0.4705	0.4735	0.4705	0.4735	28210360.0
2014-06-05 12:00:00	NVDA	Stock	0.4735	0.4755	0.4735	0.4745	22066280.0
2014-06-05 13:00:00	NVDA	Stock	0.4745	0.4755	0.4735	0.4745	7934080.0
2014-06-05 14:00:00	NVDA	Stock	0.4748	0.4754	0.4742	0.475	19643160.0
2014-06-05 15:00:00	NVDA	Stock	0.475	0.4753	0.4738	0.4738	42532080.0
2014-06-05 16:00:00	NVDA	Stock	0.4753	0.4753	0.4729	0.4741	2656440.0
2014-06-05 04:00:00	AMZN	Stock	15.35	15.35	15.3	15.3	6000.0
2014-06-05 05:00:00	AMZN	Stock	15.3	15.3	15.3	15.3	3300.0
2014-06-05 06:00:00	AMZN	Stock	15.3	15.3	15.3	15.3	5300.0
2014-06-05 07:00:00	AMZN	Stock	15.3635	15.369	15.35	15.35	12600.0
2014-06-05 08:00:00	AMZN	Stock	15.3875	15.45	15.3875	15.45	88520.0
2014-06-05 09:00:00	AMZN	Stock	15.45	15.6235	15.345	15.6235	12579860.0
2014-06-05 10:00:00	AMZN	Stock	15.6225	15.8735	15.56	15.8605	27703400.0
2014-06-05 11:00:00	AMZN	Stock	15.865	15.996	15.825	15.9476	19543020.0
2014-06-05 12:00:00	AMZN	Stock	15.952	16.224	15.9255	16.2038	20759360.0
2014-06-05 13:00:00	AMZN	Stock	16.2015	16.397	16.2	16.2755	24527460.0
2014-06-05 14:00:00	AMZN	Stock	16.2755	16.3705	16.1565	16.189	13701660.0

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

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