PREVIEW / stock_30min / 2014-01-22

all stock 30-min files

  file:    by_date/stock_30min/2014/2014-01-22.parquet
  size:    1.6 MB
  rows:    82,018
  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-01-22 05:00:00	AAPL	Stock	19.575	19.575	19.5732	19.575	16800.0
2014-01-22 06:00:00	AAPL	Stock	19.575	19.575	19.575	19.575	2800.0
2014-01-22 06:30:00	AAPL	Stock	19.5757	19.5757	19.5757	19.5757	2800.0
2014-01-22 07:00:00	AAPL	Stock	19.5979	19.6411	19.5979	19.6329	100716.0
2014-01-22 07:30:00	AAPL	Stock	19.6389	19.6954	19.6389	19.6764	210224.0
2014-01-22 08:00:00	AAPL	Stock	19.6725	19.6954	19.6564	19.6564	629356.0
2014-01-22 08:30:00	AAPL	Stock	19.6589	19.6929	19.6557	19.6921	491344.0
2014-01-22 09:00:00	AAPL	Stock	19.6929	19.6946	19.6643	19.6714	357420.0
2014-01-22 09:30:00	AAPL	Stock	19.675	19.7357	19.5646	19.6414	40477780.0
2014-01-22 10:00:00	AAPL	Stock	19.6408	19.7607	19.6368	19.7418	27308960.0
2014-01-22 10:30:00	AAPL	Stock	19.7452	19.8725	19.7268	19.8646	55970852.0
2014-01-22 11:00:00	AAPL	Stock	19.8704	19.9032	19.8332	19.8471	26396328.0
2014-01-22 11:30:00	AAPL	Stock	19.8462	19.8718	19.8046	19.8482	17505040.0
2014-01-22 12:00:00	AAPL	Stock	19.8486	19.8936	19.8246	19.8393	17938424.0
2014-01-22 12:30:00	AAPL	Stock	19.8364	19.8629	19.8161	19.8296	12939584.0
2014-01-22 13:00:00	AAPL	Stock	19.8296	19.8321	19.7029	19.7414	24766476.0
2014-01-22 13:30:00	AAPL	Stock	19.74	19.748	19.665	19.6964	22315552.0
2014-01-22 14:00:00	AAPL	Stock	19.7	19.7571	19.6846	19.7404	11747064.0
2014-01-22 14:30:00	AAPL	Stock	19.7404	19.7539	19.6804	19.6921	10348464.0
2014-01-22 15:00:00	AAPL	Stock	19.6961	19.7282	19.6861	19.6904	8446088.0
2014-01-22 15:30:00	AAPL	Stock	19.6905	19.7282	19.6732	19.6968	22569848.0
2014-01-22 16:00:00	AAPL	Stock	19.6961	19.8039	19.6814	19.7132	11487140.0
2014-01-22 16:30:00	AAPL	Stock	19.7146	19.7361	19.6929	19.7321	239568.0
2014-01-22 17:00:00	AAPL	Stock	19.725	19.75	19.7246	19.75	560700.0
2014-01-22 17:30:00	AAPL	Stock	19.75	19.7554	19.6968	19.7382	362684.0
2014-01-22 18:00:00	AAPL	Stock	19.7375	19.75	19.7321	19.75	103572.0
2014-01-22 18:30:00	AAPL	Stock	19.75	19.7636	19.7429	19.7625	92400.0
2014-01-22 19:00:00	AAPL	Stock	19.7507	19.7511	19.7468	19.75	27720.0
2014-01-22 19:30:00	AAPL	Stock	19.7568	19.7704	19.7496	19.7554	202132.0
2014-01-22 04:00:00	MSFT	Stock	36.24	36.24	36.24	36.24	553.0
2014-01-22 06:00:00	MSFT	Stock	36.26	36.26	36.26	36.26	200.0
2014-01-22 06:30:00	MSFT	Stock	36.26	36.26	36.26	36.26	200.0
2014-01-22 07:00:00	MSFT	Stock	36.23	36.23	36.23	36.23	300.0
2014-01-22 07:30:00	MSFT	Stock	36.17	36.17	36.17	36.17	100.0
2014-01-22 08:00:00	MSFT	Stock	36.16	36.18	36.141	36.18	2867.0
2014-01-22 08:30:00	MSFT	Stock	36.19	36.28	36.19	36.28	1021.0
2014-01-22 09:00:00	MSFT	Stock	36.28	36.34	36.17	36.34	5488.0
2014-01-22 09:30:00	MSFT	Stock	36.27	36.32	35.75	36.06	3772594.0
2014-01-22 10:00:00	MSFT	Stock	36.06	36.155	35.96	36.13	1633319.0
2014-01-22 10:30:00	MSFT	Stock	36.13	36.13	35.91	35.94	1309048.0
2014-01-22 11:00:00	MSFT	Stock	35.95	36.06	35.92	36.056	898435.0
2014-01-22 11:30:00	MSFT	Stock	36.055	36.09	36.0	36.0	683329.0
2014-01-22 12:00:00	MSFT	Stock	36.002	36.07	35.985	36.035	697987.0
2014-01-22 12:30:00	MSFT	Stock	36.03	36.13	36.03	36.125	816894.0
2014-01-22 13:00:00	MSFT	Stock	36.13	36.175	36.11	36.14	871315.0
2014-01-22 13:30:00	MSFT	Stock	36.14	36.15	36.06	36.08	1026485.0
2014-01-22 14:00:00	MSFT	Stock	36.08	36.14	36.07	36.11	861614.0
2014-01-22 14:30:00	MSFT	Stock	36.12	36.12	36.05	36.06	1153115.0
2014-01-22 15:00:00	MSFT	Stock	36.06	36.085	36.06	36.075	869373.0
2014-01-22 15:30:00	MSFT	Stock	36.075	36.08	35.93	35.94	3935674.0

> showing 50 of 82,018 rows — these rows as CSV

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