PREVIEW / stock_30min / 2013-11-15

all stock 30-min files

  file:    by_date/stock_30min/2013/2013-11-15.parquet
  size:    1.6 MB
  rows:    81,062
  symbols: 3,545

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-11-15 04:00:00	AAPL	Stock	18.8571	18.8932	18.8571	18.8932	19600.0
2013-11-15 05:00:00	AAPL	Stock	18.8589	18.8589	18.8457	18.8457	11200.0
2013-11-15 05:30:00	AAPL	Stock	18.8689	18.8807	18.8611	18.8611	8400.0
2013-11-15 06:00:00	AAPL	Stock	18.8929	18.8929	18.8929	18.8929	5600.0
2013-11-15 06:30:00	AAPL	Stock	18.8929	18.8929	18.8929	18.8929	24864.0
2013-11-15 07:00:00	AAPL	Stock	18.8929	18.9054	18.8925	18.9036	156296.0
2013-11-15 07:30:00	AAPL	Stock	18.9036	18.9121	18.8571	18.8571	376824.0
2013-11-15 08:00:00	AAPL	Stock	18.875	18.9036	18.8214	18.8696	761796.0
2013-11-15 08:30:00	AAPL	Stock	18.8693	18.8696	18.8354	18.8482	490364.0
2013-11-15 09:00:00	AAPL	Stock	18.8482	18.8564	18.7896	18.8071	824544.0
2013-11-15 09:30:00	AAPL	Stock	18.8071	18.8626	18.7739	18.8232	50373288.0
2013-11-15 10:00:00	AAPL	Stock	18.8225	18.8961	18.8154	18.8486	28188104.0
2013-11-15 10:30:00	AAPL	Stock	18.8468	18.8518	18.7679	18.7818	24906700.0
2013-11-15 11:00:00	AAPL	Stock	18.783	18.8168	18.7561	18.7696	13966092.0
2013-11-15 11:30:00	AAPL	Stock	18.7654	18.7714	18.7454	18.7529	16442440.0
2013-11-15 12:00:00	AAPL	Stock	18.7567	18.7907	18.7468	18.7645	9609236.0
2013-11-15 12:30:00	AAPL	Stock	18.7679	18.7796	18.7529	18.76	5178768.0
2013-11-15 13:00:00	AAPL	Stock	18.7625	18.7961	18.7557	18.7821	7358848.0
2013-11-15 13:30:00	AAPL	Stock	18.7843	18.7886	18.7657	18.7714	5923764.0
2013-11-15 14:00:00	AAPL	Stock	18.7705	18.7711	18.7536	18.7589	7643692.0
2013-11-15 14:30:00	AAPL	Stock	18.7607	18.7682	18.7346	18.74	30083396.0
2013-11-15 15:00:00	AAPL	Stock	18.7393	18.7643	18.7318	18.7525	14704480.0
2013-11-15 15:30:00	AAPL	Stock	18.7528	18.7604	18.7318	18.7479	34731480.0
2013-11-15 16:00:00	AAPL	Stock	18.7529	18.7809	18.7457	18.7493	50458408.0
2013-11-15 16:30:00	AAPL	Stock	18.7529	18.8186	18.7486	18.7493	210672.0
2013-11-15 17:00:00	AAPL	Stock	18.7504	18.7521	18.7486	18.7511	71540.0
2013-11-15 17:30:00	AAPL	Stock	18.75	18.75	18.7486	18.7486	56504.0
2013-11-15 18:00:00	AAPL	Stock	18.7496	18.7529	18.7486	18.7489	96964.0
2013-11-15 18:30:00	AAPL	Stock	18.7529	18.7529	18.7464	18.7464	256284.0
2013-11-15 19:00:00	AAPL	Stock	18.7464	18.7482	18.7464	18.7482	66724.0
2013-11-15 19:30:00	AAPL	Stock	18.7482	18.7482	18.7411	18.7454	82740.0
2013-11-15 04:30:00	MSFT	Stock	38.05	38.05	38.05	38.05	199.0
2013-11-15 06:00:00	MSFT	Stock	38.0	38.04	38.0	38.04	700.0
2013-11-15 06:30:00	MSFT	Stock	38.12	38.12	38.12	38.12	810.0
2013-11-15 07:00:00	MSFT	Stock	38.11	38.11	38.01	38.01	200.0
2013-11-15 08:00:00	MSFT	Stock	38.11	38.11	38.03	38.09	5348.0
2013-11-15 08:30:00	MSFT	Stock	38.1	38.1	38.06	38.06	7671.0
2013-11-15 09:00:00	MSFT	Stock	38.07	38.07	37.87	37.96	46560.0
2013-11-15 09:30:00	MSFT	Stock	37.95	38.02	37.91	37.98	8531726.0
2013-11-15 10:00:00	MSFT	Stock	37.976	38.0	37.95	37.985	2728950.0
2013-11-15 10:30:00	MSFT	Stock	37.99	37.99	37.87	37.92	3179193.0
2013-11-15 11:00:00	MSFT	Stock	37.92	37.93	37.88	37.91	2012920.0
2013-11-15 11:30:00	MSFT	Stock	37.91	37.93	37.8	37.82	1546947.0
2013-11-15 12:00:00	MSFT	Stock	37.83	37.84	37.75	37.786	2855519.0
2013-11-15 12:30:00	MSFT	Stock	37.79	37.8	37.72	37.73	2352531.0
2013-11-15 13:00:00	MSFT	Stock	37.73	37.81	37.72	37.78	2581499.0
2013-11-15 13:30:00	MSFT	Stock	37.78	37.83	37.77	37.8	2631442.0
2013-11-15 14:00:00	MSFT	Stock	37.81	37.83	37.77	37.786	3159789.0
2013-11-15 14:30:00	MSFT	Stock	37.79	37.81	37.785	37.8	1669060.0
2013-11-15 15:00:00	MSFT	Stock	37.791	37.84	37.79	37.825	4172466.0

> showing 50 of 81,062 rows — these rows as CSV

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