PREVIEW / stock_30min / 2014-11-21

all stock 30-min files

  file:    by_date/stock_30min/2014/2014-11-21.parquet
  size:    1.7 MB
  rows:    85,118
  symbols: 3,572

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-11-21 04:00:00	AAPL	Stock	29.1525	29.25	29.1525	29.2	22120.0
2014-11-21 04:30:00	AAPL	Stock	29.2225	29.3	29.2225	29.295	40032.0
2014-11-21 05:00:00	AAPL	Stock	29.2925	29.2925	29.2625	29.2625	13676.0
2014-11-21 05:30:00	AAPL	Stock	29.27	29.3625	29.27	29.3625	23272.0
2014-11-21 06:00:00	AAPL	Stock	29.32	29.3725	29.25	29.3	32928.0
2014-11-21 06:30:00	AAPL	Stock	29.3	29.3125	29.2775	29.3025	56076.0
2014-11-21 07:00:00	AAPL	Stock	29.295	29.3125	29.27	29.3125	263236.0
2014-11-21 07:30:00	AAPL	Stock	29.3125	29.34	29.3025	29.3025	111644.0
2014-11-21 08:00:00	AAPL	Stock	29.3025	29.35	29.2625	29.2825	642344.0
2014-11-21 08:30:00	AAPL	Stock	29.2875	29.3	29.2725	29.2875	291104.0
2014-11-21 09:00:00	AAPL	Stock	29.2875	29.42	29.27	29.38	2300704.0
2014-11-21 09:30:00	AAPL	Stock	29.3775	29.3925	29.13	29.2	45943916.0
2014-11-21 10:00:00	AAPL	Stock	29.2	29.2325	29.0525	29.1525	20596536.0
2014-11-21 10:30:00	AAPL	Stock	29.15	29.2	29.05	29.095	11520208.0
2014-11-21 11:00:00	AAPL	Stock	29.0912	29.1425	29.0175	29.1275	10409968.0
2014-11-21 11:30:00	AAPL	Stock	29.1275	29.1375	29.0375	29.0692	7814668.0
2014-11-21 12:00:00	AAPL	Stock	29.0675	29.1025	29.04	29.0812	5910324.0
2014-11-21 12:30:00	AAPL	Stock	29.0812	29.1525	29.08	29.1188	6053688.0
2014-11-21 13:00:00	AAPL	Stock	29.1175	29.13	29.055	29.0575	5723216.0
2014-11-21 13:30:00	AAPL	Stock	29.055	29.1375	29.03	29.0938	7460784.0
2014-11-21 14:00:00	AAPL	Stock	29.0925	29.125	29.05	29.065	6414200.0
2014-11-21 14:30:00	AAPL	Stock	29.065	29.1225	29.02	29.1112	8981556.0
2014-11-21 15:00:00	AAPL	Stock	29.11	29.14	29.095	29.1375	8890288.0
2014-11-21 15:30:00	AAPL	Stock	29.1375	29.1625	29.0075	29.115	21527736.0
2014-11-21 16:00:00	AAPL	Stock	29.1175	29.3865	29.08	29.105	23040232.0
2014-11-21 16:30:00	AAPL	Stock	29.1175	29.1175	29.0775	29.1175	637164.0
2014-11-21 17:00:00	AAPL	Stock	29.0975	29.1	29.0875	29.09	18836.0
2014-11-21 17:30:00	AAPL	Stock	29.0875	29.1175	29.075	29.08	75732.0
2014-11-21 18:00:00	AAPL	Stock	29.0925	29.1175	29.0825	29.1175	88904.0
2014-11-21 18:30:00	AAPL	Stock	29.085	29.1175	29.0725	29.0725	1458396.0
2014-11-21 19:00:00	AAPL	Stock	29.075	29.0825	29.0675	29.0825	23976.0
2014-11-21 19:30:00	AAPL	Stock	29.0825	29.085	29.0675	29.0675	22876.0
2014-11-21 04:00:00	MSFT	Stock	48.75	48.75	48.75	48.75	300.0
2014-11-21 04:30:00	MSFT	Stock	48.65	48.8	48.65	48.8	4396.0
2014-11-21 05:30:00	MSFT	Stock	48.68	48.9	48.68	48.71	5454.0
2014-11-21 06:00:00	MSFT	Stock	48.88	48.88	48.8	48.8	300.0
2014-11-21 06:30:00	MSFT	Stock	48.8	48.82	48.72	48.75	2300.0
2014-11-21 07:00:00	MSFT	Stock	48.77	48.78	48.77	48.78	1750.0
2014-11-21 07:30:00	MSFT	Stock	48.73	48.77	48.73	48.73	3096.0
2014-11-21 08:00:00	MSFT	Stock	48.73	48.78	48.71	48.78	40998.0
2014-11-21 08:30:00	MSFT	Stock	48.79	48.86	48.76	48.86	27341.0
2014-11-21 09:00:00	MSFT	Stock	48.85	49.09	48.85	49.03	382760.0
2014-11-21 09:30:00	MSFT	Stock	49.02	49.05	48.72	48.83	8351489.0
2014-11-21 10:00:00	MSFT	Stock	48.82	48.87	48.72	48.74	2323722.0
2014-11-21 10:30:00	MSFT	Stock	48.745	48.75	48.36	48.44	2123055.0
2014-11-21 11:00:00	MSFT	Stock	48.435	48.5	48.28	48.33	1463495.0
2014-11-21 11:30:00	MSFT	Stock	48.335	48.38	48.2	48.25	1373968.0
2014-11-21 12:00:00	MSFT	Stock	48.245	48.31	48.02	48.02	2001128.0
2014-11-21 12:30:00	MSFT	Stock	48.02	48.07	47.8	47.81	2851680.0
2014-11-21 13:00:00	MSFT	Stock	47.81	47.89	47.7	47.707	2342254.0

> showing 50 of 85,118 rows — these rows as CSV

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