PREVIEW / stock_30min / 2013-07-08

all stock 30-min files

  file:    by_date/stock_30min/2013/2013-07-08.parquet
  size:    1.5 MB
  rows:    79,860
  symbols: 3,510

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-08 04:00:00	AAPL	Stock	14.9629	14.9629	14.9629	14.9629	13468.0
2013-07-08 05:00:00	AAPL	Stock	15.0	15.0	15.0	15.0	4200.0
2013-07-08 06:00:00	AAPL	Stock	14.9989	14.9989	14.9929	14.9929	24808.0
2013-07-08 06:30:00	AAPL	Stock	14.9964	14.9964	14.9964	14.9964	12880.0
2013-07-08 07:00:00	AAPL	Stock	14.9979	15.0089	14.9864	14.9929	132188.0
2013-07-08 07:30:00	AAPL	Stock	14.9929	14.9929	14.9671	14.9732	137816.0
2013-07-08 08:00:00	AAPL	Stock	15.0	15.0	14.8571	14.9571	422016.0
2013-07-08 08:30:00	AAPL	Stock	14.9575	14.9639	14.95	14.9536	527268.0
2013-07-08 09:00:00	AAPL	Stock	14.955	15.0893	14.955	15.0011	2105432.0
2013-07-08 09:30:00	AAPL	Stock	15.0036	15.0357	14.7775	14.7993	56179032.0
2013-07-08 10:00:00	AAPL	Stock	14.7993	14.8443	14.7232	14.7271	35915516.0
2013-07-08 10:30:00	AAPL	Stock	14.7368	14.7629	14.6661	14.7118	42741720.0
2013-07-08 11:00:00	AAPL	Stock	14.7111	14.8154	14.7111	14.8004	26974920.0
2013-07-08 11:30:00	AAPL	Stock	14.8004	14.8068	14.7721	14.7893	13337268.0
2013-07-08 12:00:00	AAPL	Stock	14.7879	14.7964	14.7607	14.7679	11915148.0
2013-07-08 12:30:00	AAPL	Stock	14.7664	14.7857	14.7375	14.7411	9402288.0
2013-07-08 13:00:00	AAPL	Stock	14.7411	14.7829	14.7257	14.7493	9150484.0
2013-07-08 13:30:00	AAPL	Stock	14.7493	14.7775	14.7296	14.7593	8856092.0
2013-07-08 14:00:00	AAPL	Stock	14.7596	14.7793	14.7189	14.7282	6439776.0
2013-07-08 14:30:00	AAPL	Stock	14.7293	14.775	14.7161	14.7746	9532012.0
2013-07-08 15:00:00	AAPL	Stock	14.7756	14.8143	14.7571	14.7729	14978768.0
2013-07-08 15:30:00	AAPL	Stock	14.7743	14.8314	14.7521	14.825	25087188.0
2013-07-08 16:00:00	AAPL	Stock	14.8158	14.825	14.7643	14.8145	16077628.0
2013-07-08 16:30:00	AAPL	Stock	14.8226	14.8232	14.7752	14.8071	1026956.0
2013-07-08 17:00:00	AAPL	Stock	14.8118	14.8232	14.8004	14.8071	1376228.0
2013-07-08 17:30:00	AAPL	Stock	14.8071	14.8232	14.7946	14.8	176344.0
2013-07-08 18:00:00	AAPL	Stock	14.8036	14.8036	14.7982	14.8	53200.0
2013-07-08 18:30:00	AAPL	Stock	14.7982	14.7982	14.7857	14.7857	37856.0
2013-07-08 19:00:00	AAPL	Stock	14.7875	14.7964	14.7875	14.7875	34216.0
2013-07-08 19:30:00	AAPL	Stock	14.7893	14.7893	14.7786	14.7857	102816.0
2013-07-08 07:30:00	MSFT	Stock	34.21	34.21	34.21	34.21	102.0
2013-07-08 08:00:00	MSFT	Stock	34.2	34.33	34.16	34.33	4809.0
2013-07-08 08:30:00	MSFT	Stock	34.25	34.33	34.25	34.26	3166.0
2013-07-08 09:00:00	MSFT	Stock	34.25	34.37	34.25	34.32	57609.0
2013-07-08 09:30:00	MSFT	Stock	34.35	34.59	34.15	34.49	3809445.0
2013-07-08 10:00:00	MSFT	Stock	34.49	34.55	34.345	34.459	2363132.0
2013-07-08 10:30:00	MSFT	Stock	34.45	34.46	34.35	34.46	1657107.0
2013-07-08 11:00:00	MSFT	Stock	34.455	34.46	34.09	34.13	1951286.0
2013-07-08 11:30:00	MSFT	Stock	34.14	34.17	34.033	34.13	3519144.0
2013-07-08 12:00:00	MSFT	Stock	34.125	34.16	34.05	34.056	2091709.0
2013-07-08 12:30:00	MSFT	Stock	34.055	34.1	33.98	34.05	1686339.0
2013-07-08 13:00:00	MSFT	Stock	34.045	34.16	34.03	34.126	1244907.0
2013-07-08 13:30:00	MSFT	Stock	34.12	34.29	34.12	34.26	859360.0
2013-07-08 14:00:00	MSFT	Stock	34.26	34.29	34.16	34.175	922480.0
2013-07-08 14:30:00	MSFT	Stock	34.18	34.27	34.175	34.27	624587.0
2013-07-08 15:00:00	MSFT	Stock	34.265	34.27	34.16	34.17	1036130.0
2013-07-08 15:30:00	MSFT	Stock	34.17	34.37	34.15	34.33	3767555.0
2013-07-08 16:00:00	MSFT	Stock	34.33	34.348	34.11	34.33	5471790.0
2013-07-08 16:30:00	MSFT	Stock	34.314	34.337	34.18	34.337	250090.0
2013-07-08 17:00:00	MSFT	Stock	34.26	34.33	34.26	34.33	387904.0

> showing 50 of 79,860 rows — these rows as CSV

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