PREVIEW / stock_30min / 2015-01-20

all stock 30-min files

  file:    by_date/stock_30min/2015/2015-01-20.parquet
  size:    1.6 MB
  rows:    84,562
  symbols: 3,544

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
2015-01-20 04:00:00	AAPL	Stock	26.755	26.755	26.705	26.705	16564.0
2015-01-20 04:30:00	AAPL	Stock	26.7	26.7	26.67	26.67	6400.0
2015-01-20 05:00:00	AAPL	Stock	26.7	26.7	26.7	26.7	2800.0
2015-01-20 05:30:00	AAPL	Stock	26.7	26.75	26.6975	26.75	26428.0
2015-01-20 06:00:00	AAPL	Stock	26.75	26.75	26.74	26.74	9600.0
2015-01-20 06:30:00	AAPL	Stock	26.74	26.805	26.725	26.795	55200.0
2015-01-20 07:00:00	AAPL	Stock	26.8125	26.85	26.7875	26.8225	114864.0
2015-01-20 07:30:00	AAPL	Stock	26.825	26.875	26.8025	26.8675	166104.0
2015-01-20 08:00:00	AAPL	Stock	26.8675	26.8875	26.7875	26.8525	754464.0
2015-01-20 08:30:00	AAPL	Stock	26.8525	26.86	26.8125	26.815	307936.0
2015-01-20 09:00:00	AAPL	Stock	26.8025	26.9625	26.7525	26.96	945488.0
2015-01-20 09:30:00	AAPL	Stock	26.965	27.0	26.6625	26.8438	33985684.0
2015-01-20 10:00:00	AAPL	Stock	26.8362	26.9	26.715	26.805	14797644.0
2015-01-20 10:30:00	AAPL	Stock	26.805	26.8225	26.655	26.6725	11560072.0
2015-01-20 11:00:00	AAPL	Stock	26.6725	26.845	26.625	26.79	10956212.0
2015-01-20 11:30:00	AAPL	Stock	26.785	26.7975	26.685	26.7662	7610184.0
2015-01-20 12:00:00	AAPL	Stock	26.765	26.8525	26.7325	26.8125	5865452.0
2015-01-20 12:30:00	AAPL	Stock	26.8125	26.8968	26.765	26.8825	5842124.0
2015-01-20 13:00:00	AAPL	Stock	26.8825	26.9325	26.805	26.9165	7838408.0
2015-01-20 13:30:00	AAPL	Stock	26.9175	26.935	26.8625	26.92	5425568.0
2015-01-20 14:00:00	AAPL	Stock	26.92	27.0125	26.9075	26.9612	10928756.0
2015-01-20 14:30:00	AAPL	Stock	26.9625	27.125	26.9625	27.1225	11852124.0
2015-01-20 15:00:00	AAPL	Stock	27.1225	27.1725	27.105	27.1325	10228976.0
2015-01-20 15:30:00	AAPL	Stock	27.1325	27.195	27.0725	27.1775	18491864.0
2015-01-20 16:00:00	AAPL	Stock	27.18	27.2775	26.762	27.2725	19245744.0
2015-01-20 16:30:00	AAPL	Stock	27.2725	27.275	26.894	27.26	736904.0
2015-01-20 17:00:00	AAPL	Stock	27.2625	27.3	27.18	27.2875	2209024.0
2015-01-20 17:30:00	AAPL	Stock	27.2875	27.3	27.2825	27.3	119384.0
2015-01-20 18:00:00	AAPL	Stock	27.3	27.3075	27.29	27.3025	76676.0
2015-01-20 18:30:00	AAPL	Stock	27.3	27.31	27.2875	27.305	65332.0
2015-01-20 19:00:00	AAPL	Stock	27.3	27.3	27.18	27.2925	227160.0
2015-01-20 19:30:00	AAPL	Stock	27.285	27.2975	27.2625	27.295	84348.0
2015-01-20 04:00:00	MSFT	Stock	46.3	46.3	46.3	46.3	100.0
2015-01-20 05:00:00	MSFT	Stock	46.3	46.3	46.3	46.3	800.0
2015-01-20 05:30:00	MSFT	Stock	46.3	46.31	46.3	46.31	300.0
2015-01-20 07:00:00	MSFT	Stock	46.43	46.47	46.39	46.47	3730.0
2015-01-20 07:30:00	MSFT	Stock	46.42	46.42	46.42	46.42	233.0
2015-01-20 08:00:00	MSFT	Stock	46.45	46.47	46.42	46.43	2140.0
2015-01-20 08:30:00	MSFT	Stock	46.43	46.43	46.3	46.3	15792.0
2015-01-20 09:00:00	MSFT	Stock	46.3	46.39	46.29	46.3	7853.0
2015-01-20 09:30:00	MSFT	Stock	46.3	46.42	45.81	45.95	3601319.0
2015-01-20 10:00:00	MSFT	Stock	45.945	46.065	45.77	45.91	1910762.0
2015-01-20 10:30:00	MSFT	Stock	45.92	45.96	45.57	45.755	1965972.0
2015-01-20 11:00:00	MSFT	Stock	45.75	45.885	45.65	45.76	1955928.0
2015-01-20 11:30:00	MSFT	Stock	45.75	45.84	45.64	45.75	1461870.0
2015-01-20 12:00:00	MSFT	Stock	45.75	45.87	45.71	45.83	821810.0
2015-01-20 12:30:00	MSFT	Stock	45.84	46.045	45.79	46.01	1091772.0
2015-01-20 13:00:00	MSFT	Stock	46.0	46.23	45.88	46.17	1569787.0
2015-01-20 13:30:00	MSFT	Stock	46.17	46.249	46.145	46.19	1147580.0
2015-01-20 14:00:00	MSFT	Stock	46.19	46.33	46.14	46.209	1781092.0

> showing 50 of 84,562 rows — these rows as CSV

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