PREVIEW / stock_30min / 2014-06-05

all stock 30-min files

  file:    by_date/stock_30min/2014/2014-06-05.parquet
  size:    1.6 MB
  rows:    83,532
  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:30:00	AAPL	Stock	23.0571	23.0571	23.0571	23.0571	2800.0
2014-06-05 07:00:00	AAPL	Stock	23.0714	23.0968	23.0714	23.0964	137648.0
2014-06-05 07:30:00	AAPL	Stock	23.0893	23.1036	23.0539	23.0714	351736.0
2014-06-05 08:00:00	AAPL	Stock	23.0714	23.1071	23.0575	23.0921	622216.0
2014-06-05 08:30:00	AAPL	Stock	23.0793	23.1007	23.0793	23.1007	915768.0
2014-06-05 09:00:00	AAPL	Stock	23.0979	23.1007	23.0714	23.0782	980336.0
2014-06-05 09:30:00	AAPL	Stock	23.0786	23.1918	23.045	23.1079	51381232.0
2014-06-05 10:00:00	AAPL	Stock	23.1089	23.1286	22.9504	23.0843	37226700.0
2014-06-05 10:30:00	AAPL	Stock	23.0846	23.1129	23.0293	23.0754	16928856.0
2014-06-05 11:00:00	AAPL	Stock	23.075	23.0889	22.9846	23.0214	15610168.0
2014-06-05 11:30:00	AAPL	Stock	23.0235	23.0443	22.9689	23.0086	13239380.0
2014-06-05 12:00:00	AAPL	Stock	23.0143	23.0714	23.0134	23.0275	10368596.0
2014-06-05 12:30:00	AAPL	Stock	23.0275	23.0889	23.0236	23.0442	10264968.0
2014-06-05 13:00:00	AAPL	Stock	23.0482	23.0789	22.9804	23.002	9192120.0
2014-06-05 13:30:00	AAPL	Stock	23.0011	23.0296	22.9832	23.0154	5754756.0
2014-06-05 14:00:00	AAPL	Stock	23.0143	23.1246	23.0093	23.1143	11723880.0
2014-06-05 14:30:00	AAPL	Stock	23.1161	23.1179	23.0581	23.085	8406636.0
2014-06-05 15:00:00	AAPL	Stock	23.0884	23.1046	23.0318	23.0486	9410548.0
2014-06-05 15:30:00	AAPL	Stock	23.0507	23.1196	23.0386	23.1196	20120072.0
2014-06-05 16:00:00	AAPL	Stock	23.1161	23.1199	23.0674	23.1018	7464632.0
2014-06-05 16:30:00	AAPL	Stock	23.1007	23.1243	23.0896	23.1043	554400.0
2014-06-05 17:00:00	AAPL	Stock	23.095	23.1196	23.095	23.1021	161616.0
2014-06-05 17:30:00	AAPL	Stock	23.1014	23.1018	23.0946	23.0946	93016.0
2014-06-05 18:00:00	AAPL	Stock	23.1007	23.1018	23.0932	23.1014	114940.0
2014-06-05 18:30:00	AAPL	Stock	23.1196	23.1196	23.0939	23.0982	128604.0
2014-06-05 19:00:00	AAPL	Stock	23.0918	23.1054	23.0918	23.1	96264.0
2014-06-05 19:30:00	AAPL	Stock	23.1011	23.1068	23.0929	23.1068	56224.0
2014-06-05 04:00:00	MSFT	Stock	40.45	40.45	40.45	40.45	1200.0
2014-06-05 04:30:00	MSFT	Stock	40.77	40.86	40.77	40.86	3020.0
2014-06-05 05:30:00	MSFT	Stock	40.59	40.59	40.59	40.59	200.0
2014-06-05 06:30:00	MSFT	Stock	40.58	40.58	40.56	40.56	1900.0
2014-06-05 07:30: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.57	35120.0
2014-06-05 08:30:00	MSFT	Stock	40.66	40.68	40.66	40.67	13142.0
2014-06-05 09:00:00	MSFT	Stock	40.62	40.62	40.49	40.55	19988.0
2014-06-05 09:30:00	MSFT	Stock	40.58	40.6	40.42	40.545	3381158.0
2014-06-05 10:00:00	MSFT	Stock	40.55	40.55	40.4	40.53	1683381.0
2014-06-05 10:30:00	MSFT	Stock	40.52	40.68	40.5	40.675	1857928.0
2014-06-05 11:00:00	MSFT	Stock	40.67	40.68	40.57	40.62	1494081.0
2014-06-05 11:30:00	MSFT	Stock	40.62	40.82	40.58	40.81	1157479.0
2014-06-05 12:00:00	MSFT	Stock	40.803	40.91	40.8	40.856	1462358.0
2014-06-05 12:30:00	MSFT	Stock	40.855	40.97	40.85	40.935	1411187.0
2014-06-05 13:00:00	MSFT	Stock	40.93	40.97	40.92	40.96	977269.0
2014-06-05 13:30:00	MSFT	Stock	40.965	41.0	40.95	41.0	1125577.0
2014-06-05 14:00:00	MSFT	Stock	40.99	41.14	40.98	41.115	1647294.0
2014-06-05 14:30:00	MSFT	Stock	41.12	41.25	41.11	41.166	2447800.0
2014-06-05 15:00:00	MSFT	Stock	41.16	41.19	41.11	41.115	2327912.0
2014-06-05 15:30:00	MSFT	Stock	41.115	41.24	41.1	41.2	6173472.0
2014-06-05 16:00:00	MSFT	Stock	41.21	41.25	40.911	41.25	3348706.0

> showing 50 of 83,532 rows — these rows as CSV

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